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(); }