»ç¿ëÀÚ Áú¹®,´äº¯
|
|
ÃÖ±Ù 10Àϰ£ ´äº¯Ã¤Åà ¼øÀ§
-- update:30Min --
¡° ¹è³ÊÁß°è»çÀÌÆ®ÀÔ´Ï´Ù. ¡±
|
ÃֽŰԽù° Çѱۺ¸µå¸íÃâ·Â
questions and answers
»ç¿ëÀÚ Áú¹®.´äº¯ Q&A
|
|
| ÀÛ¼ºÀÚ |
¼¾½º¸®
|
| ºÐ ·ù |
Ȱ¿ë |
| ȨÆäÀÌÁö Á¦ÀÛ°æ·Â |
3 °³¿ù  |
|
¤ýÁ¶È¸: 40 ¤ýÃßõ: 0
|
|
| ¤ýÀÛ¼ºÀÏ: 2010/07/29 (¸ñ) 12:35 |
|
|
¡° ÃֽŰԽù° Çѱۺ¸µå¸íÃâ·Â ¡±
function Hit_rank_print_here($bd_array,$day_no,$order_by,$prt_cnt) {
// º¸µå¸í, ¸îÀÏÀüºÎÅÍ ÇöÀç±îÁö, ÃßÃâ¼ø¼, Ãâ·Â°¹¼ö
global $connect;
/* DEFINE VARIABLES */
$date_priod = mktime(0,0,0) - $day_no * 86400; // ÇöÀçºÎÅÍ ¸îÀÏÀü($day_no)°ª °è»ê
$board_id = explode("/",$bd_array); // ÀÔ·Â ¹ÞÀº º¸µå¸íÀ» ¹è¿·Î ¸¸µê
$sel_if = "wdate > $date_priod and name != 'admin'"; // º¸µåº° ÃßÃâ Á¶°Ç
$limit_no = 20; // º¸µåº° ÃßÃâ °¹¼ö - º¸µåº° ÃßÃâ°¹¼ö * º¸µå¼ö => ÃÑ ÃßÃâ°¹¼ö
$subj_length = 25; // ±ÛÁ¦¸ñ ÃÖ´ë ±æÀÌ
$j = 0; // ¹è¿ Àμö
$rank = 1; // ¼øÀ§ º¯¼ö
/* GET DATA */
for( $i = 0; $i < sizeof($board_id); $i++){
// º¸µå ¼ö ¸¸Å ¹Ýº¹ ÀÛ¾÷
$table_name = 'a_tn2_'.$board_id[$i].'_list';
$query = "select * from $table_name where $sel_if order by $order_by desc limit $limit_no";
$select_result = @mysql_query($query,$connect);
while($Index_data = @mysql_fetch_array($select_result)){
// º¸µåº°·Î µ¥ÀÌÅ͸¦ ÃßÃâ
$list[$j] = array( // º¸µåº° ·Î µ¥ÀÌÅÍ ÃßÃâ ¹× ¹è¿¿¡ ÀúÀå
"board_name" => $Index_data[board_name],
"no" => $Index_data[no],
"subject" => $Index_data[subject],
"name" => $Index_data[name],
"wdate" => $Index_data[wdate],
"hit" => $Index_data[hit],
); // À ºÎºÐ¿¡¼ Çʿ信 µû¶ó Ç׸ñ(ÁÙ)Àº »èÁ¦ ¶Ç´Â Ãß°¡ °¡´É (ÂïÀ»¶§´Â ÇÊ¿äºÎºÐ¸¸ °ñ¶ó Âï±â¶§¹® ±×³É µÎ¾îµµ µÊ)
$j++;
}
}
/* SORT */
$list = Array_sort($list,"wdate"); // ÇöÀç ÀԷº¸µå¼ø¼º°. Á¶È¸¼øÀ¸·Î µÇ¾î ÀÖ´Â °ÍÀ» º¸µå±¸ºÐ¾øÀÌ Á¶È¸ ¼ø¼¸¸À¸·Î Á¤·Ä
/* PRINT */
/* ¡Ú¡Ú ´Ù¸¥µ¥´Â ÇÊ¿ä ¾ø°í echo ¶ó°í ½áÀÖ´Â ÁÙÀ» ã¾Æ¼ Çʿ信 µû¶ó ³»¿ë ¼öÁ¤. //...../.. ºÎºÐ °íÄ¡¼¼¿ä ¡Ú¡Ú */
echo "<table width=100% border=0>\n"; // Å×ÀÌºí ¿ÀÇ - width, border °íÄ¡¼¼¿ä
echo "<tr><td colspan=2></td></tr>\n"; // Ãâ·Â½Ã Á¦¸ñÁÙ - colspan Àº ¾Æ·¡ ³»¿ëÃß·ÂÀÇ TD¼ö¿¡ µû¶ó ²À °íÄ¡¼¼¿ä
for($i=0;$i<$prt_cnt;$i++){
$subject = string_cut(stripslashes($list[$i][subject]),$subj_length,'..'); // ±ÛÁ¦¸ñ $subj_length¸¸Å ÁÙÀÓ
$link_subject = "<a href=board.php?board=".$list[$i][board_name]."&command=body&no=".$list[$i][no]." target=_new>".$subject."</a>";
$p_date = date("m-d",$list[$i][wdate]);
echo "<tr><td height=12><table id=keyword_name height=12><tr><td height=12 width=12>.$Bconfig[tx1_1]";
//------------------
$orderNum++;
if($orderNum<21) {
echo "<img src='./img/board/medal{$orderNum}.gif'>";
}else {
echo $orderNum;
}
echo "</td><td width=190>".$link_subject."</td><td width=40> <span style=font-size:11px;font-family:verdana;color:#979797;>$p_date
</span>
</td></tr></table></td></tr>\n"; // Àú GET DATA ºÎºÐÁß ¹è¿¿¡ ³ÖÀ»¶§ÀÇ À̸§ ÂüÁ¶ ÇÏ¿© Ãß°¡ ¹× »èÁ¦ °¡´É. ÄõÅ×ÀÌ¼Ç ¸¶Å© Àß »ìÆìÁÖ¼¼¿ä.
$rank++;
}
echo "</table> \n";// Å×À̺í Ŭ·Î¿ìÁî
}
?>
ÃֱٰԽù° Ãâ·Â¿¡¼ Çѱۺ¸µå¸í Ãâ·Â ½Ãų·Á¸é À§¿¡ ¼Ò½º¿¡¼ ¾î¶»°Ô ÇØ¾ßµÇÁÒ??
http://www.technote.co.kr/php/technote1/board.php?board=apple&command=body&no=21
http://www.technote.co.kr/php/technote1/board.php?board=apple&command=body&no=1030
À̱۵é ÂüÁ¶Ç϶õ ¸»¸»±¸¿ä À§¿¡ ¼Ò½º¿¡¼ ÇÏ´Â ¹æ¹ý Á» ºÎʵ叱°Ô¿ä...
Á¤¸» Àú¿¡°Õ Áß¿äÇѰŶó; ¤Ð
|
20
|
 |
|