I made a small conception a while back.
Maybe it is useful?
Conception of new Mod portal for OpenXcom Mods:
Framework: probably Codeigniter (PHP5+)
Database: MySQL (Files will be stored in a Directory on the Server)
Templates: HTML / CSS only (ifpossible no Javascript
Maybe customizeable CSS files
Project will be Opensource and shared for participation on github repository
Filetypes:
Screenshots: jpg or png only
Modfiles: *.zip only
both need specific File verification
should we have a size for uploadable files restriction?? -> Soundmod with very huge sound files!)
Database:
Entity Relationship Model
Relational Table Model
Logindata for Users should be the same as for the Forum
Views:
Users, Authors and Admins:
Default Site (News, Basic Search, Updated Mods, Newest Mods)
Searchsite
Modsite
Statistics
Authors and Admins:
Add new Mod
Edit existing Mod
Upload Screenshot
Upload Files
Mod specific Statistics
Admins:
Add and Edit News Site
Reassign Authors and Mod Ownership
Formfeatures:
Searchsite:
Keywordsearch
Search by Author
Search by Modname
Search by Gametype (UFO, TFTD, Total Conversion, Exe Mods (OpenXcom Extended for example)
Search by category (Maps, Graphics, Weapons, Additional Aliens, etc..)
Add new Mod Site:
Textfields (Mod discription (short/long)
Upload for README.TXT
Upload for CREDITS.TXT
or alternativly Formfields for c&p
Upload Screenshots
Sort Screenshots / Rename Screenshots
Add Forum Thread Link
Add Modfile
Add Changelog entries for new to upload file
Select Licence (from Database List) or
Add Licence Terms (Formfield)
Add manual Keywords
Set Keywords from List (from Database)
Edit existing Mod:
Basically the same ass Add new Mod
But with ability to include other Authors (in case of abandoned Mods (Admin only)
Mod Site:
Draw Short and Long Description
Draw Screenshots (Gallery)
Draw README.TXT
Draw CREDIT.TXT
Draw Changelog entries (last 2)
Draw Licence information
Draw Mod filelist (with download links)
Draw Commentbox (maybe it is better to add a link to the appropriate Forum Link?)
News Site:
Chronological News Articles
Randomly Selected Mods
Link in News from openxcom.org
Linklist (project related -> ufopaedia, forum etc..)
Bugtracker Issue Index
User Information:
Email Notifications
RSS Feeds
Filetracking: (Possible Feature)
Track Resource files of Mods and also Map and Routes files
via their md5checksum, this would allow to create a really andvanced search feature,
for Modders to find which files are used in which mod and in which version they are used.
Important functions (Requiered):
File verification on Upload for Screenshots and zip files.
Inspecting uploaded files for malicious content. (if possible)
Thumbnail generator for Screenshot preview.
Picture Scaler (minimize load times)
Picture Cache (reduce CPU load)
Sanatizing Database queries!
Maybe other stuff to add later?
Todo:
Development Server
Framework Documentation and setup
ERD
Relational Model
HTML Templates
Class Definitions
Maybe UML Model (since we work OOP and need some proper planning?)