Register for your free account! | Forgot your password?

You last visited: Today at 12:23

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

Advertisement



Quest Problem

Discussion on Quest Problem within the WoW Private Server forum part of the World of Warcraft category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
Exclamation Quest Problem

Hey leute

Sry das ich euch mal wieder mit meinen Fragen belästige aber nunja ... ich bin gerade dabei meinen eigenen server aufzusetzen ... und es ist ja noch kein meißter vom himmer gefallen darum habe ich mich mal an die quests gesetzt und gleich bei der 1sten voll verkackt ... es geht eig alles bis auf das wenn man die quest abgibt kein gold bekommt obwohl in der spalte wo man das gold einstellt was der player bekommt was drinsteht ... und ja gegoogelt habe ich auch ... es kommt fast nur müll bei raus ... darum könnte mit jemand von euch ein teil seiner weißheit abgeben D:?
wow-player is offline  
Old 06/08/2013, 02:12   #2
 
elite*gold: 0
Join Date: Jun 2010
Posts: 762
Received Thanks: 85
patch, core?^^
Ammonit is offline  
Old 06/08/2013, 02:27   #3
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
patch ist 3.3.5a und core ist die Trinity core ^^ sry etwas müder darum vergessen
wow-player is offline  
Old 06/08/2013, 02:57   #4

 
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
TC Info:
Quote:
RewardOrRequiredMoney

Money earned by completing the quest (if value > 0). Money quest requirement (if value < 0).

RewardMoneyMaxLevel

The money a character at level 80 would get when they complete this quest. This field also controls the XP given as the XP is calculated from the value in this field by the following formula. If the quest is repeatable, XP will be given only once. The total XP that a character will receive is also affected by the level difference between the character's level and the quest's level.

The formula for calculating XP from the value in this field:
QuestLevel >= 65: XP = RewMoneyMaxLevel / 6.0
QuestLevel h1. 64: XP = RewMoneyMaxLevel / 4.8
QuestLevel 63: XP = RewMoneyMaxLevel / 3.6
QuestLevel h1. 62: XP = RewMoneyMaxLevel / 2.4
QuestLevel 61: XP = RewMoneyMaxLevel / 1.2
QuestLevel <= 60: XP = RewMoneyMaxLevel / 0.6


Von daher so:

Code:
SET @questid := '';
SET @money := '';

UPDATE `quest_template` SET `RewardOrRequiredMoney` = @money WHERE `id` = @questid;
Edit: Schönheitsfehler behoben.
Edit2: Queryfehler behoben :/
°"Crazy"° is offline  
Old 06/08/2013, 03:00   #5
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
und das ganze jetzt nochmal für einen noob der das alles mit navicat macht xD?
wow-player is offline  
Old 06/08/2013, 10:46   #6

 
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Nimmst die Query, setzt deine Daten ein und batcht es ein. Was ist daran so schwer?
°"Crazy"° is offline  
Old 06/08/2013, 12:55   #7
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
bekomme ich folgende error meldung

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 ''quest_template' SET 'RewardOrRequiredMoney' = @money WHERE 'id' = @questid' at line 1
[Err] UPDATE 'quest_template' SET 'RewardOrRequiredMoney' = @money WHERE 'id' = @questid;
[Msg] Finished - Unsuccessfully
wow-player is offline  
Old 06/08/2013, 13:05   #8

 
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Was hast du denn genau reingeschrieben? Deine Werte mit eingetragen?
°"Crazy"° is offline  
Old 06/08/2013, 13:17   #9
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
Das habe ich so bearbeitet

Quote:
SET @questid := '500400';
SET @money := '10000';

UPDATE 'quest_template' SET 'RewardOrRequiredMoney' = @money WHERE 'id' = @questid;
wow-player is offline  
Old 06/08/2013, 13:24   #10

 
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Versuche es mal so:

Code:
UPDATE quest_template SET RewardOrRequiredMoney = '100000' WHERE id = '500400';
°"Crazy"° is offline  
Thanks
1 User
Old 06/08/2013, 13:26   #11
 
elite*gold: 0
Join Date: Apr 2011
Posts: 63
Received Thanks: 3
jetzt hat er es angenommen ^^ ich starte nachher mal den server neu und berichte dann ob es geht oder nicht trotzdem danke das du dich mit dem thema beschäftigt hast und mir geholfen hast
wow-player is offline  
Old 06/08/2013, 13:30   #12

 
elite*gold: 808
Join Date: Jul 2010
Posts: 7,984
Received Thanks: 1,652
Ich hatte nur einen Fehler drin, der das nicht erlaubt hatte, die Query einzubatchen.

Solltest du noch mehr HIlfe brauchen, kannst mich in Skype adden.
°"Crazy"° is offline  
Reply

Tags
questerstellung, wow 3.3.5a


Similar Threads Similar Threads
problem with cod ./qc quest
02/17/2013 - Metin2 Private Server - 1 Replies
hey when i want active quest there problem http://store2.up-00.com/Nov12/4me94106.png
Problem mit Quest pls [HELP]!!!
12/21/2011 - Metin2 Private Server - 3 Replies
ich habe den berufs quest geschrieben .... aber erfunst nett kann mir pls wer sagen was ichd a falsch habe ich kanne mich in den quest sachen nich so gut aus .... Berufs wahl quest: quest Dein Beruf begin state start begin when login with pc.level >= 5 begin chat("Das ist nur ein Test für die States.") set_state(Dein Beruf) (Dein Beruf) end
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 +1. The time now is 12:23.


Powered by vBulletin®
Copyright ©2000 - 2026, 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 ©2026 elitepvpers All Rights Reserved.