think i've got em
just had a little brainstorming on it ^^
should take 1 column in the membertable of the phpBB like 'voted' for '0/1' to check if you gonna see the vote or a little diagram about the vote (if you've voted already)..also this check should just happen, if you're logged into the board, otherwise there could be shown up the actual cycle and also the diagram of the vote.
could be also checked by looking for votes by this member..but at first the site has to check if you are a member, and adding a 0 or 1 to this, should take less time then that one plus a new query
"looking for votes by this member".. --> votes should be written into another table like 'mapvotes' with columns for 'n id, mapid, regular(1/0) (reduces the time of evaluation), timestamp..think, one row for one voted map should work..
the cronjob (set to execute every .. days) would be a little php file...should have to evaluate the votes, write the new mapcycle.cfg, write the results into another table (for showing it up on page and maybe a history), set the 'voted' column in the membertable back to 0 and del all old votes..
don't know if the server also has to restart then...but could be also done by the php (cmd line exec or a rcon connection), but better by another cronjob, if required.
hm..ah, a table for maps ^^ ..with their id, name, filename
guess the xlrstats and the monitorpage open pic's called like the map, or?
for the admin area, hm..just shown up to b3 admins (the orange ones in here :>)
in there a little uploader and a list of the maps..maybe the possibility to edit entries, add a pic or smth. like that..
Think that's pretty it (:
Up till next monday, i'm still free :>
time for breakfast
@Unclefragger
hm..wiki says ut4 was in 2007..must have seen it before..also there wasn't a standalone version...
i even don't rly know, if it was a urt map..but for sure a .pk3 (:
'll have to meditate about it
greets
---
hm, think, it's easier to store the votes in the table of the maps, than in a 'mapvotes'..just by writing a +1 to a 'vote' column of every map...should work, if ppl. don't vote at the same time..evaluation would be much easier this way, by sorting the query by 'vote' :>