protected function loadTickets($login) { $login = mysql_real_escape_string($login); $query = "SELECT `id`,`date`,`status`,`text` from `ticketing` WHERE `to` IS NULL AND `replyid` IS NULL AND `from`='" . $login . "' ORDER BY `date` DESC"; $result = simple_queryall($query); return $result; }
/** * Returns array of keys in ubstorage if they contains search pattern * * @param string $keypattern * @return array */ function zb_StorageFindKeys($keypattern) { $keypattern = mysql_real_escape_string($keypattern); $query = "SELECT `key` from `ubstorage` WHERE `key` LIKE '%" . $keypattern . "%'"; $result = simple_queryall($query); return $result; }
function web_MessagesShowPrevious($login) { $login = mysql_real_escape_string($login); $query = "SELECT * from `ticketing` WHERE `to`='" . $login . "' AND `from`='NULL' AND `status`='1' ORDER BY `date` DESC"; $allmessages = simple_queryall($query); $result = '<table width="100%" class="sortable">'; $result .= ' <tr class="row1"> <td>' . __('Date') . '</td> <td>' . __('Text') . '</td> </tr> '; if (!empty($allmessages)) { foreach ($allmessages as $io => $eachmessage) { $result .= ' <tr class="row3"> <td>' . $eachmessage['date'] . '</td> <td>' . $eachmessage['text'] . '</td> </tr> '; } } $result .= '</table>'; show_window(__('Previous messages'), $result); }
/** * Returns available time rules grid * * @return string */ public function renderList() { $messages = new UbillingMessageHelper(); $allTariffs = zb_TariffGetPricesAll(); $query = "SELECT * from `dshape_time` ORDER BY `id` ASC"; $allrules = simple_queryall($query); $cells = wf_TableCell(__('ID')); $cells .= wf_TableCell(__('Tariff')); $cells .= wf_TableCell(__('Time from')); $cells .= wf_TableCell(__('Time to')); $cells .= wf_TableCell(__('Speed')); $cells .= wf_TableCell(__('Actions')); $rows = wf_TableRow($cells, 'row1'); if (!empty($allrules)) { foreach ($allrules as $io => $eachrule) { $rowClass = isset($allTariffs[$eachrule['tariff']]) ? 'row3' : 'sigdeleteduser'; $tariffControl = cfr('TARIFFSPEED') ? wf_Link('?module=tariffspeeds&tariff=' . $eachrule['tariff'], $eachrule['tariff'], false) : $eachrule['tariff']; $cells = wf_TableCell($eachrule['id']); $cells .= wf_TableCell($tariffControl); $cells .= wf_TableCell($eachrule['threshold1']); $cells .= wf_TableCell($eachrule['threshold2']); $cells .= wf_TableCell($eachrule['speed']); $actions = wf_JSAlert('?module=dshaper&delete=' . $eachrule['id'], web_delete_icon(), $messages->getDeleteAlert()); $actions .= wf_JSAlert('?module=dshaper&edit=' . $eachrule['id'], web_edit_icon(), $messages->getEditAlert()); $cells .= wf_TableCell($actions); $rows .= wf_TableRow($cells, $rowClass); } } $result = wf_TableBody($rows, '100%', '0', 'sortable'); return $result; }
function zbs_AnnouncementsShow() { $query = "SELECT * from `zbsannouncements` WHERE `public`='1' ORDER by `id` DESC"; $all = simple_queryall($query); $result = ''; if (!empty($all)) { foreach ($all as $io => $each) { if (!isset($_COOKIE['zbsanread_' . $each['id']])) { $readControl = la_Link('?module=announcements&anmarkasread=' . $each['id'], la_img('iconz/anunread.gif', __('Mark as read'))) . ' '; } else { $readControl = la_Link('?module=announcements&anmarkasunread=' . $each['id'], la_img('iconz/anread.gif', __('Mark as unread'))) . ' '; } $result .= la_tag('h3', false, 'row1', '') . $readControl . $each['title'] . ' ' . la_tag('h3', true); $result .= la_delimiter(); if ($each['type'] == 'text') { $eachtext = strip_tags($each['text']); $result .= nl2br($eachtext); } if ($each['type'] == 'html') { $result .= $each['text']; } $result .= la_delimiter(); } } else { show_window(__('Sorry'), __('There are not any announcements.')); } show_window('', $result); }
function paymaster_form($customer_id, $debug, $method, $action_url, $merchant_id, $lang, $good_url, $bad_url, $merchant_currency, $db, $tariff) { $tariff_cost = ''; $form_tariffs = ''; $form = '<p> <form action="' . $action_url . '" method="' . $method . '">'; $arr = simple_queryall("SELECT name,Fee FROM tariffs ORDER BY Fee"); if ($arr) { foreach ($arr as $k => $v) { if ($tariff == $v['name']) { $tariff_cost = $v['Fee']; } //не забываем что суммы в копейках $form_tariffs .= "<input type='radio' name='amount' value='{$v['Fee']}'><span id='tariff_{$v['Fee']}'>{$v['Fee']} {$merchant_currency} ({$v['name']})</span><br>"; } } /* else { $form.='<input type="text" name="LMI_PAYMENT_AMOUNT"> '.$merchant_currency; } */ $form .= "<input type='radio' name='amount' value='0' CHECKED><input type='number' name='amount_val' min='1' max='3000' value='{$tariff_cost}'> {$merchant_currency}<br>"; $form .= $form_tariffs; //передаем прочие нужные параметры $form .= '<input type="hidden" name="LMI_PAYMENT_NO" value="' . $customer_id . '">'; $form .= '<input type="hidden" name="LMI_PAYMENT_AMOUNT" value="' . $tariff_cost . '">'; // $form.='<input type="hidden" name="good" value="'.$good_url.'">'; // $form.='<input type="hidden" name="bad" value="'.$bad_url.'">'; $form .= '<input type="hidden" name="LMI_PAYMENT_DESC">'; $form .= '<input type="hidden" name="LMI_MERCHANT_ID" value="' . $merchant_id . '">'; if ($debug) { $form .= '<input type="hidden" name="LMI_PAYMENT_SYSTEM" value="18">'; } $form .= '<br> <input type="submit" value="Оплатить">'; $form .= '</form> </p>'; return $form; }
/** * Returns array of all replies available for ticket * * @param int $ticketid * @return array */ function zbs_TicketGetReplies($ticketid) { $ticketid = vf($ticketid, 3); $query = "SELECT * from `ticketing` WHERE `replyid`='" . $ticketid . "' ORDER by `id` ASC"; $result = simple_queryall($query); return $result; }
protected function loadForeverCredits() { $query = "SELECT `login`,`Tariff`,`Cash`,`Credit`,`CreditExpire` from `users` WHERE `CreditExpire`='0' AND `Credit`!='0'"; $all = simple_queryall($query); if (!empty($all)) { $this->forever = $all; } }
/** * gets all user payments by current month and stores it into payments prop * * @return void */ protected function loadPayments() { $query = "SELECT * from `payments` WHERE `date` LIKE '" . $this->year . '-' . $this->month . "-%' AND `summ`>0;"; $all = simple_queryall($query); if (!empty($all)) { $this->payments = $all; } }
function zb_plchecknethost($login) { $login = vf($login); $ip = zb_UserGetIP($login); $query = "SELECT `id` from `nethosts` where `ip`='" . $ip . "'"; $result = simple_queryall($query); $return = !empty($result); return $return; }
/** * Loads existing subscribers data * * @return void */ protected function loadHistory() { $query = "SELECT * from `mg_history`"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->allHistory[$each['id']] = $each; } } }
/** * Loads all of multinet networks for further usage * * @return void */ protected function loadMultinetNets() { $query = "SELECT * from `networks` ORDER BY `id` ASC"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->allMultinetNets[$each['id']] = $each; } } }
/** * loads user bindings from database and store it into private prop users * * @return void */ protected function loadUsers() { $query = "SELECT * from `corp_users`"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->users[$each['login']] = $each['corpid']; } } }
protected function loadData() { $query = "SELECT * from `zbsannouncements` ORDER by `id` DESC;"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->data[$each['id']] = $each; } } }
private function loadFrozen() { $query = "SELECT `login` from `users` WHERE `Passive`='1'"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->frozen[$each['login']] = $each['login']; } } }
protected function loadAllUsers() { $query = "SELECT `login` from `users`;"; $alldata = simple_queryall($query); if (!empty($alldata)) { foreach ($alldata as $io => $each) { $this->allusers[$each['login']] = $each['login']; } } }
protected function loadApts() { $query = "SELECT * from `apt`"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->apts[$each['id']]['apt'] = $each['apt']; $this->apts[$each['id']]['buildid'] = $each['buildid']; } } }
function ds_GetDayStats($login, $day, $page = 0) { global $tablename; $pagelimit = 100; $page = vf($page); $login = mysql_real_escape_string($login); $dey = vf($day); $query = "SELECT * from `" . $tablename . "` WHERE `login`='" . $login . "' AND `day`='" . $day . "' ORDER by `starttime` DESC"; $daystats = simple_queryall($query); return $daystats; }
/** * Loads active/remind notes from database into private property * * @return void */ protected function loadActiveNotes() { $query = "SELECT * from `stickynotes` WHERE `owner`= '" . $this->myLogin . "' AND `active`='1' ORDER BY `id` ASC"; $tmpArr = simple_queryall($query); //map id=>id if (!empty($tmpArr)) { foreach ($tmpArr as $io => $each) { $this->activenotes[$each['id']] = $each; } } }
/** * Returns filtered events by some pattern * * @param string $searchpattern * @param string $admin * @param int $limit * @return array */ function zb_GetAllEventsByPattern($searchpattern, $admin, $limit) { if (!empty($admin)) { $adminFilter = "AND `admin`='" . $admin . "'"; } else { $adminFilter = ''; } $query = "SELECT * from `weblogs` WHERE `event` LIKE '%" . $searchpattern . "%' " . $adminFilter . " ORDER BY `id` DESC LIMIT " . $limit; $allevents = simple_queryall($query); return $allevents; }
function zbs_CatvGetUserPayments($catv_userid) { $catv_userid = vf($catv_userid, 3); $query = "SELECT * from `catv_payments` WHERE `userid`='" . $catv_userid . "'"; $allpayments = simple_queryall($query); if (!empty($allpayments)) { return $allpayments; } else { return false; } }
function zbs_AgentAssignStrictGetAllData() { $result = array(); $query = "SELECT * from `ahenassignstrict`"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $result[$each['login']] = $each['agentid']; } } return $result; }
/** * Check if user already has tag * @param type $login string * @param type $tagid int * @return type boolean */ function stg_check_user_tag($login, $tagid) { $login = mysql_real_escape_string($login); $tagid = vf($tagid, 3); $query = "SELECT `id` FROM `tags` WHERE `login`= '" . $login . "' AND `tagid`= '" . $tagid . "'"; $check = simple_queryall($query); if (!empty($check)) { return true; } else { return false; } }
function ep_UserGetAllRealnames() { $query_fio = "SELECT * from `realname`"; $allfioz = simple_queryall($query_fio); $fioz = array(); if (!empty($allfioz)) { foreach ($allfioz as $ia => $eachfio) { $fioz[$eachfio['login']] = $eachfio['realname']; } } return $fioz; }
/** * Loads available builpassport contact data from database * and do some preprocessing magic * * @return void */ protected function loadBuildPassports() { if ($this->altCfg['BUILD_EXTENDED']) { $query = "SELECT DISTINCT `ownerphone`,`ownername` FROM `buildpassport` WHERE `ownerphone` !=''"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $this->allBuildContacts[] = array('phone' => $each['ownerphone'], 'name' => $each['ownername']); } } } }
/** * Fetch all Payment IDs from database as virtualid=>login * * @return array */ function zb_TemplateGetAllOPCustomers() { $result = array(); $query = "SELECT * from `op_customers`"; $all = simple_queryall($query); if (!empty($all)) { foreach ($all as $io => $each) { $result[$each['realid']] = $each['virtualid']; } } return $result; }
function ms_GetAllusers() { $query = "SELECT `login` from `users`"; $result = array(); $allusers = simple_queryall($query); if (!empty($allusers)) { foreach ($allusers as $io => $eachuser) { $result[] = $eachuser['login']; } } return $result; }
function zb_SpeedControlGetOverrideUsers() { $query = "SELECT `login` from `userspeeds` WHERE `speed` NOT LIKE '0'"; $alloverrides = simple_queryall($query); $result = array(); if (!empty($alloverrides)) { foreach ($alloverrides as $io => $eachoverride) { $result[] = $eachoverride; } } return $result; }
/** * Returns full list of tariffs marked as lousy * @return array */ function zb_LousyTariffGetAll() { $query = "SELECT `id`,`tariff` from `lousytariffs`"; $result = array(); $alldata = simple_queryall($query); if (!empty($alldata)) { foreach ($alldata as $io => $eachtariff) { $result[$eachtariff['tariff']] = $eachtariff['id']; } } return $result; }
private function loadData() { $query = "SELECT `login`,`Tariff`,`IP`, (`D0`+`D1`+`D2`+`D3`+`D4`+`D5`+`D6`+`D7`+`D8`+`D9`+`U0`+`U1`+`U2`+`U3`+`U4`+`U5`+`U6`+`U7`+`U8`+`U9`) AS `traffic` from `users` WHERE `DisabledDetailStat`!='1'"; $alldata = simple_queryall($query); if (!empty($alldata)) { foreach ($alldata as $io => $each) { $this->data[$each['login']]['login'] = $each['login']; $this->data[$each['login']]['Tariff'] = $each['Tariff']; $this->data[$each['login']]['IP'] = $each['IP']; $this->data[$each['login']]['traffic'] = $each['traffic']; } } }