1 Error:
public OnGameModeInit()
{
SetTimer("ChangeServerName", 1000, 1);
new oldtime = GetTickCount();
AntiDeAMX();
mysql_debug(0);
print(" ... GamemodeInit");
GetServerVarAsString("bind",GlobalString,sizeof(GlobalString));
if(!GlobalString[0] || strcmp(GlobalString,BINDIP,false))
{
printf("SERVER: Der Server ist nicht auf der IP '%s' gebinded!",BINDIP);
print(" Server wird heruntergefahren ...");
SendRconCommand("exit");
return 1;
}
2 Error:
if(mysql_ping() == 1)
{
print("SERVER: Verbindung zur Datenbank wurde erfolgreich hergestellt.");
printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS);
}
3 Error:
if(mysql_ping() == 1)
{
print("SERVER: Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS);
}
4 Error:
public LoadAccount(playerid,pass[],passwortstate)
{
new query[356],result[25],rows,fields;
if(mysql_ping() == 0)
{
getdate(tag,monat,jahr);
gettime(stunde,minute,sekunde);
ForEachPlayer(i)
{
if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
{
SaveAccount(i);
}
}
Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!");
OnGameModeSave();
GameModeExit();
return 1;
}
5 Error:
public LoadAccountVehicles(playerid,slot)
{
new result[25],rows,fields;
if(mysql_ping() == 0)
{
getdate(tag,monat,jahr);
gettime(stunde,minute,sekunde);
ForEachPlayer(i)
{
if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
{
SaveAccount(i);
}
}
Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!");
OnGameModeSave();
GameModeExit();
return 1;
}
6 Error:
public OnQueryFinish2(index[],index2[],sqlresultid,extraid,extraid2,SconnectionHandle)
{
new query[1000],rows,fields;
if(SconnectionHandle != MySqlConnection || mysql_ping() == 0)
{
getdate(tag,monat,jahr);
gettime(stunde,minute,sekunde);
ForEachPlayer(i)
{
if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
{
SaveAccount(i);
}
}
Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!");
OnGameModeSave();
GameModeExit();
return 1;
}
7 Error:
public OnQueryFinish(index[],sqlresultid,extraid,SconnectionHandle)
{
new query[4000],result[64],rows,fields;
if(SconnectionHandle != MySqlConnection || mysql_ping() == 0)
{
getdate(tag,monat,jahr);
gettime(stunde,minute,sekunde);
ForEachPlayer(i)
{
if(IsPlayerConnected(i) && !IsPlayerNPC(i) && GetPVarInt(i,"Eingeloggt") == 1)
{
SaveAccount(i);
}
}
Log("Restartssqllog","Admin: System hat den Server gerestartet(Dead MySql Connection)!");
OnGameModeSave();
GameModeExit();
return 1;
}
Warnings:
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,sizeof(query),"UPDATE %s SET %s='%d' WHERE %s='%s'",Table,Field,To,Where,Where2);
mysql_function_query(MySqlConnection,query,false,"","");
return 1;
}
So das währe alles 