check_pagging PHP 코드 예제들

예제 #1

0

파일 보기

파일: user.management.view.users.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_user_view_u';
$query = "";
if ($db->is('query') && strlen($db->filter('query')) > 2) {
    $search = " AND (username LIKE '%" . $db->filter('query') . "%' OR email LIKE '%" . $db->filter('query') . "%' OR name LIKE '%" . $db->filter('query') . "%')";
    $query = $db->filter('query');
} else {
    $search = '';
}
$pagging = check_pagging("SELECT ID,username,email,GroupID,name,visit,enabled,registration FROM cms_user WHERE status='N' " . $search . "", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div>
    <div style="margin-left:10px; float:left; margin-top:10px; font-weight:bold;"><?php 
echo $lang->MOD_44;
?>
</div>
    <input id="a_user_view_u_table_id_search" name="search" value="<?php 
echo $query;
?>
" class="input" style="width:200px; margin-left:10px;" value="" type="text" maxlength="50" />
</div>
<div id="a_user_view_u_table" style="clear:both;">
<?php 
echo pagging($accordion_id, $pagging);
?>
<table cellpadding="0" cellspacing="1" border="0" id="a_user_view_u_table" summary="View users" class="table1 table2" width="99%">

예제 #2

0

파일 보기

파일: user.view.fields.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_user_view_f';
$pagging = check_pagging("SELECT * FROM cms_user_fields WHERE status='N'", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div id="a_user_view_f_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" summary="View fields" class="table1 table2" width="99%">
<caption class="hide">View fields</caption>
	<tr>
		<th scope="col" abbr=""><?php 
echo $lang->MOD_60;
?>
</th>
		<th scope="col" abbr=""><?php 
echo $lang->MOD_61;
?>
</th>
		<th scope="col" abbr=""><?php 
echo $lang->MOD_62;
?>
</th>
		<th scope="col" abbr=""><?php 
echo $lang->MOD_11;
?>
</th>
		<th scope="col" abbr=""><?php 
echo $lang->MOD_63;

예제 #3

0

파일 보기

파일: mail.sent.items.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_mail_sent';
$pagging = check_pagging('select ID,subject,content,date from cms_mail_main where senderID="' . $user->id . '" and status="N" order by date desc', $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div id="a_mail_sent_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" width="99%">
	<tr>
    	<th><?php 
echo $lang->MAIL_TO;
?>
</th>
		<th><?php 
echo $lang->MAIL_SUBJECT;
?>
</th>
		<th><?php 
echo $lang->SENT_DATE;
?>
</th>
		<th><?php 
echo $lang->CONTROL;
?>
</th>
	</tr>
    <?php 
$counter = 1;

예제 #4

0

파일 보기

파일: menus.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_menus';
$selected_lang_menus = 1;
if ($db->is('lang_menus')) {
    $selected_lang_menus = $db->filter('lang_menus');
} else {
    $selected_lang_menus = $user->translate_lang;
}
$pagging = check_pagging("SELECT ID,title,description,status,date,enabled,lang,parent,s_default FROM cms_menus WHERE status='N' AND domain='" . $user->domain . "' AND lang='" . $selected_lang_menus . "'", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
if ($user->translate_state == "ON") {
    $dialog = 'd_menus_sitetree_trans';
    echo '<div class="flt-right display">Language ' . lang_dropdown('' . $selected_lang_menus . '', '' . $accordion_id . '', 'lang_menus') . '</div>';
} else {
    $dialog = 'd_menus_sitetree';
}
?>
<form id="">
<input id="selected_lang_menu_id" value="<?php 
echo $selected_lang_menus;
?>
" type="hidden"/>
</form>
<div id="a_menus_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" id="viewgroups" width="99%">
	<tr>
    <th></th>

예제 #5

0

파일 보기

파일: user.management.view.groups.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_user_view_g';
$pagging = check_pagging("SELECT ID,title,description,creation,enabled FROM cms_user_groups WHERE status='N'", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div id="a_user_view_g_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" width="99%" id="viewgroups">
	<tr>
		<th><?php 
echo $lang->TITLE;
?>
</th>
		<th><?php 
echo $lang->USER_ADD_D_1;
?>
</th>
		<th><?php 
echo $lang->USER_NUMBER;
?>
</th>
		<th><?php 
echo $lang->CREATE_DATE;
?>
</th>
		<?php 
if ($user->getAuth('a_user_view_g') == 2 || $user->getAuth('a_user_view_g') == 4 || $user->getAuth('a_user_view_g') == 5) {
    echo '<th>' . $lang->CONTROL . '</th>';

예제 #6

0

파일 보기

파일: article.view.articles.php 프로젝트: NejcZdovc/sumo2

} else {
    $selected_cat = '';
}
if ($db->is('autor_id') && $db->filter('autor_id') != "-1") {
    $selected_author = " AND author='" . $db->filter('autor_id') . "'";
} else {
    $selected_author = '';
}
$query = "";
if ($db->is('query') && strlen($db->filter('query')) > 2) {
    $search = " AND title LIKE '%" . $db->filter('query') . "%'";
    $query = $db->filter('query');
} else {
    $search = '';
}
$pagging = check_pagging("SELECT ID,title,category,dateStart,views,dateEnd,lang,author,date, published FROM cms_article WHERE status='N' AND lang='" . $selected_lang_cat . "' AND domain='" . $user->domain . "' " . $selected_cat . " " . $selected_author . " " . $search . " order by title asc", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
if ($user->translate_state == "ON") {
    echo '<div class="flt-right display">' . $lang->ARTICLE_3 . ' ' . lang_dropdown('' . $selected_lang_cat . '', '' . $accordion_id . '', 'lang_art') . '</div>';
}
echo '<div class="flt-right display"><select onchange="sumo2.accordion.ReloadAccordion(\'' . $accordion_id . '\', \'cat_id=\'+this.value);">
		  <option value="-1">' . $lang->MOD_185 . '</option>';
$catListQ = $db->query('SELECT ID, title FROM cms_article_categories WHERE status="N" AND enabled="1"');
while ($catListR = $db->fetch($catListQ)) {
    if ($db->filter('cat_id') == $catListR['ID']) {
        echo '<option value="' . $catListR['ID'] . '" selected="selected" style="text-transform:none;">' . $catListR['title'] . '</option>';
    } else {
        echo '<option value="' . $catListR['ID'] . '" style="text-transform:none;">' . $catListR['title'] . '</option>';
    }
}

예제 #7

0

파일 보기

파일: seo.urls.view.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_seo_redirect_view';
$pagging = check_pagging("SELECT ID,source,destination,type FROM cms_seo_redirects WHERE lang='" . $user->translate_lang . "' AND domainID='" . $user->domain . "'order by ID asc", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div>
      <div style="margin-left:10px; float:left; margin-top:10px; font-weight:bold;"><?php 
echo $lang->MOD_44;
?>
</div>
      <input id="a_seo_redirect_view_table_id_search" name="search" class="input" style="width:200px; margin-left:10px;" value="" type="text" maxlength="50" />
</div>
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" id="a_seo_redirect_view_table" width="99%">
	<thead>
    <tr>
    	<th><?php 
echo $lang->MOD_233;
?>
</th>
		<th><?php 
echo $lang->MOD_235;
?>
</th>
		<th><?php 
echo $lang->MOD_237;
?>
</th>

예제 #8

0

파일 보기

파일: mail.inbox.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_mail_inbox';
$pagging = check_pagging("SELECT ID, mainID, date, status FROM cms_mail_sent WHERE recipientID='" . $user->id . "' and status!='D' and status!='DD' ORDER BY status desc, date desc ", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div id="a_mail_inbox_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" width="99%">
	<tr>
    	<th></th>
    	<th><?php 
echo $lang->MAIL_FROM;
?>
</th>
		<th><?php 
echo $lang->MAIL_SUBJECT;
?>
</th>
		<th><?php 
echo $lang->SENT_DATE;
?>
</th>
		<th><?php 
echo $lang->CONTROL;
?>
</th>
	</tr>
	<?php

예제 #9

0

파일 보기

파일: article.view.categories.details.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$id_cat = $crypt->decrypt($db->filter('gida'));
$accordion_id = 'a_article_view_cd' . $id_cat;
$pagging = check_pagging("SELECT ID,title,category,dateStart,dateEnd,author,lang,date, published FROM cms_article WHERE status='N' AND category LIKE '%#??#" . $id_cat . "#??#%' order by title asc", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div>
      <div style="margin-left:10px; float:left; margin-top:10px; font-weight:bold;"><?php 
echo $lang->MOD_44;
?>
</div>
      <input id="a_article_view_cd_table_id_search" name="search" class="input" style="width:200px; margin-left:10px;" value="" type="text" maxlength="50" />
</div>
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" id="viewgroups_detailed" width="99%">
	<thead>
	<tr>
    	<th><?php 
echo $lang->MOD_40;
?>
</th>
		<th><?php 
echo $lang->TITLE;
?>
</th>
		<th><?php 
echo $lang->ARTICLE_5;
?>

예제 #10

0

파일 보기

파일: user.management.view.group.details.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$id = $crypt->decrypt($db->filter('gid'));
$accordion_id = 'a_user_group_vd' . $id;
$pagging = check_pagging("SELECT ID,username,email,GroupID,name,visit,enabled FROM cms_user WHERE GroupID='" . $id . "' AND status='N'", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
?>
<div id="a_user_group_vd" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" width="99%">
	<tr>
		<th><?php 
echo $lang->NAME;
?>
</th>
		<th><?php 
echo $lang->USERNAME;
?>
</th>
		<th><?php 
echo $lang->MAIL;
?>
</th>
		<th><?php 
echo $lang->GROUP;
?>
</th>
		<th><?php 
echo $lang->LAST_VISIT;

예제 #11

0

파일 보기

파일: article.view.categories.php 프로젝트: NejcZdovc/sumo2

<?php

require_once '../initialize.php';
$security->checkFull();
$accordion_id = 'a_article_view_c';
$selected_lang_cat = 1;
if ($db->is('lang_cat')) {
    $selected_lang_cat = $db->filter('lang_cat');
} else {
    $selected_lang_cat = $user->translate_lang;
}
$pagging = check_pagging("SELECT ID,title,description,enabled,date,lang FROM cms_article_categories WHERE status='N' AND domain='" . $user->domain . "' AND lang='" . $selected_lang_cat . "'", $user->items);
$dropdown = dropdown_pagging($accordion_id, $pagging[0]);
echo '<div class="flt-right display">' . $dropdown . '</div>';
if ($user->translate_state == "ON") {
    echo '<div class="flt-right display">' . $lang->ARTICLE_3 . ' ' . lang_dropdown('' . $selected_lang_cat . '', '' . $accordion_id . '', 'lang_cat') . '</div>';
}
?>
<div id="a_article_view_c_table" style="clear:both;">
<table cellpadding="0" cellspacing="1" border="0" class="table1 table2" id="viewgroups" width="99%">
	<tr>
    	<th><?php 
echo $lang->MOD_40;
?>
</th>
		<th><?php 
echo $lang->TITLE;
?>
</th>
		<th><?php 
echo $lang->USER_ADD_D_1;

PHP check_pagging 예제들