|
You last visited: Today at 22:06
Advertisement
Hello everyone, quest problem please help
Discussion on Hello everyone, quest problem please help within the Metin2 Private Server forum part of the Metin2 category.
10/30/2014, 22:15
|
#1
|
elite*gold: 0
Join Date: Mar 2012
Posts: 4
Received Thanks: 0
|
Hello everyone, quest problem please help
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
|
what did i do wrong?
thanks in advance
|
|
|
10/31/2014, 08:35
|
#2
|
elite*gold: 50
Join Date: Apr 2013
Posts: 1,943
Received Thanks: 293
|
belongs in here ->
#moverequest
|
|
|
10/31/2014, 15:47
|
#3
|
elite*gold: 906
Join Date: Sep 2009
Posts: 17,295
Received Thanks: 4,399
|
Metin2 Main - Discussions / Questions -> Metin2 PServer - Discussions / Questions
#moved
|
|
|
10/31/2014, 17:35
|
#4
|
elite*gold: 35
Join Date: Aug 2014
Posts: 336
Received Thanks: 267
|
Code:
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
What should the quest do?
|
|
|
10/31/2014, 19:08
|
#5
|
elite*gold: 0
Join Date: Mar 2012
Posts: 4
Received Thanks: 0
|
it seems that the quest is ok but it doesnt create the table "varovania" and i dunno why...
could it be because it needs some elevated permissions or something?
|
|
|
|
Similar Threads
|
[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
|
All times are GMT +2. The time now is 22:06.
|
|