What's new
By:
  • Visit Rebornbuddy
  • Visit Panda Profiles
  • Visit LLamamMagic
  • Visit Resources
  • Visit Downloads
  • Visit Portal

Idea: Quest Order database.

j0achim

j0achim

New Member
Joined
Jan 15, 2010
Messages
532
Reaction score
15
Hey!


Was thinking of an idea, what about a "quest order" database where we add all info needed for a quest, then make a interface where you can select "pre made quest profiles" or you can make your own profile. Or "select" a quest from a "check list" example:

Code: 
Quest by zone:
+ [X] Zone 1 (Total: 27 Average Rating: 93% Selected: 27)
- [X] Zone 2 (Total: 14 Average Rating: 79% Selected: 2)
	[ ] Quest: Name of quest here (37%) Rate Good|Bad
	[X] Quest: Name of quest here (90%) Rate Good|Bad
	[X] Quest: Name of quest here (100%) Rate Good|Bad
	[ ] Quest: Name of quest here (12%) Rate Good|Bad
	[ ] Quest: Name of quest here (N/A) Rate Good|Bad
	...
+ [X] Zone 3 ...

You then select "generate quest order" and you are then given a file with all the quest orders you selected.


Now over to the interesting part, lets say we use the rating to generate quests.

We start by selecting "side" (Horde / Alliance), Include quests for both sides [yes|no], "area" (Eastern Kingdoms / Kalmidor / Outlands / Northrend), level (1-85), and rating above "Automatic (>75%) / Custom (type value 1-100) / All" you then hit "Generate Quest Order" and JavaScript then will apply the filter to the above list which you are still able to modify then "download".


This kinda project is right up my alley, as i work with SQL several hours every day. So the DB work should be done very swiftly.


To make things easier, i also had a idea making a upload interface where you can upload existing quest order profiles to the database, that way we can get away without not having to "copy, paste" information from existing quest order profiles, to fill the database.


(Ofc with a API where you can build your own plugins using the database as a back-end getting quests, much similar thetvdb.com)
 
Last edited:
This is actually a good idear, i really like it
 
would be lovely mate but unfortunately what will happen is that someone will develop a beta and then promise loads and loads of extras and the project will die just like alot of very good beta addons we have had in this community. I am not sure why this happens but it does, just hope it doesnt happen to instancebuddy
 
laurence2410 said:
would be lovely mate but unfortunately what will happen is that someone will develop a beta and then promise loads and loads of extras and the project will die just like alot of very good beta addons we have had in this community. I am not sure why this happens but it does, just hope it doesnt happen to instancebuddy
Click to expand...

ohh please not IB, realy best plugin out there !
 
laurence2410 said:
would be lovely mate but unfortunately what will happen is that someone will develop a beta and then promise loads and loads of extras and the project will die just like alot of very good beta addons we have had in this community. I am not sure why this happens but it does, just hope it doesnt happen to instancebuddy
Click to expand...

It's actually simple, some people don't apriciate the time and effort they put into the plugins/addons they make. It's basic math.
 
Well the goal would to keep it simple, ie not adding anything special.

The project itself is simple and should only take a few days to code, however that does not help if there are none who uses it. As it is solely Dependant on users making sure the data keeps a good standard.
 
interesting, but i'd say only do 58-80'ish (BC + LK) as classic will be changing very, very soon.
 
you can code this in PHP in combo with the (My)SQL database and with checkboxes what quests you want and export it into a .xml file, if you need my help with this, im up for it!
 
To make it good looking it would be CSS+Javascript+Ajax. (for the part where you select quests that is) However that is not the biggest priority.
 
the hardest part is filling the database with the right quests and their objectives
@joachim, i got all the knowledge of PHP/MySQL/JS+ajax/CSS if you need help with that
 
I was thinking this exact same thing .. although it was an offline version.. that would "merge" quest order profiles and quest overrides :D

would love to see this in action
 
I think i have a decent Database layout mapped out.

Code: 
Table: User.

id, Username, Password, Email, Registered, Activated

----------------------------------------------------------------------

Table: Quests.

id, QuestId, Name, Zone, level, faction, AddedBy, AddedTime, ModifiedBy, ModifyTime

----------------------------------------------------------------------

Table: Rating.

id, QuestId, Good, Bad, UserId

----------------------------------------------------------------------

Table: QuestProperties.

QuestId, GiverName, GiverId, NpcName, TurnInId

----------------------------------------------------------------------

Table: Objective.

id, QuestID, Type, KillCount, MobId, CollectCount, ItemId, Order

----------------------------------------------------------------------

Table: OverRide.

id, QuestId, Name

----------------------------------------------------------------------

Table: OverRide_Objective.

id, OverRideId, Type, MobId, KillCount, ItemId, collectCount

----------------------------------------------------------------------

Table: OverRide_Objective_Hotspot.

id, OverRide_ObjectiveId, x, y, z

----------------------------------------------------------------------

Table: Blackspot.

id, x, y, z, radius, zone

----------------------------------------------------------------------

Table: Vendors.

id, Name, Entry, Type, x, y, z, zone, faction

----------------------------------------------------------------------

Table: Mailboxes.

id, x, y, z, zone, faction

----------------------------------------------------------------------

Before i start i will take some time to read properly through other QuestOrder profiles to ensure i do make the Database "right" from the start.
 
Yes of course, I'm not planning on adding 2000 quests all by myself :P
 
I know of at least 2people in this comunity that already have exactly that, and there is a good reason, why it wont take off,
1. While it is pretty simple to generate a list of quest order items, the hard part isnt getting the quest data. it is getting the overrides to work just right.
2. Cata is a month away, your wasting your time, most if not all the quests are going to be changing, at least 1-60
3. Quest profiles need to be properly tested each quest you add to this project will make it even harder to maintain, i would suggest you make a few profiles first, see how it works before you start on a project of this size.
 
Didn't questy do something like this if im not mistaken? While it wasn't a database it easily pulled everything from wowhead.. Locations of hotspots, the questgivers, location sorted and importing system was nice :P. I also wonder what the apoc one uses :o
 
there once was something simmilar for ppather. also it should be considered to collect information about needed prequests for a quest.
 
Pios said:
I know of at least 2people in this comunity that already have exactly that, and there is a good reason, why it wont take off,
1. While it is pretty simple to generate a list of quest order items, the hard part isnt getting the quest data. it is getting the overrides to work just right.
2. Cata is a month away, your wasting your time, most if not all the quests are going to be changing, at least 1-60
3. Quest profiles need to be properly tested each quest you add to this project will make it even harder to maintain, i would suggest you make a few profiles first, see how it works before you start on a project of this size.
Click to expand...

The idea would have to be either #1 its a fully shared database with the community. Could even let people connect to the database with a view only user to view all tables except for "User" (duh ofc). Then it would require that people actually test a quest properly before uploading it to the database. (which is why rating system would be implemented, ie a quest is not working correct, then its a simple click to report "bad quest") #2 I make it private (or perhaps paid service). Im not trying to be a jerk but honestly making sure every quest i add is of top notch quality will take countless hours.

And yes overrides might be a problem, though im certain its not impossible to handle. If I'm not mistaken by the look I've made in several QuestOrders the questid only have to match the override so i dont see the real problem except for poor written OverRides. (again heres where the rating would do the magic)

And for Cata, yes old 1-60 profiles might never work any more, though that does not mean updated questorders should not.


And again for a "open" project like this it would require that some people would actually use some time to add quests, then regular users could later "quality check" the quests. (rating)
 
Hi all,

OK..... After some chats with well known ppl in this community we think this would deffinatly be benifitial to all quest botters.......

I had the same idea today : http://www.thebuddyforum.com/showthread.php?11781-XML-questing-server
And the idear has been mentioned before in this community.

My surgestion for an actionplan, get gothers a project 'core' team.
First objective of this team will not be to develop the application but to find if it is worth the effort.

All ppl who have XML/SQL/webservices and or plug-in development experiance please report at:
http://www.thebuddyforum.com/showth...-Quest-Order-service-Team&p=145015#post145015
 
You must log in or register to reply here.
Back
Top