Pvz : As prisijungiau,session = 1,mapas keiciasi,session = 1,o kai disconnect,session = 0.
bandziau mysql daryt bet neisejo.
gal galima butu mysql pavyzdziu?
Code: Select all
public client_putinserver(client){ if(is_user_bot(client)) return; new Data[1] Data[0] = client set_task(60.0, "Check" , client, _, _, "b") get_user_authid(client,iddd,31) new ip[16], query[256], data[1]; get_user_ip(client, ip, charsmax(ip), 1); static szQuery[ 128 ], iData[ 1 ]; formatex( szQuery, 127, "SELECT `Session` FROM `%s` WHERE ( `STEAMID` = '%s' );", TABLE, iddd[client]); iData[ 0 ] = client; SQL_ThreadQuery(Tuple, "QuerySelectData", szQuery, iData, 1 ); }public QuerySelectData( iFailState, Handle:query, szError[ ], iError, iData[ ], iDataSize, Float:fQueueTime ) { if(iFailState == TQUERY_CONNECT_FAILED) else if(iFailState == TQUERY_QUERY_FAILED) new client = iData[0]; new ColPts = SQL_FieldNameToNum(query, "Session"); while(SQL_MoreResults(query)) { session[client] = SQL_ReadResult(query, ColPts); client_print(0,print_chat,"%d",session[client]) SQL_NextRow(query) } if(session[client] == 0) { new data[1]; get_user_authid(client,iddd,31) session[client] = 1; data[0] = client; formatex(query, charsmax(query), "SELECT * FROM %s WHERE STEAMID = '%s'", TABLE, iddd[client]); SQL_ThreadQuery(Tuple, "OnCheckInfo", query, data, sizeof data); }}