Problem mit Server

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
  • Ja ist ein. bin gerade selber im Script drinnen alles mit mysql verbunden


    //E:



    PUBLIC:OnPlayerRegister(playerid, password[])
    {
    StuffInfo[sNeuUser] += 1;
    if(IsPlayerConnected(playerid))
    {
    new string[128],
    playername[MAX_PLAYER_NAME];


    GetPlayerName(playerid, playername, sizeof(playername));


    strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255);
    format(string, sizeof(string), "INSERT INTO `users` (`Name`, `Password`) VALUES ('%s', '%s')", playername, GeneratePassword(password));
    self_mysql_queryEx(string);


    PlayerInfo[playerid][pSQLID] = mysql_insert_id();
    format(string, sizeof(string), "UPDATE `users` SET `RegisterDatum`='%d' WHERE `Name`='%s'", Time(), playername);


    self_mysql_queryEx(string);


    PlayerInfo[playerid][pChar] = 26;
    gOoc[playerid] = 0;
    PlayerInfo[playerid][pReg] = 1;
    PlayerInfo[playerid][pAlter] = 0;
    PlayerInfo[playerid][pTut] = 0;
    PlayerInfo[playerid][pLevel] = 1;
    PlayerInfo[playerid][pSHealth] = 50.0;
    StuffInfo[sLastNumber] += 1;
    PlayerInfo[playerid][pNummer] = StuffInfo[sLastNumber];
    PlayerInfo[playerid][pBizKey] = -1;
    PlayerInfo[playerid][pBank] = 0;
    GivePlayerMoneys(playerid, 5000);
    PlayerInfo[playerid][pCrimes] = 0;
    PlayerInfo[playerid][pArrested] = 0;
    PlayerInfo[playerid][pArrestTime] = 0;
    PlayerInfo[playerid][pKills] = 0;
    PlayerInfo[playerid][psKills] = 0;
    PlayerInfo[playerid][pDeaths] = 0;
    PlayerInfo[playerid][pMember] = -1;
    PlayerInfo[playerid][pLeader] = -1;
    PlayerInfo[playerid][pOnDutySkin] = 60;
    PlayerInfo[playerid][pPistolSkill] = 2;
    PlayerInfo[playerid][pMaschinePistolSkill] = 2;
    PlayerInfo[playerid][pSturmgewehrPistolSkill] = 2;
    PlayerInfo[playerid][pShotGunSkill] = 1;
    /*Scheine*/
    PlayerInfo[playerid][pGunLic] = 0;
    PlayerInfo[playerid][pFlyLic] = 0;
    PlayerInfo[playerid][pCarLic] = 0;
    PlayerInfo[playerid][pBikeLic] = 0;
    PlayerInfo[playerid][pCPTUT] = 0;
    PlayerInfo[playerid][pKHTIME] = 0;


    PlayerUpdate(playerid);
    }
    return 1;
    }

  • Für mich hast du keine Mysql Verbindung, deswegen kannst du dich nicht Registrieren ;)


    Es kann auch nicht sein das dort keine log ist... da muss eine .txt sein.


  • ////////////////////////////////////////////
    #define MySQL_Host "87.98.244.35" //
    #define MySQL_User "ni272727_1_DB" //
    #define MySQL_Passwort "dPEwmkA3" //
    #define MySQL_DB "ni272727_1_DB" //



    ////////////////////////////////////////////


    hab die Server IP mal angepasst..
    Aber findet keine Verbindung scheinbar..


  • ////////////////////////////////////////////
    #define MySQL_Host "87.98.243.201" //
    #define MySQL_User "samp6046" //
    #define MySQL_Passwort "GermanElite" //
    #define MySQL_DB "ni272727_1_DB" //
    ////////////////////////////////////////////



    Habe ich geht trd nicht -.-

  • Poste mal den Teil wo du dich mit der Datenbank verbindest.
    Also den Abschnitt mit mysql_connect o.ä.
    Eine Log legt er nur an meines Wissens wenn es einen Fehler gibt.
    (E: Ok mit Ausnahme der DebugModus ist an)


    Kannst unter OnGameMode mal schauen und sofern nicht vorhanden
    mysql_debug(1);
    mal einfügen und dann den Server mal starten.
    Dann sollte im Server Ordner eine MySQL Log sein.


    Und bitte ändere dein PW und den Namen sollte das kein abgeänderter Zugang sein.
    Nicht das ein andere sich jetzt schön in deiner DB austoben kann.

    „Auge um Auge - und die ganze Welt wird blind sein.“
    - Mahatma Gandhi

    Einmal editiert, zuletzt von Dog ()

  • Versuche mal bei MySQL host localhost einzutragen, hatte auch mal ein Server bei samp4you und das gleiche Problem.

  • http://www.file-upload.net/dow…012252/mysql_log.txt.html



    //E:



    ----------
    Loaded log file: "server_log.txt".
    ----------


    SA-MP Dedicated Server
    ----------------------
    v0.3.7-R2, (C)2005-2015 SA-MP Team


    [12:40:32] mapname = "San Andreas" (string)
    [12:40:32]
    [12:40:32] Server Plugins
    [12:40:32] --------------
    [12:40:32] Loading plugin: mysql.so
    [12:40:32]


    > MySQL plugin R5 successfully loaded.


    [12:40:32] Loaded.
    [12:40:32] Loading plugin: streamer.so
    [12:40:32]


    *** Streamer Plugin v2.8.2 by Incognito loaded ***


    [12:40:32] Loaded.
    [12:40:32] Loading plugin: nativechecker.so
    [12:40:32] Loaded.
    [12:40:32] Loading plugin: sscanf.so
    [12:40:32]


    [12:40:32] ===============================


    [12:40:32] sscanf plugin loaded.


    [12:40:32] Version: 2.8.1


    [12:40:32] (c) 2012 Alex "Y_Less" Cole


    [12:40:32] ===============================


    [12:40:32] Loaded.
    [12:40:32] Loading plugin: filemanager.so
    [12:40:32] ******************
    [12:40:32] ** FILE MANAGER **
    [12:40:32] ** Loaded **
    [12:40:32] ** Version 1.1 **
    [12:40:32] ******************
    [12:40:32] Loaded.
    [12:40:32] Loaded 5 plugins.


    [12:40:32]
    [12:40:32] Ban list
    [12:40:32] --------
    [12:40:32] Loaded: samp.ban
    [12:40:32]
    [12:40:32]
    [12:40:32] Filterscripts
    [12:40:32] ---------------
    [12:40:32] Loaded 0 filterscripts.


    [12:40:32] Error: Function not registered: 'SSCANF_Init'
    [12:40:32] Error: Function not registered: 'SSCANF_Join'
    [12:40:32] Error: Function not registered: 'SSCANF_Leave'
    [12:40:32] Error: Function not registered: 'sscanf'
    [12:40:32] Error: Function not registered: 'dir_exists'
    [12:40:32] Error: Function not registered: 'dir_create'
    [12:40:32] Error: Function not registered: 'file_write'
    [12:40:32] SERVER: Der Server wurde erfolgreich gestartet
    [12:40:32] SERVER: Versucht die Verbindung zur Datenbank aufzubauen
    [12:40:32] OnGamemodeInt: LoadBiz (3ms)
    [12:40:32] OnGamemodeInt: LoadSBiz (4ms)
    [12:40:32] OnGamemodeInt: LoadTankenBiz (13ms)
    [12:40:32] OnGamemodeInt: LoadStuff (5ms)
    [12:40:32] OnGamemodeInt: LoadKassenInfo (0ms)
    [12:40:32] OnGamemodeInt: LoadGangfightZones (0ms)
    [12:40:32] OnGamemodeInt: LoadGangWarInfos (18ms)
    [12:40:32] OnGamemodeInt: LoadGangBNDInfos (1ms)
    [12:40:32] OnGamemodeInt: LoadHauser (0ms)
    [12:40:32] OnGamemodeInt: loadDynamicPickups (0ms)
    [12:40:32] OnGamemodeInt: loadDynamicMapIcons (0ms)
    [12:40:32] OnGamemodeInt: loadDynamicTextLabels (0ms)
    [12:40:32] OnGamemodeInt: loadGangWeapons (0ms)
    [12:40:32] OnGamemodeInt: loadAmmuWeapons (0ms)
    [12:40:32] OnGamemodeInt: loadHausWeapons (0ms)
    [12:40:32] OnGamemodeInt: LoadFactionVehicles (1ms)
    [12:40:32] Totaltime taken to load MySQL Stuffs: 45sm
    [12:40:32] Beginne Autos zu spawnen
    [12:40:32] Autos wurden erfolgreich Geladen und Gespawnt
    [12:40:32] 3DTexte erfolgreich Geladen
    [12:40:32]
    [12:40:32]
    [12:40:32] Westbound-Reallife
    [12:40:32] _____________________
    [12:40:32] Westbound-Reallife erfolgreich geladen!
    [12:40:32]
    [12:40:32] Number of vehicle models: 61
    [12:40:32] [connection] 87.98.244.35:54783 requests connection cookie.
    [12:40:32] [connection] 87.98.244.35:44148 requests connection cookie.
    [12:40:32] [connection] 87.98.244.35:48969 requests connection cookie.
    [12:40:32] [connection] 87.98.244.35:35231 requests connection cookie.
    [12:40:32] [connection] 87.98.244.35:36682 requests connection cookie.
    [12:40:33] [connection] 87.98.244.35:55559 requests connection cookie.
    [12:40:33] [connection] 87.98.244.35:41933 requests connection cookie.
    [12:40:33] [connection] 87.98.244.35:59893 requests connection cookie.
    [12:40:33] [connection] incoming connection: 87.98.244.35:54783 id: 0
    [12:40:33] [connection] incoming connection: 87.98.244.35:44148 id: 1
    [12:40:33] [connection] incoming connection: 87.98.244.35:48969 id: 2
    [12:40:33] [npc:join] Drogendealer has joined the server (0:87.98.244.35)
    [12:40:33] [npc:join] Mitarbeiter has joined the server (1:87.98.244.35)
    [12:40:33] [connection] incoming connection: 87.98.244.35:35231 id: 3
    [12:40:33] [connection] incoming connection: 87.98.244.35:36682 id: 4
    [12:40:33] [npc:join] Coinshop has joined the server (2:87.98.244.35)
    [12:40:34] [connection] incoming connection: 87.98.244.35:55559 id: 5
    [12:40:34] [npc:join] Stadthalle has joined the server (3:87.98.244.35)
    [12:40:34] [connection] incoming connection: 87.98.244.35:41933 id: 6
    [12:40:34] [npc:join] BSN has joined the server (4:87.98.244.35)
    [12:40:34] [connection] incoming connection: 87.98.244.35:59893 id: 7
    [12:40:34] [npc:join] Dimitri has joined the server (5:87.98.244.35)
    [12:40:34] [npc:join] Manfred has joined the server (6:87.98.244.35)
    [12:40:34] [npc:join] Nico has joined the server (7:87.98.244.35)