Jump to content
metin2dev

amosth

Members
  • Content count

    115
  • Joined

  • Last visited

Community Reputation

1 Neutral

About amosth

  • Rank
    Friendly

Profile Information

  • Gender
    Male

Recent Profile Visitors

316 profile views
  1. amosth

    open Autopotion Press Key

    Push
  2. I did not understand?
  3. Hi, How do I change the regeneration percentage of the elixir item? Bênção de Helong (S) > Change percent hp to instant hp Example item 70020
  4. amosth

    open Autopotion Press Key

    Hi, I would like to use this script with the keyboard shortcut: [F7] https://pastebin.com/BP2FSG72
  5. amosth

    open reading the MySQL column in lua

    Thanks man if (select("bla si", "bla no") == 1) then local a_, query = mysql_direct_query(string.format("SELECT ok FROM account.account WHERE id = %d LIMIT 1;", pc.get_account_id())); if a_== id then say("ok") else say("no") end --say(string.format("value: %d;", query[1].ok)) end -- if one last question, how do I check 2 column in the same result? Example: if (select("bla si", "bla no") == 1) then local a_, query = mysql_direct_query(string.format("SELECT ok,life FROM account.account WHERE id = %d LIMIT 1;", pc.get_account_id())); if a_== id then say("ok") else say("no") end end -- if EDIT: Is not working =/ if (select("bla si", "bla no") == 1) then local a_, query = mysql_direct_query(string.format("SELECT ok FROM account.account WHERE id = %d LIMIT 1;", pc.get_account_id())); if a_== id then say("ok") else say("no") end --say(string.format("value: %d;", query[1].ok)) end -- if
  6. amosth

    open reading the MySQL column in lua

    So can you help me with the quest?
  7. amosth

    open reading the MySQL column in lua

    I'll look into this. Could you help me with this case?
  8. Hello friends, I have created a column called "ok" in account, now I need to click on npc to check this example column: column "ok" = 0 if the value of the "ok" column is 0 goes from the error message, if the value of the "ok" column is 1 of the correct message. I hope you could understand. Thank you for the attention. when info or button begin say("blablabla") local f = select("bla si","bla no") if f == 1 then local c,query = mysql_direct_query("SELECT * FROM account.account WHERE id = '"..pc.get_account_id().."' LIMIT 1;") if query[1].ok < 1 then say'existe un valor menor a 1' else say'existe un valor de 1' end end if f == 2 then return end end not work =/
  9. amosth

    open block safebox in map

    up
  10. I have a column and in that column I need to check 0 or 1, column "verify" 0 or 1 quest testserver begin state start begin state start begin when login or begin set_state( gotoinfomation ) end end state gotoinfomation begin when letter begin send_letter("Welcome") end when button or info begin say("text") say("") local f = select("Yes count","No count") if f == 1 then local res1, verify = mysql_direct_query("select * from account.account;") mysql_direct_query("SELECT verify FROM account.account WHERE verify = '0'") else say("text2") if f == 2 then return end --set_state( gototeacher ) --end end end end end
  11. amosth

    open shutdown enable gm logged in

    This is not professional. Thanks.
  12. amosth

    open shutdown enable gm logged in

    all channels lead DC?
  13. amosth

    open shutdown enable gm logged in

    lol? the script is self explanatory: 1º quest: command("shutdown") when shutdown1.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 10 minutos!") notice_all("Efetue logout para evitar que itens sejam perdidos!") timer("shutdown2", 60*5) end when shutdown2.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 5 minutos!") notice_all("Efetue logout para evitar que itens sejam perdidos!") timer("shutdown3", 60*3) end when shutdown3.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 2 minutos!") notice_all("Efetue logout para evitar que itens sejam perdidos!") timer("shutdown4", 60) end when shutdown4.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 1 minuto!") notice_all("Efetue logout para evitar que itens sejam perdidos!") timer("shutdown5", 30) end when shutdown5.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 30 segundos!") notice_all("Efetue logout para evitar que itens sejam perdidos!") timer("shutdown6", 15) end when shutdown6.timer begin notice_all("Atenção !!!") notice_all("Manutenção: O servidor será desligado em 15 segundos!") notice_all("Para mais informações acesse: www.metin2.org") timer("shutdown7", 5) end when shutdown7.timer begin command("shutdown") end 2º text in login server: ""SHUTDOWN" : localeInfo.LOGIN_FAILURE_SHUTDOWN," MAINTENANCE I need GMs not turned off.
  14. amosth

    open shutdown enable gm logged in

    I need what I said above.
×