n@log 라는 통계프로그램을 사용중입니다. 리스트 정렬문제 입니다.
본문
카운터를 만들면 무조건 카운터이름순으로 정렬이 됩니다.
혹시 최근에 만들어진게 맨위쪽으로 가게 가능할까요?
아래는 소스입니다.
<?
//////////////////////////////////준비
if(!@include"nalog_connect.php"){echo"<script lanugage=javascript>alert('Please install n@log first :)')</script>
<meta http-equiv='refresh' content='0;url=install.php'>";exit;}
include "lib.php";
if(!@include "nalog_language.php"){nalog_go("install.php");}
include "language/$language/language.php";
echo $lang[head];
//////////////////////////////////체크
nalog_admin_check("login.php?go=root.php");
//////////////////////////////////테이블꺼내기
$tables=nalog_list_bd();
$total=count($tables);
//////////////////////////////////페이지당 카운터수
if($page){nalog_chk_num($page,0,$lang[counter_manager_view_error],0);}
else{$page=999;}
//////////////////////////////////목록수
$pageviewsu=999;
//////////////////////////////////인덱스설정
$pagesu=ceil($total/$page);
$start=($page*$pagenum);
$no=$total-$start;
$pagegroup=ceil(($pagenum+1)/$pageviewsu);
$pagestart=($pageviewsu*($pagegroup-1))+1;
$pageend=$pagestart+$pageviewsu-1;
$nowpage=$pagenum+1;
?>
<script language=javascript>
function chk_drop(){
if(!confirm('n@log warning : \n\n<?=$lang[counter_manager_warning_drop]?>')){return false;}
}
function chk_del(){
if(!confirm('n@log warning : \n\n<?=$lang[counter_manager_warning_clean]?>')){return false;}
}
function chk_new(){
if(!chk.new_board.value){alert('n@log error : \n\n<?=$lang[counter_manager_error_create]?>');chk.new_board.focus();return false;}
}
</script>
<table width=100% height=100%>
<tr><td valign=top><br><br>
<table align=center width=600 cellpadding=2 cellspacing=0 border=0 bgcolor=#F1F9FD>
<tr><td colspan=2 bgcolor=white><a href=http://navyism.com target=_blank><img src=nalog_image/logo_small.gif border=0></a></td></tr>
<tr><td colspan=2 bgcolor=white>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td><font color=#008CD6 size=4><b> <a href=root.php><?=$lang[root_title]?></a> > <?=$lang[counter_manager_title]?></b></font></td>
<td align=right><?=$logout?> <?=$help?></td>
</tr>
</table>
</td></tr>
<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td colspan=2 height=5></td></tr>
<tr><td colspan=2>
<table align=center width=98% cellpadding=0 cellspacing=0 border=0>
<form method=get action=admin.php>
<tr>
<td><?=$lang[counter_manager_paging1]?><b><?=$total?></b><?=$lang[counter_manager_paging2]?><b><?=$nowpage?></b><?=$lang[counter_manager_paging3]?><b><?=$pagesu?></b><?=$lang[counter_manager_paging4]?></td>
<td align=right><?=$lang[counter_manager_view]?> <input type=text size=3 class=input maxlength=3 name=page value=<?=$page?> onKeyPress="if((event.keyCode>57||event.keyCode<48)) event.returnValue=false;"> <input type=submit class=button value="<?=$lang[counter_manager_view_button]?>"></td>
</tr>
</form>
</table>
<table align=center width=98% cellpadding=2 cellspacing=0 border=1 bordercolor=white>
<form method=post action=admin_ing.php name=chk onsubmit="return chk_new()">
<input type=hidden name=mode value=make>
<tr bgcolor=#C9F0FF>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_no]?></td>
<td width=93% align=center><?=$lang[counter_manager_table_name]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_example]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_drop]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_clean]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_total]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_today]?></td>
<td width=1% nowrap align=center><?=$lang[counter_manager_table_peak]?></td>
</tr>
<?
//////////////////////////////////넘겨질변수
$send="&page=$page&";
//////////////////////////////////출력값
for($i=$start;$i<$start+$page;$i++)
{
if(!$tables[$i]){break;}
$board_name=$tables[$i];
//////////////////////////////////출력
$yy=date(Y);
$mm=date(m);
$dd=date(d);
$query="select * from nalog3_data where counter='$board_name' and yy=$yy and mm=$mm and dd=$dd";
$counter_today=mysql_fetch_array(mysql_query($query));
$counter_today=$counter_today[hit];
$set=nalog_config("$board_name");
$counter_max=$set[peak];
$counter_total=$set[total];
echo"
<tr bgcolor=white>
<td width=1% nowrap align=center>$no</td>
<td width=91%><a href=admin_counter.php?counter=$board_name target=_blank>$board_name</a></td>
<td width=1% nowrap align=center><a href=example.php?counter=$board_name target=_blank>$lang[counter_manager_tablecell_view]</a></td>
<td width=1% nowrap align=center><a href=admin_ing.php?new_board=$board_name&mode=drop onclick=\"return chk_drop()\">$lang[counter_manager_tablecell_drop]</a></td>
<td width=1% nowrap align=center><a href=admin_ing.php?new_board=$board_name&mode=del onclick=\"return chk_del()\">$lang[counter_manager_tablecell_clean]</a></td>
<td width=1% nowrap align=right>".number_format($counter_total)."</td>
<td width=1% nowrap align=right>".number_format($counter_today)."</td>
<td width=1% nowrap align=right>".number_format($counter_max)."</td>
</tr>
";
//////////////////////////////////-0-
$no--;
}
//////////////////////////////////총갯수
echo"<input type=hidden name=count value=$i>";
?>
</table>
</td></tr>
<tr><td colspan=2 align=center><?nalog_index()?>
</td></tr>
<tr><td colspan=2 height=5></td></tr>
<tr><td colspan=2>
<table align=center width=98% cellpadding=2 cellspacing=0 border=0 bordercolor=white bgcolor=#C9F0FF>
<tr>
<td>
<input type=hidden name=pagenum value=<?=$pagenum?>>
<input type=input class=input name=new_board size=20 value='<?=$word?>' onclick=select()> <input type=submit value="<?=$lang[counter_manager_create_button]?>" class=button>
</td></tr>
</table>
</td></tr></form>
<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td bgcolor=white><a href=admin.php>List</a></td><td bgcolor=white align=right><?=$lang[copy]?></td></tr>
</table>
</td></tr>
</table>
</body>
</html>
<?@mysql_close($connect);?>
답변을 작성하시기 전에 로그인 해주세요.