[Ax3l123]

PHP код:

CMD:announcedmevent(playerid, params[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai");
    if(IsPlayerConnected(playerid))
    {
        new eventprize,string[128];
        if(PlayerInfo[playerid][pAdmin] >= 3)
        {
            if(sscanf(params, "i",eventprize)) return SendClientMessage(playerid, 0xFFFFFFFF, "{B8DBFF}Syntax: /announcedmevent <premiu> ");
            if(eventprize < 250000 || eventprize > 1000000) return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Premiul trebue sa fie cel putin 250k si maxim 1kk.");
            if(EventInfo[eStatus] = 1) return SendClientMessage(playerid,COLOR_LIGHTBLUE,"Eventul a fost anuntat deja");
            if(EventInfo[eStatus] = 2) return SendClientMessage(playerid,COLOR_LIGHTGREEN,"Eventul este deja in desfasurare");
            if(EventInfo[eStatus] = 0)
            {
                EventInfo[ePrize]= eventprize;
                format(string,sizeof(string),"UPDATE `event` SET `prize` ='%s'",eventprize);
                mysql_query(SQL,string);
                EventInfo[eStatus]= 1;
                format(string,sizeof(string),"UPDATE `event` SET `status` ='1'");
                mysql_query(SQL,string);
                SendClientMessageToAll(COLOR_Duduianu,"Eventul DM a fost pornit de catre %s , premiul este de %s.",GetName(playerid),EventInfo[ePrize]);
                SendClientMessageToAll(COLOR_Duduianu,"Pentru a participa /joindmevent");
            }
        }
        else
        {
            SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai nivelul de admin necesar");
        }
    }
    return 1;
}
CMD:startdm(playerid,parmas[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai");
    if(IsPlayerConnected(playerid))
    {
        new string[128];
        if(PlayerInfo[playerid][pAdmin] >= 3 )
        {
            if(EventInfo[eStatus] != 1) return SendClientMessage(playerid,COLOR_RED,"Eventul nu a fost anuntat sau este in derularare");
            if(EventInfo[eStatus] = 1)
            {
                SendClientMessageToAll(COLOR_RED,"Intrarea este oprita");
                SendClientMessageToAll(COLOR_RED,"Eventul incepe in 10 secunde");
                EventInfo[eStatus]= 2;
                format(string,sizeof(string),"UPDATE `event` SET `status` ='2'");
                mysql_query(SQL,string);
                SetTimer("dmstart",5000,false);
            }
        }
        else
        {
            SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai nivelul de admin necesar");
        }
    }
    return 1;
}
CMD:dmwinner(playerid,params[])
{
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai");
    if(IsPlayerConnected(playerid))
    {    
        new winner, string[120],string2[120];
        if(PlayerInfo[playerid][pAdmin] >= 3)
        {
            if(sscanf(params, "u",winner)) return SendClientMessage(playerid, 0xFFFFFFFF, "{B8DBFF}Syntax: /dmwinner <winner> ");
            if(EventInfo[eStatus] !=2 ) return SendClientMessage(playerid,-1,"Eventul nu este in desfasurare");
            if(PlayerInfo[winner][pEvent] != 1) return SendClientMessage(playerid,-1,"Playerul nu a participat in event");
            if(IsPlayerConnected(winner))
            {
                if(winner != INVALID_PLAYER_ID)
                {
                    SendClientMessageToAll(COLOR_GREEN,"%s a castigat eventul DM si a primit premiul de %s",GetName(winner),EventInfo[ePrize]);
                    GivePlayerCash(winner, EventInfo[ePrize]);
                    EventInfo[ePrize] = 0;
                    EventInfo[eStatus] =0;
                    format(string,sizeof(string),"UPDATE `event` SET `prize` ='0'");
                    mysql_query(SQL,string);
                    format(string2,sizeof(string2),"UPDATE `event` SET `status` ='0'");    
                    mysql_query(SQL,string2);
                }
            }
            else
            {
                SendClientMessage(playerid,COLOR_GRAD6,"Playernul nu este connectat");
            }
            
        }
    }
    return 1;
} 


well the problem is that some commands don't work . For exemple announcedmevent always says that [eStatus] = 1 even if in mysql it's 0
i even added on gamemodeinit a EventInfo[eStatus] =0; and still the problem exists

[ATGOggy]

Try this:

PHP код:

CMD:announcedmevent(playerid, params[]) 
{ 
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai"); 
    if(IsPlayerConnected(playerid)) 
    { 
        new eventprize,string[128]; 
        if(PlayerInfo[playerid][pAdmin] >= 3) 
        { 
            if(sscanf(params, "i",eventprize)) return SendClientMessage(playerid, 0xFFFFFFFF, "{B8DBFF}Syntax: /announcedmevent <premiu> "); 
            if(eventprize < 250000 || eventprize > 1000000) return SendClientMessage(playerid, COLOR_WHITE, "{FFB870}Premiul trebue sa fie cel putin 250k si maxim 1kk."); 
            if(EventInfo[eStatus] == 1) return SendClientMessage(playerid,COLOR_LIGHTBLUE,"Eventul a fost anuntat deja"); 
            if(EventInfo[eStatus] == 2) return SendClientMessage(playerid,COLOR_LIGHTGREEN,"Eventul este deja in desfasurare"); 
            if(EventInfo[eStatus] == 0) 
            { 
                EventInfo[ePrize]= eventprize; 
                format(string,sizeof(string),"UPDATE `event` SET `prize` ='%d'",eventprize); 
                mysql_query(SQL,string); 
                EventInfo[eStatus]= 1; 
                format(string,sizeof(string),"UPDATE `event` SET `status` ='1'"); 
                mysql_query(SQL,string);
                new string2[128];
                format(string2, size of(string2),"Eventul DM a fost pornit de catre %s , premiul este de %d.",GetName(playerid),EventInfo[ePrize]
                SendClientMessageToAll(COLOR_Duduianu,string2); 
                SendClientMessageToAll(COLOR_Duduianu,"Pentru a participa /joindmevent"); 
            } 
        } 
        else 
        { 
            SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai nivelul de admin necesar"); 
        } 
    } 
    return 1; 
} 
CMD:startdm(playerid,parmas[]) 
{ 
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai"); 
    if(IsPlayerConnected(playerid)) 
    { 
        new string[128]; 
        if(PlayerInfo[playerid][pAdmin] >= 3 ) 
        { 
            if(EventInfo[eStatus] != 1) return SendClientMessage(playerid,COLOR_RED,"Eventul nu a fost anuntat sau este in derularare"); 
            if(EventInfo[eStatus] = 1) 
            { 
                SendClientMessageToAll(COLOR_RED,"Intrarea este oprita"); 
                SendClientMessageToAll(COLOR_RED,"Eventul incepe in 10 secunde"); 
                EventInfo[eStatus]= 2; 
                format(string,sizeof(string),"UPDATE `event` SET `status` ='2'"); 
                mysql_query(SQL,string); 
                SetTimer("dmstart",5000,false); 
            } 
        } 
        else 
        { 
            SendClientMessage(playerid,COLOR_LIGHTRED,"Nu ai nivelul de admin necesar"); 
        } 
    } 
    return 1; 
} 
CMD:dmwinner(playerid,params[]) 
{ 
    if(gPlayerLogged[playerid] == 0) return SendClientMessage(playerid,COLOR_LIGHTRED, "Logheazate mai intai"); 
    if(IsPlayerConnected(playerid)) 
    {     
        new winner, string[120],string2[120]; 
        if(PlayerInfo[playerid][pAdmin] >= 3) 
        { 
            if(sscanf(params, "u",winner)) return SendClientMessage(playerid, 0xFFFFFFFF, "{B8DBFF}Syntax: /dmwinner <winner> "); 
            if(EventInfo[eStatus] !=2 ) return SendClientMessage(playerid,-1,"Eventul nu este in desfasurare"); 
            if(PlayerInfo[winner][pEvent] != 1) return SendClientMessage(playerid,-1,"Playerul nu a participat in event"); 
            if(IsPlayerConnected(winner)) 
            { 
                if(winner != INVALID_PLAYER_ID) 
                { 
                    SendClientMessageToAll(COLOR_GREEN,"%s a castigat eventul DM si a primit premiul de %s",GetName(winner),EventInfo[ePrize]); 
                    GivePlayerCash(winner, EventInfo[ePrize]); 
                    EventInfo[ePrize] = 0; 
                    EventInfo[eStatus] =0; 
                    format(string,sizeof(string),"UPDATE `event` SET `prize` ='0'"); 
                    mysql_query(SQL,string); 
                    format(string2,sizeof(string2),"UPDATE `event` SET `status` ='0'");     
                    mysql_query(SQL,string2); 
                } 
            } 
            else 
            { 
                SendClientMessage(playerid,COLOR_GRAD6,"Playernul nu este connectat"); 
            } 
             
        } 
    } 
    return 1; 
}