include('config.php'); $system_id = 0; // // System id // if(!isset($_COOKIE['system_id'])) { // $fqdn = $_SERVER['SERVER_NAME']; // $query1 = "SELECT `system_id` FROM `system` WHERE `url` = '$fqdn'"; // $row1 = mysqli_fetch_row(mysqli_query($conn, $query1)); // if ($row1[0] > 0) { // $system_id = $row1[0]; // setcookie("system_id", $system_id, time() + 3600 * 1440); // } // }else{ // $system_id = $_COOKIE['system_id']; // } $fqdn = $_SERVER['SERVER_NAME']; $systemIdQuery = "SELECT `system_id` FROM `system` WHERE `url` = '$fqdn'"; $systemIdQueryRow = mysqli_fetch_row(mysqli_query($conn, $systemIdQuery)); if ($systemIdQueryRow[0] > 0) { $system_id = $systemIdQueryRow[0]; } // Social media Keys global $fb_key,$google_key; $query = "SELECT `fb_app_id` FROM system WHERE `system_id` = '$system_id'"; $row = mysqli_fetch_row(mysqli_query($conn, $query)); if ($row[0] > 0) { $fb_key = $row[0]; }else{ $fb_key = "Something went to wrong"; } $query1 = "SELECT `google_client_id` FROM system WHERE `system_id` = '$system_id'"; $row1 = mysqli_fetch_row(mysqli_query($conn, $query1)); if ($row1[0] > 0) { $google_key = $row1[0]; }else{ $google_key = "Something went to wrong"; } // Site Info global $title, $welcome_note, $name_full, $address, $tel1, $tel2, $fb_link, $insta_link, $twitter_link, $yt_link, $payment_opt_img1, $payment_opt_img2, $payment_opt_img3, $payment_opt_img4, $header_email, $header_tel; $payment_opt_img1 = 0; $payment_opt_img2 = 0; $payment_opt_img3 = 0; $payment_opt_img4 = 0; $query2 = "SELECT `title`,`welcome_note`,`name_full`,`address`,`tel1`,`tel2`,`fb_link`, `insta_link`, `twitter_link`, `yt_link`, `payment_opt_img1`, `payment_opt_img2`, `payment_opt_img3`, `payment_opt_img4`, `header_email`, `header_tel` FROM `company` WHERE `system_id` = '$system_id'"; $row2 = mysqli_fetch_row(mysqli_query($conn, $query2)); $title = $row2[0]; $welcome_note = $row2[1]; $name_full = $row2[2]; $address = $row2[3]; $tel1 = $row2[4]; $tel2 = $row2[5]; $fb_link = $row2[6]; $insta_link = $row2[7]; $twitter_link = $row2[8]; $yt_link = $row2[9]; $header_email = $row2[14]; $header_tel = $row2[15]; // var_dump($twitter_link); if($row2[10] == 1){ $payment_opt_img1 = 1; } if($row2[11] == 1){ $payment_opt_img2 = 1; } if($row2[12] == 1){ $payment_opt_img3 = 1; } if($row2[13] == 1){ $payment_opt_img4 = 1; } // var_dump($row2); // var_dump($payment_opt_img1); // var_dump($payment_opt_img2); // var_dump($payment_opt_img3); // var_dump($payment_opt_img4); // exit; ?>