HELP lol npc's doing strange things

[jackthripper]

then the only thing i can think of is i missed putting something in my database. im using heidisql never done this b4 but how do ya delete world, logon and characters database so i can try a re-instal?

[Algorithm]

then the only thing i can think of is i missed putting something in my database. im using heidisql never done this b4 but how do ya delete world, logon and characters database so i can try a re-instal?

if you want i can do this for you i have until 4 pm EST at my computer.,

get teamviewer and i will help you

[jackthripper]

never used it b4 but im downloading right now

[Algorithm]

never used it b4 but im downloading right now

when you download it , install it then run it, it will give you an ID and Password , msg me the id and pas.. it lasts only for few minutes its very secure, basically it will give us 2 screens and u will see what i am doing and anytime u want me to stop u jsut take control over my window with your mouse.. its very simple to use

[Algorithm]

[resolved the problem]

[jackthripper]

thnx master1979 definite +rep for that

[Aznex]

[resolved the problem]

It's always helpful for others to post what you did to solve the problem

[jackthripper]

instaled a different database. my heidisql was messed up ( wouldnt query very large query's,,, it would crash) so i switched to navicat.

in effect, when i installed the database with heidi, it didnt import all the info and tables were missing a lot of stuff.

[kreegoth]

As an unrelated issue to his problem but related to the issue itself.. I had a issue that was similar to this one and it was due to the fact that in certain Databases the Tables are created differently. So if you build your base off of say WHydb and partially import some of NCDB you can end up with some things like this. Some of my Npc's in cities were walking away from city and into the rest of the map due to an issue where some of the Npcids were set to double in some of the Waypoint table

[jackthripper]

come to think of it,,, i think that might have been the problem. i had navicat and heidi after we threw in the new database and i noticed on heidi that the tables wernt there in the second world database. but they were there in navicat second world.

[Algorithm]

It's always helpful for others to post what you did to solve the problem

yea what we did was, compare the world structure with db structure in world. I found some missing values, so re-imported the database, but it looked like he was using RIVAL DB, so all the tables were messed up.

Dropped all, gave him my VCN database and thats it.

My Database is super, has no errors, all clean and made for my own server.,