コード例 #1
0
                $query['feed'] = $query['idx'];
                unset($query['idx']);
            }
            $search_url = http_build_query($query);
            // Build INSERT Query
            $query = "INSERT INTO `" . TABLE_VIEWED_SEARCHES . "` SET " . "`user_id`   = '" . $user->user_id() . "', " . "`title`     = '" . $db_users->cleanInput($search_title) . "', " . "`criteria`  = '" . $db_users->cleanInput($criteria) . "', " . "`table`     = '" . $db_users->cleanInput($idx->getTable()) . "', " . "`idx`       = '" . $db_users->cleanInput($idx->getName()) . "', " . "`url`       = '" . $db_users->cleanInput($search_url) . "', " . "`timestamp` = NOW();";
            // Execute Query
            if ($db_users->query($query)) {
                // Log Event: Lead Performed Search
                $event = new History_Event_Action_ViewedSearch(array('search' => $db_users->fetchQuery("SELECT * FROM `" . TABLE_VIEWED_SEARCHES . "` WHERE `id` = '" . $db_users->insert_id() . "';")), array(new History_User_Lead($user->user_id())));
                // Save to DB
                $event->save();
                // Increment Performed Searches
                $db_users->query("UPDATE `" . TABLE_USERS . "` SET `num_searches` = `num_searches` + 1 WHERE `id` = '" . $user->user_id() . "';");
                // Run hook
                Hooks::hook(Hooks::HOOK_LEAD_SEARCH_PERFORMED)->run($user->getRow(), $idx, unserialize($criteria), html_entity_decode($search_title, ENT_COMPAT | ENT_HTML401, 'UTF-8'));
            }
        } else {
            // Build UPDATE Query
            $query = "UPDATE `" . TABLE_VIEWED_SEARCHES . "` SET `views` = `views` + 1, `timestamp` = NOW() WHERE `id` = '" . $viewed_search['id'] . "';";
            // Execute Query
            $db_users->query($query);
        }
    }
}
// Search Results
$results = array();
// Map Markers
$markers = array();
// Listing Results Found
if (!empty($search_results_count['total'])) {