Файл: InstantSocial/uploud/components/present/gifts.php
Строк: 155
<?php
/*********************************************************************************************/
// //
// InstantPresent v1.0 (c) 2010 //
// http://www.instantcms.ru/, info@instantcms.ru //
// //
// written by Somebody & Александр, 2010 //
// //
/*********************************************************************************************/
function pageSelect($gifts, $current, $perpage){
$html = '';
global $_LANG;
if ($gifts){
$pages = ceil($gifts / $perpage);
if($pages>1){
$html .= '<td width="60"><strong>'.$_LANG['GIFT_PAGE'].': </strong></span></td>';
$html .= '<td width="60" align="center"><form style="margin:0px;padding:0px" action="" name="pageform" method="POST">';
$html .= '<select style="width:60px" name="cpage" onchange="document.pageform.submit()">';
for ($p=1; $p<=$pages; $p++){
if ($p != $current) {
$html .= '<option value="'.$p.'">'.$p.'</option>';
} else {
$html .= '<option value="'.$p.'" selected>'.$p.'</option>';
}
}
$html .= '</select></form></td>';
$html .= '<td width="30"> из <strong>'.$pages.'</strong><td>';
}
}
return $html;
}
$opt = $inCore->request('opt', 'str', 'in');
if (usrCheckAuth()){
global $_LANG;
echo '<div class="con_heading" style="margin-bottom:25px">'.$_LANG['MY_GIFTS'].'</div>';
//current page
$perpage = 10;
if (isset($_POST['cpage'])) { $page = $_REQUEST['cpage']; } else { $page = 1; }
if ($opt=='in'){
//сколько всего подарков
$sql = "SELECT p.id FROM cms_present_list p, cms_users u WHERE p.user_id_to = $id AND p.user_id_from = u.id";
$result = $inDB->query($sql) ;
$gift_count = $inDB->num_rows($result);
//список подарков
$sql = "SELECT cms_present_list.id as pr_id,
cms_present_list.user_id_from,
cms_present_list.user_id_to,
cms_present_list.present_id,
cms_present_list.message,
cms_present_list.is_new,
cms_present.id,
cms_present.link,
cms_users.id,
cms_users.login,
cms_users.nickname,
DATE_FORMAT(cms_present_list.time, '%d-%m-%Y (%H:%i)') as time
FROM cms_present_list, cms_present, cms_users
WHERE cms_present_list.user_id_to = $id AND cms_present_list.present_id = cms_present.id AND cms_present_list.user_id_from = cms_users.id
ORDER BY time DESC
LIMIT ".(($page-1)*$perpage).", $perpage";
} elseif ($opt=='out'){
//сколько всего подарков
$sql = "SELECT p.id FROM cms_present_list p, cms_users u WHERE p.user_id_from = $id AND p.user_id_to = u.id";
$result = $inDB->query($sql) ;
$gift_count = $inDB->num_rows($result);
//список подарков
$sql = "SELECT cms_present_list.id,
cms_present_list.user_id_from,
cms_present_list.user_id_to,
cms_present_list.present_id,
cms_present_list.message,
cms_present_list.is_new,
cms_present.id,
cms_present.link,
cms_users.id,
cms_users.login,
cms_users.nickname,
DATE_FORMAT(cms_present_list.time, '%d-%m-%Y (%H:%i)') as time
FROM cms_present_list, cms_present, cms_users
WHERE cms_present_list.user_id_from = $id AND cms_present_list.present_id = cms_present.id AND cms_present_list.user_id_to = cms_users.id
ORDER BY time DESC
LIMIT ".(($page-1)*$perpage).", $perpage";
}
$result = $inDB->query($sql) or die(mysql_error().'<br/><br/>'.$sql);
echo '<div style="margin-bottom:10px">';
if ($opt=='in'){
$inPage->addPathway($_LANG['MY_GIFTS']);
echo '<span class="usr_msgmenu_active in_span">'.$_LANG['MY_GIFTS_IN'].'</span> ';
echo '<a class="usr_msgmenu_link out_link" href="/present/'.$id.'/gifts-sent.html">'.$_LANG['MY_GIFTS_OUT'].'</a>';
} elseif ($opt=='out') {
$inPage->addPathway($_LANG['MY_GIFTS_OUT']);
echo '<a class="usr_msgmenu_link in_link" href="/present/'.$id.'/gifts.html">'.$_LANG['MY_GIFTS_IN'].'</a> ';
echo '<span class="usr_msgmenu_active out_span">'.$_LANG['MY_GIFTS_OUT'].'</span>';
}
echo '</div>';
if ($opt=='in' || $opt=='out'){
echo '<table class="usr_msgmenu_bar" width="100%" height="30" border="0" cellpadding="5" cellspacing="0"><tr>';
echo '<td><strong>'.$_LANG['GIFTS_ALL'].':</strong> ' .$gift_count.'</td>';
if ($opt=='out'){
echo '<td align="center"><span style="color:gray">'.$_LANG['SENT_GIFTS'].'.</span></td>';
}
if ($gift_count > $perpage){
echo pageSelect($gift_count, $page, $perpage);
}
echo '</tr></table>';
if ($inDB->num_rows($result)){
while($ListPresent = $inDB->fetch_assoc($result)){
$ListPresents[] = $ListPresent;
//помечаем подарок как просмотренный
if ($opt=='in'){
$inDB->query("UPDATE cms_present_list SET is_new = 0 WHERE id = ".$ListPresent['pr_id']);
}
}
//отдаем в шаблон
$smarty= $inCore->initSmarty('components', 'com_present_gifts.tpl');
$smarty->assign('total', $gift_count);
$smarty->assign('ListPresent', $ListPresents);
$smarty->assign('page', $opt);
$smarty->display('com_present_gifts.tpl');
} else { echo '<p>'.$_LANG['NOT_GIFTS_IN_CAT'].'.</p>'; }
}
}
?>