Mysql Query not working anymore, (Login System)
#1

Hey, thanks for taking at look at my problem .

So let's get down to it: My problem is that at some point while scripting my login loading system just stopped working, I don't know why. It's supposed to load:

pawn Код:
GetPlayerName(playerid, pname, sizeof(pname));
  format(stringsize, sizeof(stringsize), "SELECT * FROM "SQL_TABLE" WHERE Name = '%s'", pname);
  mysql_query(stringsize, -1, -1, RegistrationSystemConnection);
  mysql_store_result(RegistrationSystemConnection);
  new playerfilesplit[24][256], playerloadingarray[256];
  mysql_fetch_row_format(playerloadingarray,"|", RegistrationSystemConnection);
  split(playerloadingarray, playerfilesplit, '|');
  PlayerAccount[playerid][Pid] = strval(playerfilesplit[0]);
  PlayerAccount[playerid][Money] = strval(playerfilesplit[4]);
  PlayerAccount[playerid][AdminLevel] = strval(playerfilesplit[5]);
  PlayerAccount[playerid][Vip] = strval(playerfilesplit[6]);
  PlayerAccount[playerid][Skin] = strval(playerfilesplit[7]);
  PlayerAccount[playerid][Score] = strval(playerfilesplit[8]);
  PlayerAccount[playerid][Job] = strval(playerfilesplit[9]);
  PlayerAccount[playerid][Faction] = strval(playerfilesplit[10]);
  PlayerAccount[playerid][FactionRank] = strval(playerfilesplit[11]);
  PlayerAccount[playerid][Tester] = strval(playerfilesplit[12]);
  PlayerAccount[playerid][WeaponPackages] = strval(playerfilesplit[13]);
  PlayerAccount[playerid][DriverLic] = strval(playerfilesplit[14]);
  PlayerAccount[playerid][WeaponLic] = strval(playerfilesplit[15]);
  PlayerAccount[playerid][Developer] = strval(playerfilesplit[16]);
  PlayerAccount[playerid][Banned] = strval(playerfilesplit[17]);
  PlayerAccount[playerid][Achi1] = strval(playerfilesplit[18]);
  PlayerAccount[playerid][Achi2] = strval(playerfilesplit[19]);
  PlayerAccount[playerid][Achi3] = strval(playerfilesplit[20]);
  PlayerAccount[playerid][Achi4] = strval(playerfilesplit[21]);
  PlayerAccount[playerid][Achi5] = strval(playerfilesplit[22]);
  PlayerAccount[playerid][Achi6] = strval(playerfilesplit[23]);
However It does not run anymore it's like skipping this part, it runs the

pawn Код:
format(stringsize, sizeof(stringsize), "SELECT * FROM "SQL_TABLE" WHERE Name = '%s'", pname);
But it's like skipping the rest, I've never had this problem before, and can't remember when it happen and how so can't really fix it that way, now I'm forced to find a fix for it, I've been trying to find a solution but with no luck so far. Anybody here who mind helping?

Oh yea

Код:
[17:26:15] CMySQLHandler::Query(SELECT * FROM users WHERE Name = 'Tony_Salvati') - Successfully executed.

[17:26:15] >> mysql_store_result( Connection handle: 1 )

[17:26:15] CMySQLHandler::StoreResult() - Result was stored.

[17:26:20] >> mysql_query( Connection handle: 1 )
That's from the code above, but nothing else happens, well rest runs after that as it's supposed but just not the account system.
Reply


Messages In This Thread
Mysql Query not working anymore, (Login System) - by oliverrud - 21.06.2010, 15:30
Re: Mysql Query not working anymore, (Login System) - by TTJJ - 21.06.2010, 15:43
Re: Mysql Query not working anymore, (Login System) - by oliverrud - 21.06.2010, 15:46
Re: Mysql Query not working anymore, (Login System) - by TTJJ - 21.06.2010, 15:48
Re: Mysql Query not working anymore, (Login System) - by oliverrud - 21.06.2010, 15:51
Re: Mysql Query not working anymore, (Login System) - by TTJJ - 21.06.2010, 15:52

Forum Jump:


Users browsing this thread: 1 Guest(s)