[GUIDE] How to Update TerraNet DB rev3 to rev4 - GUIDE FOR DUMMIES (LOT OF IMAGES)

Ok, i saw more than 100 posts of confused people in the TerraNet DBrev4 release post.
The thing isn't so difficult, but who have no experience may have some troubles.

You will need those files:
TerraNet DB rev3
TerraNet DB rev4

You will also need Navicat or SQLyog or any other MySQL database manager, i'll use SQLyog for this guide.

Well, let's rock! :music_band:

a) Open your SQLyog, connect to your MySQL Server.
b) Right-click on "root@localhost" and select "Create Database..." - (click to see the image)
c) Name your database (in this guide "terranet3") and click "Create" - (click to see the image)
d) Right-click on "terranet3" and select "Restore From SQL Dump..." - (click to see the image)
e) Select you TerraNet DB rev3 and click "Execute" - (click to see the image)
f) Right-click on "root@localhost" and select "Create Database..." - (click to see the image)
g) Name your databse (in this guide "terranet4") and click "Create" - (click to see the image)
h) Right-click on "terranet4" and select "Restore From SQL Dump..."
i) Select you TerraNet DB rev4 and click "Execute" - (click to see the image)
j) Copy this query on your "Query" tab:

Code:

---

UPDATE creature_proto SET attacktime = attacktime + 1500 WHERE attacktime < 5;

---

k) Select the query, right-click on it, then "Execute Query" and "Execute Selected Query" - (click to see the image)
l) Right-click "terranet4" and select "Copy Database To Different HOST/DB..." - (click to see the image)
m) Click "Select All", choose "terranet3", check "Drop Table If Exists In Target", then click "Copy" - (click to see the image)
n) Just click "OK" - (click to see the image)
o) Right-click "terranet4" and select "Drop Database..." - (click to see the image)
p) Click "Yes" to confirm - (click to see the image)
q) Delete the old query and copy these others:

Code:

---

UPDATE totemspells SET spellToCast1= 8349 WHERE spellId=1535;
UPDATE totemspells SET spellToCast1= 8502 WHERE spellId=8498;
UPDATE totemspells SET spellToCast1= 8503 WHERE spellId=8499;
UPDATE totemspells SET spellToCast1= 11306 WHERE spellId=11314;
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=11315;
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=27623;

UPDATE totemspells SET spellToCast1= 8187 WHERE spellId=8190;
UPDATE totemspells SET spellToCast1= 10579 WHERE spellId=10585;
UPDATE totemspells SET spellToCast1= 10580 WHERE spellId=10586;
UPDATE totemspells SET spellToCast1= 10581 WHERE spellId=10587;


DROP TABLE IF EXISTS `reputation_creature_onkill`;
CREATE TABLE `reputation_creature_onkill` (
  `creature_id` int(30) NOT NULL,
  `faction_change_alliance` int(30) NOT NULL,
  `change_deltamin_alliance` int(30) NOT NULL,
  `change_deltamax_alliance` int(30) NOT NULL,
  `faction_change_horde` int(30) NOT NULL,
  `change_deltamin_horde` int(30) NOT NULL,
  `change_deltamax_horde` int(30) NOT NULL,
  KEY `index` (`creature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


DROP TABLE IF EXISTS `reputation_faction_onkill`;
CREATE TABLE `reputation_faction_onkill` (
  `faction_id` int(30) NOT NULL,
  `change_factionid_alliance` int(30) NOT NULL,
  `change_deltamin_alliance` int(30) NOT NULL,
  `change_deltamax_alliance` int(30) NOT NULL,
  `change_factionid_horde` int(30) NOT NULL,
  `change_deltamin_horde` int(30) NOT NULL,
  `change_deltamax_horde` int(30) NOT NULL,
  KEY `factindex` (`faction_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `npc_monstersay`;
CREATE TABLE `npc_monstersay` (
  `entry` int(11) NOT NULL,
  `event` int(11) NOT NULL,
  `chance` float NOT NULL,
  `language` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `monstername` longtext,
  `text0` longtext,
  `text1` longtext,
  `text2` longtext,
  `text3` longtext,
  `text4` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

NOTE: Every time you see ";" (without quotes), that's the END of a single query. I suggest to execute the queries one by one, in some programs that's usefull to see if one is bugged, because if you run all the queries at once, you just got a general error message.

r) Executes the queries one by one.
I've made only some images, to show what are the single queries, (someone may not be english, like me, and not understand the red note)
Image 1
Image 2
Image 3
Image 4

YOU ARE DONE

Hope it could help someone

All credits for the databases and queries/fixes goes to:

Onemore - quest fixes
Resinate - range fixex, size fixes, a lot of others
ollee - for submitting bunch of fixes
Frango - for mount fixes
Project Silvermoon - for support and fixes
Antrix Project - For spending a good time there
TerraNet WoW Comunity - for everything you see here

i don't need but very very nice

OMG!! were did your other post go ATTILA888 ? I was trying to follow your other post with images, trying to setup my first server
I was trying to install the MySQL part on my Windows box, and during the installation, I get the following error:

Error 1335: The cabinet file 'product.cab' required for this installation is corrupt and cannot be used...

I tried several mirrors, same problem. I tried the Essentials and the second package with the same problem. I tried the third option (no installer), and though I now have the bits laid down, I have no idea how to install/configure.
And now i dont have your nice screenies how to setup a server. Any of you guys who knows how to fix my problem iam getting with the MySQL install..?
and how do i get back to the the nice screenies expaning how to set it up..? if i get my Sql error fixed.:scratch:

Germo

Sounds like a problem with your machine if the mysql is corrupt. Possibly another program interfering. I would try maybe downloading and installing from safe mode with networking support...see what happens there.

Can anyone explain to me how to fix mob spawns? After creating a new orc and going to the burning blade coven in the valley of trials, I saw that all the mobs inside seems to be spawned twice, including the bosses inside.

Thx alot of help to me ATTILA888

Damn iam still fighting this damn error from installing MySQl Essentials i have now tried savemode, (with networking and without) i even tried this on 2 other comps, and STILL iam getting this damn Error 1335: The cabinet file 'product.cab' required for this installation is corrupt and cannot be used...

I found the same version from diffrent mirrors, stil the same OMG!! Very lost here. I did find ATTILA888 nice screenies ow to install it all, it was just me looking the wrong place sorry about that. But this damn error is killing me /CRY:scratch:

Germo

Atilla 4 tha win ;P

Quote:

---

Originally Posted by Germo

Damn iam still fighting this damn error from installing MySQl Essentials i have now tried savemode, (with networking and without) i even tried this on 2 other comps, and STILL iam getting this damn Error 1335: The cabinet file 'product.cab' required for this installation is corrupt and cannot be used...

I found the same version from diffrent mirrors, stil the same OMG!! Very lost here. I did find ATTILA888 nice screenies ow to install it all, it was just me looking the wrong place sorry about that. But this damn error is killing me /CRY:scratch:

Germo

---

i'm gonna send you a pm, get ready :D

germo?

try here
Filebeam - Free Fast File Hosting

to be honest... a guy from PS Forums uploaded the blank account tables... you could just import them lol... thats what i did.... but then u dont retain original account i didnt rly care lol, i prefer clean installs since my public server is a separate server...

stammo

That all makes sense, but once I update TerraNet DB rev 3 to rev4, how does that then affect the antrix database? do i need to restore the antrix file with the updated rev4, or am i just suppose to target my .con files to the terranet3 DB?

just target your conf files to terranet3 :)

Okay, that's what I tried first, but when I went to open the antrix application, it crashed when it started to load the quests, which made me curious. I guess i have a different problem then

I guess so... did you tried my complete guide on running antrix server? Just check if you forgot anything.

I've read both of your guides numerous times, and I thought I did everything correctly, but I'm currently starting from scratch... so we'll see

hey ati, i do it all on this guide, but i can't connect to game. client always say : choose a server ? my failure ?

that could be a bad setting (conf files).
What do you mean exactly with choose server? do u get empty realm list?

sry, i see at last time .. i do false at the realm.conf file for realm declar. :P now fixed. very sry for busy :=)

I'm not 100% sure if this would be the place to post this, but I have yet been able to get a paladdin or warrior to be able to wear plate, or a shaman to wear mail... any idea how to fix this?

Some trainers (and some only) must teach you those skills.
You won't just get it leveling or learning normal skills/spells.

Usually only lvl 60 trainers can teach those skills.
Check it out and let me know :)

I just checked ever paladin trainer in stormwind and ironforge, and none of them can teach my paladin to wear plate... can one of the GM commands help with that?

Sure :)

.learnskill 293 1 1

thanks a ton! I've spend days upon days trying to fix that one problem... thinking it was the db and core and whatnot... kinda makes me mad to know it would have been as simple as that

Actually this is a database issue.
You could add this skill to your trainers (that could be difficult if you don't know where your putting your hands on), and Mail also...

(For mail skill, .learnskill 413 1 1)