I've had a sort of idea clicking around in my head for a while, and I think I could implement it, but I'm afraid it's going to be a lot of additional queries for not a lot of payoff.
Basically my site runs forum
games, and there are clear winners and losers at the end of the games (which run several months). I'd like to add a line to the postbit that shows their record in Win-Loss-Draw-Ongoing format (2-1-0-3, for example). How I planned on doing it is something like so:
I add a page where users with the correct privileges (using an array of usergroups to check) can mark one of their threads (which would be in a specific array of forums) as a game thread. They could then add users from the user list as players in that game. The game would be flagged with one of two flags, Ongoing or Completed (which would include things like abandoned games). When the moderator (the one running the game) has the game set to ongoing, it increments all players Ongoing count (I'm assuming I would need an additional set of columns in the user table). Should a player need to be replaced, they note it on the aforementioned page, and the old player is removed (and their ongoing count decremented), and the new player added (and their ongoing count incremented). When the game is marked as completed, all players have their Ongoing count decremented and the mod is taken to a screen where they mark each player's result (easily done with a for loop and some radio buttons).
As far as I can tell, everything mentioned so far is all pretty doable. I can add the win, loss, draw, and ongoing fields to the select statement during showthread, and viewprofile, and the like. I also want the record to link to a page where all their games are listed, along with the result. I'm thinking I would need another table with a gameID, threadID, gamestatus, userID, and result (the data integrity issue is sort of counterbalanced by reducing server load by avoiding a join), or possibly split that table into two (one with games and statuses, and one with games and user results).
I've never tried to add something like this into vB because it has...quirky ways of handling information (things like the GPC baffle me, but I've made stuff work with it). I know everything I've said is doable with some minor changes but do you think it's going to be pretty server intensive as well?
05-01-2007, 06:24 PM
Is this hack feasible or too intensive?
Linear Mode
