global $s_companyid,$s_ordertoken,$s_dbhost,$s_dbuser,$s_dbpw,$s_dbname,$server,$mlink; $s_companyid = $_GET['cid']; $s_ordertoken = $_GET['ot']; if ($s_companyid == "" || $s_ordertoken == "") { die('Missing Company ID or Token'); } //DATABASE ACCESS //$db_database = "rtanner2_software"; //$db_username = "rtanner2_32"; //$db_password = "gf2m7SEN"; //$db_host = "localhost"; $db_database = 'axleking_software'; $db_username = 'axleking_wpuser'; $db_password = 'Ak0733.com!!'; $db_host = '103.120.48.171'; //CONNECT TO DATABASE $mlink = mysqli_connect($db_host,$db_username,$db_password,$db_database); if (!$mlink) { die ("Could not connect to mySQL server."); } if (!mysqli_select_db ($mlink,$db_database)) { die ("Could not open database $db_database." . mysqli_error() ); } //Now just query all live companies $lcsql = "select s_companyid,s_dbserver,s_dbname,s_dbuser,AES_DECRYPT(s_dbpw,'ih8SIN2237') AS s_dbpw,s_creplyemail,s_creceiptlogo,s_cwarranty,s_curl,s_cwurl,s_cphone,s_cfax,s_corderemail,s_cemail,s_ceshost,s_cesport,s_cesuser, AES_DECRYPT(s_cespw,'ih8SIN2237') as s_cespw from master where s_companyid =$s_companyid and s_ordertoken = '$s_ordertoken' and live = 1 limit 1"; $uresult = mysqli_query($mlink,$lcsql); if (mysqli_num_rows($uresult) < 1) { die("Invalid Company Entry or Token Value"); } $urow=mysqli_fetch_array($uresult); global $s_corderemail,$s_cphone,$s_cfax,$s_curl,$s_cwurl,$s_creceiptlogo,$s_cwarranty,$s_corderemail,$ulink; $s_corderemail = $urow['s_corderemail']; $s_cphone = $urow['s_cphone']; $s_cfax = $urow['s_cfax']; $s_curl = $urow['s_curl']; $s_cwurl = $urow['s_cwurl']; $s_corderemail = $urow['s_corderemail']; $s_creceiptlogo = $urow['s_creceiptlogo']; $s_cwarranty= $urow['s_cwarranty']; $db_username = $urow['s_dbuser']; //"rtanner2_16"; $db_password = $urow['s_dbpw']; //"kGE4i4Et"; $db_database = $urow['s_dbname'] ;//"rtanner2_PAIR3"; $db_host= $urow['s_dbserver'] ; $ulink = mysqli_connect($db_host,$db_username,$db_password,$db_database); if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit; } // connect to user database now mysqli_select_db($ulink,$db_database); ?>