Page 1 of 1

Database values issue

Posted: Sat Jan 05, 2013 12:48 pm
by bladegary
Hey,
I discovered the project a few days ago so first of all I'd like to say thank you for all the work you've done so far ! :)

I followed the wiki to build the server and configure the client and everything works fine except for one thing : it seems that the hex values from the .sql files don't insert as they should in the database. So, when I log into the game, I can't see my character, the npcs, the monsters,... since the tables don't have the correct value :

Image

So, is this an encoding issue ?

Here are the database properties, maybe I have to change something there ?

Character set : utf8 -- UTF-8 Unicode

Collation : utf8_general_ci

Re: Database values issue

Posted: Sat Jan 05, 2013 1:16 pm
by whasf
Try HeidiSQL , I think the version of NaviCat you're using doesn't show blobs correctly.

Re: Database values issue

Posted: Sat Jan 05, 2013 2:09 pm
by bladegary
Thanks !
I can indeed see the correct values with HeidiSQL, so I guess my issue is something else since PC and NPC are still invisible when i launch the game =/

Re: Database values issue

Posted: Sat Jan 05, 2013 5:55 pm
by PrBlahBlahtson
I'd check the setup and bug forums a little more thoroughly. This has been encountered before. If it's selectively invisible, you're missing an expansion. If it's "everything's invisible," I forget what the solution was.

Re: Database values issue

Posted: Sat Jan 05, 2013 6:18 pm
by bladegary
I found the thread in the bug forum, missed it the first time I looked, sorry about that.

So it was because the game used the intel graphic card instead of the nvidia one, I just had to change that in the nvidia control panel and now everything works fine. Thx !