SQL Inventory

List of all SQL mentioned in the code..

ValueCountFile:Line
"SELECT * FROM signup WHERE (Fullname LIKE ? OR country LIKE ?) OR (CONCAT(work,?,work0) LIKE ?) ORDER BY country LIMIT 8"
1
  • /search.php
"SELECT author_id FROM wpost WHERE post_id = ? AND author_id IN (SELECT uf_two FROM follow WHERE uf_one= ?)"
1
  • /posts/post.php
"UPDATE comments SET c_content= :edit_commant_var , c_edited= :edited , c_time_edited= :timeEdited WHERE c_id= :comment_id"
1
  • /includes/updatecomment.php
"DELETE FROM r_star WHERE u_id = :uid AND p_id = :pid"
1
  • /includes/r_star.php
"INSERT INTO r_star (u_id,p_id) VALUES (:uid,:pid)"
1
  • /includes/r_star.php
"SELECT * FROM mynotepad WHERE author_id= :s_id ORDER BY note_time DESC"
1
  • /mynotepad/main.php
"DELETE FROM mynotepad WHERE id= :note_id"
1
  • /mynotepad/main.php
"INSERT INTO mynotepad 
(id,author_id,note_title,note_content,note_time)
VALUES
( :note_id, :author_id, :note_title, :note_content, :note_time)
    "
1
  • /mynotepad/new.php
"SELECT author_id FROM wpost WHERE post_id = ?"
1
  • /posts/post.php
"SELECT * FROM wpost WHERE post_id = ?"
1
  • /posts/post.php
"SELECT * FROM wpost WHERE post_id = ? AND p_privacy != ? AND p_privacy != ?"
1
  • /posts/post.php
"INSERT INTO wpost 
    (post_id,author_id,post_time,p_privacy,shared) VALUES
    (:post_id, :p_author_id,:p_time, :p_privacy, :shared)"
1
  • /includes/share.php
"SELECT * FROM wpost WHERE post_id = ? AND p_privacy != ?"
1
  • /posts/post.php
"SELECT * FROM supportbox WHERE from_id =:myId ORDER BY r_time DESC"
1
  • /page/index.php
"SELECT id,Fullname,Username,Email,Password,admin FROM signup WHERE Username = :ed"
1
  • /toacpnlp/user.php
"SELECT Username FROM signup WHERE Username =:db_username"
1
  • /toacpnlp/user.php
"SELECT Email FROM signup WHERE Email =:db_email"
1
  • /toacpnlp/user.php
"UPDATE signup SET Fullname = :db_fullname,Username = :db_username,Email = :db_email,admin = :db_admin WHERE Username = :ed"
1
  • /toacpnlp/user.php
"UPDATE signup SET Fullname = :db_fullname,Username = :db_username,Email = :db_email,Password = :db_password,admin = :db_admin WHERE Username = :ed"
1
  • /toacpnlp/user.php
"DELETE FROM signup WHERE id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM comments WHERE c_author_id= :uInfo_id"
1
  • /toacpnlp/user.php
"SELECT author_id FROM wpost WHERE post_id=:pid"
1
  • /includes/share.php
"SELECT author_id FROM wpost WHERE post_id=:get_post_id"
1
  • /includes/insert_commentdb.php
"DELETE FROM follow WHERE uf_two= :uInfo_id"
1
  • /toacpnlp/user.php
"INSERT INTO signup (id,Fullname,Username,Email,Password,Userphoto,gender,language)
    VALUES( :signup_id, :signup_fullname, :signup_username, :signup_email, :signup_password, :userphoto, :signup_gender,:signup_language)"
1
  • /includes/login_signup_codes.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:id"
1
  • /search.php
"SELECT c_author_id FROM comments WHERE c_id =:c_id"
1
  • /includes/deletecomm.php
"DELETE FROM comments WHERE c_id= :c_id"
1
  • /includes/deletecomm.php
"SELECT * FROM signup WHERE Username = :username OR Email= :email"
1
  • /includes/login_signup_codes.php
"SELECT login_attempts FROM signup WHERE Username = :username"
1
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE (Username= :username OR Email= :email) AND Password= :rPassword"
1
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE Username=:signup_username"
1
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE Email=:signup_email"
1
  • /includes/login_signup_codes.php
"INSERT INTO signup (id,Fullname,Username,Email,Password,Userphoto,gender,language,admin)
    VALUES( :signup_id, :signup_fullname, :signup_username, :signup_email, :signup_password, :userphoto, :signup_gender,:signup_language,:signup_admin)"
1
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE (Username= :signup_username OR Email= :signup_email) AND Password= :signup_password"
1
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE id=:s_id"
1
  • /includes/insert_commentdb.php
"DELETE FROM follow WHERE uf_one=:s_id AND uf_two=:user_id"
1
  • /includes/f_action.php
"INSERT INTO follow VALUES (:fid,:s_id,:user_id)"
1
  • /includes/f_action.php
"SELECT Username FROM signup WHERE Username=:mys"
1
  • /includes/navbar_main.php
"SELECT * FROM saved WHERE post_id= :pid AND user_saved_id= :myid"
1
  • /includes/send_saved_postDB.php
"INSERT INTO saved (id, post_id, user_saved_id, saved_time) VALUES (:id, :pid, :myid, :st)"
1
  • /includes/send_saved_postDB.php
"
INSERT INTO supportbox
(r_id,from_id,for_id,r_type,r_time,status) VALUES
(:r_id,:from_id,:for_id,:r_type,:r_time,:status)"
1
  • /includes/report.php
"
INSERT INTO supportbox
(r_id,from_id,r_type,subject,report,r_time,status) VALUES
(:r_id,:from_id,:r_type,:subject,:report,:r_time,:status)"
1
  • /includes/report.php
"DELETE FROM supportbox WHERE r_id =:r_id"
1
  • /includes/report.php
"INSERT INTO comments
(c_id,c_author_id,c_post_id,c_content,c_time)
VALUES
(:c_id,:s_id,:get_post_id,:comment_content,:comment_time)
"
1
  • /includes/insert_commentdb.php
"DELETE FROM follow WHERE uf_one= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM likes WHERE liker= :uInfo_id"
1
  • /toacpnlp/user.php
"INSERT INTO wpost
(post_id,author_id,post_img,post_time,post_content,p_title,p_privacy)
VALUES
( :post_id, :p_author_id, :p_img, :p_time, :p_content, :p_title, :p_privacy)
"
1
  • /includes/wpost.php
"SELECT * FROM follow WHERE uf_two=:row_id"
1
  • /u/profile.php
"SELECT Username,Fullname,Userphoto FROM signup"
1
  • /toacpnlp/index.php
"SELECT r_id,from_id,r_type,subject,r_time FROM supportbox WHERE status = :status"
1
  • /toacpnlp/index.php
"SELECT Fullname,Username FROM signup WHERE id = :from_id"
1
  • /toacpnlp/index.php
"SELECT post_id FROM wpost WHERE author_id=:row_id"
1
  • /u/profile.php
"SELECT id FROM r_star WHERE p_id=:row_id"
1
  • /u/profile.php
"SELECT id FROM follow WHERE uf_two=:row_id"
1
  • /u/profile.php
"SELECT id FROM follow WHERE uf_one=:row_id"
1
  • /u/profile.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:row_id"
1
  • /u/profile.php
"SELECT * FROM wpost WHERE author_id=:u_id AND post_img != :emptyImg ORDER BY post_time DESC"
1
  • /u/profile.php
"SELECT * FROM signup WHERE id=:getfollow_id"
1
  • /u/profile.php
"SELECT id FROM notifications"
1
  • /toacpnlp/index.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:id_followers"
1
  • /u/profile.php
"SELECT * FROM follow WHERE uf_one=:row_id"
1
  • /u/profile.php
"SELECT * FROM signup WHERE id=:getfolloweing_id"
1
  • /u/profile.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:id_followeing"
1
  • /u/profile.php
"SELECT * FROM r_star WHERE p_id =:row_id"
1
  • /u/profile.php
"SELECT * FROM signup WHERE id=:getuserid"
1
  • /u/profile.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:id_stars"
1
  • /u/profile.php
"SELECT * FROM wpost WHERE author_id=:s_id AND post_img != :emptyImg ORDER BY post_time"
1
  • /u/profile.php
"SELECT id FROM signup WHERE id=:usrSessID"
1
  • /config/connect.php
"SELECT Username FROM signup WHERE Username=:userVerifyBadge"
1
  • /toacpnlp/index.php
"SELECT id FROM saved"
1
  • /toacpnlp/index.php
"DELETE FROM mynotepad WHERE author_id= :uInfo_id"
1
  • /toacpnlp/user.php
"SELECT Fullname,Username,Userphoto FROM signup WHERE id = :from_id"
1
  • /toacpnlp/sbox_r.php
"DELETE FROM r_star WHERE u_id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM r_star WHERE p_id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM wpost WHERE author_id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM notifications WHERE from_id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM saved WHERE user_saved_id= :uInfo_id"
1
  • /toacpnlp/user.php
"DELETE FROM supportbox WHERE from_id= :uInfo_id"
1
  • /toacpnlp/user.php
"SELECT Username FROM signup WHERE Username =:ed AND admin =:admin_int"
1
  • /toacpnlp/user.php
"UPDATE supportbox SET r_replay = :r_replay,r_replay_time = :r_replay_time,status = :status WHERE r_id = :rid"
1
  • /toacpnlp/sbox_r.php
"SELECT r_id,for_id,from_id,r_type,report,r_time FROM supportbox WHERE r_id =:rid"
1
  • /toacpnlp/sbox_r.php
"SELECT post_id FROM wpost"
1
  • /toacpnlp/index.php
"SELECT id FROM messages"
1
  • /toacpnlp/index.php
"SELECT c_id FROM comments"
1
  • /toacpnlp/index.php
"SELECT verify FROM signup WHERE verify='1'"
1
  • /toacpnlp/index.php
"SELECT admin FROM signup WHERE admin='1' OR admin='2'"
1
  • /toacpnlp/index.php
"SELECT id FROM likes"
1
  • /toacpnlp/index.php
"SELECT aSetup FROM signup WHERE aSetup='100'"
1
  • /toacpnlp/index.php
"SELECT gender FROM signup WHERE gender='Male'"
1
  • /toacpnlp/index.php
"SELECT gender FROM signup WHERE gender='Female'"
1
  • /toacpnlp/index.php
"SELECT id FROM r_star"
1
  • /toacpnlp/index.php
"SELECT id FROM mynotepad"
1
  • /toacpnlp/index.php
"INSERT INTO wpost
(post_id,author_id,post_time,post_content,p_title,p_privacy)
VALUES
( :post_id, :p_author_id, :p_time, :p_content, :p_title, :p_privacy)
"
1
  • /includes/wpost.php
"SELECT * FROM wpost WHERE post_id = :post_id"
1
  • /includes/wpost.php
"DELETE FROM typing_m WHERE t_from=:myid AND t_to = :uid"
1
  • /includes/m_requests.php
"SELECT * FROM signup WHERE id=:authorOfPost"
1
  • /includes/fetchTrending.php
"DELETE FROM saved WHERE user_saved_id= :myid"
1
  • /settings.php
"DELETE FROM supportbox WHERE from_id= :myid"
1
  • /settings.php
"Select your country"
1
  • /settings.php
"SELECT * FROM likes WHERE liker=:s_id AND post_id=:plike"
1
  • /includes/lac.php
"DELETE FROM likes WHERE liker=:s_id AND post_id=:plike"
1
  • /includes/lac.php
"INSERT INTO likes VALUES (:lid,:s_id,:plike)"
1
  • /includes/lac.php
"SELECT * FROM signup ORDER BY followers DESC LIMIT 6"
1
  • /includes/fetchTrending.php
"SELECT * FROM wpost WHERE post_content!= :emptypost AND p_privacy = :public ORDER BY p_likes DESC LIMIT 6"
1
  • /includes/fetchTrending.php
"SELECT * FROM signup WHERE id=:get_author_id"
1
  • /includes/fetch_posts.php
"DELETE FROM wpost WHERE author_id= :myid"
1
  • /settings.php
"SELECT c_id FROM comments WHERE c_post_id=:get_post_id"
1
  • /includes/fetch_posts.php
"SELECT shared FROM wpost WHERE shared=:get_post_id"
1
  • /includes/fetch_posts.php
"SELECT * FROM wpost WHERE post_id=:get_post_shared "
1
  • /includes/fetch_posts.php
"SELECT * FROM signup WHERE id=:shP_aid "
1
  • /includes/fetch_posts.php
"SELECT id FROM likes WHERE liker=:s_id AND post_id=:get_post_id"
1
  • /includes/fetch_posts.php
"SELECT id FROM likes WHERE post_id=:get_post_id"
1
  • /includes/fetch_posts.php
"SELECT * FROM wpost WHERE author_id IN 
(SELECT uf_two FROM follow WHERE uf_one=:s_id) AND p_privacy != :p_privacy OR author_id=:s_id ORDER BY post_time DESC LIMIT :plimit,10"
1
  • /includes/fetch_posts_home.php
"SELECT * FROM signup WHERE (Fullname LIKE ? OR country LIKE ?) OR (CONCAT(work,?,work0) LIKE ?) OR Username LIKE ? LIMIT 8"
1
  • /includes/searchq.php
"INSERT INTO typing_m (t_from,t_to) VALUES (:myid,:uid)"
1
  • /includes/m_requests.php
"DELETE FROM notifications WHERE from_id= :myid"
1
  • /settings.php
"DELETE FROM r_star WHERE p_id= :myid"
1
  • /settings.php
"SELECT * FROM signup WHERE id=:author_id_4comm"
1
  • /includes/fetch_comments.php
"SELECT Username FROM signup WHERE Username =:username_var"
1
  • /settings.php
"SELECT * FROM signup ORDER BY id DESC"
1
  • /search.php
"SELECT id FROM follow WHERE uf_one=:s_id AND uf_two=:id_4User"
1
  • /search.php
"SELECT id,note_title FROM mynotepad WHERE author_id=:msid ORDER BY note_time DESC LIMIT 3"
1
  • /home.php
"SELECT * FROM r_star WHERE p_id =:mYiD ORDER BY id DESC LIMIT 5"
1
  • /home.php
"SELECT Username,Userphoto,Fullname FROM signup WHERE id=:getuserid"
1
  • /home.php
"SELECT aSetup FROM signup WHERE id=:uid"
1
  • /home.php
"SELECT * FROM follow WHERE uf_one = :uid"
1
  • /home.php
"UPDATE signup SET aSetup = :aSetupProg WHERE id = :uid"
1
  • /home.php
"SELECT Email FROM signup WHERE Email =:email_var"
1
  • /settings.php
"DELETE FROM r_star WHERE u_id= :myid"
1
  • /settings.php
"UPDATE signup SET Fullname= :fullname_var,Username= :username_var,Email= :email_var,Password= :new_password_var,gender= :gender_var WHERE username= :session_un"
1
  • /settings.php
"UPDATE signup SET school= :school_var,work0= :work0_var,work= :work_var,country= :country_var,birthday= :birthday_var,website= :website_var,bio= :bio_var WHERE username= :session_un"
1
  • /settings.php
"UPDATE signup SET language= :language_var WHERE username= :session_un"
1
  • /settings.php
"DELETE FROM signup WHERE Username= :session_un"
1
  • /settings.php
"DELETE FROM comments WHERE c_author_id= :myid"
1
  • /settings.php
"DELETE FROM follow WHERE uf_one= :myid"
1
  • /settings.php
"DELETE FROM follow WHERE uf_two= :myid"
1
  • /settings.php
"DELETE FROM likes WHERE liker= :myid"
1
  • /settings.php
"DELETE FROM mynotepad WHERE author_id= :myid"
1
  • /settings.php
"SELECT * FROM comments WHERE c_post_id=:pid ORDER BY c_time"
1
  • /includes/fetch_comments.php
"SELECT post_content FROM wpost WHERE post_content LIKE ? AND p_privacy != ? AND p_privacy != ?"
1
  • /includes/searchq.php
"SELECT * FROM wpost WHERE author_id=:row_id AND p_privacy != :pr_onlyme  ORDER BY post_time DESC LIMIT :plimit,10"
1
  • /includes/fetch_posts_user.php
"SELECT id,online,Fullname,Userphoto,Username,verify FROM signup WHERE id IN (SELECT uf_two FROM follow WHERE uf_one= ?) AND (Fullname LIKE ? OR Username LIKE ?)"
1
  • /includes/m_requests.php
"SELECT * FROM wpost WHERE post_id= :saved_post_id"
1
  • /includes/fetch_posts_saved.php
"SELECT * FROM signup WHERE id= :post_author_id"
1
  • /includes/fetch_posts_saved.php
"UPDATE signup SET Userphoto= :fileName WHERE Username= :s_un"
1
  • /includes/uploadprofilephoto.php
"SELECT uf_two FROM follow WHERE uf_one=:myid"
1
  • /includes/m_requests.php
"SELECT id,online,Fullname,Userphoto,Username,verify FROM signup WHERE id=:uf_two"
1
  • /includes/m_requests.php
"SELECT count(id),m_from FROM messages WHERE m_to=:myid GROUP BY m_from"
1
  • /includes/m_requests.php
"SELECT id,online,Fullname,Userphoto,Username,verify FROM signup WHERE id=:m_from"
1
  • /includes/m_requests.php
"SELECT uf_two FROM follow WHERE uf_one=:myid AND uf_two = :m_from"
1
  • /includes/m_requests.php
"SELECT Username,Fullname,Userphoto,online,bio,verify FROM signup WHERE id=:uid"
1
  • /includes/m_requests.php
"DELETE FROM wpost WHERE post_id= :posts_id"
1
  • /includes/deletepost.php
"UPDATE messages SET m_seen = :seen WHERE m_from=:uid AND m_to=:myid"
1
  • /includes/m_requests.php
"SELECT * FROM messages WHERE (m_from = :myid AND m_to = :uid) OR (m_from = :uid AND m_to = :myid)"
1
  • /includes/m_requests.php
"SELECT Userphoto FROM signup WHERE id = :uid"
1
  • /includes/m_requests.php
"INSERT INTO messages (m_id,message,m_from,m_to,m_time,m_seen) VALUES (:mid,:msg,:myid,:uid,:mTime,:mSeen)"
1
  • /includes/m_requests.php
"SELECT m_seen,m_to FROM messages WHERE (m_from = :myid AND m_to = :uid) OR (m_from = :uid AND m_to = :myid) ORDER BY m_time DESC LIMIT 1"
1
  • /includes/m_requests.php
"SELECT message FROM messages WHERE m_to=:myid AND m_seen = :seen"
1
  • /includes/m_requests.php
"SELECT t_from FROM typing_m WHERE t_from=:uid AND t_to = :myid"
1
  • /includes/m_requests.php
"SELECT t_from FROM typing_m WHERE t_from=:myid AND t_to = :uid"
1
  • /includes/m_requests.php
"DELETE FROM saved WHERE id = ?"
1
  • /includes/deleteSavedPost.php
"SELECT * FROM saved WHERE user_saved_id= :uid ORDER BY saved_time DESC"
1
  • /includes/fetch_posts_saved.php
"SELECT * FROM wpost WHERE post_content LIKE ? AND p_privacy != ? AND p_privacy != ? ORDER BY post_time DESC LIMIT 8"
1
  • /hashtag/hashtag.php
"SELECT seen FROM notifications WHERE for_id=:myId AND seen =:seen"
1
  • /includes/fetch_notifybox.php
"UPDATE wpost SET post_content= :edit_post_var,p_title = :edit_post_title,p_privacy = :p_privacy WHERE post_id= :posts_id"
1
  • /includes/updatepost.php
"SELECT Fullname,Username,Userphoto FROM signup WHERE id=:notify_from_id"
1
  • /includes/fetch_notifybox.php
"UPDATE signup SET user_cover_photo= :fileName WHERE Username= :s_un"
1
  • /includes/uploadcoverphoto.php
"SELECT * FROM notifications WHERE for_id =:myId ORDER BY time DESC LIMIT :load,10"
1
  • /includes/fetch_notifybox.php
"UPDATE notifications SET seen=:seen WHERE for_id=:myId"
1
  • /includes/fetch_notifybox.php
"SELECT author_id FROM wpost WHERE post_id =:posts_id"
1
  • /includes/deletepost.php
"SELECT * FROM wpost WHERE author_id=:u_id AND post_img != :emptyImg ORDER BY post_time"
1
  • /includes/myphotosProfile.php
"SELECT * FROM wpost WHERE author_id=:u_id AND post_img != :emptyImg ORDER BY post_time DESC LIMIT 3"
1
  • /includes/myphotosProfile.php
"SELECT * FROM wpost WHERE author_id=:row_id ORDER BY post_time DESC LIMIT :plimit,10"
1
  • /includes/fetch_posts_user.php
"SELECT * FROM wpost WHERE author_id=:row_id AND p_privacy != :pr_onlyme AND p_privacy != :pr_followers ORDER BY post_time DESC LIMIT :plimit,10"
1
  • /includes/fetch_posts_user.php
"SELECT * FROM signup WHERE Username=:un"
1
  • /includes/fetch_users_info.php
"UPDATE signup SET login_attempts =:attempts WHERE Username=:username"
2
  • /includes/login_signup_codes.php
  • /includes/login_signup_codes.php
"SELECT * FROM signup WHERE id=:fetch_author_id"
2
  • /includes/myphotosProfile.php
  • /u/profile.php
"SELECT id FROM signup"
2
  • /includes/login_signup_codes.php
  • /toacpnlp/index.php
"SELECT post_content FROM wpost WHERE post_id=:notifyType_id"
2
  • /includes/fetch_notifybox.php
  • /includes/fetch_notifybox.php
"SELECT Username FROM signup WHERE id=:notifyType_id"
2
  • /includes/fetch_notifybox.php
  • /includes/fetch_notifybox.php
"SELECT id FROM likes WHERE post_id=:plike"
2
  • /includes/lac.php
  • /includes/lac.php
"UPDATE wpost SET p_likes=:likes_num WHERE post_id=:plike"
2
  • /includes/lac.php
  • /includes/lac.php
"UPDATE signup SET followers=:followers_num WHERE id=:user_id"
2
  • /includes/f_action.php
  • /includes/f_action.php
"SELECT message FROM messages WHERE (m_from=:uid AND m_to=:myid) AND m_seen = :seen"
2
  • /includes/m_requests.php
  • /includes/m_requests.php
"SELECT message,m_from FROM messages WHERE (m_from = :myid AND m_to = :uid) OR (m_from = :uid AND m_to = :myid) ORDER BY m_time DESC LIMIT 1"
2
  • /includes/m_requests.php
  • /includes/m_requests.php
"UPDATE signup SET verify=:verifyValue WHERE Username =:userVerifyBadge"
2
  • /toacpnlp/index.php
  • /toacpnlp/index.php
"SELECT id FROM r_star WHERE u_id = :uid AND p_id =:pid"
2
  • /includes/r_star.php
  • /u/profile.php
"SELECT * FROM follow WHERE uf_one=:s_id AND uf_two=:user_id"
2
  • /includes/fetch_posts_user.php
  • /includes/f_action.php
"SELECT author_id FROM wpost WHERE post_id=:plike"
2
  • /includes/lac.php
  • /includes/lac.php
"DELETE FROM notifications WHERE notifyType_id=:notifyType_id AND notifyType=:notifyType"
2
  • /includes/deletepost.php
  • /includes/deletepost.php
"SELECT id FROM follow WHERE uf_two=:user_id"
2
  • /includes/f_action.php
  • /includes/f_action.php
"DELETE FROM notifications WHERE from_id =:from_id AND for_id=:for_id AND notifyType_id=:ntId AND notifyType=:notifyType"
3
  • /includes/lac.php
  • /includes/f_action.php
  • /includes/r_star.php
"UPDATE signup SET online = :online_status WHERE id = :myid"
3
  • /logout.php
  • /includes/head_imports_main.php
  • /includes/userStatus.php
"INSERT INTO notifications (n_id, from_id, for_id, notifyType_id, notifyType, seen, time) VALUES (:nId, :fromId, :forId, :notifyTypeId, :notifyType, :seen, :nTime)"
5
  • /includes/lac.php
  • /includes/f_action.php
  • /includes/insert_commentdb.php
  • /includes/share.php
  • /includes/r_star.php