Code:
L 01/04/2016 - 10:43:34: Start of error session.
L 01/04/2016 - 10:43:34: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20160104.log")
L 01/04/2016 - 10:43:34: [MySQL] Invalid database handle: 0
L 01/04/2016 - 10:43:34: [AMXX] Run time error 10 (plugin "ncodmodmysql.amxx") (native "SQL_PrepareQuery") - debug
PHP Code:
public Load(id)
{
new Name[32];
get_user_name(id, Name, 31);
new error[128], errno;
new Handle:info = SQL_MakeStdTuple();
new Handle:sql = SQL_Connect(info, errno, error, 127);
new Handle:query = SQL_PrepareQuery(sql, "SELECT * FROM `oles_szam` WHERE `username` = '%s'", Name);
if (!SQL_Execute(query))
server_print("[NiCE skin] Hiba tortent a lekeres soran. #1");
else if (!SQL_NumResults(query)) {
Kills[id] = 0;
Rang[id] = 0;
m4a1_oles[id] = 0;
ak47_oles[id] = 0;
awp_oles[id] = 0;
kes_oles[id] = 0;
} else {
new qcol_oles = SQL_FieldNameToNum(query, "oles");
new qcol_rang = SQL_FieldNameToNum(query, "rang");
new qcol_m4a1 = SQL_FieldNameToNum(query, "m4a1");
new qcol_ak47 = SQL_FieldNameToNum(query, "ak47");
new qcol_awp = SQL_FieldNameToNum(query, "awp") ;
new qcol_kes = SQL_FieldNameToNum(query, "kes");
Kills[id]= SQL_ReadResult(query, qcol_oles);
Rang[id]= SQL_ReadResult(query, qcol_rang);
m4a1_oles[id]= SQL_ReadResult(query, qcol_m4a1);
ak47_oles[id]= SQL_ReadResult(query, qcol_ak47);
awp_oles[id] = SQL_ReadResult(query, qcol_awp);
kes_oles[id] = SQL_ReadResult(query, qcol_kes);
SQL_FreeHandle(query);
SQL_FreeHandle(sql);
SQL_FreeHandle(info);
}
return PLUGIN_CONTINUE;
}
public Save(id)
{
new Name[32];
get_user_name(id, Name, 31);
new error[128], errno;
new Handle:info = SQL_MakeStdTuple();
new Handle:sql = SQL_Connect(info, errno, error, 127);
new Handle:query = SQL_PrepareQuery(sql, "INSERT INTO `oles_szam` (`username`, `oles`, `rang`, `m4a1`, `ak47`, `awp`, `kes`) VALUES ('%s',%d,%d,%d,%d,%d,%d) ON DUPLICATE KEY UPDATE `oles`=VALUES(`oles`), `rang`=VALUES(`rang`), `m4a1`=VALUES(`m4a1`), `ak47`=VALUES(`ak47`), `awp`=VALUES(`awp`), `kes`=VALUES(`kes`)", sqlesc(Name),Kills[id],Rang[id],m4a1_oles[id],ak47_oles[id],awp_oles[id],kes_oles[id]);
if (!SQL_Execute(query))
server_print("[NiCE skin] Hiba tortent a lekeres soran. #2");
return PLUGIN_CONTINUE;
}
#define SECURE_NAME_LEN 31 * 2 + 1
sqlesc(const name[])
{
new secureName[SECURE_NAME_LEN];
copy(secureName, charsmax(secureName), name);
replace_all(secureName, charsmax(secureName), "\", "\\");
replace_all(secureName, charsmax(secureName), "`", "\`");
replace_all(secureName, charsmax(secureName), "'", "\'");
return secureName;
}
Hello, guys!
can you tell me that, why is my server shutting down about every 16th hour?
I get this error from time to time, and i dont know what the problem is...