Login
User Name:

Password:



Register
Forgot your password?
Vote for Us!
tintin++ ogg sound player script for linux
Author: Robert Smith
Submitted by: Vladaar
6Dragons ogg Soundpack
Author: Vladaar
Submitted by: Vladaar
6Dragons 4.4
Author: Vladaar
Submitted by: Vladaar
LoP 1.46
Author: Remcon
Submitted by: Remcon
LOP 1.45
Author: Remcon
Submitted by: Remcon
Users Online
CommonCrawl, Yandex, DotBot

Members: 0
Guests: 6
Stats
Files
Topics
Posts
Members
Newest Member
481
3,735
19,368
618
Micheal64X
Today's Birthdays
There are no member birthdays today.
Related Links
» SmaugMuds.org » General » General Discussions » SWRSQL
Forum Rules | Mark all | Recent Posts

SWRSQL
< Newer Topic :: Older Topic >

Pages:<< prev 1 next >>
Post is unread #1 Dec 30, 2006, 8:35 pm
Go to the top of the page
Go to the bottom of the page

Rojan QDel
Fledgling
GroupMembers
Posts25
JoinedDec 30, 2006

A while ago I started a personal project of mine partly out of curiousity and partly out of my desire to make easier-to-use and more efficient web scripts interfacing with the SWR codebase. The project is built off of SWR:FUSS and is essentially geared towards, in the end, removing the flatfile database system and replacing it with MySQL. I've gotten pretty far, replacing ships, boards, starsystems, planets, notes, and sysdata, and some other things I'm forgetting to list. I was wondering if anyone would be interested in helping me finish the project. I have my own server I host it on so of course you'd get your own shell account. It's open-source and public once I get my sourceforge project created but I would like some help in truly making a version of SWRFUSS fit to run without files at all. The rest of the methods need to be converted as well as refining the current methods of saving to MySQL and making them more efficient. Anyone who's interested please e-mail me at rojanqdel@verizon.net or AIM at RojanQDel.

-Thanks
       
Post is unread #2 Dec 30, 2006, 9:40 pm
Go to the top of the page
Go to the bottom of the page

Metsuro
Apprentice
GroupMembers
Posts68
JoinedSep 2, 2006

Why not open a copy that you have now, so that people can see it, and go from there?
       
Post is unread #3 Dec 30, 2006, 11:43 pm
Go to the top of the page
Go to the bottom of the page

Rojan QDel
Fledgling
GroupMembers
Posts25
JoinedDec 30, 2006

I plan on posting one as soon as sourceforge authorizes my account. And the reason I want someone helping me finish it is so that we can actually release a finished version instead of 10 people doing it on their own.
       
Post is unread #4 Dec 31, 2006, 9:04 am
Go to the top of the page
Go to the bottom of the page

Samson
Black Hand
GroupAdministrators
Posts3,643
JoinedJan 1, 2002

So your plans are to eventually be rid of area files, pfiles, class, race, and other files? Are you planning on simply substituting the database for the function of the flatfiles or are you planning to "query on demand" as the information is needed by the game?

And have you stopped to consider that relying completely on SQL to operate the game will cut out a large chunk of users? I had to address this very problem myself when doing SQL work for AFKMud 2.0 after finding out how many systems still don't have the required libraries and support files to do this. And that was just when I had converted helpfiles.

I'm not trying to discourage you from doing it, just making sure you're aware of what this decision means in the long term.
       
Post is unread #5 Dec 31, 2006, 11:42 am
Go to the top of the page
Go to the bottom of the page

Rojan QDel
Fledgling
GroupMembers
Posts25
JoinedDec 30, 2006

Well, I don't expect a majority of users to make use of this version of the codebase. And I considered querying on demand and tried it out a bit, but it seemed to be a lot more resource-intensive then simply replacing the loading and saving functions for flatfiles with ones for the database. Though since resaving the whole database is just as efficient, probably less so than resaving a whole flatfile, I redid the save functions to take an bitvector flag of WHAT data to save along with the object to save. So for each object, it only saves specific data, not the whole thing, which will make the process exponentially more efficient. And yes, I do hope to eventually be rid of all flatfiles except for the source.
       
Post is unread #6 Jan 22, 2007, 10:06 am
Go to the top of the page
Go to the bottom of the page

Rojan QDel
Fledgling
GroupMembers
Posts25
JoinedDec 30, 2006

For any who care, I uploaded version 0.1 Alpha to sourceforge: SourceForge.net: SWR:SQL
       
Pages:<< prev 1 next >>