Raised This Month: $ Target: $400
 0% 

SQL Problems / Errors..


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
Xalus
Veteran Member
Join Date: Dec 2009
Location: Belgium
Old 05-08-2010 , 17:02   SQL Problems / Errors..
Reply With Quote #1

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;
    

__________________
Retired.
Xalus is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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