view release on metacpan or  search on metacpan

vhost/cgi-bin/config/phrasebook.ini  view on Meta::CPAN

    WHERE i.photoid < ? $where  \
    ORDER BY i.photoid DESC LIMIT 9
MetaGalleryMin=SELECT i.photoid FROM photos AS i \
    INNER JOIN imetadata AS m ON i.photoid=m.imageid \
    WHERE i.photoid < ? $where  \
    ORDER BY i.photoid DESC LIMIT 9

AllUsers=SELECT * FROM users
NewUser=INSERT INTO users (password,accessid,search,nickname,realname,email,imageid,realm) \
    VALUES (SHA1(?),?,?,?,?,?,?,?)
SaveUser=UPDATE users SET nickname=?,realname=?,email=?,imageid=?,realm=? WHERE userid=?
DeleteUser=DELETE FROM users WHERE userid IN ($ids)
ValidUser=SELECT * FROM users WHERE userid=? AND password=SHA1(?)
ChangePassword=UPDATE users SET password=SHA1(?) WHERE userid=?
BanUser=UPDATE users SET password=? WHERE userid in ($ids)
FindUser=SELECT userid,password,realname FROM users WHERE email = ?

# Groups
AllGroups=SELECT * FROM groups $where ORDER BY groupname
GroupCount=SELECT COUNT(linkid) AS count FROM ixusergroup WHERE groupid = ? AND type=1 GROUP BY groupid
GetGroup=SELECT * FROM groups WHERE groupid=?
LinkUsers=SELECT i.*,u.email,u.nickname,u.realname FROM ixusergroup AS i \
    INNER JOIN users AS u ON i.linkid=u.userid \
    WHERE i.type=1 AND i.groupid=? \
    ORDER BY u.realname
LinkedUsers=SELECT i.*,g.groupname,g.member FROM ixusergroup AS i \
    INNER JOIN groups AS g ON i.groupid=g.groupid \
    WHERE i.type=1 AND i.linkid=?
LinkGroups=SELECT i.*,g.groupname FROM ixusergroup AS i \
    INNER JOIN groups AS g ON i.linkid=g.groupid \
    WHERE i.type=2 AND i.groupid=?
AllGroupIndex=SELECT * FROM ixusergroup WHERE type=2
AddGroup=INSERT INTO groups (groupname,master) VALUES (?,0)
AddLinkIndex=INSERT INTO ixusergroup (type,linkid,groupid) VALUES (?,?,?)
SaveGroup=UPDATE groups SET groupname=? WHERE groupid=?
DeleteGroup=DELETE FROM groups WHERE groupid=?
DeleteGroupIndex=DELETE FROM ixusergroup WHERE groupid=?
DeleteLinkIndices=DELETE FROM ixusergroup WHERE linkid=? AND i.type=?
DeleteLinkIndex=DELETE FROM ixusergroup \
    WHERE type=? AND linkid=? AND groupid=?
GetGroupID=SELECT groupid FROM groups WHERE groupname=?
UserGroups=SELECT i.*,g.groupname FROM ixusergroup AS i \
    INNER JOIN groups AS g ON i.groupid=g.groupid \
    WHERE type=1 AND linkid=?

FindIPAddress=SELECT * FROM ipindex WHERE ipaddr=?
AddIPAddress=INSERT INTO ipindex (author,type,ipaddr) VALUES (?,?,?)
SaveIPAddress=UPDATE ipindex SET author=?,type=? WHERE ipaddr=?

GetTesterAddress=SELECT * FROM ixtester WHERE userid=? AND confirmed=1
FindTesterIndex=SELECT * FROM ixtester WHERE email=?
ConfirmedEmail=INSERT INTO ixtester (userid,email,confirm,confirmed) VALUES (?,?,'',1)
RemoveEmail=DELETE FROM ixtester WHERE userid=? AND email IN ($mails)
UnConfirmedEmail=INSERT INTO ixtester (userid,email,confirm,confirmed) VALUES (?,?,?,0)

ListAllMarkedReports=SELECT * FROM ixmarked
ListMarkedReports=SELECT * FROM ixmarked WHERE email IN ($addrs)
MarkReport=INSERT INTO ixmarked (id,email,cpanid,markdate) VALUES (?,?,?,?)
UnMarkReports=DELETE FROM ixmarked WHERE id IN (ids)

GetAuthorDefault=SELECT * FROM prefs_authors AS a \
	INNER JOIN prefs_distributions AS d ON d.pauseid=a.pauseid \
	WHERE a.pauseid=? AND d.distribution='-'  
GetAuthorDistros=SELECT * FROM prefs_distributions WHERE pauseid=? AND distribution!='-'
GetAuthorDistro=SELECT  * FROM prefs_distributions WHERE pauseid=? AND distribution=?
SetAuthorIgnore=UPDATE prefs_distributions SET ignored=? WHERE pauseid=? AND distribution IN ($dists)
UpdateAuthorLogin=UPDATE prefs_authors SET lastlogin=? WHERE pauseid=? 
UpdateAuthorActive=UPDATE prefs_authors SET active=? WHERE pauseid=? 
UpdateDistroPrefs=UPDATE prefs_distributions SET ignored=?,report=?,grade=?,tuple=?,version=?,patches=?,perl=?,platform=? WHERE pauseid=? AND distribution=?
InsertDistroPrefs=INSERT INTO prefs_distributions (ignored,report,grade,tuple,version,patches,perl,platform,pauseid,distribution) VALUES (?,?,?,?,?,?,?,?,?,?)
DeleteDistroPrefs=DELETE FROM prefs_distributions WHERE pauseid=? AND distribution=?

#[CPANSTATS]
GetAuthorDists=SELECT DISTINCT(dist) FROM cpanstats.uploads WHERE author=? AND type != 'backpan'
GetAuthorDistVersions=SELECT version FROM cpanstats.uploads WHERE author=? AND dist=? ORDER BY released
GetPerlVersions=SELECT DISTINCT(perl) FROM cpanstats.perl_version
AllOSNames=SELECT * FROM cpanstats.osname ORDER BY ostitle