本文整理汇总了PHP中mysql_error_logging函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_error_logging函数的具体用法?PHP mysql_error_logging怎么用?PHP mysql_error_logging使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_error_logging函数的8个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: mysql_query
$MT[0] = '';
$row = '';
$rowx = '';
$channel_live = 1;
if (strlen($conf_exten) < 1 || strlen($exten) < 1) {
$channel_live = 0;
echo "Conf Exten {$conf_exten} nie jest prawidłowy or Exten {$exten} nie jest prawidłowy\n";
exit;
} else {
$stmt = "UPDATE conferences set extension='{$exten}' where server_ip = '{$server_ip}' and conf_exten = '{$conf_exten}';";
if ($format == 'debug') {
echo "\n<!-- {$stmt} -->";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '03013', $user, $server_ip, $session_name, $one_mysql_log);
}
}
echo "Konferencja {$conf_exten} został zarejestrowany {$exten}\n";
}
if ($format == 'debug') {
$ENDtime = date("U");
$RUNtime = $ENDtime - $StarTtime;
echo "\n<!-- czas działania skyptu: {$RUNtime} sekundy -->";
echo "\n</body>\n</html>\n";
}
exit;
##### MySQL Error Logging #####
function mysql_error_logging($NOW_TIME, $link, $mel, $stmt, $query_id, $user, $server_ip, $session_name, $one_mysql_log)
{
$NOW_TIME = date("Y-m-d H:i:s");
开发者ID:akandshuvo,项目名称:Vicidial,代码行数:31,代码来源:conf_exten_check.php
示例2: count
echo "$row[0] ~$row[1] ~$row[2] ~$callback_id[$loop_count] ~$lead_id[$loop_count] ~$campaign_id[$loop_count] ~$status[$loop_count] ~$entry_time[$loop_count] ~$callback_time[$loop_count] ~$comments[$loop_count]\n";
$loop_count++;
}
}
################################################################################
### CalLBacKCounT - send the count of the USERONLY callbacks for an agent
################################################################################
if ($ACTION == 'CalLBacKCounT')
{
$stmt = "select count(*) from vicidial_callbacks where recipient='USERONLY' and user='$user' and campaign_id='$campaign' and status NOT IN('INACTIVE','DEAD');";
if ($DB) {echo "$stmt\n";}
$rslt=mysql_query($stmt, $link);
if ($mel > 0) {mysql_error_logging($NOW_TIME,$link,$mel,$stmt,'00180',$user,$server_ip,$session_name,$one_mysql_log);}
$row=mysql_fetch_row($rslt);
$cbcount=$row[0];
echo "$cbcount";
}
if ($format=='debug')
{
$ENDtime = date("U");
$RUNtime = ($ENDtime - $StarTtime);
echo "\n<!-- χρόνος εκτέλεσης: $RUNtime δευτερόλεπτα -->";
echo "\n</body>\n</html>\n";
开发者ID:h4ck3rm1k3,项目名称:vicidial-asterisk-gui,代码行数:31,代码来源:vdc_db_query.php
示例3: mysql_query
}
if (strlen($D_s_ip[2]) < 3) {
$D_s_ip[2] = "0{$D_s_ip['2']}";
}
if (strlen($D_s_ip[3]) < 2) {
$D_s_ip[3] = "0{$D_s_ip['3']}";
}
if (strlen($D_s_ip[3]) < 3) {
$D_s_ip[3] = "0{$D_s_ip['3']}";
}
$server_ip_dialstring = "{$D_s_ip['0']}{$S}{$D_s_ip['1']}{$S}{$D_s_ip['2']}{$S}{$D_s_ip['3']}{$S}";
##### grab the datails of all active scripts in the system
$stmt = "SELECT script_id,script_name FROM vicidial_scripts WHERE active='Y' order by script_id limit 1000;";
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '01051', $VD_login, $server_ip, $session_name, $one_mysql_log);
}
if ($DB) {
echo "{$stmt}\n";
}
$MM_scripts = mysql_num_rows($rslt);
$e = 0;
while ($e < $MM_scripts) {
$row = mysql_fetch_row($rslt);
$MMscriptid[$e] = $row[0];
$MMscriptname[$e] = urlencode($row[1]);
$MMscriptids = "{$MMscriptids}'{$MMscriptid[$e]}',";
$MMscriptnames = "{$MMscriptnames}'{$MMscriptname[$e]}',";
$e++;
}
$MMscriptids = substr("{$MMscriptids}", 0, -1);
开发者ID:jamesdouglas,项目名称:vicidial,代码行数:31,代码来源:vicidial.php
示例4: custom_list_fields_values
function custom_list_fields_values($lead_id, $list_id, $uniqueid, $user)
{
$STARTtime = date("U");
$TODAY = date("Y-m-d");
$NOW_TIME = date("Y-m-d H:i:s");
$vicidial_list_fields = '|lead_id|vendor_lead_code|source_id|list_id|gmt_offset_now|called_since_last_reset|phone_code|phone_number|title|first_name|middle_initial|last_name|address1|address2|address3|city|state|province|postal_code|country_code|gender|date_of_birth|alt_phone|email|security_phrase|comments|called_count|last_local_call_time|rank|owner|';
require "dbconnect.php";
$CFoutput = '';
$stmt = "SHOW TABLES LIKE \"custom_{$list_id}\";";
if ($DB > 0) {
echo "{$stmt}";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05002', $user, $server_ip, $session_name, $one_mysql_log);
}
$tablecount_to_print = mysql_num_rows($rslt);
if ($tablecount_to_print > 0) {
$stmt = "SELECT count(*) from custom_{$list_id};";
if ($DB > 0) {
echo "{$stmt}";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05003', $user, $server_ip, $session_name, $one_mysql_log);
}
$fieldscount_to_print = mysql_num_rows($rslt);
if ($fieldscount_to_print > 0) {
$rowx = mysql_fetch_row($rslt);
$custom_records_count = $rowx[0];
$select_SQL = '';
$stmt = "SELECT field_id,field_label,field_name,field_description,field_rank,field_help,field_type,field_options,field_size,field_max,field_default,field_cost,field_required,multi_position,name_position,field_order from vicidial_lists_fields where list_id='{$list_id}' order by field_rank,field_order,field_label;";
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05004', $user, $server_ip, $session_name, $one_mysql_log);
}
$fields_to_print = mysql_num_rows($rslt);
$fields_list = '';
$o = 0;
while ($fields_to_print > $o) {
$rowx = mysql_fetch_row($rslt);
$A_field_id[$o] = $rowx[0];
$A_field_label[$o] = $rowx[1];
$A_field_name[$o] = $rowx[2];
$A_field_description[$o] = $rowx[3];
$A_field_rank[$o] = $rowx[4];
$A_field_help[$o] = $rowx[5];
$A_field_type[$o] = $rowx[6];
$A_field_options[$o] = $rowx[7];
$A_field_size[$o] = $rowx[8];
$A_field_max[$o] = $rowx[9];
$A_field_default[$o] = $rowx[10];
$A_field_cost[$o] = $rowx[11];
$A_field_required[$o] = $rowx[12];
$A_multi_position[$o] = $rowx[13];
$A_name_position[$o] = $rowx[14];
$A_field_order[$o] = $rowx[15];
$A_field_value[$o] = '';
if (!preg_match("/\\|{$A_field_label[$o]}\\|/", $vicidial_list_fields)) {
if ($A_field_type[$o] == 'DISPLAY' or $A_field_type[$o] == 'SCRIPT') {
$select_SQL .= "8,";
$A_field_select[$o] = '----EMPTY----';
} else {
$select_SQL .= "{$A_field_label[$o]},";
$A_field_select[$o] = $A_field_label[$o];
}
} else {
$select_SQL .= "8,";
$A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
}
$o++;
$rank_select .= "<option>{$o}</option>";
}
$o++;
$rank_select .= "<option>{$o}</option>";
$last_rank = $o;
$select_SQL = preg_replace("/.\$/", '', $select_SQL);
$list_lead_ct = 0;
if (strlen($select_SQL) > 0) {
##### BEGIN grab the data from custom table for the lead_id
$stmt = "SELECT {$select_SQL} FROM custom_{$list_id} where lead_id='{$lead_id}' LIMIT 1;";
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05005', $user, $server_ip, $session_name, $one_mysql_log);
}
if ($DB) {
echo "{$stmt}\n";
}
$list_lead_ct = mysql_num_rows($rslt);
}
if ($list_lead_ct > 0) {
$row = mysql_fetch_row($rslt);
$o = 0;
while ($fields_to_print >= $o) {
$A_field_value[$o] = trim("{$row[$o]}");
if ($A_field_select[$o] == '----EMPTY----') {
$A_field_value[$o] = '';
}
if (preg_match("/\\|{$A_field_label[$o]}\\|/", $vicidial_list_fields)) {
$A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
//.........这里部分代码省略.........
开发者ID:J-Rod1988,项目名称:Vicidial,代码行数:101,代码来源:functions.php
示例5: custom_list_fields_values
function custom_list_fields_values($lead_id, $list_id, $uniqueid, $user)
{
$STARTtime = date("U");
$TODAY = date("Y-m-d");
$NOW_TIME = date("Y-m-d H:i:s");
$vicidial_list_fields = '|lead_id|vendor_lead_code|source_id|list_id|gmt_offset_now|called_since_last_reset|phone_code|phone_number|title|first_name|middle_initial|last_name|address1|address2|address3|city|state|province|postal_code|country_code|gender|date_of_birth|alt_phone|email|security_phrase|comments|called_count|last_local_call_time|rank|owner|';
require "dbconnect_mysqli.php";
$CFoutput = '';
$stmt = "SHOW TABLES LIKE \"custom_{$list_id}\";";
if ($non_latin > 0) {
$rslt = mysql_to_mysqli("SET NAMES 'UTF8'", $link);
}
if ($DB > 0) {
echo "{$stmt}";
}
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05002', $user, $server_ip, $session_name, $one_mysql_log);
}
$tablecount_to_print = mysqli_num_rows($rslt);
if ($tablecount_to_print > 0) {
$stmt = "SELECT count(*) from custom_{$list_id};";
if ($DB > 0) {
echo "{$stmt}";
}
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05003', $user, $server_ip, $session_name, $one_mysql_log);
}
$fieldscount_to_print = mysqli_num_rows($rslt);
if ($fieldscount_to_print > 0) {
$rowx = mysqli_fetch_row($rslt);
$custom_records_count = $rowx[0];
$select_SQL = '';
$stmt = "SELECT field_id,field_label,field_name,field_description,field_rank,field_help,field_type,field_options,field_size,field_max,field_default,field_cost,field_required,multi_position,name_position,field_order from vicidial_lists_fields where list_id='{$list_id}' order by field_rank,field_order,field_label;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05004', $user, $server_ip, $session_name, $one_mysql_log);
}
$fields_to_print = mysqli_num_rows($rslt);
$fields_list = '';
$o = 0;
while ($fields_to_print > $o) {
$rowx = mysqli_fetch_row($rslt);
$A_field_id[$o] = $rowx[0];
$A_field_label[$o] = $rowx[1];
$A_field_name[$o] = $rowx[2];
$A_field_description[$o] = $rowx[3];
$A_field_rank[$o] = $rowx[4];
$A_field_help[$o] = $rowx[5];
$A_field_type[$o] = $rowx[6];
$A_field_options[$o] = $rowx[7];
$A_field_size[$o] = $rowx[8];
$A_field_max[$o] = $rowx[9];
$A_field_default[$o] = $rowx[10];
$A_field_cost[$o] = $rowx[11];
$A_field_required[$o] = $rowx[12];
$A_multi_position[$o] = $rowx[13];
$A_name_position[$o] = $rowx[14];
$A_field_order[$o] = $rowx[15];
$A_field_value[$o] = '';
if (!preg_match("/\\|{$A_field_label[$o]}\\|/i", $vicidial_list_fields)) {
if ($A_field_type[$o] == 'DISPLAY' or $A_field_type[$o] == 'SCRIPT') {
$select_SQL .= "8,";
$A_field_select[$o] = '----EMPTY----';
} else {
$select_SQL .= "{$A_field_label[$o]},";
$A_field_select[$o] = $A_field_label[$o];
}
} else {
$select_SQL .= "8,";
$A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
}
$o++;
$rank_select .= "<option>{$o}</option>";
}
$o++;
$rank_select .= "<option>{$o}</option>";
$last_rank = $o;
$select_SQL = preg_replace("/.\$/", '', $select_SQL);
$list_lead_ct = 0;
if (strlen($select_SQL) > 0) {
##### BEGIN grab the data from custom table for the lead_id
$stmt = "SELECT {$select_SQL} FROM custom_{$list_id} where lead_id='{$lead_id}' LIMIT 1;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05005', $user, $server_ip, $session_name, $one_mysql_log);
}
if ($DB) {
echo "{$stmt}\n";
}
$list_lead_ct = mysqli_num_rows($rslt);
}
if ($list_lead_ct > 0) {
$row = mysqli_fetch_row($rslt);
$o = 0;
while ($fields_to_print >= $o) {
$A_field_value[$o] = trim("{$row[$o]}");
if ($A_field_select[$o] == '----EMPTY----') {
$A_field_value[$o] = '';
//.........这里部分代码省略.........
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:101,代码来源:functions.php
示例6: status_group_gather
function status_group_gather($status_group_id, $record_type)
{
global $NOW_TIME, $link, $mel, $user, $server_ip, $session_name, $one_mysql_log;
$status_group_statuses = '';
$cs_ct = 0;
if (strlen($status_group_id) > 0 and $status_group_id != 'NONE') {
$stmt = "SELECT status,status_name,scheduled_callback,min_sec,max_sec from vicidial_campaign_statuses where campaign_id='{$status_group_id}' and selectable='Y';";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00654', $user, $server_ip, $session_name, $one_mysql_log);
}
if ($rslt) {
$cs_ct = mysqli_num_rows($rslt);
}
$i = 0;
while ($cs_ct > $i) {
$row = mysqli_fetch_row($rslt);
$status = $row[0];
$status_name = $row[1];
$scheduled_callback = $row[2];
$min_sec = $row[3];
$max_sec = $row[4];
$status_group_statuses .= "{$status}|{$status_name}|{$scheduled_callback}|{$min_sec}|{$max_sec},";
$i++;
}
if (strlen($status_group_statuses) > 0) {
$status_group_statuses = substr("{$status_group_statuses}", 0, -1);
}
}
return $status_group_statuses;
}
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:34,代码来源:vdc_db_query.php
示例7: get_audited_comments
function get_audited_comments($lead_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log)
{
global $ACcount;
global $ACcomments;
$stmt = "select user_id,comment from vicidial_comments where lead_id='{$lead_id}';";
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, "00142-65-AuditComments:{$stmt} LeadID: {$lead_id},{$format},{$user},{$mel},{$NOW_TIME},{$link},{$server_ip},{$session_name},{$one_mysql_log}", $user, $server_ip, $session_name, $one_mysql_log);
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-69-AuditComments', $user, $server_ip, $session_name, $one_mysql_log);
}
$ACcount = mysql_num_rows($rslt);
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-72-AuditComments $ACcount=' . $ACcount, $user, $server_ip, $session_name, $one_mysql_log);
if ($ACcount > 0) {
$i = 0;
while ($i < $ACcount) {
$row = mysql_fetch_row($rslt);
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-77-AuditComments UserID=' . $row[0], $user, $server_ip, $session_name, $one_mysql_log);
$ACcomments .= "UserID: {$row['0']}\n";
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-79-AuditComments Comment=' . $row[1], $user, $server_ip, $session_name, $one_mysql_log);
$ACcomments .= $row[1];
$ACcomments .= "\n----------------------------------\n";
$i++;
}
return true;
} else {
return false;
}
}
开发者ID:himanshu12k,项目名称:ce-www,代码行数:30,代码来源:audit_comments.php
示例8: get_audited_comments
function get_audited_comments($lead_id, $format, $user, $mel, $NOW_TIME, $link, $server_ip, $session_name, $one_mysql_log)
{
global $ACcount;
global $ACcomments;
$stmt = "SELECT user_id,comment,timestamp from vicidial_comments where lead_id='{$lead_id}' order by timestamp desc;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-69-AuditComments', $user, $server_ip, $session_name, $one_mysql_log);
}
$ACcount = mysqli_num_rows($rslt);
if ($ACcount > 0) {
$i = 0;
while ($i < $ACcount) {
$row = mysqli_fetch_row($rslt);
$C_user[$i] = $row[0];
$C_comment[$i] = $row[1];
$C_date[$i] = $row[2];
$i++;
}
$i = 0;
while ($i < $ACcount) {
$C_name[$i] = 'Unknown';
$C_level[$i] = '1';
$FCS = '';
$FCE = '';
$stmt = "SELECT full_name,user_level from vicidial_users where user='{$C_user[$i]}';";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '00142-70-AuditCommentsUser', $user, $server_ip, $session_name, $one_mysql_log);
}
$Ucount = mysqli_num_rows($rslt);
if ($Ucount > 0) {
$row = mysqli_fetch_row($rslt);
$C_name[$i] = $row[0];
$C_level[$i] = $row[1];
}
if ($C_level[$i] > 7) {
$FCS = '--------ADMINFONTBEGIN--------';
$FCE = '--------ADMINFONTEND--------';
}
$ACcomments .= _QXZ("UserID: {$FCS}%1s - %2s{$FCE}, Date: %3s", 0, '', $C_user[$i], $C_name[$i], $C_date[$i]) . "\n";
$ACcomments .= $C_comment[$i];
$ACcomments .= "\n----------------------------------\n";
$i++;
}
return true;
} else {
return false;
}
}
开发者ID:vultuk,项目名称:VicidialSubversion,代码行数:50,代码来源:audit_comments.php
注:本文中的mysql_error_logging函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论