[SQL]
Insert=INSERT INTO example (field1,field2,field3) VALUES (?,?,?)
CountAll=SELECT count(*) FROM example
CountByNum=SELECT count(*) AS count FROM example WHERE field2=?
SelectAll=SELECT * FROM example
SelectByID=SELECT field3 FROM example WHERE id=?
# IP Address
FindIPAddress=SELECT * FROM ipindex WHERE ipaddr=?
AddIPAddress=INSERT INTO ipindex (author,type,ipaddr) VALUES (?,?,?)
SaveIPAddress=UPDATE ipindex SET author=?,type=? WHERE ipaddr=?
# Groups
AllGroups=SELECT * FROM groups $where ORDER BY groupname
GetGroupID=SELECT groupid FROM groups WHERE groupname=?
AllGroupIndex=SELECT * FROM ixusergroup
#Metadata
MetaCloudImage=SELECT count(x.tag) as count, x.tag as metadata \
FROM imetadata AS x \
INNER JOIN images AS i ON i.imageid=x.imageid \
GROUP BY metadata;
MetaSearchImage=SELECT DISTINCT(i.imageid) AS id,i.* \
FROM images AS i \
INNER JOIN imetadata AS m ON i.imageid=m.imageid \
WHERE m.tag IN ($meta) $where $limit
MetaDetailImage=SELECT DISTINCT(i.imageid) AS id,i.* \
FROM images AS i \
INNER JOIN imetadata AS x ON i.imageid=x.imageid \
WHERE (i.tag REGEXP '$data' OR i.href REGEXP '$data' OR x.tag IN ($meta)) $where $limit
MetaUpdateImage=INSERT INTO imetadata (imageid,tag) VALUES (?,?)
MetaDeleteImage=DELETE FROM imetadata WHERE imageid=?
MetaGetImage=SELECT * FROM imetadata WHERE imageid=?
# Requests
GetRequest=SELECT * FROM requests WHERE section=? AND command=?
#Users
AllUsers=SELECT * FROM users $search
GetUserByID=SELECT u.*,i.link,i.tag \
FROM users AS u \
INNER JOIN images AS i ON u.imageid=i.imageid \
WHERE u.userid=?
GetUserByName=SELECT u.*,i.link,i.tag \
FROM users AS u \
INNER JOIN images AS i ON u.imageid=i.imageid \
WHERE u.realname=?