public SaveXP_SQL(id)
{
new PlayerName[32], str_query[512]
new Data[1]
new id = Data[0]
if(!is_user_steam(id)){
get_user_name(id,PlayerName,charsmax(PlayerName));
}
else
{
get_user_authid(id,PlayerName,charsmax(PlayerName));
}
replace_all(PlayerName,31,"^"^"","6")
replace_all(PlayerName,31,"*","8")
replace_all(PlayerName,31,":","0")
replace_all(PlayerName,31,"-","4")
replace_all(PlayerName,31,"=","5")
replace_all(PlayerName,31,">","7")
replace_all(PlayerName,31,"<","1")
replace_all(PlayerName,31,"?","3")
replace_all(PlayerName,31,"'","2")
format(str_query, sizeof str_query-1, "INSERT INTO fbh_xp VALUES(%s, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d);", PlayerName, PlayerXP[id], PlayerLevel[id], SkillPoints[id], PtkGraw[id], PtkSpeed[id], PtkFuria[id], PtkFizyk[id], PtkCzar[id], PtkNc[id], marzenia[id], gratz[id], lpm[id], sprawdz_przejsca[id], lpmt_os[id], sprawdz_level[id], sprawdz_graw[id], sprawdz_speed[id], lpmtOS[id], os_scout[id], os_scout_s[id]);
SQL_ThreadQuery(mysql_tuple,"SaveHandler",str_query)
/*formatex(str_query,511,"UPDATE `fbh_xp` SET `xp` = '%i',`level` = '%i',`skillptk` = '%i', WHERE `fbh_xp`.`authid` = '%s';", PlayerXP[id], PlayerLevel[id], SkillPoints[id], PlayerName)
formatex(str_query,511,"UPDATE `fbh_skill` SET `ptkgraw` = '%i',`ptkspeed` = '%i',`ptksfuria` = '%i',`ptkfizyk` = '%i',`ptkczar` = '%i',`ptknc` = '%i', WHERE `fbh_xp`.`authid` = '%s';", PtkGraw[id], PtkSpeed[id], PtkFuria[id], PtkFizyk[id], PtkCzar[id], PtkNc[id], PlayerName)
SQL_ThreadQuery(mysql_tuple,"SaveHandler",str_query)
formatex(str_query,511,"UPDATE `fbh_other` SET `marzenia` = '%i',`gratz` = '%i',`lpm` = '%i',`sprawdz_przejscia` = '%i',`lpmt_os` = '%i', WHERE `fbh_xp`.`authid` = '%s';", marzenia[id], gratz[id], lpm[id], sprawdz_przejsca[id], lpmt_os[id], PlayerName)
SQL_ThreadQuery(mysql_tuple,"SaveHandler",str_query)
formatex(str_query, 511,"UPDATE `fbh_os` SET `sprawdz_level` = '%i',`sprawdz_graw` = '%i',`sprawdz_speed` = '%i',`lpmtos` = '%i',`os_scout` = '%i',`os_scout_s` = '%i', WHERE `fbh_xp`.`authid` = '%s';", sprawdz_level[id], sprawdz_graw[id], sprawdz_speed[id], lpmtOS[id], os_scout[id], os_scout_s[id], PlayerName)
SQL_ThreadQuery(mysql_tuple,"SaveHandler",str_query)*/
}
public SaveHandler(FailState, Handle:Query, Errorcode, Error[], Data[], DataSize)
{
//new Data[1]
//new id = Data[0]
if(Errorcode)
log_amx("FASTBH SQL: Blad w zapytaniu: %s [SaveXP]", Error)
if(FailState == TQUERY_CONNECT_FAILED)
{
log_amx("FASTBH SQL: Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(FailState == TQUERY_QUERY_FAILED)
{
log_amx("FASTBH SQL: Zapytanie anulowane [SaveXP]")
return PLUGIN_CONTINUE
}
return PLUGIN_CONTINUE
}
public LoadXP_SQL(id)
{
new PlayerName[32], str_query[512]
new data[1]
data[0] = id
if(!is_user_steam(id)){
get_user_name(id,PlayerName,charsmax(PlayerName));
}
else
{
get_user_authid(id,PlayerName,charsmax(PlayerName));
}
replace_all(PlayerName,31,"^"^"","6")
replace_all(PlayerName,31,"*","8")
replace_all(PlayerName,31,":","0")
replace_all(PlayerName,31,"-","4")
replace_all(PlayerName,31,"=","5")
replace_all(PlayerName,31,">","7")
replace_all(PlayerName,31,"<","1")
replace_all(PlayerName,31,"?","3")
replace_all(PlayerName,31,"'","2")
formatex(str_query,511,"SELECT * FROM `fbh_xp` WHERE (`fbh_xp`.`authid` = '%s')", PlayerName)
SQL_ThreadQuery(mysql_tuple,"CheckHandler",str_query, data,1)
/*formatex(str_query,511,"SELECT * FROM `fbh_skill` WHERE (`fbh_skill`.`authid` = '%s')", PlayerName)
SQL_ThreadQuery(mysql_tuple,"CheckHandler",str_query, data,1)
formatex(str_query,511,"SELECT * FROM `fbh_other` WHERE (`fbh_other`.`authid` = '%s')", PlayerName)
SQL_ThreadQuery(mysql_tuple,"CheckHandler",str_query, data,1)
formatex(str_query,511,"SELECT * FROM `fbh_os` WHERE (`fbh_os`.`authid` = '%s')", PlayerName)
SQL_ThreadQuery(mysql_tuple,"CheckHandler",str_query, data,1)*/
}
public CheckHandler(failstate,Handle:Query,error[],errcode,data[],datasize)
{
new data[1]
new id = data[0]
if(errcode)
log_amx("Blad w zapytaniu: %s", error)
if(failstate == TQUERY_CONNECT_FAILED)
{
log_amx("Nie mozna podlaczyc sie do bazy danych.")
return PLUGIN_CONTINUE
}
else if(failstate == TQUERY_QUERY_FAILED)
{
log_amx("Zapytanie anulowane")
return PLUGIN_CONTINUE
}
if(SQL_MoreResults(Query))
{
PlayerXP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "xp"))
PlayerLevel[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "level"))
SkillPoints[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "skillptk"))
PtkGraw[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptkgraw"))
PtkSpeed[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptkspeed"))
PtkFuria[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptkfuria"))
PtkFizyk[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptkfizyk"))
PtkCzar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptkczar"))
PtkNc[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ptknc"))
marzenia[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "marzeina"))
gratz[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "gratz"))
lpm[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lpm"))
sprawdz_przejsca[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "sprawdz_przejsca"))
lpmt_os[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lpmt_os"))
sprawdz_level[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "sprawdz_level"))
sprawdz_graw[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "sprawdz_graw"))
sprawdz_speed[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "sprawdz_speed"))
lpmtOS[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lpmtos"))
os_scout[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "os_scout"))
os_scout_s[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "os_scout_s"))
}
return PLUGIN_CONTINUE
}