View unanswered posts | View active topics It is currently Fri Apr 24, 2026 8:47 am



Reply to topic  [ 8 posts ] 
 What is the TWA Database Project? 
Author Message
Gameop
User avatar

Joined: Sun Oct 08, 2006 2:00 am
Posts: 991
Unread post 
The TWA Database Project, simply put, is to put the settings of the most popular edits into a mysql database that can be accessed via a dynamic web page. All of the settings for each edit available to the player, sysop or gameop.

The project is made up of 3 steps.

Step 1. Add all of the edits I have downloaded to the mysql database and accessable via the page at here. This page is dynamic and reads each edit from the mysql database but lacks the specific ship, planet and alien info from the edit.

Each twa file listed in the database is linked to a zip file that can be downloaded, containing the twa file and a txt file containing the default settings for the edit (the same as you would get from hitting '*' from the game menu.  There is also a 'Specs?' column that is linked to the same txt file mentioned above. So you can download either the edit and the spec file or just the spec file.


Step 2. Add the specific ship, planet, and alien settings for each edit to the mysql database, also available via this page.

Step 3. Export the database info and make it available to anyone that wants to use it on their own site or personal server.

Cerne


---
Current Status of Stage 1 - Complete



[05/31/2007]

I have added a total of 87 TWA files to the database. That is every file I have.  I will start work shortly on stage 2


[05/17/2007]


I just added 18 more edits to the TWGS and grabbed the info for input into the database


I have the A-O added minus 16 C, D and E edits but I will catch up those shortly.


At present I have ~41 Edits in the database and ~45 more to go before stage 1 is complete





[04/22/2007]


I just added 24 more edits to the TWGS and grabbed the info for input into the database





[04/21/2007]


I have 20 edits in the database (All of the A's and B's) at the moment with about 40 to 50 more to go.

_________________
"All warfare is based on deception..." - Art of War
"Time will tell all tales" - SG
Any advanced tactic in TW is indistinguishable from cheating.


Fri May 18, 2007 2:25 am
Profile ICQ
Gameop
User avatar

Joined: Thu Aug 24, 2006 2:00 am
Posts: 1737
Location: USA
Unread post 
Cerne, what you're taken on is a huge project, but when complete, will be very usefull.
Thanks for your hard work.
 
 

_________________
American soldiers don't fight because they hate what's in front of them...they fight because they love what's behind them.
http://www.runawayproton.com <-- Expired
telnet://runawayproton.dyndns.org:223 V2.20b Games <-- Expired
http://www.twsubspace.com <-- Expired
Teamspeak 3 50.23.212.53:4196 <-- Expired
Just a has been now.


Fri May 18, 2007 10:03 am
Profile WWW
Gunnery Sergeant

Joined: Tue Apr 10, 2007 2:51 pm
Posts: 27
Unread post 
Perhaps He could also benefit from the t-edit revealer you have on your twgs. Just a suggestion and tell me to shut up when neccesary.

_________________
Make no mistake, I am a woman


Fri May 18, 2007 3:57 pm
Profile
Gameop
User avatar

Joined: Thu Aug 24, 2006 2:00 am
Posts: 1737
Location: USA
Unread post 
That's still needing some work.
 

_________________
American soldiers don't fight because they hate what's in front of them...they fight because they love what's behind them.
http://www.runawayproton.com <-- Expired
telnet://runawayproton.dyndns.org:223 V2.20b Games <-- Expired
http://www.twsubspace.com <-- Expired
Teamspeak 3 50.23.212.53:4196 <-- Expired
Just a has been now.


Sat May 19, 2007 12:41 am
Profile WWW
Lieutenant Commander
User avatar

Joined: Fri Apr 06, 2001 2:00 am
Posts: 727
Location: Arkansas
Unread post 
Got a lot of unknown authors on there. Most of the edits on my page list who made em if you want that info.

_________________
Black Sun TWGS
http://www.blacksuntwgs.com
blacksuntwgs.gotdns.com:23


Wed May 23, 2007 3:53 pm
Profile ICQ WWW
Gameop
User avatar

Joined: Fri Sep 03, 2004 2:00 am
Posts: 2041
Location: Acworth, Georgis USA
Unread post 
Speaking of which Vader, I seriously need to redo my downloads page, heh, haven't had time to do it, I also need to get the info of who made the edits, I will get with you later on that when I finally revamp the downloads page. I am working on a dynamic upload/download setup, I hope it works, then the whole thing will update itself, laff.

_________________
Vulcan's Forge
v1 TWGS telnet://vulcansforge.homeip.net:2002
v2 TWGS telnet://vulcansforge.homeip.net:23
Forum and site down for now.
my Email is vulcan219@comcast.net now


Wed May 23, 2007 10:23 pm
Profile ICQ YIM
Commander
User avatar

Joined: Fri Aug 20, 2004 2:00 am
Posts: 1801
Location: Outer Rims
Unread post 
Cerne;

Since the TWA Database project is your baby, could you provide me a little detail on what it is? I'd like to post it in the TradeWars Academy site and I can link over to your project. You can email me what you want posted for an explanation and I'll put it on a page. Providing you don't mind me doing so. I'd like to help give it more exposure.

_________________
-Thrawn

But risk has always been an inescapable part of warfare.

--

Knight to Queen's Bishop 3


Wed May 23, 2007 10:51 pm
Profile
Gameop
User avatar

Joined: Sun Oct 08, 2006 2:00 am
Posts: 991
Unread post 
Vader wrote:
Got a lot of unknown authors on there. Most of the edits on my page list who made em if you want that info.


I am going to update the authors this weekend. I now have a php based editor for the mysql database.


Thrawn wrote:
Since the TWA Database project is your baby, could you provide me a
little detail on what it is? I'd like to post it in the TradeWars
Academy site and I can link over to your project. You can email me what
you want posted for an explanation and I'll put it on a page. Providing
you don't mind me doing so. I'd like to help give it more exposure.


The first post is all the info I have on it.

Cerne

_________________
"All warfare is based on deception..." - Art of War
"Time will tell all tales" - SG
Any advanced tactic in TW is indistinguishable from cheating.


Thu May 24, 2007 1:27 am
Profile ICQ
Display posts from previous:  Sort by  
Reply to topic   [ 8 posts ] 

Who is online

Users browsing this forum: No registered users and 22 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by wSTSoftware.