SQL Problems / Errors..
It gives much errors..
Could someone please fix it? :)
Code:
new trigger_hurt[33], func_door[33], func_door_rotating[33], func_rotating[33], func_train[33], env_beam[33], env_laser[33], func_breakable[33];
new StandAlone[33], Enemies[33], HSkills[33], HSknifekills[33], RoadKing[33], Buttons[33], Tmp[33], Connects[33], Button[33], Transfers[33], Hero[33];
PHP Code:
public plugin_sql()
{
new host[64], user[64], pass[64], db[64];
get_pcvar_string(pcvar_host, host, 63);
get_pcvar_string(pcvar_user, user, 63);
get_pcvar_string(pcvar_pass, pass, 63);
get_pcvar_string(pcvar_db, db, 63);
g_SqlTuple = SQL_MakeDbTuple(host, user, pass, db);
new ErrorCode;
SqlConnection = SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511);
if(!SqlConnection)
{
server_print("SQL: Could not connect to SQL database.!");
log_amx("SQL: Could not connect to SQL database.");
return pause("a");
}
new createinto[1001]
formatex(createinto, 9000, "CREATE TABLE IF NOT EXISTS `Deathrun_achievements` (`id` int(11) NOT NULL auto_increment, `StandAlone` varchar(64) NOT NULL, `Enemies` varchar(64) NOT NULL, `HSkills` int(11) NOT NULL, `HSknifekills` int(11) NOT NULL, `RoadKing` int(11) NOT NULL, `Button` varchar(64) NOT NULL, `Transfers` varchar(64) NOT NULL, `Hero` int(11) NOT NULL, `env_beam` int(11) NOT NULL, `env_laser` int(11) NOT NULL, `func_breakable` varchar(64) NOT NULL, `trigger_hurt` int(11) NOT NULL, `func_door` int(11) NOT NULL, `func_door_rotating` int(11) NOT NULL, `func_train` varchar(64) NOT NULL, `name` varchar(3) NOT NULL, `country` int(11) NOT NULL, `online` int(11) NOT NULL, `authid` int(11) NOT NULL, PRIMARY KEY(`id`))"); \
SQL_ThreadQuery(g_SqlTuple,"QueryHandle", createinto);
return PLUGIN_CONTINUE;
}
public QueryHandle(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
if( iFailState != TQUERY_SUCCESS )
{
log_amx("SQL: SQL Error #%d - %s", iErrnum, szError);
return server_print("SQL: Warring the Stats can not be Saved");
}
//server_print("Server Sending Info to SQL Server");
return PLUGIN_CONTINUE;
}
// Save & Load
public Deathrun_Load(id){
new szAuthId[64]/*, data[129]*/;
get_user_authid(id, szAuthId, 63);
new Handle:statshandle;
statshandle = SQL_PrepareQuery(SqlConnection, "SELECT `StandAlone`,`Enemies`,`HSkills`,`HSknifekills`,`RoadKing`,`Button`,`Transfers`,`Hero`,`env_beam`,`env_laser`,`func_breakable`,`trigger_hurt`,`func_door`,`func_door_rotating`,`func_train`,`name`,`country`,`online` FROM `Deathrun_achievements` WHERE authid='%s'", szAuthId[id]);
if( SQL_Execute(statshandle) )
{
if(SQL_MoreResults(statshandle))
{
new qcolStandAlone = SQL_FieldNameToNum(statshandle, "StandAlone");
new qcolEnemies = SQL_FieldNameToNum(statshandle, "Enemies");
new qcolHSkills = SQL_FieldNameToNum(statshandle, "HSkills");
new qcolHSknifekills = SQL_FieldNameToNum(statshandle, "HSknifekills");
new qcolRoadKing = SQL_FieldNameToNum(statshandle, "RoadKing");
new qcolButton = SQL_FieldNameToNum(statshandle, "Button");
new qcolTransfers = SQL_FieldNameToNum(statshandle, "Transfers");
new qcolHero = SQL_FieldNameToNum(statshandle, "Hero");
new qcolenv_beam = SQL_FieldNameToNum(statshandle, "env_beam");
new qcolenv_laser = SQL_FieldNameToNum(statshandle, "env_laser");
new qcolfunc_breakable = SQL_FieldNameToNum(statshandle, "func_breakable");
new qcoltrigger_hurt = SQL_FieldNameToNum(statshandle, "trigger_hurt");
new qcolfunc_door = SQL_FieldNameToNum(statshandle, "func_door");
new qcolfunc_door_rotating = SQL_FieldNameToNum(statshandle, "func_door_rotating");
new qcolfunc_train = SQL_FieldNameToNum(statshandle, "func_train");
new qcolonline = SQL_FieldNameToNum(statshandle, "online");
new StandAlone[12],Enemies[12],HSkills[12],HSknifekills[12],RoadKing[12],Button[12],Transfers[12],Hero[12],env_beam[12],env_laser[12],func_breakable[12],trigger_hurt[12],func_door[12],func_door_rotating[12],func_train[12],online[12]
SQL_ReadResult(statshandle, qcolStandAlone, StandAlone,11);
SQL_ReadResult(statshandle, qcolEnemies, Enemies,11);
SQL_ReadResult(statshandle, qcolHSkills, HSkills,11);
SQL_ReadResult(statshandle, qcolHSknifekills, HSknifekills,11);
SQL_ReadResult(statshandle, qcolonline, online,11);
SQL_ReadResult(statshandle, qcolRoadKing, RoadKing,11);
SQL_ReadResult(statshandle, qcolButton, Button,11);
SQL_ReadResult(statshandle, qcolTransfers, Transfers,11);
SQL_ReadResult(statshandle, qcolHero, Hero,11);
SQL_ReadResult(statshandle, qcolenv_beam, env_beam,11);
SQL_ReadResult(statshandle, qcolenv_laser, env_laser,11);
SQL_ReadResult(statshandle, qcolfunc_breakable, func_breakable,11);
SQL_ReadResult(statshandle, qcoltrigger_hurt, trigger_hurt,11);
SQL_ReadResult(statshandle, qcolfunc_door, func_door,11);
SQL_ReadResult(statshandle, qcolfunc_door_rotating, func_door_rotating,11);
SQL_ReadResult(statshandle, qcolfunc_train, func_train,11);
TotalPlayedTime[id]=str_to_num( online );
StandAlone[id]=str_to_num ( StandAlone );
Enemies[id]=str_to_num ( Enemies );
HSkills[id]=str_to_num ( HSkills );
HSknifekills[id]=str_to_num( HSknifekills );
RoadKing[id]=str_to_num ( RoadKing );
Button[id]=str_to_num ( Button );
Transfers[id]=str_to_num ( Transfers );
Hero[id]=str_to_num ( Hero );
env_beam[id]=str_to_num ( env_beam );
env_laser[id]=str_to_num( env_laser );
func_breakable[id]=str_to_num ( func_breakable );
trigger_hurt[id]=str_to_num ( trigger_hurt );
func_door[id]=str_to_num ( func_door );
func_door_rotating[id]=str_to_num ( func_door_rotating );
func_train[id]=str_to_num ( func_train );
}
}
SQL_FreeHandle(statshandle)
}
public client_disconnect(id)
if(get_pcvar_num(achievements_status))
Deathrun_Save(id);
public Deathrun_Save(id){
get_user_authid(id, szAuthId[id], 63);
get_user_info(id,"name",szUserName[id],63);
get_user_ip (id, szIP[id], 15)
geoip_code2( szIP[id], szCountery[id]);
strtolower(szCountery[id]);
TotalPlayedTime[id] += get_user_time(id);
new createinto[1001];
new cData[192];
cData[0]=id;
formatex(createinto, sizeof createinto - 1, "SELECT `StandAlone`,`Enemies`,`HSkills`,`HSknifekills`,`RoadKing`,`Button`,`Transfers`,`Hero`,`env_beam`,`env_laser`,`func_breakable`,`trigger_hurt`,`func_door`,`func_door_rotating`,`func_train`,`name`,`country`,`online` FROM `Deathrun_achievements` WHERE authid='%s'", szAuthId[id]);
SQL_ThreadQuery(g_SqlTuple, "Set_QueryHandler", createinto,cData,1);
}
public Set_QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime)
{
new id=cData[0];
if( iFailState != TQUERY_SUCCESS )
{
log_amx("SQL: SQL Error #%d - %s", iErrnum, szError);
return server_print("Warring the Tops can not be Saved");
}
//server_print("Server Geting Info of SQL Server");
new createinto[1001];
replace_all(szUserName[id], 63, "\", "")
replace_all(szUserName[id], 63, "`", "\`")
replace_all(szUserName[id], 63, "'", "\'")
if( SQL_NumResults(hQuery) == 0 )
{
formatex( createinto, sizeof createinto - 1, "INSERT INTO `Deathrun_achievements` VALUES('', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%i', '%s', '%s', '%s')",StandAlone[id],Enemies[id],HSkills[id],HSknifekills[id],TotalPlayedTime[id],RoadKing[id],Button[id],Transfers[id],Hero[id],env_beam[id],env_laser[id],func_breakable[id],trigger_hurt[id],func_door[id],func_door_rotating[id],func_train[id],szUserName[id],szCountery[id],szAuthId[id])
SQL_ThreadQuery(g_SqlTuple, "QueryHandle", createinto)
}
else
{
formatex(createinto, sizeof createinto - 1, "UPDATE `Deathrun_achievements` SET `StandAlone`='%i', `Enemies`='%i', `HSkills`='%i', `HSknifekills`='%i', `RoadKing`='%i', `Button`='%i', `Transfers`='%i', `Hero`='%i', `env_beam`='%i', `env_laser`='%i', `func_breakable`='%i', `trigger_hurt`='%i', `func_door`='%i', `func_door_rotating`='%i',szUserName[id],szCountery[id],szAuthId[id]",StandAlone[id],Enemies[id],HSkills[id],HSknifekills[id],TotalPlayedTime[id],RoadKing[id],Button[id],Transfers[id],Hero[id],env_beam[id],env_laser[id],func_breakable[id],trigger_hurt[id],func_door[id],func_door_rotating[id],func_train[id],szUserName[id],szCountery[id],szAuthId[id])
SQL_ThreadQuery(g_SqlTuple, "QueryHandle", createinto)
}
return PLUGIN_CONTINUE;
}
|