eq ''> eq 'Search'> eq 'Previous Page'> eq 'Next Page'> DELETE FROM DiscussionArchiveCount;FINISH SELECT COUNT(*) NumMsg FROM DiscussionArchive WHERE AttachTo= AND AttachLink= AND GroupLink=;OUTPUT NIL INSERT INTO DiscussionArchiveCount (AttachTo,AttachLink,GroupLink,ArchiveCount) VALUES (,,,);FINISH .. =
SELECT DISTINCT AttachTo,AttachLink,GroupLink FROM DiscussionArchive ORDER BY AttachTo,AttachLink;OUTPUT EachArea INSERT INTO DiscussionArchive (DiscussionID,AttachTo,AttachLink,MsgDate,UserLink,Content,GroupLink,IP) VALUES (,,,,,,,);FINISH. UPDATE DiscussionArchiveCount SET ArchiveCount=ArchiveCount+1 WHERE AttachTo= AND AttachLink= AND GroupLink=;FINISH DELETE FROM Discussion WHERE DiscussionID=;FINISH Archiving Messages.
SELECT * FROM Discussion WHERE UNIX_TIMESTAMP(MsgDate)<(UNIX_TIMESTAMP()-(30*86400));OUTPUT ArchiveMsg SELECT SecLink FROM Security WHERE SecLink=32 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=33 AND UserLink=;OUTPUT NIL ne '' && $in{Security_MediaDel} ne '0E0'> DELETE FROM NewsAttach WHERE AttachType='Media' AND AttachID=;OUTPUT NIL DELETE FROM Discussion WHERE AttachTo='Media' AND AttachLink=;OUTPUT NIL DELETE FROM Endorsement WHERE Type='Media' AND TypeID=;OUTPUT NIL DELETE FROM Media WHERE MediaID=;OUTPUT NIL Deleted Media.

  Media

SELECT UserID,Nym FROM User WHERE UserID=;OUTPUT NIL>SELECT count(*) TotalCount FROM Media WHERE 1=1 AND Silly!='Y' ne ''>AND Category= ne ''>AND Name LIKE ;OUTPUT NIL SELECT MediaID,Category,Name,URL,LastModified,LMBy FROM Media WHERE 1=1 AND Silly!='Y' ne ''>AND Category= ne ''>AND Name LIKE ORDER BY Category,Name LIMIT ,;OUTPUT MEDIA LIST Category --Any-- SELECTED> SELECT DISTINCT Category Temp FROM Media AND Silly!='Y' ORDER BY Temp;OUTPUT Name Website [X]   eq ''>Not Available ne ''>Website    Page: class="Text2" class="Headline1">