[Plugin] [REL] MySQL Plugin (Google Project)

[Nightmare[TR]]

Originally Posted by Sergei

Turn on debug and post it here.

Well,i solved the crash.But login doesn't works.If login doesn't works,players cannot be spawned.
Quote from mysql debug file;

[20:28:10] CMySQLHandler::Query(SELECT orgut FROM smf_members WHERE member_name='') - Successfully executed.

[20:28:10] >> mysql_store_result( Connection handle: 1 )

[20:28:10] CMySQLHandler::StoreResult() - Result was stored.

[20:28:10] >> mysql_num_rows( Connection handle: 1 )

[20:28:10] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:10] >> mysql_free_result( Connection handle: 1 )

[20:28:10] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:12] >> mysql_query( Connection handle: 1 )

[20:28:12] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:12] >> mysql_store_result( Connection handle: 1 )

[20:28:12] CMySQLHandler::StoreResult() - Result was stored.

[20:28:12] >> mysql_num_rows( Connection handle: 1 )

[20:28:12] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:12] >> mysql_free_result( Connection handle: 1 )

[20:28:12] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:14] >> mysql_query( Connection handle: 1 )

[20:28:14] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:14] >> mysql_store_result( Connection handle: 1 )

[20:28:14] CMySQLHandler::StoreResult() - Result was stored.

[20:28:14] >> mysql_num_rows( Connection handle: 1 )

[20:28:14] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:14] >> mysql_free_result( Connection handle: 1 )

[20:28:14] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:15] >> mysql_query( Connection handle: 1 )

[20:28:16] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:16] >> mysql_store_result( Connection handle: 1 )

[20:28:16] CMySQLHandler::StoreResult() - Result was stored.

[20:28:16] >> mysql_num_rows( Connection handle: 1 )

[20:28:16] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:16] >> mysql_free_result( Connection handle: 1 )

[20:28:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:16] >> mysql_query( Connection handle: 1 )

[20:28:16] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:16] >> mysql_store_result( Connection handle: 1 )

[20:28:16] CMySQLHandler::StoreResult() - Result was stored.

[20:28:16] >> mysql_num_rows( Connection handle: 1 )

[20:28:16] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:16] >> mysql_free_result( Connection handle: 1 )

[20:28:16] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:17] >> mysql_query( Connection handle: 1 )

[20:28:17] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:17] >> mysql_store_result( Connection handle: 1 )

[20:28:17] CMySQLHandler::StoreResult() - Result was stored.

[20:28:17] >> mysql_num_rows( Connection handle: 1 )

[20:28:17] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:17] >> mysql_free_result( Connection handle: 1 )

[20:28:17] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:18] >> mysql_query( Connection handle: 1 )

[20:28:18] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:18] >> mysql_store_result( Connection handle: 1 )

[20:28:18] CMySQLHandler::StoreResult() - Result was stored.

[20:28:18] >> mysql_num_rows( Connection handle: 1 )

[20:28:18] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:18] >> mysql_free_result( Connection handle: 1 )

[20:28:18] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:19] >> mysql_query( Connection handle: 1 )

[20:28:19] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:19] >> mysql_store_result( Connection handle: 1 )

[20:28:19] CMySQLHandler::StoreResult() - Result was stored.

[20:28:19] >> mysql_num_rows( Connection handle: 1 )

[20:28:19] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:19] >> mysql_free_result( Connection handle: 1 )

[20:28:19] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:20] >> mysql_query( Connection handle: 1 )

[20:28:20] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:20] >> mysql_store_result( Connection handle: 1 )

[20:28:20] CMySQLHandler::StoreResult() - Result was stored.

[20:28:20] >> mysql_num_rows( Connection handle: 1 )

[20:28:20] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:20] >> mysql_free_result( Connection handle: 1 )

[20:28:20] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:21] >> mysql_query( Connection handle: 1 )

[20:28:21] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:21] >> mysql_store_result( Connection handle: 1 )

[20:28:21] CMySQLHandler::StoreResult() - Result was stored.

[20:28:21] >> mysql_num_rows( Connection handle: 1 )

[20:28:21] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:21] >> mysql_free_result( Connection handle: 1 )

[20:28:21] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:22] >> mysql_query( Connection handle: 1 )

[20:28:22] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:22] >> mysql_store_result( Connection handle: 1 )

[20:28:22] CMySQLHandler::StoreResult() - Result was stored.

[20:28:22] >> mysql_num_rows( Connection handle: 1 )

[20:28:22] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:22] >> mysql_free_result( Connection handle: 1 )

[20:28:22] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:23] >> mysql_query( Connection handle: 1 )

[20:28:24] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:24] >> mysql_store_result( Connection handle: 1 )

[20:28:24] CMySQLHandler::StoreResult() - Result was stored.

[20:28:24] >> mysql_num_rows( Connection handle: 1 )

[20:28:24] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:24] >> mysql_free_result( Connection handle: 1 )

[20:28:24] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:47] >> mysql_query( Connection handle: 1 )

[20:28:47] CMySQLHandler::Query(SELECT * FROM smf_members WHERE member_name='ÿ') - Successfully executed.

[20:28:47] >> mysql_store_result( Connection handle: 1 )

[20:28:47] CMySQLHandler::StoreResult() - Result was stored.

[20:28:47] >> mysql_num_rows( Connection handle: 1 )

[20:28:47] CMySQLHandler::NumRows() - Returned 0 row(s)

[20:28:47] >> mysql_free_result( Connection handle: 1 )

[20:28:47] CMySQLHandler::FreeResult() - Result was successfully free'd.

[20:28:57] >> mysql_query( Connection handle: 1 )

[20:28:57] CMySQLHandler::Query(UPDATE smf_members SET exp='0' WHERE member_name='Snakeman') - Successfully executed.

[Michalec]

How to check if player logged ?

    format(Query,sizeof(Query),"SELECT `id` FROM `Gracze` WHERE `gracz` = '%s';",PlayerName(playerid));
    mysql_query(Query, -1, -1, MySQL);
    mysql_store_result();
    if(mysql_num_rows(MySQL) == 1)
    {
        LoginPlayer(playerid, 0);
    	}else{
        RegisterPlayer(playerid, 0);
    }
    mysql_free_result();

Didn't work... Help xd

[Sergei]

You cut your log at the place where it became useful. It's useless to post logs from searching for user "y" because it doesn't exist right? Query some actual user name and post log here.

And it would be useful to psot your whole login code, not just this snipped.

PS: You should really do some checks so if you don't send query with empty player name.

PS2: HAve you even used my code I gave you? I don't see that plugin is escpaing anything anywhere ...

[Nightmare[TR]]

Forget it.

[Michalec]

Help xd

[12:43:30] Passing query SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]'; | siii
[12:43:30] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]';)
[12:43:30] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[12:43:41] >> mysql_query_callback( Connection handle: 1 )
[12:43:41] CMySQLHandler::ProcessQueryThread() - Reconnection attempt in background thread.
[12:43:41] CMySQLHandler::Connect() - Connection was successful.
[12:43:41] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

This is log.
Where mistake ?

format(Query,sizeof(Query),"SELECT `id` FROM `Gracze` WHERE `gracz` = '%s';",PlayerName(playerid));
    mysql_query(Query, -1, -1, MySQL);
    mysql_store_result();
    if(mysql_num_rows(MySQL) == 1)
    {
        LoginPlayer(playerid, 0);
    	}else{
        RegisterPlayer(playerid, 0);
    }
    mysql_free_result();

Cya.

[[NoV]LaZ]

All mysql functions require a connection handle if you use any.

format(Query,sizeof(Query),"SELECT `id` FROM `Gracze` WHERE `gracz` = '%s';",PlayerName(playerid));
    mysql_query(Query, -1, -1, MySQL);
    mysql_store_result(MySQL);
    if(mysql_num_rows(MySQL) == 1)
    {
        LoginPlayer(playerid, 0);
        }else{
        RegisterPlayer(playerid, 0);
    }
    mysql_free_result(MySQL);

[Michalec]

Didn't help. In log returns 1 if player name didn't exists and in game (with my debug) returns -1 or 1 O.o

[14:23:43] Passing query SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]' LIMIT 1; | siii
[14:23:44] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]' LIMIT 1;)
[14:23:44] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[14:24:12] >> mysql_query_callback( Connection handle: 1 )
[14:24:12] >> mysql_store_result( Connection handle: 1 )
[14:24:12] CMySQLHandler::StoreResult() - Result was stored.
[14:24:12] >> mysql_num_rows( Connection handle: 1 )
[14:24:12] CMySQLHandler::NumRows() - Returned 1 row(s)
[14:24:12] >> mysql_num_rows( Connection handle: 1 )
[14:24:12] CMySQLHandler::NumRows() - Returned 1 row(s)
[14:24:12] >> mysql_free_result( Connection handle: 1 )
[14:24:12] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:24:12] Passing query SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]22' LIMIT 1; | siii
[14:24:12] ProcessQueryThread(OnQueryFinish) - Query was successful. (SELECT `id` FROM `Gracze` WHERE `gracz` = '[]Damianos[]22' LIMIT 1;)
[14:24:12] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()

If enter as []Damianos[] it returns -1
If enter as []Damianos[]22 it returns 1
[]Damianos[] exists in database, []Damianos[]22 not. WTF ?

[Nicolas_Castillo]

Hello, I have a problem with the plugin in ubuntu.

with the plugin to R7

"x86 (compiled on Ubuntu)"

I get this error:

Failed (plugins / mysql.so: undefined symbol: _Z13stringvprintfPKcPc)

While in the other version of the plugin R7

"Ubuntu"

I get this error

Failed (libmysqlclient_r.so.16: can not open shared object file: No such file or

[Coicatak]

Is is normal that

mysql_query("SELECT * FROM players");

gives me: " error 017: undefined symbol "mysql_query""?

I checked the a_mysql.inc file and I've noticed that mysql_query() is a macro, not a function, that must take 4 parameters whereas on the first post it says only the query must be passed as the other parameters are optional.

And there is no mysql_fetch_int() function, wtf lol

EDIT: Well, after reading http://forum.sa-mp.com/showthread.php?t=337810, I understood why all of the above happened. It would be good to update first post and wiki though.

[Michalec]

    format(Query,sizeof(Query),"SELECT `id` FROM `Gracze` WHERE `gracz` = '%s' LIMIT 1;",PlayerName(playerid));
    mysql_query(Query, -1, -1, MySQL);
    mysql_store_result(MySQL);
    new rows = mysql_num_rows(MySQL);
    if(rows)
    {
        LoginPlayer(playerid, 0);
    	}else{
        RegisterPlayer(playerid, 0);
    }
    FormatMessage(playerid, "Rows: %d", rows);
    mysql_free_result(MySQL);

Didn't work... Help. I have to use the method of callback ?
On debug (formatmessage) if nick exists it returns -1 (WTF?)