query("SELECT count(*) FROM {$dbprefix}collect WHERE username='$_GET[username]' AND sortname='$_GET[sortname]'");
$qcount=$dblink->result($query,0);
$pagecount=ceil($qcount/$pagerow);
if ($_GET['page']>$pagecount) $_GET['page']=1;
$start=($_GET['page']-1)*$pagerow;
$query=$dblink->query("SELECT * FROM {$dbprefix}collect WHERE username='$_GET[username]' AND sortname='$_GET[sortname]' ORDER BY collecttime desc limit $start,$pagerow");
}
else
{
$query=$dblink->query("SELECT count(*) FROM {$dbprefix}collect");
$qcount=$dblink->result($query,0);
$pagecount=ceil($qcount/$pagerow);
if ($_GET['page']>$pagecount) $_GET['page']=1;
$start=($_GET['page']-1)*$pagerow;
$query=$dblink->query("SELECT * FROM {$dbprefix}collect ORDER BY collecttime desc limit $start,$pagerow");
}
admin_header();
?>
| =$lang['col_title']?> |
=$lang['col_username']?> |
=$lang['col_type']?> |
=$lang['col_attrib']?> |
=$lang['col_add_time']?> |
=$lang['delete']?> |
fetch_array($query))
{
?>
|
|
|
|
|
=$lang['delete']?> |
|
=$lang['di']?>=$lang['ye']?>/=$lang['gong']?>=$lang['ye']?>
=$lang['shouye']?>
1)
{
$start = floor($_GET['page']/10)*10;
$end = $start+9;
if($start<1)
{
$start=1;
}
if($end>$pagecount)
{
$end=$pagecount;
}
for($i=$start; $i<=$end; $i++)
{
if($_GET['page']==$i)
{
echo ' '.$i.'';
}
else
{
echo ' ['.$i.']';
}
}
}
?>
=$lang['weiye']?>
|
|
|
query("SELECT count(*) FROM {$dbprefix}collect WHERE public=1");
$collectcount=$dblink->result($query,0);
$pagecount=ceil($collectcount/$pagerow);
if ($_GET['page']>$pagecount) $_GET['page']=1;
$start=($_GET['page']-1)*$pagerow;
$query=$dblink->query("SELECT * FROM {$dbprefix}collect WHERE public=1 ORDER BY collecttime desc limit $start,$pagerow");
admin_header();
?>
| =$lang['col_title']?> |
=$lang['col_username']?> |
=$lang['col_type']?> |
=$lang['col_attrib']?> |
=$lang['col_add_time']?> |
=$lang['delete']?> |
fetch_array($query))
{
?>
|
|
|
|
|
=$lang['delete']?> |
|
=$lang['di']?>=$lang['ye']?>/=$lang['gong']?>=$lang['ye']?>
=$lang['shouye']?>
1)
{
$start = floor($_GET['page']/10)*10;
$end = $start+9;
if($start<1)
{
$start=1;
}
if($end>$pagecount)
{
$end=$pagecount;
}
for($i=$start; $i<=$end; $i++)
{
if($_GET['page']==$i)
{
echo ' '.$i.'';
}
else
{
echo ' ['.$i.']';
}
}
}
?>
=$lang['weiye']?>
|
|
|
query("SELECT count(*) FROM {$dbprefix}collect WHERE public=0");
$collectcount=$dblink->result($query,0);
$pagecount=ceil($collectcount/$pagerow);
if ($_GET['page']>$pagecount) $_GET['page']=1;
$start=($_GET['page']-1)*$pagerow;
$query=$dblink->query("SELECT * FROM {$dbprefix}collect WHERE public=0 ORDER BY collecttime desc limit $start,$pagerow");
admin_header();
?>
| =$lang['col_title']?> |
=$lang['col_username']?> |
=$lang['col_type']?> |
=$lang['col_attrib']?> |
=$lang['col_add_time']?> |
=$lang['delete']?> |
fetch_array($query))
{
?>
|
|
|
|
|
=$lang['delete']?> |
|
=$lang['di']?>=$lang['ye']?>/=$lang['gong']?>=$lang['ye']?>
=$lang['shouye']?>
1)
{
$start = floor($_GET['page']/10)*10;
$end = $start+9;
if($start<1)
{
$start=1;
}
if($end>$pagecount)
{
$end=$pagecount;
}
for($i=$start; $i<=$end; $i++)
{
if($_GET['page']==$i)
{
echo ' '.$i.'';
}
else
{
echo ' ['.$i.']';
}
}
}
?>
=$lang['weiye']?>
|
|
|
query("UPDATE {$dbprefix}collect SET tag='$_GET[tag]',orderid='$_GET[orderid]' WHERE tid='$_GET[tid]'");
header("location:admin.php?admin_action=collect_sort");
}
elseif($admin_action=='collect_del')
{
$dblink->query("DELETE FROM {$dbprefix}collect WHERE id=$_GET[id]");
header("location:admin.php?admin_action=collect_list");
}
else
{
echo 'collect manage error';
}
?>