List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| "SELECT applicationName,applicationDesc,applicationToken FROM configurations WHERE con_id='1'" | 1 |
|
| "SELECT com_id FROM comments" | 1 |
|
| "INSERT INTO `comments` (comment, uid_fk,msg_id_fk,ip,created,uploads) VALUES (:comment, :uid,:msgid, :ip,:time,:upload)" | 1 |
|
| "UPDATE messages SET comment_count=comment_count+1 WHERE msg_id=:msgid" | 1 |
|
| "SELECT C.com_id, C.uid_fk, C.comment, C.msg_id_fk, C.created,C.uploads, U.username,U.name,U.profile_pic FROM comments C, users U WHERE C.uid_fk=U.uid and C.uid_fk=:uid and C.msg_id_fk=:msgid ORDER BY C.com_id DESC LIMIT 1 " | 1 |
|
| "SELECT M.uid_fk,C.uploads FROM comments C, messages M WHERE C.msg_id_fk = M.msg_id AND C.com_id=:com_id" | 1 |
|
| "DELETE FROM `comments` WHERE com_id=:com_id" | 1 |
|
| "DELETE FROM `comments` WHERE uid_fk=:uid and com_id=:com_id" | 1 |
|
| "SELECT image_path FROM user_uploads WHERE id=:uploadID" | 1 |
|
| "DELETE FROM user_uploads WHERE id=:uploadID AND uid_fk=:uid" | 1 |
|
| "SELECT admin_id FROM admin WHERE (admin_username=:username or admin_email=:username) and admin_password=:md5_password" | 1 |
|
| "UPDATE admin SET admin_password=:newPassword WHERE admin_id=:session_admin_uid" | 1 |
|
| "SELECT * FROM configurations WHERE con_id='1' " | 1 |
|
| "SELECT * FROM language_labels" | 1 |
|
| "SELECT uid FROM users" | 1 |
|
| "SELECT msg_id FROM messages" | 1 |
|
| "SELECT group_id FROM groups" | 1 |
|
| "SELECT com_id,comment FROM `comments` WHERE uid_fk=:uid and msg_id_fk=:msgid ORDER BY com_id DESC LIMIT 1" | 1 |
|
| "UPDATE language_labels SET socialTitle=:socialTitle,socialFacebook=:socialFacebook, socialTwitter=:socialTwitter,socialGoogle=:socialGoogle,socialInstagram=:socialInstagram WHERE labelID='1'" | 1 |
|
| "SELECT c_id FROM conversation" | 1 |
|
| "SELECT uid FROM users where status='1'" | 1 |
|
| "UPDATE language_labels SET msgDeleteConversation=:msgDeleteConversation,msgConversation=:msgConversation, msgStartConversation=:msgStartConversation,msgNoUpdates=:msgNoUpdates,msgNoMoreUpdates=:msgNoMoreUpdates,
msgNoFriends=:msgNoFriends,msgNoMoreFriends=:msgNoMoreFriends, msgNoFollowers=:msgNoFollowers,msgNoMoreFollowers=:msgNoMoreFollowers, msgNoPhotos=:msgNoPhotos,msgNoMorePhotos=:msgNoMorePhotos,msgNoViews=:msgNoViews,msgNoMoreViews=:msgNoMoreViews,msgNoGroups=:msgNoGroups,msgNoMoreGroups=:msgNoMoreGroups,msgNoMembers=:msgNoMembers,msgNoMoreMembers=:msgNoMoreMembers,msgNoConversations=:msgNoConversations WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET notiFollowingYou=:notiFollowingYou,notiLiked=:notiLiked, notiShared=:notiShared,
notiStatus=:notiStatus,notiIsFollowingGroup=:notiIsFollowingGroup,notiCommented=:notiCommented WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET placeSearch=:placeSearch,placeComment=:placeComment, placeUpdate=:placeUpdate,
placeEmailUsername=:placeEmailUsername,placePassword=:placePassword,placeEmail=:placeEmail,placeUsername=:placeUsername,placeSendMessage=:placeSendMessage WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET loginTitle=:loginTitle,emailUsername=:emailUsername, password=:password,forgotPassword=:forgotPassword,registrationTitle=:registrationTitle,
email=:email,username=:username, agreeMessage=:agreeMessage,resetPassword=:resetPassword,thankYou=:thankYou,thankYouMessage=:thankYouMessage,terms=:terms WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET settingsTitle=:settingsTitle, settingsUsername=:settingsUsername,settingsEmail=:settingsEmail, settingsName=:settingsName,
settingsPassword=:settingsPassword, settingsChangePassword=:settingsChangePassword,settingsOldPassword=:settingsOldPassword, settingsNewPassword=:settingsNewPassword, settingsConfirmPassword=:settingsConfirmPassword, settingsGroup=:settingsGroup,settingsGender=:settingsGender, settingsAboutMe=:settingsAboutMe,settingsEmailAlerts=:settingsEmailAlerts WHERE labelID='1'" | 1 |
|
| "UPDATE configurations SET language_labels=:live WHERE con_id='1'" | 1 |
|
| "UPDATE language_labels SET buttonUpdate=:buttonUpdate,buttonComment=:buttonComment,buttonFollow=:buttonFollow,
buttonFollowing=:buttonFollowing,buttonMessage=:buttonMessage,buttonJoinGroup=:buttonJoinGroup, buttonEditGroup=:buttonEditGroup,buttonUnfollowGroup=:buttonUnfollowGroup,buttonSaveSettings=:buttonSaveSettings, buttonSocialSave=:buttonSocialSave,buttonLogin=:buttonLogin,buttonSignUp=:buttonSignUp, buttonForgotButton=:buttonForgotButton,buttonSetNewPassword=:buttonSetNewPassword,buttonFacebook=:buttonFacebook, buttonMicrosoft=:buttonMicrosoft,buttonGoogle=:buttonGoogle,buttonLinkedin=:buttonLinkedin,buttonYou=:buttonYou WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET
feedLike=:feedLike,feedUnLike=:feedUnLike,feedLikeThis=:feedLikeThis, feedShare=:feedShare,feedUnshare=:feedUnshare,feedComment=:feedComment, feedDeleteUpdate=:feedDeleteUpdate,feedShareThis=:feedShareThis,feedPosted=:feedPosted WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET yourPhotos=:yourPhotos, photosOfYours=:photosOfYours WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET boxName=:boxName, boxUpdates=:boxUpdates,boxWebcam=:boxWebcam,boxLocation=:boxLocation WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET topMenuHome=:topMenuHome, topMenuMessages=:topMenuMessages,
topMenuNotifications=:topMenuNotifications,topMenuSeeAll=:topMenuSeeAll, topMenuSettings=:topMenuSettings,topMenuLogout=:topMenuLogout,topMenuLogin=:topMenuLogin,topMenuJoin=:topMenuJoin WHERE labelID='1'" | 1 |
|
| "UPDATE language_labels SET commonMembers=:commonMembers,commonViewAll=:commonViewAll,commonFriends=:commonFriends, commonGroups=:commonGroups,commonPhotos=:commonPhotos,commonCreateGroup=:commonCreateGroup,commonAbout=:commonAbout,commonRecentVisitors=:commonRecentVisitors,commonFollowers=:commonFollowers WHERE labelID='1'" | 1 |
|
| "SELECT C.uid_fk FROM comments C WHERE C.msg_id_fk=:msgid ORDER BY C.com_id DESC LIMIT 1 " | 1 |
|
| "SELECT M.group_id_fk,M.msg_id, M.uid_fk, M.message, M.created,M.uploads,M.like_count,M.comment_count,M.share_count, U.username,U.name,U.profile_pic FROM messages M, users U WHERE M.uid_fk=U.uid and M.uid_fk=:uid ORDER BY M.msg_id DESC LIMIT 1 " | 1 |
|
| "SELECT id FROM user_uploads WHERE image_type>'0'" | 1 |
|
| "SELECT DISTINCT M.msg_id,M.lat,M.lang, M.uid_fk,M.group_id_fk, M.message, M.created, U.username,U.name,U.profile_pic,M.uploads, '0' AS share_uid, '0' as share_ouid, '0' as like_uid,'0' as like_ouid FROM messages M, users U, friends F WHERE U.status='1' AND M.uid_fk=U.uid AND M.uid_fk = F.friend_two AND F.friend_one=:uid $morequery ORDER BY M.msg_id DESC LIMIT $perpage" | 1 |
|
| "SELECT id,image_path FROM user_uploads U WHERE id=:pid AND uid_fk=:uid" | 1 |
|
| "SELECT uploads,msg_id FROM messages WHERE uid_fk=:uid AND uploads!=0 AND uploads LIKE :searchID" | 1 |
|
| "UPDATE messages SET uploads=:newSet WHERE msg_id=:msgid and uid_fk=:uid" | 1 |
|
| "DELETE FROM user_uploads WHERE id=:pid AND uid_fk=:uid" | 1 |
|
| "UPDATE groups SET group_pic=:image WHERE group_id=:groupID AND uid_fk=:uid" | 1 |
|
| "SELECT group_id,group_pic FROM groups WHERE group_id=:groupID AND uid_fk=:uid" | 1 |
|
| "UPDATE users SET notification_created=:time WHERE uid=:uid" | 1 |
|
| "SELECT reactionType FROM message_like WHERE msg_id_fk=:msg_id" | 1 |
|
| "SELECT uid FROM messages M, users U WHERE M.uid_fk=U.uid and M.msg_id=:msgID AND U.status='1'" | 1 |
|
| "SELECT DISTINCT msg_id, lat,lang, uid_fk, message, created, like_count,comment_count,share_count, username,uploads, share_uid,share_ouid, like_uid, like_ouid FROM ( SELECT DISTINCT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, S.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, S.uid_fk as share_uid,S.ouid_fk as share_ouid,'0' AS like_uid, '0' as like_ouid FROM messages M, users U, message_share S WHERE M.uid_fk=U.uid AND U.status='1' AND S.msg_id_fk=M.msg_id AND S.uid_fk=:uid $morequery_share group by M.msg_id UNION ALL SELECT DISTINCT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, L.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' as share_uid,'0' as share_ouid, L.uid_fk as like_uid,L.ouid_fk as like_ouid FROM messages M, users U, message_like L WHERE M.uid_fk=U.uid AND U.status='1' AND L.msg_id_fk=M.msg_id AND L.uid_fk<>L.ouid_fk AND L.uid_fk=:uid $morequery_like group by M.msg_id UNION ALL SELECT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, M.created,M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid, '0' AS like_uid, '0' as like_ouid FROM messages M, users U WHERE U.status='1' AND M.uid_fk=U.uid AND M.uid_fk=:uid AND M.group_id_fk='0' $morequery group by M.msg_id)t GROUP BY msg_id ORDER BY created DESC LIMIT $perpage" | 1 |
|
| "SELECT M.msg_id, M.uid_fk, M.message, M.created,M.like_count,M.comment_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid FROM messages M, users U WHERE U.status='1' AND M.uid_fk=U.uid AND M.uid_fk=:uid AND M.group_id_fk='0' $morequery ORDER BY M.msg_id DESC LIMIT $perpage" | 1 |
|
| "SELECT DISTINCT msg_id, lat,lang, uid_fk, message, created, like_count,comment_count,share_count, username,uploads, share_uid,share_ouid, like_uid, like_ouid FROM ( SELECT DISTINCT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, S.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, S.uid_fk as share_uid,S.ouid_fk as share_ouid,'0' AS like_uid, '0' as like_ouid FROM messages M, users U, message_share S WHERE M.uid_fk=U.uid AND U.status='1' AND S.msg_id_fk=M.msg_id AND S.uid_fk=:uid $morequery_share group by msg_id UNION ALL SELECT DISTINCT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, L.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' as share_uid,'0' as share_ouid, L.uid_fk as like_uid,L.ouid_fk as like_ouid FROM messages M, users U, message_like L WHERE M.uid_fk=U.uid AND U.status='1' AND L.msg_id_fk=M.msg_id AND L.uid_fk<>L.ouid_fk AND L.uid_fk=:uid $morequery_like group by msg_id UNION ALL SELECT M.msg_id, M.lat,M.lang, M.uid_fk, M.message, M.created,M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid, '0' AS like_uid, '0' as like_ouid FROM messages M, users U WHERE U.status='1' AND M.uid_fk=U.uid AND M.uid_fk=:uid AND M.group_id_fk='0' $morequery group by msg_id)t GROUP BY msg_id ORDER BY created DESC LIMIT $perpage" | 1 |
|
| "SELECT M.msg_id, M.uid_fk, M.message, M.created,M.like_count,M.comment_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid FROM messages M, users U WHERE U.status='1' AND M.uid_fk=U.uid AND M.uid_fk=:uid AND M.group_id_fk='0' $morequery ORDER BY M.msg_id DESC LIMIT $perpage" | 1 |
|
| "SELECT DISTINCT msg_id, lat,lang,uid_fk,group_id_fk,message, created, like_count,comment_count,share_count, username,uploads, share_uid,share_ouid , like_uid,like_ouid FROM (SELECT DISTINCT M.msg_id,M.lat,M.lang, M.uid_fk,M.group_id_fk,M.message, S.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, S.uid_fk as share_uid,S.ouid_fk as share_ouid , '0' as like_uid,'0' as like_ouid FROM messages M, users U, friends F,message_share S WHERE F.friend_one=:uid AND U.uid = F.friend_one AND U.status='1' AND F.friend_two != S.ouid_fk AND S.uid_fk = F.friend_two AND M.uid_fk = S.ouid_fk AND F.role='fri' AND S.msg_id_fk = M.msg_id $morequery_share group by M.msg_id UNION ALL SELECT DISTINCT M.msg_id,M.lat,M.lang, M.uid_fk,M.group_id_fk,M.message, L.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads,'0' AS share_uid, '0' as share_ouid , L.uid_fk as like_uid,L.ouid_fk as like_ouid FROM messages M, users U, friends F,message_like L WHERE F.friend_one=:uid AND U.uid = F.friend_one AND U.status='1' AND F.friend_two != L.ouid_fk AND L.uid_fk = F.friend_two AND M.uid_fk = L.ouid_fk AND F.role='fri' AND L.uid_fk<>L.ouid_fk AND L.msg_id_fk = M.msg_id $morequery_like group by M.msg_id UNION ALL SELECT DISTINCT M.msg_id,M.lat,M.lang, M.uid_fk, M.group_id_fk, M.message, M.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid, '0' as like_uid,'0' as like_ouid FROM messages M, users U, friends F WHERE F.friend_one=:uid AND U.status='1' AND M.uid_fk=U.uid AND M.uid_fk = F.friend_two AND M.group_id_fk='0' $morequery group by M.msg_id UNION ALL SELECT DISTINCT M.msg_id, M.lat,M.lang,M.uid_fk, M.group_id_fk, M.message, M.created, M.like_count,M.comment_count,M.share_count, U.username,M.uploads, '0' AS share_uid, '0' as share_ouid, '0' as like_uid,'0' as like_ouid FROM messages M, users U, group_users G WHERE G.uid_fk=:uid AND U.status='1' AND M.group_id_fk = G.group_id_fk AND G.status='1' AND M.uid_fk=U.uid $morequery group by M.msg_id )t GROUP BY msg_id ORDER BY created DESC LIMIT $perpage" | 1 |
|
| "SELECT group_id FROM `groups` WHERE group_id = :group_id and uid_fk=:uid" | 1 |
|
| "UPDATE `groups` SET group_updates=group_count+1 WHERE group_id=:group_id" | 1 |
|
| "UPDATE users SET updates_count=updates_count-1 WHERE uid=:uid" | 1 |
|
| "INSERT INTO `messages` (message, uid_fk, ip,created,uploads,lat,lang,group_id_fk) VALUES (:feedUpdate, :uid, :ip,:time,:uploads,:lat,:lang,:group_id)" | 1 |
|
| "SELECT M.group_id_fk,M.msg_id, M.uid_fk, M.message, M.created,M.uploads,M.like_count,M.comment_count,M.share_count, U.username,U.name,U.profile_pic FROM messages M, users U WHERE M.uid_fk=U.uid and M.uid_fk=:uid ORDER BY M.msg_id DESC LIMIT 1" | 1 |
|
| "UPDATE `users` SET updates_count=updates_count+1 WHERE uid=:uid" | 1 |
|
| "INSERT INTO `messages` (message, uid_fk, ip,created,uploads,lat,lang) VALUES (:feedUpdate, :uid, :ip,:time,:uploads,:lat,:lang)" | 1 |
|
| "SELECT msg_id,message,created FROM `messages` WHERE uid_fk=:uid and group_id_fk=:group_id ORDER BY msg_id DESC LIMIT 1" | 1 |
|
| "SELECT msg_id,message,created FROM `messages` WHERE uid_fk=:uid ORDER BY msg_id DESC LIMIT 1" | 1 |
|
| "DELETE FROM messages WHERE msg_id = :msg_id" | 1 |
|
| "SELECT msg_id FROM `messages` WHERE msg_id = :msg_id and uid_fk=:uid" | 1 |
|
| "UPDATE users SET photos_count=photos_count-1 WHERE uid=:uid" | 1 |
|
| "DELETE FROM user_uploads WHERE id=:a" | 1 |
|
| "SELECT image_path FROM user_uploads WHERE id=:a" | 1 |
|
| "SELECT uploads FROM `messages` WHERE msg_id = :msg_id" | 1 |
|
| "DELETE FROM `comments` WHERE msg_id_fk = :msg_id" | 1 |
|
| "DELETE FROM `message_like` WHERE msg_id_fk = :msg_id" | 1 |
|
| "SELECT id FROM user_uploads WHERE image_type='0'" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='1' ORDER BY uid DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT id,image_path,uid_fk as uid,group_id_fk as group_id FROM user_uploads WHERE uid_fk=:uid AND group_id_fk='0' AND image_type='2' ORDER BY id DESC LIMIT $con" | 1 |
|
| "SELECT a_id,a_title,a_desc,a_url,a_img,status,ad_type,ad_code FROM advertisments ORDER BY a_id DESC" | 1 |
|
| "DELETE FROM comment_like WHERE com_id_fk=:com_id" | 1 |
|
| "DELETE FROM comments WHERE com_id=:com_id" | 1 |
|
| "DELETE FROM groups WHERE group_id=':group_id'" | 1 |
|
| "UPDATE groups SET status='1' WHERE group_id=:group_id" | 1 |
|
| "UPDATE groups SET status='0' WHERE group_id=:group_id" | 1 |
|
| "SELECT id,image_path FROM user_uploads U WHERE id=:pid" | 1 |
|
| "SELECT uploads,msg_id FROM messages WHERE uploads!=0 AND uploads LIKE :pid" | 1 |
|
| "UPDATE messages SET uploads=:newSet WHERE msg_id=:msgid" | 1 |
|
| "DELETE FROM user_uploads WHERE id=:pid" | 1 |
|
| "UPDATE template SET t_order=:t_id WHERE t_id=:t_order" | 1 |
|
| "INSERT INTO advertisments(a_title,a_desc,a_url,a_img)VALUES(:title,:desc1,:url,:image)" | 1 |
|
| "SELECT a_id,a_title,a_desc,a_url,a_img FROM advertisments ORDER BY a_id DESC LIMIT 1" | 1 |
|
| "INSERT INTO advertisments(a_title,ad_type,ad_code)VALUES(:title,'1',:code)" | 1 |
|
| "SELECT a_id,a_title,a_desc,a_code FROM advertisments ORDER BY a_id DESC LIMIT 1" | 1 |
|
| "DELETE FROM advertisments WHERE a_id=:aid" | 1 |
|
| "DELETE FROM comments WHERE msg_id_fk=:msg_id" | 1 |
|
| " UPDATE users SET first_name =:first_name WHERE uid=:uid " | 1 |
|
| " UPDATE users SET provider_id =:provider_id, provider =:provider WHERE uid=:uid " | 1 |
|
| " UPDATE users SET facebookProfile =:picture WHERE uid=:uid " | 1 |
|
| " UPDATE users SET birthday =:birthday WHERE uid=:uid " | 1 |
|
| " UPDATE users SET location =:location WHERE uid=:uid " | 1 |
|
| " UPDATE users SET gender =:gender WHERE uid=:uid " | 1 |
|
| " UPDATE users SET last_name =:last_name WHERE uid=:uid " | 1 |
|
| "SELECT uid FROM users WHERE email=:email " | 1 |
|
| "UPDATE configurations SET uploadImage=:final_uploadimage,bannerWidth=:banner,profileWidth=:profile,upload=:upload WHERE con_id='1'" | 1 |
|
| "INSERT INTO users (email, name, first_name, last_name, gender, birthday, location, hometown, bio, relationship, timezone, provider, provider_id,last_login,status,notification_created) VALUES (:email,:name,:first_name,:last_name,:gender,:birthday,:location,:hometown,:bio,:relationship,:timezone,:loginProvider,:provider_id,:created,:status,:notification_created)" | 1 |
|
| "SELECT uid,provider FROM users WHERE email=:email" | 1 |
|
| "SELECT language_labels,applicationName,applicationDesc,forgot,newsfeedPerPage,friendsPerPage,photosPerPage,groupsPerPage,notificationPerPage, uploadImage,bannerWidth, profileWidth,gravatar,friendsWidgetPerPage FROM configurations WHERE con_id='1'" | 1 |
|
| "SELECT * FROM users WHERE uid=:session_id" | 1 |
|
| "UPDATE configurations SET applicationName=:applicationName,applicationDesc=:applicationDesc,applicationToken=:applicationToken WHERE con_id='1'" | 1 |
|
| "UPDATE configurations SET newsfeedPerPage=:newsFeedPerPage,notificationPerPage=:notifications,friendsPerPage=:friends,photosPerPage=:photos,groupsPerPage=:groups,adminPerPage=:admin,friendsWidgetPerPage=:friendsWidget,forgot=:forgot WHERE con_id='1'" | 1 |
|
| "DELETE FROM messages WHERE msg_id=:msg_id" | 1 |
|
| "DELETE FROM message_like WHERE msg_id_fk=:msg_id" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='1' AND (email LIKE :searchKey OR name LIKE :searchKey OR username LIKE :searchKey ) ORDER BY uid DESC" | 1 |
|
| "UPDATE users SET status='1' WHERE uid=:uid" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='2' ORDER BY uid DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='2' AND (username LIKE :searchKey OR name LIKE :searchKey OR email LIKE :searchKey) ORDER BY uid DESC" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='1' AND verified='1' ORDER BY uid DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT uid,username,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,
profile_pic_status,verified,provider,name FROM users WHERE status='1' AND verified='1' AND (username LIKE :searchKey OR name LIKE :searchKey OR email LIKE :searchKey ) ORDER BY uid DESC" | 1 |
|
| "SELECT M.msg_id,M.message,U.username,M.ip FROM messages M, users U WHERE U.uid=M.uid_fk ORDER BY msg_id DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT M.msg_id,M.message,U.username,M.ip FROM messages M, users U WHERE U.uid=M.uid_fk AND (M.message LIKE :searchKey OR U.username LIKE :searchKey) ORDER BY msg_id DESC" | 1 |
|
| "SELECT C.com_id,C.comment,U.username, C.ip FROM comments C, users U WHERE U.uid=C.uid_fk ORDER BY com_id DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT C.com_id,C.comment,U.username, C.ip FROM comments C, users U WHERE U.uid=C.uid_fk AND ( C.comment LIKE :searchKey OR U.username LIKE :searchKey )ORDER BY com_id DESC" | 1 |
|
| "SELECT G.group_name,G.group_id,G.group_desc,G.group_ip,U.username FROM groups G, users U WHERE U.uid=G.uid_fk AND G.status='1' ORDER BY group_id DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT G.group_name,G.group_id,G.group_desc,G.group_ip,U.username FROM groups G, users U WHERE U.uid=G.uid_fk AND G.status='1' AND (G.group_name LIKE :searchKey OR G.group_desc LIKE :searchKey OR U.username LIKE :searchKey) ORDER BY group_id DESC" | 1 |
|
| "SELECT G.group_name,G.group_id,G.group_desc,G.group_ip,U.username FROM groups G, users U WHERE U.uid=G.uid_fk AND G.status='0' ORDER BY group_id DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT G.group_name,G.group_id,G.group_desc,G.group_ip,U.username FROM groups G, users U WHERE U.uid=G.uid_fk AND G.status='0' AND (G.group_name LIKE :searchKey OR G.group_desc LIKE :searchKey OR U.username LIKE :searchKey) ORDER BY group_id DESC" | 1 |
|
| "SELECT G.image_path,G.id,G.group_id_fk,U.username FROM user_uploads G, users U WHERE U.uid=G.uid_fk AND image_type='0' ORDER BY id DESC LIMIT :start, :per_page" | 1 |
|
| "SELECT G.image_path,G.id,G.group_id_fk,U.username FROM user_uploads G, users U WHERE U.uid=G.uid_fk AND image_type>'0' ORDER BY id DESC LIMIT :start, :per_page" | 1 |
|
| "UPDATE group_users SET status='1' WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM message_share WHERE msg_id_fk=:msg_id" | 1 |
|
| "DELETE FROM message_share WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM users WHERE uid=:uid" | 1 |
|
| "DELETE FROM messages WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM comments WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM groups WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM group_users WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM message_like WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM comment_like WHERE uid_fk=:uid" | 1 |
|
| "UPDATE users SET status='2' WHERE uid=:uid" | 1 |
|
| "DELETE FROM user_uploads WHERE uid_fk=:uid" | 1 |
|
| "DELETE FROM conversation WHERE user_one=:uid OR user_two=:uid" | 1 |
|
| "DELETE FROM conversation_reply WHERE user_id_fk=:uid" | 1 |
|
| "UPDATE users SET verified='1' WHERE uid=:uid" | 1 |
|
| "UPDATE users SET verified='0' WHERE uid=:uid" | 1 |
|
| "UPDATE group_users SET status='0' WHERE uid_fk=:uid" | 1 |
|
| "SELECT id,image_path,uid_fk as uid,group_id_fk as group_id FROM user_uploads WHERE uid_fk=:uid AND group_id_fk='0' AND image_type='0' ORDER BY id DESC LIMIT $con" | 1 |
|
| "UPDATE users SET photos_count=photos_count-1 WHERE uid=:uid" | 1 |
|
| "UPDATE groups SET group_bg_position=:position WHERE group_id=:group_id AND uid_fk=:uid" | 1 |
|
| "SELECT id,image_path from user_uploads WHERE image_path=:image " | 1 |
|
| "UPDATE messages SET share_count=share_count-1 WHERE msg_id=:msgid" | 1 |
|
| "INSERT INTO message_like (msg_id_fk,uid_fk,ouid_fk,created,reactionType) VALUES(:msgid,:uid,:ouid,:created,:reactionType)" | 1 |
|
| "UPDATE messages SET like_count=like_count+1 WHERE msg_id=:msgid" | 1 |
|
| "DELETE FROM message_like WHERE msg_id_fk=:msgid and uid_fk=:uid" | 1 |
|
| "UPDATE messages SET like_count=like_count-1 WHERE msg_id=:msgid" | 1 |
|
| "SELECT U.uid,U.username,U.name, U.profile_pic FROM message_like M, users U WHERE U.uid=M.uid_fk AND M.msg_id_fk=:msgid AND U.status='1'" | 1 |
|
| "SELECT U.uid, U.username,U.name, U.profile_pic FROM message_like M, users U WHERE U.uid=M.uid_fk AND M.msg_id_fk=:msgid AND U.status='1' LIMIT 3" | 1 |
|
| "SELECT share_id FROM message_share WHERE uid_fk=:uid and msg_id_fk=:msgid " | 1 |
|
| "SELECT like_id,reactionType FROM message_like WHERE uid_fk=:uid and msg_id_fk=:msgid" | 1 |
|
| "SELECT M.msg_id, M.uid_fk, M.message, M.created,M.like_count,M.comment_count,M.share_count,M.uploads, U.username,U.name,U.profile_pic,U.emailNotifications,U.email FROM messages M, users U WHERE U.status='1' AND M.uid_fk=U.uid and M.msg_id=:msgid " | 1 |
|
| "UPDATE users SET photos_count=photos_count+1 WHERE uid=:uid" | 1 |
|
| "INSERT INTO user_uploads (image_path,uid_fk,group_id_fk,image_type)VALUES(:image ,:uid,:group_id,:image_type)" | 1 |
|
| "INSERT INTO user_uploads (image_path,uid_fk,image_type)VALUES(:image ,:uid,:image_type)" | 1 |
|
| "SELECT id FROM user_uploads WHERE image_path=:image and uid_fk=:uid" | 1 |
|
| "SELECT id,image_path FROM user_uploads WHERE uid_fk=:uid ORDER BY id desc" | 1 |
|
| "UPDATE messages SET share_count=share_count+1 WHERE msg_id=:msgid" | 1 |
|
| "UPDATE users SET profile_bg=:image WHERE uid=:uid" | 1 |
|
| "INSERT INTO user_uploads (image_path,uid_fk,image_type) VALUES (:image,:uid,:image_type)" | 1 |
|
| "SELECT uid,profile_bg FROM users WHERE uid=:uid" | 1 |
|
| "UPDATE users SET profile_pic=:image,profile_pic_status=:status WHERE uid=:uid" | 1 |
|
| "INSERT INTO user_uploads (image_path,uid_fk,image_type) VALUES (:image,:uid,:status)" | 1 |
|
| "SELECT uid,profile_pic FROM users WHERE uid=:uid" | 1 |
|
| "INSERT INTO user_uploads(image_path,uid_fk,group_id_fk,image_type) VALUES (:image,:uid,:groupID,:image_type)" | 1 |
|
| "UPDATE groups SET group_pic=:image WHERE group_id=:groupID AND uid_fk=:uid" | 1 |
|
| "INSERT INTO user_uploads (image_path,uid_fk,group_id_fk,image_type) VALUES (:image,:uid,:groupID,:status)" | 1 |
|
| "SELECT group_id,group_pic FROM groups WHERE group_id=:groupID AND uid_fk=:uid" | 1 |
|
| "SELECT image_path FROM user_uploads WHERE id=:id " | 1 |
|
| "SELECT U.username,U.name, U.uid, U.bio, U.profile_pic FROM users U WHERE U.status=:status AND U.uid<>:uid AND verified='1' ORDER BY RAND() LIMIT 5 " | 1 |
|
| "SELECT group_id FROM groups WHERE group_id=:group_id AND uid_fk=:uid" | 1 |
|
| "SELECT '' as status,U.username,U.name, U.uid, U.profile_pic FROM users U, friends F WHERE U.status='1' AND U.uid=F.friend_one AND F.friend_two=:uid AND F.role='fri' ORDER BY F.friend_id DESC LIMIT $con" | 1 |
|
| "DELETE FROM message_share WHERE msg_id_fk=:msgid and uid_fk=:uid" | 1 |
|
| "INSERT INTO message_share (msg_id_fk,uid_fk,ouid_fk,created) VALUES(:msgid,:uid,:ouid,:time)" | 1 |
|
| "INSERT INTO friends(friend_one,friend_two,role,created) VALUES (:uid,:fid,:role,:time)" | 1 |
|
| "SELECT uid,username,name,bio,email,profile_pic,profile_bg,group_count,emailNotifications FROM users WHERE uid=:uid AND status='1'" | 1 |
|
| "SELECT uid,notification_created,username,name,profile_pic,tour FROM users WHERE (username=:username or email=:username) and password=:password AND status='1' " | 1 |
|
| "SELECT id FROM user_uploads WHERE uid_fk='$uid' and group_id_fk='0'" | 1 |
|
| "SELECT msg_id FROM messages WHERE uid_fk='$uid' and group_id_fk='0'" | 1 |
|
| "UPDATE users SET last_login='$time',photos_count='$photos_count',updates_count='$updates_count' WHERE uid='$uid'" | 1 |
|
| "UPDATE users SET notification_created='$time' WHERE uid='$uid'" | 1 |
|
| "SELECT uid FROM users WHERE username=:username or email=:email" | 1 |
|
| "INSERT INTO users(username,password,email,last_login,email_activation,status)VALUES(:username,:password,:email,:created,:email_activation,:status)" | 1 |
|
| "SELECT uid,notification_created,username,name,profile_pic,tour FROM users WHERE username=:username" | 1 |
|
| "SELECT language_labels,applicationName,applicationDesc,forgot,newsfeedPerPage,friendsPerPage,photosPerPage,groupsPerPage,notificationPerPage, uploadImage,bannerWidth, profileWidth,gravatar,friendsWidgetPerPage,upload FROM configurations WHERE con_id='1' " | 1 |
|
| "SELECT feedPosted,notiIsFollowingGroup,notiLiked,notiFollowingYou,notiShared,notiStatus,notiCommented FROM language_labels WHERE labelID='1'" | 1 |
|
| "SELECT * FROM language_labels WHERE labelID='1' " | 1 |
|
| "SELECT uid,tour,username,name,emailNotifications,bio,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,profile_pic_status,profile_bg_position,verified,notification_created,photos_count,facebookProfile,twitterProfile,googleProfile,instagramProfile,gender,emailNotifications FROM users WHERE uid=:uid AND status='1'" | 1 |
|
| "SELECT uid,tour,username,name,bio,email,friend_count,profile_pic,conversation_count,updates_count,profile_bg,group_count,profile_pic_status,profile_bg_position,verified,notification_created,photos_count,facebookProfile,twitterProfile,googleProfile,instagramProfile,gender FROM users WHERE uid=:uid AND status='1'" | 1 |
|
| "SELECT notification_created FROM users WHERE uid=:uid AND status='1'" | 1 |
|
| "SELECT uid FROM users WHERE uid=:uid AND password=:md5_oldPassword" | 1 |
|
| "UPDATE users SET facebookProfile=:facebook,twitterProfile=:twitter,googleProfile=:google,instagramProfile=:instagram WHERE uid=:uid" | 1 |
|
| "UPDATE users SET password=:md5_newPassword WHERE uid=:uid" | 1 |
|
| "UPDATE users SET tour='1' WHERE uid=:uid" | 1 |
|
| "SELECT uid FROM users WHERE username=:username" | 1 |
|
| "UPDATE users SET username=:username WHERE uid =:uid" | 1 |
|
| "SELECT uid FROM users WHERE email=:usernameEmail" | 1 |
|
| "SELECT uid FROM users WHERE username=:usernameEmail" | 1 |
|
| "SELECT uid FROM users WHERE username=:username AND status='1'" | 1 |
|
| "UPDATE users SET password=:password,forgot_code='' WHERE forgot_code=:code" | 1 |
|
| "SELECT uid FROM users WHERE email_activation=:code" | 1 |
|
| "UPDATE users SET email_activation='',status='1' WHERE email_activation=:code" | 1 |
|
| "SELECT uid FROM users WHERE (username=:usernameEmail OR email=:usernameEmail) AND status='1'" | 1 |
|
| "SELECT email,name,username FROM users WHERE uid=:uid" | 1 |
|
| "UPDATE users SET forgot_code=:active_code WHERE uid=:uid" | 1 |
|
| "UPDATE users SET name=:full_name,bio=:aboutme,gender=:gender,emailNotifications=:emailNotifications WHERE uid=:uid" | 1 |
|
| "SELECT role FROM friends WHERE friend_one=:uid AND friend_two=:fid" | 1 |
|
| "SELECT uid,notification_created,username,name,profile_pic,tour FROM users WHERE email=:email" | 1 |
|
| "UPDATE users SET friend_count=friend_count+1 WHERE uid=:uid" | 1 |
|
| "SELECT group_id FROM groups WHERE uid_fk=:uid ORDER BY group_id DESC LIMIT 1" | 1 |
|
| "SELECT R.cr_id,R.time,R.reply,R.lat,R.lang,R.uploads,U.uid,U.username,U.email,U.name,U.profile_pic FROM users U, conversation_reply R WHERE R.user_id_fk=U.uid and R.c_id_fk=:c_id ORDER BY R.cr_id DESC LIMIT 1" | 1 |
|
| "SELECT R.reply,R.user_id_fk,R.read_status FROM conversation_reply R WHERE R.c_id_fk=:c_id ORDER BY R.cr_id DESC LIMIT 1" | 1 |
|
| "SELECT R.cr_id, U.conversation_count FROM users U, conversation_reply R WHERE R.user_id_fk=U.uid AND U.status='1' AND R.c_id_fk=:c_id" | 1 |
|
| "SELECT R.cr_id,R.time,R.reply,R.user_id_fk FROM conversation_reply R WHERE R.c_id_fk=:c_id ORDER BY R.cr_id DESC LIMIT 1" | 1 |
|
| "UPDATE conversation_reply SET read_status='0' WHERE c_id_fk=:c_id ORDER BY cr_id DESC LIMIT 1" | 1 |
|
| "SELECT conversation_count from users WHERE uid=:uid" | 1 |
|
| "SELECT R.c_id_fk,R.cr_id,R.time,R.reply,R.lat,R.lang,R.uploads,U.uid,U.username,U.name,U.profile_pic,U.conversation_count FROM users U, conversation_reply R WHERE R.user_id_fk=U.uid and R.c_id_fk=:c_id $morequery ORDER BY R.cr_id ASC LIMIT $x_count 10" | 1 |
|
| "SELECT a_title,a_desc,a_url,a_img,ad_code,ad_type FROM advertisments WHERE status='1' ORDER BY a_id DESC" | 1 |
|
| "SELECT group_id FROM groups WHERE group_name=:group_name " | 1 |
|
| "INSERT INTO groups(group_name,group_desc,uid_fk,group_created,group_ip) VALUES (:group_name,:group_desc,:uid,:time,:ip)" | 1 |
|
| "SELECT uid_fk FROM groups WHERE group_id=:groupid AND status=:status" | 1 |
|
| "SELECT read_status FROM conversation_reply WHERE c_id_fk=:c_id and user_id_fk=:uid ORDER BY cr_id DESC LIMIT 1,1" | 1 |
|
| "SELECT status FROM group_users WHERE group_id_fk=:groupid AND uid_fk=:uid" | 1 |
|
| "SELECT U.username,U.bio, U.uid, G.status,U.name, U.profile_pic FROM users U, group_users G WHERE U.status=:status AND U.uid=G.uid_fk AND G.group_id_fk=:group_id ORDER BY G.group_user_id DESC LIMIT $con" | 1 |
|
| "SELECT id,image_path,uid_fk as uid FROM user_uploads WHERE group_id_fk=:group_id ORDER BY id DESC LIMIT $con" | 1 |
|
| "SELECT id FROM user_uploads WHERE uid_fk=:uid and group_id_fk=:group_id" | 1 |
|
| "DELETE FROM group_users WHERE uid_fk=:uid AND group_id_fk=:group_id" | 1 |
|
| "UPDATE groups SET group_count=group_count-1 WHERE group_id=:group_id" | 1 |
|
| "UPDATE users SET group_count=group_count-1 WHERE uid=:uid" | 1 |
|
| "UPDATE groups SET group_name=:group_name,group_desc=:group_desc WHERE group_id=:group_id and uid_fk=:uid" | 1 |
|
| "DELETE FROM user_uploads WHERE group_id_fk=:group_id" | 1 |
|
| "DELETE FROM groups WHERE group_id=:group_id" | 1 |
|
| "UPDATE users SET profile_bg_position=:position WHERE uid=:uid" | 1 |
|
| "UPDATE users SET conversation_count=conversation_count+1 WHERE uid=:o_uid" | 1 |
|
| "UPDATE users SET conversation_count=conversation_count-1 WHERE uid=:uid" | 1 |
|
| "SELECT if(user_one = :uid,user_two,user_one) AS uid FROM conversation WHERE c_id = :c_id" | 1 |
|
| "UPDATE users SET friend_count=friend_count-1 WHERE uid=:uid" | 1 |
|
| "INSERT INTO profile_views (uid_fk,view_uid_fk,created) VALUES (:uid,:view_uid,:time)" | 1 |
|
| "UPDATE profile_views SET created=:time WHERE uid_fk=:uid AND view_uid_fk=:view_uid ORDER BY created DESC" | 1 |
|
| "SELECT c_id FROM conversation WHERE user_one=:user_one ORDER BY c_id DESC LIMIT 1" | 1 |
|
| "UPDATE conversation SET time='$time' WHERE c_id='$c_id'" | 1 |
|
| "SELECT conversation_count FROM users WHERE uid=:uid" | 1 |
|
| "SELECT u.uid,c.c_id,u.username,u.email,c.time FROM conversation c, users u WHERE CASE WHEN c.user_one = :user_one THEN c.user_two = u.uid WHEN c.user_two = :user_one THEN c.user_one= u.uid END AND ( c.user_one =:user_one OR c.user_two =:user_one ) AND u.status='1' AND u.uid=:conversation_uid " | 1 |
|
| "SELECT c_id FROM conversation WHERE c_id = :c_id and (user_one=:uid or user_two=:uid)" | 1 |
|
| "SELECT read_status,user_id_fk FROM conversation_reply WHERE c_id_fk=:c_id ORDER BY cr_id DESC LIMIT 1" | 1 |
|
| "SELECT c_id FROM conversation WHERE (user_one=:user_one and user_two=:user_two) or (user_one=:user_two and user_two=:user_one)" | 1 |
|
| "SELECT uid_fk FROM profile_views WHERE uid_fk=:uid AND view_uid_fk=:view_uid" | 1 |
|
| "SELECT if(user_one = :nuid,user_two,user_one) AS uid FROM conversation WHERE c_id = :c_id" | 1 |
|
| "UPDATE users SET conversation_count=conversation_count-1 WHERE uid=:o_uid" | 1 |
|
| "DELETE FROM `conversation` WHERE c_id =:c_id" | 1 |
|
| "INSERT INTO conversation_reply (user_id_fk,reply,ip,time,c_id_fk,lat,lang,uploads) VALUES (:uid,:reply,:ip,:time,:c_id,:lat,:lang,:uploads)" | 1 |
|
| "DELETE FROM friends WHERE friend_one=:uid AND friend_two=:fid" | 1 |
|
| "SELECT DISTINCT u.uid,c.c_id,u.name,u.profile_pic,u.username,u.email,c.time FROM conversation c, users u, conversation_reply r WHERE CASE WHEN c.user_one = :user_one THEN c.user_two = u.uid WHEN c.user_two = :user_one THEN c.user_one= u.uid END AND ( c.user_one =:user_one OR c.user_two =:user_one ) AND u.status=:status AND c.c_id=r.c_id_fk AND u.uid<>:conversation_uid $morequery ORDER BY c.time DESC LIMIT 15" | 1 |
|
| "INSERT INTO conversation(user_one,user_two,ip,time) VALUES (:user_one,:user_two,:ip,:time)" | 1 |
|
| "DELETE FROM `conversation_reply` WHERE c_id_fk =:c_id" | 1 |
|
| "DELETE FROM `user_uploads` WHERE id =:upload_id" | 1 |
|
| "SELECT U.image_path,U.id FROM conversation_reply R, user_uploads U WHERE R.uploads=U.id AND R.c_id_fk =:c_id" | 1 |
|
| "INSERT INTO user_uploads(image_path,uid_fk,group_id_fk,image_type) VALUES (:image,:uid,:groupID,:status)" | 2 |
|
| "DELETE FROM group_users WHERE group_id_fk=:group_id" | 2 |
|
| "INSERT INTO friends(friend_one,friend_two,role,created)VALUES(:uid,:uid,:me,:created)" | 2 |
|
| "SELECT DISTINCT G.group_id, G.uid_fk as group_owner_id, G.group_name, G.group_pic, G.group_desc FROM groups G WHERE G.status='1' AND G.group_id<>:otherGroups ORDER BY RAND() DESC LIMIT $con" | 2 |
|
| "SELECT language_labels FROM configurations WHERE con_id='1'" | 2 |
|
| "SELECT DISTINCT G.group_id, G.uid_fk as group_owner_id, G.group_name, G.group_pic,G.group_bg, G.group_desc FROM groups G, group_users F WHERE G.status='1' AND F.status='1' AND G.group_id=F.group_id_fk AND F.uid_fk=:uid ORDER BY F.created DESC LIMIT $con" | 2 |
|
| "SELECT t_id,t_name,t_file,t_order FROM template ORDER BY t_order ASC" | 2 |
|
| "SELECT M.lat, M.lang, M.group_id_fk,M.msg_id, M.uid_fk, M.message, M.created,M.uploads,M.like_count,M.comment_count,M.share_count, U.username,U.name,U.profile_pic FROM messages M, users U WHERE M.uid_fk=U.uid and M.msg_id=:msgID AND U.status='1'" | 2 |
|
| "DELETE FROM messages WHERE group_id_fk=:group_id" | 2 |
|
| "UPDATE groups SET group_bg=:image WHERE group_id=:groupID AND uid_fk=:uid" | 2 |
|
| "SELECT U.uid,U.username,U.profile_pic,U.name FROM profile_views P,users U WHERE P.view_uid_fk=:uid AND P.uid_fk=U.uid AND U.status='1' ORDER BY P.created DESC LIMIT $con" | 2 |
|
| "INSERT INTO group_users(uid_fk,group_id_fk,created) VALUES (:uid,:group_id,:time)" | 2 |
|
| "SELECT like_id FROM message_like WHERE msg_id_fk=:msgid LIMIT 1" | 2 |
|
| "SELECT C.com_id, C.uid_fk, C.comment, C.created,C.like_count,C.uploads, U.username,U.name,U.profile_pic FROM comments C, users U WHERE U.status='1' AND C.uid_fk=U.uid and C.msg_id_fk=:msgid ORDER BY C.com_id asc $query " | 2 |
|
| "SELECT like_id FROM message_like WHERE uid_fk='$uid' and msg_id_fk=:msgid" | 2 |
|
| "SELECT friend_id FROM friends WHERE friend_one=:uid AND friend_two=:fid AND role=:role" | 2 |
|
| "SELECT uid_fk FROM messages WHERE msg_id=:msgid" | 2 |
|
| "SELECT share_id FROM message_share WHERE uid_fk=:uid and msg_id_fk=:msgid" | 2 |
|
| "UPDATE groups SET group_count=group_count+1 WHERE group_id=:group_id" | 2 |
|
| "UPDATE users SET group_count=group_count+1 WHERE uid=:uid" | 2 |
|
| "SELECT group_id,group_name,uid_fk as group_owner_id,group_created,group_desc,group_pic,group_bg,group_count,group_updates,group_bg_position FROM groups WHERE group_id=:groupid AND status=:status" | 2 |
|
| "SELECT uid FROM users WHERE forgot_code=:code" | 2 |
|
| "SELECT group_id FROM groups WHERE uid_fk=:uid AND group_id=:group_id" | 2 |
|
| "SELECT group_id,group_bg FROM groups WHERE group_id=:groupID AND uid_fk=:uid" | 2 |
|
| "SELECT '' as status,U.username,U.name, U.uid, U.profile_pic FROM users U, friends F WHERE U.status='1' AND U.uid=F.friend_two AND F.friend_one=:uid AND F.role='fri' ORDER BY F.friend_id DESC LIMIT $con" | 2 |
|
| "SELECT group_user_id FROM group_users WHERE uid_fk=:uid AND group_id_fk=:group_id" | 3 |
|
| "SELECT like_id FROM message_like" | 4 |
|
| "SELECT share_id FROM message_share" | 4 |
|