$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");
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='******' 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";
}
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);
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--';
}
$o++;
}
} else {
if ($DB) {
echo "ERROR: no custom data for this lead: {$lead_id}\n";
}
}
##### END grab the data from custom table for the lead_id
$CFoutput .= "<input type=hidden name=stage id=stage value=\"SUBMIT\">\n";
$CFoutput .= "<center><TABLE cellspacing=2 cellpadding=2>\n";
if ($fields_to_print < 1) {
$CFoutput .= "<tr bgcolor=white align=center><td colspan=4><font size=1>There are no custom fields for this list</td></tr>";
}
$o = 0;
$last_field_rank = 0;
while ($fields_to_print > $o) {
$helpHTML = '';
if (strlen($A_field_help[$o]) > 0) {
$helpHTML = " <a href=\"javascript:open_help('HELP_{$A_field_label[$o]}','{$A_field_help[$o]}');\">help+</a>";
}
if ($last_field_rank == "{$A_field_rank[$o]}") {
$CFoutput .= " ";
} else {
$CFoutput .= "</td></tr>\n";
$CFoutput .= "<tr bgcolor=white><td align=";
if ($A_name_position[$o] == 'TOP' or $A_field_type[$o] == 'SCRIPT') {
$CFoutput .= "left colspan=2";
} else {
$CFoutput .= "right";
}
$CFoutput .= "><font size=2>";
}
if ($A_field_type[$o] != 'SCRIPT' and $A_field_type[$o] != 'HIDDEN') {
$CFoutput .= "<B>{$A_field_name[$o]}</B>";
}
if ($A_name_position[$o] == 'TOP' or $A_field_type[$o] == 'SCRIPT') {
$CFoutput .= " <span style=\"position:static;\" id=P_HELP_{$A_field_label[$o]}></span><span style=\"position:static;background:white;\" id=HELP_{$A_field_label[$o]}> {$helpHTML}</span><BR>";
} else {
if ($last_field_rank == "{$A_field_rank[$o]}") {
$CFoutput .= " ";
} else {
$CFoutput .= "</td><td align=left><font size=2>";
}
}
$field_HTML = '';
if ($A_field_type[$o] == 'SELECT') {
$field_HTML .= "<select size=1 name={$A_field_label[$o]} id={$A_field_label[$o]}>\n";
}
if ($A_field_type[$o] == 'MULTI') {
$field_HTML .= "<select MULTIPLE size={$A_field_size[$o]} name={$A_field_label[$o]}[] id={$A_field_label[$o]}[]>\n";
}
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI' or $A_field_type[$o] == 'RADIO' or $A_field_type[$o] == 'CHECKBOX') {
$field_options_array = explode("\n", $A_field_options[$o]);
$field_options_count = count($field_options_array);
$te = 0;
while ($te < $field_options_count) {
if (preg_match("/,/", $field_options_array[$te])) {
$field_selected = '';
$field_options_value_array = explode(",", $field_options_array[$te]);
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI') {
if (strlen($A_field_value[$o]) > 0) {
if (preg_match("/{$field_options_value_array['0']}/", $A_field_value[$o])) {
$field_selected = 'SELECTED';
}
} else {
if ($A_field_default[$o] == "{$field_options_value_array['0']}") {
$field_selected = 'SELECTED';
}
}
$field_HTML .= "<option value=\"{$field_options_value_array['0']}\" {$field_selected}>{$field_options_value_array['1']}</option>\n";
}
if ($A_field_type[$o] == 'RADIO' or $A_field_type[$o] == 'CHECKBOX') {
if ($A_multi_position[$o] == 'VERTICAL') {
$field_HTML .= " ";
}
if (strlen($A_field_value[$o]) > 0) {
if (preg_match("/{$field_options_value_array['0']}/", $A_field_value[$o])) {
$field_selected = 'CHECKED';
}
} else {
if ($A_field_default[$o] == "{$field_options_value_array['0']}") {
$field_selected = 'CHECKED';
}
}
$field_HTML .= "<input type={$A_field_type[$o]} name={$A_field_label[$o]}[] id={$A_field_label[$o]}[] value=\"{$field_options_value_array['0']}\" {$field_selected}> {$field_options_value_array['1']}\n";
if ($A_multi_position[$o] == 'VERTICAL') {
$field_HTML .= "<BR>\n";
}
}
}
$te++;
}
}
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI') {
$field_HTML .= "</select>\n";
}
if ($A_field_type[$o] == 'TEXT') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
$field_HTML .= "<input type=text size={$A_field_size[$o]} maxlength={$A_field_max[$o]} name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$A_field_value[$o]}\">\n";
}
if ($A_field_type[$o] == 'AREA') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
$field_HTML .= "<textarea name={$A_field_label[$o]} id={$A_field_label[$o]} ROWS={$A_field_max[$o]} COLS={$A_field_size[$o]}>{$A_field_value[$o]}</textarea>";
}
if ($A_field_type[$o] == 'DISPLAY') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "{$A_field_default[$o]}\n";
}
if ($A_field_type[$o] == 'READONLY') {
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$A_field_value[$o]}\"> {$A_field_value[$o]}\n";
}
if ($A_field_type[$o] == 'HIDDEN') {
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$A_field_value[$o]}\">\n";
}
if ($A_field_type[$o] == 'SCRIPT') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "{$A_field_options[$o]}\n";
}
if ($A_field_type[$o] == 'DATE') {
if (strlen($A_field_default[$o]) < 1 or $A_field_default[$o] == 'NULL') {
$A_field_default[$o] = 0;
}
$day_diff = $A_field_default[$o];
$default_date = date("Y-m-d", mktime(date("H"), date("i"), date("s"), date("m"), date("d") + $day_diff, date("Y")));
if (strlen($A_field_value[$o]) > 0) {
$default_date = $A_field_value[$o];
}
$field_HTML .= "<input type=text size=11 maxlength=10 name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$default_date}\" onclick=\"f_tcalToggle()\">\n";
$field_HTML .= "<script language=\"JavaScript\">\n";
$field_HTML .= "var o_cal = new tcal ({\n";
$field_HTML .= "\t'formname': 'form_custom_fields',\n";
$field_HTML .= "\t'controlname': '{$A_field_label[$o]}'});\n";
$field_HTML .= "o_cal.a_tpl.yearscroll = false;\n";
$field_HTML .= "</script>\n";
}
if ($A_field_type[$o] == 'TIME') {
$minute_diff = $A_field_default[$o];
$default_time = date("H:i:s", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
$default_hour = date("H", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
$default_minute = date("i", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
if (strlen($A_field_value[$o]) > 2) {
$default_time = $A_field_value[$o];
$time_field_value = explode(':', $default_time);
$default_hour = $time_field_value[0];
$default_minute = $time_field_value[1];
}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$default_time}\">";
$field_HTML .= "<SELECT name=HOUR_{$A_field_label[$o]} id=HOUR_{$A_field_label[$o]}>";
$field_HTML .= "<option>00</option>";
$field_HTML .= "<option>01</option>";
$field_HTML .= "<option>02</option>";
$field_HTML .= "<option>03</option>";
$field_HTML .= "<option>04</option>";
$field_HTML .= "<option>05</option>";
$field_HTML .= "<option>06</option>";
$field_HTML .= "<option>07</option>";
$field_HTML .= "<option>08</option>";
$field_HTML .= "<option>09</option>";
$field_HTML .= "<option>10</option>";
$field_HTML .= "<option>11</option>";
$field_HTML .= "<option>12</option>";
$field_HTML .= "<option>13</option>";
$field_HTML .= "<option>14</option>";
$field_HTML .= "<option>15</option>";
$field_HTML .= "<option>16</option>";
$field_HTML .= "<option>17</option>";
$field_HTML .= "<option>18</option>";
$field_HTML .= "<option>19</option>";
$field_HTML .= "<option>20</option>";
$field_HTML .= "<option>21</option>";
$field_HTML .= "<option>22</option>";
$field_HTML .= "<option>23</option>";
$field_HTML .= "<OPTION value=\"{$default_hour}\" selected>{$default_hour}</OPTION>";
$field_HTML .= "</SELECT>";
$field_HTML .= "<SELECT name=MINUTE_{$A_field_label[$o]} id=MINUTE_{$A_field_label[$o]}>";
$field_HTML .= "<option>00</option>";
$field_HTML .= "<option>05</option>";
$field_HTML .= "<option>10</option>";
$field_HTML .= "<option>15</option>";
$field_HTML .= "<option>20</option>";
$field_HTML .= "<option>25</option>";
$field_HTML .= "<option>30</option>";
$field_HTML .= "<option>35</option>";
$field_HTML .= "<option>40</option>";
$field_HTML .= "<option>45</option>";
$field_HTML .= "<option>50</option>";
$field_HTML .= "<option>55</option>";
$field_HTML .= "<OPTION value=\"{$default_minute}\" selected>{$default_minute}</OPTION>";
$field_HTML .= "</SELECT>";
}
if ($A_name_position[$o] == 'LEFT' and $A_field_type[$o] != 'SCRIPT' and $A_field_type[$o] != 'HIDDEN') {
$CFoutput .= " {$field_HTML} <span style=\"position:static;\" id=P_HELP_{$A_field_label[$o]}></span><span style=\"position:static;background:white;\" id=HELP_{$A_field_label[$o]}> {$helpHTML}</span>";
} else {
$CFoutput .= " {$field_HTML}\n";
}
$last_field_rank = $A_field_rank[$o];
$o++;
}
$CFoutput .= "</td></tr></table>\n";
} else {
$CFoutput .= "ERROR: no custom list fields\n";
}
} else {
$CFoutput .= "ERROR: no custom list fields table\n";
}
##### BEGIN parsing for vicidial variables #####
if (preg_match("/--A--/", $CFoutput)) {
if (eregi('--A--user_custom_', $CFoutput) or eregi('--A--fullname', $CFoutput)) {
$stmt = "select custom_one,custom_two,custom_three,custom_four,custom_five,full_name from vicidial_users where user='******';";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05006', $user, $server_ip, $session_name, $one_mysql_log);
}
$VUC_ct = mysql_num_rows($rslt);
if ($VUC_ct > 0) {
$row = mysql_fetch_row($rslt);
$user_custom_one = trim($row[0]);
$user_custom_two = trim($row[1]);
$user_custom_three = trim($row[2]);
$user_custom_four = trim($row[3]);
$user_custom_five = trim($row[4]);
$fullname = trim($row[5]);
}
}
if (eregi('--A--dialed_', $CFoutput)) {
$dialed_number = $phone_number;
$dialed_label = 'NONE';
### find the dialed number and label for this call
$stmt = "SELECT phone_number,alt_dial from vicidial_log where uniqueid='{$uniqueid}';";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05008', $user, $server_ip, $session_name, $one_mysql_log);
}
$vl_dialed_ct = mysql_num_rows($rslt);
if ($vl_dialed_ct > 0) {
$row = mysql_fetch_row($rslt);
$dialed_number = $row[0];
$dialed_label = $row[1];
}
}
##### grab the data from vicidial_list for the lead_id
$stmt = "SELECT lead_id,entry_date,modify_date,status,user,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 FROM vicidial_list where lead_id='{$lead_id}' LIMIT 1;";
$rslt = mysql_query($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05007', $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);
$dispo = trim($row[3]);
$tsr = trim($row[4]);
$vendor_id = trim($row[5]);
$vendor_lead_code = trim($row[5]);
$source_id = trim($row[6]);
$list_id = trim($row[7]);
$gmt_offset_now = trim($row[8]);
$phone_code = trim($row[10]);
$phone_number = trim($row[11]);
$title = trim($row[12]);
$first_name = trim($row[13]);
$middle_initial = trim($row[14]);
$last_name = trim($row[15]);
$address1 = trim($row[16]);
$address2 = trim($row[17]);
$address3 = trim($row[18]);
$city = trim($row[19]);
$state = trim($row[20]);
$province = trim($row[21]);
$postal_code = trim($row[22]);
$country_code = trim($row[23]);
$gender = trim($row[24]);
$date_of_birth = trim($row[25]);
$alt_phone = trim($row[26]);
$email = trim($row[27]);
$security = trim($row[28]);
$comments = trim($row[29]);
$called_count = trim($row[30]);
$rank = trim($row[32]);
$owner = trim($row[33]);
}
$CFoutput = eregi_replace('--A--lead_id--B--', "{$lead_id}", $CFoutput);
$CFoutput = eregi_replace('--A--vendor_id--B--', "{$vendor_id}", $CFoutput);
$CFoutput = eregi_replace('--A--vendor_lead_code--B--', "{$vendor_lead_code}", $CFoutput);
$CFoutput = eregi_replace('--A--list_id--B--', "{$list_id}", $CFoutput);
$CFoutput = eregi_replace('--A--gmt_offset_now--B--', "{$gmt_offset_now}", $CFoutput);
$CFoutput = eregi_replace('--A--phone_code--B--', "{$phone_code}", $CFoutput);
$CFoutput = eregi_replace('--A--phone_number--B--', "{$phone_number}", $CFoutput);
$CFoutput = eregi_replace('--A--title--B--', "{$title}", $CFoutput);
$CFoutput = eregi_replace('--A--first_name--B--', "{$first_name}", $CFoutput);
$CFoutput = eregi_replace('--A--middle_initial--B--', "{$middle_initial}", $CFoutput);
$CFoutput = eregi_replace('--A--last_name--B--', "{$last_name}", $CFoutput);
$CFoutput = eregi_replace('--A--address1--B--', "{$address1}", $CFoutput);
$CFoutput = eregi_replace('--A--address2--B--', "{$address2}", $CFoutput);
$CFoutput = eregi_replace('--A--address3--B--', "{$address3}", $CFoutput);
$CFoutput = eregi_replace('--A--city--B--', "{$city}", $CFoutput);
$CFoutput = eregi_replace('--A--state--B--', "{$state}", $CFoutput);
$CFoutput = eregi_replace('--A--province--B--', "{$province}", $CFoutput);
$CFoutput = eregi_replace('--A--postal_code--B--', "{$postal_code}", $CFoutput);
$CFoutput = eregi_replace('--A--country_code--B--', "{$country_code}", $CFoutput);
$CFoutput = eregi_replace('--A--gender--B--', "{$gender}", $CFoutput);
$CFoutput = eregi_replace('--A--date_of_birth--B--', "{$date_of_birth}", $CFoutput);
$CFoutput = eregi_replace('--A--alt_phone--B--', "{$alt_phone}", $CFoutput);
$CFoutput = eregi_replace('--A--email--B--', "{$email}", $CFoutput);
$CFoutput = eregi_replace('--A--security_phrase--B--', "{$security_phrase}", $CFoutput);
$CFoutput = eregi_replace('--A--comments--B--', "{$comments}", $CFoutput);
$CFoutput = eregi_replace('--A--user--B--', "{$user}", $CFoutput);
$CFoutput = eregi_replace('--A--pass--B--', "{$pass}", $CFoutput);
$CFoutput = eregi_replace('--A--campaign--B--', "{$campaign}", $CFoutput);
$CFoutput = eregi_replace('--A--server_ip--B--', "{$server_ip}", $CFoutput);
$CFoutput = eregi_replace('--A--session_id--B--', "{$session_id}", $CFoutput);
$CFoutput = eregi_replace('--A--dialed_number--B--', "{$dialed_number}", $CFoutput);
$CFoutput = eregi_replace('--A--dialed_label--B--', "{$dialed_label}", $CFoutput);
$CFoutput = eregi_replace('--A--source_id--B--', "{$source_id}", $CFoutput);
$CFoutput = eregi_replace('--A--rank--B--', "{$rank}", $CFoutput);
$CFoutput = eregi_replace('--A--owner--B--', "{$owner}", $CFoutput);
$CFoutput = eregi_replace('--A--fullname--B--', "{$fullname}", $CFoutput);
$CFoutput = eregi_replace('--A--uniqueid--B--', "{$uniqueid}", $CFoutput);
$CFoutput = eregi_replace('--A--user_custom_one--B--', "{$user_custom_one}", $CFoutput);
$CFoutput = eregi_replace('--A--user_custom_two--B--', "{$user_custom_two}", $CFoutput);
$CFoutput = eregi_replace('--A--user_custom_three--B--', "{$user_custom_three}", $CFoutput);
$CFoutput = eregi_replace('--A--user_custom_four--B--', "{$user_custom_four}", $CFoutput);
$CFoutput = eregi_replace('--A--user_custom_five--B--', "{$user_custom_five}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_number_a--B--', "{$preset_number_a}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_number_b--B--', "{$preset_number_b}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_number_c--B--', "{$preset_number_c}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_number_d--B--', "{$preset_number_d}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_number_e--B--', "{$preset_number_e}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_dtmf_a--B--', "{$preset_dtmf_a}", $CFoutput);
$CFoutput = eregi_replace('--A--preset_dtmf_b--B--', "{$preset_dtmf_b}", $CFoutput);
$CFoutput = eregi_replace('--A--did_id--B--', "{$did_id}", $CFoutput);
$CFoutput = eregi_replace('--A--did_extension--B--', "{$did_extension}", $CFoutput);
$CFoutput = eregi_replace('--A--did_pattern--B--', "{$did_pattern}", $CFoutput);
$CFoutput = eregi_replace('--A--did_description--B--', "{$did_description}", $CFoutput);
$CFoutput = eregi_replace('--A--closecallid--B--', "{$closecallid}", $CFoutput);
$CFoutput = eregi_replace('--A--xfercallid--B--', "{$xfercallid}", $CFoutput);
$CFoutput = eregi_replace('--A--agent_log_id--B--', "{$agent_log_id}", $CFoutput);
# custom fields replacement
$o = 0;
while ($fields_to_print > $o) {
$CFoutput = eregi_replace("--A--{$A_field_label[$o]}--B--", "{$A_field_value[$o]}", $CFoutput);
$o++;
}
if ($DB > 0) {
echo "{$CFoutput}<BR>\n";
}
}
##### END parsing for vicidial variables #####
return $CFoutput;
}
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] = '';
}
if (preg_match("/\\|{$A_field_label[$o]}\\|/i", $vicidial_list_fields)) {
$A_field_value[$o] = '--A--' . $A_field_label[$o] . '--B--';
}
$o++;
}
} else {
if ($DB) {
echo _QXZ("ERROR: no custom data for this lead: ") . "{$lead_id}\n";
}
}
##### END grab the data from custom table for the lead_id
$CFoutput .= "<input type=hidden name=stage id=stage value=\"SUBMIT\">\n";
$CFoutput .= "<center><TABLE cellspacing=2 cellpadding=2>\n";
if ($fields_to_print < 1) {
$CFoutput .= "<tr bgcolor=white align=center><td colspan=4><font size=1>" . _QXZ("There are no custom fields for this list") . "</td></tr>";
}
$o = 0;
$last_field_rank = 0;
while ($fields_to_print > $o) {
$helpHTML = '';
if (strlen($A_field_help[$o]) > 0) {
$helpHTML = " <a href=\"javascript:open_help('HELP_{$A_field_label[$o]}','{$A_field_help[$o]}');\">" . _QXZ("help") . "+</a>";
}
if ($last_field_rank == "{$A_field_rank[$o]}") {
$CFoutput .= " ";
} else {
$CFoutput .= "</td></tr>\n";
$CFoutput .= "<tr bgcolor=white><td align=";
if ($A_name_position[$o] == 'TOP' or $A_field_type[$o] == 'SCRIPT') {
$CFoutput .= "left colspan=2";
} else {
$CFoutput .= "right";
}
$CFoutput .= "><font size=2>";
}
if ($A_field_type[$o] != 'SCRIPT' and $A_field_type[$o] != 'HIDDEN' and $A_field_type[$o] != 'HIDEBLOB') {
$CFoutput .= "<B>{$A_field_name[$o]}</B>";
}
if ($A_name_position[$o] == 'TOP' or $A_field_type[$o] == 'SCRIPT') {
$CFoutput .= " <span style=\"position:static;\" id=P_HELP_{$A_field_label[$o]}></span><span style=\"position:static;background:white;\" id=HELP_{$A_field_label[$o]}> {$helpHTML}</span><BR>";
} else {
if ($last_field_rank == "{$A_field_rank[$o]}") {
$CFoutput .= " ";
} else {
$CFoutput .= "</td><td align=left><font size=2>";
}
}
$field_HTML = '';
if ($A_field_type[$o] == 'SELECT') {
$field_HTML .= "<select size=1 name={$A_field_label[$o]} id={$A_field_label[$o]}>\n";
}
if ($A_field_type[$o] == 'MULTI') {
$field_HTML .= "<select MULTIPLE size={$A_field_size[$o]} name={$A_field_label[$o]}[] id={$A_field_label[$o]}[]>\n";
}
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI' or $A_field_type[$o] == 'RADIO' or $A_field_type[$o] == 'CHECKBOX') {
$field_options_array = explode("\n", $A_field_options[$o]);
$field_options_count = count($field_options_array);
$te = 0;
while ($te < $field_options_count) {
if (preg_match("/,/", $field_options_array[$te])) {
$field_selected = '';
$field_options_value_array = explode(",", $field_options_array[$te]);
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI') {
if (strlen($A_field_value[$o]) > 0) {
if (preg_match("/{$field_options_value_array['0']}/", $A_field_value[$o])) {
$field_selected = 'SELECTED';
}
} else {
if ($A_field_default[$o] == "{$field_options_value_array['0']}") {
$field_selected = 'SELECTED';
}
}
$field_HTML .= "<option value=\"{$field_options_value_array['0']}\" {$field_selected}>" . _QXZ("{$field_options_value_array['1']}") . "</option>\n";
}
if ($A_field_type[$o] == 'RADIO' or $A_field_type[$o] == 'CHECKBOX') {
if ($A_multi_position[$o] == 'VERTICAL') {
$field_HTML .= " ";
}
if (strlen($A_field_value[$o]) > 0) {
if (preg_match("/{$field_options_value_array['0']}/", $A_field_value[$o])) {
$field_selected = 'CHECKED';
}
} else {
if ($A_field_default[$o] == "{$field_options_value_array['0']}") {
$field_selected = 'CHECKED';
}
}
$field_HTML .= "<input type={$A_field_type[$o]} name={$A_field_label[$o]}[] id={$A_field_label[$o]}[] value=\"{$field_options_value_array['0']}\" {$field_selected}> " . _QXZ("{$field_options_value_array['1']}") . "\n";
if ($A_multi_position[$o] == 'VERTICAL') {
$field_HTML .= "<BR>\n";
}
}
}
$te++;
}
}
if ($A_field_type[$o] == 'SELECT' or $A_field_type[$o] == 'MULTI') {
$field_HTML .= "</select>\n";
}
if ($A_field_type[$o] == 'TEXT') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
$field_HTML .= "<input type=text size={$A_field_size[$o]} maxlength={$A_field_max[$o]} name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"" . _QXZ("{$A_field_value[$o]}") . "\">\n";
}
if ($A_field_type[$o] == 'AREA') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
$field_HTML .= "<textarea name={$A_field_label[$o]} id={$A_field_label[$o]} ROWS={$A_field_max[$o]} COLS={$A_field_size[$o]}>{$A_field_value[$o]}</textarea>";
}
if ($A_field_type[$o] == 'DISPLAY') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= _QXZ("{$A_field_default[$o]}") . "\n";
}
if ($A_field_type[$o] == 'READONLY') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
# if (strlen($A_field_value[$o]) < 1) {$A_field_value[$o] = $A_field_default[$o];}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$A_field_value[$o]}\"> " . _QXZ("{$A_field_value[$o]}") . "\n";
}
if ($A_field_type[$o] == 'HIDDEN' or $A_field_type[$o] == 'HIDEBLOB') {
if (strlen($A_field_value[$o]) < 1) {
$A_field_value[$o] = $A_field_default[$o];
}
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$A_field_value[$o]}\">\n";
}
if ($A_field_type[$o] == 'SCRIPT') {
if ($A_field_default[$o] == 'NULL') {
$A_field_default[$o] = '';
}
$field_HTML .= "{$A_field_options[$o]}\n";
}
if ($A_field_type[$o] == 'DATE') {
if (strlen($A_field_default[$o]) < 1 or $A_field_default[$o] == 'NULL') {
$A_field_default[$o] = 0;
}
$day_diff = $A_field_default[$o];
$default_date = date("Y-m-d", mktime(date("H"), date("i"), date("s"), date("m"), date("d") + $day_diff, date("Y")));
if (strlen($A_field_value[$o]) > 0) {
$default_date = $A_field_value[$o];
}
$field_HTML .= "<input type=text size=11 maxlength=10 name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$default_date}\" onclick=\"f_tcalToggle()\">\n";
$field_HTML .= "<script language=\"JavaScript\">\n";
$field_HTML .= "var o_cal = new tcal ({\n";
$field_HTML .= "\t'formname': 'form_custom_fields',\n";
$field_HTML .= "\t'controlname': '{$A_field_label[$o]}'});\n";
$field_HTML .= "o_cal.a_tpl.yearscroll = false;\n";
$field_HTML .= "</script>\n";
}
if ($A_field_type[$o] == 'TIME') {
$minute_diff = $A_field_default[$o];
$default_time = date("H:i:s", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
$default_hour = date("H", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
$default_minute = date("i", mktime(date("H"), date("i") + $minute_diff, date("s"), date("m"), date("d"), date("Y")));
if (strlen($A_field_value[$o]) > 2) {
$default_time = $A_field_value[$o];
$time_field_value = explode(':', $default_time);
$default_hour = $time_field_value[0];
$default_minute = $time_field_value[1];
}
$field_HTML .= "<input type=hidden name={$A_field_label[$o]} id={$A_field_label[$o]} value=\"{$default_time}\">";
$field_HTML .= "<SELECT name=HOUR_{$A_field_label[$o]} id=HOUR_{$A_field_label[$o]}>";
$field_HTML .= "<option>00</option>";
$field_HTML .= "<option>01</option>";
$field_HTML .= "<option>02</option>";
$field_HTML .= "<option>03</option>";
$field_HTML .= "<option>04</option>";
$field_HTML .= "<option>05</option>";
$field_HTML .= "<option>06</option>";
$field_HTML .= "<option>07</option>";
$field_HTML .= "<option>08</option>";
$field_HTML .= "<option>09</option>";
$field_HTML .= "<option>10</option>";
$field_HTML .= "<option>11</option>";
$field_HTML .= "<option>12</option>";
$field_HTML .= "<option>13</option>";
$field_HTML .= "<option>14</option>";
$field_HTML .= "<option>15</option>";
$field_HTML .= "<option>16</option>";
$field_HTML .= "<option>17</option>";
$field_HTML .= "<option>18</option>";
$field_HTML .= "<option>19</option>";
$field_HTML .= "<option>20</option>";
$field_HTML .= "<option>21</option>";
$field_HTML .= "<option>22</option>";
$field_HTML .= "<option>23</option>";
$field_HTML .= "<OPTION value=\"{$default_hour}\" selected>{$default_hour}</OPTION>";
$field_HTML .= "</SELECT>";
$field_HTML .= "<SELECT name=MINUTE_{$A_field_label[$o]} id=MINUTE_{$A_field_label[$o]}>";
$field_HTML .= "<option>00</option>";
$field_HTML .= "<option>05</option>";
$field_HTML .= "<option>10</option>";
$field_HTML .= "<option>15</option>";
$field_HTML .= "<option>20</option>";
$field_HTML .= "<option>25</option>";
$field_HTML .= "<option>30</option>";
$field_HTML .= "<option>35</option>";
$field_HTML .= "<option>40</option>";
$field_HTML .= "<option>45</option>";
$field_HTML .= "<option>50</option>";
$field_HTML .= "<option>55</option>";
$field_HTML .= "<OPTION value=\"{$default_minute}\" selected>{$default_minute}</OPTION>";
$field_HTML .= "</SELECT>";
}
if ($A_name_position[$o] == 'LEFT' and $A_field_type[$o] != 'SCRIPT' and $A_field_type[$o] != 'HIDDEN' and $A_field_type[$o] != 'HIDEBLOB') {
$CFoutput .= " {$field_HTML} <span style=\"position:static;\" id=P_HELP_{$A_field_label[$o]}></span><span style=\"position:static;background:white;\" id=HELP_{$A_field_label[$o]}> {$helpHTML}</span>";
} else {
$CFoutput .= " {$field_HTML}\n";
}
$last_field_rank = $A_field_rank[$o];
$o++;
}
$CFoutput .= "</td></tr></table>\n";
} else {
$CFoutput .= _QXZ("ERROR: no custom list fields") . "\n";
}
} else {
$CFoutput .= _QXZ("ERROR: no custom list fields table") . "\n";
}
##### BEGIN parsing for vicidial variables #####
$NOTESout = '';
if (preg_match("/--A--/", $CFoutput)) {
if (preg_match('/--A--user_custom_/i', $CFoutput) or preg_match('/--A--fullname/i', $CFoutput)) {
$stmt = "select custom_one,custom_two,custom_three,custom_four,custom_five,full_name from vicidial_users where user='******';";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05006', $user, $server_ip, $session_name, $one_mysql_log);
}
$VUC_ct = mysqli_num_rows($rslt);
if ($VUC_ct > 0) {
$row = mysqli_fetch_row($rslt);
$user_custom_one = trim($row[0]);
$user_custom_two = trim($row[1]);
$user_custom_three = trim($row[2]);
$user_custom_four = trim($row[3]);
$user_custom_five = trim($row[4]);
$fullname = trim($row[5]);
}
}
if (preg_match('/--A--dialed_/i', $CFoutput)) {
$dialed_number = $phone_number;
$dialed_label = _QXZ("NONE");
### find the dialed number and label for this call
$stmt = "SELECT phone_number,alt_dial from vicidial_log where uniqueid='{$uniqueid}';";
if ($DB) {
echo "{$stmt}\n";
}
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05008', $user, $server_ip, $session_name, $one_mysql_log);
}
$vl_dialed_ct = mysqli_num_rows($rslt);
if ($vl_dialed_ct > 0) {
$row = mysqli_fetch_row($rslt);
$dialed_number = $row[0];
$dialed_label = $row[1];
}
}
if (preg_match('/--A--TABLEper_call_notes--B--/i', $CFoutput)) {
### BEGIN Gather Call Log and notes ###
if ($hide_call_log_info != 'Y') {
if ($search != 'logfirst') {
$NOTESout .= _QXZ("CALL LOG FOR THIS LEAD:") . "<br>\n";
}
$NOTESout .= "<TABLE CELLPADDING=0 CELLSPACING=1 BORDER=0 WIDTH={$stage}>";
$NOTESout .= "<TR>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:10px;font-family:sans-serif;\"><B> # </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("DATE/TIME") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("AGENT") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("LENGTH") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("STATUS") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("PHONE") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("CAMPAIGN") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("IN/OUT") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("ALT") . " </font></TD>";
$NOTESout .= "<TD BGCOLOR=\"#CCCCCC\"><font style=\"font-size:11px;font-family:sans-serif;\"><B> " . _QXZ("HANGUP") . " </font></TD>";
# $NOTESout .= "</TR><TR>";
# $NOTESout .= "<TD BGCOLOR=\"#CCCCCC\" COLSPAN=9><font style=\"font-size:11px;font-family:sans-serif;\"><B> FULL NAME </font></TD>";
$NOTESout .= "</TR>";
$stmt = "SELECT start_epoch,call_date,campaign_id,length_in_sec,status,phone_code,phone_number,lead_id,term_reason,alt_dial,comments,uniqueid,user from vicidial_log where lead_id='{$lead_id}' order by call_date desc limit 10000;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05014', $user, $server_ip, $session_name, $one_mysql_log);
}
$out_logs_to_print = mysqli_num_rows($rslt);
if ($format == 'debug') {
$NOTESout .= "|{$out_logs_to_print}|{$stmt}|";
}
$g = 0;
$u = 0;
while ($out_logs_to_print > $u) {
$row = mysqli_fetch_row($rslt);
$ALLsort[$g] = "{$row['0']}-----{$g}";
$ALLstart_epoch[$g] = $row[0];
$ALLcall_date[$g] = $row[1];
$ALLcampaign_id[$g] = $row[2];
$ALLlength_in_sec[$g] = $row[3];
$ALLstatus[$g] = $row[4];
$ALLphone_code[$g] = $row[5];
$ALLphone_number[$g] = $row[6];
$ALLlead_id[$g] = $row[7];
$ALLhangup_reason[$g] = $row[8];
$ALLalt_dial[$g] = $row[9];
$ALLuniqueid[$g] = $row[11];
$ALLuser[$g] = $row[12];
$ALLin_out[$g] = "OUT-AUTO";
if ($row[10] == 'MANUAL') {
$ALLin_out[$g] = "OUT-MANUAL";
}
$stmtA = "SELECT call_notes FROM vicidial_call_notes WHERE lead_id='{$ALLlead_id[$g]}' and vicidial_id='{$ALLuniqueid[$g]}';";
$rsltA = mysql_to_mysqli($stmtA, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05015', $user, $server_ip, $session_name, $one_mysql_log);
}
$out_notes_to_print = mysqli_num_rows($rslt);
if ($out_notes_to_print > 0) {
$rowA = mysqli_fetch_row($rsltA);
$Allcall_notes[$g] = $rowA[0];
if (strlen($Allcall_notes[$g]) > 0) {
$Allcall_notes[$g] = "<b>" . _QXZ("NOTES:") . " </b> " . _QXZ("{$Allcall_notes[$g]}");
}
}
$stmtA = "SELECT full_name FROM vicidial_users WHERE user='******';";
$rsltA = mysql_to_mysqli($stmtA, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05016', $user, $server_ip, $session_name, $one_mysql_log);
}
$users_to_print = mysqli_num_rows($rslt);
if ($users_to_print > 0) {
$rowA = mysqli_fetch_row($rsltA);
$ALLuser[$g] .= " - {$rowA['0']}";
}
$Allcounter[$g] = $g;
$g++;
$u++;
}
$stmt = "SELECT start_epoch,call_date,campaign_id,length_in_sec,status,phone_code,phone_number,lead_id,term_reason,queue_seconds,uniqueid,closecallid,user from vicidial_closer_log where lead_id='{$lead_id}' order by call_date desc limit 10000;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05017', $user, $server_ip, $session_name, $one_mysql_log);
}
$in_logs_to_print = mysqli_num_rows($rslt);
if ($format == 'debug') {
$NOTESout .= "|{$in_logs_to_print}|{$stmt}|";
}
$u = 0;
while ($in_logs_to_print > $u) {
$row = mysqli_fetch_row($rslt);
$ALLsort[$g] = "{$row['0']}-----{$g}";
$ALLstart_epoch[$g] = $row[0];
$ALLcall_date[$g] = $row[1];
$ALLcampaign_id[$g] = $row[2];
$ALLlength_in_sec[$g] = $row[3] - $row[9];
if ($ALLlength_in_sec[$g] < 0) {
$ALLlength_in_sec[$g] = 0;
}
$ALLstatus[$g] = $row[4];
$ALLphone_code[$g] = $row[5];
$ALLphone_number[$g] = $row[6];
$ALLlead_id[$g] = $row[7];
$ALLhangup_reason[$g] = $row[8];
$ALLuniqueid[$g] = $row[10];
$ALLclosecallid[$g] = $row[11];
$ALLuser[$g] = $row[12];
$ALLalt_dial[$g] = "MAIN";
$ALLin_out[$g] = "IN";
$stmtA = "SELECT call_notes FROM vicidial_call_notes WHERE lead_id='{$ALLlead_id[$g]}' and vicidial_id='{$ALLclosecallid[$g]}';";
$rsltA = mysql_to_mysqli($stmtA, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05018', $user, $server_ip, $session_name, $one_mysql_log);
}
$in_notes_to_print = mysqli_num_rows($rslt);
if ($in_notes_to_print > 0) {
$rowA = mysqli_fetch_row($rsltA);
$Allcall_notes[$g] = $rowA[0];
if (strlen($Allcall_notes[$g]) > 0) {
$Allcall_notes[$g] = "<b>" . _QXZ("NOTES") . ": </b> " . _QXZ("{$Allcall_notes[$g]}");
}
}
$stmtA = "SELECT full_name FROM vicidial_users WHERE user='******';";
$rsltA = mysql_to_mysqli($stmtA, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05019', $user, $server_ip, $session_name, $one_mysql_log);
}
$users_to_print = mysqli_num_rows($rslt);
if ($users_to_print > 0) {
$rowA = mysqli_fetch_row($rsltA);
$ALLuser[$g] .= " - {$rowA['0']}";
}
$Allcounter[$g] = $g;
$g++;
$u++;
}
if ($g > 0) {
sort($ALLsort, SORT_NUMERIC);
} else {
$NOTESout .= "<tr bgcolor=white><td colspan=11 align=center>" . _QXZ("No calls found") . "</td></tr>";
}
$u = 0;
while ($g > $u) {
$sort_split = explode("-----", $ALLsort[$u]);
$i = $sort_split[1];
if (preg_match("/1\$|3\$|5\$|7\$|9\$/i", $u)) {
$bgcolor = 'bgcolor="#B9CBFD"';
} else {
$bgcolor = 'bgcolor="#9BB9FB"';
}
$phone_number_display = $ALLphone_number[$i];
if ($disable_alter_custphone == 'HIDE') {
$phone_number_display = 'XXXXXXXXXX';
}
$u++;
$NOTESout .= "<tr {$bgcolor}>";
$NOTESout .= "<td><font size=1>{$u}</td>";
$NOTESout .= "<td align=right><font size=2>{$ALLcall_date[$i]}</td>";
$NOTESout .= "<td align=right><font size=2> {$ALLuser[$i]}</td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLlength_in_sec[$i]}</td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLstatus[$i]}</td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLphone_code[$i]} {$phone_number_display} </td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLcampaign_id[$i]} </td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLin_out[$i]} </td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLalt_dial[$i]} </td>\n";
$NOTESout .= "<td align=right><font size=2> {$ALLhangup_reason[$i]} </td>\n";
$NOTESout .= "</TR><TR>";
$NOTESout .= "<td></td>";
$NOTESout .= "<TD {$bgcolor} COLSPAN=9 align=left><font style=\"font-size:11px;font-family:sans-serif;\"> " . _QXZ("{$Allcall_notes[$i]}") . " </font></TD>";
$NOTESout .= "</tr>\n";
}
$NOTESout .= "</TABLE>";
$NOTESout .= "<BR>";
}
### END Gather Call Log and notes ###
}
##### grab the data from vicidial_list for the lead_id
$stmt = "SELECT lead_id,entry_date,modify_date,status,user,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 FROM vicidial_list where lead_id='{$lead_id}' LIMIT 1;";
$rslt = mysql_to_mysqli($stmt, $link);
if ($mel > 0) {
mysql_error_logging($NOW_TIME, $link, $mel, $stmt, '05007', $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);
$dispo = trim($row[3]);
$tsr = trim($row[4]);
$vendor_id = trim($row[5]);
$vendor_lead_code = trim($row[5]);
$source_id = trim($row[6]);
$list_id = trim($row[7]);
$gmt_offset_now = trim($row[8]);
$phone_code = trim($row[10]);
$phone_number = trim($row[11]);
$title = trim($row[12]);
$first_name = trim($row[13]);
$middle_initial = trim($row[14]);
$last_name = trim($row[15]);
$address1 = trim($row[16]);
$address2 = trim($row[17]);
$address3 = trim($row[18]);
$city = trim($row[19]);
$state = trim($row[20]);
$province = trim($row[21]);
$postal_code = trim($row[22]);
$country_code = trim($row[23]);
$gender = trim($row[24]);
$date_of_birth = trim($row[25]);
$alt_phone = trim($row[26]);
$email = trim($row[27]);
$security = trim($row[28]);
$comments = trim($row[29]);
$called_count = trim($row[30]);
$rank = trim($row[32]);
$owner = trim($row[33]);
}
$CFoutput = preg_replace('/--A--lead_id--B--/i', "{$lead_id}", $CFoutput);
$CFoutput = preg_replace('/--A--vendor_id--B--/i', "{$vendor_id}", $CFoutput);
$CFoutput = preg_replace('/--A--vendor_lead_code--B--/i', "{$vendor_lead_code}", $CFoutput);
$CFoutput = preg_replace('/--A--list_id--B--/i', "{$list_id}", $CFoutput);
$CFoutput = preg_replace('/--A--gmt_offset_now--B--/i', "{$gmt_offset_now}", $CFoutput);
$CFoutput = preg_replace('/--A--phone_code--B--/i', "{$phone_code}", $CFoutput);
$CFoutput = preg_replace('/--A--phone_number--B--/i', "{$phone_number}", $CFoutput);
$CFoutput = preg_replace('/--A--title--B--/i', "{$title}", $CFoutput);
$CFoutput = preg_replace('/--A--first_name--B--/i', "{$first_name}", $CFoutput);
$CFoutput = preg_replace('/--A--middle_initial--B--/i', "{$middle_initial}", $CFoutput);
$CFoutput = preg_replace('/--A--last_name--B--/i', "{$last_name}", $CFoutput);
$CFoutput = preg_replace('/--A--address1--B--/i', "{$address1}", $CFoutput);
$CFoutput = preg_replace('/--A--address2--B--/i', "{$address2}", $CFoutput);
$CFoutput = preg_replace('/--A--address3--B--/i', "{$address3}", $CFoutput);
$CFoutput = preg_replace('/--A--city--B--/i', "{$city}", $CFoutput);
$CFoutput = preg_replace('/--A--state--B--/i', "{$state}", $CFoutput);
$CFoutput = preg_replace('/--A--province--B--/i', "{$province}", $CFoutput);
$CFoutput = preg_replace('/--A--postal_code--B--/i', "{$postal_code}", $CFoutput);
$CFoutput = preg_replace('/--A--country_code--B--/i', "{$country_code}", $CFoutput);
$CFoutput = preg_replace('/--A--gender--B--/i', "{$gender}", $CFoutput);
$CFoutput = preg_replace('/--A--date_of_birth--B--/i', "{$date_of_birth}", $CFoutput);
$CFoutput = preg_replace('/--A--alt_phone--B--/i', "{$alt_phone}", $CFoutput);
$CFoutput = preg_replace('/--A--email--B--/i', "{$email}", $CFoutput);
$CFoutput = preg_replace('/--A--security_phrase--B--/i', "{$security_phrase}", $CFoutput);
$CFoutput = preg_replace('/--A--comments--B--/i', "{$comments}", $CFoutput);
$CFoutput = preg_replace('/--A--user--B--/i', "{$user}", $CFoutput);
$CFoutput = preg_replace('/--A--pass--B--/i', "{$pass}", $CFoutput);
$CFoutput = preg_replace('/--A--campaign--B--/i', "{$campaign}", $CFoutput);
$CFoutput = preg_replace('/--A--server_ip--B--/i', "{$server_ip}", $CFoutput);
$CFoutput = preg_replace('/--A--session_id--B--/i', "{$session_id}", $CFoutput);
$CFoutput = preg_replace('/--A--dialed_number--B--/i', "{$dialed_number}", $CFoutput);
$CFoutput = preg_replace('/--A--dialed_label--B--/i', "{$dialed_label}", $CFoutput);
$CFoutput = preg_replace('/--A--source_id--B--/i', "{$source_id}", $CFoutput);
$CFoutput = preg_replace('/--A--rank--B--/i', "{$rank}", $CFoutput);
$CFoutput = preg_replace('/--A--owner--B--/i', "{$owner}", $CFoutput);
$CFoutput = preg_replace('/--A--fullname--B--/i', "{$fullname}", $CFoutput);
$CFoutput = preg_replace('/--A--uniqueid--B--/i', "{$uniqueid}", $CFoutput);
$CFoutput = preg_replace('/--A--user_custom_one--B--/i', "{$user_custom_one}", $CFoutput);
$CFoutput = preg_replace('/--A--user_custom_two--B--/i', "{$user_custom_two}", $CFoutput);
$CFoutput = preg_replace('/--A--user_custom_three--B--/i', "{$user_custom_three}", $CFoutput);
$CFoutput = preg_replace('/--A--user_custom_four--B--/i', "{$user_custom_four}", $CFoutput);
$CFoutput = preg_replace('/--A--user_custom_five--B--/i', "{$user_custom_five}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_number_a--B--/i', "{$preset_number_a}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_number_b--B--/i', "{$preset_number_b}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_number_c--B--/i', "{$preset_number_c}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_number_d--B--/i', "{$preset_number_d}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_number_e--B--/i', "{$preset_number_e}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_dtmf_a--B--/i', "{$preset_dtmf_a}", $CFoutput);
$CFoutput = preg_replace('/--A--preset_dtmf_b--B--/i', "{$preset_dtmf_b}", $CFoutput);
$CFoutput = preg_replace('/--A--did_id--B--/i', "{$did_id}", $CFoutput);
$CFoutput = preg_replace('/--A--did_extension--B--/i', "{$did_extension}", $CFoutput);
$CFoutput = preg_replace('/--A--did_pattern--B--/i', "{$did_pattern}", $CFoutput);
$CFoutput = preg_replace('/--A--did_description--B--/i', "{$did_description}", $CFoutput);
$CFoutput = preg_replace('/--A--closecallid--B--/i', "{$closecallid}", $CFoutput);
$CFoutput = preg_replace('/--A--xfercallid--B--/i', "{$xfercallid}", $CFoutput);
$CFoutput = preg_replace('/--A--agent_log_id--B--/i', "{$agent_log_id}", $CFoutput);
$CFoutput = preg_replace('/--A--call_id--B--/i', "{$call_id}", $CFoutput);
$CFoutput = preg_replace('/--A--called_count--B--/i', "{$called_count}", $CFoutput);
$CFoutput = preg_replace('/--A--did_custom_one--B--/i', "{$did_custom_one}", $CFoutput);
$CFoutput = preg_replace('/--A--did_custom_two--B--/i', "{$did_custom_two}", $CFoutput);
$CFoutput = preg_replace('/--A--did_custom_three--B--/i', "{$did_custom_three}", $CFoutput);
$CFoutput = preg_replace('/--A--did_custom_four--B--/i', "{$did_custom_four}", $CFoutput);
$CFoutput = preg_replace('/--A--did_custom_five--B--/i', "{$did_custom_five}", $CFoutput);
$CFoutput = preg_replace('/--A--TABLEper_call_notes--B--/i', "{$NOTESout}", $CFoutput);
# custom fields replacement
$o = 0;
while ($fields_to_print > $o) {
$CFoutput = preg_replace("/--A--{$A_field_label[$o]}--B--/i", "{$A_field_value[$o]}", $CFoutput);
$o++;
}
if ($DB > 0) {
echo "{$CFoutput}<BR>\n";
}
}
##### END parsing for vicidial variables #####
return $CFoutput;
}
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;
}
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;
}
}
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='******';";
$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;
}
}
