function PHPTutorials() { //echo$ip=getIp(); echo "\n<div class='container_fluid'>\n<center><table width='800'>\n <tr>"; openDB(); $getPro_id = mysql_query("select * from products where product_link='php.php'"); $split = 0; while ($row_pro = mysql_fetch_array($getPro_id)) { $prod_id = $row_pro['product_id']; $prod_title = $row_pro['product_title']; $prod_price = $row_pro['product_price']; $prod_image = $row_pro['product_image']; $pro_desc = $row_pro['product_desc']; $split++; echo "\n\t\t\t\t\t\t<td width='400' style='padding:5px;'><h3>{$prod_title}</h3>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<a href='../pages/details2.php?pro_id={$prod_id}'>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<image src='../Images/{$prod_image}' width='200' height='100'></image></a>\n\t\t\t\t\t\t<br>\n\t\t\t\t\t\t<h4><strong>Price: \$ {$prod_price}</strong></h4>\n\t\t\t\t\t\t<br><br><h4>Description:</h4><br>{$pro_desc}<br><br>\n\t\t\t\t\t\t<a href='../pages/details2.php?pro_id={$prod_id}'>Details</a>\n\t\t\t\t\t\t<a href='http://www.smcleodtech.com.au/index.php?add_cart={$prod_id}'>\n\t\t\t\t\t\t<button>Add to Cart</button></a></td>"; if ($split % 3 == 0) { echo "\n\t\t\t\t\t\t</tr><tr>"; } } cart(); closeDB(); echo "</tr><br>\n </table></center>\n </div>"; }
public function save() { $connection = connectDB(); $query = "UPDATE Transactions\n\t\t\t\tSET FirstName = '{$this->fname}',\n\t\t\t\tLastName = '{$this->lname}',\n\t\t\t\tEmail = '{$this->email}',\n\t\t\t\tPayment = '{$this->payment}',\n\t\t\t\tFinalToPay = '{$this->finalToPay}',\n\t\t\t\tPaypalMail = '{$this->PaypalMail}',\n\t\t\t\tBankNr = '{$this->BankNr}',\n\t\t\t\tAccountNr = '{$this->AccountNr}',\n\t\t\t\tStatusDate = '{$this->StatusDate}',\n\t\t\t\tRejectOption = '{$this->RejectOption}',\n\t\t\t\tOrderDate = '{$this->OrderDate}',\n\t\t\t\tReceptionDate = '{$this->ReceptionDate}',\n\t\t\t\tProcessedDate = '{$this->ProcessedDate}',\n\t\t\t\tPaymentDate = '{$this->PaymentDate}',\n\t\t\t\tFinishedDate = '{$this->FinishedDate}'\n\t\t\t\tWHERE id={$this->id}"; echo $query; mysql_query($query); closeDB($connection); }
function getCountiesMap() { global $mysqli; connectDB(); $result_set = $mysqli->query("\n SELECT * FROM `counties`\n WHERE NOT(`map` = ' ')\n "); closeDB(); return resultSetToArray($result_set); }
function getFile($limit) { global $mysqli; connectDB(); $result = $mysqli->query("SELECT * FROM `office`.`tbl_uploads` ORDER BY `ID` DESC LIMIT {$limit}"); closeDB(); return resultToArray($result); }
function getList($table, $page, $pageSize) { global $mysqli; connectDB(); $first = ($page - 1) * $pageSize; $result = $mysqli->query("SELECT * FROM {$table} ORDER BY id DESC LIMIT {$first}, {$pageSize}"); closeDB(); return resultToArray($result); }
function getFooter() { ?> </body> </html> <?php closeDB(); }
function main() { global $wonitorDb; $db = openDB($wonitorDb); try { queryDB($db); } catch (PDOException $e) { echo $e->getMessage(); } closeDB($db); }
function checkUser($login, $password) { if ($login == "" || $password == "") { require_false; } $mysqli = connectDB(); $result_set = $mysqli->query("SELECT password, activation FROM users WHERE login = '******'"); $user = $result_set->fetch_assoc(); $real_password = $user["password"]; $act = $user['activation']; if ($act != "") { return false; } closeDB($mysqli); return $real_password == $password; }
<div class="headline"><?php echo $buy_headline1; ?> </div> <div> <?php include 'db.php'; include 'language.php'; $email = $_POST['buy_email']; if (filter_var($email, FILTER_VALIDATE_EMAIL)) { $verbindung = connectDB(); $abfrage = "SELECT Email\n\t\t\t\tFROM Feedback\n\t\t\t\tWHERE Email LIKE '{$email}'\n\t\t\t\tAND Reason LIKE 'Buy'\n\t\t\t\t"; $ergebnis = mysql_query($abfrage); if (mysql_num_rows($ergebnis) > 0) { // The Email is allready in the Buy feedback echo $buy_text2; } else { // store the mail adress $insert = "INSERT INTO Feedback (Email, Reason)\n\t\t\t\t\tVALUES ('{$email}', 'Buy')"; mysql_query($insert); echo $buy_text3; echo "<br />Email: {$email}"; } closeDB($verbindung); } else { include 'buy.php'; echo "<br /><br /><br /><div class='orange'>{$buy_error1} {$email}</div>"; } ?> </div>
function getItinerary($IID) { $connection = initDB(); $query; if ($IID == 0) { $query = "SELECT * FROM Itinerary"; } else { $query = "SELECT * FROM Itinerary WHERE IID='" . $IID . "'"; } $result = mysql_query($query); //or die ("Query Failed ".mysql_error()); $itineraryID = 0; $itineraryData; while ($row = mysql_fetch_array($result)) { $GID = $row['GID']; $FID = $row['FID']; $SID = $row['SID']; //Retrieve Guest Information $query2 = "SELECT * FROM Guest WHERE GID='" . $GID . "'"; $result2 = mysql_query($query2); $row2 = mysql_fetch_array($result2); $firstName = $row2['FirstName']; $lastName = $row2['LastName']; //Retrieve Travel Schedule Information $query3 = "SELECT * FROM Schedule WHERE SID='" . $SID . "'"; $result3 = mysql_query($query3); $row3 = mysql_fetch_array($result3); $travelDate = $row3['Date']; //Retrieve Sector Information $query3 = "SELECT * FROM Flights WHERE FID='" . $FID . "'"; $result3 = mysql_query($query3); $row3 = mysql_fetch_array($result3); $sourceSID = $row3['SourceSID']; $destSID = $row3['DestSID']; $fName = $row3['FName']; $query4 = "SELECT Sector FROM Sectors WHERE SID='" . $sourceSID . "'"; $result4 = mysql_query($query4); $row4 = mysql_fetch_array($result4); $source = $row4['Sector']; $query4 = "SELECT Sector FROM Sectors WHERE SID='" . $destSID . "'"; $result4 = mysql_query($query4); $row4 = mysql_fetch_array($result4); $dest = $row4['Sector']; //Build GuestItinerary object $guestItinerary = new GuestItinerary(); $guestItinerary->set_FID($FID); $guestItinerary->set_FName($fName); $guestItinerary->set_SID($SID); $guestItinerary->set_source($source); $guestItinerary->set_dest($dest); $guestItinerary->set_travelDate($travelDate); $guestItinerary->set_GID($GID); $guestItinerary->set_firstName($firstName); $guestItinerary->set_lastName($lastName); $itineraryData[$itineraryID] = $guestItinerary; $itineraryID = $itineraryID + 1; } closeDB($connection); return $itineraryData; }
require_once 'global.php'; require 'db_query.php'; $cookie_name = "user_id"; $uid_isset = false; $uid_isvalid = false; if (!isset($_COOKIE[$cookie_name])) { $uid_isset = false; } else { $uid_isset = true; connectToDB(); $table_name = 'users'; $user_id = $_COOKIE[$cookie_name]; $user_name = $_COOKIE["user_name"]; $uid_isvalid = checkUsersWithID($user_id); closeDB(); } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <title>Create life like you create your innovative drinks!</title> <link rel="stylesheet" href="/create_your_own_drink/CSS/main.css"> <link href='http://fonts.googleapis.com/css?family=Sigmar+One|Monoton|Pinyon+Script|Rock+Salt|Kaushan+Script|Julius+Sans+One|Kranky|Coming+Soon' rel='stylesheet' type='text/css'> </head> <body> <header id="index-header"> <?php
function addUserToDB($firstName, $lastName, $username, $password, $usertype) { $con = connectToDB(); $uniqueID = uniqid(); //echo $uniqueID; $sql = "INSERT INTO User VALUES('{$uniqueID}', '{$firstName}', '{$lastName}','{$usertype}');"; if (!mysqli_query($con, $sql)) { echo "Errormessage: ", mysqli_error($con); } else { echo "Successfull insert.\n"; } //insert into credentials $sql = "INSERT INTO Credentials(uniqueID, username, password) VALUES('{$uniqueID}', '{$username}', '{$password}');"; if (!mysqli_query($con, $sql)) { echo "Errormessage: ", mysqli_error($con); } else { echo "Successfull insert.\n"; } closeDB($con); }
function performQuery($query) { // Open the database. $db = openDB(); // Query the database. $queryResult = mysql_query($query, $db); // If there is an error, return the error. if (!$queryResult) { $result = array("status" => 0, "error" => array("6", "Database query error: " . mysql_error())); packageResponse($result); exit; } // Close the database and return the result. closeDB($db); return $queryResult; }
/** ----------------------------- * add page ending tags ----------------------------*/ function endPage() { print '</body></html>'; try { closeDB(); //not care about the exception } catch (Exception $e) { } }
function getRawGMList($leagueID) { $season = getSeason(); $sql = "select teamDisplayName from fch_league_membership where leagueID = {$leagueID} and status = \"active\" and season = \"{$season}\" ORDER BY teamDisplayName ASC"; $con = initializeDB(); $result = $con->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $out .= $row["teamDisplayName"] . "<br/>"; } } closeDB($con); return $out; }
$channel["date"][] = $date; } // next program while ($row_program) { $program_time = strtotime($row_program["program_time"]); $pid = number_format($program_time * 1000 / $row["piecelength"], 0, '', ''); $channel["programs"][0]["program"][] = array( "pid" => $pid, "time" => date('Y-m-d H:i', $program_time), "name" => encodeText($row_program["title"]), "contents" => encodeText($row_program["contents"]) ); $row_program = mysql_fetch_array($result_program, MYSQL_ASSOC); } mysql_free_result ($result_program); } */ $xml["channel"][] = $channel; } mysql_free_result($result); closeDB($conn); header('Content-Type: text/xml; charset=utf-8'); $data = printXML("result", $xml); $data = gzcompress($data); echo $data; }
function showTransaction($t, $e) { $mysqli = connectDB(); $abfrage = "SELECT * FROM Transactions\n\t\t\t\tWHERE id={$t} AND email LIKE '{$e}'"; $ergebnis = $mysqli->query($abfrage); echo "<table>"; while ($row = $ergebnis->fetch_object()) { echo "<tr>\n\t\t\t\t<td>{$row->FirstName}</td>\n\t\t\t\t<td>{$row->LastName}</td>\n\t\t\t\t<td>{$row->Email}</td>\n\t\t\t\t<td>{$row->Payment}</td>\n\t\t\t\t\n\t\t\t </tr>"; } echo "</table>"; closeDB($verbindung); return $newTransactionId; }
function sqlRefresh() { $season = getSeason(); /// ///////////////////////////////////////////////// /// TRUNCATE SCHEDULE $sql = <<<SQL \t\ttruncate table fanta66_joomla.fch_schedule; SQL; $scheduleTruncateResults = executeGenericSQL($sql); /// ///////////////////////////////////////////////// /// REBUILD SCHEDULE $sql = <<<SQL \t\tinsert into fanta66_joomla.fch_schedule \t\t(dateStamp,visitor,home) \t\tselect date_stamp,visitor,home from fanta66_zudnicfchmaster.schedule_master; SQL; $scheduleResults = executeGenericSQL($sql); /// ///////////////////////////////////////////////// /// TRUNCATE SCHEDULE $sql = <<<SQL \t\ttruncate table fanta66_joomla.fch_schedule_lastseason; SQL; $scheduleTruncateResultsLY = executeGenericSQL($sql); /// ///////////////////////////////////////////////// /// REBUILD SCHEDULE $sql = <<<SQL \t\tinsert into fanta66_joomla.fch_schedule_lastseason \t\t(dateStamp,visitor,home) \t\tselect date_stamp,visitor,home from fanta66_zudnicfchmaster.schedule_lastseason; SQL; $scheduleResultsLY = executeGenericSQL($sql); /// ///////////////////////////////////////////////// /// TRUNCATE RESULTS $sql = <<<SQL \t\tDELETE FROM fanta66_joomla.fch_consolidated_results where season = "{$season}"; SQL; $out .= "<HR><B>Truncate Results SQL: </B><br/>{$sql}<p/>\n"; $truncateResultsResults = executeGenericSQL($sql); /// ///////////////////////////////////////////////// /// REBUILD RESULTS - SKATERS $sql = <<<SQL insert into fanta66_joomla.fch_consolidated_results (dateStamp ,totalPoints ,season ,playerID ,schoolID ,opponent ,opponentDisplayName ,playerDisplayName ,position ,schoolDisplayName ,statLine ,dateLine ,atVs) SELECT DISTINCT \t`fanta66_zudnicfchmaster`.`results_skaters`.`date_stamp` AS `date_stamp` \t,`fanta66_zudnicfchmaster`.`results_skaters`.`total_points` AS `totalPoints` \t,convert(CONCAT ( \t\t\tsubstr(`fanta66_zudnicfchmaster`.`results_skaters`.`season`, 1, 4) \t\t\t,"-" \t\t\t,substr(`fanta66_zudnicfchmaster`.`results_skaters`.`season`, 5, 4) \t\t\t) using utf8) AS `season` \t,replace(replace(replace(replace(replace(`fanta66_zudnicfchmaster`.`results_skaters`.`player`, "'", ""), "-", ""), ".", ""), " ", ""), "~", "") AS `playerID` \t,`fanta66_zudnicfchmaster`.`player_master`.`school_id` AS `schoolID` \t, IF ( \t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_skaters`.`visitor`) \t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`home` \t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`visitor` \t\t) AS `opponent` \t,`fanta66_zudnicfchmaster`.`school_master`.`school_shortname` AS `opponentDisplayName` \t,CONCAT ( \t\t`fanta66_zudnicfchmaster`.`player_master`.`first_name` \t\t," " \t\t,`fanta66_zudnicfchmaster`.`player_master`.`last_name` \t\t,", " \t\t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` \t\t) AS `playerDisplayName` \t,`fanta66_zudnicfchmaster`.`player_master`.`position` as position \t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` as schoolDisplayName \t,CONCAT ( \t\tconvert(IF ( \t\t\t\t(1 > `fanta66_zudnicfchmaster`.`results_skaters`.`goals`) \t\t\t\t,"0" \t\t\t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`goals` \t\t\t\t) using latin1 ) \t\t\t," G, " \t\t\t,convert(IF ( \t\t\t\t\t(1 > `fanta66_zudnicfchmaster`.`results_skaters`.`assists`) \t\t\t\t\t,"0" \t\t\t\t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`assists` \t\t\t\t\t) using latin1 ) \t\t\t\t," A " \t\t\t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`info` ) AS `statLine` \t\t\t\t,CONCAT (convert(date_format(`fanta66_zudnicfchmaster`.`results_skaters`.`date_stamp`, "%c/%e") using latin1)) AS `dateLine` \t\t\t\t,convert(IF ( \t\t\t\t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_skaters`.`visitor`) \t\t\t\t\t\t," at " \t\t\t\t\t\t," vs " \t\t\t\t\t\t) using latin1 ) AS `atVs` FROM ( \t\t\t\t\t( \t\t\t\t\t\t`fanta66_zudnicfchmaster`.`results_skaters` JOIN `fanta66_zudnicfchmaster`.`player_master` \t\t\t\t\t\t) JOIN `fanta66_zudnicfchmaster`.`school_master` \t\t\t\t\t) WHERE ( \t\t\t\t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`text_id` = `fanta66_zudnicfchmaster`.`results_skaters`.`player`) \t\t\t\t\t\tAND ( \t\t\t\t\t\t\t`fanta66_zudnicfchmaster`.`school_master`.`school_id` = IF ( \t\t\t\t\t\t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_skaters`.`visitor`) \t\t\t\t\t\t\t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`home` \t\t\t\t\t\t\t\t,`fanta66_zudnicfchmaster`.`results_skaters`.`visitor` \t\t\t\t\t\t\t\t) ) ) ORDER BY `fanta66_zudnicfchmaster`.`results_skaters`.`date_stamp` DESC; SQL; $skaterInsertResults = executeGenericSQL($sql); $out .= "<HR><B>Skater Results SQL: </B><br/>{$sql}<p/>\n"; ///////////////////////////////////////// // GOALIE RESULTS $sql = <<<SQL \tinsert into fanta66_joomla.fch_consolidated_results (dateStamp ,totalPoints ,season ,playerID ,schoolID ,opponent ,opponentDisplayName ,playerDisplayName ,position ,schoolDisplayName ,statLine ,dateLine ,atVs) \tSELECT DISTINCT `fanta66_zudnicfchmaster`.`results_goalies`.`date_stamp` AS `date_stamp` \t,`fanta66_zudnicfchmaster`.`results_goalies`.`points` AS `total_points` \t,convert(CONCAT ( \t\t\tsubstr(`fanta66_zudnicfchmaster`.`results_goalies`.`season`, 1, 4) \t\t\t,"-" \t\t\t,substr(`fanta66_zudnicfchmaster`.`results_goalies`.`season`, 5, 4) \t\t\t) using utf8) AS `season` \t,replace(replace(replace(replace(replace(`fanta66_zudnicfchmaster`.`results_goalies`.`player`, "'", ""), "-", ""), ".", ""), " ", ""), "~", "") AS `playerID` \t,`fanta66_zudnicfchmaster`.`player_master`.`school_id` AS `schoolID` \t ,IF ( \t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_goalies`.`visitor`) \t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`home` \t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`visitor` \t\t) AS `opponent` \t,`fanta66_zudnicfchmaster`.`school_master`.`school_shortname` AS `opponentDisplayName` \t,CONCAT ( \t\t`fanta66_zudnicfchmaster`.`player_master`.`first_name` \t\t," " \t\t,`fanta66_zudnicfchmaster`.`player_master`.`last_name` \t\t, ", " \t\t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` \t\t) AS `playerDisplayName` \t,`fanta66_zudnicfchmaster`.`player_master`.`position` AS position \t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` as schoolDisplayName \t,CONCAT ( \t\t`fanta66_zudnicfchmaster`.`results_goalies`.`goals_allowed` \t\t," GA, " \t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`saves` \t\t," saves, " \t\t,round(`fanta66_zudnicfchmaster`.`results_goalies`.`gaa`, 3) \t\t," GAA, " \t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`decision` \t\t) AS `statLine` \t,CONCAT (convert(date_format(`fanta66_zudnicfchmaster`.`results_goalies`.`date_stamp`, "%c/%e") using latin1)) AS `dateLine` \t,convert(IF ( \t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_goalies`.`visitor`) \t\t\t," at " \t\t\t," vs " \t\t\t) using latin1 ) AS `atVs` FROM ( \t\t( \t\t\t`fanta66_zudnicfchmaster`.`results_goalies` JOIN `fanta66_zudnicfchmaster`.`player_master` \t\t\t) JOIN `fanta66_zudnicfchmaster`.`school_master` \t\t) WHERE ( \t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`text_id` = `fanta66_zudnicfchmaster`.`results_goalies`.`player`) \t\t\tAND ( \t\t\t\t`fanta66_zudnicfchmaster`.`school_master`.`school_id` = IF ( \t\t\t\t\t(`fanta66_zudnicfchmaster`.`player_master`.`school_id` = `fanta66_zudnicfchmaster`.`results_goalies`.`visitor`) \t\t\t\t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`home` \t\t\t\t\t,`fanta66_zudnicfchmaster`.`results_goalies`.`visitor` \t\t\t\t\t) ) ) ORDER BY `fanta66_zudnicfchmaster`.`results_goalies`.`date_stamp` DESC; SQL; $goalieInsertResults = executeGenericSQL($sql); $out .= "<HR><B>Goalie Results SQL: </B><br/>{$sql}<p/>\n"; $out .= "Skater Results Insert: " . $skaterInsertResults["msg"] . "\n<br/>"; $out .= "Goalie Results Insert: " . $goalieInsertResults["msg"] . "\n<br/>"; $playerTruncateResults = executeGenericSQL("truncate table fanta66_joomla.fch_players"); $out .= "Player Truncate: " . $playerTruncateResults["msg"] . "\n"; $sql = <<<SQL \tinsert into fanta66_joomla.fch_players (playerID, lastName, firstName, schoolDisplayName, schoolID, playerYear, position, season) select distinct \treplace(replace(replace(replace(replace(`fanta66_zudnicfchmaster`.`player_master`.`text_id`, "'", ""), "-", ""), ".", ""), " ", ""), "~", "") AS `playerID` \t,`fanta66_zudnicfchmaster`.`player_master`.`last_name` as lastName \t,`fanta66_zudnicfchmaster`.`player_master`.`first_name` as firstName \t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` as schoolDisplayName \t, `fanta66_zudnicfchmaster`.`player_master`.`school_id` as schoolID \t, `fanta66_zudnicfchmaster`.`player_master`.`year_in_school` as playerYear \t, `fanta66_zudnicfchmaster`.`player_master`.`position` as position \t, convert(CONCAT ( \t\t\tsubstr(`fanta66_zudnicfchmaster`.`player_master`.`season`, 1, 4) \t\t\t,"-" \t\t\t,substr(`fanta66_zudnicfchmaster`.`player_master`.`season`, 5, 4) \t\t\t) using utf8) AS `season` \tfrom `fanta66_zudnicfchmaster`.`player_master` \twhere `fanta66_zudnicfchmaster`.`player_master`.`test` = "prod" SQL; $sql .= " and season = \"" . preg_replace("/[^A-Za-z0-9 ]/", '', getSeason()) . "\";"; $playerInsertResults = executeGenericSQL($sql); $out .= "Player refresh insert: " . $playerInsertResults["msg"] . "\n"; echo "Full Insert playerInsertResults: {$sql}<p>\n\n"; $lastSeason = preg_replace("/[^A-Za-z0-9 ]/", '', getLastSeason()); $season = getSeason(); $sql = <<<SQL \tinsert into fanta66_joomla.fch_players (playerID, lastName, firstName, schoolDisplayName, schoolID, playerYear, position, season) select distinct \treplace(replace(replace(replace(replace(`fanta66_zudnicfchmaster`.`player_master`.`text_id`, "'", ""), "-", ""), ".", ""), " ", ""), "~", "") AS `playerID` \t,`fanta66_zudnicfchmaster`.`player_master`.`last_name` as lastName \t,`fanta66_zudnicfchmaster`.`player_master`.`first_name` as firstName \t,`fanta66_zudnicfchmaster`.`player_master`.`school_name` as schoolDisplayName \t, `fanta66_zudnicfchmaster`.`player_master`.`school_id` as schoolID \t, "?" as playerYear \t, `fanta66_zudnicfchmaster`.`player_master`.`position` as position \t, {$season} AS `season` \tfrom `fanta66_zudnicfchmaster`.`player_master` \twhere `fanta66_zudnicfchmaster`.`player_master`.`year_in_school` != "Sr" SQL; $sql .= " and `fanta66_zudnicfchmaster`.`player_master`.`season` = \"{$lastSeason}\" "; $sql .= " and `fanta66_zudnicfchmaster`.`player_master`.`school_id` not in (select distinct schoolID from fanta66_joomla.fch_players where season = \"" . getSeason() . "\");"; SQL; echo "Delta Insert: {$sql}<BR>\n\n"; $deltaInsertResults = executeGenericSQL($sql); $out .= "Player delta insert: " . $deltaInsertResults["msg"] . "\n"; $deltaUpdateResults = executeGenericSQL("UPDATE fch_players SET season = \"" . getSeason() . "\", playerYear = NULL where playerYear = \"?\""); $out .= "Player delta update: " . $deltaInsertResults["msg"] . "\n"; // Draft times are in eastern time. No offset. $sql = "SELECT u.email as email, DATE_FORMAT(l.draftTime ,'%W, %b %d %h:%i %p, Eastern time') as draftTime, l.id as id\r\r\n\tFROM fch_users u, fch_leagues l, fch_league_membership lm\r\r\n\tWHERE l.draftTime > DATE_ADD( NOW( ) , INTERVAL +24 HOUR ) \r\r\n\tAND l.draftTime < DATE_ADD( NOW( ) , INTERVAL +48 HOUR ) \r\r\n\tAND lm.leagueID = l.id\r\r\n\tAND l.draftReminderSent != TRUE\r\r\n\tAND lm.userID = u.id"; /* $sql = " SELECT u.email AS email, DATE_FORMAT( l.draftTime, '%W, %b %d %h:%i %p, Eastern time' ), l.id AS draftTime FROM fch_users u, fch_leagues l, fch_league_membership lm WHERE lm.leagueID = l.id AND lm.userID = u.id AND l.id =35"; */ $con = initializeDB(); $result = $con->query($sql); if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $body = "Hi,\n"; $body .= "This is a reminder that your Fantasy College Hockey draft is tomorrow, " . $row[draftTime] . ".\n\n"; $body .= "The draft is live on fantasycollegehockey.com. The draft is available in the League menu and includes a live chat.\n\n"; $body .= "One hour prior to draft time, the system will close new registrations to the league and generate the draft order. The order will be e-mailed to you.\n\n"; $body .= "Your league administrator will need to open the draft. When the draft is over, the administrator will close the draft and your drafted players will be moved onto your roster.\n\n"; $body .= "** DO NOT REPLY ** to this email. Please contact us at fantasycollegehockey@gmail.com if you have questions.\n\n"; $body .= "Have fun!\n"; $updateDraftReminder = "UPDATE fch_leagues SET draftReminderSent = TRUE WHERE id = " . $row[id]; $out .= "<HR>Draft Reminder, SQL: {$updateDraftReminder}"; executeGenericSQL($updateDraftReminder); sendEmail($row[email], "Reminder: Your Draft Is Tomorrow", $body); $emailSentTo .= $row[email] . ", "; } } $truncateByTeamResult = executeGenericSql("DELETE FROM fanta66_joomla.fch_schedule_byteam"); $out .= "<hr/>Delete all from fch_scheduleByTeam: " . $truncateByTeamResult["msg"]; $sql = "\r\r\n\t\tinsert into fch_schedule_byteam (id,dateStamp,schoolID,atVs,opponent) \r\r\n\t\t(select NULL, dateStamp, home, \"vs\" , visitor from fch_schedule)\r\r\n\t\tunion all\r\r\n\t\t(select NULL, dateStamp, visitor as schoolID, \"at\" as atVs, home as opponent from fch_schedule)"; $rebuildByTeamResult = executeGenericSql($sql); $out .= "<hr>Rebuild fch_scheduleByTeam: <p/>\n{$sql}<p/>\nResult:" . $rebuildByTeamResult["msg"]; closeDB($con); $out .= "<p/>\n\tEmail sent to: {$emailSentTo}"; sendEmail("*****@*****.**", "FCH Cron Results", $out); echo $out; }
function main() { global $data; global $wonitorDb, $wonitorStructure; global $ns2plusDb, $ns2plusStructure; readData(); checkWhitelist(); checkData(); try { if ($_POST['messageType'] == 'MatchEnd') { $db = openDB($wonitorDb); createTables($db, $wonitorStructure); insertRoundData($db, $data); closeDB($db); echo "MatchEnd post successful\n"; } if ($_POST['messageType'] == 'NS2PlusStats') { $db = openDB($ns2plusDb); createTables($db, $ns2plusStructure); insertNS2PlusData($db, $data); closeDB($db); echo "NS2PlusStats post successful\n"; } } catch (PDOException $e) { echo $e->getMessage(); } }
} } else { // Знайти збіги невдалось $text = '<p>По вашому запиті нічого не знайдено.</p>'; } } } else { $text = '<p>Заданий порожній пошуковий запит.</p>'; } echo "</tr></table>"; //Повертаєм сформованую рядок пошукової видачі return $text; } ///////////// Сам скріпт обробки /////////////// if (isset($_POST['query'])) { // Відкриваєм зєднання з базою даних $connect = connectDB(); $search_result = search($_POST['query']); echo $search_result; // Закриваєм зєднання з базою данних closeDB($connect); } ?> </div> </div> <?php include 'util/footer.php'; ?>
} break; case "drop-results": if ($v && $r['submit'] == "ja") { query("delete from " . ZUG); query("delete from " . RES); echo "ergebnisse gelöscht"; } else { if ($v) { include STATIC_DIR . "admin-welcome"; } else { areyousure("?drop-results=true", "ergebnisse löschen", "achtung! alle ergebnisdaten werden dabei gelöscht! NUR NACH ENDE DER TESTPHASE AKTIVIEREN, IN KEINEM FALL WÄHREN DEM BETRIEB!"); } } break; default: include STATIC_DIR . "admin-welcome"; break; } echo " </td>"; echo " </tr>"; echo " <tr class='foot'>"; echo " <td colspan='2'>" . TITLE . "</td>"; echo " </tr>"; echo "</table>"; echo "</body>"; closeDB($db); //end page ?> </html>
function main() { global $wonitorDb, $wonitorStructure; global $ns2plusDb, $ns2plusStructure; $table = 'rounds'; if (isset($_GET['table'])) { $table = $_GET['table']; } $db = null; $structure = null; if (isset($wonitorStructure[$table])) { $db = openDB($wonitorDb); $structure = $wonitorStructure; } elseif (isset($ns2plusStructure[$table])) { $db = openDB($ns2plusDb); $structure = $ns2plusStructure; } else { exit; } try { queryDB($db, $structure, $table); } catch (PDOException $e) { echo $e->getMessage(); } closeDB($db); }
$result = $con->query($sql); //echo "debug ". isDebug(); $leagueSelector .= "<form name = \"leagueSelector\" method = \"POST\"><SELECT name = \"league\">"; if ($result->num_rows > 0) { // output data of each row while ($row = $result->fetch_assoc()) { $selectLeague = ""; debug("<B>Checking {$dbLeague}</B> = " . $row["leagueID"]); if ($row["leagueID"] == $dbLeague) { $usingAs = ""; //Now viewing your team in " . $row['leagueDisplayName']; $selectedLeagueID = $row["leagueID"]; $selectLeague = "SELECTED"; } else { $selectLeague = ""; } $leagueSelector .= "<OPTION value = \"" . $row['leagueID'] . "\" {$selectLeague}>" . $row['leagueDisplayName'] . "</OPTION>"; } } $leagueSelector .= "<input name = \"action\" value = \"leagueChange\" type = \"hidden\">"; $leagueSelector .= "<input name = \"go\" value = \"Change League >>\" class=\"btn btn-primary validate\" type = \"button\" onClick = \"javaScript:document.forms['leagueSelector'].submit()\">"; $leagueSelector .= "</form>"; echo $usingAs . $leagueSelector; closeDB($con); executeGenericSQL("UPDATE fch_user_preferences SET displayLeague = {$selectedLeagueID} WHERE userID = {$userID}"); } ?>
$count = executeSQL($mysqli, $sql); $logger->debug("tbl_user_macid:" . $count); // 清理关联表 macid $sql = "select um.id from tbl_user_macid um ,(select max(id) id, userid from tbl_user_macid where delete_flag=0 group by userid) u where um.userid=u.userid and um.id<>u.id and um.update_date < '{$before_day}'"; $logger->debug(preg_replace('/\\s+/', ' ', $sql)); $result = querySQL($mysqli, $sql); $data = array(); while ($row = mysql_fetch_assoc($result)) { $data[] = $row['id']; } $sql = "delete from tbl_user_macid where id in (" . join(',', $data) . ")"; $logger->debug(preg_replace('/\\s+/', ' ', $sql)); $count = executeSQL($mysqli, $sql); $logger->debug("clear tbl_user_macid:" . $count); // 清理关联表 status $sql = "select um.id from tbl_user_status um ,(select max(id) id, userid from tbl_user_status where delete_flag=0 group by userid) u where um.userid=u.userid and um.id<>u.id and um.update_date < '{$before_day}'"; $logger->debug(preg_replace('/\\s+/', ' ', $sql)); $result = querySQL($mysqli, $sql); $data = array(); while ($row = mysql_fetch_assoc($result)) { $data[] = $row['id']; } $sql = "delete from tbl_user_status where id in (" . join(',', $data) . ")"; $logger->debug(preg_replace('/\\s+/', ' ', $sql)); $count = executeSQL($mysqli, $sql); $logger->debug("clear tbl_user_status:" . $count); // 关闭DB closeDB($mysqli); ?>