Beiträge von RedStyle

    Jo nur mit dem Tut von Maddin kann ich nix Anfangen. Es ist einfach nur das Problem das immer kommt das ich einen Account habe, dabei in der Datenbank kein Account mit dem User existiert!


    //EDIT: Connection war tot und es konnte nicht funktionieren :)
    Nächstes Prob. Register Dialog will nichts machen:
    case DIALOG_REGISTER:
    {
    if(!response)
    {
    Kick(playerid);
    }
    else
    {
    if(!strlen(inputtext) || strlen(inputtext) >= 21)
    {
    Kick(playerid);
    }
    else
    {
    printf("");
    new query[500], name[25], escname[25], pip[25];
    GetPlayerName(playerid, name, sizeof name);
    mysql_real_escape_string(name, escname);
    new passwort[20];
    mysql_real_escape_string(inputtext, passwort);
    format(query, sizeof query, "INSERT INTO Spieler (Passwort,User,Adminlevel) VALUES ('%s','%s',0)",passwort,escname);
    mysql_query(query);
    GameTextForPlayer(playerid, "~g~Endlich hat es geklappt!!", 5000, 3);
    Login[playerid] = true;
    }
    }
    }

    Mahlzeit Community :)
    Wenn ich es auf dem Windows Server teste, klappt alles. Wenn ich es aber auf dem Linux Server klatsche, kommt immer Login obwohl der Account nichtmal in der Datenbank ist.


    Info: Ich benutze das R5 Plugin von BlueG auf den 0.3e Server.


    Code:
    public OnPlayerConnect(playerid)
    {
    new string[256], name[MAX_PLAYER_NAME], r_name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof name);
    mysql_real_escape_string(name, r_name);
    format(string, sizeof string, "SELECT * FROM `Spieler` WHERE `User` ='%s'", r_name);
    mysql_query(string);
    mysql_store_result();
    if(mysql_num_rows())
    {
    // LOGIN
    mysql_fetch_row_format(string, "|");
    sscanf(string, "e<p<|>is[25]s[20]iiiii>", sSpieler[playerid]); // bearbeiten
    mysql_free_result();
    new dialog[300];
    strcat(dialog, "Willkommen auf dem Stunt And Dm Server\n", 300);
    strcat(dialog, "Du musst dich Einloggen um Spielen zu können!", 300);
    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "!Welcome Back!", dialog, "Login", "Cancel");
    }
    else
    {
    // REGISTER
    mysql_free_result();
    new dialog[300];
    strcat(dialog, "Willkommen auf dem Stunt And Dm Server\n", 300);
    strcat(dialog, "Du musst dich Regestrieren um Spielen zu können!", 300);
    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Wilkommen", dialog, "Register", "Cancel");
    }
    }


    Ps: Datenbanken sind richtig und die Debug Datei spuckt auch keine Fehlers oder sonstiges aus.
    Connecten tut er auch :)


    Hoffe es kann mir wer helfen,


    MFG: R3DSty3e

    Naja Danke, aber ich hab es mal neu geschrieben, und es funktioniert noch immer nicht :) Hoffe es kann einer helfen


    new xCharacters[][] =
    {
    "A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M",
    "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z",
    "a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m",
    "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z",
    "0", "1", "2", "3", "4", "5", "6", "7", "8", "9"
    }


    public OnPlayerText(playerid, text[])
    {
    switch(xTestBusy)
    {
    case true:
    {
    if(text[0] == '!' && !strcmp(xChars, text[1], false))
    {
    new string[128], pName[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pName, sizeof(pName));
    format(string, sizeof(string), "« \%s\" hat den Reaktionstest gewonnen. »", pName);
    SendClientMessageToAll(GREEN, string);
    format(string, sizeof(string), "« Du hast $%d + %d score bekommen. »", xCash, xScore);
    SendClientMessage(playerid, GREEN, string);
    GivePlayerMoney(playerid, xCash);
    SetPlayerScore(playerid, GetPlayerScore(playerid) + xScore);
    xReactionTimer = SetTimer("xReactionTest", TIME, 1);
    xTestBusy = false;
    }
    }
    }
    return 1;
    }
    function xReactionTest()
    {
    new
    xLength = (random(8) + 2),
    string[128]
    ;
    xCash = (random(10000) + 20000);
    xScore = (random(2)+1);
    format(xChars, sizeof(xChars), "");
    Loop(x, xLength) format(xChars, sizeof(xChars), "%s%s", xChars, xCharacters[random(sizeof(xCharacters))][0]);
    format(string, sizeof(string), "« Wer als erstes !%s eintippt, gewinnt $%d + %d score! »", xChars, xCash, xScore);
    SendClientMessageToAll(PURPLE, string);
    KillTimer(xReactionTimer);
    xTestBusy = true;
    SetTimer("xReactionProgress", 30000, 0);
    return 1;
    }


    will einfach nicht gehen ?

    Hallo Community.
    Kann mir einer sagen warum das nicht funktionieren will ?
    wenn ich nur ! eingeb kommt das ich den test gewonnen hab, obwohl die Veriable gefüllt ist!
    Hab ich irgendwo einen kleinen fehler gemacht ?


    Hoffe um schnelle rückmeldung:


    Code.
    public OnPlayerText(playerid, text[])
    {
    if(text[0] == '!' && ReactionState == true)
    {
    if(!strcmp(text[1],Reaction_code, false))
    {
    new string[128], name[25];
    GetPlayerName(playerid, name, sizeof name);
    format(string ,sizeof string, ""H_COLOR_ORANGE"[Reaction] "H_COLOR_RED"%s "H_COLOR_BLUE"hat den Reactionstest gewonnen! Neuer Test startet in 2 Minuten!", name);
    SendClientMessageToAll(COLOR_WHITE, string);
    pInfo[playerid][Geld] += Reaction_Money;
    pInfo[playerid][Score] += Reaction_Score;
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid, pInfo[playerid][Geld]);
    SetPlayerScore(playerid, pInfo[playerid][Score]);
    ReactionState = false;
    KillTimer(Reaction_Timer2);
    SetTimer("sReaction", Reaction_Timer, false);
    return 0;
    }
    else return 0;
    }
    return 1;
    }


    Mfg: RedStyle

    Script[gamemodes/mr-reallife.amx]: Run time error 19: "File or function is not f
    ound"[


    Nunja...
    Alles auf dem neusten Stand, Includes gescheckt... usw...
    Stellt sich nur die Frage warum es nicht geht....


    Hat jemand ne Lösung oder das selbe Problem?


    Plugins geladen ?

    Nabend Leute.
    Seit langen hab ich mir gedacht ich mach einen neuen Server auf.
    Doch wenn ich etwas mit mysql_query machen will kommt undefined symbol mysql_query, waru, ?


    Script:
    #include <a_samp>
    #include <a_mysql>


    //==============
    //== Defines ==
    #define SERVER_CREATOR "d,"
    #define SERVER_VERSION "0.01"
    #define SERVER_CONFIG "Server/System/Config.ini"
    #define SERVER_LOG_PATH "Server/Benutzers/%s.ini"


    #define MYSQL_HOST "host"
    #define MYSQL_USER "user"
    #define MYSQL_PASS "pw"
    #define MYSQL_DATA "db"
    #define DIALOG_LOGIN 1
    #define DIALOG_REGISTER 2
    #define DIALOG_INFO 3


    enum SpielerDaten
    {
    ID,
    IP[20],
    Passwort[20],
    Geld,
    Admin,
    Banned,
    VIP,
    Kills,
    Deaths,
    Warns,
    Muted,
    };


    new pInfo[MAX_PLAYERS][SpielerDaten];
    new bool:Login[MAX_PLAYERS] = false;
    new OnlineCounter = 0;


    //===============
    //== Forwards ==


    forward SaveAccount(playerid);
    public SaveAccount(playerid)
    {
    new name[MAX_PLAYER_NAME], Query[500];
    GetPlayerName(playerid, name, sizeof name);
    new realname[MAX_PLAYER_NAME];
    mysql_real_escape_string(name,realname);
    format(Query, sizeof Query, "SELECT * FROM `Users` WHERE Nick = '%s'", realname);
    mysql_store_result();
    if(mysql_num_rows())
    {
    if(Login[playerid] == true)
    {
    new pip[25];
    GetPlayerIp(playerid,pip, sizeof pip);
    format(Query, sizeof Query, "UPDATE `Users` SET ´IP´ = '%s' WHERE Nick = '%s'",pip,realname);
    mysql_query("");
    }
    }
    return 1;
    }


    forward LoadAccount(playerid);
    public LoadAccount(playerid)
    {
    //
    return 1;
    }


    main()
    {
    print("GameMode wird geladen . . .");
    printf("GameMode wurde von %s ersteltt.",SERVER_CREATOR);
    printf("Version: %s",SERVER_VERSION);
    }


    public OnGameModeInit()
    {
    mysql_debug(1);
    mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DATA,MYSQL_PASS);
    SetGameModeText("8");
    return 1;
    }


    public OnGameModeExit()
    {
    for(new i = 0; i < MAX_PLAYERS; i++)
    {
    if(!IsPlayerConnected(i)) continue;
    {
    pInfo[i][ID] = 0;
    pInfo[i][Passwort] = 0;
    pInfo[i][Geld] = 0;
    pInfo[i][Admin] = 0;
    pInfo[i][Banned] = 0;
    pInfo[i][VIP] = 0;
    pInfo[i][Kills] = 0;
    pInfo[i][Deaths] = 0;
    pInfo[i][Warns] = 0;
    pInfo[i][Muted] = 0;
    OnlineCounter--;
    SaveAccount(i);
    Login[i] = false;
    }
    }
    mysql_close();
    return 1;
    }


    public OnPlayerRequestClass(playerid, classid)
    {
    return 1;
    }


    public OnPlayerConnect(playerid)
    {
    if(!IsPlayerNPC(playerid)) { OnlineCounter++; }
    else return Kick(playerid);
    return 1;
    }


    public OnPlayerDisconnect(playerid, reason)
    {
    Login[playerid] = false;
    OnlineCounter--;
    if(!IsPlayerNPC(playerid))
    {
    pInfo[playerid][ID] = 0;
    pInfo[playerid][Passwort] = 0;
    pInfo[playerid][Geld] = 0;
    pInfo[playerid][Admin] = 0;
    pInfo[playerid][Banned] = 0;
    pInfo[playerid][VIP] = 0;
    pInfo[playerid][Kills] = 0;
    pInfo[playerid][Deaths] = 0;
    pInfo[playerid][Warns] = 0;
    pInfo[playerid][Muted] = 0;
    SaveAccount(playerid);
    }
    return 1;
    }


    public OnPlayerSpawn(playerid)
    {
    return 1;
    }


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


    public OnVehicleSpawn(vehicleid)
    {
    return 1;
    }


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


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


    public OnPlayerCommandText(playerid, cmdtext[])
    {
    return 0;
    }


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


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


    public OnPlayerStateChange(playerid, newstate, oldstate)
    {
    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[])
    {
    return 1;
    }


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


    a_mysql include:
    /**
    * MySQL plugin R7
    * Copyright (c) 2008-2011, BlueG
    */


    #if defined mysql_included
    #endinput
    #endif
    #define mysql_included


    /**
    * Common error codes
    *
    * Client: http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html
    * Server: http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html
    *
    */


    #define ER_DBACCESS_DENIED_ERROR 1044
    #define ER_ACCESS_DENIED_ERROR 1045
    #define ER_UNKNOWN_TABLE 1109
    #define ER_SYNTAX_ERROR 1149
    #define CR_SERVER_GONE_ERROR 2006
    #define CR_SERVER_LOST 2013
    #define CR_COMMAND_OUT_OF_SYNC 2014
    #define CR_SERVER_LOST_EXTENDED 2055


    // Native functions


    #define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
    #define mysql_next_row() mysql_retrieve_row()
    #define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)


    #define mysql_query_callback(%1,%2,%3,%4,%5) \
    mysql_function_query(%5, %2, false, %3, "siii", %2, %1, %4, %5)


    #define mysql_query(%1,%2,%3,%4) \
    mysql_function_query(%4, %1, false, "OnQueryFinish", "siii", %1, %2, %3, %4)



    native mysql_affected_rows(connectionHandle = 1);
    native mysql_close(connectionHandle = 1);
    native mysql_connect(const host[], const user[], const database[], const password[], port = 3306);
    native mysql_data_seek(offset, connectionHandle = 1);
    native mysql_debug(enable = 1);
    native mysql_errno(connectionHandle = 1);
    native mysql_fetch_field(number, dest[], connectionHandle = 1);
    native mysql_fetch_field_row(string[], const fieldname[], connectionHandle = 1);
    native mysql_fetch_row_format(string[], const delimiter[] = "|", connectionHandle = 1);
    native mysql_format(connectionHandle, output[], format[], {Float,_}:...);
    native mysql_field_count(connectionHandle = 1);
    native mysql_free_result(connectionHandle = 1);
    native mysql_get_charset(destination[], connectionHandle = 1);
    native mysql_insert_id(connectionHandle = 1);
    native mysql_num_rows(connectionHandle = 1);
    native mysql_num_fields(connectionHandle = 1);
    native mysql_ping(connectionHandle = 1);
    native mysql_real_escape_string(const source[], destination[], connectionHandle = 1);
    native mysql_reconnect(connectionHandle = 1);
    native mysql_reload(connectionHandle = 1);
    native mysql_retrieve_row(connectionHandle = 1);
    native mysql_set_charset(charset[], connectionHandle = 1);
    native mysql_stat(const destination[], connectionHandle = 1);
    native mysql_store_result(connectionHandle = 1);
    native mysql_warning_count(connectionHandle = 1);


    // Cache functions


    native mysql_function_query(connectionHandle, query[], bool:cache, callback[], format[], {Float,_}:...);
    native cache_get_row(row, idx, dest[], connectionHandle = 1);
    native cache_get_field(field_index, dest[], connectionHandle = 1);
    native cache_get_data(&num_rows, &num_fields, connectionHandle = 1);
    native cache_get_field_content(row, const field_name[], dest[], connectionHandle = 1);
    native enable_mutex(bool:enable);


    // forward declarations


    forward OnQueryError(errorid, error[], callback[], query[], connectionHandle);


    Hoffe mir kann einer helfen 8|

    Konnte mir leider nicht weiterhelfen.

    Code
    [23:43:44] Incoming connection: iP
    [23:43:44] [join] RedStyle has joined the server (0:xxx.xxx.xxx.xxx)
    [23:43:45] *** Streamer_SetIntData: Invalid ID specified
    [23:44:00] __________________________________________
    [23:44:00] [USERINFO(LOGIN)]:User RedStyle hat sich eingeloggt[23:44:0 Uhr]
    [23:44:00] __________________________________________
    [23:44:00] [USERINFO(LOGOUT)]:User hat sich ausgeloggt[23:44:0 Uhr]
    [23:44:00] __________________________________________
    [23:44:00] [part] RedStyle has left the server (0:2)


    Immer wenn ich mich einlogge kommt das.
    Ich benutze SA-MP 0.3d R2 auf einem Linux Root

    Problem gelöst ^^ Meine Schuld


    public OnGameModeInit()
    {
    SetGameModeText("Stunt~DM~Freeroam");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    return CallLocalFunction("Test", "");
    }


    #if defined _ALS_OnGameModeInit
    #undef OnGameModeInit
    #else
    #define _ALS_OnGameModeInit
    #endif


    #define OnGameModeInit Test
    forward Test();


    public Test()
    {
    print("Server ist ausgegangen wegen einem Test");
    SendRconCommand("exit");
    return 1;
    }

    Hallo Community.
    Ich wollte mich mal an Funktionen replacen üben.
    Nur passiert bei mir nichts. Wieso ?


    #if defined _ALS_OnGameModeInit
    #undef OnGameModeInit
    #else
    #define _ALS_OnGameModeInit
    #endif


    #define OnGameModeInit Test
    #pragma unused ServerState


    forward Test();
    public Test()
    {
    print("Server shuting down for a test!");
    SendRconCommand("exit");
    return 1;
    }


    Wenn ich Server z.B Starte passiert rein garnichts.
    Habe es unter OnGameModeInit ^^
    Also unter dem CallBack


    Hoffe es kann mir einer Helfen!

    geht auch ohne timer! brauchst nur onplayerstreamedin und onplayerstreamedout


    ganz oben hin


    [pwn]new PlayerText3D:Stats[MAX_PLAYERS];[/pwn]
    hier mal mein code ^^ muss deine wünschen entsprechend gemacht werden und player verriablen changen!
    erstell verriable Spawn[MAX_PLAYERS];
    und setz sie bei death / connect / spawn 1 = spawned 0 = nicht gespawnt


    public OnPlayerStreamIn(playerid, forplayerid)
    {
    if(Acc[forplayerid][Adminlevel]>1)
    {
    if(Spawn[playerid] == 1)
    {
    new info[256],IP[20],Name[24];
    GetPlayerIp(playerid, IP,sizeof IP);
    GetPlayerName(playerid, Name, sizeof Name);
    format(info, sizeof info,""ORANGE"Nickname: %s | Ip: %s\nGeld: %d | Score: %d\nAdminlevel: %d\nKills: %d | Deaths: %d",Name,IP,GetPlayerMoney(playerid),GetPlayerScore(playerid),Acc[playerid][Adminlevel],Acc[playerid][Kills],Acc[playerid][Deaths]);
    Stats[playerid] = CreatePlayer3DTextLabel(forplayerid,info,0xFFFFFF,0.0,0.0,-3.0,70.0,playerid);
    }
    }
    return 1;
    }


    public OnPlayerStreamOut(playerid, forplayerid)
    {
    if(Acc[playerid][Adminlevel]>1)
    {
    if(Spawn[playerid] == 1)
    {
    DeletePlayer3DTextLabel(playerid,Stats[playerid]);
    }
    }
    return 1;
    }