TerraNet DB Help & Support[Latest Revisions]

Quote:

---

Hello everybody,
Long expected TerraNet - ProjectSilvermoon DataBase Revision 6 is finally out.We bring you a great deal of new fixes, spawns, new added items, and overall blizzlike content.Thanx to all the supportive comunities.Thanx to TerraNet for hosting, also ProjectSilvermoon for hosting and supporting the DB.Thanx to all PPL who posted fixes here.Thanx to all PPL who use the DB and enjoying thier servers without serious flaws in DB.Enjoy in this new revision as you did with all of them.

This Revision is brought to you by the Development Team which consists of:

* Lemon - Project Leader
* Utsjitimmie - Project Leader
* Onemore - Project Sub-Leader
* Teto18 - Trainers Master
* Channel_49 - Items Master
* Devincean - Items and everything else
* Evilgb - Spawning
* Volition - Whining and Taking Care of everything
* Vertazzar - Creature Stats

Also we want to thanx to: CasaCorpus Team, skidac, felenna, Volvo132, sorcermerlin

IMPORTANT: This DataBase will be published only by TerraNet and Project Silvermoon, and no one else has no right to publish its modified version.It can only be published in repacks without any changes made, which means in the state that it has been published, without any updates or fixes included, since TerraNet and Project Silvermoon hold the right on this DB and only those comunities can release revisions of the same.
Resinate blow us

COMPATIBLE WITH ANTRIX REV 575

IMPORT ONLY WITH SQyog OR PS BACKUPER-IMPORTER

Please pay attention to README, you also have it in your downloaded folder.

README:
This database edition, just like the rev5 doesn`t contain character related tables, nor you need to backup them and reimport.All you have to do is just import this DataBase on your existing one.

It has been dumped so it has "Drop SQL query" in front of every insert or create query, so it will just replace the data you had in rev4 with this new data in rev6 without any modifications to your character or account related tables.

Srry for not releasing it in Changesets, but there is a lot of things we fix ingame, so its impossible to get all of that in SQL.

IMPORTANT: Instruct your players to delete their Cashe folder before entering the game, to avoid possible tickets biggrin.gif

Just in case someone is using this DB for the first time, I included character related tables too.

WARNING: DataBase structure is compatible with the latest revision of Antrix Core


LINKS

TNPS DataBase - filebeam
TNPS DataBase - rapidshare
TNPS DataBase - sendspace

CHANGELOG

* Fixed half of the trainers, few more left to go - thanx Teto
* Spawned more vines in the world - thanx Volvo132
* Fixing some wrong spawns, and creature IDs
* Spawned Old Hyjal - Thanx to Tim
* Spawned Gruuls Lair - some bosses needed, but missing due to being scripted
* Fixed profession trainers - thanx Onemore, possible unclickable trainers, please report if you find
* Fixed great deal of displayIDs - few more left
* Well I think the loot problem has been eliminated now, no more double loots and still working on improving the percentchances to fit the blizzlike standards.(blizzlike loots in Black Temple, Karazhan, The Eye, Serpent (only bosses) - thanx for the tool to skidac
* Added Complete Merciless Gladiator PVP Sets - thanx Devincean
* Added Missing Merciless Gladiator Weapons - Channel
* Added Other Missing Weapons from Hyjal - Channel
* Added a ton of missing items - thanx Channel
* Fixed all auction houses, and linked them together.All Ally AHs are linked and all Horde also, Gadzetzan is linked with bootybay
* Added proffesion recepies - thanx sorcermerlin
* Removed all those unclickable creatures, that I managed to find, report if you find some new please
* Fixed a lot of quest Reputation Rewards - thanx CasaCorpus Team and felenna
* Spawned Magtheridon`s Lair - not fully blizzlike*
* Started adding spells to bosses in various instances - only first steps
* Fixed all reported errors with trainers - PLEASE NOTE "REPORTED" which means there could be some more flaws with trainers-PLEASE REPORT THEM AND I WILL FIX
* Black Temple spawned(not fully) - Spawning Tim, Loots Lemon, Stats Vertazzar
* Slave Pens spawned - Thanx Evilgb

---

The OLD DB

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

Quote:

---

TerraNet DataBase for Antrix revision 5

Here we have the fifth in line revision of TerraNet DataBase for Antrix.
As always we bring you many fixed things added items, quests, sawns and everything else to make your gameplay more enjoyable.You can see what has been fixed in this rev, and much more which I cannot remember now.I added credits to those I could remember, but if I missed someone, then please PM me and I will add you.
As always this DB edition was brought to you by TerraNet Development Team with help from all sides, Project Silvermoon, Ragezone, WoWPS and many other comunities and individuals who posted their fixes for this DB, and I want to thank you all for that.

IMPORTANT: This DataBase will be published only by TerraNet and Project Silvermoon, and no one else has no right to publish its modified version.It can only be published in repacks without any changes made, since TerraNet and Project Silvermoon hold the right on this DB and only those comunities can release revisions of the same.
Resinate blow us

Please pay attention to README, you also have it in your downloaded folder.

README:
This database edition, just like the rev4 doesn`t contain character related tables, nor you need to backup them and reimport.All you have to do is just import this DataBase on your existing one.

It has been dumped so it has "Drop SQL query" in front of every insert or create query, so it will just replace the data you had in rev4 with this new data in rev5 without any modifications to your character or account related tables.


IMPORTANT: Instruct your players to delete their Cashe folder before entering the game, to avoid possible tickets

Just in case someone is using this DB for the first time, I included character related tables too.

WARNING: DataBase structure is compatible with the latest revision of Antrix Core, but after I tested the cores, they are really fucked up, so if you wanna have the best experience stick to rev 354 as I do.


Cheers,
Lemon,
TerraNet WoW Comunity
Project Silvermoon Development Forums

LINKS:

TerraNet DB Rev5 - Filebeam
TerraNet DB Rev5 - sendspace
TerraNet DB Rev5 - Rapidshare


CHANGELOG:

* Added more veins to the world
* Ahn`Qiraj Temple fully spawned
* Ahn`Qiraj Ruins fully spawned
* New Missing Items added - thanx to Supermann
* Removed Elementals in front of Dark Portal - thanx to Devincean
* Fixed Quest rewarding for starting Draenei and BE quests
* Added arround 600 new items parsed from wowhead, armory, thotbott, allakhazam and combined
* Spawned herbs in the world - thanx to Volvo132
* Corrected BT loot items - thanx to Madmatt
* Quest updates - thanx to Excalibur Team
* Supremus loot modified - thanx Madmatt
* Fixed HP of more than 600 creatures - thanx to Cataclysm


Download Folder Contains:

* TerraNet DB Rev5
* Character Related Tables
* PS Backuper
* Readme

---

Thanx to terranet team!

NEWEST CORE

rev:557 download

rev:550 download

rev:546 download

rev:544 download

rev:541 Download

| commands | 1 | Shows Commands |
| help | 1 | Shows help for command |
| announce | u | Sends Msg To All |
| wannounce | u | Sends Widescreen Msg To All |
| appear | v | Teleports to x's position. |
| summon | v | Summons x to your position |
| banchar | b | Bans character x with or without reason |
| unbanchar | b | Unbans character x |
| banreason | b | Shows the reason for ban |
| kick | b | Kicks player from server |
| kill | r | .kill - Kills selected unit. |
| revive | r | Revives you. |
| reviveplr | r | Revives player specified. |
| morph | m | Morphs into model id x. |
| demorph | m | Demorphs from morphed model. |
| mount | m | Mounts into modelid x. |
| dismount | 1 | Dismounts. |
| gm | p | Shows active GM's |
| gmoff | t | Sets GM tag off |
| gmon | t | Sets GM tag on |
| gps | p | Shows Position |
| info | p | Server info |
| worldport | v | No description. |
| save | s | Save's your character |
| saveall | s | Save's all playing characters |
| security | z | No description. |
| start | m | Teleport's you to a starting location |
| levelup | m | No description. |
| additem | m | No description. |
| createguild | l | No description. |
| invincible | j | .invincible - Toggles INVINCIBILITY (mobs won't attack you) |
| invisible | i | .invisible - Toggles INVINCIBILITY and INVISIBILITY (mobs won't attack you and nobody can see you, but they can see your chat messages) |
| resetreputation | n | .resetreputation - Resets reputation to start levels. (use on characters that were made before reputation fixes.) |
| resetlevel | n | .resetlevel - Resets all stats to level 1 of targeted player. DANGEROUS. |
| resetspells | n | .resetspells - Resets all spells to starting spells of targeted player. DANGEROUS. |
| resettalents | n | .resettalents - Resets all talents of targeted player to that of their current level. DANGEROUS. |
| resetskills | n | .resetskills - Resets all skills. |
| learn | m | Learns spell |
| unlearn | m | Unlearns spell |
| learnskill | m | .learnskill <skillid> (optional) <value> <maxvalue> - Learns skill id skillid. |
| advanceskill | m | advanceskill <skillid> <amount, optional, default = 1> - Advances skill line x times.. |
| removeskill | m | .removeskill <skillid> - Removes skill |
| increaseweaponskill | m | .increaseweaponskill <count> - Increase eqipped weapon skill x times (defaults to 1). |
| createaccount | z | .createaccount - Creates account. Format should be .createaccount username password email |
| playerinfo | z | .playerinfo - Displays informations about the selected character (account...) |
| uptime | 1 | Shows server uptime |
| getpos | d | No description. |
| removeauras | m | Removes all auras from target |
| paralyze | b | Roots/Paralyzes the target. |
| unparalyze | b | Unroots/Unparalyzes the target. |
| setmotd | m | Sets MOTD |
| additemset | m | Adds item set to inv. |
| gotrig | v | Warps to areatrigger <id> |
| createinstance | m | Creates instance on map <map> |
| goinstance | m | Joins instance <instance> <x> <y> <z> <optional mapid> |
| exitinstance | m | Exits current instance, return to entry point. |
| dbreload | m | Reloads some of the database tables |
| spawnspiritguide | m | Spawns a spirit guide (params: 1 = horde, 0 = alliance |
| servershutdown | z | Initiates server shutdown in <x> seconds. |
| serverrestart | z | Initiates server restart in <x> seconds. |
| allowwhispers | c | Allows whispers from player <s> while in gmon mode. |
| blockwhispers | c | Blocks whispers from player <s> while in gmon mode. |
| advanceallskills | m | Advances all skills <x> points. |
| killbyplayer | f | Disconnects the player with name <s>. |
| killbyaccount | f | Disconnects the session with account name <s>. |
| unlockmovement | m | Unlocks movement for player. |
| castall | z | Makes all players online cast spell <x>. |
| getrate | f | Gets rate <x>. |
| setrate | f | Sets rate <x>. |
| modperiod | m | Changes period of current transporter. |
| npcfollow | m | Sets npc to follow you |
| nullfollow | m | Sets npc to not follow anything |
| formationlink1 | m | Sets formation master. |
| formationlink2 | m | Sets formation slave with distance and angle |
| formationclear | m | Removes formation from creature |

----------------------------------------------------------------------------------------------------
modify
----------------------------------------------------------------------------------------------------
| hp | m | Health Points/HP |
| mana | m | Mana Points/MP |
| rage | m | Rage Points |
| energy | m | Energy Points |
| level | m | Level |
| armor | m | Armor |
| holy | m | Holy Resistance |
| fire | m | Fire Resistance |
| nature | m | Nature Resistance |
| frost | m | Frost Resistance |
| shadow | m | Shadow Resistance |
| arcane | m | Arcane Resistance |
| damage | m | Unit Damage Min/Max |
| scale | m | Size/Scale |
| gold | m | Gold/Money/Copper |
| speed | m | Movement Speed |
| nativedisplayid | m | Native Display ID |
| displayid | m | Display ID |
| flags | m | Unit Flags |
| faction | m | Faction Template |
| dynamicflags | m | Dynamic Flags |
| talentpoints | m | Talent Points |
| loyalty | m | Loyalty |
| spirit | m | Spirit |
| boundingraidus | m | Bounding Radius |
| combatreach | m | Combat Reach |
| emotestate | m | NPC Emote State |

----------------------------------------------------------------------------------------------------
debug
----------------------------------------------------------------------------------------------------
| infront | d | No description. |
| showreact | d | No description. |
| aimove | d | No description. |
| dist | d | No description. |
| face | d | No description. |
| moveinfo | d | No description. |
| setbytes | d | No description. |
| getbytes | d | No description. |
| unroot | d | No description. |
| root | d | No description. |
| landwalk | d | No description. |
| waterwalk | d | No description. |
| castspell | d | .castspell <spellid> - Casts spell on target. |
| castspellne | d | .castspellne <spellid> - Casts spell on target (only plays animations, doesnt handle effects or range/facing/etc. |
| celldelete | d | !USE WITH CAUTION! '.celldelete YES' - Removes everything in current cell from game and database. '.celldelete YES YES' removes everything in a range of 1cell. |
| addrestxp | d | .addrestxp - Adds x rest XP to player. |
| generatename | d | .generatename - Generates name for pet, etc. |
| attackerinfo | d | .attackerinfo - Shows selected mob/player's attacker's infomation. |
| showattackers | d | .showattackers - Shows selected mob/player's attacker on the minimap. |
| aggrorange | d | .aggrorange - Shows aggro Range of the selected Creature. |
| knockback | d | .knockback <value> - Knocks you back. |
| fade | d | .fade <value> - calls ModThreatModifyer(). |
| threatMod | d | .threatMod <value> - calls ModGeneratedThreatModifyer(). |
| calcThreat | d | .calcThreat <dmg> <spellId> - calculates threat. |
| threatList | d | .threatList - returns all AI_Targets of the selected Creature. |
| gettptime | d | grabs transporter travel time |
| itempushresult | d | sends item push result |
| weather | d | No description. |
| setbit | d | No description. |
| setvalue | d | No description. |

----------------------------------------------------------------------------------------------------
waypoint
----------------------------------------------------------------------------------------------------
| add | w | Add wp at current pos |
| show | w | Show wp's for creature |
| hide | w | Hide wp's for creature |
| delete | w | Delete selected wp |
| movehere | w | Move to this wp |
| flags | w | Wp flags |
| waittime | w | Wait time at this wp |
| emote | w | Emote at this wp |
| skin | w | Skin at this wp |
| change | w | Change at this wp |
| info | w | Show info for wp |
| movetype | w | Movement type at wp | The rest are below, post was too long.

Heres the rest

Quote:
----------------------------------------------------------------------------------------------------
gameobject
----------------------------------------------------------------------------------------------------
| select | o | Selects the nearest GameObject to you |
| delete | o | Deletes selected GameObject |
| spawn | o | Spawns a GameObject by ID |
| info | o | Gives you informations about selected GO |
| activate | o | Activates/Opens the selected GO. |
| enable | o | Enables the selected GO for use. |
| scale | o | Sets scale of selected GO |
| animprogress | o | Sets anim progress |
| export | o | Exports the current GO selected |

----------------------------------------------------------------------------------------------------
battleground
----------------------------------------------------------------------------------------------------
| setbgscore | e | <Teamid> <Score> - Sets battleground score. 2 Arguments. |
| startbg | e | Starts current battleground match. |
| pausebg | e | Pauses current battleground match. |
| bginfo | e | Displays information about current battleground. |
| battleground | e | Shows BG Menu |
| setworldstate | e | <var> <val> - Var can be in hex. WS Value. |
| playsound | e | <val>. Val can be in hex. |
| setbfstatus | e | .setbfstatus - NYI. |
| leave | e | Leaves the current battleground. |

----------------------------------------------------------------------------------------------------
npc
----------------------------------------------------------------------------------------------------
| vendoradditem | n | Adds to vendor |
| vendorremoveitem | n | Removes from vendor. |
| name | n | Changes creature name |
| subname | n | Changes creature subname |
| flags | n | Changes NPC flags |
| emote | n | .emote - Sets emote state |
| run | n | No description. |
| addweapon | n | No description. |
| allowmove | n | No description. |
| addgrave | n | No description. |
| addsh | n | No description. |
| addspirit | n | No description. |
| spawn | n | <entry> <flags> <faction> <level> <name> |
| spawnentry | n | <entry> |
| delete | n | Deletes mob from db and world. |
| info | n | Displays NPC information |
| guid | n | Shows selected object guid |
| addAgent | n | .npc addAgent <agent> <procEvent> <procChance> <procCount> <spellId> <spellType> <spelltargetType> <spellCooldown> <floatMisc1> <Misc2> |
| delAgent | n | .npc delAgent <procEvent> <spellId> |
| listAgent | n | .npc listAgent |
| reset | n | resets npc health/dmg from temp table. |
| export | n | Exports the npc to a sql file |
| say | n | .npc say <text> - Makes selected mob say text <text>. |
| yell | n | .npc yell <Text> - Makes selected mob yell text <text>. |
| come | n | .npc come - Makes npc move to your position |
| return | n | .npc return - Returns ncp to spawnpoint. |

----------------------------------------------------------------------------------------------------
cheat
----------------------------------------------------------------------------------------------------
| status | m | Shows active cheats. |
| taxi | m | Enables all taxi nodes. |
| cooldown | m | Enables no cooldown cheat. |
| casttime | m | Enables no cast time cheat. |
| power | m | Disables mana consumption etc. |
| god | m | Sets god mode, prevents you from taking damage. |
| fly | m | Sets fly mode |
| land | m | Unsets fly mode |
| explore | m | Reveals the unexplored parts of the map. |
| flyspeed | m | Modifies fly speed. |
| stack | m | Enables aura stacking cheat. |

----------------------------------------------------------------------------------------------------
honor
----------------------------------------------------------------------------------------------------
| getpvprank | m | Gets PVP Rank |
| setpvprank | m | Sets PVP Rank |
| addpoints | m | Adds x amount of honor points/currency |
| addkills | m | Adds x amount of honor kills |
| globaldailyupdate | m | Daily honor field moves |
| singledailyupdate | m | Daily honor field moves for selected player only |
| pvpcredit | m | Sends PVP credit packet, with specified rank and points |

----------------------------------------------------------------------------------------------------
pet
----------------------------------------------------------------------------------------------------
| createpet | m | Creates a pet with <entry>. |
| renamepet | m | Renames a pet to <name>. |
| enablerename | m | Enables pet rename. |
| addspell | m | Teaches pet <spell>. |
| removespell | m | Removes pet spell <spell>. |

----------------------------------------------------------------------------------------------------
recall
----------------------------------------------------------------------------------------------------
| list | q | List recall locations |
| port | q | Port to recalled location |
| add | q | Add recall location |
| del | q | Remove a recall location |

will you create update?

nice

Yes of course -it a hole team involved ,we have rev 1.2.3 now it`s for .Trust me we are Professional

okay i put in everything now where is the accounts and stuff to add ppl.

i couldn't find it so i ended up putting in the clean_db file to add the accounts to add players.

now when i make character's it doesn't show them on the logon screen.

is there something wrong?

emm.. sorry, im so newbie and dont know how to install it? can so1 help me? I just restored this dump into a new DB.

what rev this one compatible to ?

to bad that ps is down again..

can i import account from my antrix 2.1.0 version to this? if yes, then HOW???

hmmm i have a problem may be, the table accounts not exist in this DB

OK, thats how i did...

Create a new DB, and restore .sql file into it.
Then copy all the tables from your old antrix DB into the new one.
After that simply delete tables with "copy" in the name from your new DB.
Edit your .config files to a new DB...
Here you go! Tempest Keep, Black Temple and most of TBC instances are working.

This DB does not use the correct creature proto table. I have already fixed creature proto table for OBDB. I have fixed my copy for rev 4 and would like to send a fixed copy to Lemon. I lost his terrawow site. Can anyone send me the link to it? So next rev is corrected.

pls link me working core to this version for client 2.1.1

yeah when u create ur chars everything u get when u close server gets deleted

Cool stuff :ninja: