rendered paste body<dbGUI showSQL="true" title = "Quest editor for Kobold - done by Iceman"> <!-- define the name of the table and its primary key here --> <mainTable name="quests" pkey="questId"/> <!-- Allow the user to search --> <findBy> <findCol display="ID" column="questId" /> <findCol display="Name" column="title" /> </findBy> <!-- dbColumn name - name inside database display - show this text to the user panel - NORTH, SOUTH, EAST, WEST or CENTER The GUI is divided into these parts You must specify where you want the GUI element to be displayed. | NORTH | _____________________________ | | WEST | CENTER | EAST _____________________________ | SOUTH | --> <!-- dbType name - what type it is (currently ignored) minVal - if integer: no number below minVal is accepted (optional) maxVal - if integer: no number beyond maxVal (optional) if text: max number of allowed chars sizeX - the width of the TextField for the GUI (optional) sizeY - the height of the GUI component - only makes sense if (optional) 'type="textArea"' type - textArea (optional) The 'type' field is ignored, if you specify a more complex type --> <dbColumn name="title" display="Quest Title" panel="CENTER" newLine="true" gridwidth="2"> <newPanel name="Basic"/> <dbType name="text" maxVal="20" defaultVal="" sizeX="10"/> </dbColumn> <dbColumn name="questId" display="DB ID" panel="CENTER" newLine="true"> <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <!-- <dbColumn name="zoneID" display="ZoneID" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox> <cBValue name="Dun Morogh" value="4" /> <cBValue name="LongShore" value="1" /> </displayComboBox> </dbColumn> --> <dbColumn name="zoneID" display="ZoneId" gridwidth="2" panel="CENTER" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayComboBox loadFile="quest_template/zoneid.txt" /> </dbColumn> <dbColumn name="reqLevel" display="MinLevel" panel="CENTER" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questLevel" display="QuestLevel" panel="CENTER" newLine="true" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questType" display="questType" panel="CENTER" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayComboBox loadFile="quest_template/type.txt" /> <!-- See https://svn.mangosproject.org/trac/MaNGOS/wiki/Database/quest_template#Type --> </dbColumn> <dbColumn name="timeMinutes" display="timeMinutes" panel="CENTER" newLine="true"> <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questFlags" display="questFlags" gridwidth="5" panel="SOUTH" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayCheckBox combineValues="AND" direction="V" > <cBValue name="NONE" value="0" /> <cBValue name="LOOT" value="1" /> <cBValue name="EXPLORATION" value="2" /> <cBValue name="SPEAKTO-DELIVERY" value="4" /> <cBValue name="KILL" value="8" /> <cBValue name="TIMED" value="16" /> <cBValue name="CASTSPELL" value="32" /> <cBValue name="INTERACTWITH" value="64" /> <cBValue name="USEITEM" value="128" /> <cBValue name="ESCORT" value="256" /> <cBValue name="STARTEVENT" value="512" /> <cBValue name="ENDEVENT" value="1024" /> </displayCheckBox> </dbColumn> <dbColumn name="questBehavior" display="BehaviorFlags" gridwidth="5" panel="SOUTH" newLine="true"> <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayCheckBox combineValues="AND" direction="V" > <cBValue name="NONE" value="0" /> <cBValue name="DELIVER" value="1" /> <cBValue name="EXPLORATION" value="2" /> <cBValue name="SPEAKTO" value="4" /> <cBValue name="KILL" value="8" /> <cBValue name="TIMED" value="16" /> <cBValue name="REPEATABLE" value="32" /> <cBValue name="REPUTATION" value="64" /> <cBValue name="UNK 1" value="128" /> <cBValue name="UNK 2" value="256" /> </displayCheckBox> </dbColumn> <!-- Special column type: displayComboBoxRef Reference to a different table Here a reference to "quest_template" is defined Parameter: table - referenced table column - key inside the table that is referenced ignore - Do not lookup this value in the referenced table searchFor - Specify what the user may search for inside the referenced table This GUI element offers a "search" dialog, where the user can search for entries inside the referenced table. "searchFor" defines WHAT the user can search for. column - Name of the column inside the referenced table display - Show this text to the user --> <dbColumn name="prevQuests" display="No of Prev Quests" panel="CENTER" newLine="true"> <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="previousQuest1" display="prev Quest" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="quests" column="questId" ignore="0"> <searchFor column="questId" display="ID"/> <searchFor column="Title" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="nextQuest" display="next Quest" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="quests" column="questId" ignore="0"> <searchFor column="questId" display="ID"/> <searchFor column="Title" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questRaces" display="Race" panel="EAST"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayCheckBox combineValues="AND" direction="VERTICAL" > <cBValue name="Human" value="1" /> <cBValue name="Orc" value="2" /> <cBValue name="Dwarf" value="4" /> <cBValue name="Nightelf" value="8" /> <cBValue name="Undead" value="16" /> <cBValue name="Tauren" value="32" /> <cBValue name="Gnome" value="64" /> <cBValue name="Troll" value="128" /> <cBValue name="Goblin" value="256" /> <cBValue name="Bloodelf" value="512" /> <cBValue name="Draenei" value="1024" /> </displayCheckBox> </dbColumn> <dbColumn name="questClass" display="questClass" panel="EAST" > <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayComboBox loadFile="quest_template/classes.txt" /> <!-- See https://svn.mangosproject.org/trac/MaNGOS/wiki/Database/quest_template#Type --> </dbColumn> <dbColumn name="srcItem" display="Source Item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <!-- ignore: When the system receives this value, do not lookup inside the REF table--> <displayComboBoxRef table="items" column="item_id" ignore="0"> <!-- searchFor name - Name of the db column the user can search for display - Display this on the screen, a more readable form than the column name showToUser - Specified, if you want to add this column's value to the screen. Meaning this value is displayed, if the user found something --> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <!-- RequiredSkill --> <dbColumn name="questTrSkill" display="Needed Skill" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox loadFile="quest_template/skill.txt"/> </dbColumn> <!-- PANEL --> <!-- Texts --> <dbColumn name="Details" display="Details" panel="CENTER" > <newPanel name="Texts" /> <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="Objectives" display="Objectives" panel="CENTER" newLine="true"> <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="completedText" display="completedText" panel="CENTER" > <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="secondText" display="secondText" panel="CENTER" > <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="incompleteText" display="incompleteText" panel="CENTER" newLine="true"> <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="partText1" display="partText1" panel="CENTER" > <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="partText2" display="partText2" panel="CENTER" newLine="true"> <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="partText3" display="partText3" panel="CENTER" > <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <dbColumn name="partText4" display="partText4" panel="CENTER" newLine="true"> <dbType name="text" maxVal="20" defaultVal="" type="textArea" sizeX="20" sizeY="6"/> </dbColumn> <!-- PANEL --> <!-- Required --> <dbColumn name="questItemCount1" display="Num Items" panel="CENTER" > <newPanel name="Required" /> <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questItemId1" display="Required item1" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questItemCount2" display="Num Items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questItemId2" display="Required item2" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questItemCount3" display="Num Items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questItemId3" display="Required item3" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questItemCount4" display="Num Items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questItemId4" display="Required item4" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <!-- kills --> <dbColumn name="questMobCount1" display="Num mobs" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questMobId1" display="Kill mob" panel="CENTER" newLine="true" toolTip = "(value > 0) required creature ID the player need to kill in order to complete the quest."> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="creatures_templ" column="creature_id" ignore="0"> <searchFor column="creature_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questMobCount2" display="Num mobs" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questMobId2" display="Kill mob" panel="CENTER" newLine="true" toolTip = "(value > 0) required creature ID the player need to kill in order to complete the quest."> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="creatures_templ" column="creature_id" ignore="0"> <searchFor column="creature_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questMobCount3" display="Num mobs" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questMobId3" display="Kill mob" panel="CENTER" newLine="true" toolTip = "(value > 0) required creature ID the player need to kill in order to complete the quest."> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="creatures_templ" column="creature_id" ignore="0"> <searchFor column="creature_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="questMobCount4" display="Num mobs" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="questMobId4" display="Kill mob" panel="CENTER" newLine="true" toolTip = "(value > 0) required creature ID the player need to kill in order to complete the quest."> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="creatures_templ" column="creature_id" ignore="0"> <searchFor column="creature_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <!-- reputation --> <dbColumn name="repValue1" display="Reputation Value1" panel="CENTER" > <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox loadFile="quest_template/reputation_values.txt" /> </dbColumn> <dbColumn name="repFaction1" display="Faction 1" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox loadFile="quest_template/quest_factions.txt" /> </dbColumn> <dbColumn name="repValue2" display="Reputation Value2" panel="CENTER" > <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox loadFile="quest_template/reputation_values.txt" /> </dbColumn> <dbColumn name="repFaction2" display="Faction 2" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBox loadFile="quest_template/quest_factions.txt" /> </dbColumn> <!-- PANEL --> <!-- Reward --> <dbColumn name="choiceItemCount1" display="Num items" panel="CENTER" > <newPanel name="Reward" /> <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="choiceItemId1" display="Choose item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="choiceItemCount2" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="choiceItemId2" display="Choose item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="choiceItemCount3" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="choiceItemId3" display="Choose item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="choiceItemCount4" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="choiceItemId4" display="Choose item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <!-- fixed items --> <dbColumn name="rewardItemCount1" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="rewardItemId1" display="Reward Item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="rewardItemCount2" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="rewardItemId2" display="Reward Item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="rewardItemCount3" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="rewardItemId3" display="Reward Item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <dbColumn name="rewardItemCount4" display="Num items" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="rewardItemId4" display="Reward Item" panel="CENTER" newLine="true"> <dbType name="uint" minVal ="0" maxVal="10" defaultVal="0" /> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </dbColumn> <!-- misc rewards --> <dbColumn name="rewardGold" display="rewardGold" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> </dbColumn> <dbColumn name="learnSpell" display="LearnSpell" panel="CENTER" newLine="true"> <dbType name="text" maxVal="5" defaultVal="" sizeX="5"/> <displayComboBox loadFile="quest_template/spells.txt" /> </dbColumn> <!-- <dbColumn name="learnSpell" display="Spell" panel="CENTER" > <dbType name="int" maxVal="5" defaultVal="" sizeX="5"/> <displayComboBoxRef table="spell_prices" column="spell_id" ignore="0"> <searchFor column="spell_id" display="Spell" /> <searchFor column="spell_name" display="Text" showToUser="yes"/> </displayComboBoxRef> </dbColumn> --> <!-- dummy: Needed to make sure that externalRef and dbColumn do not get mixed --> <dummy/> <dummy/> <externalRef table="objectquestrelation" column="questId" display="questID" guiText="started By gameobject" panel="CENTER" newLine="true"> <newPanel name="externalREF" /> <exColumn name="objectId" display="gameobjectID"> <refersTo table="gameobj_def" column="obj_id" config="simple/gameobject_template.xml"> <searchFor column="obj_id" display="ID" showToUser="yes"/> <searchFor column="name" display="Name" showToUser="yes"/> </refersTo> </exColumn> </externalRef> <externalRef table="objectinvolvedrelation" column="questId" display="questID" guiText="ended By gameobject" panel="CENTER" newLine="true"> <exColumn name="objectId" display="gameobjectID"> <refersTo table="gameobj_def" column="obj_id" config="simple/gameobject_template.xml"> <searchFor column="obj_id" display="ID" showToUser="yes"/> <searchFor column="name" display="Name" showToUser="yes"/> </refersTo> </exColumn> </externalRef> <externalRef table="creaturequestrelation" column="questId" display="questID" guiText="started By creature-faction" panel="CENTER" newLine="true"> <exColumn name="creatureId" display="creatureID"> <refersTo table="creatures_templ" column="creature_id" config="simple/creatures_templ.xml"> <searchFor column="creature_id" display="ID" showToUser="yes"/> <searchFor column="name" display="Name" showToUser="yes"/> <searchFor column="faction" display="faction" showToUser="yes"/> </refersTo> </exColumn> </externalRef> <externalRef table="creatureinvolvedrelation" column="questId" display="questID" guiText="ended By creature-faction" panel="CENTER" newLine="true"> <exColumn name="creatureId" display="creatureID"> <refersTo table="creatures_templ" column="creature_id" config="simple/creatures_templ.xml"> <searchFor column="creature_id" display="ID" showToUser="yes"/> <searchFor column="name" display="Name" showToUser="yes"/> <searchFor column="faction" display="faction" showToUser="yes"/> </refersTo> </exColumn> </externalRef> <dummy/> <dummy/> <one2Many refCol="StartQuest" display="itemID" guiText="started by item" neutral="0" panel="CENTER" newLine="true"> <displayComboBoxRef table="items" column="item_id" ignore="0"> <searchFor column="item_id" display="ID" showToUser="yes"/> <searchFor column="name" display="Title" showToUser="yes"/> </displayComboBoxRef> </one2Many> <!-- PANEL --> <one2Many refCol="QuestID" display="RepID" guiText="quest Reputation" neutral="0" panel="CENTER" newLine="true"> <displayComboBoxRef table="questsreputation" column="QuestID" ignore="0"> <searchFor column="FactionID" display="FactionID" showToUser="yes"/> <searchFor column="ReputationAward" display="ReputationAward" showToUser="yes"/> </displayComboBoxRef> </one2Many> <!-- Help/About file --> <about file="help/html/index.html" /></dbGUI>