Raised This Month: $ Target: $400
 0% 

SQL sending killer id to SQL Query


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
devWaleed
Member
Join Date: Apr 2013
Location: Karachi, Pakistan
Old 08-08-2014 , 20:17   Re: SQL sending killer id to SQL Query
Reply With Quote #1

OK I'm sorry for double post but I found my answer by looking at settask data parameter.

It should be done like this:

In DeathMsg event:

PHP Code:
get_user_name(killernamecharsmax(name));        
        
formatex(Query511"SELECT * FROM points WHERE `username`='%s'"name);
        
SQL_ThreadQuery(g_SqlTuple"QueryThread_SELECT"Querynamecharsmax(name)); 
In Handler:

PHP Code:
public QueryThread_SELECT(FailStateHandle:QueryError[], ErrcodeData[], DataSize){
    
    if(
FailState == TQUERY_CONNECT_FAILED){
        return 
set_fail_state("Couldn't connect to DB");        
    }else if(
FailState == TQUERY_QUERY_FAILED){
        return 
set_fail_state("Query failed");
    }
    
    if(
SQL_NumResults(Query) < 1){
        
        
formatex(szquery511"INSERT INTO `points` VALUES('%s', '+1')"Data);
        
SQL_ThreadQuery(g_SqlTuple"FreeQueryHandler"szquery);
        
        
client_print(0print_chat"Insert for %s"Data);
        
        
        
    }else if(
SQL_NumResults(Query) == 1){
        
        
formatex(szquery511"UPDATE `points` SET `coins` = `coins`+1 WHERE `username` = '%s'"Data);
        
SQL_ThreadQuery(g_SqlTuple"FreeQueryHandler"szquery);
        
        
client_print(0print_chat"Update for %s"Data);
    }
    return 
PLUGIN_CONTINUE;

It works perfectly now...but if someone could do some improvements please reply..

Thanks
__________________
Steam: Waleedbaig2013
devWaleed is offline
Send a message via Skype™ to devWaleed
Reply



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 12:57.


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