SEOClerks

Personalization site in php

Personalization site in php

Pay close attention !!
My site is all in php
My website is this very http://www.bompreco.ninja/ the site to be customized so you can stay almost equal to this pescariaurbana.net

However my website will have to stay with 1100px wide

Need to modify the site to become more beautiful and elegant!
The mainly need customer panel that the customer panel menu is different prettier.

Also need to stand at the end of payment is personalized so that it is not the same but much more professional type of pescariaurbana.net/carrinho/ site

I also want to bring up the option of esolher the amount of products you want to buy at the end of the payment.

I would like to change the site menu let more professional
I would like to have a page like this one http://www.pescariaurbana.net/rastrear-pedido/

I would persoanlizar popup from my store to be equal to this http://i.imgur.com/R0X4eNE.png

The area adiministrador not need to change anything!

My store allows only buy if you are registered like to change that!
I would like the people can register at the time of purchase.

See what needs to be persoanlizado.

The menu
I need the shopping cart at the end of the payment be like this
The customer panel
Creating a page like this http://www.pescariaurbana.net/rastrear-pedido/
Coloar more link in the main menu
Leave my most elegant of categories and the entire site


Requirements

The site will have to be on the same professional level of this site pescariaurbana the pages of my published site and offers will have to be almost the same as this is pescariaurbana.net site

The panel the customer will have to be all modified so that it is at least similar to that pescariaurbana.net site

If you really are a profssional in programming please make your offer, if not please do not bother me is !!

I need a person who really understands programming


Skills Required

Programming Java Php Html

Bids

will do everything to your requirement which you have said

hello sir,

i am ready for works.

thanks

Bid On Listing Created 11 years ago in Programming

Other jobs by georlandio

Order Now
Process Time: 0.44417405128479

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='20886' 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='20886' AND A.category=B.CATID AND A.USERID=C.USERID

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

SELECT * FROM seoclerks.members_recommendations WHERE USERID=73019 AND status=1 ORDER BY MRID DESC limit 11SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations WHERE USERID=73019 AND status=1 ORDER BY MRID DESC limit 1

/opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() ()

SELECT * FROM seoclerks.members WHERE USERID='462526'1SELECT username FROM seoclerks.members WHERE USERID='462526'

/opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() ()

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

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

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

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

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

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

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='20886' 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='20886' 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='20886'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='20886'

/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='20886' 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='20886' ORDER BY w.bidid ASC

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

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

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

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

/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=730191SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=73019

/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='16942'1SELECT profilepicture FROM seoclerks.members WHERE USERID='16942'

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

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

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

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

/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.1349121SELECT 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 '%give%' OR A.skills LIKE '%give%')0.1349120.134912
0.1315421SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 20886 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Programming Java Php Html%' ) LIMIT 40.1315420.131542
0.1059541SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Human_capacity_development%') ORDER BY total_recommendations desc LIMIT 0,400.1059540.105954