Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
inc	[ DIR ]	drwxr-sr-x	2008-01-09 07:51
.htaccess	394 B	-rw-r--r--	2017-10-25 14:17
.htpasswd	41 B	-rw-r--r--	2008-01-16 06:26
ADMarkComplete.php4	551 B	-rw-r--r--	2008-01-09 09:25
ADaddDone.php4	3.92 KB	-rw-r--r--	2008-01-09 09:20
ADdeleteDone.php4	3.65 KB	-rw-r--r--	2008-01-09 09:20
ADdisplayContacts.php4	23.05 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayContactsTable.php4	2.75 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayDone.php4	2.27 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayHelp.php4	1.31 KB	-rw-r--r--	2008-01-09 09:16
ADdisplayMemberFirm.php4	45.72 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayOfficeContactsTable.php4	3.47 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayOffices.php4	25.54 KB	-rw-r--r--	2008-01-16 08:04
ADdisplayTest.php4	1.21 KB	-rw-r--r--	2008-01-09 09:25
ADdisplayrecords.php4	3.28 KB	-rw-r--r--	2008-01-09 09:25
ADdisplaytblMemberFirmOffices.php4	3.62 KB	-rw-r--r--	2008-01-09 09:25
ADdisplaytblMemberFirms.php4	3.79 KB	-rw-r--r--	2008-01-09 09:25
ADeditDone.php4	3.75 KB	-rw-r--r--	2008-01-09 09:20
ADfixDisplayTable.php4	15.31 KB	-rw-r--r--	2008-01-09 09:25
ShadeTable.js	535 B	-rw-r--r--	2008-01-09 09:16
accept.jpg	638 B	-rw-r--r--	2008-01-09 09:16
addAdvisory-listing.php4	4.08 KB	-rw-r--r--	2008-01-09 09:20
addLinks.php4	4.09 KB	-rw-r--r--	2008-01-09 09:20
addNLCC.php4	9.48 KB	-rw-r--r--	2008-01-09 09:20
addPress.php4	3.53 KB	-rw-r--r--	2008-01-09 09:20
admin_b.php	557 B	-rw-r--r--	2009-05-15 13:23
admin_b.phtml	557 B	-rw-r--r--	2008-01-09 09:16
annualdec.php4	966 B	-rw-r--r--	2008-01-09 09:16
changedivision.php4	2.65 KB	-rw-r--r--	2008-01-09 09:16
db_import.php	91 B	-rw-r--r--	2009-05-15 13:23
db_import.phtml	91 B	-rw-r--r--	2008-01-09 09:16
decline.jpg	723 B	-rw-r--r--	2008-01-09 09:16
deleteAdvisory-listing.php4	4.23 KB	-rw-r--r--	2008-01-09 09:20
deleteLinks.php4	4.21 KB	-rw-r--r--	2008-01-09 09:20
documents.php	1.11 KB	-rw-r--r--	2009-05-15 13:23
documents.phtml	1.11 KB	-rw-r--r--	2008-01-09 09:20
editAdvisory-listing.php4	4.89 KB	-rw-r--r--	2008-01-09 09:20
editLinks.php4	4.71 KB	-rw-r--r--	2008-01-09 09:20
graph.php	1.83 KB	-rw-r--r--	2009-05-15 13:23
graph.phtml	1.83 KB	-rw-r--r--	2008-01-09 09:20
ht.acl	167 B	-rw-r--r--	2008-01-09 09:16
index.php4	4.78 KB	-rw-r--r--	2010-01-19 13:04
linkscript	31 B	-rw-r--r--	2008-01-09 09:16
manageAdvisory-listing.php4	2.78 KB	-rw-r--r--	2008-01-09 09:20
manageAdvisory.php4	1.21 KB	-rw-r--r--	2008-01-09 09:16
manageLinks.php4	1.17 KB	-rw-r--r--	2008-01-09 09:16
manageLinksListing.php4	2.62 KB	-rw-r--r--	2008-01-09 09:20
membersearch.php	15.46 KB	-rw-r--r--	2009-05-15 13:23
membersearch.phtml	15.45 KB	-rw-r--r--	2009-03-02 09:59
next.jpg	491 B	-rw-r--r--	2008-01-09 09:16
notice.phtml	5.33 KB	-rw-r--r--	2008-01-09 09:20
null.php	1.39 KB	-rw-r--r--	2009-05-15 13:23
null.phtml	1.39 KB	-rw-r--r--	2008-01-09 09:20
previous.jpg	562 B	-rw-r--r--	2008-01-09 09:16
register.php	4.75 KB	-rw-r--r--	2009-05-25 13:52
register.phtml	4.75 KB	-rw-r--r--	2009-03-02 09:59
resetpw.php	2.31 KB	-rw-r--r--	2009-05-15 13:23
resetpw.phtml	2.3 KB	-rw-r--r--	2009-03-02 09:59
serverstats.php	59 B	-rw-r--r--	2009-05-15 13:23
serverstats.phtml	59 B	-rw-r--r--	2008-01-09 09:16
siteinfo.php	1.88 KB	-rw-r--r--	2009-05-15 13:23
siteinfo.phtml	1.88 KB	-rw-r--r--	2008-01-09 09:20
top20users.php	1.42 KB	-rw-r--r--	2009-05-15 13:23
top20users.phtml	1.42 KB	-rw-r--r--	2008-01-09 09:20
unregister.php	960 B	-rw-r--r--	2009-05-25 13:53
unregister.phtml	955 B	-rw-r--r--	2009-03-02 09:59
upload.htm	668 B	-rw-r--r--	2008-01-09 09:16
upload.php4	780 B	-rw-r--r--	2008-01-09 09:16
upload2.php4	583 B	-rw-r--r--	2008-01-09 09:16
username.php	2.06 KB	-rw-r--r--	2009-05-15 13:23
username.phtml	2.06 KB	-rw-r--r--	2009-03-02 09:59

Rename

<html>
<head>
<title>
Memberzone Noticeboard
</title>
</head>
<body>
<h3>Memberzone Noticeboard Admin Section</h3>
<p>Please see <A href="#tips">below</a> for help and tips</p>
<?php
include('../inc/conf.inc');

//opening database connection
$connection = mysql_connect($server, $user, $pass);

mysql_select_db($db,$connection);

//this part handles the execution of the buttons
switch($action) {
	case add :
			echo "<form method=\"post\" action=\"$PHP_SELF\">\n";
			echo "<input type=\"hidden\" name=\"action\" value=\"todb\">\n";
			echo "Topic:<textarea name=\"topic\" cols=\"40\" rows=\"3\"></textarea>\n<br>\n";
			echo "<input type=\"submit\" value=\"add notice\">\n";
			echo "</form>\n";
			break;
	case activate :
			$sql = "UPDATE noticeboard SET active = 'y' WHERE id = $recordid";
			$result = mysql_query($sql) or die ('Could not activate record');
			echo "<p><b>Update successfull</b></p>";
			break;
	case deactivate :
			$sql = "UPDATE noticeboard SET active = 'n' WHERE id = $recordid";
			$result = mysql_query($sql) or die ('Could not deactivate record');
			echo "<p><b>Update successfull</b></p>";
			break;
	case delete :
			$sql = "DELETE FROM noticeboard WHERE id = $recordid";
			$result = mysql_query($sql) or die ('Could not delete record');
			echo "<p><b>Delete successfull</b></p>";
			break;
	case todb :
			$zadate = gmdate ("Y-m-d H:i:s", time()+7200);
			$topic=addslashes($topic);
			$sql = "INSERT INTO noticeboard (date, topic, active) VALUES ('$zadate', '$topic', 'y')";
			$result = mysql_query($sql) or die ('Could not insert data');
			echo "<p><b>New Notice inserted into the database.</b></p>";
			break;
	default :

break;
} //end switch
//this part shows the notices in the database
if ($show != 'n') {
	echo "<p>";
	$sql="SELECT * FROM noticeboard ORDER BY date DESC";
	$result=mysql_query($sql);
	$result_rows=mysql_num_rows($result);
	if ($result_rows > 0) {
		echo "<table width=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"1\">\n<tr><td valign=\"top\">Date added:</td><td valign=\"top\">Topic</td><td valign=\"top\" width=\"170\">Activate/Deactivate notice</td><td valign=\"top\" width=\"100\">Delete Notice</td>";
		while($row=mysql_fetch_array($result)) {
			$id = $row["id"];
			$date = $row["date"];
			$topic = $row["topic"];
			$active = $row["active"];
			$userid = $row["userid"];
			echo "<tr>\n";
			echo "<td valign=\"top\">$date</td>\n";
			echo "<td valign=\"top\">".stripslashes($topic)."</td>\n";
			switch($active) {
				case y :
					echo "<td valign=\"top\" align=\"center\">\n";
					echo "<form method=\"post\" action=\"$PHP_SELF\">\n";
					echo "<input type=\"hidden\" name=\"action\" value=\"deactivate\">\n";
					echo "<input type=\"hidden\" name=\"recordid\" value=\"$id\">\n";
					echo "<input type=\"submit\" value=\"deactivate\">\n";
					echo "</form>\n";
					echo "</td>\n";
					break;
				case n :
					echo "<td valign=\"top\" align=\"center\">\n";
					echo "<form method=\"post\" action=\"$PHP_SELF\">\n";
					echo "<input type=\"hidden\" name=\"action\" value=\"activate\">\n";
					echo "<input type=\"hidden\" name=\"recordid\" value=\"$id\">\n";
					echo "<input type=\"submit\" value=\"  activate   \">\n";
					echo "</form>\n";
					echo "</td>\n";
					break;
				default :
					echo "<td>&nbsp;</td>";
					break;
			} //end switch
			echo "<td valign=\"top\" align=\"center\">\n";
			echo "<form method=\"post\" action=\"$PHP_SELF\">\n";
			echo "<input type=\"hidden\" name=\"action\" value=\"delete\">\n";
			echo "<input type=\"hidden\" name=\"recordid\" value=\"$id\">\n";
			echo "<input type=\"submit\" value=\"delete\">\n";
			echo "</form>\n";
			echo "</td>\n";
			echo "</tr>\n";
		} //end while
		echo "</table>\n";
	} else {
		echo "<p>No notices in the database</p>";
	} //end if else
	echo "<form method=\"post\" action=\"$PHP_SELF\">\n";
	echo "<input type=\"hidden\" name=\"action\" value=\"add\">\n";
	echo "<input type=\"hidden\" name=\"show\" value=\"n\">\n";
	echo "<input type=\"submit\" value=\"add new notice\">\n";
	echo "</form>\n";
	echo "</p>";
} //end if
//closing database connection
mysql_close($connection);
?>
<a name="tips">
<p>
The Noticeboard is a bulleted list on the memberzone homepage.<br>
It is used to bring important information under the attention of the members.<br>
</p>
<p>
To <b>add</b> a new notice:
<ul>
<li>Click on 'add new notice'.
<li>Enter the desired notice in the topic field.
<li> Click 'add notice'.
</ul>
</p>
<p>
To <b>deactivate</b> a notice so that it does <b>not</b> show on the memberzone homepage:
<ul>
<li>Click on 'deactivate' next to a active notice topic.
<li><b>Note:</b> This will keep the notice in the database. It can then be acticated at a later stage to be shown on the homepage.
</ul>
</p>
<p>
To <b>activate</b> an inactive notice so that is displays on the memberzone homepage:
<ul>
<li>Click on 'activate' next to the inactive notice topic.
</ul>
</p>
<p>
To delete a notice:
<ul>
<li>Click on 'delete' in the last column to <b>permanently</b> delete the notice from the database.
<li>Please note that this action cannot be undone, and is permanent.
<li>Useful for if you made a spelling mistake and want to recreate the notice with the correct topic.
</ul>
</p>
<p>
Please note that an edit function is not included, since deleting and recreating a notice is so easy.
</p>
<?php
echo "<a href=\"/members/saaceadmin/\">Back to SAACE Admin</a>";
?>
</body>
</html>