AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQL Problems / Errors.. (https://forums.alliedmods.net/showthread.php?t=126369)

Xalus 05-08-2010 17:02

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_hosthost63);
    
get_pcvar_string(pcvar_useruser63);
    
get_pcvar_string(pcvar_passpass63);
    
get_pcvar_string(pcvar_dbdb63);
    
    
g_SqlTuple SQL_MakeDbTuple(hostuserpassdb);
    
    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(createinto9000"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(iFailStateHandle:hQueryszError[], iErrnumcData[], iSizeFloat:fQueueTime)
{
    if( 
iFailState != TQUERY_SUCCESS )
    {
        
log_amx("SQL: SQL Error #%d - %s"iErrnumszError);
        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(idszAuthId63);
    
    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(statshandleqcolStandAloneStandAlone,11);
            
SQL_ReadResult(statshandleqcolEnemiesEnemies,11);
            
SQL_ReadResult(statshandleqcolHSkillsHSkills,11);
            
SQL_ReadResult(statshandleqcolHSknifekillsHSknifekills,11);
            
SQL_ReadResult(statshandleqcolonlineonline,11);
            
SQL_ReadResult(statshandleqcolRoadKingRoadKing,11);
            
SQL_ReadResult(statshandleqcolButtonButton,11);
            
SQL_ReadResult(statshandleqcolTransfersTransfers,11);
            
SQL_ReadResult(statshandleqcolHeroHero,11);
            
SQL_ReadResult(statshandleqcolenv_beamenv_beam,11);
            
SQL_ReadResult(statshandleqcolenv_laserenv_laser,11);
            
SQL_ReadResult(statshandleqcolfunc_breakablefunc_breakable,11);
            
SQL_ReadResult(statshandleqcoltrigger_hurttrigger_hurt,11);
            
SQL_ReadResult(statshandleqcolfunc_doorfunc_door,11);
            
SQL_ReadResult(statshandleqcolfunc_door_rotatingfunc_door_rotating,11);
            
SQL_ReadResult(statshandleqcolfunc_trainfunc_train,11);
            
            
TotalPlayedTime[id]=str_to_numonline );
            
StandAlone[id]=str_to_num StandAlone );
            
Enemies[id]=str_to_num Enemies );
            
HSkills[id]=str_to_num HSkills );
            
HSknifekills[id]=str_to_numHSknifekills );
            
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_numenv_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(idszAuthId[id], 63);
    
get_user_info(id,"name",szUserName[id],63);
    
get_user_ip (idszIP[id], 15)
    
geoip_code2szIP[id], szCountery[id]);
    
strtolower(szCountery[id]);
    
TotalPlayedTime[id] += get_user_time(id);
    new 
createinto[1001];
    new 
cData[192];
    
cData[0]=id;
    
formatex(createintosizeof 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(iFailStateHandle:hQueryszError[], iErrnumcData[], iSizeFloat:fQueueTime)
{
    new 
id=cData[0];
    if( 
iFailState != TQUERY_SUCCESS )
    {
        
log_amx("SQL: SQL Error #%d - %s"iErrnumszError);
        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;
    




All times are GMT -4. The time now is 03:34.

Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.