Raised This Month: $ Target: $400
 0% 

Saber si existe en la DB


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Author Message
thesnakebiter
Senior Member
Join Date: Oct 2011
Old 06-20-2012 , 15:30   Saber si existe en la DB
#1

PHP Code:
#include <amxmodx>
#include <amxmisc>
#include <sqlx>


new Handle:g_SqlTuple

new g_iMaxPlayers
new s_IP[60]
new 
s_MapName[32]
new 
s_nPlayers
new s_Hostname[64]

public 
plugin_init()
{
    
register_plugin("DB Test","1.0","TSB")
    
register_clcmd("say /crear","Load")
    
g_iMaxPlayers get_maxplayers()
    
g_SqlTuple SQL_MakeDbTuple("127.0.0.1","super","1234""newtest")
}
public 
Load()
{
    static 
szQuery[199];
    
Checks()
    
    
formatex(szQuerycharsmax(szQuery),"SELECT * 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)
        
log_amx(" SQL Error #%d - %s"iErrnumszError)
        
    if( !
SQL_NumResultshQuery ) )
    {
        
formatex(szQuerycharsmax(szQuery),"INSERT INTO servers_online (ip,map,online,name) VALUES ('%s','%s','%s/%s','%s')"s_IPs_MapName,s_nPlayers,g_iMaxPlayers,s_Hostname)
        
SQL_ThreadQuery(g_SqlTuple"LoadHandler"szQuery);
    }
    else
    {
        
formatex(szQuerycharsmax(szQuery),"UPDATE TABLE 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"LoadHandler"szQuery);
    }
        

No puse una funcion.
Lo que ocurre es que yo quiero comprobar si ya existe una entrada en la tabla de la base de datos con la ip del sv, intento con SELECT * FROM servers_online WHERE ip = 'IPDELSV' y con SQL_NumResults( hQuery ) pero se hace un loop infinito intentando todo el rato modificar la columna pero no la crea en caso de que no este.
thesnakebiter is offline
 


Thread Tools
Display Modes

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:27.


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