Jump to content

Rien

Membru
  • Posts

    11
  • Joined

  • Last visited

Posts posted by Rien

  1. Problema intalnita (descriere): Nu stiu cum sa elimin obiectele din imaginea de mai jos. Stiu ca se foloseste RemoveBuildingForPlayer, dar nu stiu ce cod au cladirile (marcate cu rosu)
    Ero(area / rile) / warning-(ul / urile): -
    Liniile de cod / sursa / script-ul(obligatoriu): Nu e nevoie 
    Imagini / Video (optional): http://imgur.com/Myy71yf
    Ati incercat sa rezolvati singur?: Da, dar n-am reusit

  2.  

    CMD:muteoff(playerid, params[]) {
    if(PlayerInfo[playerid][pAdmin] >= 2)
        {
            new muteTime,mutedName[25],mutedReason[55], queryString[500], query[512], string[150], messageString[551], aString[170];
            if(sscanf(params, "s[25]is[50]", mutedName, muteTime, mutedReason)) return SendAdminMessage(playerid, "/muteoff [name] [time] [reason]");
            {
                if(muteTime == 0) {
                cache_get_data(rows, fields, handle);
                mysql_format(handle, query, sizeof(query), "SELECT `username` FROM `players` WHERE `username` = '%e' AND `muted` = '1'", mutedName);
                mysql_query(handle, query);
                if(!rows)
                {
                format(string, sizeof(string), "Nobody with the name %s is registered or this player is not muted.", mutedName);
                return SendClientMessage(playerid, COLOR_GREY, string);
                }
                else if(rows)
                {
                mysql_format(handle, queryString, sizeof(queryString), "UPDATE `players` SET `muted`='0', `mutedBy`='%e' WHERE `username`='%e'",PlayerInfo[playerid][pRealName],mutedName);
                mysql_query(handle, queryString);
                PlayerInfo[playerid][pLogsType] = 2;
                format(messageString, sizeof(messageString), "[%s] %s unmuted offline player %s, reason: %s", ReturnDate(), PlayerInfo[playerid][pRealName], mutedName, mutedReason);                
                format(PlayerInfo[playerid][pLogsAction], 550, messageString);            
                LogSave(playerid);
                offLogSaveType[playerid] = 0;
                format(messageString, sizeof(messageString), "[%s] %s was offline unmuted by %s, reason: %s", ReturnDate(), mutedName, PlayerInfo[playerid][pRealName], mutedReason);                
                format(offLogSaveText[playerid], 550, messageString);
                format(offLogSaveName[playerid], 40, mutedName);                        
                offLogSave(playerid);            
                format(aString, sizeof(aString), "Butick: %s %s muted offline player %s for %d minutes, reason: %s.", PlayerInfo[playerid][pFunction], PlayerInfo[playerid][pRealName], mutedName, mutedReason);
                StaffBroadCast(COLOR_DARKRED, aString);            
                    }
                }
                else
                {
                cache_get_data(rows, fields, handle);
                mysql_format(handle, query, sizeof(query), "SELECT `username` FROM `players` WHERE `username` = '%e'", mutedName);
                mysql_query(handle, query);
                if(!rows)
                {
                format(string, sizeof(string), "Nobody with the name %s is registered.", mutedName);
                return SendClientMessage(playerid, COLOR_GREY, string);
                }
                else if(rows)
                {
                mysql_format(handle, queryString, sizeof(queryString), "UPDATE `players` SET `muted`='1', `mutedBy`='%e', `mutedReason`='%e', `mutedTime`='%d', `mutedPassKey`='1' WHERE `username`='%e'", PlayerInfo[playerid][pRealName],mutedReason, muteTime*60, mutedName);
                mysql_query(handle, queryString);
                PlayerInfo[playerid][pLogsType] = 2;
                format(messageString, sizeof(messageString), "[%s] %s muted offline player %s for %d minutes, reason: %s", ReturnDate(), PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);                
                format(PlayerInfo[playerid][pLogsAction], 550, messageString);            
                LogSave(playerid);
                offLogSaveType[playerid] = 0;
                format(messageString, sizeof(messageString), "[%s] %s was offline muted by %s for %d minutes, reason: %s", ReturnDate(), mutedName, PlayerInfo[playerid][pRealName], muteTime, mutedReason);                
                format(offLogSaveText[playerid], 550, messageString);
                format(offLogSaveName[playerid], 40, mutedName);                        
                offLogSave(playerid);            
                format(aString, sizeof(aString), "Butick: %s %s muted offline player %s for %d minutes, reason: %s.", PlayerInfo[playerid][pFunction], PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);
                SendClientMessageToAll(COLOR_LIGHTRED, aString);            
                }
                
                }
            }
        }    
    return 1;
    }

    Uite aici. 

  3. CMD:muteoff(playerid, params[]) {
    if(PlayerInfo[playerid][pAdmin] >= 2)
        {
            new muteTime,mutedName[25],mutedReason[55], queryString[500], query[512], string[150], messageString[551], aString[170];
            if(sscanf(params, "s[25]is[50]", mutedName, muteTime, mutedReason)) return SendAdminMessage(playerid, "/muteoff [name] [time] [reason]");
            {
                if(muteTime == 0) {
                cache_get_data(rows, fields, handle);
                mysql_format(handle, query, sizeof(query), "SELECT `username` FROM `players` WHERE `username` = '%e' AND `muted` = '1'", mutedName);
                mysql_query(handle, query);
                if(!rows)
                {
                format(string, sizeof(string), nomute_text_en, mutedName);
                return SendClientMessage(playerid, COLOR_GREY, string);
                }
                else if(rows)
                {
                mysql_format(handle, queryString, sizeof(queryString), "UPDATE `players` SET `muted`='0', `mutedBy`='%e' WHERE `username`='%e'",PlayerInfo[playerid][pRealName],mutedName);
                mysql_query(handle, queryString);
                PlayerInfo[playerid][pLogsType] = 2;
                format(messageString, sizeof(messageString), "[%s] %s unmuted offline player %s, reason: %s", ReturnDate(), PlayerInfo[playerid][pRealName], mutedName, mutedReason);                
                format(PlayerInfo[playerid][pLogsAction], 550, messageString);            
                LogSave(playerid);
                offLogSaveType[playerid] = 0;
                format(messageString, sizeof(messageString), "[%s] %s was offline unmuted by %s, reason: %s", ReturnDate(), mutedName, PlayerInfo[playerid][pRealName], mutedReason);                
                format(offLogSaveText[playerid], 550, messageString);
                format(offLogSaveName[playerid], 40, mutedName);                        
                offLogSave(playerid);            
                format(aString, sizeof(aString), unmutetext_off_en, PlayerInfo[playerid][pFunction], PlayerInfo[playerid][pRealName], mutedName, mutedReason);
                StaffBroadCast(COLOR_DARKRED, aString);            
                    }
                }
                else
                {
                cache_get_data(rows, fields, handle);
                mysql_format(handle, query, sizeof(query), "SELECT `username` FROM `players` WHERE `username` = '%e'", mutedName);
                mysql_query(handle, query);
                if(!rows)
                {
                format(string, sizeof(string), nomute_text2_en, mutedName);
                return SendClientMessage(playerid, COLOR_GREY, string);
                }
                else if(rows)
                {
                mysql_format(handle, queryString, sizeof(queryString), "UPDATE `players` SET `muted`='1', `mutedBy`='%e', `mutedReason`='%e', `mutedTime`='%d', `mutedPassKey`='1' WHERE `username`='%e'", PlayerInfo[playerid][pRealName],mutedReason, muteTime*60, mutedName);
                mysql_query(handle, queryString);
                PlayerInfo[playerid][pLogsType] = 2;
                format(messageString, sizeof(messageString), "[%s] %s muted offline player %s for %d minutes, reason: %s", ReturnDate(), PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);                
                format(PlayerInfo[playerid][pLogsAction], 550, messageString);            
                LogSave(playerid);
                offLogSaveType[playerid] = 0;
                format(messageString, sizeof(messageString), "[%s] %s was offline muted by %s for %d minutes, reason: %s", ReturnDate(), mutedName, PlayerInfo[playerid][pRealName], muteTime, mutedReason);                
                format(offLogSaveText[playerid], 550, messageString);
                format(offLogSaveName[playerid], 40, mutedName);                        
                offLogSave(playerid);            
                format(aString, sizeof(aString), mutetext_off_en, PlayerInfo[playerid][pFunction], PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);
                SendClientMessageToAll(COLOR_LIGHTRED, aString);            
                }
                
                }
            }
        }    
    return 1;
    }

     

  4. Problema intalnita (descriere): Recent am creeat o noua comanda, /muteoff asemanator comenzii /banoff din gm-ul lui w3op. Totul a mers ok, nu am nici o eroare insa cand execut comanda prima data ii da mute, daca o mai execut inca o data spune ca nimeni cu numele X nu e inregistrat, daca o mai executa inca o data merge si daca o mai execut inca o data iar nu merge, intelegeti voi. Serverul e hostat la mine in calculator, m-am gandit sa fie de la ping-ul mySql dar am obsevat ca nu are nicio legatura.
    Ero(area / rile) / warning-(ul / urile): - 
    Liniile de cod / sursa / script-ul(obligatoriu): 

                cache_get_data(rows, fields, handle);
                mysql_format(handle, query, sizeof(query), "SELECT `username` FROM `players` WHERE `username` = '%e'", mutedName);
                mysql_query(handle, query);
                if(!rows)
                {
                format(string, sizeof(string), nomute_text2_en, mutedName);
                return SendClientMessage(playerid, COLOR_GREY, string);
                }
                else if(rows)
                {
                mysql_format(handle, queryString, sizeof(queryString), "UPDATE `players` SET `muted`='1', `mutedBy`='%e', `mutedReason`='%e', `mutedTime`='%d', `mutedPassKey`='1' WHERE `username`='%s'", PlayerInfo[playerid][pRealName],mutedReason, muteTime*60, mutedName);
                mysql_query(handle, queryString);
                PlayerInfo[playerid][pLogsType] = 2;
                format(messageString, sizeof(messageString), "[%s] %s muted offline player %s for %d minutes, reason: %s", ReturnDate(), PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);                
                format(PlayerInfo[playerid][pLogsAction], 550, messageString);            
                LogSave(playerid);
                offLogSaveType[playerid] = 0;
                format(messageString, sizeof(messageString), "[%s] %s was offline muted by %s for %d minutes, reason: %s", ReturnDate(), mutedName, PlayerInfo[playerid][pRealName], muteTime, mutedReason);                
                format(offLogSaveText[playerid], 550, messageString);
                format(offLogSaveName[playerid], 40, mutedName);                        
                offLogSave(playerid);            
                format(aString, sizeof(aString), mutetext_off_en, PlayerInfo[playerid][pFunction], PlayerInfo[playerid][pRealName], mutedName, muteTime, mutedReason);
                SendClientMessageToAll(COLOR_LIGHTRED, aString);            
                }

     Imagini / Video (optional):  http://i.imgur.com/65Ly0he.png
    Ati incercat sa rezolvati singur?: Desigur, dar chiar nu vad unde am gresit.

  5. Problema intalnita (descriere): Deci, doresc sa fac un sistem de misiuni pe serverul meu pe MySQL. Am creeat un tabel numit mission, acolo contine toate misiunile si id-urile lor. As vrea ca atunci cand un player foloseste comanda /missions sa apara misiunile pe care el NU le-a facut, adica sa nu mai apara toate misiunile, decat cele pe care le mai are de facut. M-am gandit si am creeat un tabel nou numit completemissions care contine: ID-ul misiunii si id-ul playerului din Mysql. Probelma este urmatoarea: Nu am nici cea mai vaga idee ce legatura as putea face intre aceste 2 tabele din mysql. Cum as putea face ca atunci cand un membru foloseste /missions sa apara DOAR misiunile pe care el nu le-a facut. Cu ce functie / comanda. M-am gandit toata noaptea si nu am reusit sa rezolv problema. Sau daca aveti din intamplare o comanda asemanatoare ar fi perfect. Ofer +REP
    Ero(area / rile) / warning-(ul / urile): -
    Liniile de cod / sursa / script-ul(obligatoriu): Am spus mai sus problema, nu e nevoie de niciun cod.
    Imagini / Video (optional): Nu.
    Ati incercat sa rezolvati singur?: Desigur, din pacate nu am ajuns la o rezolvare.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.