amosth
Inactive Member-
Posts
163 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Everything posted by amosth
-
Hi, I would like to use this script with the keyboard shortcut: [F7] #edited
-
reading the MySQL column in lua
amosth replied to amosth's topic in Community Support - Questions & Answers
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 -
reading the MySQL column in lua
amosth replied to amosth's topic in Community Support - Questions & Answers
So can you help me with the quest? -
reading the MySQL column in lua
amosth replied to amosth's topic in Community Support - Questions & Answers
I'll look into this. Could you help me with this case? -
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 =/
-
up
-
up
-
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
-
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
This is not professional. Thanks. -
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
all channels lead DC? -
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
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. -
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
I need what I said above. -
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
sorry google translate That's not what I meant.=/ ( It's not the "dc" command I need but "shutdown" Example in quest command("shutdown") Python: ""SHUTDOWN" : localeInfo.LOGIN_FAILURE_SHUTDOWN," -
shutdown enable gm logged in
amosth replied to amosth's topic in Community Support - Questions & Answers
I'll test and tell if it worked -
I would like to use the "shutdown" command but GMs should not be turned off. GMs Must Stay Connected and Not Shut Down. Can you help me?
-
complete registration for login
amosth replied to amosth's topic in Community Support - Questions & Answers
I love you -
How can I by a status wait until the e-mail is confirmed, ie .. will only be able to log in when confirming the e-mail?
-
bump
-
Hi friends block the use of the safebox on the map?
-
thanks man
-
item_proto and the calculation of wearflag to IsWELESRing2?
-
How do I add multiple items and different effects?
-
I'm using chrmgr.RegisterEffect(chrmgr.EFFECT_REFINED+21, "Bip01", "D:/ymir work/pc/common/effect/armor/roxo.mse") chrmgr.RegisterEffect(chrmgr.EFFECT_REFINED+22, "Bip01", "D:/ymir work/pc/common/effect/armor/vermelho.mse") chrmgr.RegisterEffect(chrmgr.EFFECT_REFINED+23, "Bip01", "D:/ymir work/pc/common/effect/armor/verde.mse") chrmgr.RegisterEffect(chrmgr.EFFECT_REFINED+24, "Bip01", "D:/ymir work/pc/common/effect/armor/marron.mse") chrmgr.RegisterEffect(chrmgr.EFFECT_REFINED+25, "Bip01", "D:/ymir work/pc/common/effect/armor/azul.mse")
-
Hi Can you help me with this script? case CItemData::ITEM_TYPE_COSTUME: if (refine < 7) return 0; if (pItem->GetSubType() == CItemData::COSTUME_BODY) { __ClearArmorRefineEffect(); m_armorRefineEffect = EFFECT_REFINED+EFFECT_BODYARMOR_REFINED7+refine-7; __AttachEffect(m_armorRefineEffect); } break; Error: [Hidden Content]