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.