GLaube nicht das es an Dialog liegt eher an die Stocks von MySQL hier zeig ich mal ein paar:
stock mysql_CheckAccount(playerid)
{
new Name[MAX_PLAYER_NAME],count;
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name, Name);
mysql_function_query(SQL_Handle,"SELECT * FROM `accounts` WHERE `Username` = '%s'", true,"SpielerLaden","",Name);
mysql_store_result();
count = mysql_num_rows();
mysql_free_result();
return count;
}
stock CreateAccount(playerid, pass[])
{
new Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
mysql_real_escape_string(Name,Name);
mysql_real_escape_string(pass,pass);
mysql_function_query(SQL_Handle,"INSERT INTO `accounts` (`Username`, `Passwort`) VALUES ('%s', '%s')", true,"SpielerLaden","", Name, pass);
SetPlayerScore(playerid,1);
GivePlayerMoney(playerid,12000);
SpielerSpeichern(playerid);
return true;
}
stock mysql_ReturnPasswort(Name[])
{
new Get[130];
mysql_real_escape_string(Name, Name);
mysql_function_query(SQL_Handle,"SELECT `passwort` FROM `accounts` WHERE `Username` = '%s'", true,"SpielerLaden","", Name);
mysql_store_result();
mysql_fetch_row(Get);
mysql_free_result();
return Get;
}
stock Connect_To_Database()
{
mysql_connect(my_Host,my_User, my_Data, my_Pass);
if(mysql_ping() == 1)
{
print(">> [MySQL]: Die Verbindung zu Mysql wurde hergestellt !");
return true;
}
else
{
print(">> [MySQL]: Die Verbindung zu Mysql wurde nicht hergestellt !");
mysql_connect(my_Host,my_User, my_Data, my_Pass);
if(mysql_ping() == 1)
{
print(">> [MySQL]: Die Verbindung zu Mysql wurde beim 2mal hergestellt !");
return true;
}
else
{
print(">> [MySQL]: Die Verbindung zu Mysql wurde nicht hergestellt (Server-Shutdown) !");
SendRconCommand("exit");
return true;
}
}
}
stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
mysql_function_query(SQL_Handle,"SELECT `%s` FROM `%s` WHERE `%s` = '%s'", true,"SpielerLaden","",Field, Table, Where, Is);
//mysql_query(query);
mysql_store_result();
//new sqlint = mysql_fetch_int();
//mysql_fetch_int(SQL_Handle);
mysql_free_result();
return SQL_Handle;
}
stock mysql_GetString(Table[], Field[], Where[], Is[])
{
new 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);
mysql_function_query(SQL_Handle,"SELECT `%s` FROM `%s` WHERE `%s` = '%s'", true,"SpielerLaden","",Field, Table, Where, Is);
mysql_store_result();
mysql_fetch_row(Get);
mysql_free_result();
return Get;
}
stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
{
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Is, Is);
mysql_function_query(SQL_Handle,"SELECT `%s` FROM `%s` WHERE `%s` = '%s'", true,"SpielerLaden","",Field, Table, Where, Is);
mysql_store_result();
//mysql_fetch_float(sqlfloat);
mysql_free_result();
return SQL_Handle; //Zeile
}
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
mysql_function_query(SQL_Handle,"UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", false,"","",Table, Field, To, Where, Where2);
return true;
}
stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
{
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);
mysql_function_query(SQL_Handle,"UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", false,"","",Table, Field, To, Where, Where2);
return true;
}
stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
{
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
mysql_function_query(SQL_Handle,"UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", false,"","",Table, Field, To, Where, Where2);
return true;
}
Hoffe ihr könnt mir weiter helfen