anyone can share me for antrix newest core
Printable View
anyone can share me for antrix newest core
i tried this data base on 291,333 and 354 core.But the problem persistes: all items do not have level requarement,race,class, or eny stamin,intelect,agility etc.
My list for missing tables between Atrix V3 and V4
Accounts
Bids
Auctions
Characters
Charters
Clientaddons
Corpes
finished_quests
gm_ticket
Guild_ranks
Guilds
Instances
IPbans
Mailbox
Playercooldownitems
Playercooldownsecurity
Playerpet_spells
questlog
social
tutorials
the sql dump i got from terranet forum was wrong.
TerraNet DB is officially compatible with Antrix Rev 354.
Tested it and all the problems with items, mounts, etc are gone.
Also in my next releases I will include a backuper with few functions for importing exporting and managing your DB that was made by Brett and me, so it will be easier for you to handle next releases without having problems.
Cheers,
Lemon, TerraNet
So how do you import TerraNet DB rev 3 and then Terranet DB rev 4? I am trying to update but it won't let me since the tables exist. Is there some way to overwrite existing tables? It was Stated that rev 4 is and upgrade.
i miss those tables too. how do i get those tables in my db?
usind terranetdb4
Someone posted an sql fix for the missing tables in this thread on like page 3 or 4. I have it working well, but no mounts, items don't work, and water/food doesn't work. Will try it with the newest core & see what happens.
ehm, im sorry for the newb question^^
does it matter which dbc (like 2.1.0 or 2.1.1) i use for the terranedDB4?
since the revisions dont include dbc files, i download them somewhere else.
id like to try with rev354 or rev364.
edit: oh and id like also to know if Terranet Db rev4 is for 2.1 or 2.1.1?
thanks in advance
I upgraded from v3 by copying the v4 over it and i still have the items problem,no stamina,intelect etc.Rest is working perfectly
I think i forgot the DBC's from 2.1.0 can it be posible because of this?(not haveing stamina,intelect,agility at items)
you can also get this from :
Project Silvermoon
OK I`ll start answering those questions.
ALL OF YOU HAVING PROBLEMS WITH ITEM STATS: THIS IS NOT DB ISSUE, ITS CORE RELATED AND IT WORKS GREAT WITH 354+ CORE REVS
TerraNet DB WORKS GREAT WITH 2.1.1 & 2.1.0 SINCE DB HAS NOTHING TO DO WITH CLIENT VERSIONS
DBC FILES HAVE NOTHING TO DO WITH DB THEY ARE STRICTY CONNECTED TO CORE, AND AS CORE RELATED ITS ALWAYS THE BEST TO HAVE THE NEWEST SINCE ANTRIX SUPPORTS 2.1.1
Jaboxer: JUST LIKE THE MAN SAID, PS Boards ALONG WITH TerraNet Boards ARE HOME OF TerraNer DB, SINCE I AM DEV FOR PS(Lemon :D)
Cheers ppl
Lemon
Sorry for double post but its something completely different.
First: Could a mod change a topic of this to: TerraNet DB Help & Support[Latest Revisions]
Second: is it too much to ask for a sticky?? :S
Third: Could I get my name changed to LemonPS please :D
i will confirm dzanans post.
Terranet DB 4 works perfect with revision 354. great job guys. keep it up.
id like to know which new items were added to the database. where do i get their ids?
where can i download database rev3?
look in page 4 i posted a link,do some searching before posting
The replace of dbc's with the latest ones solved my item stats problem,thanks.
well it was a core issue, not a DBC one as far as I know, but DBC might help, which I don`t really know :D
im using this db with antrix core290 and 354 but i can only put one buff at time on me.... cause they are always replacing themselves.. what am i doing wrong?
Ok. Soon as I think i'm getting somewhere i found out about another rev. then this issue and that. So, I've got a few questions that's probably noobish to most of you, hope someone can throw me bone here.
:poster_do
My setup:
MySQL Server 5.0
SQLyog 6.02
Antrix Rev290
TerraNet DB rev4
WoW Patched up 2.1.1 (6739)
Ok. So here's what's on my mind:
1) When these DB Revs come out do I just repop a new DB and run that? I mean are they collective or do I have to do the repop copy BD to different host deal? If I have to do the later, do i start from Rev2 then work my way up to rev4?
2) I've manged to get my game running but quests, weapon trainers etc.. are still buggy. Also, I can't get into outlands. Says I have to have the expansion installed?
I haven't tried to get my friends on here yet, but I'm looking forward to it! Any real help on the matter would be appreciated greatly. Anything from the ground up works. Thanks in advance to all. :biggrinth
1) You need to join rev 3 and rev4. rev3 and older revs where ready to use. rev4 is just an update for rev3, so you don't need rev2 anyway.Quote:
Originally Posted by Odyne
For this i mean.
Install rev3, install rev3 fixes.
Install rev4 on different database, copy the new one overwriting the old one (only hte existing tables).
Now install rev4 fixes.
2) I've noticed some quests aren't working, but that's the same in all private servers. Anyway most of them are working (i've tried about 20-25 quests, 15 worked fine).
About outlands. You must set your account to flag 8. Flag 0 is normal wow, flag 8 is burning crusade.
To do so, open SQLyog, go to accounts table, click on "3 Table Data" look the column "flag" and put the value 8 manually.
Then save the changes and close SQLyog.
Hope it helps
can anyone post a link to rev 3 and fixes.. im totally new to this i just used the ready to go db from atila thread but it doesnt seem to work well.. PLZ i beg you can someone explain how to install a fix if i put the database in sqlyog. plz plz plz :scratch:
TerraNet WoW Forums -> TerraNet DB releasesQuote:
Originally Posted by abraxxas
Check rev3, install it and then apply the fix (the query), then rev4 as i've explained before.
Hope it helps.
i only find a a download link for rev 3 there no fixes.. Anyways.. so i have to download rev 3 then start SQlyog and i use restore from sql dump and import rev 3?? right?? and what do i do then??
edit: ah i found the fiy its the one right under the download link... but how do i apply it?... sry for my noobyness ;(
the fix is in the same page of the download, but it's not a download... it's a query...
here it is:
Copy this query in your SQLyog up-right empty window (wich is also named query)Code:UPDATE creature_proto SET attacktime = attacktime + 1500 WHERE attacktime < 5;
then right-click on the 1, just beside the pasted query, and select execute query->execute query selected.
Rev3 is now fixed.
thx m8 i managed to do this :technolog: but how do i add the db rev 4 now??.. do i have to query the whole db?
create a new db (like you created the first one) with different name and restore it as you restored the first one. (yep it could be a long operation... again xD)
Then, refresh, right-click on rev4 database, "copy to different host/database".
In the new window, at the lest click on SELECT ALL, at righ in the list select your rev3 database, and check "DROP IF ALREADY EXIST".
Click on COPY, then wait until the end :)
i see this gonna tike sum time :winky: .. but thx m8
edit: btw. im using antrix revison 354 with this db so do i have to apply the fix for rev4 or isit only for revision 290?? and can i also use revision 374 and if yes what is the difference? Anyways thx for ya help.. nice tutorial and cool db.. thx to all guys ;P
:biggrinth :biggrinth :biggrinth :biggrinth :biggrinth
ATTILA888
:biggrinth :biggrinth :biggrinth :biggrinth
THUMBS UP TO YOU! Those instructions you gave me was right on the ball! Just got my server up 2mins ago and I can already tell it's a 101% better now. Thanks a million :jump1: !
LOL xD
It's always a pleasure to help xD
what do i do with the missing char tables do i need em?? doo i add em the same way i add rev4 to rev 3??? and do i need the rev 4 fix? im suing antrix revison 354
there are no missing tables if you added rev4 to rev3, because rev3 already had those tables missing in rev4.
The only thing you have to do now is to run rev4 fix queries, then you can play :)
but it says: Execute this if you want it to be compatible with rev 290. and i use rev 354.... ya sure i need em? dont wanna do smt wrong cause then ill have to do it all again:smurf:
If i'm correct, all version OVER 290 need this fix.
Just DON'T apply this fix, run your server... if antrix crashes... APPLY this fix... easy :D
hey btw.. is there any diference between your v4 ready to go database adn the erde rev4 and rev3 database? or are they the same?
edit: can i also use the rev 3 fix after i merged the 2 dbs? cause if i forgot it before
There is no difference between my ready to use, and the rev3-rev4 merged, mine is only smaller and faster.
anyway if i have good memory, the rev3 fix was just an update, so you should be able to use it after merging :)
so yours is better.. than the one i have now... or am i wrong?
well... structure and data are exactly the same, my sql dump is just a bit optimized for being restored faster and doesn't need fixex (becasue i've already done them)... but once you restore it, the result is the SAME
anyways.... this might be the wrong thread but were can i find the model ids of items??? cause i would like to create sum of the missing items.... :2gunsfiring_v1:
Only tried making custom items changing displays etc.. etc.. but I think the same IDs should work for adding new items to the dbase. You can find the items/ids from thottbot.com or that alakazham site. If you click on the item the last digits in the web address after the "/" is the item ID number.
yeah i know but i think that the model id is different from the item id.. or am i wrong??
you're right :)
in thotboth there is an section (Thottbot World of Warcraft:)
don't know about allakhazam :)
Can some one please tell me how do i add portals please.
This maybe a n00bish question, but how do I apply the fix that is mentioned in the first post? I'm using NaviCat and the latest Antrix rev...
open navicat, open connection with your db, click it so it becomes green, then click query (big icon)
the in the new query bar select new query, copy-paste ther and click run
Many thanks! I'll try that :)
Oh! It worked! Many thanks ATTILA888
EDIT: But must I update from rev 3 to rev 4, or can I just apply rev 4 and then apply the fixes?
Db terranet rev 4 is bad..no tables clientaddons,etccc etcc no exist this tables
i m probe antrix 364 and 290 and more
must update from rev3 to rev4... i've also made a guide (it's sticked...)Quote:
Originally Posted by Selvin
hope it helps :)
Yeah! It helped very much! Thanks :)
I got my server working perfectly in core 354 but i have this little problem , players can't explore eny map.
I have to say that this is a pretty good DB, but there are still alot of items missing... :wounded1:
I have added armory, thotbot, allakhazam and wowhead combined parsed items :D in rev5
Well i saw REV 400 core for Antrix.Quote:
Originally Posted by soneta
And i can share it if nobody done yet
When is going to be released that rev5 ? or if is allready please give a link will/is it(be) a full database ??Quote:
Originally Posted by dzanan
Release is today.
Gotta try it :D
I just forgot to ask you if you like my guide to update rev3 to rev4 :)Quote:
Originally Posted by dzanan
I did it because you didn't allowed my to release a ready to use database xD
(Anyway, rev5 would be a database or just an update?)
How long does the DB to uplaod take?
a 200mb db takes 1 hr to install ,so make coffee LOL
1 hour?
never more than 30 minutes to me...
it will take 2 min to upload with the tool I will include in the package.
But this new update, it's from the TerraNet team?
Edit: That was a very dumb question :P
Very niceee ...i can't wait to try that one :DQuote:
Originally Posted by dzanan
Ps: Thx for you pm ATTILA888
It is taking me nearly 4 hours -_-, and I have an Intel Dual Core 3,2 Gighertz 1024 Megaram.
2 min??? its an update??Quote:
Originally Posted by dzanan
PLEASE help me,i have 2 problems:
1 players can't explore i have core rev 397
2 the spirit spawn after diing is incorect,always when u die takes u to a graveyard near western plague lands.
I hear that REV 5 is the best please hurry i really need rev 5
cheers for the TerraNet DB. i just followed the guide shown by Atilla and it is working perfectly. thanks for the serpentshrine items. now i can roam around the world on Peep the Phoenix. keep up the good work. oh i've been reading that people are having issues with upload times for their databases. from following Atilla's guide on how to update between Rev3 and Rev4 i think the time it took was 46mins for each Rev upload. and 20 mins to merge them. i'm running a Pentium 3.0 830 dual core with 2gb of ram. something must be really wrong if people are taking more than 2 hours to get their databases up and running.
again thanks. can't wait to see Rev5.
its not in the terranetdb5 pack included no?Quote:
Originally Posted by dzanan
coz ive downloaded it from terranet forums but didnt see any upload tool in.
than you didn`t look at the right place.There is a thing called PS Backuper chk there a bit
Where can i actually download the new rev?
You must register before you can view it.
TerraNet DB rev5
Get maps... duhQuote:
Originally Posted by cipa_shmen
i update first topic with the new db provided by Lemon
Hmmm, May i ask which DB Is cleaner and Bigger? OBDB 1.3 Or TaRRaDB?
I never heard about those 2 DB`sQuote:
Originally Posted by darkid11
Demon trainer is not working ..or have i done something wrong ?
I Think you understood very well for what i am meaning, isn't it?Quote:
Originally Posted by OSP
SQL TerraNet DB and SQL OBDB 1.3
How come I cant use any of the mounts?
i got a problem with it when i try and run my antrix.exe with theese dbc files it comes up with error and has to close when it loads map 530... heres screeny:
http://img517.imageshack.us/img517/6752/errorvp2.png
i think its trying to load to many npcs/spawns on map 530??
Usualy that problem indicates an corupted database ... also try to see if it works with other revisions Index of /antrix
so umm just check every one of those see if any work :D?
Cool ty it worked :D
:S I update the db from v4 to v5, and I see that for example, learn ridings costs 10c, If I'm mage only can put on me 1 buff, draenei's can't summon a riding etc etc any have the same problem?
Only I put the v5 over v4...
thxs 4 all
I am very sorry to say that none of that is a DB problem.Riding prices maybe but I have to chk it out.
Have rev.5 all mounts including Netherdrakes becouse when i summon the Netherdrake i can't see mount help pls)
http://img409.imageshack.us/img409/197/helppb1.jpg
Any help guys? using terranet db rev 5 and antrix 375 and client 2.0.12 tbc.
I would advise you to update your client to 2.1.1 and extract again the dbc files ..that should do the trick ;) I use the same rev like you and it works excelent soo it can't be that
Thx for the help man. I'm downloading 2.1.0 patch now. ^^Quote:
Originally Posted by poemihai
Hey, there was an update early this morning and it won't let me connect to my server because the versions are different or something, how do I fix this?
MinClientBuild = 6546
MaxClientBuild = 6546
Maybe change this accordingly? ^^'
i've found that antrix can be temperamental when loading the database. i'd advise downgrading to a known working version like Rev354, thats what fixed it for me. i think i'm using Rev290 since i can't find the Rev354.
Try seting like this (soo i have ..tho' i'm not using that last patch) :Quote:
Originally Posted by tweeaaked
MinClientBuild = 6000
MaxClientBuild = 7000
If this does not work you need to downgrade your game to 2.1.0
you shouldn't do that because lots client errors you will have.
Hello people, sorry about my english but i am going to do my best.
I am using Antrix rev 354 with TerraNet DB rev 5 without any problem, but i can not use .recall port epl (easter plage land) it does not work.
I have installed WOW 2.1.1 client, i extracted the maps and dbs
The antrix console does not show any error or query fail.
could it be some area trigger problem??
Thanks suffer reading this
PD: I also tried with DB Repack V2 and It works
I have a problem with terranet, only when I use other rev of Antrix that for example 364, or god's revision 402, when I go to the game for play stay a message that say connecting but nothing can else. And when I use the stable rev 290 works perfectly, any have the same problem, or the problem is from the Antrix Core?
I been testing some more and found that when i summon my nether ray this does not show at all, is like I am floating, the nether drako works fine.
should I use the dbc 2.1.2 ??
Thanks
When i add portals and other gameobjects they doesnt appear when im restarting the server, but my npc's are working after restart is it a problem with the DB or antrix rev? using 354
One more thing, when i delete gameobject then i works even if i restart the server, really strange...
I have dbc 2.1.2 but i dont have the newest maps, are 2.1.2 maps same as 2.1.0 maps or not?
Witch DB is better can anyone tell me? Dose this db have any parts of OBDB 1.3 - The Antrix Database !
witch db is better OBDB 1.3 or TerraNet DB rev 5
Arberflow try both out and see for yourself.That question has been asked for thousad times, and almost all game the same answer but that doesn`t mean you have to use it.Try it and see for yourself which one fits your needs.
...