query($sSQL); if ($objDb->getCount( ) != 1) { output("Error: Invalid Login info. Please provide correct Username & Password.", $bJsFlag); return; } $iUserId = $objDb->getField(0, 0); $sPremiumUser = $objDb->getField(0, 1); $sCopyrightType = $objDb->getField(0, 2); // getting user display settings $sSQL = "SELECT * FROM tblUserSettings WHERE UserId=$iUserId;"; $objDb->query($sSQL); if ($objDb->getCount( ) != 1) { output("Error: Unable to read the User Dislpay Settings.", $bJsFlag); return; } $sTimeZoneCode = stripslashes($objDb->getField(0, "TimeZoneCode")); $sEventCode = stripslashes($objDb->getField(0, "EventCode")); $sFontName = $objDb->getField(0, "FontName"); $iFontSize = $objDb->getField(0, "FontSize"); $sFontColor = $objDb->getField(0, "FontColor"); $sDateFormat = $objDb->getField(0, "DateFormat"); $sTimeFormat = $objDb->getField(0, "TimeFormat"); // getting time zone values if ($iTimeZoneId == 0) $iTimeZoneId = 32; $sSQL = "SELECT * FROM tblTimeZones WHERE ZoneId=$iTimeZoneId;"; $objDb->query($sSQL); if ($objDb->getCount( ) != 1) { output("Error: Unable to read the Time Zone Settings.", $bJsFlag); return; } $sZoneName = $objDb->getField(0, "ZoneName"); $iZoneTime = $objDb->getField(0, "ZoneTime"); // getting user events $sSQL = ("SELECT c.Category_Name, uc.*, e.* FROM tblCategories c, tblUserCategories uc, tblUserEvents e WHERE c.CategoryId=uc.CategoryId AND uc.UserId=$iUserId AND e.UserId=$iUserId AND e.CategoryId=c.CategoryId AND (e.Event_Date>'".gmdate('Y-m-d')."' OR (e.Event_Date='".gmdate('Y-m-d')."' AND e.Event_Time>='".gmdate('H:i:s')."'))"); if ($sCategories != "") $sSQL .= " AND c.CategoryId IN ($sCategories)"; $sSQL .= " ORDER BY e.Event_Date, e.Event_Time"; if ($iRecords > 0) $sSQL .= " LIMIT $iRecords"; $sSQL .= ";"; $objDb->query($sSQL); if ($objDb->getCount( ) == 0) { output("

Sorry there are no Freerolls available at the moment - We are working hard to arrange more so please check back later.

", $bJsFlag); return; } else { $iCount = $objDb->getCount( ); $iFieldsCount = $objDb->getFieldsCount( ); // setting time zone difference value if ($iCount > 0 && $sTimeZoneCode != "" && $bJsFlag == false) { $objTempDb = new Database( ); $sSQL = "SELECT * FROM tblTimeZones ORDER BY ZoneId;"; $objTempDb->query($sSQL); $iTempCount = $objTempDb->getCount( ); $sTimeZonesList = ""; for ($i = 0; $i < $iTempCount; $i ++) $sTimeZonesList .= (''); $sTimeZoneCode = @str_replace("{SELECTED_ZONE_NAME}", $sZoneName, $sTimeZoneCode); $sTimeZoneCode = @str_replace("{SELECTED_ZONE_ID}", $iTimeZoneId, $sTimeZoneCode); $sTimeZoneCode = @str_replace("{TIME_ZONE_LIST}", $sTimeZonesList, $sTimeZoneCode); $sTimeZoneCode = @str_replace("{RECORDS}", $iRecords, $sTimeZoneCode); $sTimeZoneCode = @str_replace("{CATEGORIES}", $sCategories, $sTimeZoneCode); output($sTimeZoneCode, $bJsFlag); } if ($iCount > 0) { $iTimeFieldIndex = -1; for ($i = 0; $i < $iFieldsCount; $i ++) { $sField = $objDb->getColumn($i); $sField = strtoupper($sField); $sType = $objDb->getType($i); if ($sType == "time" && $sField == "EVENT_TIME") { $iTimeFieldIndex = $i; break; } } } for ($i = 0; $i < $iCount; $i ++) { $sEvent = $sEventCode; for ($j = 0; $j < $iFieldsCount; $j ++) { $sField = $objDb->getColumn($j); $sField = strtoupper($sField); $sType = $objDb->getType($j); $sValue = $objDb->getField($i, $j); if ($sType == "date") { if($iTimeFieldIndex >= 0) { $sTime = $objDb->getField($i, $iTimeFieldIndex); $sDateTime = ($sValue." ".$sTime); $sValue = date($sDateFormat, (strtotime($sDateTime) + $iZoneTime)); } else $sValue = date($sDateFormat, (strtotime($sValue) + $iZoneTime)); } else if ($sType == "time") $sValue = date($sTimeFormat, (strtotime($sValue) + $iZoneTime)); $sEvent = @str_replace(("{".$sField."}"), $sValue, $sEvent); } output($sEvent, $bJsFlag); } } if ($sPremiumUser == "N") { // getting copyright notice code $sSQL = ("SELECT CopyrightCode".$sCopyrightType." FROM tblSettings;"); $objDb->query($sSQL); if ($objDb->getCount( ) != 1) { output("Error: Unable to read the Copyright HTML Code.", $bJsFlag); return; } $sCopyright = stripslashes($objDb->getField(0, 0)); $sCopyright = @str_replace("{FONT_NAME}", $sFontName, $sCopyright); $sCopyright = @str_replace("{FONT_SIZE}", $iFontSize, $sCopyright); $sCopyright = @str_replace("{FONT_COLOR}", $sFontColor, $sCopyright); output($sCopyright, $bJsFlag); } $objDb->close( ); } if ($_POST) { $sUserName = $_POST['UserName']; $sPassword = $_POST['Password']; $iTimeZoneId = (int)$_POST['TimeZoneId']; $iRecords = (int)$_POST['Records']; $sCategories = $_POST['Categories']; showEvents($sUserName, $sPassword, $iTimeZoneId, $iRecords, $sCategories); } if ($_REQUEST['Flag'] == "JS") { $sUserName = $_REQUEST['UserName']; $sPassword = $_REQUEST['Password']; $iTimeZoneId = (int)$_REQUEST['TimeZoneId']; $iRecords = (int)$_REQUEST['Records']; $sCategories = $_REQUEST['Categories']; header('Content-type: text/javascript'); header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); header('Cache-Control: no-store, no-cache, must-revalidate'); header('Cache-Control: post-check=0, pre-check=0', false); showEvents($sUserName, $sPassword, $iTimeZoneId, $iRecords, $sCategories, true); } ?>