Thread: Petition system
View Single Post
  #5  
Old 04-28-2008, 09:24 AM
ndnet
Hill Giant
 
Join Date: Oct 2003
Posts: 105
Default

The only field in that table (from the copy I'm looking at) that is not required on INSERT is `gmtext` (because there wouldn't be any gmtext when the player first submits a ticket).

The structure also saves things like the level of urgency -- GMs/Guides can raise or lower an escalation level of the petition, checkouts -- should be a count of how many times the petition has been looked at with the in-game UI, lastgm -- name of the last person to have looked at the petition, etc.

Edit: I meant to include: unavailable is probably going to be the count of how many times a GM checked out the petition but the player wasn't around to respond.

Last edited by ndnet; 04-28-2008 at 05:27 PM.. Reason: Quick inclusion
Reply With Quote