Onforum.net - Web and gaming resource community

Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members .

Quests /Python maintenance Quest

Vanilla

Elite
Elite
Credits
1,180
code_language.lua:
quest maintenance begin
state start begin
when 40003.use with pc.is_gm () begin
say_title ("Maintenance System")
say ("What do you want to do?")
say ("") local s = select ("Start maintenance system", "End maintenance system", "Cancel") if s == 1then
mysql_query ("UPDATE account.account SET account.status = 'SHUTDOWN' WHERE status = 'OK' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
command ("shutdown" ifend)



s == 2 then
mysql_query ("UPDATE account.account SET account.status = 'OK' WHERE status = 'SHUTDOWN' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
end
if s == 3 then
return
end
end
end
 
code_language.lua:
quest maintenance begin
state start begin
when 40003.use with pc.is_gm () begin
say_title ("Maintenance System")
say ("What do you want to do?")
say ("") local s = select ("Start maintenance system", "End maintenance system", "Cancel") if s == 1then
mysql_query ("UPDATE account.account SET account.status = 'SHUTDOWN' WHERE status = 'OK' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
command ("shutdown" ifend)



s == 2 then
mysql_query ("UPDATE account.account SET account.status = 'OK' WHERE status = 'SHUTDOWN' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
end
if s == 3 then
return
end
end
end

Nice, but a little bit messed up. Here's corrected version(your quest, my edit):
code_language.lua:
quest maintenance begin
    state start begin
        when 40003.use with pc.is_gm () begin
        say_title ("Maintenance System")
        say ("What do you want to do?")
        say ("")
        local s = select ("Start maintenance system", "End maintenance system", "Cancel")
            if s == 1 then
                mysql_query ("UPDATE account.account SET account.status = 'SHUTDOWN' WHERE status = 'OK' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
                command ("shutdown")
            end
            if s == 2 then
                mysql_query ("UPDATE account.account SET account.status = 'OK' WHERE status = 'SHUTDOWN' and account.login NOT IN (SELECT mAccount FROM common.gmlist);")
            end
            if s == 3 then
                return
            end
        end
    end
end
 

Similar threads


Top

Dear User!

We found that you are blocking the display of ads on our site.

Please add it to the exception list or disable AdBlock.

The advertises that you'll see aren't intrusive they just help us to keep the community alive

If you don't want to see those ads just buy an upgrade.

Thank you for understanding!

Rogue

Rogue Purchase

User upgrade! at

🔥 Upgrade Now
Baba2

Baba2 Purchase

User upgrade! at

🔥 Upgrade Now

Escanor25 Purchase

User upgrade! at

🔥 Upgrade Now