Beiträge von Mr.Datenbank

  • Mysql fehler

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


    [23:56:10] filterscripts = "" (string)
    [23:56:10]
    [23:56:10] Server Plugins
    [23:56:10] --------------
    [23:56:10] Loading plugin: streamer.so
    [23:56:10]


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


    [23:56:10] Loaded.
    [23:56:10] Loading plugin: mysql.so
    [23:56:10]


    > MySQL plugin R5 successfully loaded.


    [23:56:10] Loaded.
    [23:56:10] Loading plugin: sscanf.so
    [23:56:10]


    [23:56:10] ===============================


    [23:56:10] sscanf plugin loaded.


    [23:56:10] (c) 2009 Alex "Y_Less" Cole


    [23:56:10] ===============================


    [23:56:10] Loaded.
    [23:56:10] Loading plugin: crashdetect.so
    [23:56:10] CrashDetect v4.13.1-lse is OK.
    [23:56:10] Loaded.
    [23:56:10] Loaded 4 plugins.


    [23:56:10]
    [23:56:10] Ban list
    [23:56:10] --------
    [23:56:10] Loaded: samp.ban
    [23:56:10]
    [23:56:10]
    [23:56:10] Filterscripts
    [23:56:10] ---------------
    [23:56:10] Loaded 0 filterscripts.


    [23:56:11] [debug] Run time error 19: "File or function is not found"
    [23:56:11] [debug] Streamer_CallbackHook
    [23:56:11] [debug] SSCANF_Init
    [23:56:11] [debug] SSCANF_Join
    [23:56:11] [debug] SSCANF_Leave
    [23:56:11] [debug] SetDynamicObjectMaterialText
    [23:56:11] [debug] SetDynamicObjectMaterial
    [23:56:11] [debug] mysql_function_query
    [23:56:11] [debug] cache_get_data
    [23:56:11] [debug] cache_get_field_content
    [23:56:11] [debug] Run time error 19: "File or function is not found"
    [23:56:11] [debug] Streamer_CallbackHook
    [23:56:11] [debug] SSCANF_Init
    [23:56:11] [debug] SSCANF_Join
    [23:56:11] [debug] SSCANF_Leave
    [23:56:11] [debug] SetDynamicObjectMaterialText
    [23:56:11] [debug] SetDynamicObjectMaterial
    [23:56:11] [debug] mysql_function_query
    [23:56:11] [debug] cache_get_data
    [23:56:11] [debug] cache_get_field_content
    [23:56:11] Script[gamemodes/pRPv2.0b.amx]: Run time error 19: "File or function is not found"
    [23:56:11] Number of vehicle models: 0


  • Mysql fehler

    in den scriptfiles ordner erstellt sich einen datei names mysql und der datei steht



    17/05/2013-15:46:43 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `pRP_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,PRIMARY KEY (`Name`))




    und im serverlog

  • SQL Dumps importieren

    Hallo ich habe gerade versucht von phpmyadmin aus eine SQL datei zu importieren doch das limit ist bei 2048KiB 3864KiB wie kann ich denn dies hochladen ?
    doch meine SQL datei enthält



    EDIT:/
    oh sry im falschen bereich glaube ich kann dies jemand verschieben

  • HeadShot system bugt

    also weiter gehts nicht dannach kommt das tazer system


    public OnPlayerTakeDamage(playerid, issuerid, Float:amount, weaponid, bodypart)
    {
    if(issuerid == INVALID_PLAYER_ID) return 1;
    PlayerPlaySound(issuerid,17802,0.0,0.0,0.0);
    if(weaponid == 34 && bodypart == 9) //Headshot System
    {
    GameTextForPlayer(playerid,!"~r~~h~~h~] Headshot ]",5000,5);
    GameTextForPlayer(issuerid,!"~g~~h~~h~] Headshot ]",5000,5);
    SetPlayerHealth(playerid, 0.0);
    return 1;
    }
    if(weaponid != 23) return 1;
    if(gTeam[issuerid] == 2 || IsACop(issuerid) || PlayerInfo[issuerid][pLeader] == 24 || PlayerInfo[issuerid][pMember] == 24 || PlayerInfo[issuerid][pLeader] == 7)
    {
    if(PlayerCuffed[playerid] > 0) return SendClientMessage(issuerid, COLOR_GREY, " Spieler ist schon gefesselt !");
    if(GetDistanceBetweenPlayers(issuerid,playerid) < 5)
    {
    if(gTeam[playerid] == 2) return SendClientMessage(issuerid, COLOR_GREY, " Du kannst keinen Beamten Tazern! !");
    if(IsPlayerInAnyVehicle(playerid)) return SendClientMessage(issuerid, COLOR_GREY, " Der Betroffene ist in einem Fahrzeug !");
    if(!TazerBereit[issuerid]) return SendClientMessage(issuerid, COLOR_GREY, " Dein Tazer ist noch nicht aufgeladen! (ca. 30 Sekunden)");
    if(!random(3)) return SendClientMessage(issuerid, COLOR_GREY, " Du hast ihn nicht getroffen!");
    new giveplayer[MAX_PLAYER_NAME], sendername[MAX_PLAYER_NAME], string[128];
    GetPlayerName(playerid, giveplayer, sizeof(giveplayer));
    GetPlayerName(issuerid, sendername, sizeof(sendername));
    format(string, sizeof(string), "* %s hat dich mit einem Stromschocker niedergestreckt.", sendername);
    SendClientMessage(playerid, COLOR_LIGHTBLUE, string);
    format(string, sizeof(string), "Du hast %s mit einem Stromschocker niedergestreckt.", giveplayer);
    SendClientMessage(issuerid, COLOR_LIGHTBLUE, string);
    format(string, sizeof(string), "* %s holt seinen Stromschocker raus und streckt %s nieder.", sendername ,giveplayer);
    ProxDetector(30.0, issuerid, string, COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE,COLOR_PURPLE);
    GameTextForPlayer(playerid, "~r~Geschockt", 2500, 3);
    ApplyAnimation(playerid, "WUZI", "CS_Dead_Guy", 1.0, 0, 0, 0, 0, 0);
    FreezePlayer(playerid);
    // PlayerCuffed[playerid] = 1;
    // PlayerCuffedTime[playerid] = 20 + random(10);
    TazerBereit[issuerid] = 0;
    SetTimerEx("TazerBereitForPlayer", 30000,0,"i",issuerid);
    }
    }
    else
    {
    SendClientMessage(playerid, COLOR_GREY, " Du bist kein Beamter !");
    }
    return 1;
    }

  • HeadShot system bugt

    Hallo wenn ich einen ein Headshot gebe geht der server Down


    public OnPlayerTakeDamage(playerid, issuerid, Float:amount, weaponid, bodypart)
    {
    if(issuerid == INVALID_PLAYER_ID) return 1;
    PlayerPlaySound(issuerid,17802,0.0,0.0,0.0);
    if(weaponid == 34 && bodypart == 9) //Headshot System
    {
    GameTextForPlayer(playerid,!"~r~~h~~h~] Headshot ]",5000,5);
    GameTextForPlayer(issuerid,!"~g~~h~~h~] Headshot ]",5000,5);
    SetPlayerHealth(playerid, 0.0);
    return 1;
    }

  • Gamemode ladet ncht

    und im terminal steht


    samp03svr: amx/amx.c:811: expand: Assertion `memsize==0' failed.
    Aborted



    edit:


    #pragma compress 0 im script einfügen

  • pWBB4 v0.5 - PHP & WBB4 Funktionen für SAMP

    machen das mal erst mit ban ok @seegras


    if(strcmp("/ban", cmd, true) == 0)
    {
    if(IsPlayerConnected(playerid))
    {
    tmp = strtok(cmdtext, idx);
    if(!strlen(tmp))
    {
    SendClientMessage(playerid, COLOR_BENUTZETEXT, "Benutze: /ban [SpielerName/ID] [Grund]");
    return 1;
    }
    giveplayerid = ReturnUser(tmp);
    if(IsPlayerConnected(giveplayerid))
    {
    if(PlayerInfo[playerid][pAdmin] >= 2)
    {
    GetPlayerName(giveplayerid, giveplayer, sizeof(giveplayer));
    GetPlayerName(playerid, sendername, sizeof(sendername));
    new length = strlen(cmdtext);
    while ((idx < length) && (cmdtext[idx] <= ' '))
    {
    idx++;
    }
    new offset = idx;
    new result[84];
    while ((idx < length) && ((idx - offset) < (sizeof(result) - 1)))
    {
    result[idx - offset] = cmdtext[idx];
    idx++;
    }
    result[idx - offset] = EOS;
    if(!strlen(result))
    {
    SendClientMessage(playerid, COLOR_BENUTZETEXT, "Benutze: /ban [SpielerName/ID] [Grund]");
    return 1;
    }
    if(strfind(result, "'", true) != -1)
    {
    SendClientMessage(playerid, COLOR_ERRORTEXT, " Kein Apostroph(') !");
    return 1;
    }
    if(PlayerInfo[giveplayerid][pSQLID] == 1 || PlayerInfo[giveplayerid][pSQLID] == 2 && PlayerInfo[playerid][pSQLID] != 1)
    {
    format(string, sizeof(string), "AdmCmd: %s wurde von %s gebannt. Grund: %s", giveplayer, sendername, (result));
    SendClientMessage(playerid, COLOR_LIGHTRED, string);
    format(string, sizeof(string), "* %s hat versucht dich zu Bannen, er wurde aus sicherheits gründen gekickt.. Grund: %s", sendername, (result));
    SendClientMessage(giveplayerid, COLOR_LIGHTRED, string);
    Kick(playerid);
    return 1;
    }
    else
    {
    new year, month,day;
    getdate(year, month, day);
    format(string, sizeof(string), "AdmCmd: %s wurde von %s gebannt. Grund: %s", giveplayer, sendername, (result));
    SendAdminMessage(COLOR_LIGHTRED, -1, string);
    SendClientMessage(giveplayerid,COLOR_LIGHTRED, string);
    format(string,sizeof(string),"%s, gebannt von: %s ,Grund: %s.", giveplayer, sendername,(result));
    EnterToLog("ban",string);
    UserAkte(PlayerInfo[giveplayerid][pSQLID], string);
    SendClientMessage(giveplayerid,COLOR_GRAD3, "Du wurdest von einem Admin gebannt, sollte es sich hierbei um ein Missverständnis handeln,");
    SendClientMessage(giveplayerid,COLOR_GRAD3, "erstelle hiervon ein Screen (F8) und Erstelle im Forum einen Entbannantrag.");
    BanSelfmade(giveplayerid, playerid, (result), -1, 0);
    }
    return 1;
    }
    else
    {
    SendClientMessage(playerid, COLOR_KEINADMIN, "*** INFO: Dies ist ein Adminbefehl, du bist kein Admin.");
    return 1;
    }
    }
    else
    {
    SendClientMessage(playerid, COLOR_ERRORTEXT, " Dieser Spieler ist Offline !");
    }
    }
    return 1;
    }

  • job gehalt

    also hast du


    new Float:vHealth,value,randcash = +1000; oder wie hast du es geschrieben