Beispiel #1
0
 public function update($contentid, $subcontents, $periodtime, $type)
 {
     $strTableName = self::TBL_SL_CONTENT_SUMMARY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CONTENT_SUMMARY, array($strTableName, global_common::escape_mysql_string($contentid), global_common::escape_mysql_string($subcontents), global_common::escape_mysql_string($periodtime), global_common::escape_mysql_string($type)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CONTENT_SUMMARY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_content_summary:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 public function update($storeid, $categoryid)
 {
     $strTableName = self::TBL_SL_STORECATEGORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_STORECATEGORY, array($strTableName, global_common::escape_mysql_string($storeid), global_common::escape_mysql_string($categoryid)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_STORECATEGORY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_storecategory:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #3
0
 public function activeRetailer($retailerID, $statusID)
 {
     $strTableName = self::TBL_SL_RETAILER;
     $strSQL = global_common::prepareQuery(self::SQL_ACTIVE_SL_RETAILER, array($strTableName, global_common::escape_mysql_string($retailerID), $statusID));
     //echo $strSQL;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RETAILER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error activeRetailer sl_retailer:' . $strSQL, 1);
         return false;
     }
     return $retailerID;
 }
Beispiel #4
0
 public function update($advertisingid, $advertisingname, $partnerid, $startdate, $enddate, $adtypeid, $catID, $content, $imagelink, $preferlink, $order, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_ADVERTISING;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_ADVERTISING, array($strTableName, global_common::escape_mysql_string($advertisingid), global_common::escape_mysql_string($advertisingname), global_common::escape_mysql_string($partnerid), global_common::formatDateTimeSQL($startdate), global_common::formatDateTimeSQL($enddate), global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($content), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($preferlink), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status), $catID));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_advertising:' . $strSQL, 1);
         return false;
     }
     return $advertisingid;
 }
Beispiel #5
0
 public function update($paymentmodeid, $paymentmodename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_PAYMENT_MODE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PAYMENT_MODE, array($strTableName, global_common::escape_mysql_string($paymentmodeid), global_common::escape_mysql_string($paymentmodename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PAYMENT_MODE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_payment_mode:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #6
0
 public function update($currencyid, $currencyname, $eurorate, $usdrate, $audrate, $ndtrate, $cadrate, $gbprate, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted)
 {
     $strTableName = self::TBL_SL_CURRENCY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_CURRENCY, array($strTableName, global_common::escape_mysql_string($currencyid), global_common::escape_mysql_string($currencyname), global_common::escape_mysql_string($eurorate), global_common::escape_mysql_string($usdrate), global_common::escape_mysql_string($audrate), global_common::escape_mysql_string($ndtrate), global_common::escape_mysql_string($cadrate), global_common::escape_mysql_string($gbprate), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_CURRENCY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_currency:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 public function update($adtypeid, $adtypename, $width, $height, $numofday, $displaypage, $shareditem, $price, $cityid, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_AD_TYPE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_AD_TYPE, array($strTableName, global_common::escape_mysql_string($adtypeid), global_common::escape_mysql_string($adtypename), global_common::escape_mysql_string($width), global_common::escape_mysql_string($height), global_common::escape_mysql_string($numofday), global_common::escape_mysql_string($displaypage), global_common::escape_mysql_string($shareditem), global_common::escape_mysql_string($price), global_common::escape_mysql_string($cityid), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_AD_TYPE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_ad_type:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #8
0
    } else {
        $search = ' and `' . global_mapping::CityID . '` = ' . $city . ' ';
    }
}
if ($keyword) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    } else {
        $search .= '(`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    }
}
if ($manu) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
    } else {
        $search .= '(`' . global_mapping::ManufactoryID . '` = ' . global_common::escape_mysql_string($manu) . ')';
    }
}
if ($productInIDs) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ProductID . '` IN (' . $productInIDs . '))';
    } else {
        $search .= '(`' . global_mapping::ProductID . '` IN (' . $productInIDs . '))';
    }
}
//echo 'search:'. $search;
if ($search) {
    $products = $objProduct->getAllProduct($page, '*', $search, null, $total);
}
//echo $total;
//print_r($topProperties);
Beispiel #9
0
 public function update($articleid, $evaluationid, $numevaluation, $evaluatedby, $lastevaluated)
 {
     $strTableName = self::TBL_SL_EVALUATION;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_EVALUATION, array($strTableName, global_common::escape_mysql_string($articleid), global_common::escape_mysql_string($evaluationid), global_common::escape_mysql_string($numevaluation), global_common::escape_mysql_string($evaluatedby), global_common::escape_mysql_string($lastevaluated)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_EVALUATION, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_evaluation:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 public function update($id, $userid, $createddate, $expiredate, $resetdate, $isdelete)
 {
     $strTableName = self::TBL_SL_RESET_PASSWORD;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_RESET_PASSWORD, array($strTableName, global_common::escape_mysql_string($id), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($expiredate), global_common::escape_mysql_string($resetdate), global_common::escape_mysql_string($isdelete)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_RESET_PASSWORD, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_reset_password:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #11
0
 public function update($userid, $username, $password, $fullname, $birthdate, $address, $phone, $email, $sex, $identity, $roleid, $userrankid, $avatar, $accountid, $isactived)
 {
     $strTableName = self::TBL_SL_USER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_USER, array($strTableName, global_common::escape_mysql_string($userid), global_common::escape_mysql_string($username), global_common::escape_mysql_string($password), global_common::escape_mysql_string($fullname), global_common::escape_mysql_string($birthdate), global_common::escape_mysql_string($address), global_common::escape_mysql_string($phone), global_common::escape_mysql_string($email), global_common::escape_mysql_string($sex), global_common::escape_mysql_string($identity), global_common::escape_mysql_string($roleid), global_common::escape_mysql_string($userrankid), global_common::escape_mysql_string($avatar), global_common::escape_mysql_string($accountid), global_common::escape_mysql_string($isactived)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_USER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_user:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #12
0
 public function update($articleid, $prefix, $title, $filename, $articletype, $content, $notificationtype, $tags, $catalogueid, $sectionid, $numview, $numcomment, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_ARTICLE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_ARTICLE, array($strTableName, global_common::escape_mysql_string($articleid), global_common::escape_mysql_string($prefix), global_common::escape_mysql_string($title), global_common::escape_mysql_string($filename), global_common::escape_mysql_string($articletype), global_common::escape_mysql_string($content), global_common::escape_mysql_string($notificationtype), global_common::escape_mysql_string($tags), global_common::escape_mysql_string($catalogueid), global_common::escape_mysql_string($sectionid), global_common::escape_mysql_string($numview), global_common::escape_mysql_string($numcomment), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ARTICLE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_article:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #13
0
 public function update($productpriceid, $productid, $retailer, $productlink, $typeid, $order, $statusid, $status)
 {
     $strTableName = self::TBL_SL_PRODUCT_PRICE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PRODUCT_PRICE, array($strTableName, global_common::escape_mysql_string($productpriceid), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($retailer), global_common::escape_mysql_string($productlink), global_common::escape_mysql_string($typeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($statusid), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT_PRICE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product_price:' . $strSQL, 1);
         return false;
     }
     return $productpriceid;
 }
Beispiel #14
0
 public function update($likeid, $likeamount, $unlikeamount, $likeusers, $unlikeusers)
 {
     $strTableName = self::TBL_SL_LIKE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_LIKE, array($strTableName, global_common::escape_mysql_string($likeid), global_common::escape_mysql_string($likeamount), global_common::escape_mysql_string($unlikeamount), global_common::escape_mysql_string($likeusers), global_common::escape_mysql_string($unlikeusers)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_LIKE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_like:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #15
0
 public function update($manufactoryid, $manufactoryname, $categoryid, $order, $modifiedby, $isdeleted)
 {
     $strTableName = self::TBL_SL_MANUFACTORY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_MANUFACTORY, array($strTableName, global_common::escape_mysql_string($manufactoryid), global_common::escape_mysql_string($manufactoryname), global_common::escape_mysql_string($categoryid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), $isdeleted));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_MANUFACTORY, $this->_objConnection, $strTableName)) {
         echo $strSQL;
         global_common::writeLog('Error add sl_manufactory:' . $strSQL, 1);
         return false;
     }
     return $manufactoryid;
 }
 public function update($productid, $propertyid, $propertyvalue, $order, $typeID, $status)
 {
     $strTableName = self::TBL_SL_PRODUCT_PROPERTY;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PRODUCT_PROPERTY, array($strTableName, global_common::escape_mysql_string($productid), global_common::escape_mysql_string($propertyid), global_common::escape_mysql_string($propertyvalue), global_common::escape_mysql_string($order), $typeID, $status));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT_PROPERTY, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product_property:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #17
0
 public function update($auctionid, $userid, $price, $offereddate, $deleteddate, $isdelete, $status)
 {
     $strTableName = self::TBL_SL_OFFER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_OFFER, array($strTableName, global_common::escape_mysql_string($auctionid), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($price), global_common::escape_mysql_string($offereddate), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdelete), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_OFFER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_offer:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #18
0
    $allSubCats = $objArticleType->getAllArticleType(0, null, 'ParentID=' . $catID, null);
    //print_r($allSubCats);
    if (count($allSubCats) <= 0) {
        $allCatIDs = $catID;
    } else {
        $allCatIDs = global_common::getArrayColumn($allSubCats, global_mapping::ArticleTypeID);
    }
}
if ($allCatIDs) {
    $search = '`' . global_mapping::ArticleTypeID . '` IN ( ' . global_common::convertToQueryIN($allCatIDs) . ' )';
}
if ($keyword) {
    if ($search) {
        $search .= ' and (`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    } else {
        $search .= '(`' . global_mapping::ProductName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Description . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\')';
    }
}
$allAds = $objAdvertising->getAllAdvertising($page, null, $search, null, $total);
$allAdType = $objAdType->getAllAdType(0, null, null, null);
$_SESSION[global_common::SES_C_CUR_PAGE] = "admin/admin_advertising.php";
include_once 'include/_admin_header.inc';
?>
<script type="text/javascript" src="<?php 
echo $_objSystem->locateJs('user_advertising.js');
?>
"></script>
<div id="admin-advertising" class="admin-page">
	<div class="row-fluid">
		<div class="span12">
			<!-- BEGIN PAGE TITLE & BREADCRUMB-->
Beispiel #19
0
 public function update($requesid, $contentrequest, $requestedby, $requesteddate, $contentrespone, $responedby, $responeddate, $isapproved, $isdeleted)
 {
     $strTableName = self::TBL_SL_REQUEST;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_REQUEST, array($strTableName, global_common::escape_mysql_string($requesid), global_common::escape_mysql_string($contentrequest), global_common::escape_mysql_string($requestedby), global_common::escape_mysql_string($requesteddate), global_common::escape_mysql_string($contentrespone), global_common::escape_mysql_string($responedby), global_common::escape_mysql_string($responeddate), global_common::escape_mysql_string($isapproved), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_REQUEST, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_request:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #20
0
        if ($userInfo) {
            echo global_common::convertToXML($strMessageHeader, array("rs", "content"), array(1, json_encode($userInfo)), array(0, 1));
        } else {
            echo global_common::convertToXML($arrHeader, array("rs", "inf"), array(0, "Data is invalid. Pleae try again later"), array(0, 1));
        }
        return;
    }
}
//$catID = $_pgR["cid"];
$page = $_pgR["p"];
if (!$page) {
    $page = 1;
}
$keyword = $_pgR["keyword"];
if ($keyword) {
    $search = ' `' . global_mapping::UserName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::FullName . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\' or `' . global_mapping::Email . '` like \'%' . global_common::escape_mysql_string($keyword) . '%\'';
}
$allUsers = $objUser->getAllUser($page, '', $search, '', $total);
$_SESSION[global_common::SES_C_CUR_PAGE] = "admin/admin_advertising.php";
include_once 'include/_admin_header.inc';
?>
<script type="text/javascript" src="<?php 
echo $_objSystem->locateJs('user_user.js');
?>
"></script>
<div id="admin-user">
	<div class="row-fluid">
		<div class="span12">
			<!-- BEGIN PAGE TITLE & BREADCRUMB-->
			<h3 class="page-title">
				Manage User
Beispiel #21
0
 public function update($menuid, $menuname, $link, $numorder, $isdeleted, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $level, $parentid)
 {
     $strTableName = self::TBL_SL_MENU;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_MENU, array($strTableName, global_common::escape_mysql_string($menuid), global_common::escape_mysql_string($menuname), global_common::escape_mysql_string($link), global_common::escape_mysql_string($numorder), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($level), global_common::escape_mysql_string($parentid)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_MENU, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_menu:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 public function update($propertygroupid, $propertygroupname, $propertygroupdisplay, $articletypeid, $order, $modifiedby, $status)
 {
     $strTableName = self::TBL_SL_PROPERTY_GROUP;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PROPERTY_GROUP, array($strTableName, global_common::escape_mysql_string($propertygroupid), global_common::escape_mysql_string($propertygroupname), global_common::escape_mysql_string($propertygroupdisplay), global_common::escape_mysql_string($articletypeid), global_common::escape_mysql_string($order), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::nowSQL(), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     //echo $strSQL;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PROPERTY_GROUP, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_property_group:' . $strSQL, 1);
         return false;
     }
     return $propertygroupid;
 }
Beispiel #23
0
 public function update($commnentid, $description, $reportedby, $reporteddate, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_COMMENT_BAD;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_COMMENT_BAD, array($strTableName, global_common::escape_mysql_string($commnentid), global_common::escape_mysql_string($description), global_common::escape_mysql_string($reportedby), global_common::escape_mysql_string($reporteddate), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_COMMENT_BAD, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_comment_bad:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #24
0
 public function update($parterid, $userid, $partnername, $company, $address1, $addressname1, $address2, $addressname2, $address3, $addressname3, $address4, $addressname4, $address5, $addressname5, $email1, $emailname1, $email2, $emailname2, $email3, $emailname3, $email4, $emailname4, $email5, $emailname5, $phone1, $phonename1, $phone2, $phonename2, $phone3, $phonename3, $phone4, $phonename4, $phone5, $phonename5, $fax1, $faxname1, $fax2, $faxname2, $fax3, $faxname3, $fax4, $faxname4, $fax5, $faxname5, $website1, $websitename1, $website2, $websitename2, $website3, $websitename3, $website4, $websitename4, $website5, $websitename5, $taxnumber, $accountnumber, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $status, $isdeleted)
 {
     $strTableName = self::TBL_SL_PARTNER;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PARTNER, array($strTableName, global_common::escape_mysql_string($parterid), global_common::escape_mysql_string($userid), global_common::escape_mysql_string($partnername), global_common::escape_mysql_string($company), global_common::escape_mysql_string($address1), global_common::escape_mysql_string($addressname1), global_common::escape_mysql_string($address2), global_common::escape_mysql_string($addressname2), global_common::escape_mysql_string($address3), global_common::escape_mysql_string($addressname3), global_common::escape_mysql_string($address4), global_common::escape_mysql_string($addressname4), global_common::escape_mysql_string($address5), global_common::escape_mysql_string($addressname5), global_common::escape_mysql_string($email1), global_common::escape_mysql_string($emailname1), global_common::escape_mysql_string($email2), global_common::escape_mysql_string($emailname2), global_common::escape_mysql_string($email3), global_common::escape_mysql_string($emailname3), global_common::escape_mysql_string($email4), global_common::escape_mysql_string($emailname4), global_common::escape_mysql_string($email5), global_common::escape_mysql_string($emailname5), global_common::escape_mysql_string($phone1), global_common::escape_mysql_string($phonename1), global_common::escape_mysql_string($phone2), global_common::escape_mysql_string($phonename2), global_common::escape_mysql_string($phone3), global_common::escape_mysql_string($phonename3), global_common::escape_mysql_string($phone4), global_common::escape_mysql_string($phonename4), global_common::escape_mysql_string($phone5), global_common::escape_mysql_string($phonename5), global_common::escape_mysql_string($fax1), global_common::escape_mysql_string($faxname1), global_common::escape_mysql_string($fax2), global_common::escape_mysql_string($faxname2), global_common::escape_mysql_string($fax3), global_common::escape_mysql_string($faxname3), global_common::escape_mysql_string($fax4), global_common::escape_mysql_string($faxname4), global_common::escape_mysql_string($fax5), global_common::escape_mysql_string($faxname5), global_common::escape_mysql_string($website1), global_common::escape_mysql_string($websitename1), global_common::escape_mysql_string($website2), global_common::escape_mysql_string($websitename2), global_common::escape_mysql_string($website3), global_common::escape_mysql_string($websitename3), global_common::escape_mysql_string($website4), global_common::escape_mysql_string($websitename4), global_common::escape_mysql_string($website5), global_common::escape_mysql_string($websitename5), global_common::escape_mysql_string($taxnumber), global_common::escape_mysql_string($accountnumber), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($status), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PARTNER, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_partner:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #25
0
 public function update($productid, $productname, $catalogueid, $imagelink, $manufactoryid, $paymentmodeid, $numberaireid, $storagedate, $price, $amount, $description, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_PRODUCT;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_PRODUCT, array($strTableName, global_common::escape_mysql_string($productid), global_common::escape_mysql_string($productname), global_common::escape_mysql_string($catalogueid), global_common::escape_mysql_string($imagelink), global_common::escape_mysql_string($manufactoryid), global_common::escape_mysql_string($paymentmodeid), global_common::escape_mysql_string($numberaireid), global_common::escape_mysql_string($storagedate), global_common::escape_mysql_string($price), global_common::escape_mysql_string($amount), global_common::escape_mysql_string($description), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 public function activeAdvertising($adID, $isActivate)
 {
     $strTableName = self::TBL_SL_ADVERTISING;
     $strSQL = global_common::prepareQuery(self::SQL_ACTIVE_SL_ADVERTISING, array($strTableName, global_common::escape_mysql_string($adID), $isActivate));
     //echo $strSQL;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_ADVERTISING, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_article:' . $strSQL, 1);
         return false;
     }
     return $adID;
 }
Beispiel #27
0
 public function update($auctionid, $productid, $startdate, $enddate, $startingprice, $numoffer, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $status, $isdeleted)
 {
     $strTableName = self::TBL_SL_AUCTION;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_AUCTION, array($strTableName, global_common::escape_mysql_string($auctionid), global_common::escape_mysql_string($productid), global_common::escape_mysql_string($startdate), global_common::escape_mysql_string($enddate), global_common::escape_mysql_string($startingprice), global_common::escape_mysql_string($numoffer), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($status), global_common::escape_mysql_string($isdeleted)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_AUCTION, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_auction:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
 function changeResetPassword($userID, $newPassword)
 {
     $userInfo = $this->getUserByID($userID);
     if ($userInfo) {
         $newPassword = md5($userID . md5($newPassword));
         $sqlUpdate = '`Password` = \'' . global_common::escape_mysql_string($newPassword) . '\'';
         $condition = '`UserID` = \'' . $userID . '\'';
         $strTableName = self::TBL_SL_USER;
         $strSQL = global_common::prepareQuery(global_common::SQL_UPDATE_BY_CONDITION, array($strTableName, $sqlUpdate, $condition));
         //echo $strSQL;
         if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_USER, $this->_objConnection, $strTableName)) {
             //echo $strSQL;
             global_common::writeLog('Error add changeResetPassword:' . $strSQL, 1);
             return -1;
         }
         return 1;
     }
     return 0;
 }
Beispiel #29
0
 public function update($notificationtypeid, $notificationtypename, $createdby, $createddate, $modifiedby, $modifieddate, $deletedby, $deleteddate, $isdeleted, $status)
 {
     $strTableName = self::TBL_SL_NOTIFICATION_TYPE;
     $strSQL = global_common::prepareQuery(self::SQL_UPDATE_SL_NOTIFICATION_TYPE, array($strTableName, global_common::escape_mysql_string($notificationtypeid), global_common::escape_mysql_string($notificationtypename), global_common::escape_mysql_string($createdby), global_common::escape_mysql_string($createddate), global_common::escape_mysql_string($modifiedby), global_common::escape_mysql_string($modifieddate), global_common::escape_mysql_string($deletedby), global_common::escape_mysql_string($deleteddate), global_common::escape_mysql_string($isdeleted), global_common::escape_mysql_string($status)));
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_NOTIFICATION_TYPE, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_notification_type:' . $strSQL, 1);
         return false;
     }
     return $intNewID;
 }
Beispiel #30
0
 public function cloneProduct($productid, $createdBy)
 {
     $strTableName = self::TBL_SL_PRODUCT;
     $intID = global_common::getMaxValueofField($this->_objConnection, global_mapping::ProductID, $strTableName) + 1;
     $strSQL = global_common::prepareQuery(self::SQL_CLONE_SL_PRODUCT, array($strTableName, $productid, $intID, global_common::escape_mysql_string($createdBy), global_common::nowSQL()));
     //echo $strSQL;
     //return;
     if (!global_common::ExecutequeryWithCheckExistedTable($strSQL, self::SQL_CREATE_TABLE_SL_PRODUCT, $this->_objConnection, $strTableName)) {
         //echo $strSQL;
         global_common::writeLog('Error add sl_product:' . $strSQL, 1);
         return false;
     }
     return $intID;
 }