function getProfilebyname($username) { $user_id = getAccountid($username); $sql = "SELECT * FROM user_details WHERE user_id = :user_id AND isdeleted = 0"; $params = array(':user_id' => $user_id); $result = DatabaseHandler::GetAll($sql, $params); return $result; }
<?php $user = $_SESSION['user']; $userid = getAccountid($user); $regval = ""; $registerscs = ""; $stuff = ""; $categorywise = ""; $eventdetails = array(); $categories = array(); $events = array(); $count = array(); if (isset($_GET['eventid'])) { $eventdetails = getEventbyid(addslashes(htmlentities($_GET['eventid']))); if ($eventdetails && count($eventdetails)) { $stuff = "<div class='box'>\n\t\t\t\t\t<div class='box-head'>\n\t\t\t\t\t\t<h2 class='left'> " . $eventdetails[0]['event_name'] . ": </h2>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'><br>\n\t\t\t\t\t\t<h3><b><u>About: </u></b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px; font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['about']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Rules:</u> </b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px;font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['rules']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Contest Link:</u></b> </h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px;font-size:14px; line-height:18px;'><a href='" . stripslashes($eventdetails[0]['clink']) . "' target='new'>" . stripslashes($eventdetails[0]['clink']) . "</a></p><br>\n\t\t\t\t\t</div>\n\t\t\t\t\t<div style='padding: 10px 10px 10px 20px;'>\n\t\t\t\t\t\t<h3><b><u>Contact Details:</u> </b></h3><br>\n\t\t\t\t\t\t<p style='padding-bottom: 5px; font-size:14px; line-height:18px;'>" . stripslashes($eventdetails[0]['contacts']) . "</p><br>\n\t\t\t\t\t</div>\n\t\t\t\t</div>\n\t\t\t\t"; } } if (isset($_POST['register'])) { $regval = addslashes(htmlentities($_POST['regval'])); if (!alreadyRegistered($userid, $regval)) { if (isProfileComplete($user)) { registerEvent($regval, $userid, $user); $registerscs = "<p style='color:#74a446; font-size:15px;' > You have successfully registered to the Event! </p>"; } else { $registerscs = "<p style='color:red; font-size:15px;' > First you need to complete your profile information to apply for Events.<p>"; } } else { $registerscs = "<p style='color:#74a446; font-size:15px;' > You are already registered to the Event! </p>"; } $eventdetails = getEventbyid($regval);
<?php $username = $_SESSION['user']; $userid = getAccountid($username); $eventlist = ""; $eventname = ""; $upcoming = ""; $ongoing = ""; $registered = ""; $events = array(); $categories = array(); $news = array(); $timezone = "Asia/Calcutta"; date_default_timezone_set($timezone); $eventlist = getRegisteredEvents($userid); for ($i = 0; $i < count($eventlist); $i++) { $eventname = getEventbyid($eventlist[$i]['event_id']); $registered .= "<tr>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>{$eventname[0]['event_name']}</p></td>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>" . format_date($eventname[0]['start']) . "</p></td>\n\t\t\t <td><p style='padding:3px; line-height:20px;'>" . format_date($eventname[0]['end']) . "</p></td>\n\t\t </tr>\n\t "; } $categories = getEventCategories(); $events = getAllEvents(); for ($i = 0; $i < count($categories); $i++) { $eventcat = $categories[$i]['id']; for ($j = 0; $j < count($events); $j++) { if ($eventcat == $events[$j]['event_category_id']) { if (strtotime($events[$j]['start']) <= time() && time() < strtotime($events[$j]['end'])) { $ongoing .= "<tr><td>{$events[$j]['event_name']}</td><td>" . ucFirst($categories[$i]['name']) . "</td><td>" . format_date($events[$j]['end']) . "</td></tr>"; } } } }