Jump to content
  • 0

Comanda se executa cand vrea ea.

Rien

Asked by Rien,

 Share

Question

Rien Apprentice

Rien

Posted
Posted

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.

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0
Rien Apprentice

Rien

Posted
  • Author
Posted

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;
}

 

Link to comment
Share on other sites
  • 0
Rien Apprentice

Rien

Posted
  • Author
Posted (edited)

 

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. 

Edited by Rien
Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • 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.