public static function cadastrados() { self::$departamento->getConnection()->with_limits(get_limit()); $o = self::$departamento->registros(); if ($o) { $ds = self::$departamento->get_lista($o); } return $ds; }
$bads[$row['user_id']] = $row['bads']; } $result = sql_query(' SELECT SQL_CALC_FOUND_ROWS ' . (PRO_VERSION ? 'users.*' : implode(',', $GLOBALS['USERS_FIELDS'])) . ', SUM(IF(t.type="d", t.amount, NULL)) as deposit, SUM(IF(t.type="w", t.amount, NULL)) as withdrawal, SUM(IF(t.type="e", t.amount, NULL)) as earning, SUM(IF(t.type="r", t.amount, NULL)) as referral, SUM(IF(t.type="i", t.amount, NULL)) as reinvest, SUM(IF(t.type="b", t.amount, NULL)) as bonus FROM users LEFT JOIN translines as t ON t.user_id = users.id AND t.stamp < ' . Project::getInstance()->getNow() . ' AND t.status > 0 GROUP BY users.id ORDER BY ' . (!empty($_REQUEST['order_by']) ? addslashes($_REQUEST['order_by']) : 'reg_date DESC') . ' ' . get_limit() . ' '); $users = array(); while ($row = mysql_fetch_assoc($result)) { $row['ips'] = isset($ips[$row['id']]) ? $ips[$row['id']] : array(); $row['bads'] = isset($bads[$row['id']]) ? intval($bads[$row['id']]) : 0; $row['ipsec'] = 0; $users[$row['id']] = $row; } foreach ($users_by_ips as $ip => $u_ids) { if (count($u_ids) > 1) { foreach ($u_ids as $u_id) { if (!isset($users[$u_id])) { continue; } $users[$u_id]['ipsec'] = 1;
?> </div> </div> <div class="clear"></div> <?php } if ($content_type == 'people') { ?> <ul> <li class="first_column"> <?php echo get_avatar($row->username); if ($body_title == 'Leaderboard') { ?> <div class="rank"><?php $rank = get_limit() * ($page - 1) + $i; echo $rank; ?> </div> <?php } ?> </li> <li class="second_column"> <div class="fullname"> <?php echo get_fullname($row->username); ?> </div> <div class="username">@<?php echo $row->username;
/* TODO: what other options could be in "php_handler_type"? */ } /* TODO: plesk offers some more options: * sys_user_id -> owner of files? * ip_address_id - needed? * fp - frontpage extensions * miva - ? * coldfusion * asp * asp_dot_net * traffic_bandwidth * max_connections */ $web_folder = $entry['www_root']; $web_folder = preg_replace('/^\\/(var|srv)\\/www\\/(vhosts\\/)?[^\\/]+\\/(.*)\\/httpdocs.*/', '$3', $web_folder); $params = array('server_id' => $server_id, 'ip_address' => '*', 'domain' => $entry['name'] . '.' . $parent_domain['name'], 'web_folder' => $web_folder, 'type' => 'vhostsubdomain', 'parent_domain_id' => $domain_ids[$entry['dom_id']], 'vhost_type' => 'name', 'hd_quota' => byte_to_mbyte(get_limit($limits, $entry['dom_id'], 'disk_space', -1)), 'traffic_quota' => byte_to_mbyte(get_limit($limits, $entry['dom_id'], 'max_traffic', -1)), 'cgi' => yes_no(get_option($hosting, 'cgi', 'false') === 'true' ? 1 : 0), 'ssi' => yes_no(get_option($hosting, 'ssi', 'false') === 'true' ? 1 : 0), 'suexec' => yes_no(1), 'errordocs' => get_option($options, 'apacheErrorDocs', 'false') === 'true' ? 1 : 0, 'subdomain' => '', 'ssl' => yes_no(get_option($hosting, 'ssl', 'false') === 'true' ? 1 : 0), 'php' => $phpmode, 'fastcgi_php_version' => '', 'ruby' => yes_no(0), 'python' => yes_no(get_option($hosting, 'python', 'false') === 'true' ? 1 : 0), 'active' => yes_no($entry['status'] == 0 && get_option($hosting, 'maintenance_mode', 'false') !== 'true' ? 1 : 0), 'redirect_type' => $redir_type, 'redirect_path' => $redir_path, 'seo_redirect' => '', 'ssl_state' => $entry[''], 'ssl_locality' => $entry[''], 'ssl_organisation' => $entry[''], 'ssl_organisation_unit' => $entry[''], 'ssl_country' => $entry[''], 'ssl_domain' => $entry[''], 'ssl_request' => $entry[''], 'ssl_cert' => $entry[''], 'ssl_bundle' => $entry[''], 'ssl_action' => $entry[''], 'stats_password' => '', 'stats_type' => get_option($hosting, 'webstat', 'webalizer') === 'awstats' ? 'awstats' : 'webalizer', 'backup_interval' => 'none', 'backup_copies' => 1, 'allow_override' => 'All', 'pm_process_idle_timeout' => 10, 'pm_max_requests' => 0); $old_domain = $app->db->queryOneRecord("SELECT * FROM web_domain WHERE domain = '" . $entry['name'] . '.' . $parent_domain['name'] . "'"); if (!$old_domain) { $old_domain = $app->db->queryOneRecord("SELECT * FROM web_domain WHERE CONCAT(subdomain, '.', domain) = '" . $entry['name'] . "'"); } if ($old_domain) { $new_id = $old_domain['domain_id']; $params = array_merge($old_domain, $params); $msg .= "Found domain with id " . $new_id . ", updating it.<br />"; $ok = $importer->sites_web_vhost_subdomain_update($session_id, $plesk_ispc_ids[$parent_domain['cl_id']], $new_id, $params); if ($ok === false) { $msg .= " Error: " . $importer->getFault() . "<br />"; } } else { $new_id = $importer->sites_web_vhost_subdomain_add($session_id, $plesk_ispc_ids[$parent_domain['cl_id']], $params, true); // read only...
<?php } else { echo "<input type='hidden' value='yes' name='agree' />"; echo ""; } ?> </table> <fieldset> <?php //echo "<pre>"; //print_r($userdata); //echo "</pre>"; $limit_data = get_limit($userdata->ID); $stop_date = $limit_data[0]->stop_date; $limit = $limit_data[0]->limit; ?> <legend><?php _e('Ваш <span title="Предоплаченный Вами или авансированный сайтом для последующей оплаты" style="border: 1px dashed ; cursor:help"> лимит </span> на скачивание'); ?> </legend> <label><?php _e('Количество файлов: '); echo $limit; ?> <br /> <!-- <input type="text" name="user_login" value="<?php echo $limit; ?>
function get_sql_query_clauses_NEW($db, $params, $currentUser = null) { global $mysqli, $wg_ids, $publicOnly; $mysqli = $db; if (!$params) { $params = array(); } //$_REQUEST; // 1. DETECT CURRENT USER AND ITS GROUPS, if not logged search only all records (no bookmarks) ---------------------- $wg_ids = array(); //may be better use $system->get_user_group_ids() ??? if ($currentUser && @$currentUser['ugr_ID'] > 0) { if (@$currentUser['ugr_Groups']) { $wg_ids = array_keys($currentUser['ugr_Groups']); } $currUserID = $currentUser['ugr_ID']; array_push($wg_ids, $currUserID); } else { $currUserID = 0; $params['w'] = 'all'; } array_push($wg_ids, 0); // be sure to include the generic everybody workgroup $publicOnly = @$params['publiconly'] == 1; //@todo change to vt - visibility type parameter of query // 2. DETECT SEARCH DOMAIN ------------------------------------------------------------------------------------------ if (strcasecmp(@$params['w'], 'B') == 0 || strcasecmp(@$params['w'], BOOKMARK) == 0) { // my bookmark entries $search_domain = BOOKMARK; } else { if (@$params['w'] == 'e') { //everything - including temporary $search_domain = EVERYTHING; } else { if (@$params['w'] == 'nobookmark') { //all without BOOKMARK $search_domain = NO_BOOKMARK; } else { // all records entries $search_domain = "a"; } } } if (is_array(@$params['q'])) { $query_json = $params['q']; } else { $query_json = json_decode(@$params['q'], true); } $query = new HQuery("0", $query_json, $search_domain, $currUserID); $query->makeSQL(); //1. create tree of predicates //2. make where // 6. DEFINE LIMIT AND OFFSET --------------------------------------------------------------------------------------- $limit = get_limit($params); $offset = get_offset($params); if (!$query->where_clause) { $query->where_clause = "(1=1)"; } // 7. COMPOSE QUERY ------------------------------------------------------------------------------------------------ return array("from" => " FROM " . $query->from_clause, "where" => $query->where_clause, "sort" => $query->sort_clause, "limit" => " LIMIT {$limit}", "offset" => $offset > 0 ? " OFFSET {$offset} " : ""); }
<td height="25" colspan="2" bgcolor="#EDEEF8"> 留言列表</td> </tr> <?php //列表 $sql = "select * from lyb order by id desc"; mysql_query("SET NAMES 'utf8'"); $rs = mysql_query($sql); if($rs) { $num = mysql_num_rows($rs); } $page_size = 3; //每页显示数目更改 $sql = "select * from lyb order by id desc ".get_limit($page_size); mysql_query("SET NAMES 'utf8'"); $rs = mysql_query($sql); if($rs) { while($rows = mysql_fetch_object($rs)) { ?> <tr> <td width="167" height="25" bgcolor="#FFFFFF"> <table width="100%" height="100%" border="0"> <tr> <td align="center"><img src="images/<?=$rows->touxiang?>.gif" border="0" /></td> </tr> <tr>
function build_query($query, $page, $order = 'id DESC') { $CI =& get_instance(); return $CI->db->query($query . ' ORDER BY ' . $order . ' LIMIT ' . get_offset($page) . ', ' . get_limit()); }
/** * Use the supplied _REQUEST variables (or $params if supplied) to construct a query starting with $query prefix * * @param System $system * @param mixed $query - prefix (usually SELECT with list of fields) * @param mixed $params * parameters: stype - (OUTDATED) type of search: key - by tag title, all - by title of record and titles of its resource, by default by record title s - sort order (NOTE!!! sort may be defined in "q" parameter also) l or limit - limit of records o or offset w - domain of search a|all, b|bookmark, e (everything) qq - several conjunctions and disjunctions q - query string keywords for 'q' parameter url: url title: title contains t: record type id f: field id tag: tag id: id n: description usr: user id any: relatedto: sortby: * * @param mixed $currentUser - array with indexes ugr_ID, ugr_Groups (list of group ids) * we can access; Records records marked with a rec_OwnerUGrpID not in this list are omitted */ function get_sql_query_clauses($db, $params, $currentUser = null) { global $mysqli; $mysqli = $db; /* use the supplied _REQUEST variables (or $params if supplied) to construct a query starting with $select_clause */ if (!$params) { $params = array(); } //$_REQUEST; if (!defined('stype') && @$params['stype']) { define('stype', @$params['stype']); } // 1. DETECT CURRENT USER AND ITS GROUPS, if not logged search only all records (no bookmarks) ---------------------- $wg_ids = array(); //may be better use $system->get_user_group_ids() ??? if ($currentUser && @$currentUser['ugr_ID'] > 0) { if (@$currentUser['ugr_Groups']) { $wg_ids = array_keys($currentUser['ugr_Groups']); } $currUserID = $currentUser['ugr_ID']; array_push($wg_ids, $currUserID); } else { $currUserID = 0; $params['w'] = 'all'; } array_push($wg_ids, 0); // be sure to include the generic everybody workgroup $publicOnly = @$params['publiconly'] == 1; //@todo // 2. DETECT SEARCH DOMAIN ------------------------------------------------------------------------------------------ if (strcasecmp(@$params['w'], 'B') == 0 || strcasecmp(@$params['w'], BOOKMARK) == 0) { // my bookmark entries $search_domain = BOOKMARK; } else { if (@$params['w'] == 'e') { //everything - including temporary $search_domain = EVERYTHING; } else { // all records entries $search_domain = null; } } // 3a. SPECIAL CASE for _BROKEN_ $needbroken = false; if (@$params['q'] && preg_match('/\\b_BROKEN_\\b/', $params['q'])) { $params['q'] = preg_replace('/\\b_BROKEN_\\b/', '', $params['q']); $needbroken = true; } // 3b. SPECIAL CASE for _NOTLINKED_ $neednotlinked = false; if (@$params['q'] && preg_match('/\\b_NOTLINKED_\\b/', $params['q'])) { $params['q'] = preg_replace('/\\b_NOTLINKED_\\b/', '', $params['q']); $neednotlinked = true; } // 4. QUERY MAY BE SIMPLE or full expressiveness ---------------------------------------------------------------------- $query = parse_query($search_domain, @$params['q'], @$params['s'], @$params['parentquery'], $currUserID); $where_clause = $query->where_clause; // 4a. SPECIAL CASE for _BROKEN_ if ($needbroken) { $where_clause = '(to_days(now()) - to_days(rec_URLLastVerified) >= 8) ' . ($where_clause ? ' and ' . $where_clause : ''); } // 4b. SPECIAL CASE for _NOTLINKED_ if ($neednotlinked) { $where_clause = '(not exists (select rl_ID from recLinks where rl_SourceID=TOPBIBLIO.rec_ID or rl_TargetID=TOPBIBLIO.rec_ID )) ' . ($where_clause ? ' and ' . $where_clause : ''); } // 5. DEFINE USERGROUP RESTRICTIONS --------------------------------------------------------------------------------- if ($search_domain != EVERYTHING) { if ($where_clause) { $where_clause = '(' . $where_clause . ') and '; } if ($search_domain == BOOKMARK) { $where_clause .= ' (bkm_UGrpID=' . $currUserID . ' and not TOPBIBLIO.rec_FlagTemporary) '; } else { if ($search_domain == BIBLIO) { //NOT USED $where_clause .= ' (bkm_UGrpID is null and not TOPBIBLIO.rec_FlagTemporary) '; } else { $where_clause .= ' not TOPBIBLIO.rec_FlagTemporary '; } } } if ($publicOnly) { $query->recVisibilityType = "public"; } if ($query->recVisibilityType && $query->recVisibilityType != "hidden") { $where2 = '(TOPBIBLIO.rec_NonOwnerVisibility="' . $query->recVisibilityType . '")'; //'pending','public','viewable' } else { if ($query->recVisibilityType) { //hidden $where2 = 'TOPBIBLIO.rec_NonOwnerVisibility="hidden" and '; } else { $where2 = '(not TOPBIBLIO.rec_NonOwnerVisibility="hidden") or '; } $where2 = '( ' . $where2 . 'TOPBIBLIO.rec_OwnerUGrpID in (' . join(',', $wg_ids) . ') )'; } $where_clause = $where_clause . ' and ' . $where2; // 6. DEFINE LIMIT AND OFFSET --------------------------------------------------------------------------------------- $limit = get_limit($params); $offset = get_offset($params); // 7. COMPOSE QUERY ------------------------------------------------------------------------------------------------ return array("from" => $query->from_clause, "where" => $where_clause, "sort" => $query->sort_clause, "limit" => " LIMIT {$limit}", "offset" => $offset > 0 ? " OFFSET {$offset} " : ""); }