-=/PryDevServer-4TC:\=- Trinity Core!

[pryd]

I Have found missing Sql Files

2010-04-21 15:05:42 The table `addons` is empty
2010-04-21 15:07:53 SQL: SELECT entry,race,class FROM character_npcbot WHERE owner='1'
2010-04-21 15:07:53 query ERROR: Table 'characters.character_npcbot' doesn't exist

Im Using newest YTDB_7947_Fun + Ultra Core Release_7947

Did i need some separete files or is that problem not realy important?
Minion-Bots Works fine, but Player bots does Nothing...


Help Please

Player Bots now Fixit, if any have same Trouble here the FIX

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

CREATE TABLE IF NOT EXISTS `character_npcbot` (
`owner` int(11) default NULL,
`entry` int(11) default NULL,
`race` tinyint(4) default NULL,
`class` tinyint(4) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

need the table "addons"

Thanks for the catch. I have now included a blank custom character database (run it with navicat) that has the required bots tables within.
Also, if you happen to get any script errors, make sure to check the Icc_script_attach in sql update folder included w/ cores / world databases.

The reason you might get an errror?
If by chance you use a world database that I haven't actually updated in a while such as ytdb pure, well you might have some work cut out for ya.
JK, run the icc script attach and extras and you'll be just fine.

Howdy.

Im sure this question has been posed before, but I the search function is hardly reasonable for searching for something like that, I've tried.

Basically my issue is, Im running an older revision, not Prydevserver. Actually some repack by someone named eternity or something like that. Anyways, the server is TrinityCore2 rev: 4194, and supports client 3.1.3. Ive heard so many good things about your repacks that I really wish to upgrade to the latest version and use your server instead. However, I am running a server with quite a few people playing on it, and I was wondering if there was a way to retain the Character information that I currently have. I would hate to rebuild all the characters from the ground up, but the revision I have running at the moment is really quite horrid. Damage is all sorts of messed up and many other bugs and quests broken make the experience less than enjoyable. Upgrading would be the best option for me right now, and if I HAVE to wipe the database clean, I would, but if there was some way to save the characters and accounts, that would make my life much easy. If you have some sort of solution, I would love to hear it. Thank you in advance, to whomever has some advice.

Ok so here's what you do to upgrade from an old Trinity Core character database to the current Ultra Core:

1) backup / export the character database
2) Make a new database called character_beta & make world_beta
3) Make realmd_beta just realize it'll be used for testing purposes.

Import the respective databases: your old characters, my new world and new realmd from Prydevserver repo at sourceforge.net

The tough part: Update all your character sqls from your current core version: 4194 to my current version 7947 inside the repack.

Make sure to use the tools to extract your new dbcs, maps, vmaps.

Lastly config the new beta core /folder paths and /data files mentioned above. And test out the new core / content.

Once you are satisfied, you can update your realmd sql from 4194 to the latest. The reason to do the beta test is to ensure that it will work.
In theory and with practice it does.

Hope this helps

[Furinex]

Thank you Very much for your quick response, I had no idea you'd be this quick considering my time zone difference. Being out in the Indian ocean on a Naval Ship has its draw backs :P Anyways, To clarify, before I start this... (Just so Im not screwing anything)...

What im going to do is Use Navicat to create database backups of all 3, Realmd, World and Characters for my current server.

Then Import all of your database files MINUS the character one you supplied and just import my OWN character database into newly created beta databases. (Which World Database sql should I use? Database\Blizz\tdb_blizz? or one of the World_base/29/plus_29 ones?)

Now the part im a little confused on, I need to update my character database sql from my current core version to your core version. That would be located inside the database folder of your repack. Which sqls would I use, and should I Source them in within a CMD prompt under mysql? Guessing, I would probably use the ones in Databse\Blizz\Updates\3.1.3_old\ starting with 4209_characters_TDB.sql (Since there are no character sqls for my exact version, that is the next one I see in there) and then source all the ones in subsequently after that(Any SQL that has "Characters" in the name, im assuming), ending in 6509_characters_character_skills.sql? Then move to Databse\Blizz\Updates\3.2.2a_old and do the same thing? then on to 3.3.2_old and do the same thing there... then to the main updates folder and do the same thing there?

The vmaps, dbcs and maps im not worried about, im fairly familiar with that. Same with the folder paths and data files path.

Then run the Core, see if my characters are still intact. Then Source the Realmd updates (as I described above) to the latest version.

Again, I really appreciate your assistance in this matter, as do all the Navy WoW players on my ship :P Thanks in advance.

[lucas13]

Pryd please upload a new (hopefully full) repack because i cant seem to find a mysql in your win32 and not in any of the dbs either or lorac's maps.

[vaniva]

please fixed core 9747
The Quest almost all bug , (it have scripted but cannot accpet of all)
Example the first quest of Orc , Troll , etc

[giorqa]

Pry pliz: no working walok pet.. bug fallow no :confused:

[giorqa]

sory working walok pet.

no workin beginer quvest rase paladin, ......

[vaniva]

sory working walok pet.

no workin beginer quvest rase paladin, ......

If you using 7947 it not only paladin
but every class BUG with accept beginner quest
like I said Quest scripted but cannot accept.

please fix it , thx.

[lorac]

If you using 7947 it not only paladin
but every class BUG with accept beginner quest
like I said Quest scripted but cannot accept.

please fix it , thx.

I am looking into this
However on the SAME core SAME db I have not ran into this problem

Which leads me to believe there is a SQL export issue
Or you did not follow the directions
You MUST use the new db
you must use all the updates supplied by pryd

9700+????
We are at 8021 on the development side

I will not support any core but Trinity ultracore
The Quest bug is not in this core
If you choose to use an other persons core then i am not liable for the outcome
As i TRIED to reply to your pm V but your box is full
you need to use the sqls ONLY supplied by us
And Core Only supplied by us
I cant be dealing with bugs that other repacks Or Trinity core it self has!!!
I spend alot of time going behind the main project and fixing errors like mangos mergers

AGAIN Make sure all the updates are applied and you are using Our Core ONLY!!!!
Thank you
Lorac < Head Core Designer >

[spitfire21]

also with the warlock try logging in and logging out when that happens it sometimes fixes the problem.

[vaniva]

lorac , i try it from 20.04 release beginner quest bug , but latest now not get bug

and when I warp to LK raid i got problem like this http://img651.imageshack.us/img651/3...510042452d.jpg cannot move at that point
How do i fix
thanks

[pryd]

please fixed core 9747
The Quest almost all bug , (it have scripted but cannot accpet of all)
Example the first quest of Orc , Troll , etc

We don't support YTDB : /

This isn't a core issue, it's a database issue. Confirmed bug on YTDB.

Bug does not exist in TDB. Ultra Core Team officially supports TDB until other databases work out the issues if they are supporting Trinty Core.

Remember if you find bugs / report them to the respective dev teams.
Such as TDB / YTDB / CTDB.

I will see if I can't figure out why YTDB is acting in this fashion.

Found your YTDB's issue... Vaniva do yourself a favor, import TDB for comparison and compare the quest_template for orc start quest.

Come back and tell me what you find.
Please do more research before you assume.

And if you find more bugs on YTDB report them to YTDB, but I doubt anyone will support it...
it's the name of the game, that's why I suggest using TDB it is the premier database and the standard to which all should be based off of for this repack.

Lastly, the quests that do not work properly on YTDB for Ultra Core might be a long list.. I can't be sure at this time, I found at least 30+ problem quests.. there could be more. What we will need if we are to fix them is a comprehensive list.

And a sql update to go along w/ that ( data compared to TDB ) test and know for sure that it works.. like.

UPDATE `quest_template` SET `questflags` = 0 WHERE `entry`=4641;

Tested by me and fixed. As far as the teleport issue to lich king, possibly change the end location, make the z higher? and you will not fall through the world? Let me know how that works out too.

You could also turn off the portal for now to reach the lich king since he's not scripted yet.

Thank you Very much for your quick response, I had no idea you'd be this quick considering my time zone difference. Being out in the Indian ocean on a Naval Ship has its draw backs :P Anyways, To clarify, before I start this... (Just so Im not screwing anything)...

What im going to do is Use Navicat to create database backups of all 3, Realmd, World and Characters for my current server.

Then Import all of your database files MINUS the character one you supplied and just import my OWN character database into newly created beta databases. (Which World Database sql should I use? Database\Blizz\tdb_blizz? or one of the World_base/29/plus_29 ones?)

Now the part im a little confused on, I need to update my character database sql from my current core version to your core version. That would be located inside the database folder of your repack. Which sqls would I use, and should I Source them in within a CMD prompt under mysql? Guessing, I would probably use the ones in Databse\Blizz\Updates\3.1.3_old\ starting with 4209_characters_TDB.sql (Since there are no character sqls for my exact version, that is the next one I see in there) and then source all the ones in subsequently after that(Any SQL that has "Characters" in the name, im assuming), ending in 6509_characters_character_skills.sql? Then move to Databse\Blizz\Updates\3.2.2a_old and do the same thing? then on to 3.3.2_old and do the same thing there... then to the main updates folder and do the same thing there?

The vmaps, dbcs and maps im not worried about, im fairly familiar with that. Same with the folder paths and data files path.

Then run the Core, see if my characters are still intact. Then Source the Realmd updates (as I described above) to the latest version.

Again, I really appreciate your assistance in this matter, as do all the Navy WoW players on my ship :P Thanks in advance.

This is exactly the right steps, yes you will need the char sql updates from the older folders.
There may not be an exact match to your current char database, but go for the core revs that are higher.

Let me know how it works out, normally if you miss a sql and get to the point w/ the new server config, the server will scream at you hinting at the missing sql.
I'll do my best to help in that area: As always and if you need, use the newer character database as a reference when all is said and done.

[lorac]

lorac , i try it from 20.04 release beginner quest bug , but latest now not get bug

and when I warp to LK raid i got problem like this http://img651.imageshack.us/img651/3...510042452d.jpg cannot move at that point
How do i fix
thanks

I have no clue
Considering we havent even began to touch that part of the raid
Actually we havent started really working on ICC Raid at all
Simple solution
Dont go there
Considering the Tele didnt exsist
nor did the transporters have the location avail
this should have been a clue that that area has not been worked on
Untill we say the core supports frozen throne do not go there
The scripts are not even in the core
The scripts dont even exist
If this becomes much more of an issue i will turn off the scripts for icc untill it is supported to protect ppl and to cut down on the same ol responces

::::Notice to everyone::::
ICC RAID is only scripted to the first area
anything past that
I will not answer questions about or offer support
it is not fair to those who are waiting for fixes or other things to be added
for us to continusly have to stop and handle an invalid issue that we knew about and you knew about

This again is my last time covering this
The next time the same issue comes up
ICC raid will be closed and all icc scripts will be turned off
Thank you for your understanding
Lorac

[giorqa]

YTDB Base problem quvest , no working all clas

[giorqa]

WoWScrnShot_042510_114055.jpg:
Upload of file failed.

[lorac]

YTDB Base problem quvest

4 words
Please read previous posts