|
SELECT SecLink FROM Security WHERE SecLink=76 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=77 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=78 AND UserLink=;OUTPUT NIL
SELECT SecLink FROM Security WHERE SecLink=79 AND UserLink=;OUTPUT NIL
eq 'Y') && ( ne ) && $in{Security_UserOth} ne '0E0'>
You are not authorized to see that User.
ne 'Y') || ( eq ) || $in{Security_UserOth} ne '0E0'>
 |
USER DETAILS |
eq ) || $in{Security_UserOth} ne '0E0'> |
|
| Screen Name | |
ne ''> |
| Name | |
| Location | , , |
| Email | |
| Birthday | > , |
| Affiliation | |
| First Login | > , : |
| Last Login | > , : |
| Predictions |
Points:
Predictions: / (%)
Points Per: / ()
|
| Emote Messages |
SELECT COUNT(*) MPost FROM DiscussionEmote WHERE Emote= AND MsgUserLink=;OUTPUT NIL
SELECT COUNT(*) MPost FROM DiscussionEmote WHERE Emote= AND UserLink=;OUTPUT NIL
|
SELECT COUNT(*) ArchiveCount FROM DiscussionEmote as e,DiscussionArchive as d WHERE e.MsgUserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0
AND (PrivateTo IN (0,) OR d.UserLink=)
;OUTPUT NIL
SELECT COUNT(*) PCnt FROM DiscussionEmote as e,Discussion as d WHERE e.MsgUserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0
AND (PrivateTo IN (0,) OR d.UserLink=)
OUTPUT NIL
| DISCUSSION |
SELECT Nym,Photo,PAccuracy,Access,Abbr,Color FROM User,Party WHERE UserID= AND PartyID=PartyLink;OUTPUT NIL
ne ''> |
| : | (President) ( points)
 x
SELECT Emote,COUNT(UserLink) NumEm FROM DiscussionEmote WHERE DiscussionLink= GROUP BY Emote;OUTPUT DoEmotes
| > , : |
|
|
|
SELECT DISTINCT DiscussionID,MsgDate,d.UserLink,Content,AttachTo,AttachLink FROM DiscussionEmote as e,Discussion as d WHERE e.MsgUserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0 AND AttachTo!='Friends'
AND (PrivateTo IN (0,) OR d.UserLink=)
ORDER BY MsgDate DESC LIMIT ,;OUTPUT
SELECT DISTINCT DiscussionID,MsgDate,d.UserLink,Content,AttachTo,AttachLink FROM DiscussionEmote as e,DiscussionArchive as d WHERE e.MsgUserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0 AND AttachTo!='Friends'
AND (PrivateTo IN (0,) OR d.UserLink=)
ORDER BY MsgDate DESC LIMIT ,;OUTPUT
SELECT COUNT(*) ArchiveCount FROM DiscussionEmote as e,DiscussionArchive as d WHERE e.UserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0
AND (PrivateTo IN (0,) OR d.UserLink=)
;OUTPUT NIL
SELECT COUNT(*) PCnt FROM DiscussionEmote as e,Discussion as d WHERE e.UserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0
AND (PrivateTo IN (0,) OR d.UserLink=)
OUTPUT NIL
| DISCUSSION |
SELECT Nym,Photo,PAccuracy,Access,Abbr,Color FROM User,Party WHERE UserID= AND PartyID=PartyLink;OUTPUT NIL
| ne ''> |
| : | (President) ( points)
x
SELECT Emote,COUNT(UserLink) NumEm FROM DiscussionEmote WHERE DiscussionLink= GROUP BY Emote;OUTPUT DoEmotes
| > , : |
|
|
|
SELECT DISTINCT DiscussionID,MsgDate,d.UserLink,Content,AttachTo,AttachLink FROM DiscussionEmote as e,Discussion as d WHERE e.UserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0 AND AttachTo!='Friends'
AND (PrivateTo IN (0,) OR d.UserLink=)
ORDER BY MsgDate DESC LIMIT ,;OUTPUT
SELECT DISTINCT DiscussionID,MsgDate,d.UserLink,Content,AttachTo,AttachLink FROM DiscussionEmote as e,DiscussionArchive as d WHERE e.UserLink= AND Emote= AND DiscussionID=e.DiscussionLink AND GroupLink=+0 AND AttachTo!='Friends'
AND (PrivateTo IN (0,) OR d.UserLink=)
ORDER BY MsgDate DESC LIMIT ,;OUTPUT
>
|
|
to
from