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; }
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; }
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; }
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; }