projectshome.vwarmysql5

References

• VWar Homepage
• Local Development Version
• Remote Development Version

VWar is a game clan war system. It uses a layout similar to a forum and allows one clan to challenge another. At the moment My SQL 5 support is lacking to say the least. Stefan from the Old Gents clan has asked me to get it working with My SQL 5.

I started with setting it up on their clan server but have now decided to work locally on my own server since I have access to the logs.

Notes

• Had to give write access to backup folder so that htaccess and htpasswd files could be created at end of installation
• I had already made a bunch of changes to the code before moving development to my local server. These were mostly due to how My SQL doesn't allow "default" values for text columns but the VWar source code had them defined all over the place.

Todo

• Seems to be stable as they've been using it for a 2 and 1/2 months with no more error reports

Complete
11.05.07

• Testing seems complete on the old gents server, I've tried most functions and they seem to work
• Changed line 901 in vwar_complete.style to say "Game Type Name" instead of "Gametypename", this is the only change that does not have a Tann San comment next to it as I didn't want that entered into the DB 
• Uploaded to vwar server for public approval

03.05.07

• Created remote DB 
• Setup initial remote file structure
• Completed install procedure
• Began changing files here and there to allow the clan to use them
• MySQLi Conversion
  • changes made to:
    • install.php
    • functions_admin.php
    • functions_common.php
    • functions_install.php
    • class_backup.php
  • copied class_db.php as class_db_mysqli.php and plan to change it to use mysqli
  • added a new row to the installation requirements page (index.php) to show if the My SQ Li? is available
• Tested on my server and can perform all steps required to challenge the clan