johnake |
29th June 2008 12:55 |
[Netvision 2.0] Category Manager
I noticed that in the netvision 2.0 source, there is no category manager. So I picked up my category management file from tbdev and adapted for this source. So let's begin.
1.Create a new file called editcats.php
2.Paste this code into this file:
PHP Code:
<?php
/*Tracker categories management Original source from: TBDEV.NET Adapted for NV Tracker 2.0 */
ob_start(); require_once("include/bittorrent.php"); dbconn(false); loggedinorreturn(); if (get_user_class() < UC_ADMINISTRATOR) { die("Access denied."); } mysql_connect($mysql_host,$mysql_user,$mysql_pass); mysql_select_db($mysql_db); stdhead("Categories"); begin_frame("<font size=2 align=center>Manage Tracker Categories</font><tr></tr>", false, "100%"); print("</br>"); print("<table align=center width=70% border=0 cellspacing=0 cellpadding=2><tr><td align=center>\n");
///////////////////// D E L E T E C A T E G O R Y \\\\\\\\\\\\\\\\\\\\\\\\\\\\
$sure = $_GET['sure']; if($sure == "yes") { $delid = $_GET['delid']; $query = "DELETE FROM categories WHERE id=" .sqlesc($delid) . " LIMIT 1"; $sql = mysql_query($query); echo("Category succesfully deleted! [ Back ]"); end_frame(); stdfoot(); die(); } $delid = $_GET['delid']; $name = $_GET['cat']; if($delid > 0) { echo("Are you sure you would like to delete this category? ($name) ( Y / N )"); end_frame(); stdfoot(); die();
}
///////////////////// E D I T A C A T E G O R Y \\\\\\\\\\\\\\\\\\\\\\\\\\\\
$edited = $_GET['edited']; if($edited == 1) { $id = $_GET['id']; $cat_name = $_GET['cat_name']; $cat_img = $_GET['cat_img']; $query = "UPDATE categories SET name = '$cat_name', image = '$cat_img' WHERE id=".sqlesc($id); $sql = mysql_query($query); if($sql) { echo("<table class=main align=center cellspacing=0 cellpadding=5 width=50%>"); echo("<tr><td><div align='center'>Well done! Your category has been edited succesfully! [ Back ]</div></tr>"); echo("</table>"); end_frame(); stdfoot(); die(); } }
$editid = $_GET['editid']; $name = $_GET['name']; $img = $_GET['img']; if($editid > 0) { echo("<form name='form1' method='get' action='" . $_SERVER['PHP_SELF'] . "'>"); echo("<table class=main cellspacing=0 align=center cellpadding=5 width=50%>"); echo("<div align='center'><input type='hidden' name='edited' value='1'>Now editing category "$name"</div>"); echo(" "); echo("<input type='hidden' name='id' value='$editid'<table class=main cellspacing=0 cellpadding=5 width=50%>"); echo("<tr><td>Category Name: </td><td align='right'><input type='text' size=50 name='cat_name' value='$name'></td></tr>"); echo("<tr><td>Category Image Name: </td><td align='right'><input type='text' size=50 name='cat_img' value='$img'></td></tr>"); echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>"); echo("</table></form>"); end_frame(); stdfoot(); die(); }
///////////////////// A D D A N E W C A T E G O R Y \\\\\\\\\\\\\\\\\\\\\\\\\\\\
$add = $_GET['add']; if($add == 'true') { $cat_name = $_GET['cat_name']; $cat_img = $_GET['cat_img']; $query = "INSERT INTO categories SET name = '$cat_name', image = '$cat_img'"; $sql = mysql_query($query); if($sql) { $success = TRUE; } else { $success = FALSE; } } begin_table(TRUE); print("Add A New Category!"); print(" "); print(" "); echo("<form name='form1' method='get' action='" . $_SERVER['PHP_SELF'] . "'>"); echo("<tr><td>Category Name: </td><td align='right'><input type='text' size=50 name='cat_name'></td></tr>"); echo("<tr><td>Category Image Name: </td><td align='right'><input type='text' size=50 name='cat_img'><input type='hidden' name='add' value='true'></td></tr>"); echo("<tr><td></td><td><div align='right'><input type='Submit'></div></td></tr>"); echo("</table>"); if($success == TRUE) { print("Success!"); } echo(" "); echo("</form>");
///////////////////// E X I S T I N G C A T E G O R I E S \\\\\\\\\\\\\\\\\\\\\\\\\\\\
print("Existing Categories:"); print(" "); print(" "); begin_table(TRUE); echo("<td class=tablecat>ID:</td><td class=tablecat>Name:</td><td class=tablecat >Picture:</td><td class=tablecat>Browse Category:</td><td class=tablecat >Edit:</td><td class=tablecat>Delete:</td>"); $query = "SELECT * FROM categories WHERE 1=1"; $sql = mysql_query($query); while ($row = mysql_fetch_array($sql)) { $id = $row['id']; $name = $row['name']; $img = $row['image']; echo("<tr><td class=tablea><div align='center'>$id</div> </td> <td class=tableb>$name</td> <td class=tablea><div align='center'>[img]$DEFAULTBASEURL/pic/$img[/img]<div></td><td class=tableb><div align='center'>[img]$DEFAULTBASEURL/pic/viewnfo.gif[/img]</div></td> <td class=tablea><div align='center'>[img]$DEFAULTBASEURL/pic/multipage.gif[/img]</div></td> <td class=tableb><div align='center'>[img]$DEFAULTBASEURL/pic/warned2.gif[/img]</div></td></tr>"); }
end_frame(); end_frame(); stdfoot();
?>
After that, the only thing you need to do is to add this file in the staffpanel.
|