1) Need to change endpoing for Authorize and need to change silent post url in authorize account:
/public_html/payment-gateways/authrize.php
/public_html/payment-gateways/ajax-authrize.php

Card Number:- 4111111111111111  Expiration Date: 02/20  CSV: 865

2) Need to change endpoing for PayPal:
PayPal:
Use This PayPal Email and password to test PayPal Payment:
User: heltpers23@gmail.com  Pass: pers@123
Business Account: hbusiness@gmail.com

3) Change PayPal ipn and pdt url from paypal account.

4) Change order URl
<form name="write_us" method="POST" action="contactsubmit.php">


++++++++++++++++++++++++++++++++++++++++++++++++++++++
SiteLock: 
User: HeltonTeahan123
Pass: locSit@23

++++++++++++++++++++++++++++++++
DATABASE QUERIES
+++++++++++++++++++++++++++++++
GET AND DELETE all recrods from WHEELS_NEW which are not exist in rest tables

SELECT w.* FROM wheels_new w LEFT OUTER JOIN wheels_info wi ON (w.id = wi.wheel_id) WHERE wi.wheel_id is null ORDER BY w.model

DELETE w FROM wheels_new w LEFT OUTER JOIN wheels_info wi ON (w.id = wi.wheel_id) WHERE wi.wheel_id is null
____________________________________________
GET AND DELETE NOT AVAILABLE PCDS
SELECT pcd.* from wheels_sub_info as wsi LEFT OUTER JOIN wheelpcds as pcd on pcd.offsetid = wsi.pid WHERE pcd.offsetid IS NULL

DELETE pcd from wheels_sub_info as wsi LEFT OUTER JOIN wheelpcds as pcd on pcd.offsetid = wsi.pid WHERE pcd.offsetid IS NULL

____________________________________________
DELETE WHEELS_INFO if no record found in WHEEL_SUB_PRICE_INFO Table
SELECT wi.id, wi.wheel_id from wheels_info wi left outer join wheel_sub_price_info wspi on wi.id = wspi.size_id  where wspi.size_id  is null
DELETE wi from wheels_info wi left join wheel_sub_price_info wspi on wi.id = wspi.size_id where wspi.size_id is null

____________________________________________
GET STAGGERED WHEELS
SELECT ws.* FROM wheels_staggared AS ws INNER JOIN wheels_info AS wi ON (ws.wSizeid = wi.id) INNER JOIN wheels_new AS w ON (wi.wheel_id = w.id) INNER JOIN wheels_brand_price AS wbp ON (w.brand_id = wbp.id) WHERE wbp.brand_name = 'American Racing Forged' ORDER BY `finish_type` ASC

____________________________________________
DELETE RECORDS FROM STAGGERED TABLE WHICH ARE NOT AVAILABLE
SELECT ws.* FROM wheels_staggared ws WHERE ws.wSizeid NOT IN (SELECT id FROM wheels_info)
DELETE ws FROM wheels_staggared ws WHERE ws.wSizeid NOT IN (SELECT id FROM wheels_info)