Community Adventure Project
Welcome Adventurer, make yerself at home.

Display results as :

Rechercher Advanced Search

Latest topics
» Fix or Improve??
Sat Dec 20, 2014 10:12 pm by Drgnwlkr

» Is there...
Fri Nov 14, 2014 10:39 am by Tavion

» Resetting Journal
Mon Oct 21, 2013 11:38 pm by Subnormal

» Golem Builder By Borojb
Sun Sep 01, 2013 1:32 pm by Tavion

» Hack K & L
Fri Jul 19, 2013 11:43 pm by Tavion

» Help with the haks
Fri May 31, 2013 7:34 pm by Wyrdwolf

» Character Retirement not working
Fri May 03, 2013 3:43 am by MannyJabrielle

Sat Apr 06, 2013 1:58 am by Drgnwlkr

» The Grimm is back!
Sat Mar 09, 2013 1:41 am by borojb

SQL database + persistency of location

Go down

SQL database + persistency of location

Post  Phoenixoverlord on Thu Jun 16, 2011 3:21 pm

I already have another PW running in a MSSQL database and I thought to add yours as well in there. So I got that nifty little FireFox tool to look at and convert the SQLLite db file, but I noticed that many of your tables have a type of "blob", whereas others are the more recognisable "text" format. Can this be replaced by another type? Because creating the tables doesn't really work all that well. Smile

Nothing critical, I was just wondering.

Second, I run version 12 and after a reset the PC's location is not saved. I used the runestone and while I get the message that the location is stored, after talking to the NPC at the starting area nothing happens when I choose the option to go back to a saved location. Sorry if I missed a post in the forum about that.

CAP Rook
CAP Rook

Posts : 13
Join date : 2011-06-10
Location : A BE in MI

View user profile

Back to top Go down

Re: SQL database + persistency of location

Post  lord_of_worms on Thu Jun 16, 2011 3:43 pm

I would hold off on the actual v12 module as I will be uploading the most current build the same time mine goes live. this will fix many bugs as well as the persistant location.

as for the txt format..
blob is used by sqLITE for storing objects. using TXT always was 50/50 for me...
MySQL doesnt have this issue so yes, you can change the format from blob to text.

I will post here for you when its live and you can download the newest version.
CAP Knight
CAP Knight

Posts : 321
Join date : 2010-01-12
Age : 45
Location : Massachussetts

View user profile

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum