|
Member
|

12-14-2011
, 11:11
MySQL helps
|
#1
|
Hello all
Help with errors please...
PHP Code:
L 12/13/2011 - 19:48:33: [MySQL] Invalid info tuple handle: 0 L 12/13/2011 - 19:48:33: [AMXX] Displaying debug trace (plugin "zp50_rewards_ammopacks.amxx") L 12/13/2011 - 19:48:33: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery") L 12/13/2011 - 19:48:33: [AMXX] [0] zp50_rewards_ammopacks.sma::Load_MySql (line 188) L 12/13/2011 - 19:48:33: [AMXX] [1] zp50_rewards_ammopacks.sma::client_connect (line 255)
Code create:
PHP Code:
public MySql_Init() { g_SqlTuple = SQL_MakeDbTuple(Host,User,Pass,Db) new ErrorCode,Handle:SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,charsmax(g_Error)) if(SqlConnection == Empty_Handle) set_fail_state(g_Error) new Handle:Queries Queries = SQL_PrepareQuery(SqlConnection,"CREATE TABLE IF NOT EXISTS zl_stats (Nick varchar(32),AP INT(11),Level INT(11),Damage INT(11),DamageMAX INT(11))")
if(!SQL_Execute(Queries)) { // if there were any problems SQL_QueryError(Queries,g_Error,charsmax(g_Error)) set_fail_state(g_Error) } // close the handle SQL_FreeHandle(Queries) // you free everything with SQL_FreeHandle SQL_FreeHandle(SqlConnection) }
Code register:
PHP Code:
public register_client(FailState,Handle:Query,Error[],Errcode,Data[], size, Float:queuetime) { if(FailState == TQUERY_CONNECT_FAILED) { log_amx("Load - Could not connect to SQL database. [%d] %s", Errcode, Error) } else if(FailState == TQUERY_QUERY_FAILED) { log_amx("Load Query failed. [%d] %s", Errcode, Error) } new id id = Data[0] if(!is_user_connected(id)) return PLUGIN_HANDLED if(SQL_NumResults(Query) < 1) { //.if there are no results found get_user_name(id,name,31) new szTemp[512] APStart = zp_ammopacks_get(id) // now we will insturt the values into our table. formatex(szTemp, 350, "INSERT INTO `zl_stats` \ (`Nick`, `AP`, `Level`, `Damage`, `DamageMAX`) \ values ('%s', '%d', '%d', '%d', '%d')", //values (^"%s^", ^"%d^", ^"%d^", ^"%d^", ^"%d^")", name, APStart, Level[id], g_DamageEXP[id], MaxEXP[id]) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) } else if(SQL_MoreResults(Query)) { //zp_ammopacks_get(id) APS = SQL_ReadResult(Handle:Query, SQL_FieldNameToNum(Query, "AP")); Level[id] = SQL_ReadResult(Handle:Query, 1) g_DamageEXP[id] = SQL_ReadResult(Handle:Query, 2) MaxEXP[id] = SQL_ReadResult(Handle:Query, 3) } return PLUGIN_HANDLED }
Code load:
PHP Code:
public Load_MySql(id) { new szTemp[512] new name[33] get_user_name(id,name,31) new Data[1] Data[0] = id formatex(szTemp, 180, "SELECT \ `AP` , `Level` , `Damage` , `DamageMAX` \ FROM `zl_stats` WHERE `Nick` = '%s'", name) SQL_ThreadQuery(g_SqlTuple,"register_client",szTemp,Data,1) }
Code save:
PHP Code:
public Save_MySql(id) { new szTemp[512] get_user_name(id,name,31) APStart = zp_ammopacks_get(id) // Here we will update the user hes information in the database where the steamid matches. format(szTemp,charsmax(szTemp),"UPDATE `zl_stats` \ SET `AP` = '%d', `Level` = '%d', `Damage` = '%d', `DamageMAX` = '%d' \ WHERE `zl_stats`.`Nick` = '%s';", zp_ammopacks_get(id), Level[id], g_DamageEXP[id], MaxEXP[id], name) SQL_ThreadQuery(g_SqlTuple,"IgnoreHandle",szTemp) }
Help please, the floor of the week to solve a problem I can not: (
|
|