PHP NS_TRACK_MISC::escape_string示例

示例#1

文件： query.func.php 项目： juliogallardo1326/proc

 function GetQueryId($Qr = false)
 {
     if (!$Qr) {
         return 0;
     }
     global $_NS_TRACK_VARS;
     $Db =& $_NS_TRACK_VARS['Db'];
     $Qr = NS_TRACK_MISC::escape_string($Qr);
     $Query = "SELECT ID FROM " . NS_DB_PFX . "_tracker_query WHERE MD5_SEARCH=MD5('{$Qr}')";
     $CheckId = $Db->ReturnValue($Query);
     if (NS_TRACK_MISC::ValidId($CheckId)) {
         return $CheckId;
     }
     $Query = "INSERT INTO " . NS_DB_PFX . "_tracker_query (QUERY_STRING, MD5_SEARCH) VALUES ('{$Qr}', MD5('{$Qr}'))";
     $Db->Query($Query);
     return NS_TRACK_MISC::ValidId($Db->LastInsertId) ? $Db->LastInsertId : 0;
 }

示例#2

文件： campaign.func.php 项目： juliogallardo1326/proc

 function GetCampaignBySrc($Src = false)
 {
     if (!$Src) {
         return 0;
     }
     global $_NS_TRACK_VARS;
     $Db =& $_NS_TRACK_VARS['Db'];
     $CompanyId =& $_NS_TRACK_VARS['CompanyId'];
     if (!$CompanyId) {
         return 0;
     }
     $Src = NS_TRACK_MISC::escape_string($Src);
     $Query = "SELECT SUB_ID FROM " . NS_DB_PFX . "_tracker_sub_campaign WHERE SRC_ID='{$Src}'";
     $CheckId = $Db->ReturnValue($Query);
     if ($CheckId) {
         return $CheckId;
     }
     $Query = "INSERT INTO " . NS_DB_PFX . "_tracker_camp_piece (CAMPAIGN_ID, COMPANY_ID, NAME) VALUES (0, {$CompanyId}, '{$Src}')";
     $Db->Query($Query);
     $SubId = $Db->LastInsertId;
     $Query = "INSERT INTO " . NS_DB_PFX . "_tracker_sub_campaign (SUB_ID, SRC_ID) VALUES ({$SubId}, '{$Src}')";
     $Db->Query($Query);
     return $SubId;
 }

示例#3

文件： general.func.php 项目： juliogallardo1326/proc

 function CheckDblSale($StId, $CustomId)
 {
     if (!$CustomId) {
         return false;
     }
     global $_NS_TRACK_VARS;
     $Db =& $_NS_TRACK_VARS['Db'];
     $CompanyId =& $_NS_TRACK_VARS['CompanyId'];
     $CustomId = NS_TRACK_MISC::escape_string($CustomId);
     $Query = "SELECT ID FROM " . NS_DB_PFX . "_tracker_" . $CompanyId . "_stat_sale WHERE SITE_ID={$StId} AND CUSTOM_ORDER_ID='{$CustomId}'";
     $CheckId = $Db->ReturnValue($Query);
     return $CheckId ? true : false;
 }

示例#4

文件： referer.func.php 项目： juliogallardo1326/proc

 function GetKeywordId($Key = false)
 {
     if (!$Key) {
         return 0;
     }
     global $_NS_TRACK_VARS;
     $Db =& $_NS_TRACK_VARS['Db'];
     $Key = NS_TRACK_MISC::escape_string($Key);
     $Query = "SELECT ID FROM " . NS_DB_PFX . "_tracker_keyword WHERE MD5_SEARCH=MD5('{$Key}')";
     $CheckId = $Db->ReturnValue($Query);
     if (NS_TRACK_MISC::ValidId($CheckId)) {
         return $CheckId;
     }
     $Query = "INSERT INTO " . NS_DB_PFX . "_tracker_keyword (KEYWORD, MD5_SEARCH) VALUES ('{$Key}', MD5('{$Key}'))";
     $Db->Query($Query);
     return $Db->LastInsertId;
 }