Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

[cstef4n]

salutare,

Cine ma poate ajuta si pe mine, cand expira billboard-ul nu seteaza jucatorului offline variabila Billboard pe 0

 

Cod: 

function ScadeTimpBillboard() {
    new query[248];
    for(new i = 0; i < MAX_BILLBOARDS; i++) {
        if(Billboard[i][blOwned] > 0) {
            if(Billboard[i][blExpire] > 0) {
                Billboard[i][blExpire] -= 60;
                UpdateLabelBillboard(i);

                mysql_format(SQL, query, sizeof(query), "UPDATE `billboards` SET `expire`='%d' WHERE `ID`='%d'", Billboard[i][blExpire], i);
                mysql_tquery(SQL, query, "", "");
                
                if(Billboard[i][blExpire] <= 0) {

                  

                    ---- > AICI (la ownerbill) <---

                     new ownerbill[64];
                    cache_get_field_content( 0, "blOwner", ownerbill, SQL, 64);
                    mysql_format(SQL, query, sizeof query, "UPDATE `users` SET `Billboard` = '0' WHERE `Username` = '%s'", ownerbill);
                    mysql_tquery(SQL, query, "", "" );

                    Billboard[i][blOwned] = 0;
                    Billboard[i][blPhone] = 0;
                    Billboard[i][blExpire] = 0;
                    format(Billboard[i][blOwner],25,"AdmBot");
                    format(Billboard[i][blFont],25,"Arial");
                    format(Billboard[i][blMessage],32,"Your advertisment here!");
                    mysql_format(SQL,query,248,"UPDATE `billboards` SET `blFont`='Arial',`blOwned`='0',`blOwner`='AdmBot',`blPhone`='0',`blMessage`='Your advertisment here!',`expire`='0' WHERE `ID` = '%d' LIMIT 1",Billboard[i][blID]);
                    mysql_tquery(SQL,query,"","");
                    SetDynamicObjectMaterialText(Billboard[i][blObjectID],0,Billboard[i][blMessage], OBJECT_MATERIAL_SIZE_256x128,Billboard[i][blFont], 18, 0, 0xFF000000, 0xFFFFFFFF, OBJECT_MATERIAL_TEXT_ALIGN_CENTER);
                    UpdateLabelBillboard(i);
                } 
            }
        }
    }
    return 1;
}

Edited May 18 by cstef4n

[khain.dev]

function ScadeTimpBillboard() {
    new query[248];
    for(new i = 0; i < MAX_BILLBOARDS; i++) {
        if(Billboard[i][blOwned] > 0) {
            if(Billboard[i][blExpire] > 0) {
                Billboard[i][blExpire] -= 60;
                UpdateLabelBillboard(i);

                mysql_format(SQL, query, sizeof(query), "UPDATE `billboards` SET `expire`='%d' WHERE `ID`='%d'", Billboard[i][blExpire], i);
                mysql_tquery(SQL, query, "", "");
                
                if(Billboard[i][blExpire] <= 0) {

                    mysql_format(SQL, query, sizeof(query), "UPDATE `users` SET `Billboard` = '0' WHERE `Username` = '%s'", Billboard[i][blOwner]);
                    mysql_tquery(SQL, query, "", "" );

                    Billboard[i][blOwned] = 0;
                    Billboard[i][blPhone] = 0;
                    Billboard[i][blExpire] = 0;
                    format(Billboard[i][blOwner],25,"AdmBot");
                    format(Billboard[i][blFont],25,"Arial");
                    format(Billboard[i][blMessage],32,"Your advertisement here!");
                    mysql_format(SQL,query,248,"UPDATE `billboards` SET `blFont`='Arial',`blOwned`='0',`blOwner`='AdmBot',`blPhone`='0',`blMessage`='Your advertisement here!',`expire`='0' WHERE `ID` = '%d' LIMIT 1",Billboard[i][blID]);
                    mysql_tquery(SQL,query,"","");
                    SetDynamicObjectMaterialText(Billboard[i][blObjectID],0,Billboard[i][blMessage], OBJECT_MATERIAL_SIZE_256x128,Billboard[i][blFont], 18, 0, 0xFF000000, 0xFFFFFFFF, OBJECT_MATERIAL_TEXT_ALIGN_CENTER);
                    UpdateLabelBillboard(i);
                } 
            }
        }
    }
    return 1;
}

Poftim

[cstef4n]

Mersi mult mane, o sa incerc cand ajung acasa si iti zic daca merge