/** * This function is used to show the currency * * * @return string */ function displayEnabledCurrencies() { $sql = "SELECT a.id,a.currency_name,a.currency_code,a.currency_tocken,a.default_currency,b.cou_name as country_name FROM currency_master_table a, country_table b WHERE a.status=1 AND a.country_code=b.cou_code"; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DCurrencySettings::displayEnabledCurrencies($obj->records); }
/** * Function get the list of categories available in the database * * * @return string */ function showCategory() { $sql = "select b.category_parent_id as parent ,b.category_id as child,a.category_name as parent_name,b.category_name from category_table a right outer join category_table b on a.category_id = b.category_parent_id "; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DCategoryList::displayCategory($obj->records); }
/** * Function generates a file with category details . * * @param string $targetpath * @return file */ function createCategoryTSVFile($targetpath) { $sql = "SELECT title,description,concat('?do=prodetail&action=showprod&prodid=',product_id)as destn FROM `products_table` order by product_id"; $obj = new Bin_Query(); $obj->executeQuery($sql); $arr = $obj->records; $str = "Campaign\tAd Group\tHeadline\tDescription Line 1\tDescription Line 2\tDisplay URL\tDestination URL\tCampaign Status\tAdGroup Status\tCreative Status"; $fp = fopen($targetpath, 'w'); for ($i = 0; $i < count($arr); $i++) { $campaign = "\nCampaign #1"; $addGroup = "\tAd Group #1"; $headline = "\t" . $arr[$i]['title']; $Desc1 = "\t" . substr(str_replace("\r\n", "", strip_tags($arr[$i]['description'])), 0, 24); $Desc2 = "\t" . substr(str_replace("\r\n", "", strip_tags($arr[$i]['description'])), 25, 50); $DispURL = "\t" . $_SERVER['SERVER_NAME']; $DestURL = "\t" . $_SERVER['SERVER_NAME'] . '/' . $arr[$i]['destn']; $CampStat = "\tActive"; $AdGroupStat = "\tActive"; $CreativeStat = "\tActive"; $str .= $campaign . $addGroup . $headline . $Desc1 . $Desc2 . $DispURL . $DestURL . $CampStat . $AdGroupStat . $CreativeStat; } fwrite($fp, $str); fclose($fp); print_r($str); //exit(); }
/** * Function generates the data need for showing the best selling products * * * @return string */ function showBestSellingProducts() { $pagesize = 25; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sql = "SELECT orders.product_id, sum( orders.product_qty ) AS cnt , prod.title , prod.category_id , prod.thumb_image, cat.category_name, prod.msrp FROM order_products_table orders , products_table prod , category_table cat WHERE orders.product_id=prod.product_id and prod.category_id=cat.category_id and prod.intro_date <= now() AND status=1 GROUP BY orders.product_id ORDER BY cnt DESC"; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $total = ceil($query->totrows / $pagesize); include_once 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $sql1 = "SELECT orders.product_id, sum( orders.product_qty ) AS cnt , prod.title , prod.category_id , prod.thumb_image, cat.category_name, prod.msrp FROM order_products_table orders , products_table prod , category_table cat WHERE orders.product_id=prod.product_id and prod.category_id=cat.category_id and prod.intro_date <= now() AND status=1 GROUP BY orders.product_id ORDER BY cnt DESC LIMIT {$start},{$end}"; $query1 = new Bin_Query(); if ($query1->executeQuery($sql1)) { return Display_DBestSellingProducts::showBestSellingProducts($query1->records, $this->data['paging'], $this->data['prev'], $this->data['next']); } } else { return "No Best Selling Products Found"; } }
/** * This function is used to get the user product review * * . * * @return string */ function showProductReview() { include 'classes/Display/DUserAccount.php'; $userid = $_SESSION['user_id']; $pagesize = 10; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sqlselect = "SELECT date_format(review_date,'%e/%c/%Y') as rdate,b.title,review_caption FROM product_reviews_table a,products_table b where a.product_id=b.product_id and a.user_id=" . $userid; $query = new Bin_Query(); $query->executeQuery($sqlselect); $total = ceil($query->totrows / $pagesize); include 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $sqlselect = "SELECT a.product_id,date_format(review_date,'%e/%c/%Y') as rdate,b.title,review_caption,rating,case when review_status=1 then 'Active' else 'In Active' end as rstatus FROM product_reviews_table a,products_table b where a.product_id=b.product_id and a.user_id=" . $userid . " LIMIT {$start},{$end}"; $obj = new Bin_Query(); $obj->executeQuery($sqlselect); return Display_DUserAccount::showProductReview($obj->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start); }
/** * This function is used to get the rss * * . * * @return XML data */ function showRss() { $sql = " SELECT a.product_id, a.title,a.description, a.thumb_image, a.msrp, a.intro_date,b.soh,sum(c.rating)/count(c.user_id) as\n\t\t\trating\tFROM products_table a INNER JOIN\tproduct_inventory_table b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE datediff( CURDATE( ) , a.intro_date ) <=100 group by a.product_id order by a.intro_date desc"; $query = new Bin_Query(); $query->executeQuery($sql); return Core_CRss::writeXML($query->records); }
/** * This function is used to show the all new product page. * * * * @return string */ function showAllNew() { include 'classes/Display/DUserAccount.php'; $pagesize = 8; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sql = " SELECT a.product_id, a.title, a.thumb_image, a.msrp, a.intro_date,b.soh,sum(c.rating)/count(c.user_id) as\n\t\t\trating FROM products_table a INNER JOIN\tproduct_inventory_table b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id"; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $total = ceil($query->totrows / $pagesize); include 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $sql = " SELECT a.product_id, a.title, a.thumb_image, a.msrp, a.intro_date,b.soh,sum(c.rating)/count(c.user_id) as\n\t\t\trating \tFROM products_table a INNER JOIN product_inventory_table b ON a.product_id=b.product_id left join product_reviews_table c on a.product_id=c.product_id WHERE a.intro_date <= '" . date('Y-m-d') . "' and a.status=1 group by a.product_id order by a.intro_date desc limit {$start},{$end}"; $obj = new Bin_Query(); if ($obj->executeQuery($sql)) { return Display_DUserAccount::showAllNew($obj->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start); } else { return 'No Products Found!'; } } else { return 'No Products Found!'; } }
/** * Function gets the most search keyword frequency from the database * * * @return string */ function showMostSearchedKeywords() { $pagesize = 25; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sql = "select search_tag as keyword,search_count as cnt from search_tags_table order by search_count desc "; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $total = ceil($query->totrows / $pagesize); include_once 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $sql1 = "select search_tag as keyword,search_count as cnt from search_tags_table order by search_count desc LIMIT {$start},{$end}"; $query1 = new Bin_Query(); if ($query1->executeQuery($sql1)) { return Display_DMostSearchedKeywords::showMostSearchedKeywords($query1->records, $this->data['paging'], $this->data['prev'], $this->data['next']); } } else { return "No Contents Found"; } }
/** * This function is used to get the all news from db * * * @return string */ function showNewsPage() { $pagesize = 10; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sql = "SELECT news_title,DATE_FORMAT(news_date,'%M %D %Y')AS date,news_desc from news_table where news_status=1 order by news_date desc"; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $total = ceil($query->totrows / $pagesize); include 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; $sql = "SELECT news_title,DATE_FORMAT(news_date,'%M %D %Y')AS date,news_desc from news_table where news_status=1 order by news_date desc limit {$start},{$end}"; $obj = new Bin_Query(); if ($obj->executeQuery($sql)) { return Display_DNews::showNewsPage($obj->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start); } else { return Core_CLanguage::_(NO_NEWS_FOUND); } } else { return Core_CLanguage::_(NO_NEWS_FOUND); } }
/** * Function gets the latest customer details from the database * * * @return string */ function dispLatestCustomer() { $sql = 'select a.user_display_name,a.user_email,a.user_doj,c.orders_status_name,b.order_total from users_table a left outer join orders_table b on b.customers_id=a.user_id left outer join orders_status_table c on b.orders_status=c.orders_status_id order by a.user_id desc limit 0,10'; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DLatestOrders::dispLatestCustomer($obj->records); }
/** * Function updates the changes made in the site moto details into the table * * * @return string */ function updatesiteSettings() { $remove = array("\\n", "\\r"); $_POST['google_analytics'] = str_replace($remove, "", $_POST['google_analytics']); $_POST['customer_header'] = str_replace($remove, "", $_POST['customer_header']); if ($_FILES['site_logo']['name'] != '') { $site_logo_path = 'images/logo/' . date("YmdHis") . '_' . $_FILES['site_logo']['name']; if (move_uploaded_file($_FILES['site_logo']['tmp_name'], '../' . $site_logo_path)) { $site_logo = $site_logo_path; } } else { $site_logo = $_POST['site_logo']; } $sql = "UPDATE admin_settings_table SET \n\t\t\tcustomer_header ='" . trim($_POST['customer_header']) . "' ,\n\t\t\tsite_logo='" . $site_logo . "',\n\t\t\tgoogle_analytics='" . trim($_POST['google_analytics']) . "',\n\t\t\ttime_zone='" . trim($_POST['time_zone']) . "',\n\t\t\tsite_moto='" . trim($_POST['site_moto']) . "',\t\t\t\n\t\t\tmeta_kerwords='" . stripslashes(trim($_POST['meta_kerwords'])) . "',\n\t\t\tmeta_description='" . stripslashes(trim($_POST['meta_description'])) . "'\n\t\t\twhere set_id='1'"; $query = new Bin_Query(); if ($query->updateQuery($sql)) { $_SESSION['msgSitemoto'] = '<div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> Site settings has been updated successfully </div>'; } else { $_SESSION['msgSitemoto'] = '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button>Site settings has not been updated successfully</div>'; } header('Location:?do=site'); exit; }
/** * This function is used to show the faq page * * * @return string */ function showFaq() { $pagesize = 10; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sql = "select * from faq_table"; $query = new Bin_Query(); if ($query->executeQuery($sql)) { $total = ceil($query->totrows / $pagesize); include 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; } $sql = "select * from faq_table"; $query = new Bin_Query(); $query->executeQuery($sql); return Display_DFaq::listFaq($query->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start); }
/** * Function checks whether the user exists in the database * * * @return array */ function checkUSer() { /** * * Here database query comes * */ $sql = "SELECT * FROM user_registration WHERE user_name='" . mysql_escape_string($_POST['usernametxt']) . "' and user_password = '******'passwordtxt'])) . "'"; $obj = new Bin_Query(); if ($obj->executeQuery($sql)) { $arr = $obj->totrows; print_r($arr); } if ($arr == 1) { if ($obj->records[0]['user_status'] == 1) { $_SESSION['user_id'] = $obj->records[0]['user_id']; $_SESSION['username'] = $obj->records[0]['user_name']; return "1"; } else { if ($obj->records[0]['user_status'] == 0) { $_SESSION['user_id'] = $obj->records[0]['user_id']; $_SESSION['username'] = $obj->records[0]['user_name']; return "0"; } else { if ($obj->records[0]['user_status'] == 2) { return "Your are Suspended by Admin"; } } } } else { return "Invalid Username and Password"; } }
/** * This function is used to get the account dashboard information * * . * * @return string */ function showDashboard() { include 'classes/Display/DUserAccount.php'; $pagesize = 10; if (isset($_GET['page'])) { $start = trim($_GET['page'] - 1) * $pagesize; $end = $pagesize; } else { $start = 0; $end = $pagesize; } $total = 0; $sqlselect = "SELECT a.customers_id,a.orders_id,date_format(a.date_purchased,'%e/%c/%Y') as pdate,b.orders_status_name,c.user_display_name,a.order_total as total,a.currency_id FROM `orders_table` a,orders_status_table b,users_table c,order_products_table d where a.orders_status=b.orders_status_id and a.customers_id=c.user_id and a.orders_id=d.order_id and a.customers_id=" . $_SESSION['user_id'] . " group by a.orders_id order by a.date_purchased desc"; $query = new Bin_Query(); if ($query->executeQuery($sqlselect)) { $total = ceil($query->totrows / $pagesize); include 'classes/Lib/Paging.php'; $tmp = new Lib_Paging('classic', array('totalpages' => $total, 'length' => 10), 'pagination'); $this->data['paging'] = $tmp->output; $this->data['prev'] = $tmp->prev; $this->data['next'] = $tmp->next; } $sqlselect = "SELECT a.customers_id,a.orders_id,date_format(a.date_purchased,'%e/%c/%Y') as pdate,b.orders_status_name,c.user_display_name,a.order_total as total,a.currency_id,e.id,e.currency_tocken FROM `orders_table` a,orders_status_table b,users_table c,order_products_table d,currency_master_table e where a.orders_status=b.orders_status_id and a.customers_id=c.user_id and a.orders_id=d.order_id and a.customers_id=" . $_SESSION['user_id'] . " and e.id=a.currency_id group by a.orders_id order by a.date_purchased desc LIMIT {$start},{$end}"; $sqlUser = '******' . $_SESSION['user_id']; $sqlNews = "SELECT user_id,b.status FROM `users_table` a,newsletter_subscription_table b where a.user_email=b.email and a.user_status=1 and a.user_id=" . $_SESSION['user_id']; $obj = new Bin_Query(); $objuser = new Bin_Query(); $objNews = new Bin_Query(); $obj->executeQuery($sqlselect); $objuser->executeQuery($sqlUser); $objNews->executeQuery($sqlNews); return Display_DUserAccount::showDashboard($obj->records, $objuser->records, $objNews->records, $this->data['paging'], $this->data['prev'], $this->data['next'], $start); }
/** * Function gets all the header link from the table * * * @return string */ function showHeaderLink() { $sql = "SELECT * FROM header_link_table "; $query = new Bin_Query(); $query->executeQuery($sql); return Display_DHeaderSettings::showHeaderLink($query->records); }
/** * This function is used to get the rating from db * @param integer $productid * . * * @return array */ function disRates($productid) { $sql = 'select min(msrp) as msrp from msrp_by_quantity_table where product_id =' . $productid; $obj = new Bin_Query(); $obj->executeQuery($sql); $val = $obj->records; return $val[0]['msrp']; }
/** * Function gets the order status details from the database * * * @return string */ function editOrderStatus() { $id = $_GET['id']; $sql = 'select * from orders_status_table where orders_status_id=' . $id; $obj1 = new Bin_Query(); $obj1->executeQuery($sql); return Display_DOrderStatusManagement::editOrderStatus($obj1->records); }
/** * Function gets the contents from the html contents table. * * * @return string */ function dispCategory() { $id = 4; $sql = "select * from html_contents_table where html_content_name='Category Content'"; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DDisplayCategoryList::dispCategory($obj->records); }
/** * This function is used to get the map for category * * @return HTML data */ function showMap() { include 'classes/Display/DSiteMap.php'; $sql = "select category_id,category_name from category_table where category_parent_id=0 and category_status=1"; $query = new Bin_Query(); $query->executeQuery($sql); return Display_DSiteMap::showMap($query->records); }
/** * Function to find the category id * @param integer $productid * @return string */ function findCategoryid($productid) { $sql = 'select category_id from products_table where product_id=' . $productid; $obj = new Bin_Query(); $obj->executeQuery($sql); $val = $obj->records[0]['category_id']; return $val; }
/** * This function is used to get the price compare page * * . * * @return string */ function showPriceComparePage() { $obj = new Bin_Query(); $sql = "select set_value from admin_settings_table where set_name='www.pricerunner.com Affiliate ID'"; if ($obj->executeQuery($sql)) { $pricerunnerid = $obj->records[0]['set_value']; } $output = Display_DPriceCompare::showPriceComparePage($pricerunnerid); return $output; }
/** * Function updates the contact us details into the table * * * @return string */ function updateContactUs() { $sql = "UPDATE contactus_table SET contactus='" . $_POST['contactus'] . "' Where id=1"; $query = new Bin_Query(); if ($query->updateQuery($sql)) { return '<div class="success_msgbox">Contact Us Information Updated Successfully</div>'; } else { return '<div class="error_msgbox">Content Not Updated </div>'; } }
/** * Function updates the copyrights details into the table * * * @return string */ function updateCopyrights() { $sql = "UPDATE admin_settings_table SET set_value='" . $_POST['copyrights'] . "' Where set_name='Copy Rights'"; $query = new Bin_Query(); if ($query->updateQuery($sql)) { return '<div class="success_msgbox">Copy right Information Updated Successfully</div>'; } else { return '<div class="error_msgbox">Copyright Not Updated </div>'; } }
/** * Function gets the count of products from the database with their brand details. * * * @return string */ function dispBrandWithCount() { // $catid=$_POST['id']; // $catid=$_GET['id']; $catid = 2; $sql = 'Select brand, count(*)as cnt from products_table where category_id=' . $catid . ' group by brand having count(*) > 0 '; $obj = new Bin_Query(); $obj->executeQuery($sql); return Display_DNarrowSearch::dispBrandWithCount($obj->records); }
/** * Function selects the data from the table need for generating auto complete popup window. * * * @return xml */ function autoComplete() { $aUsers = array(); $sql = "SELECT title FROM products_table"; $obj = new Bin_Query(); $obj->executeQuery($sql); $count = count($obj->records); for ($i = 0; $i < $count; $i++) { $aUsers[] = $obj->records[$i]['title']; } $input = strtolower($_GET['input']); $len = strlen($input); $limit = isset($_GET['limit']) ? (int) $_GET['limit'] : 0; $aResults = array(); $count = 0; if ($len) { for ($i = 0; $i < count($aUsers); $i++) { // had to use utf_decode, here // not necessary if the results are coming from mysql // if (strtolower(substr(utf8_decode($aUsers[$i]), 0, $len)) == $input) { $count++; $aResults[] = array("id" => $i + 1, "value" => htmlspecialchars($aUsers[$i])); } if ($limit && $count == $limit) { break; } } } header("Expires: Mon, 26 Jul 1997 05:00:00 GMT"); // Date in the past header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified header("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1 header("Pragma: no-cache"); // HTTP/1.0 if (isset($_REQUEST['json'])) { header("Content-Type: application/json"); echo "{\"results\": ["; $arr = array(); for ($i = 0; $i < count($aResults); $i++) { $arr[] = "{\"id\": \"" . $aResults[$i]['id'] . "\", \"value\": \"" . $aResults[$i]['value'] . "\"}"; } echo implode(", ", $arr); echo "]}"; } else { header("Content-Type: text/xml"); echo "<?xml version=\"1.0\" encoding=\"utf-8\" ?><results>"; for ($i = 0; $i < count($aResults); $i++) { echo "<rs id=\"" . $aResults[$i]['id'] . "\" >" . $aResults[$i]['value'] . "</rs>"; } echo "</results>"; } }
/** * Function updates the changes made in the time zone details into the database * * * @return string */ function updateTimeZone() { if ($_POST['timezone'] != '') { $sql = "UPDATE admin_settings_table SET set_value='" . $_POST['timezone'] . "' where set_name='Time Zone'"; $query = new Bin_Query(); if ($query->updateQuery($sql)) { return '<div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> <strong> well done !</strong> Timezone Updated to <b>' . $_POST['timezone'] . '</b> Successfully</div>'; } } }
/** * Function generates a excel product report for google base * * * @return file */ function googleProduct() { include "classes/Lib/excelwriter.inc.php"; $excel = new ExcelWriter("GoogleBase_Product_Feed.xls"); if ($excel == false) { echo $excel->error; } $myArr = array("Product Id", "Product Title", "Description", "Product Price", "Link", "Brand", "Image Link", "Weight"); $excel->writeLine($myArr); $sql = 'select product_id,title,description,price,brand,thumb_image,weight from products_table'; $obj = new Bin_Query(); if ($obj->executeQuery($sql)) { $cnt = count($obj->records); for ($i = 0; $i < $cnt; $i++) { $product_id = $obj->records[$i]['product_id']; $title = $obj->records[$i]['title']; $description = strip_tags($obj->records[$i]['description']); $price = $obj->records[$i]['price']; $brand = $obj->records[$i]['brand']; $thumb_image = $obj->records[$i]['thumb_image']; $image_link = $_SERVER['SERVER_NAME'] . '/' . $thumb_image; $weight = $obj->records[$i]['weight']; $link = $_SERVER['SERVER_NAME'] . '/?do=prodetail&action=showprod&id=' . $product_id; $excel->writeRow(); $excel->writeCol($product_id); $excel->writeCol($title); $excel->writeCol($description); $excel->writeCol($price); $excel->writeCol($link); $excel->writeCol($brand); $excel->writeCol($image_link); $excel->writeCol($weight); } $excel->close(); } if (strpos($_SERVER['USER'], 'MSIE')) { // IE cannot download from sessions without a cache header('Cache-Control: public'); } else { //header("Cache-Control: no-cache, must-revalidate"); header("Cache-Control: no-cache"); } $file = "GoogleBase_Product_Feed.xls"; //chmod ($file, 0755); header("Pragma: no-cache"); header("Content-Type: php/doc/xml/html/htm/asp/jpg/JPG/sql/txt/jpeg/gif/bmp/png/xls/csv/x-ms-asf\n"); header("Connection: close"); header("Content-Disposition: attachment; filename=" . $file . "\n"); header("Content-Transfer-Encoding: binary\n"); header("Content-length: " . (string) filesize("{$file}")); $fd = fopen($file, "rb"); fpassthru($fd); }
/** * This function is used to insert the site hit count * * * @return string */ function setCount() { $ip = Core_CHitCounter::getRealIpAddr(); $sql = "select * from site_hit_counter_table where ip_address='" . $ip . "' and date(visited_on)='" . date("Y-m-d") . "'"; $query = new Bin_Query(); $query->executeQuery($sql); if (empty($query->records)) { $sql = "insert into site_hit_counter_table (ip_address,visited_on) values('" . $ip . "','" . date("y.m.d H.i.s") . "')"; $query = new Bin_Query(); $query->executeQuery($sql); } }
/** * Function updates the custom header details into the table * * * @return string */ function updateCustomHeader() { $sql = "update admin_settings_table set set_value='" . trim($_POST['headerContent']) . "' where set_name='Custom Header'"; $obj = new Bin_Query(); if ($obj->updateQuery($sql)) { return '<div class="alert alert-success"> <button type="button" class="close" data-dismiss="alert">×</button> <strong> well done !</strong> Custom Header changed Successfully</div>'; } else { return '<div class="alert alert-error"> <button type="button" class="close" data-dismiss="alert">×</button> Unable to change Custom Header</div>'; } }
/** * Function adds an HTML Content value into the database * * * @return string */ function addContent() { if (trim($_POST['contentname']) != '' && trim($_POST['htmlcontent']) != '') { $content = $_POST['contentname']; $sql = "INSERT INTO html_contents_table (html_content_name,html_content) VALUES ('" . $content . "','" . $_POST['htmlcontent'] . "')"; $query = new Bin_Query(); if ($query->updateQuery($sql)) { return '<div class="success_msgbox">Content Added Successfully</div>'; } } else { return '<div class="error_msgbox">Field Can not be Blank</div>'; } }