| www.ClassicTW.com https://mail.black-squirrel.com/ |
|
| What is the TWA Database Project? https://mail.black-squirrel.com/viewtopic.php?f=1&t=19326 |
Page 1 of 1 |
| Author: | Cerne [ Fri May 18, 2007 2:25 am ] |
| Post subject: | |
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. |
|
| Author: | Runaway Proton [ Fri May 18, 2007 10:03 am ] |
| Post subject: | |
Cerne, what you're taken on is a huge project, but when complete, will be very usefull. Thanks for your hard work. |
|
| Author: | Robotica [ Fri May 18, 2007 3:57 pm ] |
| Post subject: | |
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. |
|
| Author: | Runaway Proton [ Sat May 19, 2007 12:41 am ] |
| Post subject: | |
That's still needing some work. |
|
| Author: | Vader [ Wed May 23, 2007 3:53 pm ] |
| Post subject: | |
Got a lot of unknown authors on there. Most of the edits on my page list who made em if you want that info. |
|
| Author: | Vulcan [ Wed May 23, 2007 10:23 pm ] |
| Post subject: | |
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. |
|
| Author: | Thrawn [ Wed May 23, 2007 10:51 pm ] |
| Post subject: | |
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. |
|
| Author: | Cerne [ Thu May 24, 2007 1:27 am ] |
| Post subject: | |
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 |
|
| Page 1 of 1 | All times are UTC - 5 hours |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|