|
Author |
Topic: WCS install (Read 65 times)
|
InfinityRogue
Level 0 Beginner
 Offline
 United States
Posts: 5
|
 |
« on: December 14, 2009, 08:25:58 AM » |
|
Hi,
I just installed the 0.75 version, because I wanted to use MySQL. I've enabled it in the es_WCS_config_db.txt, and I've set up all the information in the es_WCSsql.txt.
I've also added a database, but I have not created a table in this database. I assumed that it would do that itself. But, it's not doing that. What am I doing wrong? Is there some guide to how to set up the tables?
I have other servers that use MySQL access, so I know my information is correct. I just need help with the tables.
|
|
|
|
|
Logged
|
|
|
|
|
CA.Berettonawak
|
|
« Reply #1 on: December 14, 2009, 09:26:21 AM » |
|
WCS 0.75 is not SQL compatible (anymore). WCS 0.77 isn't either. None is !  |
|
|
|
|
Logged
|
Beret, keep yourself focusing on 1 project. Be sure to memorize that down since it sounds good. i love tuna juice  =CA= Pietro: back
=CA= Pietro: sorry, was downstair sharing my chocolate with my cat
=CA= Pietro: you should see his face when he ate it xD =CA= Berettonawak: just because you don't have hope doesn't mean we're doomed |
|
|
InfinityRogue
Level 0 Beginner
Offline
United States
Posts: 5
|
|
« Reply #2 on: December 14, 2009, 07:48:33 PM » |
|
So, how does the game save the xp? I did a test, where I joined, played for a bit, then left the server. When I re-joined, the xp was still there, but when I left, restarted the server, then re-joined, then it was gone. So, a restart of the server resets it somehow. I thought there was some text file saved somewhere, cause I have that enabled as well.
|
|
|
|
|
Logged
|
|
|
|
|
Sasuke[Icetouch]
|
|
« Reply #3 on: December 14, 2009, 08:27:05 PM » |
|
It uses SQlite to save it in a .db file, found in your eventscripts/wcs/WCSusers folder.
|
|
|
|
|
Logged
|
################################ Join our new Server with the newest Mod on it! ################################ |
|
|
InfinityRogue
Level 0 Beginner
Offline
United States
Posts: 5
|
|
« Reply #4 on: December 15, 2009, 01:48:14 AM » |
|
So, if my server uses MySQL, then the sqlite file is useless for me right? I just don't understand how a restart of the server clears that file? It seems to save it as long as the server is not restarted.
|
|
|
|
|
Logged
|
|
|
|
|
CA.Berettonawak
|
|
« Reply #5 on: December 15, 2009, 04:16:52 PM » |
|
N O
You CANNOT USE MYSQL WITH WCS.
Has to be a .sqldb file (sqlite)
|
|
|
|
|
Logged
|
Beret, keep yourself focusing on 1 project. Be sure to memorize that down since it sounds good. i love tuna juice =CA= Pietro: back
=CA= Pietro: sorry, was downstair sharing my chocolate with my cat
=CA= Pietro: you should see his face when he ate it xD =CA= Berettonawak: just because you don't have hope doesn't mean we're doomed |
|
|
InfinityRogue
Level 0 Beginner
Offline
United States
Posts: 5
|
|
« Reply #6 on: December 15, 2009, 08:23:15 PM » |
|
I understand that! What I am asking is, since I have MySQL on my server, and it's obviously not using that, then how is it saving the xp anyways? You all say it's in a sqlite file, which I can see, but how is it reading it, if I don't have sqlite, cause it obviously is. I am asking if it saves in another text file somewhere, like .txt or something.
And the second question to it all is, let's say for some odd reason it does save only to this sqlite file, then how come on a restart of the server, the file is reset and all the xp is lost?
|
|
|
|
|
Logged
|
|
|
|
|
Sasuke[Icetouch]
|
|
« Reply #7 on: December 15, 2009, 08:50:59 PM » |
|
Have you updated all of your current Mods you have installed? Like Eventscipts to 2.0xxxx? WCS uses eventscripts to save it in the database, and eventscripts uses it's build in sqlite to do that. (If I'm not wrong it is build in, could be somewhere else too, but most likely build in ) |
|
|
|
|
Logged
|
################################ Join our new Server with the newest Mod on it! ################################ |
|
|
InfinityRogue
Level 0 Beginner
Offline
United States
Posts: 5
|
|
« Reply #8 on: December 15, 2009, 08:58:26 PM » |
|
Yeah, I have everything up to date, because it's a completely new server, so I've gotten all the latest things. And all I'm trying to figure out is, why it resets the xp's on a restart, because we do restart our servers once in a while, and I'd like to prevent deleting everybody's xp.
|
|
|
|
|
Logged
|
|
|
|
|
Sasuke[Icetouch]
|
|
« Reply #9 on: December 16, 2009, 06:33:20 PM » |
|
Well, never happend to me, and re-installed my Server alot times.
Maybe check your permissions? If eventscripts is not allowed to alter anything by itself, it will just do nothing.
But, never read anything like that before, if ppl had problems with saving, they didn't install everything properly.
|
|
|
|
|
Logged
|
################################ Join our new Server with the newest Mod on it! ################################ |
|
|
|
|
|
France
Bifkids
Germany
fucker. 
