[n0way0out]

i am editing user register system plugin. but i need help .

i have one table . table name is register , and there is 5 field name .

1. username , 2 , password , 3 confirmcode , 4 status , 5 , time



i just want that if new player fully connected the server then automatic that status field change to logged_in . and when he disconnect the server his status field automatic change to logged_out.


i try a lot but failed .

here is some code i have tried.
public client_connect( id )
{
new szAuthid[ 34 ]
get_user_authid( id, szAuthid, charsmax( szAuthid ) )
formatex(query, charsmax(query), "UPDATE register SET Status =logged_in WHERE Name = ^"%s^")
SQL_ThreadQuery(g_sqltuple, "QuerySetData", query)
}

[^SmileY]

Full code

Ps.

UPDATE register SET Status =logged_in WHERE Name = ^"%s^"

>>

UPDATE register SET Status = 1 WHERE Name = ^"%s^"

Its a same.

[jimaway]

Originally Posted by n0way0out i am editing user register system plugin. but i need help . i have one table . table name is register , and there is 5 field name . 1. username , 2 , password , 3 confirmcode , 4 status , 5 , time i just want that if new player fully connected the server then automatic that status field change to logged_in . and when he disconnect the server his status field automatic change to logged_out. i try a lot but failed . here is some code i have tried. public client_connect( id ) { new szAuthid[ 34 ] get_user_authid( id, szAuthid, charsmax( szAuthid ) ) formatex(query, charsmax(query), "UPDATE register SET Status =logged_in WHERE Name = ^"%s^") SQL_ThreadQuery(g_sqltuple, "QuerySetData", query) }

you dont have a field named "Name"? also you didnt supply a string for %s in formatex and why are you getting the authid when you are not using it?