[Jstylezzz]

Hi eveyone,

It seems that something is wrong in my loadstats function, but i just don't get what is going on..
Does anyone see the error?
Every help is appreciated!

pawn Код:

stock LoadStats(playerid)
{
    new pName[24],Query[80];
    GetPlayerName(playerid,pName,24);
    format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row_format(Query, "|");
    sscanf(Query, "e<p<|>s[60]s[60]iiiiiiiiiiiiiiiiiiiiiiiiis[128]iis[128]s[128]s[128]ii>", PInfo[playerid]);
    mysql_free_result();
    GivePlayerMoney(playerid,PInfo[playerid][Money]);
    SetPVarInt(playerid,"Score",PInfo[playerid][Level]);
    SetPlayerScore(playerid,PInfo[playerid][Level]);
    SetPVarInt(playerid,"Level",PInfo[playerid][Admin]);
    SetPVarInt(playerid,"Helper",PInfo[playerid][Helper]);
    SetPlayerSkin(playerid,PInfo[playerid][Skin]);
    SetPVarInt(playerid,"Kills",PInfo[playerid][Kills]);
    SetPVarInt(playerid,"Deaths",PInfo[playerid][Deaths]);
    SetPVarInt(playerid,"Muted",PInfo[playerid][Muted]);
    SetPVarInt(playerid,"HasCell",PInfo[playerid][Cell]);
    SetPVarInt(playerid,"HasCigs",PInfo[playerid][Cigs]);
    SetPVarInt(playerid,"HasWatch",PInfo[playerid][Watch]);
    SetPVarInt(playerid,"HasMask",PInfo[playerid][Mask]);
    SetPVarInt(playerid,"GasCan",PInfo[playerid][GasCan]);
    SetPVarInt(playerid,"HasSprunk",PInfo[playerid][Sprunk]);
    SetPVarInt(playerid,"HasStereo",PInfo[playerid][Stereo]);
    SetPVarInt(playerid,"GoldCoins",PInfo[playerid][GoldCoins]);
    SetPVarInt(playerid,"PMethod",PInfo[playerid][PaymentMethod]);
    SetPVarInt(playerid,"Skin",PInfo[playerid][Skin]);



    return 1;
}

[Vince]

Log? And what's the point of these PVars if you're already using an enum?

[iggy1]

Quote:

Originally Posted by Vince Log? And what's the point of these PVars if you're already using an enum?

Maybe he needs to use them cross script. Though i do agree that's not a good way of going about it.

@Jari Have you tried the crashdetect plugin yet?

EDIT:

If you decide to use the crash detect plugin put the following file in your pawno folder.
http://dl.dropbox.com/u/76608104/pawn.cfg

Re-compile your code and run it with the crash detect plugin. If you compile with this file, extra information will be added to the crashdetect output. It should tell you which line the mode crashes on.

Remove the file or delete it's contents and recompile once you have debugged your code.

[Jstylezzz]

Thanks for the responses.
I know these pvars are shit xD I made my whole script with pvars since I was a total noob when I started it, I'm converting everything now.

I will check the crashdetect plugin, and i hope i can solve my problem.
Thanks

EDIT: ok, so i did some research...
It's clear that the problem is in this part of the stock:

pawn Код:

new pName[24],Query[80];
    GetPlayerName(playerid,pName,24);
    format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row_format(Query, "|");
    sscanf(Query, "e<p<|>s[60]s[60]iiiiiiiiiiiiiiiiiiiiiiiiis[128]iis[128]s[128]s[128]ii>", PInfo[playerid]);
    mysql_free_result();

Anyone any idea?

[Jstylezzz]

Bump - Sorry for bumping, but i really need this fixed, this is the only thing that keeps my server from going online :\

Problem:

pawn Код:

new pName[24],Query[80];
    GetPlayerName(playerid,pName,24);
    format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
    mysql_query(Query);
    mysql_store_result();
    mysql_fetch_row_format(Query, "|");
    sscanf(Query, "e<p<|>s[60]s[60]iiiiiiiiiiiiiiiiiiiiiiiiis[128]iis[128]s[128]s[128]ii>", PInfo[playerid]);
    mysql_free_result();

Somewhere in here...
I am out of ideas..

[Vince]

Quote:

Originally Posted by Vince Log?

4 char.

[Snipa]

Yes, show the log..

Or it could be this:

pawn Код:

"e<p<|>ssiiiiiiiiiiiiiiiiiiiiiiiiisiisssii>", PInfo[playerid]

[Jstylezzz]

pawn Код:

[18:17:37]  

[18:17:37] ---------------------------

[18:17:37] MySQL Debugging activated (06/21/12)

[18:17:37] ---------------------------

[18:17:37]  

[18:17:37] >> mysql_connect( )

[18:17:37] CMySQLHandler::CMySQLHandler() - constructor called.

[18:17:37] CMySQLHandler::CMySQLHandler() - Connecting to "" | DB: "" | Username: "" ...

[18:17:37] CMySQLHandler::Connect() - Connection was successful.

[18:17:37] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[18:17:40]  

[18:17:40] ---------------------------

[18:17:40] MySQL Debugging activated (06/21/12)

[18:17:40] ---------------------------

[18:17:40]  

[18:17:40] >> mysql_connect( )

[18:17:40] CMySQLHandler::CMySQLHandler() - constructor called.

[18:17:40] CMySQLHandler::CMySQLHandler() - Connecting to "" | DB: "" | Username: "" ...

[18:17:40] CMySQLHandler::Connect() - Connection was successful.

[18:17:40] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[18:19:24] >> mysql_query( Connection handle: 1 )

[18:19:25] CMySQLHandler::Query(SELECT `Username` FROM `Users` WHERE `Username` = 'Jari_Johnson' LIMIT 1;) - Successfully executed.

[18:19:25] >> mysql_store_result( Connection handle: 1 )

[18:19:25] CMySQLHandler::StoreResult() - Result was stored.

[18:19:25] >> mysql_num_rows( Connection handle: 1 )

[18:19:25] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:19:25] >> mysql_free_result( Connection handle: 1 )

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

[18:20:14] >> mysql_real_escape_string( Connection handle: 1 )

[18:20:14] CMySQLHandler::EscapeString(password); - Escaped 10 characters to password.

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

[18:20:14] CMySQLHandler::Query(SELECT * FROM `Users` WHERE `Username` = 'Jari_Johnson' AND `Password` = 'password') - Successfully executed.

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

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

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

[18:20:14] CMySQLHandler::NumRows() - Returned 1 row(s)

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

[18:20:14] CMySQLHandler::Query(SELECT * FROM `Users` WHERE `Username` = 'Jari_Johnson' ) - Successfully executed.

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

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

[18:20:14] >> mysql_fetch_row_format( Connection handle: 1 )

[18:20:14] CMySQLHandler::FetchRow() - Return: Jari_Johnson|password|5000|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||0|0||||0|0

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

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

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

[18:20:14] CMySQLHandler::FreeResult() - The result is already empty.

[18:22:09] >> mysql_query( Connection handle: 1 )

[18:22:09] CMySQLHandler::Query(SELECT `Username` FROM `Users` WHERE `Username` = 'Casper_Johnson' LIMIT 1;) - Successfully executed.

[18:22:09] >> mysql_store_result( Connection handle: 1 )

[18:22:09] CMySQLHandler::StoreResult() - Result was stored.

[18:22:09] >> mysql_num_rows( Connection handle: 1 )

[18:22:09] CMySQLHandler::NumRows() - Returned 0 row(s)

[18:22:09] >> mysql_free_result( Connection handle: 1 )

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

[18:22:12] >> mysql_query( Connection handle: 1 )

[18:22:12] CMySQLHandler::Query(INSERT INTO `Users` (Username) VALUES ('Casper_Johnson')) - Successfully executed.

[18:22:17] >> mysql_query( Connection handle: 1 )

[18:22:18] CMySQLHandler::Query(UPDATE Users SET Age = '50'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:18] >> mysql_query( Connection handle: 1 )

[18:22:18] CMySQLHandler::Query(UPDATE Users SET PNumber = '104436075'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:23] >> mysql_query( Connection handle: 1 )

[18:22:23] CMySQLHandler::Query(UPDATE Users SET PCountry = 'The Netherlands'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:30] >> mysql_query( Connection handle: 1 )

[18:22:30] CMySQLHandler::Query(UPDATE Users SET PDesc = 'I am cool'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:35] >> mysql_query( Connection handle: 1 )

[18:22:35] CMySQLHandler::Query(UPDATE Users SET PMail = '-'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:36] >> mysql_query( Connection handle: 1 )

[18:22:36] CMySQLHandler::Query(UPDATE Users SET PSex = '0'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:39] >> mysql_query( Connection handle: 1 )

[18:22:39] CMySQLHandler::Query(UPDATE Users SET Password = 'password',Money = '5000',Level = '1'WHERE Username = 'Casper_Johnson') - Successfully executed.

[18:22:39] >> mysql_query( Connection handle: 1 )

[18:22:40] CMySQLHandler::Query(SELECT * FROM `Users` WHERE `Username` = 'Casper_Johnson' ) - Successfully executed.

[18:22:40] >> mysql_store_result( Connection handle: 1 )

[18:22:40] CMySQLHandler::StoreResult() - Result was stored.

[18:22:40] >> mysql_fetch_row_format( Connection handle: 1 )

[18:22:40] CMySQLHandler::FetchRow() - Return: Casper_Johnson|password|5000|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||50|104436075|I am cool|-|The Netherlands|0|0

[18:22:40] >> mysql_free_result( Connection handle: 1 )

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

[18:22:52] >> mysql_query( Connection handle: 1 )

[18:22:52] CMySQLHandler::Query(SELECT `Username` FROM `Users` WHERE `Username` = 'Casper_Johnson' LIMIT 1;) - Successfully executed.

[18:22:52] >> mysql_store_result( Connection handle: 1 )

[18:22:52] CMySQLHandler::StoreResult() - Result was stored.

[18:22:52] >> mysql_num_rows( Connection handle: 1 )

[18:22:52] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:22:52] >> mysql_free_result( Connection handle: 1 )

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

[18:22:57] >> mysql_real_escape_string( Connection handle: 1 )

[18:22:57] CMySQLHandler::EscapeString(password); - Escaped 6 characters to password.

[18:22:57] >> mysql_query( Connection handle: 1 )

[18:22:57] CMySQLHandler::Query(SELECT * FROM `Users` WHERE `Username` = 'Casper_Johnson' AND `Password` = 'password') - Successfully executed.

[18:22:57] >> mysql_store_result( Connection handle: 1 )

[18:22:57] CMySQLHandler::StoreResult() - Result was stored.

[18:22:57] >> mysql_num_rows( Connection handle: 1 )

[18:22:57] CMySQLHandler::NumRows() - Returned 1 row(s)

[18:22:57] >> mysql_query( Connection handle: 1 )

[18:22:57] CMySQLHandler::Query(SELECT * FROM `Users` WHERE `Username` = 'Casper_Johnson' ) - Successfully executed.

[18:22:57] >> mysql_store_result( Connection handle: 1 )

[18:22:57] CMySQLHandler::StoreResult() - Result was stored.

[18:22:57] >> mysql_fetch_row_format( Connection handle: 1 )

[18:22:57] CMySQLHandler::FetchRow() - Return: Casper_Johnson|password|5000|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0||50|104436075|I am cool|-|The Netherlands|0|0

[18:22:57] >> mysql_free_result( Connection handle: 1 )

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

here is the log..
idk what this is, but when i am alone it works, but when a second person joins it crashes..
Sometimes it also crashes when i am alone..

[rachit_rocks]

Big error will give u the method asap

[Jstylezzz]

for everyone who tries to help, I just updated the mysql plugin, but the problem still exists :\
so at least it isnt the plugin.....