function deletecat() { //pour supprimer une catégorie (fonction appelée par le clic sur "supprimer" dans une ligne du formulaire) global $deletecat, $keysommaire, $confirm, $catname, $db, $prefix; if ($confirm != "YES") { include "header.php"; GraphicAdmin(); echo "<br>"; OpenTable(); $catname = htmlspecialchars($catname); echo "<div align=\"center\">" . _SOMWARNINGDELETECAT . " <i>{$catname}</i> ?<br><br>"; echo "[ <a href=\"admin.php?op=sommaire\">" . _SOMNO . "</a> | <a href=\"admin.php?op=sommaire&go=deletecat&deletecat={$deletecat}&confirm=YES\">" . _SOMYES . "</a> ]" . "</div>"; CloseTable(); include "footer.php"; } else { $confirm = "NO"; $db->sql_query("DELETE FROM " . $prefix . "_sommaire WHERE groupmenu='{$deletecat}'"); $db->sql_query("DELETE FROM " . $prefix . "_sommaire_categories WHERE groupmenu='{$deletecat}'"); echo MySql_error(); index(); } }
function show_list() { /* *各个年级记录人数的标记 */ $c4 = 0; $c5 = 0; $c6 = 0; $c7 = 0; $conn = mysql_connect("208.97.186.208", "xiyoulinux", "xiyoulinux.cn") or die("connect err:" . MySql_error()); //$conn = mysql_connect("localhost","root","root") or // die("connect err:".MySql_error()); // $conn = mysql_connect($hostip,$user,$passwd)or die("connect err:".MySql_error()); if ($conn) { mysql_select_db("xiyoulinux_org"); //此处需要修改数据库名称 // mysql_select_db("xiyoulinux"); //此处需要修改数据库名称 $sql = "select xy_member.member_blog,xy_member.member_rss_url,xy_category.category_name from xy_category,xy_member where xy_member.member_category_ID=xy_category.category_ID and xy_member.member_rss_url!=''"; $result = mysql_query($sql, $conn); while ($row = mysql_fetch_array($result)) { //echo $row[0]; //echo $row[1]; //echo $row[2]; if ($row[2] == 07) { $category7title[$c7] = $row[0]; $category7link[$c7] = $row[1]; $c7++; } else { if ($row[2] == 06) { $category6title[$c6] = $row[0]; $category6link[$c6] = $row[1]; $c6++; } else { if ($row[2] == 05) { $category5title[$c5] = $row[0]; $category5link[$c5] = $row[1]; $c5++; } else { if ($row[2] <= 04) { $category4title[$c4] = $row[0]; $category4link[$c4] = $row[1]; $c4++; } } } } } } else { echo "数据库链接失败!"; } mysql_close($conn); /* *数据查询结束,开始数据显示 */ echo "<ul id=\"nav\">"; echo "<li class=\"current\" >"; echo "<a href=\"#\" class=\"list_title\"><img src=\"images/sub_list_03.gif\"><div class=\"text_seclect\">07级成员博客</div></a>"; echo "<div class=\"hide_menu\"><ul>"; for ($i = 0; $i < $c7; $i++) { echo "<li><a href='?feed_url=" . $category7link[$i] . "' title='" . $category7title[$i] . "' onmouseover='hover1(this.style)' onmouseout='hout1(this.style)'>"; echo "<strong>" . $category7title[$i] . "</strong><img src=\"images/sub_list_04.gif\"></a></li>"; } echo "</ul></div></li>"; echo "<li class=\"current\">"; echo "<a href=\"#\" class=\"list_title\"><img src=\"images/sub_list_03.gif\"><div class=\"text_seclect\">06级成员博客</div></a>"; echo "<div class=\"hide_menu\"><ul>"; for ($i = 0; $i < $c6; $i++) { echo "<li><a title='" . $category6title[$i] . "' href='?feed_url=" . $category6link[$i] . "' onmouseover='hover1(this.style)' onmouseout='hout1(this.style)'>"; echo "<strong>" . $category6title[$i] . "</strong></a></li>"; } echo "</ul></div></li>"; echo "<li class=\"current\">"; echo "<a href=\"#\" class=\"list_title\"><img src=\"images/sub_list_03.gif\"><div class=\"text_seclect\">05级成员博客</div></a>"; echo "<div class=\"hide_menu\"><ul>"; for ($i = 0; $i < $c5; $i++) { echo "<li><a title='" . $category5title[$i] . "' href='?feed_url=" . $category5link[$i] . "' onmouseover='hover1(this.style)' onmouseout='hout1(this.style)'>"; echo "<strong>" . $category5title[$i] . "</strong></a></li>"; } echo "</ul></div></li>"; echo "<li class=\"current\">"; echo "<a href=\"#\" class=\"list_title\"><img src=\"images/sub_list_03.gif\"><div class=\"text_seclect\">04级成员博客</div></a>"; echo "<div class=\"hide_menu\"><ul>"; for ($i = 0; $i < $c4; $i++) { echo "<li><a title='" . $category4title[$i] . "' href='?feed_url=" . $category4link[$i] . "' onmouseover='hover1(this.style)' onmouseout='hout1(this.style)'>"; echo "<strong>" . $category4title[$i] . "</strong></a></li>"; } echo "</ul></div></li>"; echo "</ul>"; }