db_count PHP代码示例

示例#1

0

显示文件

文件： menus.php 项目： jsib/dumps.loc

function menu_top($manual_items=""){
	//Подключаем глобальную переменную
	global $DocumentId;
	
	db_connect();
	$html_items="	
					<a href='/engine.php?table=documents'>Документ покупки</a><span class='divider'></span>
					<a href='/engine.php?table=computers'>Сборки компьютеров</a><span class='divider'></span>
					<a href='/statistics.php'>Статистика</a><span class='divider'></span>
					<a href='/engine.php?table=documents&document=$DocumentId&action=list_contragents'>Контрагенты</a><span class='divider'></span>
					<a href='/engine.php?table=documents&document=$DocumentId&action=list_positions'>Позиции</a><span class='divider'></span>
					<br/>
					";
					
    //Запрашиваем из таблицы БД 'menus' все пункты меню, принадлежащие размещению 'top'
    $items_query=db_query("SELECT `href`, `text`, `label` FROM `menu_items` WHERE `area`='top' ORDER BY `order` ASC");

    $number_item=1;
	
	//Ручное добавление пунктов
	$html_items.=$manual_items;
	
    //Пункты меню найдены
    if(db_count($items_query)>0){
        //Перебираем пункты меню
        while($item=db_fetch($items_query)){
            $html_items.="<a href='{$item['href']}' class='".get_class_depend_on_uri("!=", 'table_name', $item['label'])."'>{$item['text']}</a>";
            $html_items.="<span class='divider'></span>";
            if($number_item % 7 == 0) $html_items.="<br/>";
            $number_item++;
        }
    //Такие пункты меню не найдены
    }
    return template_get('menus/menu_top', array('html_items'=>$html_items, 'login'=>$_SESSION['user']));
}

示例#2

0

显示文件

文件： show_branch.php 项目： jsib/intranet

function show_branch()
{
    switch (@$_GET['message']) {
        case "branchjustadded":
            $message_html = template_get("message", array('message' => "Город успешно добавлен"));
            break;
        default:
            $message_html = template_get("nomessage");
    }
    $branch_id = $_GET['branch'];
    $branch = db_easy("SELECT * FROM `phpbb_branches` WHERE `id`={$branch_id}");
    $pointsRES = db_query("SELECT * FROM `phpbb_points` WHERE `branch_id`={$branch_id}");
    if (db_count($pointsRES) > 0) {
        while ($point = db_fetch($pointsRES)) {
            $points_html .= "<div style='padding-bottom:5px;'><a href='/manager.php?action=show_point&point={$point['id']}'>{$point['name']}</a></div>";
        }
    } else {
        $points_html = "-";
    }
    if (check_rights('add_branch')) {
        $edit_branch_html = "<a href='/manager.php?action=edit_branch&branch={$branch_id}' style='font-size:8pt;'>Редактировать</a>";
    }
    $html .= template_get("branches/show_branch", array('name' => $branch['name'], 'editbranch' => $edit_branch_html, 'message' => $message_html, 'points' => $points_html));
    return $html;
}

示例#3

0

显示文件

文件： auth.php 项目： jsib/intranet

function check_rights($right_name = "")
{
    //Define global variables
    global $user;
    //Check rights
    if (isset($GLOBALS['super_rights_users'][$user->data['username']])) {
        //For users with super rights
        return true;
    } else {
        //If
        if ($right_name !== "") {
            $rightRES = db_query("SELECT * FROM `phpbb_rights` WHERE `name`='{$right_name}'");
            if (db_count($rightRES) == 1) {
                $right_id = db_fetch($rightRES)['id'];
            } else {
                show("Ошибка в функции check_right_name(). Права с именем '{$right_name}' не существует или имеется несколько прав с таким именем.<br/>");
                show('Debug backtrace:');
                show(debug_backtrace());
                exit;
            }
            if (db_easy_count("SELECT * FROM `phpbb_rights_users` WHERE `user_id`={$user->data['user_id']} AND `right_id`={$right_id}") > 0) {
                return true;
            } else {
                return false;
            }
        }
    }
}

示例#4

0

显示文件

文件： get_comment.php 项目： jsib/intranet

function get_comment()
{
    /*Получаем данные от пользователя*/
    if (isset($_POST['id'])) {
        if (!preg_match("/^comment\\-[0-9]{1,2}\\-[0-9]{4}\\-[0-9]{1,2}\\-[0-9]{1,2}\$/", $_POST['id'])) {
            return "Ошибка в формате входных данных (td).";
        } else {
            $id = $_POST['id'];
        }
    } else {
        return "Не определены входные данные (id)";
    }
    /*Обрабатываем полученные данные*/
    $temp = explode('-', $id);
    $year = (int) $temp[2];
    $month = (int) $temp[3];
    $day = (int) $temp[4];
    //Запрос к базе
    $q = db_query("SELECT * FROM `phpbb_timetable_comments` WHERE `year`={$year} AND `month`={$month} AND `day`={$day}");
    if (db_count($q) == 0) {
        return 1;
    } else {
        $result = db_fetch($q);
        return $result['comment1'] . "\n" . $result['comment2'] . "\n" . $result['comment3'];
    }
}

示例#5

0

显示文件

文件： 01CSCLog.php 项目： Nazg-Gul/gate

 function CanCreate()
 {
     if (db_count('service', '`sclass` = "CSCLog"') == 0) {
         return true;
     }
     add_info('Может существовать лишь один серфис журналирования.');
     return false;
 }

示例#6

0

显示文件

文件： 02CSRCRSS.php 项目： Nazg-Gul/gate

 function CanCreate()
 {
     if (db_count('service', '`sclass`="CSCRSS"') == 0) {
         return true;
     }
     add_info('Может существовать лишь один RSS серфис.');
     return false;
 }

示例#7

0

显示文件

文件： add_right.php 项目： jsib/intranet

function add_right()
{
    //Определяем переменные
    $html = "";
    $users_html = "";
    /*Проверка прав на выполнение действия*/
    if (!check_rights('add_right')) {
        return "У вас нет соответствующих прав";
    }
    //IF
    if (!isset($_POST['user'])) {
        /*Получаем и проверяем данные от пользвователя*/
        $right_id = (int) $_GET['right'];
        /*Проверка входных данных*/
        $rightRES = db_query("SELECT `name` FROM `phpbb_rights` WHERE `id`='{$right_id}'");
        if (db_count($rightRES) == 0) {
            return "Ошибка в формате входных данных (right)";
        } else {
            $right_name = db_fetch($rightRES)['name'];
        }
        //Запрос к базе
        $usersRES = db_query("SELECT * FROM `phpbb_users`\r\n\t\t\t\t\t\t\t\tWHERE (`user_type`=0 OR `user_type`=3) AND `username`!='root'\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY `username` ASC");
        //WHILE
        while ($userWHILE = db_fetch($usersRES)) {
            if (db_easy_count("SELECT * FROM `phpbb_rights_users`\r\n\t\t\t\t\t\t\t\tWHERE `user_id`={$userWHILE['user_id']}\r\n\t\t\t\t\t\t\t\t\tAND `right_id`={$right_id}\r\n\t\t\t\t\t\t") == 0) {
                $users_html .= "<option value='{$userWHILE['user_id']}'>{$userWHILE['username']}</option>";
            }
        }
        /*Подключаем шаблон*/
        $html .= template_get("rights/add_right", array('users' => $users_html, 'right_id' => $right_id, 'right_name' => $right_name));
        //ELSE
    } else {
        /*Получаем и проверяем данные от пользвователя*/
        $user_id = (int) $_POST['user'];
        /*Получаем и проверяем данные от пользвователя*/
        $right_id = (int) $_POST['right'];
        /*Проверка входных данных*/
        if (db_easy_count("SELECT * FROM `phpbb_users` WHERE `user_id`={$user_id}") == 0) {
            return "Ошибка в формате входных данных (user)";
        }
        /*Проверка входных данных*/
        if (db_easy_count("SELECT * FROM `phpbb_rights` WHERE `id`='{$right_id}'") == 0) {
            return "Ошибка в формате входных данных (right)";
        }
        //Запрос к базе
        if (db_easy_count("SELECT * FROM `phpbb_rights_users` WHERE `user_id`={$user_id} AND `right_id`={$right_id}") == 0) {
            $insertRES = db_query("INSERT INTO `phpbb_rights_users` SET `user_id`={$user_id}, `right_id`={$right_id}");
        }
        /*Проверка правильности выполнения запроса к БД*/
        if (!db_result($insertRES)) {
            return "Ошибка при выполнении (insert)";
        }
        //Выполняем HTTP запрос
        header("location: /manager.php?action=show_rights");
    }
    //Возвращаем значение функции
    return $html;
}

示例#8

0

显示文件

文件： articles.php 项目： jokepinocchio/MiniXML

function notify_users($id, $what = "created")
{
    global $PHP_URL, $PROJECT_EMAIL, $PROJECT_NAME;
    $result = db_query("SELECT * FROM article WHERE id = {$id}");
    if (db_count($result) == 1) {
        $row = db_next($result);
        mail($PROJECT_EMAIL, "{$PROJECT_NAME} Article #{$id} {$what}", wordwrap("{$row['create_user']} has {$what} an article titled, " . "'{$row['title']}' with the following abstract:\n\n" . "    {$row['abstract']}\n\n" . "Please approve or delete this article via the following " . "page:\n\n" . "    {$PHP_URL}?L{$id}\n"), "From: {$PROJECT_EMAIL}\r\n");
    }
}

示例#9

0

显示文件

文件： poll.php 项目： jokepinocchio/MiniXML

function
show_poll($id)				// I - Poll ID
{
  global $PHP_SELF, $POLL_TYPE_PICKONE, $POLL_TYPE_PICKMANY;


  $result = db_query("SELECT * FROM poll WHERE is_published = 1 AND id = $id");

  if (db_count($result) == 1)
  {
    $row      = db_next($result);
    $id       = $row['id'];
    $question = htmlspecialchars($row['question']);

    print("<p><form method='POST' action='poll.php?v$row[id]'>"
	 ."<b>$question</b>\n");

    if ($row['poll_type'] == $POLL_TYPE_PICKONE)
      print("(please pick one)\n");
    else
      print("(pick all that apply)\n");

    for ($i = 0; $i < 10; $i ++)
    {
      $answer = htmlspecialchars($row["answer$i"]);

      if ($answer != "")
      {
	if ($row['poll_type'] == $POLL_TYPE_PICKONE)
          print("<br /><input type='radio' name='ANSWER'");
	else
          print("<br /><input type='checkbox' name='ANSWER$i'");

	print(" value='$i'/>$answer\n");
      }
    }

    $votes = $row['votes'];
    if ($votes == 1)
      $votes .= "&nbsp;vote";
    else
      $votes .= "&nbsp;votes";

    $ccount = count_comments("poll.php_r$id");
    if ($ccount == 1)
      $ccount .= "&nbsp;comment";
    else
      $ccount .= "&nbsp;comments";

    print("<br /><input type='submit' value='Vote'/>\n"
	 ."[&nbsp;<a href='poll.php?r$id'>Results</a>&nbsp;]\n");
    print("<br />($votes, $ccount)</form></p>\n");
  }

  db_free($result);
}

示例#10

0

显示文件

文件： service.php 项目： Nazg-Gul/gate

 function Update()
 {
     $name = htmlspecialchars(addslashes($this->name));
     if (db_count('service', '`name`="' . $name . '" AND `id`<>' . $this->id) > 0) {
         add_info('Сервис с таким именем уже существует.');
         return false;
     }
     db_update('service', array('name' => "\"{$name}\""), '`id`=' . $this->id);
     return true;
 }

示例#11

0

显示文件

文件： group.php 项目： Nazg-Gul/gate

 function group_update($id)
 {
     $name = htmlspecialchars(trim($_POST['name']));
     if ($name == '') {
         return;
     }
     if (db_count('group', '(`name`="' . $name . '")  AND (`id`<>' . $id . ')') > 0) {
         add_info('Группа с таким именем уже существует.');
     } else {
         db_update('group', array('name' => '"' . $name . '"', 'default' => manage_setting_get_received('default_group') ? 1 : 0), "`id`={$id}");
     }
 }

示例#12

0

显示文件

文件： list_points.php 项目： jsib/intranet

function list_points()
{
    if (isset($_GET['message'])) {
        $point_id = trim($_GET['point']);
        $point_name = trim($_GET['name']);
        switch (@$_GET['message']) {
            case "pointadded":
                $message_html = template_get("message", array('message' => "Добавлена точка \"{$point_name}\""));
                break;
            case "pointdeleted":
                $message_html = template_get("message", array('message' => "Удалена точка \"{$point_name}\""));
                break;
            default:
                $message_html = template_get("nomessage");
        }
    }
    $result_points = db_query("SELECT * FROM `phpbb_points` WHERE `id`!=1 ORDER BY `name` ASC");
    $num_points = db_count($result_points);
    $num = 0;
    $table_html = "";
    if (check_rights('delete_point')) {
        $th_html = "\t<th class='right'></th>";
    } else {
        $th_html = "";
    }
    while ($point = db_fetch($result_points)) {
        $num++;
        if ($num == $num_points) {
            $bottom_class = "bottom";
        } else {
            $bottom_class = "";
        }
        if (check_rights('delete_point')) {
            $right_class = '';
        } else {
            $right_class = 'right';
        }
        $table_html .= "\t<tr class='{$bottom_class}'>\r\n\t\t\t\t\t\t\t<td><a href='/manager.php?action=show_point&point={$point['id']}' style='font-size:9pt;'>" . $point['name'] . "</a></td>\r\n\t\t\t\t\t\t\t<td>" . $point['phone'] . "</td>\r\n\t\t\t\t\t\t\t<td class='{$right_class}'>" . $point['address'] . "</td>";
        if (check_rights('delete_point')) {
            $table_html .= "\t<td class='right'><a href='/manager.php?action=delete_point&point={$point['id']}' onclick=\"if(!confirm('Удалить?')) return false;\">Удалить</a><br/></td>\r\n\t\t\t\t\t\t</tr>";
        }
    }
    if (check_rights('add_point')) {
        $add_point_link = "<a href='/manager.php?action=add_point' class='listcontacts'>Добавить офис/склад</a><br/><br/>";
    }
    $html .= template_get("points/list_points", array('addpointlink' => $add_point_link, 'numpoints' => $num_points, 'table' => $table_html, 'message' => $message_html, 'th_html' => $th_html, 'right_class' => $right_class));
    return $html;
}

示例#13

0

显示文件

文件： service.php 项目： jsib/intranet

function is_engineer_chief_employee(){
	//Подтягиваем глобальные переменные
	global $user;
	
	$q=db_query("SELECT * FROM `phpbb_users` WHERE `user_id`=".$user->data['mychief_id']);
	if(db_count($q)>0){
		$mychief=db_fetch($q);
		if($mychief['engineer_chief']==1){
			return true;
		}else{
			return false;
		}
	}else{
		return false;
	}
}

示例#14

0

显示文件

文件： it.php 项目： jsib/dumps.loc

function getOrAdd_model($name)
{
    $name = trim($name);
    if ($name != "") {
        $qstr = "SELECT * FROM `models` WHERE `name`='" . $name . "'";
        $q = db_query($qstr);
        if (db_count($q) > 0) {
            $model_id = db_easy($qstr)['id'];
        } else {
            db_query("INSERT INTO `models` SET `name`='" . $name . "'");
            $model_id = db_easy("SELECT * FROM `models` WHERE `name`='" . $name . "'")['id'];
        }
        return $model_id;
    } else {
        return 0;
    }
}

示例#15

0

显示文件

文件： show_timetable_rights.php 项目： jsib/intranet

function show_hr_managers()
{
    //Определяем переменные
    $html = "";
    //Запрос к базе
    $hrmanagersRES = db_query("SELECT * FROM `phpbb_users` WHERE `hrmanager`=1 ORDER BY `username` ASC");
    //IF
    if (db_count($hrmanagersRES) > 0) {
        //WHILE
        while ($hrmanager = db_fetch($hrmanagersRES)) {
            $html .= $hrmanager['username'] . "<a href='/manager.php?action=delete_hr_manager_right&user={$hrmanager['user_id']}'><img src='/images/delete.png' style='padding-left:20px;' /></a><br/>";
        }
        //ELSE
    } else {
        $html .= "Ни один пользователь не имеет прав HR-менеджера";
    }
    //Возвращаем значение функции
    return $html;
}

示例#16

0

显示文件

文件： show_rights.php 项目： jsib/intranet

function show_right_users($right_id, $right_name)
{
    //Определяем переменные
    $html = "";
    //Запрос к базе
    $rightsRES = db_query("SELECT `phpbb_users`.`username`, `phpbb_rights_users`.`user_id`, `phpbb_rights_users`.`right_id`\r\n\t\t\t\t\t\t\tFROM `phpbb_rights_users`, `phpbb_users`\r\n\t\t\t\t\t\t\t\tWHERE `phpbb_rights_users`.`right_id`={$right_id}\r\n\t\t\t\t\t\t\t\t\tAND `phpbb_rights_users`.`user_id`=`phpbb_users`.`user_id`\r\n\t\t\t\t\t\t\t\t\t\tORDER BY `phpbb_users`.`username` ASC");
    //IF
    if (db_count($rightsRES) > 0) {
        //WHILE
        while ($user = db_fetch($rightsRES)) {
            $html .= $user['username'] . "<a href='/manager.php?action=delete_right&user={$user['user_id']}&right={$user['right_id']}'><img src='/images/delete.png' style='padding-left:20px;' /></a><br/>";
        }
        //ELSE
    } else {
        $html .= "Ни один пользователь не имеет права {$right_name}";
    }
    //Возвращаем значение функции
    return $html;
}

示例#17

0

显示文件

文件： list_branches.php 项目： jsib/intranet

function list_branches()
{
    $result_branches = db_query("SELECT * FROM `phpbb_branches` WHERE `id`!=1 ORDER BY `name`");
    $num_branches = db_count($result_branches);
    $num = 0;
    $table_html = "";
    while ($branch = db_fetch($result_branches)) {
        $num++;
        if ($num == $num_branches) {
            $bottom_class = "bottom";
        } else {
            $bottom_class = "";
        }
        $table_html .= "\t<tr class='{$bottom_class}'>\r\n\t\t\t\t\t\t\t<td><a href='/manager.php?action=show_branch&branch=" . $branch['id'] . "' style='font-size:9pt;'>" . $branch['name'] . "</a></td>\r\n\t\t\t\t\t\t\t<td><a href='/manager.php?action=edit_branch&branch={$branch['id']}'>Редактировать</a></td>\r\n\t\t\t\t\t\t\t<td class='right'><a href='/manager.php?action=delete_branch&branch={$branch['id']}' onclick=\"if(!confirm('Удалить?')) return false;\">Удалить</a><br/></td>\r\n\t\t\t\t\t\t</tr>";
    }
    $add_branch_link = "manager.php?action=add_branch";
    $html .= template_get("branches/list_branches", array('addbranchlink' => $add_branch_link, 'numbranches' => $num_branches, 'table' => $table_html));
    return $html;
}

示例#18

0

显示文件

文件： tickets_20150916.inc.php 项目： jmangarret/ostickets

if ($search) {
    $qs += array('a' => $_REQUEST['a'], 'q' => $_REQUEST['q']);
    if (is_numeric($_REQUEST['q'])) {
        $qwhere .= " AND ticket.`number` LIKE '{$queryterm}%'";
    } else {
        //Deep search!
        $queryterm = db_real_escape($_REQUEST['q'], false);
        //escape the term ONLY...no quotes.
        $qwhere .= ' AND ( ' . " cdata.subject LIKE '%{$queryterm}%'" . " OR thread.body LIKE '%{$queryterm}%'" . ' ) ';
        $deep_search = true;
        //Joins needed for search
        $qfrom .= ' LEFT JOIN ' . TICKET_THREAD_TABLE . ' thread ON (' . 'ticket.ticket_id=thread.ticket_id AND thread.thread_type IN ("M","R"))';
    }
}
TicketForm::ensureDynamicDataView();
$total = db_count('SELECT count(DISTINCT ticket.ticket_id) ' . $qfrom . ' ' . $qwhere);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('tickets.php', $qs);
//more stuff...
$qselect .= ' ,count(attach_id) as attachments ';
$qfrom .= ' LEFT JOIN ' . TICKET_ATTACHMENT_TABLE . ' attach ON  ticket.ticket_id=attach.ticket_id ';
$qgroup = ' GROUP BY ticket.ticket_id';
$query = "{$qselect} {$qfrom} {$qwhere} {$qgroup} ORDER BY {$order_by} {$order} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$res = db_query($query);
$showing = $res && db_num_rows($res) ? $pageNav->showing() : "";
if (!$results_type) {
    $results_type = ucfirst($status) . ' Tickets';

示例#19

0

显示文件

文件： tickets.inc.php 项目： e-gob/chilesinpapeleo-soporte

    $order_by = $sortOptions[$_REQUEST['sort']];
}
if ($_REQUEST['order']) {
    $order = $orderWays[$_REQUEST['order']];
}
if ($_GET['limit']) {
    $qstr .= '&limit=' . urlencode($_GET['limit']);
}
$order_by = $order_by ? $order_by : 'ticket.created';
$order = $order ? $order : 'DESC';
$pagelimit = $_GET['limit'] ? $_GET['limit'] : PAGE_LIMIT;
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$qselect = 'SELECT ticket.ticket_id,ticket.ticketID,ticket.dept_id,isanswered,ispublic,subject,name ' . ',dept_name,status,source,priority_id,ticket.created,ticket.updated,staff.firstname,staff.lastname';
$qfrom = ' FROM (' . TICKET_TABLE . ' ticket' . ' LEFT JOIN ' . DEPT_TABLE . ' dept ON ticket.dept_id=dept.dept_id )' . ' LEFT JOIN ' . STAFF_TABLE . ' staff ON ticket.staff_id=staff.staff_id';
//Pagenation stuff....wish MYSQL could auto pagenate (something better than limit)
$total = db_count('SELECT count(*) ' . $qfrom . ' ' . $qwhere);
$pageNav = new Pagenate($total, $page, $pagelimit);
$pageNav->setURL('view.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qselect .= ' ,count(attach_id) as attachments ';
$qfrom .= ' LEFT JOIN ' . TICKET_ATTACHMENT_TABLE . ' attach ON  ticket.ticket_id=attach.ticket_id ';
$qgroup = ' GROUP BY ticket.ticket_id';
$query = "{$qselect} {$qfrom} {$qwhere} {$qgroup} ORDER BY {$order_by} {$order} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
$tickets_res = db_query($query);
$showing = db_num_rows($tickets_res) ? $pageNav->showing() : "";
$results_type = $status ? $ger_status . 'Tickets' : 'Tickets';
$negorder = $order == 'DESC' ? 'ASC' : 'DESC';
//Negate the sorting..
?>

示例#20

0

显示文件

文件： forum.func.php 项目： xianyuxmu/alinkagarden-xiuno

function forum_count($cond = array())
{
    return db_count('bbs_forum', $cond);
}

示例#21

0

显示文件

文件： staffmembers.inc.php 项目： ed00m/osTicket-1.8

//Sorting options...
if ($sort && $sortOptions[$sort]) {
    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'staff.firstname,staff.lastname';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(DISTINCT staff.staff_id) ' . $from . ' ' . $where);
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('staff.php', $qstr . '&sort=' . urlencode($_REQUEST['sort']) . '&order=' . urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$select} {$from} {$where} GROUP BY staff.staff_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
//echo $query;
?>
<h2>Staff Members</h2>
<div style="width:700px; float:left;">
    <form action="staff.php" method="GET" name="filter">
     <input type="hidden" name="a" value="filter" >
        <select name="did" id="did">
             <option value="0">&mdash; All Departments &mdash;</option>
             <?php

示例#22

0

显示文件

文件： users.tmpl.php 项目： CarlosAvilesMx/CarlosAviles.Mx

    $order_column =$sortOptions[$sort];

$order_column = $order_column ?: 'user.name';

if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])])
    $order = $orderWays[strtoupper($_REQUEST['order'])];

$order=$order ?: 'ASC';
if ($order_column && strpos($order_column,','))
    $order_column = str_replace(','," $order,",$order_column);

$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$total=db_count('SELECT count(DISTINCT user.id) '.$from.' '.$where);
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total,$page,PAGE_LIMIT);
$pageNav->setURL('users.php',$qstr.'&sort='.urlencode($_REQUEST['sort']).'&order='.urlencode($_REQUEST['order']));
//Ok..lets roll...create the actual query
$qstr.='&order='.($order=='DESC'?'ASC':'DESC');

$select .= ', count(DISTINCT ticket.ticket_id) as tickets ';

$from .= ' LEFT JOIN '.TICKET_TABLE.' ticket ON (ticket.user_id = user.id) ';


$query="$select $from $where GROUP BY user.id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
//echo $query;

$showing = $search ? __('Search Results').': ' : '';

示例#23

0

显示文件

文件： zenpage-template-functions.php 项目： rauldobrota/zenphoto

/**
 * Returns a count of the pages
 *
 * If in search context, the count is the number of items found.
 * If in a page context, the count is the number of sub-pages of the current page.
 * Otherwise it is the total number of pages.
 *
 * @param bool $total return the count of all pages
 *
 * @return int
 */
function getNumPages($total = false)
{
    global $_zp_zenpage, $_zp_zenpage_pagelist, $_zp_current_search, $_zp_current_zenpage_page;
    $addquery = '';
    if (!$total) {
        if (in_context(ZP_SEARCH)) {
            $_zp_zenpage_pagelist = $_zp_current_search->getPages();
            return count($_zp_zenpage_pagelist);
        } else {
            if (in_context(ZP_ZENPAGE_PAGE)) {
                if (!zp_loggedin(ADMIN_RIGHTS | ZENPAGE_PAGES_RIGHTS)) {
                    $addquery = ' AND `show` = 1';
                }
                return db_count('pages', 'WHERE parentid=' . $_zp_current_zenpage_page->getID() . $addquery);
            }
        }
    }
    if (!zp_loggedin(ADMIN_RIGHTS | ZENPAGE_PAGES_RIGHTS)) {
        $addquery = ' WHERE `show` = 1';
    }
    return db_count('pages', $addquery);
}

示例#24

0

显示文件

文件： syslogs.inc.php 项目： KingsleyGU/osticket

if($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order=$orderWays[strtoupper($_REQUEST['order'])];
}
$order=$order?$order:'DESC';

if($order_column && strpos($order_column,',')){
    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$qselect = 'SELECT log.* ';
$qfrom=' FROM '.SYSLOG_TABLE.' log ';
$total=db_count("SELECT count(*) $qfrom $qwhere");
$page = ($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
//pagenate
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$pageNav->setURL('logs.php',$qs);
$qs += array('order' => ($order=='DESC' ? 'ASC' : 'DESC'));
$qstr = '&amp;'. Http::build_query($qs);
$query="$qselect $qfrom $qwhere ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.$title;
else
    $showing=__('No logs found!');
?>

<h2><?php echo __('System Logs');?>

示例#25

0

显示文件

文件： modlog.func.php 项目： xianyuxmu/alinkagarden-xiuno

function modlog_count($cond = array())
{
    return db_count('bbs_modlog', $cond);
}

示例#26

0

显示文件

文件： categories.inc.php 项目： KingsleyGU/osticket

}
$order_column=$order_column?$order_column:'cat.name';

if($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order=$orderWays[strtoupper($_REQUEST['order'])];
}
$order=$order?$order:'ASC';

if($order_column && strpos($order_column,',')){
    $order_column=str_replace(','," $order,",$order_column);
}
$x=$sort.'_sort';
$$x=' class="'.strtolower($order).'" ';
$order_by="$order_column $order ";

$total=db_count('SELECT count(*) FROM '.FAQ_CATEGORY_TABLE.' cat ');
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total, $page, PAGE_LIMIT);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('categories.php', $qs);
$qstr = '&amp;order='.($order=='DESC'?'ASC':'DESC');
$query="$sql GROUP BY cat.category_id ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit();
$res=db_query($query);
if($res && ($num=db_num_rows($res)))
    $showing=$pageNav->showing().' '.__('categories');
else
    $showing=__('No FAQ categories found!');

?>
<div class="pull-left" style="width:700px;padding-top:5px;">
 <h2><?php echo __('FAQ Categories');?></h2>

示例#27

0

显示文件

文件： cannedresponses.inc.php 项目： gizur/osticket

//Sorting options...
if ($sort && $sortOptions[$sort]) {
    $order_column = $sortOptions[$sort];
}
$order_column = $order_column ? $order_column : 'canned.title';
if ($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) {
    $order = $orderWays[strtoupper($_REQUEST['order'])];
}
$order = $order ? $order : 'ASC';
if ($order_column && strpos($order_column, ',')) {
    $order_column = str_replace(',', " {$order},", $order_column);
}
$x = $sort . '_sort';
${$x} = ' class="' . strtolower($order) . '" ';
$order_by = "{$order_column} {$order} ";
$total = db_count('SELECT count(*) FROM ' . CANNED_TABLE . ' canned ');
$page = $_GET['p'] && is_numeric($_GET['p']) ? $_GET['p'] : 1;
$pageNav = new Pagenate($total, $page, PAGE_LIMIT);
$qstr = '&amp;' . Http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('canned.php', $qs);
//Ok..lets roll...create the actual query
$qstr .= '&order=' . ($order == 'DESC' ? 'ASC' : 'DESC');
$query = "{$sql} GROUP BY canned.canned_id ORDER BY {$order_by} LIMIT " . $pageNav->getStart() . "," . $pageNav->getLimit();
$res = db_query($query);
if ($res && ($num = db_num_rows($res))) {
    $showing = $pageNav->showing() . ' ' . _N('premade response', 'premade responses', $total);
} else {
    $showing = __('No premade responses found!');
}
?>

示例#28

0

显示文件

文件： tickets.inc.php 项目： KingsleyGU/osticketLocal

       ' LEFT JOIN '.USER_EMAIL_TABLE.' email ON user.id = email.user_id'.
       ' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id ';

if ($_REQUEST['uid'])
    $qfrom.=' LEFT JOIN '.TICKET_COLLABORATOR_TABLE.' collab
        ON (ticket.ticket_id = collab.ticket_id )';


$sjoin='';

if($search && $deep_search) {
    $sjoin.=' LEFT JOIN '.TICKET_THREAD_TABLE.' thread ON (ticket.ticket_id=thread.ticket_id )';
}

//get ticket count based on the query so far..
$total=db_count("SELECT count(DISTINCT ticket.ticket_id) $qfrom $sjoin $qwhere");
//pagenate
$pagelimit=($_GET['limit'] && is_numeric($_GET['limit']))?$_GET['limit']:PAGE_LIMIT;
$page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1;
$pageNav=new Pagenate($total,$page,$pagelimit);

$qstr = '&amp;'.http::build_query($qs);
$qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']);
$pageNav->setURL('tickets.php', $qs);

//ADD attachment,priorities, lock and other crap
$qselect.=' ,IF(ticket.duedate IS NULL,IF(sla.id IS NULL, NULL, DATE_ADD(ticket.created, INTERVAL sla.grace_period HOUR)), ticket.duedate) as duedate '
         .' ,CAST(GREATEST(IFNULL(ticket.lastmessage, 0), IFNULL(ticket.closed, 0), IFNULL(ticket.reopened, 0), ticket.created) as datetime) as effective_date '
         .' ,ticket.created as ticket_created, CONCAT_WS(" ", staff.firstname, staff.lastname) as staff, team.name as team '
         .' ,IF(staff.staff_id IS NULL,team.name,CONCAT_WS(" ", staff.lastname, staff.firstname)) as assigned '
         .' ,IF(ptopic.topic_pid IS NULL, topic.topic, CONCAT_WS(" / ", ptopic.topic, topic.topic)) as helptopic '

示例#29

0

显示文件

文件： 142.bck.1.php 项目： rudiedirkx/Games

</head>

<body style="overflow:auto;">
<table border="1" cellpadding="0" cellspacing="0" width="600" align="center">
	<tr>
		<th>Table</th>
		<th>Blinds</th>
		<th># Players</th>
		<th>&nbsp;</th>
	</tr>
<?php 
foreach ($arrGames as $arrGame) {
    echo '<tr>';
    echo '<td>Table ' . $arrGame['id'] . '</td>';
    echo '<td>' . (double) $arrGame['small_blind'] . ' / ' . (double) (2 * $arrGame['small_blind']) . '</td>';
    echo '<td>' . db_count(TABLE_PLAYERS_IN_GAMES, 'game_id = ' . (int) $arrGame['id']) . '</td>';
    echo '<td><a onclick="return openTable(' . $arrGame['id'] . ');" href="?game=' . $arrGame['id'] . '">Open table</a></td>';
    echo '</tr>' . "\r\n";
}
?>
</table>
</body>

</html>
<?php 
exit;
function getSeatInfo($f_iSeat)
{
    $iSeat = min(MAX_PLAYERS_EVER, max(1, $f_iSeat));
    return db_fetch("\n\tSELECT\n\t\tu.*,\n\t\tp.*\n\tFROM\n\t\t" . TABLE_PLAYERS . " u,\n\t\t" . TABLE_PLAYERS_IN_GAMES . " p\n\tWHERE\n\t\t(p.seat = " . $iSeat . ") AND\n\t\t(p.table_id = " . GAME_ID . ") AND\n\t\t(p.user_id = u.id);\n\t");
}

示例#30

0

显示文件

文件： ipaccess.func.php 项目： xianyuxmu/alinkagarden-xiuno

function ipaccess_count()
{
    $n = db_count('bbs_ipaccess');
    return $n;
}

PHP db_count示例