function erase_unused_datas()
{
msquery('ALTER TABLE ' . ses('qdd') . ' DROP day, DROP cat;');
$ret .= 'datas deleted';
msquery('UPDATE ' . ses('qda') . ' SET thm=""');
$ret .= 'old tags deleted';
return $ret;
}
function savefunc()
{
//save_all
sql_init('sys');
msquery('TRUNCATE TABLE _sys');
$r = array('admin', 'adminx', 'ajax', 'ajxf', 'api', 'art', 'boot', 'bubs', 'finder', 'lib', 'meta', 'mod', 'msql', 'pop', 'sav', 'spe', 'styl', 'tri');
//,'ajx.js','utils.js'
foreach ($r as $v) {
save_funcs('progb/' . $v . '.php', $v);
}
}
function umwords_sav($r)
{
if ($r) {
foreach ($r as $k => $v) {
if (!umwords_ex($v[1])) {
$rb[] = $v;
}
}
}
$nid = msquery('insert into ' . qd('umvoc') . ' values ' . mysqlrb($rb), 1);
return $nid;
}
private function getPark()
{
if (eregi("INCALL", $this->status)) {
$stmt = "SELECT COUNT(*) FROM parked_channels WHERE channel_group='{$this->callerid}';";
if (msquery($stmt, $this->db)) {
$this->status = 'PARK';
return true;
} else {
$this->getDead();
}
}
$this->getRinging();
}
function plug_test($p, $o)
{
//echo 'ee';
require 'plug/mysql.php';
$r = sq2('id,page', 'live2', 'kv', '');
//pr($r);
if ($r) {
foreach ($r as $k => $v) {
$vr = explode_k($v, '&', '=');
//pr($vr);
$v = implode_k($vr, '&', '=');
//echo $k.':'.$v.br();
msquery('update pub_live2 set page="' . $v . '" where id="' . $k . '"');
}
}
//return $ret;
}
function add_member($qb, $user, $ath)
{
$qdu = $_SESSION['qdu'];
$mbrs = rse("mbrs", $qdu . ' WHERE name="' . $qb . '"');
$mbrs .= $ath . '::' . $user . ',';
$_SESSION['auth'] = $ath;
msquery("UPDATE {$qdu} SET mbrs='{$mbrs}' WHERE name='{$qb}'");
$_SESSION['qbin']["membrs"] = tab_members($mbrs);
}
function patch_sql()
{
//qda
$r = array('day day INT(10) NOT NULL', 'ib ib INT(7) NOT NULL', 'name name TINYTEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL', 'mail mail TINYTEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL', 're re ENUM("0","1","2","3","4") NOT NULL', 'lu lu INT(7) NOT NULL', 'host host MEDIUMINT(7) NOT NULL');
//'frm frm TINYTEXT CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL',
foreach ($r as $k => $v) {
msquery('ALTER TABLE ' . ses('qda') . ' CHANGE ' . $v . ';');
$ret .= 'qda' . $v . br();
}
//qdi
$r = array('ib ib INT(7) NOT NULL', 'day day INT(10) NOT NULL', 're re INT(7) NOT NULL', 'lu lu INT(7) NOT NULL', 're re ENUM("0","1","2","3","4") NOT NULL');
foreach ($r as $k => $v) {
msquery('ALTER TABLE ' . ses('qdi') . ' CHANGE ' . $v . ';');
$ret .= 'qdi' . $v . br();
}
//qdd
$r = array('ib ib INT(7) NOT NULL', 'day day INT(10) NOT NULL');
foreach ($r as $k => $v) {
msquery('ALTER TABLE ' . ses('qdd') . ' CHANGE ' . $v . ';');
$ret .= 'qdd' . $v . br();
}
//qds
$r = array('day day INT(7) NOT NULL', 'nbu nbu INT(10) NOT NULL', 'nbv nbv INT(10) NOT NULL');
foreach ($r as $k => $v) {
msquery('ALTER TABLE ' . ses('qds') . ' CHANGE ' . $v . ';');
$ret .= 'qde' . $v . br();
}
//qde
$r = array('iq iq INT(7) NOT NULL', 'nb nb INT(10) NOT NULL');
foreach ($r as $k => $v) {
msquery('ALTER TABLE ' . ses('qde') . ' CHANGE ' . $v . ';');
$ret .= 'qde' . $v . br();
}
echo $ret . btn('txtalert', 'patch d\'optimisation des tables appliqué avec succès');
}
// $agent_wait_today;
$stmt = "select sum(agent_wait_today) from vicidial_campaign_stats where calls_today > 10;";
$arrayF['AGENT_AVG_WAIT'] = number_format(msquery($stmt, $db) / $arrayF['AGENT_CALLS_TODAY']);
// avg talk time
// $agent_custtalk_today / $agent_calls_today
// $agent_custtalk_today;
$stmt = "select sum(agent_custtalk_today) from vicidial_campaign_stats where calls_today > 10 {$LOGallowed_campaignsSQL};";
$arrayF['AVG_TALK_TIME'] = number_format(msquery($stmt, $db) / $arrayF['AGENT_CALLS_TODAY']);
// total calls today
$stmt = "select sum(calls_today) from vicidial_campaign_stats where calls_today > 500 {$LOGallowed_campaignsSQL};";
$arrayF['TOTAL_CALLS_TODAY'] = msquery($stmt, $db);
// avg wrap
$stmt = "select round((sum(dispo_sec)/(select sum(agent_calls_today) from vicidial_campaign_stats)),0) \nfrom vicidial_agent_log where event_time> now() -interval 14 hour;";
$arrayF['AVG_WRAP'] = msquery($stmt, $db);
// avg pause
// $agent_pause_today / $agent_calls_today
// $agent_pause_today
$stmt = "select sum(agent_pause_today) from vicidial_campaign_stats where calls_today > 10 {$LOGallowed_campaignsSQL};";
$arrayF['AVG_PAUSE'] = number_format(msquery($stmt, $db) / $arrayF['AGENT_CALLS_TODAY']);
// avg agents
$stmt = "select avg(agents_average_onemin) from vicidial_campaign_stats where calls_today > -1 {$LOGallowed_campaignsSQL};";
$arrayF['AVG_AGENTS'] = number_format(msquery($stmt, $db), 2);
// dialable leads
$stmt = "select sum(dialable_leads) from vicidial_campaign_stats where calls_today > -1 {$LOGallowed_campaignsSQL};";
$arrayF['DIALABLE_LEADS'] = number_format(msquery($stmt, $db));
// dial method
//$stmt = "select C.dial_method from vicidial_campaign_stats S inner join vicidial_campaigns C on C.campaign_id=S.campaign_id where C.active='Y' and S.calls_today>10 having count()=(select count() from vicidial_campaign_stats S inner join vicidial_campaigns C on C.campaign_id=S.campaign_id where C.active='Y' and S.calls_today>10 order by C.dial_method desc limit 1);";
$stmt = "select min(dial_method) from vicidial_campaigns where active='Y' {$LOGallowed_campaignsSQL};";
$arrayF['DIAL_METHOD'] = msquery($stmt, $db);
$db->close();
echo json_encode($arrayF);
}
if ($va == 'oldconn') {
req(pop);
$rt = retape('<br>' . $id, '');
}
if ($va == 'replace') {
list($rep, $by) = ajxr($res);
$rt = str_replace($rep, $by, $id);
}
//if($va=='table'){$rt=ajxg($res);}
if ($va == 'randim') {
$_POST['randim'] = 1;
$_GET['continue'] = 1;
$read = $_SESSION['read'];
$id = mysql_real_escape_string(stripslashes($id));
msquery('UPDATE ' . $_SESSION['qdm'] . ' SET msg="' . $id . '" WHERE id="' . $read . '"');
req('spe');
req('pop');
$ret = format_txt($id, 3, $read);
$rt = sql('msg', 'qdm', 'v', 'id=' . $read);
}
if ($va == 'revert') {
$rt = sql('msg', 'qdm', 'v', 'id=' . $_SESSION['read']);
}
if ($va == 'postreat') {
$rt = post_treat_batch($id, $va, $opt);
}
$ret = txarea1($rt);
break;
case "backup":
$optb = sql('msg', 'qdm', 'v', 'id=' . $_SESSION['read']);
function dl_data($h)
{
require '../params/_connectx.php';
$d = read_file('http://' . $_SESSION['servr'] . '/params/' . $h . '_backup_' . $_GET['data']);
$d = stripslashes($d);
$d = str_replace('\'' . $_SESSION['target_hub'] . '\'', '\'' . $_SESSION['qb'] . '\'', $d);
if ($_SESSION['datasaved'][$_GET['data']]) {
echo 'already_saved :: ';
} else {
$verif = msquery($d);
}
if (!$verif) {
echo "error";
} else {
echo btn("txtyl", 'saved');
}
$_SESSION['datasaved'][$_GET['data']] = 1;
}
echo ', "userGroups": ';
echo json_encode($userGroups);
echo ', "time": ';
echo json_encode(time());
echo ', "getPhoneLogin": '******', "get_server_ip": ';
echo json_encode($get_server_ip);
echo ', "user": '******', "pass": '******'set_server_ip' from phones where login='******' and active = 'Y';";
$set_server_ip = msquery($stmt, $db);
echo ', "set_server_ip": ';
echo json_encode($set_server_ip);
echo ', "setPhoneLogin": '******', "webphone_name": ';
echo json_encode($phone_login);
echo ', "webphone_pass": '******', "webphone_ip": ';
echo json_encode($external_server_ip);
if ($userOptions) {
echo ', "display": ';
echo $userOptions;
} else {
function edit_categories()
{
$rub = urldecode($_GET['modif']);
$old_rub = $_POST['old_rub'];
if ($_SESSION['auth'] >= 6) {
//save
if ($_POST['hide']) {
$rub = '_' . $_POST['old_rub'];
} elseif ($_POST['publish'] && substr($old_rub, 0, 1) == "_") {
$rub = substr($old_rub, 1);
} elseif ($_POST['modif']) {
$rub = $_POST['modif'];
}
if ($_POST['hide'] or $_POST['publish'] or $_POST['modif']) {
msquery('UPDATE ' . $_SESSION['qda'] . ' SET frm="' . $rub . '" WHERE nod="' . ses('qb') . '" and frm="' . $old_rub . '"');
}
if ($_POST['mktag']) {
$r = sql('id,thm', 'qda', 'q', 'frm="' . $old_rub . '"');
$rid = randid();
while ($data = mysql_fetch_array($r)) {
$repl = str_replace(array(', ' . $old_rub, $old_rub . ', ', $old_rub), '', $data['thm']);
update('qda', 'thm', $repl . ', ' . $old_rub, "id", $data['id']);
}
}
}
if ($rub) {
//champs
$valu = input2('text" size="15" maxlength="255', 'modif', $rub, "") . hidden('old_rub', '', $rub) . ' ' . input2('submit', 'Submit', 'modif', "") . ' ';
if (substr($rub, 0, 1) != "_") {
$valu .= input2('submit', 'hide', 'hide', "") . ' ';
} else {
$valu .= input2('submit', 'publish', 'publish') . ' ';
}
$valu .= input2('submit', 'mktag', 'mktag');
$inp = br() . btn("", $valu);
$ret .= lkc('txtx', htac('section') . $rub, 'go_to') . ' ';
$ret .= lkc('txtx', '/?admin=all_arts&cat=' . $rub, 'all_arts_of:' . $rub) . br();
$ret .= form('/?admin=categories&modif=' . $rub, $inp);
}
return $ret . br();
}
function art_import($res)
{
$f = ajx(trim($res), 1);
$f = utmsrc($f);
$f = http($f);
$_GET['urlsrc'] = $f;
$fb = nohttp($f);
if (!$_GET['ti']) {
list($sujb, $msg, $rec, $current, $defid) = vacuum($f, $suj);
$msg = embed_links($msg);
$ret = $msg;
$_SESSION['vacti'][$f] = $sujb;
} else {
$ret = clean_title($_SESSION['vacti'][$f]);
$_SESSION['vacti'][$f] = '';
}
if ($_GET['import'] && $sujb) {
$wh = 'WHERE id = "' . $_GET['import'] . '" LIMIT 1;';
$sq = 'suj="' . clean_title($sujb) . '", mail="' . $f . '", img="" ';
//ib="0",
msquery('UPDATE ' . $_SESSION['qda'] . ' SET ' . $sq . $wh . '');
req('sav,pop');
modif_art($_GET['import'], $msg);
}
if ($_SESSION['vacuum'][$fb]) {
unset($_SESSION['vacuum'][$fb]);
}
return $ret;
}
function reflush($bs, $o = '')
{
msquery('alter table ' . $_SESSION[$bs] . ' order by id');
if ($o) {
msquery('alter table ' . $_SESSION[$bs] . ' AUTO_INCREMENT=' . (lastid($bs) + 1));
}
}
function troc_del($id, $rid)
{
if ($id) {
delete('obj', $id);
}
msquery('DELETE FROM ' . $_SESSION['prop'] . ' WHERE ib="' . $id . '"');
return troc_add($rid);
}
function modif_art($read, $msg)
{
$qdm = $_SESSION['qdm'];
if ($_SESSION['auth'] < 3) {
return;
}
$msg = str_replace("\r", "", $msg);
$msg = html_entity_decode_b($msg);
$msg = embed_links($msg);
$msg = unescape($msg);
$msg = correct_txt($msg, $read, 'savimg');
$msg = clean_br_lite($msg);
$msg = clean_punct($msg);
$msg = repair_tags($msg);
//if(rstr(70))$msg=retape($msg,$read);
$msg = addslashes(stripslashes($msg));
msquery("UPDATE {$qdm} SET msg='{$msg}' WHERE id='{$read}' LIMIT 1");
return stripslashes($msg);
}
function remove_tag($idtag)
{
//from admin
if (!auth(6)) {
return;
}
if ($idtag) {
msquery('delete from ' . ses('qdta') . ' where idtag="' . $idtag . '"');
delete('qdt', $idtag);
}
return divc('txtalert', 'remove: ' . $idtag);
}
function light_live()
{
$db = plugin_func('install', 'install_db', ses('qd'));
if (!$db['live']) {
return 'er';
}
$sql = str_replace('_live', '_live2', $db['live']);
mysql_query($sql);
$tim = calc_date(30);
$day = date('Y-m-d H:i:s', $tim);
$lastid = sql('id', 'qdv', 'v', 'time>"' . $day . '" order by id limit 1');
if (is_numeric($lastid)) {
msquery('insert into ' . ses('qdv2') . ' select * from ' . ses('qdv') . ' where id<' . $lastid);
msquery('delete from ' . ses('qdv') . ' where id<"' . $lastid . '"');
reflush('qdv');
}
return ses('qdv') . ' was cleaned from id ' . $lastid;
}
function edit_categories()
{
//fixtag();
$rub = $_GET['modif'];
$old_rub = $_POST['old_rub'];
if ($_SESSION['auth'] >= 6) {
//save
if ($_POST['totag']) {
cat2tag($_POST['modif']);
}
if ($_POST['hide']) {
$rub = '_' . $_POST['old_rub'];
} elseif ($_POST['publish'] && substr($old_rub, 0, 1) == "_") {
$rub = substr($old_rub, 1);
} elseif ($_POST['modif']) {
$rub = $_POST['modif'];
}
if ($_POST['hide'] or $_POST['publish'] or $_POST['modif']) {
msquery('UPDATE ' . $_SESSION['qda'] . ' SET frm="' . $rub . '" WHERE nod="' . ses('qb') . '" and frm="' . $old_rub . '"');
}
}
if ($rub) {
//champs
$valu = input2('text" size="15" maxlength="255', 'modif', $rub, "") . hidden('old_rub', '', $rub) . ' ' . input2('submit', 'Submit', 'modif', "") . ' ';
if (substr($rub, 0, 1) != "_") {
$valu .= input2('submit', 'hide', 'hide', "") . ' ';
} else {
$valu .= input2('submit', 'publish', 'publish') . ' ';
}
$valu .= input2('submit', 'totag', 'make tag') . ' ';
$valu .= radiobtn(explode(' ', 'tag ' . prmb(18)), 'tag', 'rdtg');
if ($_POST['totag']) {
$valu .= btn('txtyl', $rub . ' was added as tag ' . $_POST['rdtg']);
}
$inp = br() . btn("", $valu);
$ret .= lkc('txtx', htac('cat') . $rub, pictxt('url', 'go')) . ' ';
$ret .= lkc('txtx', '/?admin=all_arts&cat=' . $rub, pictxt('view', $rub)) . br();
$ret .= form('/?admin=categories&modif=' . $rub, $inp);
}
return $ret . br();
}
