Our Campaigns - News - <VAR Headline,Safe> - <VAR MonthSN<VAR NewsDate,sqlmonth>> <VAR NewsDate,sqlday>, <VAR NewsDate,sqlyear>

SELECT *,DATE_FORMAT(DATE_ADD(DATE_ADD(NewsDate,INTERVAL 6 Hour),INTERVAL Hour),'%W, %M %e, %Y %r') LDate FROM News WHERE NewsID=;OUTPUT NIL SELECT *,DATE_FORMAT(DATE_ADD(DATE_ADD(NewsDate,INTERVAL 6 Hour),INTERVAL Hour),'%W, %M %e, %Y %r') LDate FROM NewsLog WHERE NewsLogID=;OUTPUT NIL Our Campaigns - News - <VAR Headline,Safe> - <VAR MonthSN<VAR NewsDate,sqlmonth>> <VAR NewsDate,sqlday>, <VAR NewsDate,sqlyear> DELETE FROM UserNewItems WHERE UserLink= AND ItemType='News' AND ItemLink=;FINISH INSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'News',,Now());FINISH SELECT Nym FROM User WHERE UserID=;OUTPUT NIL SELECT Nym CNym FROM User WHERE UserID=;OUTPUT NIL SELECT Name PName FROM Party WHERE PartyID=;OUTPUT NIL

ne ''> ne '' && $in{Session_Access}+0 > 800> DELETE FROM NewsAttach WHERE NewsLink= AND AttachType= AND AttachID=;FINISHNews Attachment Removed. SELECT SecLink FROM Security WHERE SecLink=12 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=14 AND UserLink=;OUTPUT NIL SELECT Category MCat,Name MName FROM Media WHERE MediaID=;OUTPUT NIL

LOGGED NEWS DETAILS

Parent(s)

[X] SELECT * FROM NewsAttach WHERE NewsLink=;OUTPUT

Contributor

Last Edited

> , :

Logged

SELECT COUNT(*) NumLogged FROM NewsLog WHERE NewsID=;OUTPUT NIL[Current] SELECT NewsLogID TNLID,LogDate TLD FROM NewsLog WHERE NewsID= AND LogDate > ORDER BY LogDate LIMIT 1;OUTPUT NIL [Newer] SELECT NewsLogID TNLID,LogDate TLD FROM NewsLog WHERE NewsID= AND LogDate < ORDER BY LogDate DESC LIMIT 1;OUTPUT NIL [Older] SELECT NewsLogID TNLID,LogDate TLD FROM NewsLog WHERE NewsID= ORDER BY LogDate DESC LIMIT 1;OUTPUT NIL [Older]