PHP use_archive_table 예제들

예제 #1

파일: AST_CLOSERstats_v2.php 프로젝트: vultuk/VicidialSubversion

##### END SETTINGS LOOKUP #####
###########################################
### ARCHIVED DATA CHECK CONFIGURATION
$archives_available = "N";
$log_tables_array = array("vicidial_did_log", "vicidial_closer_log", "live_inbound_log");
for ($t = 0; $t < count($log_tables_array); $t++) {
    $table_name = $log_tables_array[$t];
    $archive_table_name = use_archive_table($table_name);
    if ($archive_table_name != $table_name) {
        $archives_available = "Y";
    }
}
if ($search_archived_data) {
    $vicidial_did_log_table = use_archive_table("vicidial_did_log");
    $vicidial_closer_log_table = use_archive_table("vicidial_closer_log");
    $live_inbound_log_table = use_archive_table("live_inbound_log");
} else {
    $vicidial_did_log_table = "vicidial_did_log";
    $vicidial_closer_log_table = "vicidial_closer_log";
    $live_inbound_log_table = "live_inbound_log";
}
#############
$stmt = "SELECT local_gmt FROM servers where active='Y' limit 1;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($DB) {
    $MAIN .= "{$stmt}\n";
}
$gmt_conf_ct = mysqli_num_rows($rslt);
$dst = date("I");
if ($gmt_conf_ct > 0) {
    $row = mysqli_fetch_row($rslt);

예제 #2

파일: AST_inbound_daily_report.php 프로젝트: vultuk/VicidialSubversion

    $slave_db_server = $row[2];
    $reports_use_slave_db = $row[3];
    $SSenable_languages = $row[4];
    $SSlanguage_method = $row[5];
}
##### END SETTINGS LOOKUP #####
###########################################
### ARCHIVED DATA CHECK CONFIGURATION
$archives_available = "N";
$table_name = "vicidial_closer_log";
$archive_table_name = use_archive_table($table_name);
if ($archive_table_name != $table_name) {
    $archives_available = "Y";
}
if ($search_archived_data) {
    $vicidial_closer_log_table = use_archive_table("vicidial_closer_log");
} else {
    $vicidial_closer_log_table = "vicidial_closer_log";
}
#############
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
} else {
    $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW);
    $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER);
}
$stmt = "SELECT selected_language from vicidial_users where user='******';";
if ($DB) {
    echo "|{$stmt}|\n";
}

예제 #3

파일: call_report_export.php 프로젝트: vultuk/VicidialSubversion

    $table_name = $log_tables_array[$t];
    $archive_table_name = use_archive_table($table_name);
    if ($archive_table_name != $table_name) {
        $archives_available = "Y";
    }
}
if ($search_archived_data) {
    $vicidial_log_table = use_archive_table("vicidial_log");
    $vicidial_closer_log_table = use_archive_table("vicidial_closer_log");
    $vicidial_agent_log_table = use_archive_table("vicidial_agent_log");
    $vicidial_log_extended_table = use_archive_table("vicidial_log_extended");
    $recording_log_table = use_archive_table("recording_log");
    $vicidial_carrier_log_table = use_archive_table("vicidial_carrier_log");
    $vicidial_cpd_log_table = use_archive_table("vicidial_cpd_log");
    $vicidial_did_log_table = use_archive_table("vicidial_did_log");
    $vicidial_outbound_ivr_log_table = use_archive_table("vicidial_outbound_ivr_log");
} else {
    $vicidial_log_table = "vicidial_log";
    $vicidial_closer_log_table = "vicidial_closer_log";
    $vicidial_agent_log_table = "vicidial_agent_log";
    $vicidial_log_extended_table = "vicidial_log_extended";
    $recording_log_table = "recording_log";
    $vicidial_carrier_log_table = "vicidial_carrier_log";
    $vicidial_cpd_log_table = "vicidial_cpd_log";
    $vicidial_did_log_table = "vicidial_did_log";
    $vicidial_outbound_ivr_log_table = "vicidial_outbound_ivr_log";
}
#############
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);

예제 #4

파일: AST_performance_comparison_report.php 프로젝트: vultuk/VicidialSubversion

###########################################
if (strlen($report_display_type) < 2) {
    $report_display_type = $SSreport_default_format;
}
### ARCHIVED DATA CHECK CONFIGURATION
$archives_available = "N";
$log_tables_array = array("vicidial_agent_log");
for ($t = 0; $t < count($log_tables_array); $t++) {
    $table_name = $log_tables_array[$t];
    $archive_table_name = use_archive_table($table_name);
    if ($archive_table_name != $table_name) {
        $archives_available = "Y";
    }
}
if ($search_archived_data) {
    $vicidial_agent_log_table = use_archive_table("vicidial_agent_log");
} else {
    $vicidial_agent_log_table = "vicidial_agent_log";
}
#############
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
} else {
    $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW);
    $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER);
}
$stmt = "SELECT selected_language from vicidial_users where user='******';";
if ($DB) {
    echo "|{$stmt}|\n";
}

예제 #5

파일: AST_DIDstats.php 프로젝트: vultuk/VicidialSubversion

    $slave_db_server = $row[2];
    $reports_use_slave_db = $row[3];
    $SSenable_languages = $row[4];
    $SSlanguage_method = $row[5];
}
##### END SETTINGS LOOKUP #####
###########################################
### ARCHIVED DATA CHECK CONFIGURATION
$archives_available = "N";
$table_name = "vicidial_did_log";
$archive_table_name = use_archive_table($table_name);
if ($archive_table_name != $table_name) {
    $archives_available = "Y";
}
if ($search_archived_data) {
    $vicidial_did_log_table = use_archive_table("vicidial_did_log");
} else {
    $vicidial_did_log_table = "vicidial_did_log";
}
#############
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
} else {
    $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW);
    $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER);
}
$stmt = "SELECT selected_language from vicidial_users where user='******';";
if ($DB) {
    echo "|{$stmt}|\n";
}

예제 #6

파일: recording_log_redirect.php 프로젝트: vultuk/VicidialSubversion

    $log_recording_access = $row[7];
}
##### END SETTINGS LOOKUP #####
###########################################
$recording_id = preg_replace('/[^0-9]/', '', $recording_id);
$lead_id = preg_replace('/[^0-9]/', '', $lead_id);
$search_archived_data = preg_replace("/'|\"|\\\\|;/", "", $search_archived_data);
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
} else {
    $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW);
}
if ($search_archived_data) {
    $recording_log_table = use_archive_table("recording_log");
} else {
    $recording_log_table = "recording_log";
}
$auth = 0;
$auth_message = user_authorization($PHP_AUTH_USER, $PHP_AUTH_PW, '', 1);
if ($auth_message == 'GOOD') {
    $auth = 1;
}
if ($auth < 1) {
    $VDdisplayMESSAGE = _QXZ("Login incorrect, please try again");
    $log_stmt = "insert into vicidial_recording_access_log(recording_id, lead_id, user, access_datetime, access_result, ip) VALUES('{$recording_id}', '{$lead_id}', '{$PHP_AUTH_USER}', now(), 'INVALID USER', '{$ip}');";
    $log_rslt = mysql_to_mysqli($log_stmt, $link);
    if ($auth_message == 'LOCK') {
        $VDdisplayMESSAGE = _QXZ("Too many login attempts, try again in 15 minutes");
        Header("Content-type: text/html; charset=utf-8");

예제 #7

파일: AST_LISTS_campaign_stats.php 프로젝트: vultuk/VicidialSubversion

    $slave_db_server = $row[2];
    $reports_use_slave_db = $row[3];
    $SSenable_languages = $row[4];
    $SSlanguage_method = $row[5];
}
##### END SETTINGS LOOKUP #####
###########################################
### ARCHIVED DATA CHECK CONFIGURATION
$archives_available = "N";
$table_name = "vicidial_list";
$archive_table_name = use_archive_table($table_name);
if ($archive_table_name != $table_name) {
    $archives_available = "Y";
}
if ($search_archived_data) {
    $vicidial_list_table = use_archive_table("vicidial_list");
} else {
    $vicidial_list_table = "vicidial_list";
}
#############
if ($non_latin < 1) {
    $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER);
    $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
} else {
    $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW);
    $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER);
}
$stmt = "SELECT selected_language from vicidial_users where user='******';";
if ($DB) {
    echo "|{$stmt}|\n";
}