TerraNet Database Revision 8

[channel_49]

TerraNet Database Revision 8

Since Angel/Lemon doesn't come to ragezone a lot, I'll officially post TerraNet Database releases on this forum from now on. Although this is a really late post, its better than nothing :).


Angel's original description of TNDB:

A complete DataBase, TNDB brings you a lot of new fixes and improvements as usual. On this revision we tried to concetrate on loots.

Thanx to the tool Channel_49 made we were able to rip off complete data from WOWhead when it comes to creatureloot, objectloot, skinningloot, quest starters finishers etc.

This revision has completely finished 8 tables and are 99% blizzlike.

We have also worked on little improvements in all other parts of DB from spawns, creature stats adding new 2.1.3 content, quest works.

Thanx to Darkid for his work on creature_names and creature_proto!
Thanx to Volition for hughe number of quest fixes!

Some quest fixes have been done so we disabled some of the spells that can be learned by Quests. If the quest are not working with you, just remove the spell from spell_disable_trainers.

We have also added some AI_Agents to make the game more enjoyable. Please report BUGS so we can fix them more easily.

This database is compatible with the latest Ascent cores, I personally have tested it for Ascent rev 1033.



Revision 8 Project Team:

• Lemon - Project Leader
• Channel_49 - Project Leader
• Volition - Project Sub-Leader
• Onemore - Project Sub-Leader
• Teto18 - Trainers Master
• Devincean - Items and everything else
• Evilgb - Spawning
• dhiB - team member
• darkid11 -team member(retired)
• Vertazzar - Creature Stats
• SorcererMerlin - C++, c#, PHP coding support
• Valkirie - Team Member - a lot of fixes
• Hitmanblack - Newest item and content updates
• Icemaster - multiple Quest fixes
• Immortal - multiple fixes

A thank you to all those non-team members who submitted fixes for this database.



Revision 8 Changelog:

• Orphan Matron Nightingale - pepsi1x1
• Numerous creature_name and proto fixes - darkid11
• Numerous item clean up - corpusrottus
• More accurate reqenchantskill - corpusrottus
• More item clean up - channel_49
• Correction of item sheath - channel_49
• Kobold's emote - rizzo2
• Complete skinningloot table - channel_49
• Complete Gameobject and creature quest_starter and finisher tables - channel_49
• Complete vendor table and buyprice for vendor items - channel_49
• New worldmap_info - darkid11
• Numerous spawn and rare spawns fixes - bwkclan
• Blood elf and draenei starting language fix - teto18
• Numerous trainers and riding instructor fixes - teto18
• Many loot fixes and additions - silent
• Many quest fixes and tweaks - silent
• And a lot of other fixes that are too detailed to list

Links:

depositfiles: TNDB Rev8
sendspace: TNDB Rev8
rapidshare: TNDB Rev8
filebeam: TNDB Rev8

TerraNet WoW Forums



Channel_49,
TerraNet Development WoW Community

[MentaL]

[resinate]

post dl links not forums, posting forums is against the rules. i got in fract for posting my forum and that was for my server. so sry mate u have to follow the rules too.


for those who want to dl this heres the link

Filebeam - Free Fast File Hosting

[popttt]

i wonder why there are portals in blood elf starting place and all city? same on official?

[Bearmen]

Why cant make portal in Stormwind to shattrah or Darn to Shattrah etc...

[OSP]

Erm who told you Terranet its Same like Oficial?Will never be Like oficial ,why should we be a copy of oficial ?We can do our things more pleasant then oficial...

Cheers Immortal !!

[popttt]

Erm who told you Terranet its Same like Oficial?Will never be Like oficial ,why should we be a copy of oficial ?We can do our things more pleasant then oficial...

Cheers Immortal !!

but i heard of that its blizz-like.

[Bloodshed2007]

first of all...YAY!
second of all...i got to congratulate u on ur excellent work...

i was wondering if with the rev 8 db can extract the lvl 40 and 60 mount versions of the Spectral Tiger...i am using the databaseevolved one and that doesnt come with and i really would like it :)..

-Bloodshed-

p.s cant wait for the next database

[resinate]

WARNING TO ALL> there is a nasty bug with the new gems. they are not 100% done in the 2.2 so if u use them they will not sockest correctly. i was reading thro and saw them. didnt think they added them lol so wasnt gonan say anything.

also theres 6 broom mounts

heres the spell id for 2 of them
42668=flying
42683=ground

i have all 6 alrdy added, so giving 2 away wont hurt XD.

and yes i do have an account on tn i made 1 post to keep my account XD.

[Bloodshed2007]

thanks for the spell id...can u put on the item aswell plz?

-Bloodshed-

[resinate]

nah i gave all they need to add them. lol theyll have it in rev 9

btw u guys missed 3 gems
Mystic Bladestone(lower right corner)
Sparkling Falling Star(upper right corner)
Brillant Bladestone(upper right corner)

heres the screen for it.

http://img77.imageshack.us/img77/5621/image2im5.gif

enjoy

[Bloodshed2007]

hmm...ok...if i wanted to make the item would i need to create a entry in creature_names aswell? or should i just create the item?

btw can u tell me what the displayid is for the item? (and creature_name if needed)

thanks

-Bloodshed-

[resinate]

to make a working mount thats brand new u need

item id
spell id
creature_name display id
creature_name id
creature_proto id.

[Bloodshed2007]

so....i would need to create the entry for the broomstick..i got:

insert into `items` (`entry`, `class`, `subclass`, `field4`, `name`, `name2`, `name3`, `name4`, `displayid`, `quality`, `flags`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSkillSubRank`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `unk203_1`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ItemExtendedCost`, `ReqDisenchantSkill`, `unk2`) values('88776655','15','0','-1','Ridable Broomstick','Ridable Broomstick','Ridable Broomstick','Ridable Broomstick','17608','4','64','0','1000000','0','262143','2147483647','60','60','762','150','0','0','0','0','0','0','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','42668,'0','0','0','330','3000','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','','0','0','0','0','0','-1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','-1','0');

i used the spell id in that...

i need to create a creature_names entry like:

insert into `creature_names` (`entry`, `creature_name`, `Subname`, `Flags1`, `type`, `Family`, `Rank`, `unk4`, `SpellDataID`, `displayid`, `unk2`, `unk3`, `Civilian`, `Leader`) values('88776655','Broomstick','','0','0','0','0','0',NULL,'(DISPLAYID)','1','1',NULL,NULL);

whats the displayid for the mount?

and then a creature_proto which i will do in a bit...

is that what i have to do?

-Bloodshed-

[n4ru70h4x0r]

if there is not Display id for a broomstick you can't, but i believe you can use the blood elf broomstick in the belf starting area. However, i do not believe there is a riding position for the broom so i doubt it will work, try anyway

[Hellfirespectre]

Why is Naxx not in this version? How can we put it in?

[channel_49]

Don't post our direct download links. All downloads of our db goes back to our forums, its our content.

I havn't been around for 2 weeks, so new content you'll have to post the bugs on our forums and we'll get to fixing them.

[n4ru70h4x0r]

@channel_49: well then remove your links too... you can't have forum links like resinate stated... so it seems like if you don't want resinate to post links, you can't post forums, it seems like it's impossible to release it without infracting the rules. :) Seems like you have no choice but to allow resinate to post ;) Pwned by the Rules.

[channel_49]

First of all, you're using our content, and I presume you used my gm vendors too, so don't be talking to me with attitude.

Resinate is just angry that we banned him from our forums for leeching. I'll post the download links, but our own links remain as well, its our content.

[n4ru70h4x0r]

@channel_49: im sorry if i offended you, I really did ot mean to. And yes I am using your vendors, thnx for that. Again, I did not intend to offend you with my post.:rip:

[martinbt]

One question can i use this DB without ascent because i got older Rev ???

[resinate]

Resinate is just angry that we banned him from our forums for leeching. I'll post the download links, but our own links remain as well, its our content.

dude my db has 10x the shyt urs does u fool u cant even make all them gems u have 10/13 u have 2/8 mounts u dont even have any zul amen made or spawned. ur db is a POS

and u noob u banned 1 of my accounts i have 3 more accounts.

ur team knows nothing.

btw u have 2200+ npcs busted to my what 10 yea my db soo sucks lol. u guys r teh ones leeching off me lol u noobs.

and this is why i stopped releasing my db cuz no one deserves them. only one person treulyl earned his way to use the db and he helped me greatly for it.

and ur noob db cant even keep a server online for no more then 8 hours. mine runs 4 to 7 days ez

for those who says i have no proof look at the thread i made of the screen shots.

[n4ru70h4x0r]

@resinate: calm down... don't flame. And if so where is this "10x" DB? HMM???
@martinbt: yes

[resinate]

terranet is a joke has been since rev 4.

[channel_49]

@resinate: Then stop taking our content, and stop posting in our release threads. If you dont like us, then leave us alone. In simpler terms, piss off.
And fyi, I don't have a server.

@n4ru70h4x0r: No harm done, just wasn't in the mood. Ever since we made peace with ascent, all these old antrix bandwagoners are just really irritating.
Don't be mistaken, I'm talking about someone else in this thread who cant seem to leave me alone.

[resinate]

dude u guys r taking my shit, ive had the items in my db over 3 weeks now to ur 3 days. u guys r the theives now. so stuff it

http://img186.imageshack.us/img186/4...7141826xd8.jpg

http://img47.imageshack.us/img47/923...7014525ls6.jpg

http://img47.imageshack.us/img47/770...7134734nm5.jpg

http://img380.imageshack.us/img380/3...7161600tb8.jpg

NAME ONE SERVER WITH THAT.

u guys riipped shit outta my rev 3 that i released. so shut the f up. and go back to terra forums.

terra r rip offs, hope they get ddos

watch terranet rip off my warper npc just watch them gooo.