Hello guys, i'm sorry if i posted in the wrong section. i have this quest:
Quote:
quest warn begin
state start beginwhen9005.chat."Add warn "with pc.is_gm()begin
say_title("Add warn: ")
say("Enter player's full name: ")local meno = input()
say_title("Add warn: ")
say("Enter reason:")
say("")local dvovod = input()
say("To grant a warning: ")
say_reward(meno)
say("because: ")
say_reward(dvovod)local acc_id = mysql_query("SELECT account_id FROM player.player WHERE name='"..meno.."' LIMIT 1 ;")
say("Your account id: "..acc_id.account_id[1].." .")
say("")local uloha =select("Yes","No")if uloha ==1then
say_title("Add warn: ")
mysql_query("INSERT INTO account.varovania (ucet_id,od,dvovod,cas) VALUES ('"..acc_id.account_id[1].."','"..pc.get_name().."','"..dvovod.."','"..os.d ate().."')")
say("Warning for "..meno.." ("..acc_id.account_id[1]..") has been granted. ")
say("Because "..dvovod..". ")
say("")else
say_title("Add warning: ")
say_reward("Warning for "..meno.." not granted. ")
say("")endendendend
and i get the following error
Quote:
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1' at line 2
[Err] CREATE TABLE `varovania`(`id`int(11) NOT NULL AUTO_INCREMENT,`ucet_id`int(30) NOT NULL DEFAULT '',`od` varchar(45) NOT NULL DEFAULT '',`dvovod` varchar(255) DEFAULT NULL,`cas` varchar(255) DEFAULT '',
PRIMARY KEY (`id`),) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1
[Msg] Finished - Unsuccessfully
quest warn begin
state start begin
when 9005.chat."Add warn "with pc.is_gm()begin
say_title("Add warn: ")
say("Enter player's full name: ")
local meno = input()
say_title("Add warn: ")
say("Enter reason:")
say("")
local dvovod = input()
say("To grant a warning: ")
say_reward(meno)
say("because: ")
say_reward("dvovod")
local acc_id = mysql_query("SELECT account_id FROM player.player WHERE name='"..meno.."' LIMIT 1 ;")
say("Your account id: "..acc_id.account_id[1].." .")
say("")
local uloha =select("Yes","No")
if uloha ==1then
say_title("Add warn: ")
mysql_query("INSERT INTO account.varovania (ucet_id,od,dvovod,cas) VALUES ('"..acc_id.account_id[1].."','"..pc.get_name().."','"..dvovod.."','"..os.d ate().."')")
say("Warning for "..meno.." ("..acc_id.account_id[1]..") has been granted. ")
say("Because "..dvovod..". ")
say("")
else
say_title("Add warning: ")
say_reward("Warning for "..meno.." not granted. ")
say("")
end
end
end
end
[Quest-PROBLEM]"Weiter"-Button, Quest schließt sich 02/01/2014 - Metin2 Private Server - 8 Replies Servus Leute,
ich habe folgendes Problem, meine "give_starter_set.quest" sieht wie folgt aus:
quest give_starter_set begin
state start begin
when login begin
say_title("Willkommen")
say("Willkommen auf TEST")
Compile all quest without quest's files list // Kompilieren Sie alle Quest ohne Quest 07/17/2011 - Metin2 PServer Guides & Strategies - 3 Replies ENGLISH
Hello dear community, this is a very simple guide but at the same time useful.
How to compile ALL quest in the folder "quest" without the files list in the file "locale_list"?
Easy!
Open the file "make" and replace the content of the file with this:
for f in *.quest; do ./qc $f; done
Oki. Now set the 0777 permission to the file.
Finally open a SSH client and sign in. Write the command:
cd /game_file_folder
[Problem] Problem with server starting - cannot find quest index for PaxHeader 12/22/2009 - Metin2 Private Server - 1 Replies Hello!
I have this same problem as here when i'm starting my server:
http://www.elitepvpers.com/forum/metin2-pserver-di scussions-questions/307143-metin2-serverfiles-ques t-index-fehler.html
But I didn't know the answer.. how to repair this?
Greetings