SEOClerks

Need to clone/create a script.

Need to clone/create a script.

Hi

I need this script, copy or made
http://goo.gl/3pyJkI


Requirements

Code explained please.


Skills Required

Php Programming Images

Bids

i will develop a web app similar to pablo.buffer.com, with the same features or more
and with a good ux and ui design.
*price is negotiable

you may contact with me. first you need to describe me. thanks.

  • Media
    HTML Level 2
  • order now!

    hey there,
    you want to create a script which will do same fucntioning as the link you posted we can make it. so lets talk on the chat and get it clear.
    thanks

    Bid On Listing Created 9 years ago in Programming

    Other jobs by domainkey

    Order Now
    Process Time: 0.35898399353027

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

    /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

    SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='45176' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='45176' AND A.category=B.CATID AND A.USERID=C.USERID

    /opt/clerks-staging/docroot/viewwant.php 163 () ()

    SELECT * FROM ratings_buyer WHERE USERID=3207801SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=320780

    /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 45176 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Programming Images%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 45176 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Programming Images%' ) LIMIT 4

    /opt/clerks-staging/docroot/viewwant.php 551 () ()

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 45176 AND A.category=B.CATID AND A.active=1 AND A.USERID=320780 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 45176 AND A.category=B.CATID AND A.active=1 AND A.USERID=320780 LIMIT 4

    /opt/clerks-staging/docroot/viewwant.php 568 () ()

    SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='45176' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='45176' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

    /opt/clerks-staging/docroot/viewwant.php 835 () ()

    UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='45176'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='45176'

    /opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

    SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='45176' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='45176' ORDER BY w.bidid ASC

    /opt/clerks-staging/docroot/viewwant.php 1192 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=210521SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=21052

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=5108021SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=510802

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM seoclerks.members as m WHERE m.USERID=425531SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=42553

    /opt/clerks-staging/docroot/viewwant.php 1258 () ()

    SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    SELECT * FROM posts WHERE USERID=3207801SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=320780

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

    SELECT * FROM categories1SELECT * FROM categories

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

    select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * from categories_wanttotrade order by name asc

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories()

    SELECT * FROM seoclerks.members WHERE USERID='21052'1SELECT profilepicture FROM seoclerks.members WHERE USERID='21052'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='510802'1SELECT profilepicture FROM seoclerks.members WHERE USERID='510802'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='42553'1SELECT profilepicture FROM seoclerks.members WHERE USERID='42553'

    /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

    SELECT * FROM seoclerks.members WHERE USERID='320780'1SELECT profile_data FROM seoclerks.members WHERE USERID='320780'

    /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

    Invalid SQL

    count(*)sql1error_msg

    Expensive SQL

    Tuning the following SQL could reduce the server load substantially
    LoadCountSQLMaxMin

    Suspicious SQL

    The following SQL have high average execution times
    Avg TimeCountSQLMaxMin
    0.1162381SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID AND (A.tags LIKE '%Scrubb%' OR A.skills LIKE '%Scrubb%')0.1162380.116238
    0.1104221SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 45176 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Programming Images%' ) LIMIT 40.1104220.110422
    0.1018421SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Boostrap%') ORDER BY total_recommendations desc LIMIT 0,400.1018420.101842