[n0way0out]

hello all

i need help ,

i need a code that update table field name when user logged in . when player logged in to the server then that table colume field name automtic update and when player logged out then again update .



thanks ....

[Backstabnoob]

You really cannot figure it out yourself? You might as well post in requests next time.

/* Plugin generated by AMXX-Studio */

#include <amxmodx>
#include <amxmisc>
#include < sqlx >

#define PLUGIN "New Plugin"
#define VERSION "1.0"
#define AUTHOR "Author"


new Handle: g_SqlHandle

new g_QueryCache[ 256 ]

public plugin_init( )
{
    g_SqlHandle = SQL_MakeStdTuple( )
}

public client_connect( id )
{
    new szAuthid[ 34 ]
    get_user_authid( id, szAuthid, charsmax( szAuthid ) )
    
    formatex( g_QueryCache, charsmax( g_QueryCache ), "INSERT INTO table VALUES ('%s', 1) ON DUPLICATE KEY online=1", szAuthid )
    
    SQL_ThreadQuery( g_SqlHandle, "SQL__HANDLE_DROP", g_QueryCache )
}

public client_disconnect( id )
{
    new szAuthid[ 34 ]
    get_user_authid( id, szAuthid, charsmax( szAuthid ) )
    
    formatex( g_QueryCache, charsmax( g_QueryCache ), "INSERT INTO table VALUES ('%s', 0) ON DUPLICATE KEY online=0", szAuthid )
    
    SQL_ThreadQuery( g_SqlHandle, "SQL__HANDLE_DROP", g_QueryCache )
}


public SQL__HANDLE_DROP( ) { }

[n0way0out]

thanks for reply bro . my table name is "register" and there is 5 field name . user,status,confirmcode,userid, and password . so if user connected then first check that user name and update his status "logged_in" and if user logged out then again update "logged_out".


thanks

[n0way0out]

public client_connect( id )
{
new szAuthid[ 34 ]
get_user_authid( id, szAuthid, charsmax( szAuthid ) )
formatex(query, charsmax(query), "UPDATE register SET Status = ^"%s^" WHERE Name = ^"%s^";", enabled ? "LOGGED_IN" : "LOGGED_OUT", name)
SQL_ThreadQuery(g_sqltuple, "QuerySetData", query)
}

???

[Backstabnoob]

Something like that, replace double quotes by single ones, therefore you don't need to escape them with ^ and I don't even know how MySQL handles double quotes.

Only thing I don't understand is your enabled ? "LOGGED_IN" : "LOGGED_OUT" nonsense. Why do you even use it? Of course they will be logged in since you're calling the query from client_connect. Simply use SET Status = 'LOGGED_IN' in client_connect and LOGGED_OUT in client_disconnect.

Also, you're using "name" variable which doesn't even exist. You should check some basic pawn tutorials before trying to use more complex things such as MySQL.

[n0way0out]

Originally Posted by Backstabnoob Something like that, replace double quotes by single ones, therefore you don't need to escape them with ^ and I don't even know how MySQL handles double quotes. Only thing I don't understand is your enabled ? "LOGGED_IN" : "LOGGED_OUT" nonsense. Why do you even use it? Of course they will be logged in since you're calling the query from client_connect. Simply use SET Status = 'LOGGED_IN' in client_connect and LOGGED_OUT in client_disconnect. Also, you're using "name" variable which doesn't even exist. You should check some basic pawn tutorials before trying to use more complex things such as MySQL.

thanx for helping me .. now everything is ok except one thing.

how i block user to connect my server if his status is LOGGED_IN . ?

[Backstabnoob]

I have no idea why would you want this, but it would be a bit more complicated. You'd have to call a SELECT query from within the client_connect handler, however NOT as a threaded query. If you choose to use a threaded query, the next query that sets their status to LOGGED_IN would rewrite the value before the SELECT query is finished, therefore you would always get LOGGED_IN.