Link Download?

Baza de date nu merge sa o descarci

Te-ai saturat de servare care peste 1 luna se inchid din cauza banilor te asteptam aici si iti vei da cu parerea, servarul dispune de un gamemod RPG cat mai frumos cu multe sisteme unice si pe placul tututor, de asemenea cautam si staff capabil sa ma ajute pe mai departe, te asteptam alaturi de noi!

HostName: BlueMax RPG l Cautam Staff l /bonus
Address:  193.203.39.134:7777

[19:57:31]  ===============================

[19:57:31]       sscanf plugin loaded.     

[19:57:31]          Version:  2.8.1        

[19:57:31]    (c) 2012 Alex "Y_Less" Cole  

[19:57:31]  ===============================

[19:57:31]   Loaded.
[19:57:31]  Loading plugin: streamer
[19:57:31] 

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

[19:57:31]   Loaded.
[19:57:31]  Loading plugin: mysql
[19:57:31]   Failed.
[19:57:31]  Loaded 2 plugins.

[19:57:31] 
[19:57:31] Filterscripts
[19:57:31] ---------------
[19:57:31]   Loaded 0 filterscripts.

[19:57:31] Script[gamemodes/redhood.amx]: Run time error 19: "File or function is not found"
[19:57:31] Number of vehicle models: 0

am pus toate plugingurile cu mysql si nimic de mysql imi da

11:13:27  [mysql]     Attempting to start MySQL app...
11:13:28  [mysql]     Status change detected: running
11:13:30  [mysql]     Status change detected: stopped
11:13:30  [mysql]     Error: MySQL shutdown unexpectedly.
11:13:30  [mysql]     This may be due to a blocked port, missing dependencies, 
11:13:30  [mysql]     improper privileges, a crash, or a shutdown by another method.
11:13:30  [mysql]     Press the Logs button to view error logs and check
11:13:30  [mysql]     the Windows Event Viewer for more clues
11:13:30  [mysql]     If you need more help, copy and post this
11:13:30  [mysql]     entire log window on the forums

InnoDB: using atomic writes.
2021-09-14 11:13:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-09-14 11:13:28 0 [Note] InnoDB: Uses event mutexes
2021-09-14 11:13:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-09-14 11:13:28 0 [Note] InnoDB: Number of pools: 1
2021-09-14 11:13:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-09-14 11:13:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-09-14 11:13:28 0 [Note] InnoDB: Completed initialization of buffer pool
2021-09-14 11:13:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-09-14 11:13:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-09-14 11:13:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-09-14 11:13:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-09-14 11:13:28 0 [Note] InnoDB: Waiting for purge to start
2021-09-14 11:13:28 0 [Note] InnoDB: 10.4.13 started; log sequence number 47055; transaction id 9
2021-09-14 11:13:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-09-14 11:13:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-09-14 11:13:28 0 [Note] InnoDB: Buffer pool(s) load completed at 210914 11:13:28
2021-09-14 11:13:28 0 [ERROR] Can't open and lock privilege tables: Can't find file: '.\mysql\servers.MAI' (errno: 2 "No such file or directory")
2021-09-14 11:13:28 0 [Note] Server socket created on IP: '::'.

 ce sa ii mai fac ca nu ii dau de cap

Daca as stii l-as fi facut sau nu stiu!

l-am dezinstalat am facut arhiva la el am instalat altul merge dar la bazele de date apare asa si nu mai merg imi apare la unele in uz

Am si eu o problema cand dau localhost/phpmyadmin imi arata eroarea asta, tin sa precizez ca pana acum a mers si nu am facut nici o modificare nimic

Reîncearcă să te conectezi

la ucp apare asa

Pagina web de la https://localhost/panel5/ poate fi temporar nefuncțională sau a fost mutată definitiv la o nouă adresă web.

unde se modifica baza de date sa pun localhost si sa preaia baza de date din localhost

+1 dar unde este mysql connect sa adaug localhost sa ii fac un test?

Am si eu aceste erori si se da crash pe server 

[12:02:08] [debug] Run time error 4: "Array index out of bounds"
[12:02:08] [debug]  Accessing element at negative index -1
[12:02:08] [debug] AMX backtrace:
[12:02:08] [debug] #0 001bf4f4 in public OnPlayerKeyStateChange (0, 65536, 0) from gamemode.amx
[12:02:12] [debug] Run time error 4: "Array index out of bounds"
[12:02:12] [debug]  Accessing element at negative index -1
[12:02:12] [debug] AMX backtrace:
 

On 12/11/2020 at 11:13 AM, UbiquiTouS. said:

Pentru cei care vor sa complieze gm-ul union-zone si va da erori,luati de aici tot ce aveti nevoie -> UNION-ZONE ,e acelas gm,doar ca are toate includurile si poate fi compliat fara erori,a fost testat de catre mine.

nu merge link-ul si am incercat sa iti dau add discord si nu merge zice ceva de majuscule! poti baga tu discordul meu BaDB0y#3017

Am si eu o comanda /makeleader si am incerc sa fac cand tastez sa imi apara id-ul factiuni si factiunile sa stii ce sa setezi la player si nu apare deloc

CMD:makeleader(playerid, params[])
{
    if(pInfo[playerid][pAdmin] < 5) return SendClientMessage(playerid, COLOR_DARKGRAY, "You are not authorized to use that command.");
    new giveplayerid, level;
    if(sscanf(params, "ud", giveplayerid, level)) return SendClientMessage(playerid, 0x8EC7DCFF, "Syntax: {FFFFFF}/makeleader [playerid/name] [faction ID]");
    SendClientMessage(playerid, 0x8EC7DCFF, "1.LS Police Departament || 2.F.B.I || 3.National Guard || 4.Paramedics Departament LS || 5.Taxi LS || 6.News Reporters || 7.School Instructor LS || 8.Hitman Agency || 9.Grove Street || 10.The Ballas Family");
    SendClientMessage(playerid, 0x8EC7DCFF, "11.La Cosa Nostra || 12.Yakuza || 13.The Mayor || 14.Insomnia Racing Club || 15.Midnight Racers Club || 16.Taxi LV || 17.School Instructor LV || 18.Paramedics Departament LV || 19.LV Police Departament");
    if(giveplayerid == INVALID_PLAYER_ID || pInfo[giveplayerid][pStatus] != 1) return SendClientMessage(playerid, COLOR_DARKGRAY, "Player not connected.");
    if(pInfo[giveplayerid][pMember] > 0 && pInfo[giveplayerid][pRank] != 10) return SendClientMessage(playerid, COLOR_DARKGRAY, "Jucatorul este deja intr-o factiune ca membru. (/auninvite)");
    if(pInfo[giveplayerid][pMember] == 0 && level == 0) return SendClientMessage(playerid, COLOR_DARKGRAY, "Jucatorul este deja civil.");
    if(ac28[giveplayerid] == 0)

Am si eu o problema la comanda /bonus dupa ce tastez primesc level si diamantele si bani mi pune si ii retrage inapoi adica bani nu se salveaza

CMD:bonus(playerid, params[])
{
    if(IsPlayerConnected(playerid))
     {
        if(pInfo[playerid][pScore] <= 2)
          {
            GivePlayerMoney(playerid, 15000000);
              pInfo[playerid][pScore] = 3;
            pInfo[playerid][pDiamonds] = 50;
               SetPlayerScore(playerid, pInfo[playerid][pScore]);
             SendClientMessage(playerid, COLOR_LIGHTBLUE, "Ai primit 15.000.000$, level 3 si 50 diamante de bun venit!");
        }
        else return SendClientMessage(playerid, COLOR_LIGHTRED, "Nu poti folosi aceasta comanda daca ai level 3+ !");
    }
    return 1;
}

si daca pica hostul nu se salveaza

2 hours ago, HPQ123 said:

Poti face un query la aceasta functie cu salvarea datelor ori la OnGamemodeExit.

mysql_format(SQL, gQuery, sizeof gQuery, "UPDATE `stuff` SET `goal`='%i", ServerGoal);
mysql_tquery(SQL, gQuery);

 

asta e tot ce am la ongamemodeexit

 public OnGameModeExit() {
    DestroyActor(SpawnActor);
    DestroyActor(actorbar1);
    DestroyActor(actorconvertor);
    gQuery[0] = EOS;
    mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `stuff` SET `goal`='%d'", ServerGoal);
    mysql_tquery(SQL, gQuery, "", "");
    save_stock();
    return true; }

On 7/10/2021 at 12:24 PM, Banditul said:

Arata si UpdateJobGoal pentru ca in comanda nu ai query de update. Eventual arata si cum incarci valoarea din baza de date

function UpdateJobGoal(update) {
    ServerGoal += update;
    gString[0] = EOS;
    format(gString, 60, "~y~$%s ~w~/ ~g~$%s", ServerGoal >= MAXGOAL ? FormatNumbers(MAXGOAL) : FormatNumbers(ServerGoal), FormatNumbers(MAXGOAL));
    TextDrawSetString(GoalTD[0], gString);

    if(TerminatJobGoal != 1) {
        if(ServerGoal >= MAXGOAL) {
            foreach(Player, b) {
                new amount, rand = random(30);
                switch(rand) {
                    case 0..10: {
                        amount = RandomEx(200, 400);
                        format(gString, 100, "Job Goal: {FFFFFF}Felicitari! Ai primit %d Gift Points pentru ca s-a umplut golul.", amount);
                        SCM(b, 0xF5C738FF, gString);
                        PlayerInfo[b][pGiftPoints] += amount;
                        if(PlayerInfo[b][pGiftPoints] >= 1000) PlayerInfo[b][pGiftPoints] = 1000;
                        Update(b, pGiftPointsx);        
                    }
                    case 11..19: {
                        amount = RandomEx(15, 30);
                        format(gString, 100, "Job Goal: {FFFFFF}Felicitari! Ai primit %d Premium Points pentru ca s-a umplut golul.", amount);
                        SCM(b, 0xF5C738FF, gString);
                        PlayerInfo[b][pPremiumPoints] += amount;
                        Update(b, pPremiumPointsx);        
                    }
                    default: {
                        amount = RandomEx(200, 350);
                        format(gString, 100, "Job Goal: {FFFFFF}Felicitari! Ai primit %d DPoints pentru ca s-a umplut golul.", amount);
                        SCM(b, 0xF5C738FF, gString);
                        PlayerInfo[b][pCPoints] += amount;
                        Update(b, pCPointsx);
                    }
                }
            }
            TerminatJobGoal = 1;
        }
    }
    return true; }

YCMD:resetgoal(playerid, params[], help) {
    if( PlayerInfo[ playerid ][ pAdmin ] < 7 )
    return SCM( playerid, COLOR_LGREEN, AdminOnly );
    ServerGoal = 0; TerminatJobGoal = 0;
    UpdateJobGoal( 0 );
    SCMTA( COLOR_YELLOW, "* Goal-ul a fost resetat de catre un administrator." );
    mysql_tquery(SQL, "UPDATE `stuff` SET `goal`='0'", "", "");
    return true; }

UpdateJobGoal(TotalMoneyy);

new totalmony;
                    GiveJobSalary(playerid);
                    UpdateJobGoal(totalmony + fishing);
                    GivePlayerCash(playerid, 1, fishing + totalmony);

asta e tot ce am gasit in gamemod de updatejobgoal

Deci daca setez din comanda apare in joc suma care o pun cand face jucatorul se pune la job doar ca la repornire server o ia de la 0 plus ca daca setez suma nu se modifica in stuff - goal

mai exact daca dau restart la server nu ramane salvat ca si cum nu ar citi de acolo nu stiu ce sa fie

YCMD:setjobgoalmoney(playerid, params[], help) {
    if(PlayerInfo[playerid][pScripter] < 1) return SCM(playerid, COLOR_RED, "Eroare: {FFFFF}Nu ai acces la aceasta comanda!");
    new amount, string[64];
    if(sscanf(params, "i", amount)) return SCM(playerid, COLOR_GREY, "Syntax: {FFFFFF}/setjobgoalmoney <amount>");
    UpdateJobGoal( amount );
    format(string, sizeof(string), "Ai adaugat %s$ la job goal.", FormatNumbers(amount));
    SCM(playerid, COLOR_YELLOW, string);
    return true; }

Eu nu gasesc md5 unde mai exact ar trebui cautat

Vreau sa criptez si eu parola unui jucator de exemplu in baza de date imi apare la password parola lui si as vrea sa o criptez o sa va arat imediat cum apare si nu stiu cum sa fac sa fie criptata

Cand tastez comanda /leaders imi apare daca sunt aplicatiile deschise sau nu si le pot modifica doar din baza de date unde am pus mai sus as face o comanda dar nu inteleg cum sa o fac sa afecteze fiecare rand

Comanda asta trebuie sa modifice statusul aplicatilor adica la comanda /leaders apare opened sau closed daca factiunea recruteaza sau nu, cand o folosesc se modifica motd in joc ar trebuie sa imi afecteaza acele randuri si sa pot pune 0 sau 1 nu sa scriu litere

Am si eu o probelma cu comanda /status ar trebui sa imi modifice statusul in opened si closed si nu imi modifica nimic, o sa las mai joc comanda si din mysql ce ar trebui sa afecteze ca randuri

Ce trebuie sa mai modific in comanda sa o fac sa mearga ca nu ii pot da de cap deloc sa imi dea voie sa pun doar 0 si 1

1 Opened

2 Closed

CMD:status(playerid, params [])
{
    if(pInfo[playerid][pRank] < 6 || pInfo[playerid][pMember] == 13) return SendClientMessage(playerid, COLOR_DARKGRAY, "You not have minimum rank 6.");
    new motd[90];
    if(sscanf(params, "s[90]", motd)) return SendClientMessage(playerid, 0x8EC7DCFF, "Syntax: {FFFFFF}/status [MOTD Text]");
    if(strlen(motd) > 89) return SendClientMessage(playerid, COLOR_DARKGRAY, "Maximum characters allowed for faction MOTD is 90.");
    if(!IsValidMOTD(motd)) return SendClientMessage(playerid, COLOR_DARKGRAY, "Invalid characters, valid characters are: A-Z, a-z, 0-9, (. , : ! ?).");
    mysql_tquery(MySQLCon, "SELECT option_value FROM `inf_options` WHERE `option_name`='factionAppStatus1' OR `option_name`='factionAppStatus2' OR `option_name`='factionAppStatus3' OR `option_name`='factionAppStatus4'OR `option_name`='factionAppStatus5'OR `option_name`='factionAppStatus6'OR `option_name`='factionAppStatus7'OR `option_name`='factionAppStatus8'OR `option_name`='factionAppStatus9'OR `option_name`='factionAppStatus10'OR `option_name`='factionAppStatus11'OR `option_name`='factionAppStatus12'OR `option_name`='factionAppStatus14'OR `option_name`='factionAppStatus15'OR `option_name`='factionAppStatus16'OR `option_name`='factionAppStatus17'OR `option_name`='factionAppStatus18'OR `option_name`='factionAppStatus19'", "OnFUP", "");
    format(stringf[pInfo[playerid][pMember]-1], 100, "Faction MOTD: {FFFFFF}%s", motd), SendClientMessage(playerid, 0xA9C4E4FF, stringf[pInfo[playerid][pMember]-1]);
    return 1;
}

Nu ma pricep la panel daca stiam sa creez unul faceam asa!

Exact asta vreau sa fac sa sparg parolele multi playeri isi uita parola care au inactivitate mai mare si nu ii pot ajuta sa le-o resetez nu inteleg de ce mai postezi sa faci +1 daca habar nu ai

Unde trebuie modificat si ce ca atunci cand un utilizator se inregistreaza sa imi arate parola lui de la cont in mysql la players pass ca imi arata o parola random??