SELECT SecLink FROM Security WHERE SecLink=43 AND UserLink=;OUTPUT NIL INSERT INTO ProgramLog (ShortDescribe,LongDescribe,Suggestor,Priority,ModifyDate) VALUES (,,,,Now());FINISH DELETE FROM ProgramLog WHERE ProgramLogID= AND Suggestor=;FINISHSuggestion Deleted.
 UPDATE ProgramLog SET CompleteDate= WHERE ProgramLogID=;FINISHSuggestion Completed.
  Site Programming Changes
Our Campaigns is a work in progress. Some bugs still exist, and features are continuously being added.

On the left is a list of changes that have been completed and the dates they were completed on, newest first, since this feature was added (2/23/2005). On the right is a list of changes I will try to work on when I have time. You may add to this list once you are a member, but I reserve the right to delete or modify your suggestion.


- Randy Parker

SELECT * FROM ProgramLog WHERE CompleteDate != '0000-00-00 00:00:00' ORDER BY CompleteDate DESC;OUTPUT
Completed Changes
Complete Date Description
,Safe> ,  :
SELECT UserID SgUserID,Nym SgNym,ProgramLogID,ShortDescribe,Priority/100 TPri FROM ProgramLog,User WHERE CompleteDate='0000-00-00 00:00:00' AND Rejected='' AND UserID=Suggestor ORDER BY Priority DESC;OUTPUT SELECT UserID SgUserID,Nym SgNym,ProgramLogID,ShortDescribe,Priority/100 TPri FROM ProgramLog,User WHERE CompleteDate='0000-00-00 00:00:00' AND Rejected='Y' AND UserID=Suggestor ORDER BY Priority DESC;OUTPUT
To-Do Changes
Suggested By Description Priority
[X] [Completed]
Rejected Suggestions
Suggested By Description Priority
Add Suggestion
Priority
Short
Long
Description