Mysql Script Fehler!

Daniel5474 · 3. Mai 2012

Hallo ich habe einen kleinen Fehler im Mysql Script^^
also es wird einfach nicht in die Datenbank eingetragen^^

hier mein Script irgendwo muss ein fehler sein^^

also
Include
#include <a_mysql>

#define SQL_HOST "host"
#define SQL_USER "name"
#define SQL_PASS "password"
#define SQL_DATA "dbbasename"

On Gamemod Int

Connect_To_Database();
mysql_debug(1);

on Player Disconect
SavePlayer(playerid);

und dich Functions
stock SavePlayer(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
if(GetPVarInt(playerid,"Eingeloggt") == 1)
{
new sendername74[MAX_PLAYER_NAME)];
GetPlayerName(playerid, sendername74, MAX_PLAYER_NAME);
mysql_SetInt("accounts", "Level", PlayerInfo[playerid][pLevel], "Name", sendername74);
mysql_SetInt("accounts", "Geld", PlayerInfo[playerid][pCash], "Name", sendername74);
mysql_SetInt("accounts", "Kills", PlayerInfo[playerid][pKills], "Name", sendername74);
//mysql_SetInt("accounts", "Tode", PlayerInfo[playerid][pTode], "Name", pname);
//mysql_SetFloat("accounts", "Health", SpielerInfo[playerid][pHealth], "Name", SpielerInfo[playerid][pName]);
mysql_SetInt("accounts", "Adminlevel", PlayerInfo[playerid][pAdmin], "Name", sendername74);
//mysql_SetInt("accounts", "Fraktion", PlayerInfo[playerid][pFraktion], "Name", pname);
//mysql_SetInt("accounts", "Respektspunkte", SpielerInfo[playerid][pRespektspunkte], "Name", SpielerInfo[playerid][pName]);
mysql_SetInt("accounts", "Ban", PlayerInfo[playerid][pBan], "Name", sendername74);
mysql_SetInt("accounts", "Rank", PlayerInfo[playerid][pRank], "Name", sendername74);
//mysql_SetInt("accounts", "Leader", SpielerInfo[playerid][pLeader], "Name", SpielerInfo[playerid][pName]);
}
}
return 1;
}
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}

stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(To, To);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
new sqlint = mysql_fetch_int();
mysql_free_result();
return sqlint;
}

stock mysql_GetString(Table[], Field[], Where[], Is[])
{
new query[128], Get[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get);
mysql_free_result();
return Get;
}

stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
{
new query[128], Float:sqlfloat;
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
mysql_query(query);
mysql_store_result();
mysql_fetch_float(sqlfloat);
mysql_free_result();
return sqlfloat;
}
stock Connect_To_Database()
{
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
if(mysql_ping() == 1)
{
print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
return true;
}
else
{
print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
print("<-| [MYSQL] Der Server wird nun beendet!");
SendRconCommand("exit");
return true;
}
}
}

hier ist noch mein MYSQl Serverlog:

[17:14:13]

[17:14:13] ---------------------------

[17:14:13] MySQL Debugging activated (05/03/12)

[17:14:13] ---------------------------

[17:14:13]

[17:15:25] >> mysql_real_escape_string( Connection handle: 1 )

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

[17:15:25] >> mysql_real_escape_string( Connection handle: 1 )

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

[17:15:25] >> mysql_real_escape_string( Connection handle: 1 )

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

[17:15:25] >> mysql_real_escape_string( Connection handle: 1 )

[17:15:25] CMySQLHandler::EscapeString([LoG]Daniel); - Escaped 11 characters to [LoG]Daniel.

[17:15:25] >> mysql_query( Connection handle: 1 )

[17:15:26] CMySQLHandler::Query(UPDATE `accounts` SET `Level` = '10' WHERE `Name` = '[LoG]Daniel') - Successfully executed.