PHP Code:
<?php
require_once("mainfile.php");
$module_name = basename(dirname(__FILE__));
if(!$tid) $pagetitle = "- Tutorials";
elseif($tid) {
$sql = "SELECT pagename FROM nuke_tutorials WHERE tid='$tid'";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$pagetitle = "- Tutorials :: $row[pagename]";
}
include ("header.php");
OpenTable();
function show($tid) {
$sql = "SELECT * FROM nuke_tutorials WHERE tid='$tid'";
$result = mysql_query($sql);
while($row = mysql_fetch_array($result)){
echo "$row[content]<br>";
echo "<font class=gensmall><center>This Tutorial Has Been Viewed
<b>$row[counter]</b> Times</center></font>";
}
$updatecounter = "UPDATE nuke_tutorials SET counter=counter+1 where tid='$tid'";
mysql_query($updatecounter);
}
function index() {
echo "Welcome!";
echo "</td></tr>";
echo "<tr><td width=100% background=\"themes\SMblue\images\blue.gif\" class=orange>";
echo "Hi friends,<br>";
echo "I spent my last Week in Searching for Tutorials about how to Create Custom Modules in Php-Nuke and how to Make Them Searchable via Nukes Default Search Module..<br><br>";
echo "the help i recieved From Related sites was Null :P<br>";
echo "Now dont think that i am complaining, i know they are busy in Enhancing nuke, and they Also have their own Life,<br> so i gave them a rest and Tried to Search on Google For It..<br><br>";
echo "Quite Surprisingly i didnt find anything even related to this..<br>";
echo "But i did find Two other Cool Tutorials Which Were:<br>";
echo "<ol>";
echo "<li>How to add Data to Database</li>";
echo "<li>How to Show it on Browser</li>";
echo "</ol>";
echo "Then with some common sence and with some help of already created Php-Nuke modules i made my Own Modules :<br>";
echo "My Modules: <a href=\"Http://Thalassemia.Com.Pk/nuke/modules.php?name=Islam\" target=_blank>Islam</a> - <a href=\"Http://Thalassemia.Com.Pk/nuke/modules.php?name=Pakistan\" target=_blank>Pakistan</a> - <a href=\"Http://Thalassemia.Com.Pk/nuke/modules.php?name=thal\" target=_blank>Thalassemia</a><br><Br>";
echo "After that i also Added them in Search Module of PhpNuke<br><br>";
echo "Then i thought that i should Share the Experience with others, so that others dont have to Search whole night like me ;)<br><br>";
echo "Any wayz i hope you find them easy :)<br>";
echo "and i hope that you dont find any bugs :><br>";
echo "But if you do found any bugs please Email me at:<br>";
echo "<b>webmaster (at) thalassemia (dot) com (dot) pk</b>";
}
function add_tut() {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
OpenTable();
echo "<form action=\"modules.php?name=$module_name\" method=POST>";
echo "<input type=\"hidden\" name=\"op\" value=\"addtut\">";
echo "Tutorial Name: <input type=\"text\" name=\"pagename\"><br>";
echo "Content: <textarea name=\"content\" style=\"width: 150px\" rows=\"4\" cols=\"50\" class=\"post\"></textarea><br>";
echo "Counter: <input type=\"text\" name=\"counter\">";
echo "<input type=\"submit\" value=\"Submit\">";
echo "</form>";
CloseTable();
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function addtut($tid, $pagename, $content, $counter) {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
$sql = "INSERT INTO nuke_tutorials( pagename, content, tid, counter )
VALUES ('$pagename', '$content', '$tid', $counter)";
$result = mysql_query($sql);
OpenTable();
//Code to check if statement executed properly and display message
if ($result) {
echo("PageName, Content, Url and Counter successully added<br>Click <a href=\"javascript:history.back(1)\">here</a> for another Tutorial");
} else {
echo("An error has occured");
}
CloseTable();
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function mod_tut() {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
OpenTable();
echo "<form action=\"modules.php?name=$module_name\" method=POST>";
echo "<input type=\"hidden\" name=\"op\" value=\"modtut\">";
echo "Tutroial: <input type=\"text\" name=\"tid\"><br>";
echo "<input type=\"submit\" value=\"submit\">";
echo "</form>";
CloseTable();
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function modtut($tid, $pagename, $content, $counter) {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
// Select Relative Tutorial Data From Database
$sql = "SELECT * FROM nuke_tutorials where tid='$tid'";
$result = $db->sql_query($sql);
// If there is any Result
if ($db->sql_numrows($result) == 1) {
$row = $db->sql_fetchrow($result);}
// Show the Results
OpenTable();
echo "<form action=\"modules.php?name=$module_name\" method=Post>";
echo "<input type=\"hidden\" name=\"op\" value=\"modit\">";
echo "<input type=\"hidden\" name=\"tid\" value=\"$row[tid]\">";
echo "<table bgcolor=#000000 cellspacing=1 width=100% border=0><tr bgcolor=#ffffff>";
echo "<td>Tutorial Url:</td> <td><b>$row[tid]</b></td></tr>";
echo "<tr bgcolor=#ffffff><td>Tutorial Name:</td> <td><input type=\"text\" name=\"pagename\" value=\"$row[pagename]\"></td></tr>";
echo "<tr bgcolor=#ffffff><td>Content:</td> <tD><textarea name=\"content\" rows=\"10\" cols=\"80\" class=\"post\">$row[content]</textarea></td></tr>";
echo "<tr bgcolor=#ffffff><td>Counter:</td> <tD><input type=\"text\" name=\"counter\" value=\"$row[counter]\"></td></tr>";
echo "<tr bgcolor=#fcfcfc><td colspan=2 align=center><input type=\"submit\" value=\"Submit\"></td></tr></table>";
echo "</form>";
CloseTable();
// Close Sql Query
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function modit($tid, $pagename, $content, $counter) {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
$sql = "UPDATE nuke_tutorials SET pagename='$pagename', content='$content', counter='$counter' where tid='$tid'";
$result = mysql_query($sql);
//Code to check if statement executed properly and display message
if ($result) {
OpenTable();
echo("PageName, Content, and Counter OF $tid successully modified<br>Click <a href=\"javascript:history.back(2)\">here</a> for another Tutorial");
CloseTable();
} else {
OpenTable();
echo("An error has occured");
CloseTable();
}
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function del_tut() {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
OpenTable();
echo "<form action=\"modules.php?name=$module_name\" method=POST>";
echo "<input type=\"hidden\" name=\"op\" value=\"deltutconfirm\">";
echo "Tutorial: <input type=\"text\" name=\"tid\"><br>";
echo "<input type=\"submit\" value=\"submit\">";
echo "</form>";
CloseTable();
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function deltutconfirm($tid) {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
OpenTable();
echo "<script language=\"JavaScript\">
<!-- Begin
function DontDelete() {
window.open(\"index.php\",\"_self\");
}
// End -->
</script>";
echo "<form action=\"modules.php?name=$module_name\" method=POST>";
echo "<input type=\"hidden\" name=\"op\" value=\"deltut\">";
echo "<input type=\"hidden\" name=\"tid\" value=\"$tid\">";
echo "Are You Sure You Want To Delete This Tutorial: <b>$tid</b> ??";
echo "<input type=\"button\" value=\"No\" onClick=\"DontDelete()\"> <input type=\"submit\" value=\"Yes\">";
echo "</form>";
CloseTable();
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
function deltut($tid) {
global $prefix, $db, $sitename, $admin, $module_name;
if (is_admin($admin)) {
$sql = "DELETE from nuke_tutorials where tid='$tid'";
$result = mysql_query($sql);
//Code to check if statement executed properly and display message
if ($result) {
OpenTable();
echo("$tid successully Deleted");
CloseTable();
} else {
OpenTable();
echo("An error has occured");
CloseTable();
}
} else {
OpenTable();
echo "Access Denied";
CloseTable();
}
}
switch($op) {
case "show":
show($tid, $pagename, $content, $counter);
break;
case "mod_tut":
mod_tut();
break;
case "modtut":
modtut($tid, $pagename, $content, $counter);
break;
case "modit":
modit($tid, $pagename, $content, $counter);
break;
case "add_tut":
add_tut();
break;
case "addtut":
addtut($tid, $pagename, $content, $counter);
break;
case "del_tut":
del_tut();
break;
case "deltutconfirm":
deltutconfirm($tid);
break;
case "deltut":
deltut($tid);
break;
default:
index();
break;
}
CloseTable();
include ("footer.php");
?>
Can anybody just tell me that where and what should i add in this so that it can show tutorials from categories.. ?? 
please dont shout
Originally Posted by s001dxp
Posting Permissions
Bookmarks