PHP simple_query_maindb Examples

Example #1

File: c_f.php Project: aiurlano/mAdserve-Fork

function track($data)
{
    $cache_key = 'click_' . $data['h'] . '';
    if (MAD_TRACK_UNIQUE_CLICKS) {
        $cache_result = get_cache($cache_key);
        if ($cache_result && $cache_result == 1) {
            return false;
        } else {
            set_cache($cache_key, 1, 500);
        }
    }
    if (!is_numeric($data['zone_id'])) {
        return false;
    }
    /* Get the Publication */
    $query = "SELECT publication_id FROM md_zones WHERE entry_id='" . $data['zone_id'] . "'";
    $zone_detail = simple_query_maindb($query, true, 1000);
    if (!$zone_detail or $zone_detail['publication_id'] < 1) {
        return false;
    }
    switch ($data['type']) {
        case 'normal':
            reporting_db_update($zone_detail['publication_id'], $data['zone_id'], $data['campaign_id'], $data['ad_id'], '', 0, 0, 0, 1);
            break;
        case 'network':
            reporting_db_update($zone_detail['publication_id'], $data['zone_id'], $data['campaign_id'], '', $data['network_id'], 0, 0, 0, 1);
            break;
        case 'backfill':
            reporting_db_update($zone_detail['publication_id'], $data['zone_id'], '', '', $data['network_id'], 0, 0, 0, 1);
            break;
    }
}

Example #2

File: r_f.php Project: aiurlano/mAdserve-Fork

function get_mobfox_id()
{
    $query = "select entry_id from md_networks where network_identifier='MOBFOX'";
    if ($network_detail = simple_query_maindb($query, true, 2000)) {
        return $network_detail['entry_id'];
    } else {
        return false;
    }
}