[Psycho77]

Hey..

I'm using StrickenKid's mysql plguin.
I like to read a table an write the readed values into my variables.

This shouldn't becomes a problem but it is!

Here my code:

Код:

new Query[512], Load[100];
	print("Test 1");
	mysql_real_escape_string(pName[playerid], pName[playerid]);
	print("Test 2");
	format(Load,sizeof(Load),"SELECT * FROM `accounts` WHERE `Nickname` = '%s'", pName[playerid]);
	print("Test 3");
	mysql_query(Load);
	print("Test 4");
	mysql_store_result();
	print("Test 5");
	while(mysql_fetch_row(Query, "|"))
	{
	
		print("Test 6");

		sscanf(Query, "p<|>{is[30]s[35]}s[15]iiiiliiiiiliiffffffiiiiiiii{iiiiiiiiiiiiiiiiiiiiiiiiii}lls[100]s[20]s[20]iils[20]s[15]iiiiis[75]s[30]iiis[15]",
		Spieler[playerid][RegDate], Spieler[playerid][Zivilskin], Spieler[playerid][Fraktionsskin], Spieler[playerid][Duty], Spieler[playerid][Adminlvl], Spieler[playerid][Leaderverwaltung], Spieler[playerid][Bargeld], Spieler[playerid][Bankgeld], Spieler[playerid][Konto],
		Spieler[playerid][Level], Spieler[playerid][Fraktion], Spieler[playerid][Leader], Spieler[playerid][Rang], Spieler[playerid][Spawnchange], Spieler[playerid][Leben], Spieler[playerid][Armour], Spieler[playerid][LastX], Spieler[playerid][LastY],
		Spieler[playerid][LastZ], Spieler[playerid][LastA], Spieler[playerid][LastInt], Spieler[playerid][LastVirt], Spieler[playerid][LastHour], Spieler[playerid][LastMinute], Spieler[playerid][LastSecond], Spieler[playerid][LastYear], Spieler[playerid][LastMonth],
		Spieler[playerid][LastDay], Spieler[playerid][ban], Spieler[playerid][tban], Spieler[playerid][bangrund], Spieler[playerid][tbantime], Spieler[playerid][tbandate], Spieler[playerid][warns], Spieler[playerid][Tutorial], Spieler[playerid][Perso],
		Spieler[playerid][Geschlecht], Spieler[playerid][GebDate], Spieler[playerid][Mute], Spieler[playerid][OOCMute], Spieler[playerid][Wanteds], Spieler[playerid][Wantedpoints], Spieler[playerid][Susptime],Spieler[playerid][Verbrechen], Spieler[playerid][Klaeger],
		Spieler[playerid][Drogen], Spieler[playerid][Mats], Spieler[playerid][Handy], Spieler[playerid][Handynummer]);
	}

    print("Test 7");
    mysql_free_result();
	print("Test 8");

The last log is "Test 5".

I can show you the mysql log, too:

Quote:

Function: mysql_real_esacpe_string executed: "Jules" with result: "Jules". [Sat Apr 27 16:42:32 2013] Function: mysql_query executed: "SELECT * FROM `accounts` WHERE `Nickname` = 'Jules'" with result: "0". [Sat Apr 27 16:42:32 2013] Function: mysql_store_result executed with result: "1" [Sat Apr 27 16:42:32 2013] Function: mysql_fetch_row executed with result: "6|Jules|a384b6463fc216a5f8ecb6670f86456a|27.4.201 3|230|-1|0|0|0|1000|14000|0|1|-1|0|0|-1|100|0|0|0|0|0|0|0|-1|-1|-1|2000|1|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|0|NULL|NULL|NULL|0|1|0|NULL|NULL|0| 0|0|0|0|Unbekannt|Unbekannt|0|0|-1|01732045316".

Sorry for my bad english, I hope you can find the error.

[LowRyder]

I know this is such an old topic, but isn't your function wrong;
this is the correct one...

Код:

while(mysql_fetch_row_format(query,"|"))

even tho it's crashing my game also. This is why i came up across this topic hoping for help