Raised This Month: $ Target: $400
 0% 

Saber si existe en la DB


  
 
 
Thread Tools Display Modes
Author Message
AsditoŽ^
Veteran Member
Join Date: Feb 2010
Location: Santa Fe, Argentina
Old 06-23-2012 , 11:39   Re: Saber si existe en la DB
#1

Intenta probando asi.. por lo que veo esta bien.
PHP Code:
public Load(id)
{        
    static 
szQuery[199];
    
Checks()
    
    
formatex(szQuerycharsmax(szQuery), "SELECT 'ip' FROM `servers_online` WHERE (`ip` = '%s')"s_IP)
    
SQL_ThreadQuery(g_SqlTuple"LoadHandler"szQuery);
}

public 
LoadHandler(iFailStateHandle:hQueryszError[], iErrnumcData[], iSizeFloat:fQueueTime)
{
    static 
szQuery[199];

    if( 
iFailState != TQUERY_SUCCESS )
        return 
log_amx("SQL Error #%d - %s"iErrnumszError)
    
    if (!
SQL_NumResults(hQuery))
    {                        
        
formatex(szQuerycharsmax(szQuery), "INSERT INTO `servers_online` VALUES ('%s','%s','%s/%s','%s');"s_IPs_MapName,s_nPlayers,g_iMaxPlayers,s_Hostname//seguro que tenes que guardar solo strings aca? (lo digo por g_IImaxplayers ..    
        
SQL_ThreadQuery(g_SqlTuple,"QueryHandle"szQuery)
        
        return 
PLUGIN_HANDLED;
    }
    else
    {
        
formatex(szQuerycharsmax(szQuery),"UPDATE `servers_online` SET  `map` = '%s', `online` = '%s/%s', `name` = '%s' WHERE `ip` = '%s'"s_MapName,s_nPlayers,g_iMaxPlayers,s_Hostname,s_IP
                
SQL_ThreadQuery(g_SqlTuple,"QueryHandle"szQuery);
        
        return 
PLUGIN_HANDLED;
    }
    
    return 
PLUGIN_CONTINUE;
}

public 
QueryHandle(iFailStateHandle:hQueryszError[], iErrnumcData[], iSizeFloat:fQueueTime)
{
    if( 
iFailState != TQUERY_SUCCESS )
    {
        return 
log_amx("SQL Error #%d - %s"iErrnumszError)
    }
    
    return 
PLUGIN_CONTINUE

__________________
################################

Last edited by AsditoŽ^; 06-23-2012 at 11:40.
AsditoŽ^ is offline
Send a message via MSN to AsditoŽ^
 



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 18:26.


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