Radio wird weder gelesen noch gespeichert ...

/*Allgemeine Includes sind hier zu finden !*/

#include <a_samp>
#include <a_mysql>
#include <MD5>
#include <npcdll>
#include <ocmd>
#include <sscanf2>

/*Allgemeine Farben sind hier zu finden !*/

#define Weiss 0xFFFFFFFF
#define Rot 0xFF0000FF
#define Gelb 0xFFFC00FF
#define grün 0x00FF3CFF
#define blau 0x0096FFFF

/*Allgemeine Handles sind hier zu finden !*/

new Handle;

new CarRadio[MAX_VEHICLES],
CarRadioName[MAX_PLAYERS][32],
CarRadioURL[MAX_PLAYERS][128];
/*Hier finsdest du die MySQL Daten !*/

/*Warum nutze ich diese Reihenfolge ? Weil man erst den Host, dann den User, dann dass password und dann die Datenbank abruft !*/

#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_DATA "samp_database"
#define MYSQL_PASS ""
/*Hier kann man noch Dialoge finden !*/

#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2

#define RADIO_STREAMS_DEBUG 3

#define DIALOG_CARMENU_RADIO 300
#define DIALOG_RADIO_ADD_NAME 301
#define DIALOG_RADIO_ADD_URL 302
#define DIALOG_RADIO_ADD_CHECK 303
#define DIALOG_RADIO_MANAGE_LIST 304
/*Hier kann man die forwards finden !*/

forward OnPasswordResponse(playerid);
forward UserCheck(playerid);

/*Hier = ENUM !!!*/

enum PD
{
pEingeloggt,
pGeld,
pLevel,
pFraktion,
pOnline
};

new SpielerInfo[MAX_PLAYERS][PD];

/*Das Script beginnt hier !*/

main()
{
print("\n----------------------------------");
print(" That is a gamemode made by LoomaR");
print("----------------------------------\n");
}

public OnGameModeInit()
{
Handle = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DATA, MYSQL_PASS);
if(mysql_errno() < 1) print ("MySqlServer: Die Verbindung zum Server wurde erfolgreich hergestellt."), mysql_log(LOG_ALL); else print ("MySqlServer: Es konnte keine Verbindung zum Server hergestellt werden"), SendRconCommand("exit");
SetGameModeText("That is a script made by LoomaR");
AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
return 1;
}

public OnGameModeExit()
{
return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
return 1;
}

public OnPlayerConnect(playerid)
{
new query[256];
mysql_escape_string(Spielername(playerid), Spielername(playerid));
format(query, sizeof(query), "SELECT * FROM `samp_database`.`users` WHERE username='%s'", Spielername(playerid));
mysql_tquery(Handle, query, "UserCheck", "i", playerid);
format(query, sizeof(query), "UPDATE `samp_database`.`users` SET `Online`=1 WHERE `username`='%s'", Spielername(playerid));
mysql_tquery(Handle, query);
return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
new query[256];
format(query, sizeof(query), "UPDATE `samp_database`.`users` SET `Online`=0 WHERE `username`='%s'", Spielername(playerid));
SpielerSpeichern(playerid);
mysql_tquery(Handle, query);
return 1;
}

public OnPlayerSpawn(playerid)
{
return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
return 1;
}

public OnVehicleSpawn(vehicleid)
{
CarRadio[vehicleid] = 0;
return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
return 1;
}

public OnPlayerText(playerid, text[])
{
return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
if (strcmp("/mycommand", cmdtext, true, 10) == 0)
{
// Do something here
return 1;
}
return 1;
}

ocmd:carradio(playerid, params[])
{
new query [512];
if(GetPlayerVehicleSeat(playerid) != 1 && GetPlayerVehicleSeat(playerid) != 0)return SendClientMessage(playerid, 0xAFAFAFFF, "Du bist kein Fahrer oder Beifahrer eines Fahrzeuges!");
format(query, sizeof(query), "SELECT * FROM radiostations WHERE radio_active='1'", Spielername(playerid));
new rows, fields;
cache_get_data(rows, fields);
if(!rows)return SendClientMessage(playerid, 0xAFAFAFFF, "Es sind keine Radiosender vorhanden.");
new radios, dstring[1028];
while(radios < rows) {
new temp[512];
cache_get_field_content(radios, "radio_name", temp);
format(dstring, sizeof dstring, "%s%s\n", dstring, temp);
radios++;
}
ShowPlayerDialog(playerid, DIALOG_CARMENU_RADIO, DIALOG_STYLE_LIST, "Radiosender", dstring, "Einschalten", "Ausschalten");
mysql_tquery(Handle, query);
return 1;
}

ocmd:listradios(playerid, params[])
{
new query [512];
if(!IsPlayerAdmin(playerid))return SendClientMessage(playerid, 0xAFAFAFFF, "Du bist kein Administrator.");
format(query, sizeof(query), "SELECT * FROM radiostations WHERE radio_active='1'", Spielername(playerid));
new rows, fields;
cache_get_data(rows, fields);
if(!rows)return ShowPlayerDialog(playerid, DIALOG_RADIO_MANAGE_LIST, DIALOG_STYLE_LIST, "Radiosender", "Es sind keine Radiosender vorhanden", "Hinzufügen", "");
new radios, dstring[1028];
while(radios < rows) {
new temp[512];
cache_get_field_content(radios, "radio_name", temp);
format(dstring, sizeof dstring, "%s[%i] %s\n", cache_get_field_content_int(radios, "id"), dstring, temp);
radios++;
}
ShowPlayerDialog(playerid, DIALOG_RADIO_MANAGE_LIST, DIALOG_STYLE_LIST, "Radiosender", dstring, "Hinzufügen", "Löschen");
mysql_tquery(Handle, query);
return 1;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
new vehicleid = GetPlayerVehicleID(playerid);
if(newstate == PLAYER_STATE_DRIVER || newstate == PLAYER_STATE_PASSENGER) {
if(CarRadio[vehicleid] != 0) {
new query[512];
format(query, sizeof(query), "SELECT * FROM radiostations WHERE id='%i' LIMIT 1", CarRadio[vehicleid], Spielername(playerid));
mysql_tquery(Handle, query);
new temp[512];
cache_get_field_content(0, "radio_url", temp);
PlayAudioStreamForPlayer(playerid, temp);
}
}
if(newstate == PLAYER_STATE_ONFOOT) {
StopAudioStreamForPlayer(playerid);
}
return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
return 1;
}

public OnRconCommand(cmd[])
{
return 1;
}

public OnPlayerRequestSpawn(playerid)
{
return 1;
}

public OnObjectMoved(objectid)
{
return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
return 1;
}

public OnPlayerExitedMenu(playerid)
{
return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
return 1;
}

public OnPlayerUpdate(playerid)
{
return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
new query[256], key[50];
if(dialogid == DIALOG_REGISTER)
{
if(!response)
{
return Kick(playerid);
}
if(strlen(inputtext) < 7) return SendClientMessage(playerid, Rot, "Error: {FFFFFF}Dein Passwort ist kleiner als 7 Zeichen. Bitte verwende ein sicheres Passwort."),ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Registration","It was no Account found under this name.\nPlease take a safe Password to register you.","Register","Cancel"); format(key, 50, "%s", inputtext);
mysql_escape_string(Spielername(playerid), Spielername(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "INSERT INTO `samp_database`.`users` (`username`, `password`, `Geld`, `Level`) VALUES ('%s', MD5('%s'), 50000, 1)", Spielername(playerid), key);
mysql_tquery(Handle, query);
SendClientMessage(playerid, -1, "Dein Account wurde erstellt.");
GivePlayerMoney(playerid, 50000), SetPlayerScore(playerid, 1);

return 1;
}

if(dialogid == DIALOG_LOGIN)
{
if(!response)
{
return Kick(playerid);
}
format(key, 50, "%s", inputtext);
mysql_escape_string(Spielername(playerid), Spielername(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "SELECT * FROM `samp_database`.`users` WHERE username='%s' AND password=MD5('%s')", Spielername(playerid), key);
mysql_tquery(Handle, query, "OnPasswordResponse", "i", playerid);
}

new string[512];
switch(dialogid) {
case DIALOG_CARMENU_RADIO: {
if(response) {
format(query, sizeof(query), "SELECT * FROM radiostations WHERE radio_name='%s' LIMIT 1", inputtext, Spielername(playerid));
mysql_tquery(Handle, query);
new temp[512];
cache_get_field_content(0, "radio_url", temp);
PlayAudioStreamForPlayer(playerid, temp);
cache_get_field_content(0, "radio_name", temp);
format(query, sizeof(query), "Du hast den Radiosender auf %s gestellt.", temp);
SendClientMessage(playerid, -1, string);
CarRadio[GetPlayerVehicleID(playerid)] = cache_get_field_content_int(0, "id");
} else StopAudioStreamForPlayer(playerid);
}
case DIALOG_RADIO_ADD_NAME: {
if(response) {
if(!strlen(inputtext) || strlen(inputtext) < 6)return SendClientMessage(playerid, 0xAFAFAFFF, "Der Name ist zu kurz."), ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_NAME, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe den Namen des Radios ein.", "Weiter", "Abbruch");
if(strlen(inputtext) > 32)return SendClientMessage(playerid, 0xAFAFAFFF, "Der Name ist zu lang."), ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_NAME, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe den Namen des Radios ein.", "Weiter", "Abbruch");
ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_URL, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe die URL des Radios ein.", "Weiter", "Zurück");
format(CarRadioName[playerid], 32, "%s", inputtext);
mysql_tquery(Handle, query);
}
}
case DIALOG_RADIO_ADD_URL: {
if(response) {
if(!strlen(inputtext) || strlen(inputtext) < 6)return SendClientMessage(playerid, 0xAFAFAFFF, "Die URL ist zu kurz."), ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_URL, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe die URL des Radios ein.", "Weiter", "Zurück");
if(strlen(inputtext) > 128)return SendClientMessage(playerid, 0xAFAFAFFF, "Die URL ist zu lang."), ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_URL, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe die URL des Radios ein.", "Weiter", "Zurück");
format(CarRadioURL[playerid], 128, "%s", inputtext);
format(query, sizeof(query), "Radio Name: %s\nRadio URL: %s\n\nWollen sie die Radiostation hinzufügen?", CarRadioName[playerid], CarRadioURL[playerid]);
ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_CHECK, DIALOG_STYLE_INPUT, "Radio hinzufügen", string, "Ja", "Nein");
mysql_tquery(Handle, query);
}
}
case DIALOG_RADIO_ADD_CHECK: {
if(response) {
format(query, sizeof(query), "INSERT INTO radiostations (`radio_name`, `radio_url`) VALUES ('%s', '%s')", CarRadioName[playerid], CarRadioURL[playerid]);
mysql_tquery(Handle, query);
SendClientMessage(playerid, -1, "Du hast erfolgreich eine Radiostation hinzugefügt.");
#if RADIO_STREAMS_DEBUG == 1
printf("[Radio-System]: %s hat einen Radiosender hinzugefügt.", PlayerName(playerid));
#endif
}
}
case DIALOG_RADIO_MANAGE_LIST: {
if(response) {
ShowPlayerDialog(playerid, DIALOG_RADIO_ADD_NAME, DIALOG_STYLE_INPUT, "Radio hinzufügen", "Gebe den Namen des Radios ein.", "Weiter", "Abbruch");
} else if(!response) {
new start, end;
start = strfind(inputtext, "[");
end = strfind(inputtext, "]");
strdel(inputtext, 0, start+1);
strdel(inputtext, end, strlen(inputtext));
new id = strval(inputtext);
format(query, sizeof(query), "DELETE FROM radiostations WHERE id='%i'", id);
mysql_tquery(Handle, query);
SendClientMessage(playerid, -1, "Du hast erfolgreich einen Radiosender gelöscht.");
#if RADIO_STREAMS_DEBUG == 1
printf("[Radio-System]: %s hat einen Radiosender gelöscht.", PlayerName(playerid));
#endif
}
}
}
return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}

public UserCheck(playerid)
{
new num_rows, num_fields;
cache_get_data(num_rows, num_fields, Handle);
if(num_rows == 0)
{
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
else
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde ein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
}
public OnPasswordResponse(playerid)
{
new num_fields, num_rows;
cache_get_data(num_rows, num_fields);
if(num_rows == 0)
{
SendClientMessage(playerid, -1, "Das Passwort ist inkorrekt.");
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde ein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
else
{
SendClientMessage(playerid, -1, "Erfolgreich eingeloggt.");
SpielerInfo[playerid][pEingeloggt] = true;
SpielerLaden(playerid);
SpawnPlayer(playerid);
}
return 1;
}

stock Spielername(playerid)
{
new name[50];
GetPlayerName(playerid, name, 50);
return name;
}

stock PlayerName(playerid) {
new Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
return Name;
}

stock SpielerLaden(playerid)
{
SpielerInfo[playerid][pEingeloggt] = true;
SpielerInfo[playerid][pGeld] = cache_get_field_content_int(0, "Geld", Handle), GivePlayerMoney(playerid, SpielerInfo[playerid][pGeld]);
SpielerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level", Handle), SetPlayerScore(playerid, SpielerInfo[playerid][pLevel]);
return 1;
}

stock SpielerSpeichern(playerid)
{
new query[256];
if(!SpielerInfo[playerid][pEingeloggt])return 1;
mysql_format(Handle, query, sizeof(query), "UPDATE `samp_database`.`users` SET `Geld`='%i',`Level`='%i' WHERE `username`='%e'", GetPlayerMoney(playerid), GetPlayerScore(playerid), Spielername(playerid)),
mysql_pquery(Handle, query);
return 1;
}

stock CheckTables()
{
new query[256];
mysql_format(Handle, query, sizeof(query), "CREATE TABLE IF NOT EXISTS `radiostations` (`id` int(11) NOT NULL AUTO_INCREMENT,`radio_name` text NOT NULL,`radio_url` text NOT NULL,`radio_active` tinyint(1) NOT NULL DEFAULT '1',PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;", Spielername(playerid));
mysql_pquery(Handle, query);
return 1;
}