User FeaturesNEWS FEED – The News Feed page keeps you up to date with the latest status updates of your friends, birthdays and activities, shows friends suggestions and more.
PROFILES – The Profile page features cover and profile images, information about the user, friends list, liked messages, visited locations as well as the user’s timeline.
GROUPS – With Groups you can create and manage communities, stay in touch with the members, share statuses, get notifications when something is posted.
PAGES – With pages you can create pages to promote your brand, community, company, etc. as well as keeping your fan base up to date with your activity.
MESSAGES – Share your life moments, photos, music, videos, movies, places, visited locations, with the public, your friends or privately.
LIVE CHAT – Communicate with your friends in real-time with our multi-windows chat, share your thoughts, photos, emojis, take camera shots and more.
SEARCH – Instant search allows searching for People, #Hashtags, @Pages and !Groups, the results can be filtered using various parameters to match your needs.
NOTIFICATIONS – The advanced notifications system keeps you up to date with the activity of your friends, get notified on Likes, Comments, Shares, Group Invites, and more.
CONNECT – Your users can easily register and log-in on your website with a simplified registered form. Facebook integration also allows to quickly connect with just two clicks.
Admin FeaturesDASHBOARD – The Dashboard shows quick statistics about the evolution of the current day along with graphs of the last 7 days, site information and more.
SITE SETTINGS – Completele website control with tons of options such as captcha, word banning, emoticons, accounts per ip, dynamic timestamps, user settings and more.
THEMES – The built-in theme system allows to switch between themes in an instant, changing your website appearance to a fresh new look.
PLUGINS – The built-in plugins system allows to add new functionality to your website in order to offer a better experience for your users.
LANGUAGES – The built-in language system allows your user to feel at home by providing a quick way to switch between multiple languages.
MANAGE USERS – Manage your users, view and change general account information, verify, delete or suspend users, everything with a few clicks.
MANAGE GROUPS – Manage the groups created by users, view the number of members in a group, change general group settings or delete them.
MANAGE PAGES – Manage the pages created by users, view the number of likes and the page admin, change general pages settings, verify or delete them.
MANAGE REPORTS – Manage the reported messages or comments with ease, get summary statistics, view the reported content and take appropriate actions.
SITE STATISTICS – Get insight statistics of your website activity such as registered users, posted messages, comments, likes, shares and groups created.
ADVERTISEMENT – The predefined advertisement spots allows you to easily insert your 3rd party ad-unit code in various locations on your website.
| Match | Count | SQL | Script |
| SELECT * FROM posts WHERE PID=711067 | 1 | SELECT *, author_bookmarktip AS service_author_bookmarktip FROM posts WHERE PID=711067 | /opt/clerks-staging/docroot/include/functions/includes/service.php 479 getAllServiceDetails() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM seoclerks.members WHERE USERID='175750' | 1 | SELECT * FROM seoclerks.members WHERE USERID='175750' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM ratings A, seoclerks.members B WHERE A.PID='711067' AND A.RATER=B.USERID | 1 | SELECT COUNT(A.RID) as total,
SUM(bad) as badTotal,
SUM(good) as goodTotal
FROM
ratings A,
seoclerks.members B
WHERE A.PID='711067'
AND A.RATER=B.USERID | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM portfolio WHERE PID='711067' ORDER BY id ASC LIMIT 10 | 1 | SELECT
*
FROM
portfolio
WHERE PID='711067'
ORDER BY id ASC
LIMIT 10
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM orders WHERE PID='711067' AND status in (1, 4, 6) | 1 | SELECT
OID,
stime,
extradays1,
extradays2,
extradays3,
extra1ordered,
extra2ordered,
extra3ordered,
days,
status,
quantity,
extras_data
FROM
orders
WHERE PID='711067'
AND status in (1, 4, 6) | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| UPDATE posts SET viewcount = viewcount + 1 WHERE PID='711067' | 1 | UPDATE posts
SET viewcount = viewcount + 1
WHERE PID='711067' | /opt/clerks-staging/docroot/include/functions/main.php 1717 update_viewcount() () |
| SELECT * FROM seoclerks.ratings WHERE USERID='175750' AND PID != 0 | 1 | SELECT good, bad FROM seoclerks.ratings WHERE USERID='175750' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM codeclerks.ratings WHERE USERID='175750' AND PID != 0 | 1 | SELECT good, bad FROM codeclerks.ratings WHERE USERID='175750' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM listingdock.ratings WHERE USERID='175750' AND PID != 0 | 1 | SELECT good, bad FROM listingdock.ratings WHERE USERID='175750' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM pixelclerks.ratings WHERE USERID='175750' AND PID != 0 | 1 | SELECT good, bad FROM pixelclerks.ratings WHERE USERID='175750' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| SELECT * FROM wordclerks.ratings WHERE USERID='175750' AND PID != 0 | 1 | SELECT good, bad FROM wordclerks.ratings WHERE USERID='175750' AND PID != 0 | /opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM categories WHERE parentid = 0 | 1 | SELECT *
FROM categories
WHERE parentid = 0
| /opt/clerks-staging/docroot/include/functions/main.php 21555 getNotParentCategories() include() |
| SELECT * FROM seoclerks.members WHERE USERID=? | 1 | SELECT usergroup
FROM seoclerks.members
WHERE USERID=?
| /opt/clerks-staging/docroot/include/functions/includes/member.php 2553 isStaffMember() include() |
| count(*) | sql1 | error_msg |
|---|
