eq || $in{Security_UserOther} ne '0E0'>
SELECT SecLink FROM Security WHERE SecLink=1 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=5 AND UserLink=;OUTPUT NIL SELECT SecLink FROM Security WHERE SecLink=78 AND UserLink=;OUTPUT NIL print 'hi'.$ENV{'REQUEST_URI'}; DELETE FROM Session WHERE UserID=;FINISH User Sessions Deleted.
INSERT INTO EditLog (EditorLink,EditType,EditLink,EditDate) VALUES (,'User',,Now());FINISH $in{Nym}=~s/^\s+//; $in{Nym}=~s/\s+$//; if ($in{Nym} eq '') { $in{Nym}=$in{UserID}.' Name Removed'; } SELECT Nym OldNym from User WHERE UserID=;OUTPUT NIL INSERT INTO UserNameArchive (UserLink,OldNym,ChangeDate) VALUES (,,);FINISH UPDATE User SET eq || $in{Session_UserID} == 1>Username=,EPWord=PASSWORD(),FirstName=,LastName=,Email=,City=, StateLink=,Zip=,CountryLink=,Timezone=,BirthDate=,PreviousOn=,Nym=,NoChatInvite=,FNumDate=,FDecimal=,FThouSep=, AdminNotes=,Privacy=,LastModify=,Bio=,IsHTML=,ViewSilly=,EOverview= WHERE UserID=;OUTPUT NIL - Saved Changes
DELETE FROM TagAttach WHERE ParentType='User' AND ParentID=;FINISH INSERT INTO TagAttach (ParentType,ParentID,TagLink) VALUES ('User',,);FINISH SELECT TagID FROM Tag;OUTPUT SetTag INSERT INTO Tag (Category,TagName) VALUES (,);FINISH DELETE FROM Security WHERE UserLink=;FINISH ,SQL> eq 'Y'>INSERT INTO Security (UserLink,SecLink) VALUES (,);FINISH eq 'Y'>UPDATE User SET Photo='' WHERE UserID=;OUTPUT NIL /users/Full,FILE_DATA> /users/,FILE_DATA> $res=`mogrify -geometry 100X100! $in{BIDIR}/users/$in{Photo}`; $res=`mogrify -unsharp 1X1000 $in{BIDIR}/users/$in{Photo}`; UPDATE User SET Photo=,PicLoad=PicLoad+1 WHERE UserID=;OUTPUT NIL ne '' && $in{NewIgnore}!=1> SELECT UserID TUID FROM User WHERE UserID=;OUTPUT NIL DELETE FROM IgnoreUser WHERE ParentUser= AND IgnoreUser=;FINISH INSERT INTO IgnoreUser (ParentUser,IgnoreUser) VALUES (,);FINISHAdded User Ignore.
ne '' && $in{Session_Access} > 800> DELETE FROM TagAttach WHERE TagLink=;FINISH DELETE FROM Tag WHERE TagID=;FINISH ne ''> DELETE FROM IgnoreUser WHERE ParentUser= AND IgnoreUser=;FINISH UPDATE User SET PartyLink= WHERE UserID=;FINISH SELECT * FROM User WHERE UserID=;OUTPUT NIL SELECT Name PName FROM Party WHERE PartyID=;OUTPUT NIL
eq || $in{Session_UserID} == 1> SELECT Category FStCat FROM Container WHERE ParentLink= AND (Category='State' OR Category='Territory' OR Category='Administrative Region' OR Category='Member States' OR Category='Province' OR Category='Regions' OR Category='Country' OR Category='Territory/ Commonwealth') AND Silly='' AND StartDate < Now() AND (EndDate='0000-00-00 00:00:00' OR EndDate > Now()) ORDER BY Category LIMIT 1;OUTPUT NIL ='Y'>SELECT SecLink FROM Security WHERE UserLink=;OUTPUT
EDIT ACCOUNT
Email Address
Password
Screen Name
First Name
Last Name
City
Zip
Country
Time Zone
Short Date Format
Decimal
Thousands
Member Visible Email
Affiliation [Change]
Birthday
Previous Login>
Info
Is HTML? eq 'Y'> CHECKED> - Check if the Info box contains HTML.
Photo (jpg) ne ''>Delete
Privacy eq 'Y'> CHECKED> - Check this box if you do not want
this info to appear on the website.
No Chat Invites CHECKED> - Check this box if you do not want
to receive chat invites.
View Silly eq 'Y'> CHECKED> - Check this box if you want to see the sillier parts of the site
- humor, fake races, etc.
View Election Overview checked="checked"> - Check this box if you want to see the (currently incomplete) Election 2012 Overview on the home page
Admin Notes

Access





[Force Logout]
Function Post Move Delete Others
Discussion eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Votes eq 'Y'> CHECKED>      
Key Race Level eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Leaning Predictions eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
% Predictions eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Endorsements eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
News eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Issues eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Parties eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Candidates eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Approval Polls eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Polling Firms eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Media eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Info Links eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Books eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
XXXXXXXX eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Containers eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Maps eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Party Registration eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Races eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Race Candidates eq 'Y'> CHECKED>   eq 'Y'> CHECKED>  
Finances eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Polls eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Users eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Tags eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>
Blog eq 'Y'> CHECKED>   eq 'Y'> CHECKED> eq 'Y'> CHECKED>

Return To View User
SELECT SecLink FROM Security WHERE SecLink=82 AND UserLink=;OUTPUT NIL SELECT UserBlogID,BlogName FROM UserBlog WHERE UserLink=;OUTPUT INSERT INTO UserBlog (UserLink,BlogName) VALUES (,);FINISHSELECT UserBlogID,BlogName FROM UserBlog WHERE UserLink=;OUTPUT
YOUR BLOG(s)
Add: Name:

SELECT IgnoreUser,Nym INym FROM IgnoreUser,User WHERE ParentUser= AND UserID=IgnoreUser ORDER BY Nym;OUTPUT Ignores
IGNORE LIST
[X]
New Ignore User #

SELECT SecLink FROM Security WHERE SecLink=80 AND UserLink=;OUTPUT NIL SELECT COUNT(*) HasTag FROM TagAttach WHERE TagLink= AND ParentType='User' AND ParentID=;OUTPUT NILSELECT * FROM Tag ORDER BY Category,TagName;OUTPUT ListTags
TAGS
CHECKED> [X]
Add New
Use Sparingly!
CAT
TAG

SELECT DiscussionGroupID,GroupName FROM DiscussionGroup WHERE JoinCode=;OUTPUT NIL There is no group with that code. DELETE FROM GroupMember WHERE GroupLink= AND UserLink=;OUTPUT NIL INSERT INTO GroupMember (GroupLink,UserLink,Access) VALUES (,,200);OUTPUT NIL UPDATE User SET GroupLink= WHERE UserID=;OUTPUT NIL> You have joined discussion group .
SELECT DiscussionGroupID,GroupName FROM GroupMember,DiscussionGroup WHERE UserLink= AND DiscussionGroupID=GroupLink ORDER BY GroupName;OUTPUT
GROUPS
Public AreaCurrent Switch To
Current Switch To
Join Code#