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.
DELETE FROM UserNameArchive WHERE UserLink= AND ChangeDate=;FINISH
ne 'Y') || ( eq ) || $in{Security_UserOth} ne '0E0'>
 |
USER DETAILS |
eq ) || $in{Security_UserOth} ne '0E0'> |
|
| Screen Name | |
ne ''> |
| Name | |
| Location | , , |
| Birthday | > , |
| Possible Duplicate Users |
SELECT DISTINCT IP FROM Discussion WHERE IP!='' AND UserLink=;OUTPUT CollectIPs
SELECT DISTINCT Nym DNym FROM Discussion,User WHERE IP IN () AND UserLink!= AND UserID=UserLink;OUTPUT
|
| Affiliation | |
| Browser |
SELECT * FROM UserBrowser WHERE UserLink= ORDER BY LastLogin DESC;OUTPUT EachBrowser
|
| Member Of | Public Website
SELECT GroupName FROM GroupMember,DiscussionGroup WHERE UserLink= AND DiscussionGroupID=GroupLink ORDER BY DiscussionGroupID;OUTPUT
|
| First Login | > , : |
| Last Login | > , : |
| Access | SELECT count(*) NumAccess FROM Security WHERE UserLink=;OUTPUT NIL |
SELECT * FROM UserNameArchive WHERE UserLink= ORDER BY ChangeDate;
FINISH
[X]
| Previous Screen Names |
// - //:
OUTPUT
|
| Predictions |
Points:
Predictions: / (%)
Points Per: / ()
|
| Messages Posted |
SELECT COUNT(*) MPost FROM Discussion WHERE UserLink=;OUTPUT NIL
SELECT COUNT(*) MAPost FROM DiscussionArchive WHERE UserLink=;OUTPUT NIL
|
| Contributed |
SELECT COUNT(*) LMCnt FROM Race WHERE FirstBy= AND ParentRace=0 AND Silly='';OUTPUT NIL Races,
SELECT COUNT(*) LMCnt FROM Race WHERE FirstBy= AND ParentRace!=0 AND Silly='';OUTPUT NIL
SELECT COUNT(DISTINCT RaceLink,SubLink) LMCnt2 FROM RaceSub WHERE LMBy=;OUTPUT NIL Sub-Races,
SELECT COUNT(*) LMCnt FROM Candidate WHERE FirstBy= AND Silly='';OUTPUT NIL Candidates,
SELECT COUNT(*) LMCnt FROM Container WHERE FirstBy= AND Silly='';OUTPUT NIL Containers,
SELECT COUNT(*) LMCnt FROM Poll WHERE FirstBy=;OUTPUT NIL Polls,
SELECT COUNT(*) LMCnt FROM PollingFirm WHERE FirstBy=;OUTPUT NIL Polling Firms,
SELECT COUNT(*) LMCnt FROM News WHERE FirstBy= AND Silly='';OUTPUT NIL News Items,
SELECT COUNT(*) LMCnt FROM Party WHERE FirstBy= AND Silly='';OUTPUT NIL Parties,
SELECT COUNT(*) LMCnt FROM Issue WHERE FirstBy= AND Silly='';OUTPUT NIL Issues,
SELECT COUNT(*) LMCnt FROM Book WHERE FirstBy=;OUTPUT NIL Books,
SELECT COUNT(*) LMCnt FROM InfoLink WHERE LMBy=;OUTPUT NIL Info Links,
SELECT COUNT(*) LMCnt FROM FAQ WHERE FirstBy=;OUTPUT NIL FAQs,
SELECT COUNT(*) LMCnt FROM Endorsement WHERE FirstBy= AND Type='User';OUTPUT NIL Personal Endorsements,
SELECT COUNT(*) LMCnt FROM Endorsement WHERE FirstBy= AND Type='Media';OUTPUT NIL Media Endorsements,
SELECT COUNT(*) LMCnt FROM Endorsement WHERE FirstBy= AND Type='Candidate';OUTPUT NIL Candidate Endorsements,
|
| Your 2¢ |
 ,
SELECT Emote,COUNT(*) NumE FROM DiscussionEmote WHERE UserLink= GROUP BY Emote;OUTPUT UserEmotes
|
| 2¢ to You |
,
SELECT Emote,COUNT(*) NumE FROM DiscussionEmote WHERE MsgUserLink= GROUP BY Emote;OUTPUT UserEmotes
|
| Tags |
-
SELECT TagName FROM TagAttach,Tag WHERE ParentType='User' AND ParentID= AND TagID=TagLink ORDER BY Category,TagName;OUTPUT
|
| Ignoring |
-
SELECT Nym INym FROM IgnoreUser,User WHERE ParentUser= AND UserID=IgnoreUser ORDER BY INym;OUTPUT
|
| Ignored By |
-
SELECT Nym INym FROM IgnoreUser,User WHERE IgnoreUser= AND UserID=ParentUser ORDER BY INym;OUTPUT
|
| Gets Armies | : Central |
| Info | ne 'Y'>,plaintext> |
DELETE FROM GroupMember WHERE GroupLink= AND UserLink=;OUTPUT NIL
INSERT INTO GroupMember (GroupLink,UserLink,Access) VALUES (,,200);OUTPUT NIL
SELECT COUNT(*) Access FROM GroupMember WHERE GroupLink= AND UserLink=;OUTPUT NIL
Is a member of .
Give this person access to
SELECT DiscussionGroupID,GroupName FROM DiscussionGroup WHERE Moderator= ORDER BY GroupName;OUTPUT
UPDATE Session SET UserID= WHERE OwnerCode=;FINISHUser Transfer Complete.
Become this User
>
|
>
SELECT UserBlogID,BlogName FROM UserBlog WHERE UserLink=;
OUTPUT NIL
| Is In |
>
|
|
SELECT ContainerID,Category,Name FROM Cart,Container WHERE UserLink= AND ItemType='Container' AND ContainerID=ItemID AND AmIn='Y' ORDER BY Container.Priority,Category LIMIT 40;OUTPUT
>
|
|
SELECT RaceID,Race.Title,PollEnd FROM Cart,Race WHERE UserLink= AND ItemType='Race' AND AmIn='Y' AND RaceID=ItemID ORDER BY PollStart DESC LIMIT 20;OUTPUT
SELECT PresGameCandidateID,FirstName,LastName,BirthDate,BuildPoints,Abbr,Color FROM PresGameCandidate as c,Party WHERE c.FirstBy= AND PartyID=PartyLink ORDER BY c.FirstEnter DESC;
FINISH
| Presidential Game Candidates |  |
|
| Pty | Name | Born | Build Points |
>
|
|
|
|
|
OUTPUT
| ENDORSEMENTS |
>
| - ,Safe> , |
|
style="background-color:black;color:white">🚫 |
SELECT RaceID,Race.Title,PollEnd,FirstName,LastName,Abbr,Color,AntiEndorse FROM Endorsement,Race,Candidate,Party WHERE Endorsement.Type='User' AND TypeID= AND RaceID=RaceLink AND CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY PollStart DESC,Endorsement.LastModified LIMIT 20;OUTPUT
| LEANING PREDICTIONS |
| PRESIDENTIAL |
>
|
 |
Slight Lean Strong Safe |
ne ''>$in{Color}='#'.sprintf("%02x%02x%02x",255-int((255-hex(substr($in{Color},1,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},3,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},5,2)))/(5-$in{Amount})));
SELECT RaceLink,Title,FirstName,LastName,Amount,Color,MapFill,CandidateID,Winner,Winner2 FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Office='President' AND Type='General Election' AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND
ContainerID=ParentContainer AND CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount;OUTPUT
$mogtmp='cp '.$in{BIDIR}.'/ustemp.gif '.$in{BIDIR}.'/upresmap.gif'; $res=`$mogtmp`; $mogtmp='mogrify'.$in{MakeMap}.' '.$in{BIDIR}.'/upresmap.gif'; $res=`$mogtmp`;
|
| SENATE |
>
|
|
Slight Lean Strong Safe |
ne ''>$in{Color}='#'.sprintf("%02x%02x%02x",255-int((255-hex(substr($in{Color},1,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},3,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},5,2)))/(5-$in{Amount})));
SELECT RaceLink,Title,FirstName,LastName,Amount,Color,MapFill,CandidateID,Winner,Winner2 FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Office='Senate' AND Type='General Election' AND ContainerID=ParentContainer AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND
CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount,PollEnd LIMIT 40;OUTPUT
$mogtmp='cp '.$in{BIDIR}.'/2seat.gif '.$in{BIDIR}.'/usenmap.gif'; $res=`$mogtmp`; $mogtmp='mogrify'.$in{MakeMap}.' '.$in{BIDIR}.'/usenmap.gif'; $res=`$mogtmp`;
|
| GOVERNORS |
>
|
|
Slight Lean Strong Safe |
ne ''>$in{Color}='#'.sprintf("%02x%02x%02x",255-int((255-hex(substr($in{Color},1,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},3,2)))/(5-$in{Amount})),255-int((255-hex(substr($in{Color},5,2)))/(5-$in{Amount})));
SELECT RaceLink,Title,FirstName,LastName,Amount,Color,MapFill,CandidateID,Winner,Winner2 FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Office='Governor' AND Type='General Election' AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND
ContainerID=ParentContainer AND CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount,PollEnd LIMIT 50;OUTPUT
$mogtmp='cp '.$in{BIDIR}.'/ustemp.gif '.$in{BIDIR}.'/ugovmap.gif'; $res=`$mogtmp`; $mogtmp='mogrify'.$in{MakeMap}.' '.$in{BIDIR}.'/ugovmap.gif'; $res=`$mogtmp`;
|
| HOUSE |
>
|
|
Slight Lean Strong Safe |
SELECT RaceLink,Title,FirstName,LastName,Amount,Color,MapFill,CandidateID,Winner,Winner2 FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Office='House of Representatives' AND Type='General Election' AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND
ContainerID=ParentContainer AND CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount,PollEnd LIMIT 20;OUTPUT
|
| PRIMARIES |
>
|
|
Slight Lean Strong Safe |
SELECT RaceLink,Title,Office,CandidateID,FirstName,LastName,Amount,Winner,Winner2,Color FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Type='Primary Election' AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND ContainerID=ParentContainer AND
CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount,PollEnd LIMIT 20;OUTPUT
|
| OTHER |
>
|
X |
Slight Lean Strong Safe |
SELECT RaceLink,Title,Office,PollEnd,CandidateID,FirstName,LastName,Amount,Winner,Winner2,Color FROM Leaning as l,Race,Container,Candidate,Party WHERE
UserLink= AND l.EndDate='0000-00-00 00:00:00' AND RaceID=RaceLink AND Type!='Primary Election' AND Office!='House of Representatives' AND Office!='Governor' AND Office!='Senate' AND Office!='President'
AND TO_DAYS(PollEnd)+60 > TO_DAYS(Now()) AND ContainerID=ParentContainer AND
CandidateID=CandidateLink AND PartyID=PartyLink ORDER BY Amount,PollEnd LIMIT 20;OUTPUT
|