Raised This Month: $ Target: $400
 0% 

Sqlx Help


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
WAW555
Junior Member
Join Date: Dec 2008
Old 09-29-2011 , 10:09   Re: Sqlx Help
Reply With Quote #7

Please help with query

g_i_PlayerID[id] = 116

PHP Code:
public Get_User_Group(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(
FailState == TQUERY_CONNECT_FAILED)
    return 
set_fail_state("Error connect MySql")
    else if(
FailState == TQUERY_QUERY_FAILED)
    return 
set_fail_state("Error Query.")
    
    if(
Errcode)
    return 
log_amx("Error MySql: %s",Error)
    
    new 
id
    id 
Data[0]
    
    if(
SQL_MoreResults(Query))
    {
        new  
s_Request[512]
        
g_i_PlayerGroup[id] = SQL_ReadResult(Query,0)
        
log_to_file(g_szLogFile"13. Get Player Group g_i_PlayerGroup = %d"g_i_PlayerGroup[id])
        if(
g_i_PlayerGroup[id] == 2)
        {
            
g_s_PlayerGroupName[id] = "User"
        
}
        
format(s_Request,charsmax(s_Request), "SELECT parent FROM w4die_community_msg WHERE from = '%d'",g_i_PlayerID[id])
        
SQL_ThreadQuery(g_SqlTuple,"Get_User_Group_Name",s_RequestData1)
        
SQL_NextRow(Query)
    }
    
SQL_FreeHandle(Query)
    
    return 
PLUGIN_CONTINUE
}

public 
Get_User_Group_Name(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
    if(
FailState == TQUERY_CONNECT_FAILED)
    return 
set_fail_state("Error connect MySql")
    else if(
FailState == TQUERY_QUERY_FAILED)
    return 
set_fail_state("Error Query.")
    
    if(
Errcode)
    return 
log_amx("Error MySql: %s",Error)
    
    new 
id
    id 
Data[0]
    
    if(
SQL_MoreResults(Query))
    {
        
g_i_Player_Message[id] = SQL_ReadResult(Query,0)
        
log_to_file(g_szLogFile"14. Get user message g_i_Player_Message = %d"g_i_Player_Message[id])
        
        
SQL_NextRow(Query)
    }
    
SQL_FreeHandle(Query)
    
    return 
PLUGIN_CONTINUE

error_log

Code:
L 09/29/2011 - 17:56:19: Info (map "de_dust2") (file "addons/amxmodx/logs/error_20110929.log")
L 09/29/2011 - 17:56:19: [AMXX] Plugin ("sql_test.amxx") is setting itself as failed.
L 09/29/2011 - 17:56:19: [AMXX] Plugin says: Ошибка запроса.
L 09/29/2011 - 17:56:19: [AMXX] Displaying debug trace (plugin "sql_test.amxx")
L 09/29/2011 - 17:56:19: [AMXX] Run time error 1: forced exit 
L 09/29/2011 - 17:56:19: [AMXX]    [0] sql_test.sma::Get_User_Group_Name (line 335)
mysql_log

Code:
L 09/29/2011 - 17:56:19: 1. Autorised player SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 3. Get SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 4. Get player in mysql SteamID STEAM_0:0:19404857
L 09/29/2011 - 17:56:19: 16. Get player Data
L 09/29/2011 - 17:56:19: 13. Get Player Group g_i_PlayerGroup = 2
MySql Data

from parent
116 2
118 2
116 2
WAW555 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 19:43.


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