Script auf MySQL umgeschrieben = Fehler?

Freakynight · 31. August 2012, 10:24

Hallo,
ich habe mir gestern von YT (wenn erwünscht schicke ich auch Link) ein Video über MySQL und SAMP angeguckt, habe alles gemacht wie dort.
Doch wenn ich jetzt das Script hochlade,starte komm da "run time error" und beim GameMode wird "Unknown" angezeigt, doch der Server läuft.

Hier meine MySQL Stocks:
[pwn]
stock mysql_CheckAccount(playerid)
{
new Query[128],Name[MAX_PLAYER_NAME],count;
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name, Name);
format(Query, sizeof(Query), "SELECT * FROM `accounts` WHERE `Name` = '%s'", Name);
mysql_query(Query);
mysql_store_result();
count = mysql_num_rows();
mysql_free_result();
return count;
}
stock CreateAccount(playerid, pass[])
{
new query[256],Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(pass,pass);
format(query, sizeof(query), "INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('%s', '%s')", Name, pass);
mysql_query(query);
return true;
}
stock mysql_ReturnPasswort(Name[])
{
new query[130], Get[130];
mysql_real_escape_string(Name, Name);
format(query, 128, "SELECT `passwort` FROM `accounts` WHERE `Name` = '%s'", Name);
mysql_query(query);
mysql_store_result();
mysql_fetch_row(Get);
mysql_free_result();
return Get;
}
stock SpielerSpeichern(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,pInfo[playerid][pName],MAX_PLAYER_NAME);
if(r_LoadSQLEntrance("accounts","Name",pInfo[playerid][pName]))
{
pInfo[playerid][Level] = GetPlayerScore(playerid);
pInfo[playerid][Geld] = GetPlayerMoney(playerid);
r_mysql_SetInt("Level",pInfo[playerid][Level]);
r_mysql_SetInt("Geld",pInfo[playerid][Geld]);
r_mysql_SetInt("Skin",pInfo[playerid][Skin]);
r_mysql_SetInt("Skin2",pInfo[playerid][Skin2]);
r_mysql_SetInt("Geschlecht",pInfo[playerid][Geschlecht]);
r_mysql_SetInt("Haus",pInfo[playerid][Haus]);
r_mysql_SetInt("Alter",pInfo[playerid][Alter]);
r_mysql_SetInt("Fraktion",pInfo[playerid][Fraktion]);
r_mysql_SetInt("Leader",pInfo[playerid][Leader]);
r_mysql_SetInt("Rank",pInfo[playerid][Rank]);
r_mysql_SetInt("Adminlevel",pInfo[playerid][Adminlevel]);
r_mysql_SetInt("Ehrenmember",pInfo[playerid][Ehrenmember]);
r_mysql_SetInt("Kopfgeld",pInfo[playerid][Kopfgeld]);
r_mysql_SetInt("FSchein",pInfo[playerid][FSchein]);
r_mysql_SetInt("Gebannt",pInfo[playerid][Gebannt]);
r_mysql_SetInt("PayDay",pInfo[playerid][NextPayday]);
r_mysql_SetInt("GWD",pInfo[playerid][gwdgrade]);
r_mysql_SetInt("Wanteds",pInfo[playerid][wps]);
r_mysql_SetInt("Fightstyle",pInfo[playerid][fightstyle]);
r_mysql_SetInt("C4",pInfo[playerid][HatC4]);
printf("Spielerdaten vom Spieler %s erfolgreich in der Datenbank gespeichert.",SpielerName(playerid));
r_UnloadSQLEntrance();
}
}
return 1;
}
stock SpielerLaden(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,pInfo[playerid][pName],MAX_PLAYER_NAME);
if(r_LoadSQLEntrance("accounts","Name",pInfo[playerid][pName]))
{
pInfo[playerid][Level] = r_mysql_GetInt("Level");
SetPlayerScore(playerid, pInfo[playerid][Level]);
pInfo[playerid][Geld] = r_mysql_GetInt("Geld");
GivePlayerMoney(playerid, pInfo[playerid][Geld]);
pInfo[playerid][Skin] = r_mysql_GetInt("Skin");
pInfo[playerid][Haus] = r_mysql_GetInt("Haus");
pInfo[playerid][Skin2] = r_mysql_GetInt("Skin2");
pInfo[playerid][Geschlecht] = r_mysql_GetInt("Geschlecht");
pInfo[playerid][Alter] = r_mysql_GetInt("Alter");
pInfo[playerid][Fraktion] = r_mysql_GetInt("Fraktion");
pInfo[playerid][Leader] = r_mysql_GetInt("Leader");
pInfo[playerid][Rank] = r_mysql_GetInt("Rank");
pInfo[playerid][Adminlevel] = r_mysql_GetInt("Adminlevel");
pInfo[playerid][Ehrenmember] = r_mysql_GetInt("Ehrenmember");
pInfo[playerid][Kopfgeld] = r_mysql_GetInt("Kopfgeld");
pInfo[playerid][FSchein] = r_mysql_GetInt("FSchein");
pInfo[playerid][Gebannt] = r_mysql_GetInt("Gebannt");
pInfo[playerid][NextPayday] = r_mysql_GetInt("PayDay");
pInfo[playerid][gwdgrade] = r_mysql_GetInt("GWD");
pInfo[playerid][wps] = r_mysql_GetInt("Wanteds");
pInfo[playerid][fightstyle] = r_mysql_GetInt("Fightstyle");
pInfo[playerid][HatC4] = r_mysql_GetInt("C4");
printf("Spielerdaten vom Spieler %s erfolgreich aus der Datenbank geladen",SpielerName(playerid));
if(pInfo[playerid][Gebannt] == 1)
{
Kick(playerid);
}
SpawnPlayer(playerid);
new string[256];
format(string, sizeof(string), ""CYAN"<< Fraktionsmitglied "ROT1"%s "CYAN"hat sich eingeloggt. >>", pInfo[playerid][pName]);
SendFraktionMessage(pInfo[playerid][Fraktion],COLOR_WHITE,string);
if(IsPlayerAnAdmin(playerid,1))
{
new string2[256];
format(string2, sizeof(string2), ""GRÜN"<< Teammitglied "ROT1"%s "GRÜN"hat sich eingeloggt. >>", pInfo[playerid][pName]);
SendAdminMessage(COLOR_WHITE, string2);
}
if(pInfo[playerid][Level] <= 3

IsPlayerAnAdmin(playerid,1))
{
TogNC[playerid] = 1;
SendClientMessage(playerid, COLOR_PURPLE, "Der Newbiechat ist angeschaltet, benutzen kannst du ihn mit /nc.");
}
r_UnloadSQLEntrance();
}

}
return 1;
}
[/pwn]

//EDIT: Ich benutze noch dieses Include damit es (laut YT) einfacher geht:
[pwn]
/*
RFT MySql Version 1.1.0
© 2012 by RFT

*/
#include <a_samp>
#include <a_mysql>

/*
native r_mysql_Connect_To_Database(host[], user[], password[], database[]);
native r_LoadSQLEntrance(Table[], Where1[], Where2[]);
native r_UnloadSQLEntrance();
native r_mysql_GetString(Var[]);
native r_mysql_GetFloat(Var[]);
native r_mysql_GetInt(Var[]);
native r_mysql_SetString(Var[], to[]);
native r_mysql_SetFloat(Var[], Float:to);
native r_mysql_SetInt(Var[], to);
*/

new bool:r_in_use=false;
new bool:r_GET[3][64];

stock r_mysql_Connect_To_Database(host[], user[], password[], database[])
{
printf("MySql: Verbindung zur Datenbank: %s wird hergestellt...", database);
mysql_connect(host, user, database, password);
if(mysql_ping()!=1)
{
printf("MySql: Verbindung zur Datenbank %s konnte nicht hergestellt werden.", database);
printf("MySql: Es wird erneut versucht eine Verbindung zur Datenbank %s herzustellen...", database);
mysql_connect(host, user, database, password);
if(mysql_ping()!=1)
{
printf("MySql: Es konnte erneut keine Verbindung zur Datenbank: %s hergestellt werden. Der Server wird beendet.", database);
SendRconCommand("exit");
return true;
}
else printf("MySql: Der erneute versuch eine Verbindung zur Datenbank: %s herzustellen war erfolgreich.", database);
}
else printf("MySql: Verbindung zur Datenbank: %s erfolgreich hergestellt...", database);
return true;
}

stock r_LoadSQLEntrance(Table[], Where1[], Where2[])
{
new query[128];
if(r_in_use==false)
{
strmid(r_GET[0], Table, 0, strlen(Table), 64);
strmid(r_GET[1], Where1, 0, strlen(Where1), 64);
strmid(r_GET[2], Where2, 0, strlen(Where2), 64);
format(query, sizeof(query), "SELECT * FROM %s WHERE `%s`='%s'", Table, Where1, Where2);
mysql_query(query);
mysql_store_result();
mysql_retrieve_row();
r_in_use=true;
return 1;
}
else
{
print("[RFT_MYSQL]Fehler");
return 0;
}
}

stock r_UpdateRow()
{
r_UnloadSQLEntrance();
r_LoadSQLEntrance(r_GET[0], r_GET[1], r_GET[2]);
return true;
}

stock r_mysql_GetString(Var[])
{
new load[128];
mysql_fetch_field_row(load, Var);
return load;
}

stock Float:r_mysql_GetFloat(Var[])
{
return floatstr(r_mysql_GetString(Var));
}

stock r_mysql_GetInt(Var[])
{
return strval(r_mysql_GetString(Var));
}

stock r_mysql_SetString(Var[], to[])
{
if(r_in_use==true)
{
new query[128];
format(query, sizeof(query), "UPDATE %s SET `%s` = '%s' WHERE `%s` = '%s'", r_GET[0], Var, to, r_GET[1], r_GET[2]);
mysql_query(query);
r_UpdateRow();
return 1;
}
return 0;
}

stock r_mysql_SetFloat(Var[], Float:to)
{
new str[32];
format(str, sizeof(str), "%f", to);
r_mysql_SetString(Var, str);
return 1;
}

stock r_mysql_SetInt(Var[], to)
{
new str[32];
format(str, sizeof(str), "%d", to);
r_mysql_SetString(Var, str);
return 1;
}

stock r_UnloadSQLEntrance()
{
if(r_in_use==true)
{
r_in_use=false;
mysql_free_result();
return 1;
}
else return 0;
}
[/pwn]

Vincent Petritz · 31. August 2012, 14:13

Da fehlt dann wohl ein Ordner/Datei, z.B. die mysql.so-Datei könnte's sein.

Freakynight · 31. August 2012, 14:35

Ich habs jetzt einfach alles neu geschrieben, mit dem TuT aus breadfish. Doch jetzt das nächste Problem:
Es wird nicht gespeichert:

stocks:
[pwn]
stock SpielerSpeichern(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,pInfo[playerid][pName],MAX_PLAYER_NAME);
pInfo[playerid][Level] = GetPlayerScore(playerid);
pInfo[playerid][Geld] = GetPlayerMoney(playerid);
mysql_SetInt("accounts", "Level", pInfo[playerid][Level], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Geld", pInfo[playerid][Geld], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Skin", pInfo[playerid][Skin], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Skin2", pInfo[playerid][Skin2], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Geschlecht", pInfo[playerid][Geschlecht], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Haus", pInfo[playerid][Haus], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Alter", pInfo[playerid][Alter], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Fraktion", pInfo[playerid][Fraktion], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Leader", pInfo[playerid][Leader], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Rank", pInfo[playerid][Rank], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Adminlevel", pInfo[playerid][Adminlevel], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Ehrenmember", pInfo[playerid][Ehrenmember], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Kopfgeld", pInfo[playerid][Kopfgeld], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "FSchein", pInfo[playerid][FSchein], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Gebannt", pInfo[playerid][Gebannt], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "PayDay", pInfo[playerid][NextPayday], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "GWD", pInfo[playerid][gwdgrade], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Wanteds", pInfo[playerid][wps], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Fightstyle", pInfo[playerid][fightstyle], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "C4", pInfo[playerid][HatC4], "Name", pInfo[playerid][pName]);
printf("Spielerdaten vom Spieler %s erfolgreich in der Datenbank gespeichert.",SpielerName(playerid));
}
return 1;
}
stock SpielerLaden(playerid)
{
if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
{
GetPlayerName(playerid,pInfo[playerid][pName],MAX_PLAYER_NAME);
pInfo[playerid][Level] = mysql_GetInt("accounts", "Level", "Name", pInfo[playerid][pName]); //Wir holen uns den wert der unter "Level" eingetragen ist und Speichern ihn in unserer Variable.
SetPlayerScore(playerid, pInfo[playerid][Level]);
pInfo[playerid][Geld] = mysql_GetInt("accounts", "Geld", "Name", pInfo[playerid][pName]);
GivePlayerMoney(playerid, pInfo[playerid][Geld]);
pInfo[playerid][Skin] = mysql_GetInt("accounts", "Skin", "Name", pInfo[playerid][pName]);
pInfo[playerid][Haus] = mysql_GetInt("accounts", "Haus", "Name", pInfo[playerid][pName]);
pInfo[playerid][Skin2] = mysql_GetInt("accounts", "Skin2", "Name", pInfo[playerid][pName]);
pInfo[playerid][Geschlecht] = mysql_GetInt("accounts", "Geschlecht", "Name", pInfo[playerid][pName]);
pInfo[playerid][Alter] = mysql_GetInt("accounts", "Alter", "Name", pInfo[playerid][pName]);
pInfo[playerid][Fraktion] = mysql_GetInt("accounts", "Fraktion", "Name", pInfo[playerid][pName]);
pInfo[playerid][Leader] = mysql_GetInt("accounts", "Leader", "Name", pInfo[playerid][pName]);
pInfo[playerid][Rank] = mysql_GetInt("accounts", "Rank", "Name", pInfo[playerid][pName]);
pInfo[playerid][Adminlevel] = mysql_GetInt("accounts", "Adminlevel", "Name", pInfo[playerid][pName]);
pInfo[playerid][Ehrenmember] = mysql_GetInt("accounts", "Ehrenmember", "Name", pInfo[playerid][pName]);
pInfo[playerid][Kopfgeld] = mysql_GetInt("accounts", "Kopfgeld", "Name", pInfo[playerid][pName]);
pInfo[playerid][FSchein] = mysql_GetInt("accounts", "FSchein", "Name", pInfo[playerid][pName]);
pInfo[playerid][Gebannt] = mysql_GetInt("accounts", "Gebannt", "Name", pInfo[playerid][pName]);
pInfo[playerid][NextPayday] = mysql_GetInt("accounts", "PayDay", "Name", pInfo[playerid][pName]);
pInfo[playerid][gwdgrade] = mysql_GetInt("accounts", "GWD", "Name", pInfo[playerid][pName]);
pInfo[playerid][wps] = mysql_GetInt("accounts", "Wanteds", "Name", pInfo[playerid][pName]);
pInfo[playerid][fightstyle] = mysql_GetInt("accounts", "Fightstyle", "Name", pInfo[playerid][pName]);
pInfo[playerid][HatC4] = mysql_GetInt("accounts", "C4", "Name", pInfo[playerid][pName]);
printf("Spielerdaten vom Spieler %s erfolgreich aus der Datenbank geladen",SpielerName(playerid));
SpawnPlayer(playerid);
new string[256];
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid,name,sizeof(name));
format(string, sizeof(string), ""CYAN"<< Fraktionsmitglied "ROT1"%s "CYAN"hat sich eingeloggt. >>", name);
SendFraktionMessage(pInfo[playerid][Fraktion],COLOR_WHITE,string);
if(IsPlayerAnAdmin(playerid,1))
{
new string2[256];
format(string2, sizeof(string2), ""GRÜN"<< Teammitglied "ROT1"%s "GRÜN"hat sich eingeloggt. >>", name);
SendAdminMessage(COLOR_WHITE, string2);
}
if(pInfo[playerid][Level] <= 3

IsPlayerAnAdmin(playerid,1))
{
TogNC[playerid] = 1;
SendClientMessage(playerid, COLOR_PURPLE, "Der Newbiechat ist angeschaltet, benutzen kannst du ihn mit /nc.");
}

}
return 1;
}
[/pwn]

SSL · 1. September 2012, 17:42

Schonmal MySQL Debug angemacht?

Teilen