25.01.2010, 10:34
Problems again o_O
Last user_id is 9313 so i need to get this:
But i get this:
from mysql logs:
and for mysql_get_field i have this:
Maybe this is some problems with plugin ? Because i can't login to my account too. Maybe you did some mistakes in yesterdays update ?
pawn Code:
new RegUserID;
format(query,sizeof(query),"SELECT user_id FROM vartotojai ORDER BY user_id DESC LIMIT 0, 1");
mysql_query(query);
mysql_store_result();
mysql_fetch_row(line);
mysql_get_field("user_id",sql);
RegUserID = strval(sql)+1;
printf("NEW USER ID: %d",RegUserID);
printf("FROM DATABASE: %s",sql);
Code:
NEW USER ID: 9314 FROM DATABASe: 9313
Code:
NEW USER ID: 1 FROM DATABASE: [here nothing]
Code:
[01/25/10 13:33:03] 'mysql_query' executed: "SELECT user_id FROM vartotojai ORDER BY user_id DESC LIMIT 0, 1" with result: "0". [01/25/10 13:33:03] 'mysql_fetch_row' called with result: "9313".
pawn Code:
#define mysql_get_field(%1,%2) mysql_fetch_field(%1,%2)