[ Link Admin Home | Add a Category | Add a Link | Logout | Install Hosting Index ]

"; if($ax=="install") { if($type=="un") { $result=MySQLQuery("DROP TABLE 'links_cat'",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The links category database table was dropped

";} else {echo "

Error dropping the links category database table

";} $result=MySQLQuery("DROP TABLE 'links'",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The links database table was dropped

";} else {echo "

Error dropping the links database table

";} } else if($type=="full") { $result=MySQLQuery("DROP TABLE IF EXISTS links_cat;",$QueryError_Email,$QueryError_Browser); $result=MySQLQuery("CREATE TABLE links_cat(id int(10) auto_increment primary key not null,sub_cat int(10),name varchar(24),dsc varchar(255));",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The links category database table was created

";} else {echo "

Error creating the links category database table

";} $result=MySQLQuery("DROP TABLE IF EXISTS links;",$QueryError_Email,$QueryError_Browser); $result=MySQLQuery("CREATE TABLE links(id int(10) auto_increment primary key not null,cat_id int(10),name varchar(100),url varchar(100),dsc varchar(255),approved varchar(3),email varchar(50),password varchar(10),clicks int(10),date_added date,image varchar(100),rating int(255),rates int(255));",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The links database table was created

";} else {echo "

Error creating the links database table

";} $result=MySQLQuery("DROP TABLE IF EXISTS dd_banners;",$QueryError_Email,$QueryError_Browser); $result=MySQLQuery("CREATE TABLE dd_banners (BannerID int(10) NOT NULL auto_increment, BannerFile varchar(255) NOT NULL default '', BannerURL varchar(255) NOT NULL default '', AltText varchar(255) NOT NULL default '', BannerType varchar(50) NOT NULL default '',PRIMARY KEY (BannerID));",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The banners database table was created

";} else {echo "

Error creating the banner database table

";} $result=MySQLQuery("DROP TABLE IF EXISTS dd_newsletter;",$QueryError_Email,$QueryError_Browser); $result=MySQLQuery("CREATE TABLE dd_newsletter (nemail varchar(150) NOT NULL default '',PRIMARY KEY (nemail));",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The newsletter database table was created

";} else {echo "

Error creating the newsletter database table

";} $result=MySQLQuery("DROP TABLE IF EXISTS dd_links;",$QueryError_Email,$QueryError_Browser); $result=MySQLQuery("CREATE TABLE dd_links (LinkID int(10) NOT NULL auto_increment,LinkName varchar(255) NOT NULL default '',LinkURL varchar(255) NOT NULL default '',PRIMARY KEY (LinkID));",$QueryError_Email,$QueryError_Browser); if ($result) {echo "

The sponsor links database table was created

";} else {echo "

Error creating the sponsor links database table

";} } else { echo "

"; echo "

Click to install

WARNING INSTALLATION WILL REMOVE ALL PREVIOUS DATA IF YOU HAVE ALREADY INSTALLED THIS WEBSITE

"; } } else if($ax=="logout") { setcookie("admin_log"); header("Location: ".$PHP_SELF); } ////////////////////// // Category Management ////////////////////// else if($ax=="updatecat") { $id=$_GET["id"]; $sub_cat=$_POST["sub_cat"]; $name=$_POST["name"]; $dsc=$_POST["dsc"]; $result=MySQLQuery("update links_cat set sub_cat='$sub_cat',name='$name', dsc='$dsc' where id=$id",$QueryError_Email,$QueryError_Browser); if ($result) { echo "

The Link Category Was Updated

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Updating Link Category

";} } else if($ax=="insertcat") { $sub_cat=$_POST["sub_cat"]; $name=$_POST["name"]; $dsc=$_POST["dsc"]; $result=MySQLQuery("insert into links_cat (sub_cat,name,dsc) values ('$sub_cat','$name','$dsc')",$QueryError_Email,$QueryError_Browser); if ($result) { echo "

The Link Category Was Added

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Adding Link Category

";} } else if($ax=="deletecat") { $id=$_GET["id"]; $v=$_GET["v"]; if($v=="yes") { $result=MySQLQuery("delete from links_cat where id=$id",$QueryError_Email,$QueryError_Browser); if ($result) { echo "

The Link Category Was Deleted

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Deleting Link Category

";} } else { echo "

Are you Sure?

If you are sure you want to delete this category, click here.

"; } } else if($ax=="editcat" || $ax=="addcat") { if($ax=="editcat") { $id=$_GET["id"]; $result=MySQLQuery("select * from links_cat where id=$id",$QueryError_Email,$QueryError_Browser); while($row=mysql_fetch_array($result)) { $id=$row["id"]; $sub_cat=$row["sub_cat"]; $name=$row["name"]; $dsc=$row["dsc"]; } $form_title="Edit a Link Category"; $form_action="?ax=updatecat&id=$id"; } else if($ax=="addcat") { $name=""; $dsc=""; $form_title="Add a Link Category"; $form_action="?ax=insertcat"; } ?>

The Link Was Updated

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Updating Link

";} } else if($ax=="insert") { $cat_id=$_POST["cat_id"]; $name=$_POST["name"]; $dsc=$_POST["dsc"]; $url=$_POST["url"]; $approval=$_POST["approval"]; $email=$_POST["email"]; $password=$_POST["password"]; $clicks="0"; $date_added=$_POST["date_added"]; $image=$_POST["image"]; $rating="0"; $rates="0"; $result=MySQLQuery("insert into links (cat_id,name,dsc,url,approved,email,password,date_added,image,rating,rates) values ('$cat_id','$name','$dsc','$url','$approval','$email','$password','$date_added','$image','$rating','$rates')",$QueryError_Email,$QueryError_Browser); if ($result) { echo "

The Link Was Added

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Adding Link

";} } else if($ax=="delete") { $id=$_GET["id"]; $v=$_GET["v"]; if($v=="yes") { $result=MySQLQuery("delete from links where id=$id",$QueryError_Email,$QueryError_Browser); if ($result) { echo "

The Link Was Deleted

"; ob_end_clean(); header("Location: ".$PHP_SELF); } else {echo "

Error Deleting Link

";} } else { echo "

Are you Sure?

If you are sure you want to delete this listing, click here.

"; } } else if($ax=="view") { $id=$_GET["id"]; $v=$_GET["v"]; $result = MySQLQuery("SELECT * FROM links WHERE id=$id", $QueryError_Email, $QueryError_Browser); while($row = mysql_fetch_array($result)) {echo "

".$row["name"]."
".$row["dsc"]."
".$row["email"]."

";} } else if($ax=="edit" || $ax=="add") { if($ax=="edit") { $id=$_GET["id"]; $result=MySQLQuery("select * from links where id=$id",$QueryError_Email,$QueryError_Browser); while($row=mysql_fetch_array($result)) { $id=$row["id"]; $cat_id=$row["cat_id"]; $name=$row["name"]; $dsc=$row["dsc"]; $url=$row["url"]; $approved=$row["approved"]; $email=$row["email"]; $password=$row["password"]; $clicks=$row["clicks"]; $date_added=$row["date_added"]; $image=$row["image"]; $rating=$row["rating"]; $rates=$row["rates"]; } $form_title="Edit a Link"; $form_action="$PHP_SELF?ax=update&id=$id"; } else if($ax=="add") { $name=""; $dsc=""; $url=""; $approved="yes"; $email=""; $password=""; $date_added=""; $image=""; $date_added=date($date_format); $date_added=date($date_format); $date_added=date($date_format); $form_title="Add a Link"; $form_action="$PHP_SELF?ax=insert"; } ?>

Link Management

"; $cat_id=$_GET["cat_id"]; $topic_result = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE id=$cat_id", $QueryError_Email,$QueryError_Browser); while($topic_row = mysql_fetch_array($topic_result)) { $topic_id=$topic_row["id"]; $topic_sub=$topic_row["sub_cat"]; $topic_name=$topic_row["name"]; if($topic_sub != 0) { $topic_result2 = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE id=$topic_sub", $QueryError_Email,$QueryError_Browser); while($topic_row2 = mysql_fetch_array($topic_result2)) { $topic_name2=$topic_row2["name"]; } $topic_text=$topic_name2." > ".$topic_name; } else { $topic_text=$topic_name; } } $result = MySQLQuery("SELECT * FROM links WHERE cat_id=$cat_id AND approved='yes' ORDER BY id DESC", $QueryError_Email, $QueryError_Browser); echo "\n \n \n \n"; if(mysql_num_rows($result)) { while($row = mysql_fetch_array($result)) { $count=$count+1; if($count%2){$bgclass="primary";}else{$bgclass="secondary";} echo ""; } } else { echo ""; } echo "\n \n \n

Links listed in \"$topic_text\"
View	Edit	Delete	".$row["name"]."
No links assigned to this category.

\n"; } ////////////////// // Front Page View ////////////////// else { echo "

Category Management

To work with individual links, click 'View Links' next to the name of the category that the link is located in. In order to make the \"Delete\" links active you will have to re-categorize any links in that category. If your delete button is not active, it has some child records of some sort.

"; $result = MySQLQuery("SELECT id,sub_cat,name FROM links_cat WHERE sub_cat='0' ORDER BY name DESC", $QueryError_Email, $QueryError_Browser); echo "\n \n \n \n"; if(mysql_num_rows($result)) { while($row = mysql_fetch_array($result)) { $id=$row["id"]; $sub_cat=$row["sub_cat"]; $name=$row["name"]; $delete="yes"; $delete_check = MySQLQuery("SELECT * FROM links_cat WHERE sub_cat=$id", $QueryError_Email, $QueryError_Browser); if(mysql_num_rows($delete_check)){$delete="no";} $delete_check = MySQLQuery("SELECT * FROM links WHERE cat_id=$id AND approved='yes'", $QueryError_Email, $QueryError_Browser); if(mysql_num_rows($delete_check)){$delete="no";} if($delete=="no"){$delete="";}else{$delete="Delete";} echo "\n \n \n \n \n \n"; $sub_result = MySQLQuery("SELECT * FROM links_cat WHERE sub_cat='".$row["id"]."' ORDER BY id DESC", $QueryError_Email, $QueryError_Browser); if(mysql_num_rows($sub_result)) { while($sub_row = mysql_fetch_array($sub_result)) { $sub_id=$sub_row["id"]; $sub_sub_cat=$sub_row["sub_cat"]; $sub_name=$sub_row["name"]; $delete_check = MySQLQuery("SELECT * FROM links WHERE cat_id='$sub_id' AND approved='yes' ORDER BY name DESC", $QueryError_Email, $QueryError_Browser); if(mysql_num_rows($delete_check)){$delete="no";} if($delete=="no"){$delete="";}else{$delete="Delete";} echo "\n \n \n \n \n \n"; } } } } else { echo ""; } echo "\n \n \n

Link Catagories
View Links	Edit	$delete	$name
View Links	Edit	$delete	$sub_name
No Categories currently listed.

\n
\n"; if($admin_approved=="no") { $result = MySQLQuery("SELECT * FROM links WHERE approved<>'yes' ORDER BY id DESC",$QueryError_Email,$QueryError_Browser); echo "\n \n \n \n"; if(mysql_num_rows($result)) { while($row = mysql_fetch_array($result)) { $count=$count+1; if($count%2){$bgclass="primary";}else{$bgclass="secondary";} echo ""; } } else { echo ""; } echo "\n \n \n

Links Waiting For Approval
View	Edit	Delete	".$row["name"]."
No records are needing approval.

\n"; } } } else if($_GET["login"]=="true") { if($pw==$admin_password) { setcookie("admin_log","in"); header("Location: ".$PHP_SELF); } else { echo "

Error

Your have entered the wrong password.

"; } } else { echo "

"; echo ""; ?>