Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Metin2 > Metin2 Private Server
You last visited: Today at 22:06

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old   #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
cypheredu is offline  
Old 10/31/2014, 08:35   #2

 
elite*gold: 50
Join Date: Apr 2013
Posts: 1,943
Received Thanks: 293
belongs in here ->

#moverequest
Nightmare™ is offline  
Old 10/31/2014, 15:47   #3


 
Zevion's Avatar
 
elite*gold: 906
Join Date: Sep 2009
Posts: 17,295
Received Thanks: 4,399
Arrow Metin2 Main - Discussions / Questions -> Metin2 PServer - Discussions / Questions

#moved
Zevion is offline  
Old 10/31/2014, 17:35   #4
 
.Various's Avatar
 
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?
.Various is offline  
Old 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?
cypheredu is offline  
Reply


Similar Threads 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.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.