Hey people,
Well yeah, I've been looking through different modifications, some with instructions in, some with none, mainly study on PHP.net but I thought here's a re first. Now I tried my best and make it look similar to some good modification(Skill of programming), but meh your thoughts. I'm not really good of thinking of Ideas so I just re-coded this. I don't know if it works, I haven't tested it, but if any ERRORS please post them up.
<?php
require_once(dirname(__FILE__).'/globals.php');
$_GET['delall2'] = isset($_GET['delall2']) ? abs(intval($_GET['delall2']) : FALSE;
if(isset(is_numeric($_GET['delete'])) {
$db->query("DELETE FROM `events` WHERE `evID` = ".$_GET['delete']." AND `evUSER` = ".$_SESSION['userid']);
echo '[b]Event Deleted!</strog>[url="index.php"] Home[/url]'; }
else {
echo '[b]No valid ID![/b]'; }
if(isset($_GET['delall'])) { ?>
All your events will be deleted. Are you sure you want to delete all your events?
[url='events.php?delall2=1'][b]I'm not just positive, I'm HIV positive[/b][/url] - [url='events.php'][b]No no, I stay.[/b][/url]
<? exit; }
if($_GET['delall2'])) {
$db->query("DELETE FROM `events` WHERE `evUSER` = ".$_SESSION['userid']);
echo '[b]All events are deleted![/b]'; exit; }
else { echo '[b]You have no events![/b]'; exit; } ?>
[b]Latest 25 events[/b]
<hr>[url='events.php?delall=1']Delete all events![/url]<hr /> <?
$INFO_GET = $db->query("SELECT `evTIME`,`evID`,`evTEXT`,`evTIME`,`evREAD`,`evUSER` FROM `events WHERE `evUSER` = `".$_SESSION['userid'."` ORDER BY `evTIME` DESC LIMIT 25");
echo "<table width='75%' cellpadding='1' class='table'><tr><th>Time</th><th>Event</th><th>Links</th></tr>";
while($User = $db->fetch_row($INFO_GET)) {
echo "<tr><td>".date('F j Y, g:i:s a',$User['evTIME']);
if(!$User['evREAD']) {
echo '
[b]New![/b]'; }
echo "</td><td>".$User->evTEXT."</td><td>[url='events.php?delete=".$User[']Delete[/url]</td></tr>"; }
echo '</table>';
if($ir['new_events'] > 0) {
$db->query("UPDATE `events` SET `evREAD` = 1 WHERE `evUSER` = ".$_SESSION['userid']);
$db->query("UPDATE `users` SET `new_events` = 0 WHERE `userid` = ".$_SESSION['userid']); }
$h->endpage(); ?>