MySQL System - Speichert und lädt Spielerdaten nicht.

Xoony · 14. März 2014

Hallo sampler,

Ich habe nun das Problem das mein MySQL Login system zwar für den Login funktioniert, (Sowie auch das regestrieren)
aber, er lädt die Spielerdaten nicht. z.B Geld.. bleibt immer alles unverändert.

Hier der code :

Zitat

stock LoadPlayer(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid, SpielerInfo[playerid][pName], MAX_PLAYER_NAME);
SpielerInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", SpielerInfo[playerid][pName]);
SpielerInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", SpielerInfo[playerid][pName]);
SpielerInfo[playerid][pKills] = mysql_GetInt("accounts", "Kills", "Name", SpielerInfo[playerid][pName]);
SpielerInfo[playerid][pTode] = mysql_GetInt("accounts", "Tode", "Name", SpielerInfo[playerid][pName]);
}

Alles anzeigen

SA:MP-Designs · 14. März 2014

Gibst du den Spieler überhaupt das Geld auf die Hand beim connecten?
Außerdem ist deine MySQL Speicherung ziemlich ressourcenfressend, schreib das um.

Slash™ · 14. März 2014

Einmal unter ongamemodeinit
mysql_debug(1);
schrieben und dann den mysql log posten.

Xoony · 14. März 2014

MySQL Log:

Zitat

[14:33:44]

[14:33:44] ---------------------------

[14:33:44] MySQL Debugging activated (03/14/14)

[14:33:44] ---------------------------

[14:33:44]

[14:35:15] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:15] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:15] >> mysql_query( Connection handle: 1 )

[14:35:15] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:15] >> mysql_store_result( Connection handle: 1 )

[14:35:15] CMySQLHandler::StoreResult() - Result was stored.

[14:35:15] >> mysql_num_rows( Connection handle: 1 )

[14:35:15] CMySQLHandler::NumRows() - Returned 1 row(s)

[14:35:15] >> mysql_free_result( Connection handle: 1 )

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

[14:35:15] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:15] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:15] >> mysql_query( Connection handle: 1 )

[14:35:15] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:15] >> mysql_store_result( Connection handle: 1 )

[14:35:15] CMySQLHandler::StoreResult() - Result was stored.

[14:35:15] >> mysql_num_rows( Connection handle: 1 )

[14:35:15] CMySQLHandler::NumRows() - Returned 1 row(s)

[14:35:15] >> mysql_free_result( Connection handle: 1 )

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

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:17] >> mysql_query( Connection handle: 1 )

[14:35:17] CMySQLHandler::Query(SELECT `passwort` FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:17] >> mysql_store_result( Connection handle: 1 )

[14:35:17] CMySQLHandler::StoreResult() - Result was stored.

[14:35:17] >> mysql_fetch_row_format( Connection handle: 1 )

[14:35:17] CMySQLHandler::FetchRow() - Return: afrane

[14:35:17] >> mysql_free_result( Connection handle: 1 )

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

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:17] >> mysql_query( Connection handle: 1 )

[14:35:17] CMySQLHandler::Query(SELECT `Level` FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:17] >> mysql_store_result( Connection handle: 1 )

[14:35:17] CMySQLHandler::StoreResult() - Result was stored.

[14:35:17] >> mysql_fetch_int( Connection handle: 1 )

[14:35:17] CMySQLHandler::FetchRow() - Return: 1

[14:35:17] >> mysql_free_result( Connection handle: 1 )

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

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:17] >> mysql_query( Connection handle: 1 )

[14:35:17] CMySQLHandler::Query(SELECT `Geld` FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:17] >> mysql_store_result( Connection handle: 1 )

[14:35:17] CMySQLHandler::StoreResult() - Result was stored.

[14:35:17] >> mysql_fetch_int( Connection handle: 1 )

[14:35:17] CMySQLHandler::FetchRow() - Return: 5400

[14:35:17] >> mysql_free_result( Connection handle: 1 )

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

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:17] >> mysql_query( Connection handle: 1 )

[14:35:17] CMySQLHandler::Query(SELECT `Kills` FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:17] >> mysql_store_result( Connection handle: 1 )

[14:35:17] CMySQLHandler::StoreResult() - Result was stored.

[14:35:17] >> mysql_fetch_int( Connection handle: 1 )

[14:35:17] CMySQLHandler::FetchRow() - Return: 0

[14:35:17] >> mysql_free_result( Connection handle: 1 )

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

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Tode); - Escaped 4 characters to Tode.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:17] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:17] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:17] >> mysql_query( Connection handle: 1 )

[14:35:17] CMySQLHandler::Query(SELECT `Tode` FROM `accounts` WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:17] >> mysql_store_result( Connection handle: 1 )

[14:35:17] CMySQLHandler::StoreResult() - Result was stored.

[14:35:17] >> mysql_fetch_int( Connection handle: 1 )

[14:35:17] CMySQLHandler::FetchRow() - Return: 0

[14:35:17] >> mysql_free_result( Connection handle: 1 )

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

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:23] >> mysql_query( Connection handle: 1 )

[14:35:23] CMySQLHandler::Query(UPDATE `accounts` SET `Level` = '1' WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:23] >> mysql_query( Connection handle: 1 )

[14:35:23] CMySQLHandler::Query(UPDATE `accounts` SET `Geld` = '5400' WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:23] >> mysql_query( Connection handle: 1 )

[14:35:23] CMySQLHandler::Query(UPDATE `accounts` SET `Kills` = '0' WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Tode); - Escaped 4 characters to Tode.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:23] >> mysql_query( Connection handle: 1 )

[14:35:23] CMySQLHandler::Query(UPDATE `accounts` SET `Tode` = '0' WHERE `Name` = 'Xoony') - Successfully executed.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Health); - Escaped 6 characters to Health.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

[14:35:23] >> mysql_real_escape_string( Connection handle: 1 )

[14:35:23] CMySQLHandler::EscapeString(Xoony); - Escaped 4 characters to Xoony.

[14:35:23] >> mysql_query( Connection handle: 1 )

[14:35:23] CMySQLHandler::Query(UPDATE `accounts` SET `Health` = '0.000000' WHERE `Name` = 'Xoony') - Successfully executed.

Alles anzeigen

**Kasakow** · 14. März 2014

Natürlich muss auch GivePlayerMoney und SetPlayerScore angewendet werden.
Es reicht nicht wenn du die ganzen Werte in eine Variable speichern lässt

GivePlayerMoney(...);

SetPlayerScore(...);

Hoffe konnte dir helfen

Xoony · 14. März 2014

Und wie kann ich das am besten ins MySql script mit einbinden?

Manniac · 15. März 2014

Zitat von Xoony

SpielerInfo[playerid][pLevel] = mysql_GetInt("accounts", "Level", "Name", SpielerInfo[playerid][pName]);
SpielerInfo[playerid][pGeld] = mysql_GetInt("accounts", "Geld", "Name", SpielerInfo[playerid][pName]);

GivePlayerMoney(playerid,SpielerInfo[playerid][pGeld]);
SetPlayerScore(playerid,SpielerInfo[plaerid][pLevel]

breadfish.de 12. März 2022