Problem Mit Mysql Update
- luiluiboy014
- Geschlossen
- Erledigt
Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!
Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
-
-
Die funktion gibt es nichtmehr, bzw brauchst du sie nichtmehr im neuen Mysql Update. Musst leider einiges Umschreiben Einfaches ersetzen der include und des Plugins reichen nicht.
-
was müste ich alles um stellen für das neue mfg
-
Dumme Frage,
dein komplettes Script.Jeffry hat damals mal ein MySQL TuT veröffentlicht.
Schau da mal rein. -
was müste ich alles um stellen für das neue mfg
Nutz die ältere Version dann musst du es nicht.
-
ich hate version 31 R
und wolte es mit 39-4 updaten
-
Sollte dir weiterhelfen ([wiki]MySQL/R33[/wiki]) alles umzuschreiben das gilt für alle Versionen ab R33
-
ist das ein großer unter schiht mit 31 und 33 version Mfg
was kann ich hier für nehmen mysql_free_result
-
Du kannst dir dieses Tutorial anschauen: http://forum.sa-mp.com/showthread.php?t=337810
Dort gibt es den Punkt "Converting", da ist beschrieben, wie du das umschreiben musst, damit es klappt. -
weil ich beim server restart nur noch das bekomme
Code
Alles anzeigen[15:39:12] [WARNING] CMySQLConnection::Disconnect - no connection available [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:12] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1) [15:39:13] [ERROR] mysql_tquery - invalid connection handle (id: 1)
-
Dann beendest du die Verbindung vor den mysql_tqueries, bzw. hast erst gar keine Verbindung aufgebaut.
-
jetzt bekomme ich nur das hier
[15:52:31] [WARNING] CMySQLHandle::Create - connection already exists
[15:53:05] [WARNING] CMySQLHandle::Create - connection already exists
[15:53:50] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[15:54:29] [WARNING] CMySQLHandle::Create - connection already exists
[15:54:47] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') -
Zu den Warnungen:
Du versuchst mehrmals eine Verbindung zu den gleichen Daten aufzubauen (mysql_connect).Zu den Errors:
Du versuchst einen Cache auszulesen, der nicht existiert. Dazu müsstest du den entsprechenden Code posten, durch den das verursacht wird. -
fragt sich wo der code jetzt ist den der abragen tut hier habe ich nur den mysql_connect schonn mall
Code
Alles anzeigenMySqlConnection = mysql_connect(SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS,3306,true); if(mysql_errno(MySqlConnection) == 0) { 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); } else { print("SERVER: Es konnte keine Verbindung zur Datenbank hergestellt werden!"); print(" Es wird erneut versucht eine Verbindung zur Datenbank herzustellen."); printf("Host: %s,User: %s,Datanbank: %s,Passwort: %s",SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); MySqlConnection = mysql_connect(SQL_HOST,SQL_USER,SQL_DATA,SQL_PASS); if(mysql_errno(MySqlConnection) == 0) { 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); } else { print("SERVER: Es konnte keine Verbindung zur Datenbank hergestellt werden!"); print(" Server wird heruntergefahren ..."); SendRconCommand("exit"); return 1; } }
den anderen code muss ich suchen
Jetzt kommt die meldung
Code[16:13:43] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '13' for key 'PRIMARY' [16:13:43] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0') [16:14:19] [WARNING] CMySQLHandle::Create - connection already exists [16:14:37] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
ich glaube das der fehler hier drine steckt
Code
Alles anzeigenpublic LoadAccount(playerid,pass[],passwortstate) { new query[356],result[25],rows,fields; if(mysql_errno(MySqlConnection) != 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; } cache_get_data(rows,fields); if(rows) { if(passwortstate == 1) { cache_get_field_content(0,"Passwort",result); new tmpp[25]; strmid(tmpp, MD5_Hash(pass), 0, 24, 25); if(!strcmp(/*MD5_Hash(pass)*/tmpp,result,true)) { format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",playerid," ",0); return 1; } format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid)); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); return 1; } cache_get_field_content(0,"Tutorial",result); Spieler[playerid][pViewTutorial] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Admin",result); Spieler[playerid][pAdmin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Verwarnungen",result); Spieler[playerid][pWarns] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FLeaderRechte",result); Spieler[playerid][pLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Fraktion",result); Spieler[playerid][pFraktion] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsRang",result); Spieler[playerid][pFraktRang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsURang",result); Spieler[playerid][pFraktURang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsSperre",result); Spieler[playerid][pFraktionSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionsGehalt",result); Spieler[playerid][pFraktionsGehalt] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Job",result); Spieler[playerid][pJob] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"JobWarns",result); Spieler[playerid][JobWarns] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"JobSperre",result); Spieler[playerid][pJobSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ArbeitslosenGeld",result); Spieler[playerid][pWorkLess] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geschlecht",result); Spieler[playerid][pSex] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"SpielerAlter",result); Spieler[playerid][pYearsOld] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Level",result); SetPlayerLevel(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geld",result); ACMoney(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"GWD",result); Spieler[playerid][pGrundwehrdienst] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Zivinote",result); Spieler[playerid][pZiviNote] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FAbteilung",result); Spieler[playerid][pFraktABTInvite] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bankguthaben",result); Spieler[playerid][pBank] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"BankPin",result); Spieler[playerid][pBankPin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WantedSterne",result); SetPlayerWantedLevel(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WantedPunkte",result); Spieler[playerid][pWantedPoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Suspects",result); Spieler[playerid][pSuspectPoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund1",result); strmid(pWantedReason1[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund2",result); strmid(pWantedReason2[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund3",result); strmid(pWantedReason3[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund4",result); strmid(pWantedReason4[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Wanted_Grund5",result); strmid(pWantedReason5[playerid],result,0,strlen(result),64); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Crimes",result); Spieler[playerid][pLastSuspects] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"STVOcrimes",result); Spieler[playerid][pSTVOpoints] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KampfStyle",result); SetPlayerFightingStyle(playerid,strval(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handy",result); Spieler[playerid][pHandy] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handycoins",result); Spieler[playerid][pHandyCoins] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyStatus",result); Spieler[playerid][pHandystate] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyAkku",result); Spieler[playerid][pHandyakku] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HandyNummer",result); Spieler[playerid][pPhonenumber] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handyflat",result); Spieler[playerid][pHandyFlat] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Handyflatbuyinbiz",result); Spieler[playerid][pHandyBuyByBiz] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_X",result); Spieler[playerid][LastInGamePos_x] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Y",result); Spieler[playerid][LastInGamePos_y] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Z",result); Spieler[playerid][LastInGamePos_z] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_Interior",result); Spieler[playerid][LastInGamePos_int] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Letzte_VirtualWorld",result); Spieler[playerid][LastInGamePos_world] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pSelectHome",result); Spieler[playerid][pSelectHome] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HausMieter",result); Spieler[playerid][pRentHome] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Spawn",result); Spieler[playerid][pSpawn] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Hotel",result); Spieler[playerid][pHotel] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tod",result); Spieler[playerid][pDeath] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_X",result); Spieler[playerid][tot_x] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Y",result); Spieler[playerid][tot_y] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Z",result); Spieler[playerid][tot_z] = floatstr(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_Interior",result); Spieler[playerid][tot_int] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tot_VirtualWorld",result); Spieler[playerid][tot_world] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TotZeit",result); Spieler[playerid][pDeathTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Friedhof",result); Spieler[playerid][pFriedhof] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FriedhofZeit",result); Spieler[playerid][pFriedhofTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ImKnast",result); Spieler[playerid][pJailed] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KnastZeit",result); Spieler[playerid][pJailTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KnastKaution",result); Spieler[playerid][pKaution] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Muted",result); Spieler[playerid][pMuted] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"MuteZeit",result); Spieler[playerid][pMuteTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"ImPrison",result); Spieler[playerid][pInPrison] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PrisonCheckPointsAbgelaufen",result); Spieler[playerid][pPrisonCPsgelaufen] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PrisonCheckPointsGegeben",result); Spieler[playerid][pPrisonCPsgegeben] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Morde",result); Spieler[playerid][pMorde] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Tode",result); Spieler[playerid][pTode] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"SkinID",result); Spieler[playerid][pSkin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"FraktionSkinID",result); Spieler[playerid][pFraktSkin] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallKills",result); Spieler[playerid][pPBKills] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallTode",result); Spieler[playerid][pPBDeaths] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallRang",result); Spieler[playerid][pPBRang] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"PaintBallBesuche",result); Spieler[playerid][pPBVisits] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"AngenommeneReports",result); Spieler[playerid][Reports] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"KopfGeld",result); Spieler[playerid][pHeadMoney] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pWantedDeaths",result); Spieler[playerid][pWantedDeaths] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBuyTickets",result); Spieler[playerid][pBuyTickets] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pJailedCount",result); Spieler[playerid][pJailedCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bankkonto",result); Spieler[playerid][pBankkonto] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyPlaneOrder",result); Spieler[playerid][pArmyPlaneOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyHeliOrder",result); Spieler[playerid][pArmyHeliOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pArmyWaffenOrder",result); Spieler[playerid][pArmyWaffenOrder] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"LevelUPKosten",result); Spieler[playerid][pLevelKosten] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RespectForLevelUp",result); Spieler[playerid][pRespektToLevelUp] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RespectFromPayday",result); Spieler[playerid][pRespektFromPayday] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TimeAfterRegister",result); Spieler[playerid][pTimeAfterRegister] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Time4Payday",result); Spieler[playerid][pMinutesAfterPayday] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"TimeoutCrashExeorKick",result); Spieler[playerid][pAntiOfflineFlucht] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"RpChat",result); Spieler[playerid][pAntiOfflineFlucht] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"HabGeworben",result); Spieler[playerid][HatGeworben] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pPremium",result); Spieler[playerid][pPremium] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"GeworbenerSpieler",result); strmid(Spieler[playerid][GeworbenPlaya],result,0,strlen(result),24); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pScheinSperre",result); Spieler[playerid][pScheinSperre] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"DigiHud",result); Spieler[playerid][DigiHud] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pDHitsound",result); Spieler[playerid][pDHitsound] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Bonus",result); Spieler[playerid][pStartbonus] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Gutschein",result); Spieler[playerid][pGutschein] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pCoins",result); Spieler[playerid][pCoins] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pFirmaLeader",result); Spieler[playerid][pFirmaLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pFirmaMember",result); Spieler[playerid][pFirmaMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pOrgLeader",result); Spieler[playerid][pOrgLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pOrgMember",result); Spieler[playerid][pOrgMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pParteiLeader",result); Spieler[playerid][pParteiLeader] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pParteiMember",result); Spieler[playerid][pParteiMember] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pLohn",result); Spieler[playerid][pLohn] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"WaitPerso",result); Spieler[playerid][WaitPerso] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMarried",result); strmid(Spieler[playerid][pMarried],result,0,strlen(result),sizeof(result)); strdel(result,0,sizeof(result)); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBuyClothes",result); Spieler[playerid][pBuyClothes] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pIll",result); Spieler[playerid][pIll] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pConterminatedTime",result); Spieler[playerid][pConterminatedTime] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBitchSkill",result); Spieler[playerid][pBitchSkill] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pBitchFuckCount",result); Spieler[playerid][pBitchFuckCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMedicHealplayerSkill",result); Spieler[playerid][pMedicHealplayerSkill] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"pMedicHealCount",result); Spieler[playerid][pMedicHealCount] = strval(result); strdel(result,0,sizeof(result)); cache_get_field_content(0,"Geburtstag",result); format(Spieler[playerid][pGeburtstag], 11, result); strdel(result,0,sizeof(result)); new stringlogin[256]; format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_weapons WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountWeapons","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_fish WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountFish","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_koffer WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountKoffer","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_blacklist WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBlacklists","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_inventar WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountInventar","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_licenses WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountLicenses","i",playerid); format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_banksafe WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountBankSafe","i",playerid); for(new slot=0;slot<MAX_PLAYER_VEHS;slot++) { format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_vehicle WHERE name = '%s' AND slot = '%d'",SpielerName(playerid),slot); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccountVehicles","ii",playerid,slot); } mysql_SetInt(""#DATENBANKTAG"_account_main","Online",1,"Name",Spieler[playerid][pName]); AddToAutoLogin(playerid); StopPlayerPlaySound(playerid); PlayerPlaySound(playerid,1188,0.0,0.0,10.0); if(isPlayerAnAdmin(playerid,1)) { format(stringlogin,sizeof(stringlogin),"{FF0000}<< {FFFFFF}%s %s hat sich eingeloggt{FF0000} >>",Adminrang(playerid),SpielerName(playerid)); SendAdminMessage(WEISS,stringlogin); switch(Spieler[playerid][pAdmin]) { case 1: { TextDrawShowForPlayer(playerid,Reportdraw[0]); TextDrawShowForPlayer(playerid,Reportdraw[1]); } case 2,3,4: { TextDrawShowForPlayer(playerid,Reportdraw[0]); TextDrawShowForPlayer(playerid,Reportdraw[1]); TextDrawShowForPlayer(playerid,Reportdraw[2]); } case 5,6,7,8,9: { for(new i=0;i<sizeof(Reportdraw);i++) { TextDrawShowForPlayer(playerid,Reportdraw[i]); } } } format(stringlogin,sizeof(stringlogin),"Art : Login Admin: %s (Adminlevel: %i) * IP: %s - ID/PlayerID : %i",SpielerName(playerid),Spieler[playerid][pAdmin],SpielerIP(playerid),playerid); Log("Admin-Loginsqllog",stringlogin); } if(Spieler[playerid][pKoffer] == 1) SetPlayerAttachedObject(playerid,9,1210,5,0.310000,0.066999,0.000000,0.000000,-91.900009,0.000000,1.000000,1.000000,1.000000); if(Spieler[playerid][pHandy] != 0) { if(Spieler[playerid][pHandystate] == 1 && Spieler[playerid][pHandyakku] > 0.0) { PlayerTextDrawShow(playerid,HandyInfodraw[playerid]); HandyAkku(playerid); AkkuTimer[playerid] = SetTimerEx("HandyAkku",120000,1,"i",playerid); } } if(Spieler[playerid][pFraktion] != 0) { format(stringlogin,sizeof(stringlogin),"{00FFFF}<< Fraktionsmitglied{FF0000} %s {00FFFF}hat sich eingeloggt >>",SpielerName(playerid)); SendFraktionsMessage(Spieler[playerid][pFraktion],HELLBLAU,stringlogin); } format(stringlogin,sizeof(stringlogin),"Name:%s | IP:%s",SpielerName(playerid),SpielerIP(playerid)); Log("Player-Loginsql",stringlogin); if(Spieler[playerid][pViewTutorial] == 0)return ImTutorial[playerid] = 1; TogglePlayerControllable(playerid,1); TogglePlayerSpectating(playerid,0); SpawnPlayerEx(playerid); TextDrawHideForPlayer(playerid,Introdraw[0]); TextDrawHideForPlayer(playerid,Introdraw[1]); format(stringlogin,sizeof(stringlogin),"{A91400}SERVER{FFFFFF}: Willkommen %s",SpielerName(playerid)); SendClientMessage(playerid,WEISS,stringlogin); switch(monat) { case 1:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Januar"); case 2:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Februar"); case 3:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist März"); case 4:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist April"); case 5:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Mai"); case 6:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juni"); case 7:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Juli"); case 8:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist August"); case 9:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist September"); case 10:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Oktober"); case 11:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist November"); case 12:SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Dezember"); } if(tag == 31 && monat == 3) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Sommerzeit hat begonnen"); if(tag == 27 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Die Winterzeit hat begonnen"); if(tag == 31 && monat == 10) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Es ist Halloween"); if(tag == 24 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohe Weihnachten"); if(tag == 31 && monat == 12) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Das neue Jahr steht vor der Tür"); if(tag == 1 && monat == 1) SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Frohes Neues Jahr"); TextDrawShowForPlayer(playerid,Version); TextDrawShowForPlayer(playerid,InfoSign); format(stringlogin,sizeof(stringlogin),"~w~Willkommen ~y~%s",SpielerName(playerid)); PlayerTextDrawSetString(playerid,INFOdraw[playerid][2],stringlogin); StopAudioStreamForPlayer(playerid); PlayAudioStreamForPlayer(playerid,ServerSounds[13],0.0,0.0,0.0); PlayerTextDrawShow(playerid,INFOdraw[playerid][2]); SetTimerEx("HideInfoBox",4000,0,"i",playerid); MakeRace[playerid] = -1; SetPlayerWaffenSkill(playerid); if(!isPlayerInFrakt(playerid,0)) { format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_fraktion_motd WHERE fID='%d'",Spieler[playerid][pFraktion]); mysql_function_query(MySqlConnection,stringlogin,true,"OnQueryFinish","siii",stringlogin,_SQL_FRAKTIONSMOTD_SELECT,playerid,MySqlConnection); } else ShowPlayerDialog(playerid,DIALOG_4ALL_SONSTIGES,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Info","Herzlich Willkommen auf "#SERVERNAME",\nbitte denke immer daran dich an die Regeln zu halten.\nBugs/Fehler im Spiel bitte im Forum melden.\n\nViel Spaß beim spielen!","Verlassen",""); if(GetPlayerLevel(playerid) <= ENABLE_KILLORPAY_BYLEVEL) { format(stringlogin,sizeof(stringlogin),"ACHTUNG: Solltest du als Level %i´er einen Spieler töten,",GetPlayerLevel(playerid)); SendClientMessage(playerid,LEUCHTENDESROT,stringlogin); SendClientMessage(playerid,LEUCHTENDESROT,"wirst du Automatisch vom System gebannt!"); } if(Spieler[playerid][HatGeworben] == 0) { if(GetPlayerLevel(playerid) <= 3) { SendClientMessage(playerid,WEISS,"{A91400}SERVER{FFFFFF}: Niemand hat dich geworben ?"); SendClientMessage(playerid,WEISS,"{FFFFFF} Falls doch Benutze: /geworben."); } else Spieler[playerid][HatGeworben] = 1; } new zeitdauer = gettime()+(60*60*24*7*2);//2 wochen mysql_SetInt(""#DATENBANKTAG"_account_main","PropertyClearTime",zeitdauer,"Name",SpielerName(playerid)); SetPVarInt(playerid,"Eingeloggt",1); OnlinePlayer(playerid,true); printf("LOAD: %s Account hat geladen!",SpielerName(playerid)); } return 1; }
das hier auch
19/01/2016-16:13:43 | errorid=1062,error=Duplicate entry '13' for key 'PRIMARY',query=INSERT INTO onlines (ID, Name) VALUES ('13','luiluiboy014')kann mir da einer helfen mfg lui
-
Die Fehlermeldung scheint mir beim Login (Online-Liste) zu kommen, da dies ein INSERT ist. Genau kann man das der Meldung so aber nicht entnehmen, wann es passiert.
Das musst du im Code suchen. -
das ist alles Was ich an login habe
Code
Alles anzeigenpublic ShowLoginOrRegisterDialog(playerid) { new query[128]; TextDrawHideForPlayer(playerid,Introdraw[2]); TextDrawHideForPlayer(playerid,Introdraw[3]); TextDrawHideForPlayer(playerid,Introdraw[4]); TextDrawHideForPlayer(playerid,Introdraw[5]); SpamChat(playerid,0);// 0 = nur für einen spieler wird der chat kontrolliert 100 zeilen voll gespamt,bei 1 = für alle spieler format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ACCOUNT_CHECK,playerid,MySqlConnection); return 1; }
Codestock AddToAutoLogin(playerid) { new query[128]; format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_autologin WHERE Name='%s' AND IP='%s'",SpielerName(playerid),SpielerIP(playerid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ADDTOAUTOLOGIN,playerid,MySqlConnection); return 1; }
Codecase _SQL_ADDTOAUTOLOGIN: { cache_get_data(rows,fields); if(!rows) { format(query,sizeof(query),"INSERT INTO "#DATENBANKTAG"_account_autologin (`Name`,`IP`) VALUES ('%s','%s')",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,false,"",""); } return 1; }
Code
Alles anzeigencase _SQL_ACCOUNT_AUTOLOGIN: { cache_get_data(rows,fields); if(rows) { new oi = CheckPlayerOfflineInfo(extraid); if(oi != -1) { new time = OfflineInfo[oi][Odeletetime] - gettime(); format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\nDu kannst dich erst in %i:%02d Minuten wieder einloggen.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(extraid),time/60,time%60); ShowPlayerDialog(extraid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); return 1; } SendClientMessage(extraid,WEISS,"{A91400}SERVER{FFFFFF}: Da du dich heute schon einmal mit der gleichen IP eingeloggt hast, wurdest du automatisch eingeloggt."); format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name='%s'",SpielerName(extraid)); mysql_function_query(MySqlConnection,query,true,"LoadAccount","isi",extraid," ",0); } else { SendClientMessage(extraid,GRUEN,"|____ Willkommen auf "#SERVERNAME" ____|"); SendClientMessage(extraid,WEISS,"Dein Name ist bei uns registriert, bitte logge dich ein!"); format(query,sizeof(query),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(extraid)); ShowPlayerDialog(extraid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",query,"Login","Abbrechen"); format(query,sizeof(query),"DELETE FROM "#DATENBANKTAG"_account_autologin WHERE Name = '%s' OR IP = '%s'",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,false,"",""); } return 1; }
Code
Alles anzeigencase _SQL_ACCOUNT_CHECK: { cache_get_data(rows,fields); if(rows) { if(login == true) { SendClientMessage(extraid,BLAU,"Das Einloggen wurde von einem Admin deaktiviert."); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Einloggen deaktiviert - Kick"); } format(query,sizeof(query),"SELECT * FROM "#DATENBANKTAG"_account_autologin WHERE Name='%s' AND IP='%s'",SpielerName(extraid),SpielerIP(extraid)); mysql_function_query(MySqlConnection,query,true,"OnQueryFinish","siii",query,_SQL_ACCOUNT_AUTOLOGIN,extraid,MySqlConnection); } else { if(registration == true) { SendClientMessage(extraid,BLAU,"Die Registration wurde von einem Admin ausgeschaltet."); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Registration deakviert - Kick"); } if(GetRegisteredCount() > MAX_REGISTEREDINSAMETIME) { SendClientMessage(extraid,BLAU,"Verbindung nicht möglich da momentan "#MAX_REGISTEREDINSAMETIME" in der Registrierung sind!"); SendClientMessage(extraid,BLAU,"Versuch es später erneut..."); KickUser(extraid, "System", "Maximale Registrationen - Kick"); } SendClientMessage(extraid,0x00489184,"|____ Willkommen auf "#SERVERNAME" ____|"); SendClientMessage(extraid,WEISS,"Dein Name wurde nicht gefunden,bitte registriere dich!"); ShowPlayerDialog(extraid,DIALOG_REGISTER3,DIALOG_STYLE_MSGBOX,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Willkommen","{C9C9C9}Willkommen auf dem Roleplay Server der "#SERVERFARBE""#SERVERNAME"{C9C9C9} Community.\nDein Account wurde nicht gefunden !\nBitte registriere dich.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}","Registrieren","Verlassen"); } return 1; }
Code
Alles anzeigencase DIALOG_LOGIN: { new stringlogin[256],oi = CheckPlayerOfflineInfo(playerid); if(response == 0)return Kick(playerid); else { StopAudioStreamForPlayer(playerid); PlayAudioStreamForPlayer(playerid,ServerSounds[3],0.0,0.0,0.0); if(oi != -1) { new time = OfflineInfo[oi][Odeletetime] - gettime(); format(stringlogin,sizeof(stringlogin),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\nDu kannst dich erst in %i:%02d Minuten wieder einloggen.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid),time/60,time%60); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",stringlogin,"Login","Abbrechen"); return 1; } if(!strlen(inputtext)) { format(stringlogin,sizeof(stringlogin),"{C9C9C9}Willkommen zurück "#SERVERFARBE"%s {C9C9C9}!\n{C9C9C9}Dein Account ist registriert.\nBitte Logge dich mit deinem entsprechendem Passwort ein.\n\n"#SERVERFARBE"** "#SERVERNAME" **{C9C9C9}",SpielerName(playerid)); ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,""#SERVERFARBE""#SERVERNAME"{FFFFFF}: Login",stringlogin,"Login","Abbrechen"); return 1; } format(stringlogin,sizeof(stringlogin),"SELECT * FROM "#DATENBANKTAG"_account_main WHERE Name = '%s'",SpielerName(playerid)); mysql_function_query(MySqlConnection,stringlogin,true,"LoadAccount","isi",playerid,inputtext,1); } return 1; }
-
Suche danach:
INSERT INTO onlines (ID, Name) VALUES -
stock OnlinePlayer(playerid,bool:player)
{
new query[250];
if(player == true)
{
format(query,sizeof(query),"INSERT INTO onlines (ID, Name) VALUES ('%d','%s')",playerid,Spieler[playerid][pName]);
mysql_function_query(MySqlConnection,query,false,"","");
}
else if(player == false)
{
format(query,sizeof(query),"DELETE FROM onlines WHERE ID = '%d'",playerid);
mysql_function_query(MySqlConnection,query,false,"","");
}
return 1;
} -
format(query,sizeof(query),"INSERT INTO onlines (ID, Name) VALUES ('%d','%s')",playerid,Spieler[playerid][pName]);
zu:
format(query,sizeof(query),"INSERT INTO onlines (ID, Name) VALUES ('%d','%s') ON DUPLICATE KEY UPDATE Name='%s'",playerid,Spieler[playerid][pName],Spieler[playerid][pName]);Dann sollte der Fehler weg sein.
-