[StrickenKid]

Quote:

Originally Posted by Dreft Problems again o_O 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); Last user_id is 9313 so i need to get this: Code: NEW USER ID: 9314 FROM DATABASe: 9313 But i get this: Code: NEW USER ID: 1 FROM DATABASE: [here nothing] from mysql logs: 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". and for mysql_get_field i have this: pawn Code: #define mysql_get_field(%1,%2) mysql_fetch_field(%1,%2) Maybe this is some problems with plugin ? Because i can't login to my account too. Maybe you did some mistakes in yesterdays update ?

You do not need to use mysql_fetch_row before you use mysql_fetch_field.

EDIT: I also forgot to say, but I had a request from MenaceX to add mysql_fetch_int(), and mysql_fetch_float().
I've added those into the plugin and they're working, and I'll upload it when I get home from school.

So with mysql_fetch_int(), you can do:

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();
		RegUserID = mysql_fetch_int();

which is way more efficient when dealing with single fields.

Quote:

Originally Posted by OnTop2K9 This is the first time i have used MySql in sa-mp and decided to try this plugin. Iv got as far as making the tables and storing the but thats it. Could someone make an example login/register script using this plugin? I'm still reading over the example in the first post but I'm not getting any further. Infact i seem to be going backwards Thanks.

I could make another simple example on how to make a full login/register system when I get home from school.