27.11.2011, 01:45
Hello.
I've recently moved to a VPS Debian 6. I installed the proper Blueg's plugin for a debian server.
When i am using a command which checks and echos a player's ban details, the server crashes. This did not happen with volt-host and the other plugin volt-host provided me with. ( i did not edit the script)
The thing that crashes the server is mysql_get_field (it crashes the server)
Interesting thing is that the field "Banner" doesn't crash the server but all others do.
I've recently moved to a VPS Debian 6. I installed the proper Blueg's plugin for a debian server.
When i am using a command which checks and echos a player's ban details, the server crashes. This did not happen with volt-host and the other plugin volt-host provided me with. ( i did not edit the script)
The thing that crashes the server is mysql_get_field (it crashes the server)
Interesting thing is that the field "Banner" doesn't crash the server but all others do.
Code:
IRCCMD:banned(botid, channel[], user[], host[], params[]) { new name[100],msg[300]; if(sscanf(params, "s", name)) return 0; format(Query, sizeof(Query), "SELECT `banner`,`reason`,`banlength`,`bandate` FROM `bans` WHERE `name` = '%s' LIMIT 1 ", name); mysql_query(Query); mysql_store_result(); if (mysql_num_rows() == 0) return IRC_GroupSay(gGroupID,IRC_ADMIN,"1 Sorry, This user is not found in bans list."); new banner[30],reason[50],bandate[30],index, line[50],buffer[149],banl[30],result[200]; mysql_retrieve_row(); <---- DOESNT CRASH IT mysql_get_field("banner", banner); <---- DOESNT CRASH IT mysql_get_field("reason", reason); <---- crashes it mysql_get_field("banlength", banl); <----- Crashes it mysql_get_field("bandate", bandate); <--- crashes it /// REST OF THE CODE NOW SHOWN (doesnt crash it anyway) return 1; }