>> SELECT FirstName FN,LastName LN FROM Candidate WHERE CandidateID=;OUTPUT NIL
  , - Edit
 SELECT Title RaceTitle,PollEnd RaceEnd,DATE_FORMAT(PollEnd,'%b %e, %Y') FRaceEnd,FileDeadline FROM Race WHERE RaceID=;OUTPUT NIL
  , - Candidate Attachment

SELECT SecLink FROM Security WHERE SecLink=62 AND UserLink=;OUTPUT NIL ne ''> ne ''> SELECT ContainerID TCID,ParentLink PTC,CategoryLink PCCT,EquivalentTo PCCEq,Name PCTName FROM Container as c JOIN ContainerCategory as cc ON ContainerCategoryID=CategoryLink WHERE ContainerID=;OUTPUT NIL SELECT ParentContainer PTC,PartyLimit PLimit FROM Race WHERE RaceID=;OUTPUT NIL SELECT StateLink CState,CountryLink FROM Candidate WHERE CandidateID=;OUTPUT NIL >SELECT CAbbr StateAbbr FROM Container WHERE ContainerID=;OUTPUT NIL ne '' && $in{ReplaceCan} eq ''> ne '' && $in{ReplaceCan} ne ''> ne ''> ne ''> SELECT CandidateID,c.FirstName,c.LastName,BirthDate,DeathDate,City,County,StateLink,Country,PartyID,Abbr,Color FROM Candidate as c LEFT JOIN Party as p ON PartyID=PartyLink WHERE CandidateID= AND ORDER BY LastName,FirstName; SELECT CandidateID,c.FirstName,c.LastName,BirthDate,DeathDate,City,County,StateLink,Country,PartyID,Abbr,Color,cnc.FirstName PFN,cnc.LastName PLN FROM Candidate as c LEFT JOIN Party as p ON PartyID=PartyLink LEFT JOIN CandidateNameChange as cnc ON cnc.CandidateLink=c.CandidateID WHERE c.CountryLink IN () AND StateLink= AND (c.LastName LIKE OR cnc.LastName LIKE ) AND (c.FirstName LIKE OR cnc.FirstName LIKE ) AND PartyID=PartyLink ORDER BY PartyID!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName,c.FirstName;OUTPUT SELECT CandidateID,c.FirstName,c.LastName,BirthDate,DeathDate,City,County,StateLink,Country,PartyID,Abbr,Color,cnc.FirstName PFN,cnc.LastName PLN FROM Candidate as c LEFT JOIN Party as p ON PartyID=PartyLink LEFT JOIN CandidateNameChange as cnc ON cnc.CandidateLink=c.CandidateID WHERE c.CountryLink IN () AND StateLink!= AND (c.LastName LIKE OR cnc.LastName LIKE ) AND (c.FirstName LIKE OR cnc.FirstName LIKE ) AND PartyID=PartyLink ORDER BY PartyID!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName,c.FirstName; OUTPUT SELECT CandidateID,c.FirstName,c.LastName,BirthDate,DeathDate,City,County,StateLink,Country,PartyID,Abbr,Color,cnc.FirstName PFN,cnc.LastName PLN FROM Candidate as c LEFT JOIN Party as p ON PartyID=PartyLink LEFT JOIN CandidateNameChange as cnc ON cnc.CandidateLink=c.CandidateID WHERE c.CountryLink NOT IN () AND (StateLink!= OR StateLink=0) AND (c.LastName LIKE OR cnc.LastName LIKE ) AND (c.FirstName LIKE OR cnc.FirstName LIKE ) AND PartyID=PartyLink ORDER BY PartyID!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName!=,c.LastName,c.FirstName; OUTPUT
SELECT ONE OF THESE
PtyNameLocationBorn/DiedView
-- Other Parties --
  ( ) ( ) ( ) ( ) eq '0000-00-00 00:00:00'>Unknown ne '0000-00-00 00:00:00'>> , eq '0000-00-00 00:00:00'>- ne '0000-00-00 00:00:00'>-> , ne '0000-00-00 00:00:00'>> != 0>>-> ( years) [View]
No Candidate Matches In-State
ne ''>View Out of State ne ''>View Out of State ne ''>View Out of State
-- Out of State --
No Candidate Matches Out of State, In Country
ne ''>View Out of Country ne ''>View Out of Country ne ''>View Out of Country
-- Out of Country --
No Candidate Matches Out of Country
OR ENTER A NEW CANDIDATE
eq '0E0'>OUTPUT NIL UPDATE Candidate SET FirstName=,LastName=,Address1=,Address2=, Phone=,Email=,City=,County=,StateLink=,Zip=,CountryLink=, Longitude=,Latitude=,BirthDate=,DeathDate=,Bio=,BioSource=,IsHTML=, Silly=,Website=,DonateURL=,Twitter=,Facebook=,LastModify=, LMBy=,Gender=,Race=,Religion=,CanType=,PartyLink= WHERE CandidateID=;OUTPUT NIL - Saved Changes
DELETE FROM MetaData WHERE MetaDataID=;FINISH UPDATE MetaData SET DataValue=,SQL> WHERE MetaDataID=;FINISH SELECT * FROM MetaData WHERE AttachTo='Candidate' AND AttachLink= ORDER BY Priority DESC,DataName;OUTPUT INSERT INTO Candidate (PartyLink,FirstName,LastName,Address1,Address2,Phone,Email,City,County,StateLink,Zip,CountryLink,Longitude,Latitude,BirthDate,DeathDate,Bio,BioSource,IsHTML,Silly,Website,DonateURL,Twitter,Facebook, LastModify,FirstBy,FirstEnter,LMBy,Gender,Race,Religion,CanType) VALUES (,,,,,,,,, ,,,,,,,,,,,, ,,,,,,,,,,);OUTPUT NIL - Saved New Candidate
 =$in{'NNMT'.$in{NewMeta}}> INSERT INTO MetaData (AttachTo,AttachLink,DataName,DataValue) VALUES ('Candidate',,,SQL>,,SQL>);FINISH UPDATE CandidateNameChange SET StartDate=,SQL>,EndDate=,SQL>,FirstName=,SQL>,LastName=,SQL> WHERE CandidateNameChangeID=;FINISH SELECT CandidateNameChangeID PCNCID FROM CandidateNameChange WHERE CandidateLink= ORDER BY EndDate DESC,StartDate DESC;OUTPUT INSERT INTO CandidateNameChange (CandidateLink,StartDate,EndDate,FirstName,LastName) VALUES (,,,,);FINISH DELETE FROM TagAttach WHERE ParentType='Candidate' AND ParentID=;FINISH INSERT INTO TagAttach (ParentType,ParentID,TagLink) VALUES ('Candidate',,);FINISH SELECT TagID FROM Tag;OUTPUT SetTag INSERT INTO Tag (Category,TagName) VALUES (,);FINISH SELECT COUNT(*) RMCnt FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL eq '0'> SELECT PartyLink FROM Candidate WHERE CandidateID=;OUTPUT NIL INSERT INTO RaceMember (RaceLink,CandidateLink,PartyLink,EntryDate) VALUES (,,,);OUTPUT NIL UPDATE Race SET LMBy=,LastModified= WHERE RaceID=;OUTPUT NIL ne '' && $in{ReplaceCan} ne ''> SELECT COUNT(*) RMCnt FROM RaceMember WHERE RaceLink= AND CandidateLink=;OUTPUT NIL eq '0'> UPDATE RaceMember SET CandidateLink= WHERE RaceLink= AND CandidateLink=;OUTPUT NIL UPDATE Leaning SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE Prediction SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE Endorsement SET CandidateLink= WHERE CandidateLink= AND RaceLink=;OUTPUT NIL UPDATE PollResult SET AttachID= WHERE ParentPoll= AND AttachTo='Candidate' AND AttachID=;OUTPUT NIL SELECT PollID TPLID FROM Poll WHERE AttachTo='Race' AND AttachID=;OUTPUT RepEachPoll UPDATE Race SET LMBy=,LastModified= WHERE RaceID=;OUTPUT NIL UPDATE Candidate SET Photo='' WHERE CandidateID=;OUTPUT NIL UPDATE CandidatePic SET PicDate=Date,SQL> WHERE CandidatePicID=;FINISH $res=`mv $in{BIDIR}/candidates/b$in{CPhotoBlock}/C$in{CandidateID}D$in{PicDate}.jpg $in{BIDIR}/candidates/b$in{CPhotoBlock}/C$in{CandidateID}D$in{$in{Date_VAR}}.jpg`; $res=`mv $in{BIDIR}/candidates/b$in{CPhotoBlock}/FullC$in{CandidateID}D$in{PicDate}.jpg $in{BIDIR}/candidates/b$in{CPhotoBlock}/FullC$in{CandidateID}D$in{$in{Date_VAR}}.jpg`; DELETE FROM CandidatePic WHERE CandidatePicID=;FINISH unlink $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}; unlink $in{BIDIR}/candidates/b$in{CPhotoBlock}/Full$in{TPhoto}; SELECT CandidatePicID CPID,PicDate FROM CandidatePic WHERE CandidateLink=;OUTPUT CkDelPhoto INSERT INTO CandidatePic (CandidateLink,PicDate) VALUES (,);FINISH SELECT Photo FROM Candidate WHERE CandidateID=;OUTPUT NIL $res=`mkdir $in{BIDIR}/candidates/b$in{CPhotoBlock}`; $res=`chmod 0777 $in{BIDIR}/candidates/b$in{CPhotoBlock}`; $res=`mv $in{BIDIR}/candidates/$in{Photo} $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}`; $res=`mv $in{BIDIR}/candidates/Full$in{Photo} $in{BIDIR}/candidates/b$in{CPhotoBlock}/Full$in{TPhoto}`; UPDATE Candidate SET Photo='' WHERE CandidateID=;FINISH INSERT INTO CandidatePic (CandidateLink,PicDate) VALUES (,);FINISH $res=`mkdir $in{BIDIR}/candidates/b$in{CPhotoBlock}`; $res=`chmod 0777 $in{BIDIR}/candidates/b$in{CPhotoBlock}`; /candidates/b/Full,FILE_DATA> /candidates/b/,FILE_DATA> $res=`mogrify -geometry 150X200 $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}`; $res=`mogrify -unsharp 1X1000 $in{BIDIR}/candidates/b$in{CPhotoBlock}/$in{TPhoto}`; UPDATE Candidate SET PartyLink= WHERE CandidateID=;FINISH eq ''> SELECT * FROM Candidate WHERE CandidateID=;OUTPUT NIL SELECT Name PName FROM Party WHERE PartyID=;OUTPUT NIL
ne ''> ne ''> ne ''> ne ''> SELECT * FROM MetaData WHERE AttachTo='Candidate' AND AttachLink= ORDER BY Priority DESC,DataName;OUTPUT
eq ''>ADD ne ''>EDIT CANDIDATE
LinkReturn to Race Member Edit
LinkReturn to Race Member Edit
LinkReturn to Endorsement Edit
LinkReturn to Family Member
Category
Affiliation [Other]
Gender checked="checked">Male checked="checked">Female checked="checked">Other checked="checked">Unknown
First Name
Last Name
Address 1
Address 2
City
County
State
Zip
Country
Lon/Lat
Phone
Email
Website
Donate Link
X (Twitter)
Facebook
[+meta]    Race
Religion
Birth Date
Death Date
Bio
Bio Source/ Approval to Use
Is HTML? eq 'Y'> CHECKED> - Check if the Info box contains HTML.
Silly? eq 'Y'> CHECKED> - Check if this person is not a serious political candidate.
Prior Names =$in{P_StartDate}>-=$in{P_EndDate}>
F L
 SELECT * FROM CandidateNameChange WHERE CandidateLink= ORDER BY EndDate DESC,StartDate DESC;OUTPUT
Photos (jpg) Delete
 Date=$in{PicDate}>Delete
 SELECT CandidatePicID CPID,PicDate FROM CandidatePic WHERE CandidateLink= ORDER BY PicDate DESC;OUTPUT EachPhoto
Please note that I prefer close-up facial photos.
Please insure photo copyrights allow our use.
Do Not use photos from large news sites
ne ''>
Return To View Candidate
TAGS
SELECT TagID,Category,TagName,a.TagLink HasTag FROM Tag as t LEFT JOIN TagAttach as a ON TagLink=TagID AND ParentType='Candidate' AND ParentID= ORDER BY Category,HasTag IS NULL,TagName;OUTPUT ListTags
CHECKED>
Add New
Warning - Use Sparingly!
CAT
TAG
DELETE FROM FamilyConnect WHERE FamilyConnectID=;FINISH DELETE FROM FamilyConnect WHERE SourceLink= AND TargetLink= AND Type=;FINISH INSERT INTO FamilyConnect (SourceLink,TargetLink,Type,LMBy,LastModify) VALUES (,,,,);FINISH INSERT INTO FamilyConnect (SourceLink,TargetLink,Type,LMBy,LastModify) VALUES (,,'S',,);FINISH Start=$in{FStartDate}>End=$in{FEndDate}> UPDATE FamilyConnect SET StartDate=Start,SQL>,EndDate=End,SQL>,LMBy=,LastModify= WHERE FamilyConnectID=;FINISH SELECT CandidateID,FirstName,LastName,FamilyConnectID,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE TargetLink= AND Type='S' AND CandidateID=SourceLink ORDER BY Type,StartDate,EndDate;OUTPUT SELECT CandidateID,FirstName,LastName,FamilyConnectID,Type,StartDate,EndDate FROM FamilyConnect,Candidate WHERE SourceLink= AND CandidateID=TargetLink ORDER BY Type,StartDate,EndDate;OUTPUT
FAMILY
,Safe>
- [X]
Add
Last Name


eq 'SaveIt'> if (open(FILE, "$in{BFDIR}/CandidateMakePage.html")) { undef $/; $zz=; $/="\n"; close FILE; $zz=&ParseIt($zz); $zz=~s/\$in{BFDIR}/Candidate/".$in{CandidateID}.".html")) { print FILE $zz; close FILE; } }