Quest table dumped to SVN

Hya,

I've dumped the current quest table into SVN. The difference is, is that each quest have it's own file.
It can be re-run any time fixing 'just' that one quest you where looking for, without toughing anything else..
(I also included a build.bat which rebuilds all quests into 1 file, so you can rebuild all if you want.)

You can also add this php to your webroot, so you can dump from your own database directly too.
(check sql setting inside; copy it to your webroot folder and access it with http://localhost/quest.php?qid=7 This will show dump for quest 7)


PS Realy suggest to use SVN so we can track our changes and monitor our progress.
So please people, post you're fixes (or URL to fixes ) here, so we can update SVN..

Great , im in

Ace, realy great work.
I will see if I can contribute.

But I found a little problem

Code:

-- NPC Quest Starter
DELETE FROM `creaturequestrelation` WHERE `questid` = 66
INSERT INTO `creaturequestrelation` SET `creatureId` =265, `questId` = 66;

In every SQL file I checked the line DELETE FROM `creaturequestrelation` ... is not cloced with an ;

I do not know how you created the sql file, probably in an automated way. Could you please fix it.

bartus wrote:

Ace, realy great work.
I will see if I can contribute.

But I found a little problem

Code:

-- NPC Quest Starter
DELETE FROM `creaturequestrelation` WHERE `questid` = 66
INSERT INTO `creaturequestrelation` SET `creatureId` =265, `questId` = 66;

In every SQL file I checked the line DELETE FROM `creaturequestrelation` ... is not cloced with an ;

I do not know how you created the sql file, probably in an automated way. Could you please fix it.

Line 15 in the ones I tried

Right you are :-/

Updated svn (also found out I forgot to add files to 9000-9999, so did that too...

Yep thX i will try too.

new problem for me anyways. ( I am probably doing something wrong) when I try to use the build.bat I get this ---->



What am I doing wrong? (btw I put @pause in it so as to see error)

Fixed ;P

WHEN EXECUTE TABLES (((

[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 '-- MySQL Data Transfer
-- parsed by ldt
-- Quest Template
-- Remove commented ' at line 3
[Msg] Finished - Unsuccessfully

remove the 

ace is it possible to make a php scipt like that but this time it exports the creature numbers you enter?

tnx

Possible but quests are not finished yet , what about creature loot / gameobj loot ?

QuestID - 9305

Quote :

-- shouldn't be given by a mob
DELETE FROM creatures_loot WHERE item_id='22978';

-- delete object if its exist , and it should be (i think)
DELETE FROM gameobj_def WHERE obj_id='181283';

-- inserting this one , should work nice with quests.
INSERT INTO gameobj_def
(obj_id, name, model, data0, data1, data2, data3, data4, data5, data6, data7, data8, data9, data10, data11, data12, data13, data14, data15, data16, data17, data18, data19, data20, data21, data22, data23, faction, flags, gtype, size, level, art_kit, anim_progress)
VALUES
(181283, "Emitter Spare Part", 6778, 43, 100889, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 12, 0, 3, 1, 0, 0, 0);

-- inserting loot
INSERT INTO `gameobj_loot` (`objloot_id`,`obj_id`,`item_id`,`chance`) VALUES ('100889','181283','22978','100')

what about making the sme dump for mobs and GO's
but then not with 1 but every 10/20/30/40/50

just an crazy idea

Not crazy, but a lot of work though...
We will see...

if u tell me the sql syntax i can do that

ace thats what i did , tell me if i have to cange someting or add someting
http://rapidshare.com/files/24601797/creature.rar

Ah...you found the php it I see :-)

Looks good ;-)

As svn creatures_templ might be a bit out-of-date, you mind posting (or PM) the code?

it is a python script
http://rapidshare.com/files/24609130/creature_expot.py

just edit the connection int th third line (passwor user db) and run the script, it s extrakting in c:\creature
o and edit HierstCreatureID

cool nice job joke
but ace i was wondering something.
if we got a creatures_templ with is full from reature 1 all the way to let's say 50K
but only a 1/4 or 2/4 is spawned from it would it couse lud to use more resource?
i was thinking of adding all the mobs even trough there not right model/faction and stuff just take the info from mob 1 in the creatures_templ (spawn point) that way if i see a npc/mob missing ingame i will add it to world correct faction/flags/model.
becouse atm if i add something to DB while server is runing i have tor estart it to spawn it wich sux if u ask me

aries

i can script that in about 10 min if u want

that would be great ^^
saves me alot of trouble

makes it more easy todo stuff.
i make edit them then export them with an php scrit i got 1 mob/npc at a time
that way even the smallest things can be edited wihtout having to change whole templ

ok this is the sql file thet adds the missing creatures in creature temlate from the svn as a spawn point
http://rapidshare.com/files/24636399/add.sql
and this ist the script i made
http://rapidshare.com/files/24636680/addspawnpoint.py

Nice job Joke... switched to py I see
my parser is php based

hello,

what am i doing wrong?
when i execute the .bat i get a 33bytes "all_quest.sql" but there are no quests inside...

hotSpitta

did i do this for nothing?