Beiträge von Hagz

    Hey liebe Community,
    ist es möglich mysql_tquery zu benutzen ohne das man gleich einen Callback erstellen muss?


    Hier mal mein Stock:


    stock SpielerUpdaten(playerid)
    {
    new query[128];
    mysql_format(dbhandle,query,sizeof(query),"UPDATE `Accounts` SET `Level` = '%d', `Admin` = '%d', `Geld` = '%d', `Filliale` = '%d', `Bank` = '%d', `Leader` = '%d', `Member` = '%d', `Job` = '%d', `Bankkarte` = '%d' WHERE `Name` = %e",GetPlayerScore(playerid),pDaten[playerid][Admin],GetPlayerMoney(playerid),pDaten[playerid][Filliale],pDaten[playerid][Bank],pDaten[playerid][Leader],pDaten[playerid][Member],pDaten[playerid][Job],pDaten[playerid][Bankkarte]);
    return 1;
    }


    Dort fehlt aber noch das der Query abgesendet wird mit tquery. Aber man muss ja immer ein Callback erstellen. Wie mach ich das ohne?


    Uff zu viele Errors, kannst du mir eventuell per Teamviewer helfen?

    1.) Du nutzt localhost, nicht 127.0.0.1
    2.) Du nutzt ein Passwort. Hast du es selbst in deiner Datenbank geändert oder hast du den root Benutzer nicht angefasst?


    => Kann es sein, dass du im falschen Code werkelst, oder den falschen Server startest?


    #define dbhost "127.0.0.1"
    #define dbuser "root"
    #define dbdb "samp2"
    #define dbpw ""



    Würde auch hilfe über TeamViewer aktzeptieren.
    Ich möchte nur ein Script ausprobieren, sprich dieses ist nicht meins.

    Wenn er den "root" Benutzer anspricht, dann darf er kein Passwort eingeben. Das habe ich explizit betont.
    Außer er ändert das Passwort, aber das wird er ja wohl nicht innerhalb einer Minute vergessen.


    Hagz:
    Hast du Zugriff, wenn du anstatt "localhost" die lokale IP nimmst, also "127.0.0.1"?
    Wenn nein, poste bitte nochmal die Meldung die dann kommt.


    Hier die Error die ich dann bekomme ( mit 127.0.0.1 :(


    [Thu Oct 09 17:29:17 2014] Logging Started
    [Thu Oct 09 17:29:17 2014] -------------------------
    [Thu Oct 09 17:29:17 2014] Function: mysql_init executed with result: "2".
    [Thu Oct 09 17:29:17 2014] Error (0): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (1): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (2): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (3): Failed to connect. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (1): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (2): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (3): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_query called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_store_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_fetch_field called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES).
    [Thu Oct 09 17:29:17 2014] Error (0): Function: mysql_free_result called when not connected to any database. Access denied for user 'root'@'localhost' (using password: YES)


    Nur ein kleiner Teil .btw

    Hey liebe Community,
    habe nun schon seit einer Stunde versucht das Problem zu beheben und habe mich auch vorher im Forum mit der SuFu erkundigt aber leider ohne Erfolg.


    Jedes mal wenn ich den Server starte bekomme ich volgenden Error:


    1): Function: mysql_query called when not connected to any database. Access denied for user 'SampUser'@'localhost' (using password: YES).


    Wäre cool wenn mir jemand per Teamviewer helfen würde :)


    MfG

    Ich bevorzuge MM und Saturn aus dem Grund da ich das Headset gleich umtauschen gehe und einen Gutschein für MM erhalte mit dem Wert des Headsets . Meines Erachtens kann man MM Gutscheine auch bei Saturn eintauschen.