public function getlastThread($topic_id) { global $mySession; $db = new Db(); $forumThread = $db->runQuery("select * from " . FORUM_THREADS . " inner join " . USERS . " on " . USERS . ".user_id = " . FORUM_THREADS . ".user_id where topic_id=" . $topic_id . " order by thread_id desc limit 1"); return $forumThread; }
public function init() { global $mySession; $db = new Db(); $ConfigData = $db->runQuery("select * from " . ADMINISTRATOR . " where admin_id='1'"); $SiteTitle = $ConfigData[0]['site_title']; $MetaDescription = $ConfigData[0]['site_description']; $MetaKeyword = $ConfigData[0]['site_keyword']; $AdminEmail = $ConfigData[0]['admin_email']; $PaypalEmail = $ConfigData[0]['paypal_email']; $welcomemessageC = $ConfigData[0]['welcomemessage']; $admin_name_value = $ConfigData[0]['admin_fullname']; $site_title = new Zend_Form_Element_Text('site_title'); $site_title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Site title is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($SiteTitle); $admin_name = new Zend_Form_Element_Text('admin_name'); $admin_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Admin name is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($admin_name_value); $site_description = new Zend_Form_Element_Text('site_description'); $site_description->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Site description is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($MetaDescription); $site_keyword = new Zend_Form_Element_Text('site_keyword'); $site_keyword->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Site keyword is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($MetaKeyword); $admin_email = new Zend_Form_Element_Text('admin_email'); $admin_email->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Administrator email is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required email")->setValue($AdminEmail); $paypal_email = new Zend_Form_Element_Text('paypal_email'); $paypal_email->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Paypal email address is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required email")->setValue($PaypalEmail); /*$currency_symbol= new Zend_Form_Element_Text('currency_symbol'); $currency_symbol->setRequired(true) ->addValidator('NotEmpty',true,array('messages' =>'Currency symbol is required.')) ->addDecorator('Errors', array('class'=>'error')) ->setAttrib("class","required") ->setValue($CurrencySymbol);*/ $welcomemessage = new Zend_Form_Element_Textarea('welcomemessage'); $welcomemessage->setAttrib("id", "elrte")->setAttrib("cols", "auto")->setAttrib("rows", "auto")->setValue($welcomemessageC); $this->addElements(array($site_title, $admin_name, $site_description, $site_keyword, $admin_email, $paypal_email, $welcomemessage)); }
public function saveProtype($dataForm, $ptyleId = "") { global $mySession; $db = new Db(); $data_update['ptyle_name'] = $dataForm['ptyle_name']; if ($ptyleId == "") { $chkQry = $db->runQuery("select * from " . PROPERTYTYPE . " where ptyle_name='" . mysql_escape_string(trim($dataForm['ptyle_name'])) . "'"); if ($chkQry != "" and count($chkQry) > 0) { //if Property Type Name is exists than return false / 0 // No Data Inserted return 0; } else { # If Property Type Name Not Already Exista. # Insert New Record Into Database $db->save(PROPERTYTYPE, $data_update); return 1; } } else { $chkQry = $db->runQuery("select * from " . PROPERTYTYPE . " where ptyle_name='" . mysql_escape_string(trim($dataForm['ptyle_name'])) . "' and ptyle_id!=" . $ptyleId); if ($chkQry != "" and count($chkQry) > 0) { return 0; } else { $condition = 'ptyle_id=' . $ptyleId; $result = $db->modify(PROPERTYTYPE, $data_update, $condition); return 1; } } }
public function init($stateId) { global $mySession; $db = new Db(); $CountryId = ""; $StateName = ""; if ($stateId != "") { $PageData = $db->runQuery("select * from " . STATE . " where state_id='" . $stateId . "'"); $CountryId = $PageData[0]['country_id']; $StateName = $PageData[0]['state_name']; } $CounyryArr = array(); $CounyryArr[0]['key'] = ""; $CounyryArr[0]['value'] = "- - Country - -"; $CounyryData = $db->runQuery("select * from " . COUNTRIES . " order by country_name"); if ($CounyryData != "" and count($CounyryData) > 0) { $i = 1; foreach ($CounyryData as $key => $CounyryValues) { $CounyryArr[$i]['key'] = $CounyryValues['country_id']; $CounyryArr[$i]['value'] = $CounyryValues['country_name']; $i++; } } $country_id = new Zend_Form_Element_Select('country_id'); $country_id->setRequired(true)->addMultiOptions($CounyryArr)->addValidator('NotEmpty', true, array('messages' => 'Country is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "required")->setValue($CountryId); $state_name = new Zend_Form_Element_Text('state_name'); $state_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'State Name is required.'))->addValidator('regex', true, array('pattern' => '/^[a-zA-Z\\-]+$/', 'messages' => array('regexNotMatch' => 'Please enter proper name and without space')))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($StateName); $this->addElements(array($country_id, $state_name)); }
public function saveCurrency($dataForm, $currencyId = "") { global $mySession; $db = new Db(); $data_update['currency_name'] = trim($dataForm['currency_name']); $data_update['currency_code'] = strtoupper(trim($dataForm['currency_code'])); $data_update['exchange_rate'] = $dataForm['exchange_rate']; $maxquery = $db->runQuery("select max(currency_order) as MAX from " . CURRENCY . " "); if ($currencyId == "") { $currencyId = 0; } $chkQry2 = $db->runQuery("select * from " . CURRENCY . " where currency_code='" . mysql_escape_string(trim($data_update['currency_code'])) . "' and currency_id!=" . $currencyId); if ($chkQry != "" and count($chkQry) > 0) { return 0; } else { if ($currencyId > 0) { $condition = 'currency_id=' . $currencyId; $db->modify(CURRENCY, $data_update, $condition); return 1; } else { $data_update['currency_order'] = $maxquery[0]['MAX'] + 1; $db->save(CURRENCY, $data_update); return 1; } } }
public function saveAttribute($dataForm, $attributeId = "") { global $mySession; $db = new Db(); $dataForm = SetupMagicQuotesTrim($dataForm); if ($attributeId == "") { $chkQry = $db->runQuery("select * from " . ATTRIBUTE . " where attribute_name like '%" . mysql_escape_string(trim($dataForm['attribute_name'])) . "' "); if ($chkQry != "" and count($chkQry) > 0) { //if Same Question exists than return false / 0 // No Data Inserted return 0; } else { $data = array(); $data['attribute_name'] = $dataForm['attribute_name']; $data['attribute_status'] = $dataForm['attribute_status']; $db->save(ATTRIBUTE, $data); $latestId = $db->lastInsertId(); return 1; } } else { $chkQry = $db->runQuery("select * from " . ATTRIBUTE . " where attribute_name like '%" . mysql_escape_string(trim($dataForm['attribute_name'])) . "' and attribute_id != '" . $attributeId . "' "); if ($chkQry != "" and count($chkQry) > 0) { //if Same Question exists than return false / 0 // No Data Inserted return 0; } else { $data = array(); $data['attribute_name'] = $dataForm['attribute_name']; $data['attribute_status'] = $dataForm['attribute_status']; $condition = "attribute_id = " . $attributeId; $db->modify(ATTRIBUTE, $data, $condition); return 1; } } }
public function init() { global $mySession; $db = new Db(); $myControllerName = Zend_Controller_Front::getInstance()->getRequest()->getControllerName(); $myActionName = Zend_Controller_Front::getInstance()->getRequest()->getActionName(); $this->view->myControllerName = $myControllerName; $this->view->myActionName = $myActionName; $defineData = $db->runQuery("select * from " . ADMINISTRATOR . " where admin_id='1'"); if (isset($mySession->LoggedUserId) and @$mySession->LoggedUserId != "") { $userData = $db->runQuery("select * from " . USERS . " where user_id='" . $mySession->LoggedUserId . "'"); $this->view->userData = $userData; } if (!defined("ADMIN_EMAIL")) { define("ADMIN_EMAIL", array_key_exists('admin_email', $defineData[0]) ? $defineData[0]['admin_email'] : ''); } if (!defined("PAYPAL_TOKEN")) { define("PAYPAL_TOKEN", array_key_exists('paypal_token', $defineData[0]) ? $defineData[0]['paypal_token'] : ''); } if (!defined("PAYPAL_EMAIL")) { define("PAYPAL_EMAIL", array_key_exists('paypal_email', $defineData[0]) ? $defineData[0]['paypal_email'] : ''); } if (!defined("SITE_NAME")) { define("SITE_NAME", array_key_exists('site_title', $defineData[0]) ? $defineData[0]['site_title'] : 'TeeshirtSCRIPT'); } //define("PRICE_SYMBOL",$defineData[0]['currency_symbol']); $Explode = explode("/", $_SERVER['REQUEST_URI']); $SName = $Explode[count($Explode) - 1]; $ChkCampaign = $db->runQuery("select * from " . LAUNCHCAMPAIGN . " where trim(url)='" . urldecode($SName) . "' "); if ($ChkCampaign != "" and count($ChkCampaign) > 0 && $myControllerName == "error" && $myActionName == "error") { // Routing did not came up with a page, no problem as the URL is related to a campaign URL $myform1 = new Form_Buy(); //$this->view->myform1=$myform1; $sizes = $db->runQuery("select * from " . TSHIRT_SIZE); $this->view->sizes = $sizes; $this->view->CampaignData = $ChkCampaign; include "application/layouts/scripts/campaign.phtml"; // Load Campaign view! exit; } if (isset($mySession->TeeLoggedID) and @$mySession->TeeLoggedID != "") { if ($myControllerName == "signup" || $myControllerName == "login" || $myControllerName == "forgotpassword") { $this->_redirect(APPLICATION_URL . 'myaccount/profile'); } } else { if ($myControllerName == "myaccount" || $myControllerName == "launchcampaign" && $myActionName == "edit") { $this->_redirect(APPLICATION_URL . 'index/index'); } } if ($myControllerName == "launchcampaign") { if (stripslashes(array_key_exists('recreation_product', $_POST) ? $_POST['recreation_product'] : '') != '') { $mySession->recreation_product = stripslashes($_POST['recreation_product']); } if (stripslashes(array_key_exists('priceValueKM', $_POST) ? $_REQUEST['priceValueKM'] != '' : '') && stripslashes(array_key_exists('idValueKM', $_POST) ? $_REQUEST['idValueKM'] != '' : '')) { $mySession->priceValueKM = $_REQUEST['priceValueKM']; $mySession->selectedIdValueKM = $_REQUEST['idValueKM']; } } $this->_helper->layout->setLayout('main'); }
public function init($review_id) { global $mySession; $db = new Db(); $airport1_value = ""; $review_date_value = ""; $property_value = ""; $status_value = ""; $review_value = ""; $description_value = ""; $amenityArr = $db->runQuery("select * from " . OWNER_REVIEW . " where review_status = '1' "); if ($review_id != "") { $pptyData = $db->runQuery("select guest_name, property_title, review_date, location, review_status, check_in, review, \n\t\t\t\t\t\t\t\t\t " . OWNER_REVIEW . ".rating as rating, headline, comment from " . OWNER_REVIEW . " \n\t\t\t\t\t\t\t\t\t inner join " . PROPERTY . " on " . PROPERTY . ".id = " . OWNER_REVIEW . ".property_id \n\t\t\t\t\t\t\t\t\t where review_id = '" . $review_id . "' "); $user_value = $pptyData[0]['guest_name']; $property_value = $pptyData[0]['property_title']; $review_date_value = date('d-m-Y', strtotime($pptyData[0]['review_date'])); $location_value = $pptyData[0]['location']; $status_value = $pptyData[0]['review_status']; $check_in_value = date('d-m-Y', strtotime($pptyData[0]['check_in'])); $rating_value = $pptyData[0]['rating']; $review_value = $pptyData[0]['review']; $headline_value = $pptyData[0]['headline']; $comment_value = $pptyData[0]['comment']; } $i = 0; $full_name = new Zend_Form_Element_Text('full_name'); $full_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "Please enter Full Name"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setAttrib("maxlength", "50")->setValue($user_value); $location = new Zend_Form_Element_Text('location'); $location->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "enter email address"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setAttrib("maxlength", "50")->setValue($location_value); $check_in = new Zend_Form_Element_Text('check_in'); $check_in->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "Please enter phone number"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput mws-datepicker required ")->setValue($check_in_value); $ratingArr = array(); $ratingArr[0]['key'] = ""; $ratingArr[0]['value'] = "- - Select - -"; for ($i = 1; $i <= 10; $i++) { $ratingArr[$i]['key'] = $i; $ratingArr[$i]['value'] = $i; } $rating = new Zend_Form_Element_Select('rating'); $rating->setRequired(true)->addMultiOptions($ratingArr)->addValidator('NotEmpty', true, array('messages' => "Enter Rating"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($rating_value); $headline = new Zend_Form_Element_Text('headline'); $headline->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "Enter Review Headline"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required reviewHeadline")->setAttrib("maxlength", "100")->setValue($headline_value); $comment = new Zend_Form_Element_Textarea('comment'); $comment->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "required")->setAttrib("rows", "4")->setAttrib("cols", "30")->setAttrib("maxlength", "300")->setValue($comment_value); $review = new Zend_Form_Element_Textarea('review'); $review->setRequired(true)->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "required")->setAttrib("rows", "4")->setAttrib("cols", "30")->setAttrib("maxlength", "1000")->addValidator('NotEmpty', true, array('messages' => "Enter Review"))->setValue($review_value); $statusArr[0]['key'] = ""; $statusArr[0]['value'] = "- - Select - "; $statusArr[1]['key'] = "0"; $statusArr[1]['value'] = "Disable"; $statusArr[2]['key'] = "1"; $statusArr[2]['value'] = "Enable"; $status = new Zend_Form_Element_Select('status'); $status->setRequired(true)->addMultiOptions($statusArr)->setValue($status_value); $this->addElements(array($full_name, $location, $check_in, $rating, $headline, $comment, $review, $status)); }
public function init($cityId) { global $mySession; $db = new Db(); $CountryId = ""; $StateId = ""; $CityName = ""; if ($cityId != "") { $PageData = $db->runQuery("select * from " . CITIES . " where city_id='" . $cityId . "'"); $CountryId = $PageData[0]['country_id']; $StateId = $PageData[0]['state_id']; $CityName = $PageData[0]['city_name']; } $CountryArr = array(); $CountryArr[0]['key'] = ""; $CountryArr[0]['value'] = "- - Country - -"; $CountryData = $db->runQuery("select * from " . COUNTRIES . " order by country_name"); if ($CountryData != "" and count($CountryData) > 0) { $i = 1; foreach ($CountryData as $key => $CountryValues) { $CountryArr[$i]['key'] = $CountryValues['country_id']; $CountryArr[$i]['value'] = $CountryValues['country_name']; $i++; } } $country_id = new Zend_Form_Element_Select('country_id'); $country_id->setRequired(true)->addMultiOptions($CountryArr)->addValidator('NotEmpty', true, array('messages' => 'Country is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("style", "width:250px;")->setAttrib("onchange", "getCountryState(this.value);")->setValue($CountryId); $StateArr = array(); $StateArr[0]['key'] = ""; $StateArr[0]['value'] = "- - State - -"; $chkCountryId = $CountryId; if (isset($_REQUEST['country_id']) && $_REQUEST['country_id'] != "") { $chkCountryId = $_REQUEST['country_id']; } if ($chkCountryId != "") { $StateData = $db->runQuery("select * from " . STATE . " where country_id='" . $chkCountryId . "' order by state_name"); if ($StateData != "" and count($StateData) > 0) { $i = 1; foreach ($StateData as $key => $StateValues) { $StateArr[$i]['key'] = $StateValues['state_id']; $StateArr[$i]['value'] = $StateValues['state_name']; $i++; } } } $state_id = new Zend_Form_Element_Select('state_id'); $state_id->setRequired(true)->addMultiOptions($StateArr)->addValidator('NotEmpty', true, array('messages' => 'State is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("style", "width:250px;")->setValue($StateId); $city_name = new Zend_Form_Element_Text('city_name'); $city_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'City Name is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setAttrib("style", "width:250px;")->setValue($CityName); $this->addElements(array($country_id, $state_id, $city_name)); }
public function saveReview($dataForm) { global $mySession; $db = new Db(); $data_update = array(); $chckArr = $db->runQuery("select * from " . PROPERTY . " where propertycode = '" . trim($dataForm['ppty_no']) . "' and status = '3'"); if (count($chckArr) > 0 && $chckArr != "") { $data_update['guest_name'] = $dataForm['full_name']; $data_update['location'] = $dataForm['location']; $check_in = explode("/", $dataForm['check_in']); $data_update['check_in'] = date('Y-m-d', strtotime($check_in[2] . "-" . $check_in[1] . "-" . $check_in[0])); $data_update['rating'] = $dataForm['rating']; $data_update['user_id'] = $mySession->LoggedUserId; $data_update['headline'] = $dataForm['headline']; $data_update['comment'] = $dataForm['comment']; $data_update['review'] = $dataForm['review']; $data_update['uType'] = $mySession->LoggedUserType == '1' ? "1" : "0"; $data_update['review_date'] = date("Y-m-d"); $data_update["property_id"] = $chckArr[0]['id']; $data_update['guest_image'] = $mySession->LoggedUser['image']; copy(SITE_ROOT . "images/" . $mySession->LoggedUser['image'], SITE_ROOT . "images/profile/" . $mySession->LoggedUser['image']); $db->save(OWNER_REVIEW, $data_update); $review_id = $db->lastInsertId(); //====== code to enter new latest review properties =============== //two cases are there //1. if already an entry is there within latest reviews //2. first entry is made for specific property $reviewPptyArr = $db->runQuery("select * from " . LATEST_REVIEW . " where r_property_id = '" . $chckArr[0]['id'] . "' "); //case 1 if (count($reviewPptyArr) > 0 && $reviewPptyArr != "") { $db->delete(LATEST_REVIEW, "r_id = " . $reviewPptyArr[0]['r_id']); $updateData = array(); $updateData['r_order'] = new Zend_Db_Expr('r_order-1'); $db->modify(LATEST_REVIEW, $updateData, "r_order > " . $reviewPptyArr[0]['r_order']); } else { $updateData = array(); $updateData['r_order'] = new Zend_Db_Expr('r_order+1'); $db->modify(LATEST_REVIEW, $updateData); $saveData = array(); $saveData['r_property_id'] = $chckArr[0]['id']; $saveData['r_order'] = '1'; //$saveData['r_review_id'] = $review_id; $saveData['r_status'] = '1'; $db->save(LATEST_REVIEW, $saveData); } //----------------------------------------------------------------- return 1; } else { return 0; } }
public function pagesAction() { global $mySession; $db = new Db(); $slug = $this->getRequest()->getParam("slug"); $userArr = $db->runQuery("select * from " . USERS . " where user_id = '" . $mySession->LoggedUserId . "' "); $sql = "select * from " . PAGES1 . " where synonyms = '{$slug}'"; $staticArr = $db->runQuery($sql); $strContent = str_replace("[SITEURL]", APPLICATION_URL, $staticArr[0]['page_content']); $strContent = str_replace("[FULLNAME]", $userArr[0]['email_address'], $strContent); if (!isLogged()) { $strContent = str_replace("[LOGINMSG]", "<a href='" . APPLICATION_URL . "/signin'>click here</a> to Login", $strContent); } else { $strContent = str_replace("[LOGINMSG]", "", $strContent); } $this->view->pageContent = $strContent; $this->view->pageTitle = $staticArr[0]['page_title']; $this->view->page_id = $staticArr[0]['page_id']; if ($staticArr[0]['page_id'] == '12' || $staticArr[0]['page_id'] == '63') { $myform = new Form_Contact(); $this->view->myform = $myform; } if ($staticArr[0]['page_id'] == '80') { $myform = new Form_Ocontact(); $this->view->myform = $myform; } $varsuccess = 0; if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $dataForm = $myform->getValues(); if ($myform->isValid($request->getPost())) { $dataForm = $myform->getValues(); //prd($dataForm); if ($dataForm['captcha'] == $_SESSION['captcha']) { $myObj = new Users(); if ($staticArr[0]['page_id'] == '80') { $Result = $myObj->ownercontactus($dataForm); } else { $Result = $myObj->contactus($dataForm); } $mySession->sucessMsg = "Thank you, You will soon be contacted"; $varsuccess = 1; } else { $mySession->errorMsg = "Human Verification code is wrong"; } } } $this->view->myform = $myform; $this->view->varsuccess = $varsuccess; }
public function init($userType, $userId) { global $mySession; $db = new Db(); $receiver_id_value = ""; $message_subject_value = ""; $message_text_value = ""; if ($userType == '1') { $ReceiverArr = array(); $ReceiverArr[0]['key'] = "0"; $ReceiverArr[0]['value'] = "ADMIN"; } else { $ReceiverArr = array(); if ($userId != "") { $ReceiverData = $db->runQuery("select " . USERS . ".user_id,concat(first_name,' ',last_name) as ReceiverName,\n\t\t\t\t\t\t\t\t\t\t email_address, uType from " . USERS . " where " . USERS . ".user_id != '" . $userId . "' \n\t\t\t\t\t\t\t\t\t\t and " . USERS . ".user_status = '1'\n\t\t\t\t\t\t\t\t\t\t "); } else { $ReceiverData = $db->runQuery("select " . USERS . ".user_id,concat(first_name,' ',last_name) as ReceiverName,\n\t\t\t\t\t\t\t\t\t\t email_address, uType from " . USERS . " where " . USERS . ".user_status = '1' "); } } if ($ReceiverData != "" and count($ReceiverData) > 0) { $i = 1; foreach ($ReceiverData as $key => $ReceiverValues) { $usertype = $ReceiverValues['uType'] == '2' ? "Owner" : "Customer"; $ReceiverArr[$i]['key'] = $ReceiverValues['user_id']; $ReceiverArr[$i]['value'] = $ReceiverValues['email_address'] . " [" . $usertype . "]"; $i++; } } $box1View = new Zend_Form_Element_Select('box1View'); $box1View->addMultiOptions($ReceiverArr)->setAttrib("multiple", "multiple")->setRegisterInArrayValidator(false)->setAttrib("style", "width:100%;height:250px;")->setValue($receiver_id_value); $this->addElement($box1View); $box2View = new Zend_Form_Element_Select('box2View'); $box2View->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Reciever is required'))->setRegisterInArrayValidator(false)->setAttrib("multiple", "multiple")->setAttrib("style", "width:100%;height:250px;"); $this->addElement($box2View); if ($userId != "") { $ReceiverData = $db->runQuery("select " . USERS . ".user_id,concat(first_name,' ',last_name) as ReceiverName,\n\t\t\t\t\t\t\t\t\t\t\t email_address, uType from " . USERS . " where " . USERS . ".user_id = '" . $userId . "' "); $ReceiverArr = array(); $usertype = $ReceiverValues['uType'] == '2' ? "Owner" : "Customer"; $ReceiverArr[0]['key'] = $ReceiverData[0]['user_id']; $ReceiverArr[0]['value'] = $ReceiverData[0]['email_address'] . " [" . $usertype . "]"; $box2View->addMultiOptions($ReceiverArr); } $message_subject = new Zend_Form_Element_Text('message_subject'); $message_subject->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Message subject is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($message_subject_value); $this->addElement($message_subject); $message_text = new Zend_Form_Element_Textarea('message_text'); $message_text->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Message is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($message_text_value); $this->addElement($message_text); }
public function myInit($Id) { global $mySession; $db = new Db(); if ($Id != "") { $adminData = $db->runQuery("select * from " . TSHIRT_ICONS . " where id='" . $Id . "'"); $title_value = $adminData[0]['title']; $oldicon_value = $adminData[0]['icon']; $colorcode_value = $adminData[0]['colorcode']; } else { $title_value = ''; $oldicon_value = ''; $colorcode_value = ''; } $title = new Zend_Form_Element_Text('title'); $title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'First Name is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($title_value); $colorcode = new Zend_Form_Element_Text('colorcode'); $colorcode->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Please enter color code.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "Expandable mws-textinput required")->setAttrib("onkeypress", "return checknummspK(event)")->setValue($colorcode_value); $this->addElement($colorcode); $this->addElement($title); if ($Id == "") { $image = new Zend_Form_Element_File('image'); $image->setDestination(SITE_ROOT . 'images/tshirt-icons/')->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Please select an icon.'))->addValidator('Extension', false, 'jpg,jpeg,png,gif')->setAttrib("class", "textbox")->addDecorator('Errors', array('class' => 'error')); } else { $image = new Zend_Form_Element_File('image'); $image->setDestination(SITE_ROOT . 'images/tshirt-icons/')->addValidator('Extension', false, 'jpg,jpeg,png,gif')->setAttrib("class", "textbox"); } $this->addElement($image); if ($Id != "") { $oldicon = new Zend_Form_Element_Hidden('oldicon'); $oldicon->setValue($oldicon_value); $this->addElement($oldicon); $this->addElement("hidden", "foo", array("decorators" => array(array(array("img" => "HtmlTag"), array("tag" => "img", "openOnly" => true, "src" => IMAGES_URL . 'tshirt-icons/' . $oldicon_value, "align" => "middle", "class" => "myClass", "style" => "max-width:200px;max-height:200px;")), array("ViewHelper"), array(array("span" => "HtmlTag"), array("tag" => "span", "class" => "myElement", "style" => "text-align:center;display:block;"))))); } }
public function init($blogId) { // echo "hello ".$blogId; exit(); global $mySession; $db = new Db(); $title_value = ""; $description_value = ""; $status_value = "1"; if ($blogId != "") { $blogData = $db->runQuery("select * from " . BLOG_POST . " where blog_post_id='" . $blogId . "'"); $title_value = $blogData[0]['title']; $description_value = $blogData[0]['description']; $status_value = $blogData[0]['status']; } $StatusArr = array(); $StatusArr[0]['key'] = "1"; $StatusArr[0]['value'] = "Enable"; $status = new Zend_Form_Element_Select('status'); $status->addMultiOptions($StatusArr)->setAttrib("class", "textInput")->setValue($status_value); $title = new Zend_Form_Element_Text('title'); $title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'blog title is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setValue($title_value); $description = new Zend_Form_Element_Textarea('description'); $description->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'blog description is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setAttrib("rows", "3")->setAttrib("style", "height:100px;")->setValue($description_value); $this->addElements(array($status, $title, $description)); }
public function UpdateSub($dataForm, $userId) { global $mySession; $db = new Db(); $dataForm = SetupMagicQuotes($dataForm); $chkQry = $db->runQuery("select * from " . SUBSCRIPTION . " where mobile_number='" . $dataForm['mobile_number'] . "' and user_id!='" . $userId . "'"); if ($chkQry != "" and count($chkQry) > 0) { return 0; } else { $dataUpdate['first_name'] = $dataForm['first_name']; $dataUpdate['last_name'] = $dataForm['last_name']; $dataUpdate['email_address'] = $dataForm['email_address']; $dataUpdate['username'] = $dataForm['username']; $dataUpdate['address'] = $dataForm['address']; $dataUpdate['country_id'] = $dataForm['country_id']; $dataUpdate['state_id'] = $dataForm['state_id']; $dataUpdate['city_id'] = $dataForm['city_id']; $dataUpdate['zipcode'] = $dataForm['zipcode']; $dataUpdate['phone_number'] = $dataForm['phone_number']; $dataUpdate['mobile_number'] = $dataForm['mobile_number']; $dataUpdate['newsletter_subscribe'] = $dataForm['subscribe']; $conditionUpdate = "user_id='" . $userId . "'"; $db->modify(USERS, $dataUpdate, $conditionUpdate); return $userId; } }
public function init($topicId) { global $mySession; $db = new Db(); $topicTitle = ""; $topicDescription = ""; $topicStatus = "1"; if ($topicId != "") { $topicData = $db->runQuery("select * from " . FORUM_TOPICS . " where topic_id='" . $topicId . "'"); $topicTitle = $topicData[0]['topic_title']; $topicDescription = $topicData[0]['topic_description']; $topicStatus = $topicData[0]['topic_status']; } $StatusArr = array(); $StatusArr[0]['key'] = "1"; $StatusArr[0]['value'] = "Enable"; $StatusArr[1]['key'] = "0"; $StatusArr[1]['value'] = "Disable"; $topic_status = new Zend_Form_Element_Select('topic_status'); $topic_status->addMultiOptions($StatusArr)->setAttrib("class", "textInput")->setValue($topicStatus); $topic_title = new Zend_Form_Element_Text('topic_title'); $topic_title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Topic title is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setValue($topicTitle); $topic_description = new Zend_Form_Element_Textarea('topic_description'); $topic_description->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Topic description is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setAttrib("rows", "3")->setAttrib("style", "height:100px;")->setValue($topicDescription); $this->addElements(array($topic_status, $topic_title, $topic_description)); }
public function init($pageId) { global $mySession; $db = new Db(); $PageTitle = ""; $PageContent = ""; //$pageposition_value=""; if ($pageId != "") { $PageData = $db->runQuery("select * from " . PAGES . " where page_id='" . $pageId . "'"); $PageTitle = $PageData[0]['page_title']; $PageContent = $PageData[0]['page_content']; //$pageposition_value=$PageData[0]['page_position']; } $page_title = new Zend_Form_Element_Text('page_title'); $page_title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Page title is required.'))->addDecorator('Errors', array('class' => 'errormsg'))->setAttrib("class", "mws-textinput required")->setValue($PageTitle); $page_content = new Zend_Form_Element_Textarea('page_content'); $page_content->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Page content is required.'))->addDecorator('Errors', array('class' => 'errormsg'))->setAttrib("class", "mws-textinput required")->setAttrib("id", "elrte")->setAttrib("cols", "auto")->setAttrib("style", "width:90%;")->setValue($PageContent); /* $pagepositionArr=array(); $pagepositionArr[0]['key']="0"; $pagepositionArr[0]['value']="Top"; $pagepositionArr[1]['key']="1"; $pagepositionArr[1]['value']="Bottom"; $pageposition= new Zend_Form_Element_Radio('pageposition'); $pageposition->addMultiOptions($pagepositionArr) ->setValue($pageposition_value); */ $this->addElements(array($page_title, $page_content)); }
public function init($categoryId) { global $mySession; $db = new Db(); $CategoryName = ""; $cattitle = ""; $catdesc = ""; $catimage = ""; $rssurl = ""; if ($categoryId != "") { //category_id, category_name, perent_id, cat_position, cat_title, cat_desc, cat_image, category_status, created_by, created_date $PageData = $db->runQuery("select * from " . CATEGORIES . " where category_id='" . $categoryId . "'"); $CategoryName = $PageData[0]['category_name']; $catposition = $PageData[0]['cat_position']; $cattitle = $PageData[0]['cat_title']; $catdesc = $PageData[0]['cat_desc']; $catimage = $PageData[0]['cat_image']; $rssurl = $PageData[0]['rss_url']; } $cat_position = new Zend_Form_Element_Hidden('cat_position'); $cat_position->setValue($catposition); $cat_image_file = new Zend_Form_Element_Hidden('cat_image_file'); $cat_image_file->setValue($catimage); $cat_desc = new Zend_Form_Element_Textarea('cat_desc'); $cat_desc->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Category Title is required.'))->setAttrib("style", "width:350px;height:150px")->setValue($catdesc); $category_name = new Zend_Form_Element_Text('category_name'); $category_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Category Name is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setAttrib("style", "width:350px;")->setValue($CategoryName); $cat_title = new Zend_Form_Element_Text('cat_title'); $cat_title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Category Title is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "textInput")->setAttrib("style", "width:350px;")->setValue($cattitle); $rss_url = new Zend_Form_Element_Text('rss_url'); $rss_url->setAttrib("class", "textInput")->setAttrib("style", "width:350px;")->setValue($rssurl); $photo_path = new Zend_Form_Element_File('photo_path'); $photo_path->setDestination(SITE_ROOT . 'images/category/')->addValidator('Extension', false, 'jpg,jpeg,png,gif')->setRequired(false)->addDecorator('Errors', array('class' => 'error')); $this->addElements(array($category_name, $cat_title, $cat_desc, $cat_image_file, $rss_url, $cat_position, $photo_path)); }
public function init() { global $mySession; $db = new Db(); $myControllerName = Zend_Controller_Front::getInstance()->getRequest()->getControllerName(); $myActionName = Zend_Controller_Front::getInstance()->getRequest()->getActionName(); $defineData = $db->runQuery("select * from " . ADMINISTRATOR . " where admin_id='1'"); define("ADMIN_EMAIL", array_key_exists('admin_email', $defineData[0]) ? $defineData[0]['admin_email'] : ''); define("SITE_NAME", array_key_exists('site_title', $defineData[0]) ? $defineData[0]['site_title'] : 'TeeshirtSCRIPT'); define("SITE_KEYWORD", array_key_exists('site_keyword', $defineData[0]) ? $defineData[0]['site_keyword'] : ''); define("PRICE_SYMBOL", array_key_exists('currency_symbol', $defineData[0]) ? $defineData[0]['currency_symbol'] : '$'); define("DEFAULT_BUSINESS_IMAGE", array_key_exists('default_business_image', $defineData[0]) ? $defineData[0]['default_business_image'] : 'my_default_business_image.png'); define("DEFAULT_EVENT_IMAGE", array_key_exists('default_event_image', $defineData[0]) ? $defineData[0]['default_event_image'] : 'my_default_event_image.png'); define("DEFAULT_MALE_USER_IMAGE", array_key_exists('default_male_image', $defineData[0]) ? $defineData[0]['default_male_image'] : 'my_default_male_image.png'); define("DEFAULT_FEMALE_USER_IMAGE", array_key_exists('default_female_image', $defineData[0]) ? $defineData[0]['default_female_image'] : 'my_default_female_image.png'); define("DEFAULT_USER_IMAGE", array_key_exists('default_both_image', $defineData[0]) ? $defineData[0]['default_both_image'] : 'my_default_both_image.png'); if ($mySession->adminId == "" && $myControllerName != 'index') { $mySession->errorMsg = "Please login now to access administrator control panel."; $this->_redirect('index'); } if ($mySession->adminId != "" && ($myControllerName == 'index' && $myActionName == 'index')) { $this->_redirect('dashboard'); } $this->_helper->layout->setLayout('main'); }
public function loginAction() { global $mySession; $db = new Db(); $this->view->pageHeading = "Login"; $this->_helper->layout->setLayout('login'); if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $myform = new Form_Login(); if ($myform->isValid($request->getPost())) { $dataForm = $myform->getValues(); $chkLogin = $db->runQuery("select * from " . ADMINISTRATOR . " where admin_username='******'admin_username']) . "' and admin_password='******'admin_password'])) . "'"); if ($chkLogin != "" and count($chkLogin) > 0) { $mySession->adminId = $chkLogin[0]['admin_id']; $this->_redirect('dashboard'); } else { $mySession->errorMsg = "Invalid username or password."; $this->view->myform = $myform; $this->render('index'); } } else { $this->view->myform = $myform; $this->render('index'); } } else { $this->_redirect('index'); } }
public function ChildPost($post_id, $thread_id) { global $mySession; $db = new Db(); $forumPostlist = $db->runQuery("select * from \n\t\t\t" . FORUM_POSTS . " inner join " . FORUM_THREADS . " on " . FORUM_POSTS . ".thread_id=" . FORUM_THREADS . ".thread_id \n\t\t\tinner join " . FORUM_TOPICS . " on " . FORUM_TOPICS . ".topic_id = " . FORUM_THREADS . ".topic_id \n\t\t\t\tinner join " . USERS . " on " . USERS . ".user_id = " . FORUM_POSTS . ".user_id\n\t\t\t where topic_status='1' and " . FORUM_POSTS . ".replyof=" . $post_id . " and " . FORUM_THREADS . ".thread_id = " . $thread_id . " order by " . FORUM_POSTS . ".post_id desc"); return $forumPostlist; }
public function init($catId) { global $mySession; $db = new Db(); $catname = ""; $catdescription = ""; if ($catId != "") { $Data = $db->runQuery("select * from " . CATEGORY . " where cat_id='" . $catId . "'"); $catname = $Data[0]['cat_name']; $catdescription = $Data[0]['cat_description']; } $cat_name = new Zend_Form_Element_Text('cat_name'); $cat_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Category name is required.'))->addDecorator('Errors', array('class' => 'errormsg'))->setAttrib("class", "mws-textinput required")->setValue($catname); $cat_description = new Zend_Form_Element_Textarea('cat_description'); $cat_description->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Category description is required.'))->addDecorator('Errors', array('class' => 'errormsg'))->setAttrib("class", "mws-textinput required")->setValue($catdescription); /* $pagepositionArr=array(); $pagepositionArr[0]['key']="0"; $pagepositionArr[0]['value']="Top"; $pagepositionArr[1]['key']="1"; $pagepositionArr[1]['value']="Bottom"; $pageposition= new Zend_Form_Element_Radio('pageposition'); $pageposition->addMultiOptions($pagepositionArr) ->setValue($pageposition_value); */ $this->addElements(array($cat_name, $cat_description)); }
public function updateplanAction() { global $mySession; $db = new Db(); $planId = $this->getRequest()->getParam('planId'); $this->view->planId = $planId; $planData = $db->runQuery("select * from " . SUBSCRIPTIONS . " where plan_id='" . $planId . "'"); $this->view->planImage = $planData[0]['plan_image']; $this->view->pageHeading = "Edit Subscription Plan"; if ($this->getRequest()->isPost()) { $request = $this->getRequest(); $myform = new Form_Subscription($planId); if ($myform->isValid($request->getPost())) { $dataForm = $myform->getValues(); $myObj = new System(); $Result = $myObj->UpdatePlan($dataForm, $planId); if ($Result == 1) { $mySession->errorMsg = "Subscription plan updated successfully."; $this->_redirect('subscription/index'); } else { $mySession->errorMsg = "Subscription plan name you entered is already exists."; $this->view->myform = $myform; $this->render('editplan'); } } else { $this->view->myform = $myform; $this->render('editplan'); } } else { $this->_redirect('subscription/editplan/planId/' . $planId); } }
public function indexAction() { global $mySession; $this->view->pageHeading = "Manage Pages"; $db = new Db(); $this->view->ResData = $db->runQuery("select * from " . PAGES1); }
public function init($pageId) { global $mySession; $db = new Db(); $PageTitle = ""; $PageContent = ""; $PageMetaKeyword = ""; $PageMetaDescription = ""; if ($pageId != "") { $PageData = $db->runQuery("select * from " . PAGES1 . " where page_id='" . $pageId . "'"); // prd($PageData); $PageTitle = $PageData[0]['page_title']; $PageContent = $PageData[0]['page_content']; $PageMetaKeyword = $PageData[0]['meta_keywords']; $PageMetaDescription = $PageData[0]['meta_description']; $PageSynonyms = $PageData[0]['synonyms']; } $page_title = new Zend_Form_Element_Text('page_title'); $page_title->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Page title is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($PageTitle); $page_content = new Zend_Form_Element_Textarea('page_content'); $page_content->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Page content is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("id", "elrte")->setAttrib("cols", "auto")->setAttrib("rows", "auto")->setValue($PageContent); $meta_keywords = new Zend_Form_Element_Text('meta_keywords'); $meta_keywords->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Keywords are required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($PageMetaKeyword); $meta_description = new Zend_Form_Element_Text('meta_description'); $meta_description->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'Description is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($PageMetaDescription); $synonyms = new Zend_Form_Element_Text('synonyms'); $synonyms->setRequired(true)->addValidator('NotEmpty', true, array('messages' => 'URL is required.'))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($PageSynonyms); $this->addElements(array($page_title, $page_content, $meta_keywords, $meta_description, $synonyms)); }
public function init($cid) { global $mySession; $db = new Db(); $full_name_value = ""; $phone_value = ""; $email_value = ""; $comment_value = ""; $captcha_value = ""; $subject_value = ""; if ($cid != "") { $adminData = $db->runQuery("select * from " . user . " where id='" . $cid . "'"); $full_name_value = $adminData[0]['fname'] . " " . $adminData[0]['lname']; $phone_value = $adminData[0]['phone']; $email_value = $adminData[0]['email']; $comment_value = $adminData[0]['comment']; } $full_name = new Zend_Form_Element_Text('full_name'); $full_name->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "Please enter Full Name"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($full_name_value); /*$phone = new Zend_Form_Element_Text('phone'); $phone->setRequired(true) ->addValidator('NotEmpty',true,array('messages' =>"Please enter phone number")) ->addDecorator('Errors', array('class'=>'error')) ->setAttrib("onkeypress","return checknummsp(event);") ->setAttrib("class","mws-textinput required") ->addValidator('Digits',true,array('messages' =>"enter proper phone number")) ->setValue($phone_value);*/ if (isset($_REQUEST['phone'])) { $stringLength = new Zend_Validate_StringLength($_POST['phone']); $stringLength->setMin(10); $stringLength->setMax(10); $phone->addValidator($stringLength); } $email_address = new Zend_Form_Element_Text('email_address'); $email_address->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "enter email address"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required email")->setValue($email_value); $cemail_address = new Zend_Form_Element_Text('cemail_address'); $cemail_address->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "enter email address"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required email")->setAttrib("equalTo", "#email_address")->setValue($email_value); $subject = new Zend_Form_Element_Text('subject'); $subject->setRequired(true)->addValidator('NotEmpty', true, array('messages' => "enter email address"))->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "mws-textinput required")->setValue($subject_value); /* $comment= new Zend_Form_Element_Textarea('comment'); $comment->setRequired(true) ->addDecorator('Errors', array('class'=>'error')) ->setAttrib("class","required") ->setAttrib("rows","4") ->setAttrib("cols","30") ->addValidator('NotEmpty',true,array('messages' =>"Enter message"));*/ $enquiry = new Zend_Form_Element_Textarea('enquiry'); $enquiry->setRequired(true)->addDecorator('Errors', array('class' => 'error'))->setAttrib("class", "required")->setAttrib("rows", "4")->setAttrib("cols", "30")->addValidator('NotEmpty', true, array('messages' => "Enter message")); /*$captcha = new Zend_Form_Element_Text('captcha'); $captcha->setRequired(true) ->addDecorator('Errors', array('class'=>'error')) ->setAttrib("class","mws-textinput required") ->addValidator('NotEmpty',true,array('messages' =>"Enter captcha"));*/ /*$check = new Zend_Form_Element_Hidden('check'); $check->setRequired(true) ->setValue($text);*/ $this->addElements(array($full_name, $email_address, $cemail_address, $subject, $enquiry)); }
public function descindexAction() { global $mySession; $db = new Db(); $this->view->pageTitle = "Site Description"; $Data = $db->runQuery("select * from " . SITE_DESC . " where desc_id='1'"); $this->view->Data = $Data; }
public function Getblogs() { global $mySession; $db = new Db(); $str = "Select *,\n\t(SELECT count(`comment_id`) s FROM " . BLOG_COMMENTS . "\n\t\tINNER JOIN " . USERS . " ON " . USERS . ".user_id = " . BLOG_COMMENTS . ".user_id\n\t\t WHERE " . BLOG_COMMENTS . ".blog_id= " . BLOGS . ".blog_id) as commentcount\n\t, CONCAT(first_name,' ',last_name) as username from " . BLOGS . " left join " . USERS . " on " . USERS . ".user_id= " . BLOGS . ".user_id order by blog_id DESC"; $blogdata = $db->runQuery($str); return $blogdata; }
public function indexAction() { global $mySession; $this->view->pageHeading = "Manage Currency"; $db = new Db(); $qry = "select * from " . CURRENCY; $this->view->ResData = $db->runQuery("{$qry}"); }
public function ShowBlogComment($blog_id) { global $mySession; $db = new Db(); $Blogcommentdata = $db->runQuery("SELECT * FROM \n " . BLOG_POST . " inner join " . BLOG_COMMENTS . " on " . BLOG_POST . ".blog_post_id=" . BLOG_COMMENTS . ".`blog_post_id` \n inner join `users` on " . BLOG_COMMENTS . ".post_by=`users`.`user_id` where status=1 and " . BLOG_POST . ".blog_post_id=" . $blog_id . " order by " . BLOG_COMMENTS . ".comment_id desc"); // return $Blogcommentdata; }