Ok guys, updated my server to 2.8 stable and ncdb 711 i think... anyway, updated all of the sqls for above 700.
The possible class updates are now in the class trainer.
Doing more work on Trade Vendors.
Version 1.1
Printable View
Ok guys, updated my server to 2.8 stable and ncdb 711 i think... anyway, updated all of the sqls for above 700.
The possible class updates are now in the class trainer.
Doing more work on Trade Vendors.
Version 1.1
New NCDB 866 (Or someting)...Quote:
Error occured at:2008-01-10 23:11:10
Line no.:5
Error Code: 1054 - Unknown column 'mouseFlags' in 'field list'
Like I said before I love this one but;
Why is it in there, it has the default value anyway. Not ? I manually remove this colum from the SQL queries every time there is a update...Quote:
Originally Posted by Zeo80
Just replace :
insert into `creature_names` (`entry`, `name`, `subname`, `mouseFlags`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('100009','Class Spell Trainer','Ackhole Custom Trainers','0','0','4','0','3','0','0','18106','18106','0','0','1','1','0','0');
For
insert into `creature_names` (`entry`, `name`, `subname`, `Flags1`, `type`, `family`, `rank`, `unk4`, `spelldataid`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `civilian`, `leader`) values('100009','Class Spell Trainer','Ackhole Custom Trainers', '0','4','0','3','0','0','18106','18106','0','0','1','1','0','0');
Everywhere....
Basically `mouseFlags` will be set to 0 anyway as default, why is it in there, only to create issues with NCDB versions ?
Hm, im pretty sure i did. What sql did you find this in?Quote:
Originally Posted by Zeo80
Mouseflags should have been replaced with info_str
Version 1.2 Released!
Ackhole's Projects Download Page
Finally finished Trade Vendors, spawns is included.
I need some input on two things though.
1. I need some display IDs and some good locations for the different things in my Custom trainers and vendors.
2. Also, was wondering if anyone had any ideas on what I should do next :-)
Let me know any errors I made, i should have gotten that darn `mouseflags` out by now....
Thanks!
Link is down
Shouldn't be, works fine for me.
Ackhole's Projects Download Page
1st: I added my own version of portals to GM Island, one which needs a Donation Reward to activate from the main cities. Thanks to Kazz for finishing it for me, I <3 you!
2nd: I did the following, which I added to the Class Trainer. Thanks to whoever told me this list :-)
warrior:
mortal strike rank 2
paladin:
summon charger Added for Bloodelfs
summon warhorse Added Both
redemption rank 1
priest:
shadowprotection rank 2
devouring plague rank 1 Added (Requires Undead i think)
shaman:
searing totem rank 1
stoneskin totem rank 1
healing stream totem rank 1
warlock: ritual of doom
rogue:
eviscerate rank 2
slice and dice rank 1
sinister strike rank 2
sprint rank 1
evasion rank 1
sap rank 1
instant poison rank1
deadly poison rank 1
mind-numbering poison rank 1
crippling poison rank 1
wound poison rank 1
Mage Teleports, define for Alliance and Horde. Working on it.
Version 1.3, and let me know if the download link is still causeing issues, ill have to upload it somewhere else maybe....
If your having issues connecting, someone suggested this:
Ackhole's Projects Download Page
Update: Thanks Yimgame from NCDB forums for the tool to help people update it more efficently! I <3 you almost as much as Kazz!
Version 1.4
Thanks to DBE, I now have an SVN!
http://projects.emupedia.com/svn/dbe.../trunk/Ackhole
Is all there baby!
Starts at version 1.4
Tool.bat is done! ABOUT TIME..... You can use the svn, or the same old download space....
SVN:
http://projects.emupedia.com/svn/dbe.../trunk/Ackhole
Regular Download:
Ackhole's Projects Download Page
My SVN has changed too
http://projects.emupedia.com/svn/dbe.../trunk/Ackhole
You got Vendors In it too ?
Its all in the SVN, The same with the regular downloads page. I keep them both updated :-)
Forgot to mention that the tool.bat is now fully operational, and that even the mouse pointers fix is included!
Added a quest for the Ackhole Portal project, to get the Donation Reward. (Will change name of it later) Also, added another spawn of the portal to Shatt.
Version 1.5
Modified so the Quest Givers don't attack sorrounding guards and such.
Still 1.5
These trainers have been Redone into Ackhole Custom Mall, located here.
http://forum.ragezone.com/f114/ascen...0/#post3165757