/** * Denna kan se lite annorlunda ut eftersom det är in showStyle. * Det kanske inte innehåller secifikt footer och header. */ public function showContent() { /* First Gallery start on klick on Gallery */ if ($this->m->level == 0) { $q = new Query("matruschka"); $q->whereImage("mParent='" . $this->m->ID . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "ASC", 1); $q->whereImage("mParent='" . $q->getResultRow("mRowid") . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "ASC", 1); $showID = $q->getResultRow("mRowid"); } else { if ($this->m->level == 2) { $showID = $this->m->ID; } } $q = new Query("matruschka"); $q->whereImage("mParent='" . $showID . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "ASC", 0); $qq = new Query("matruschka"); $qq->whereImage("mRowid='" . $showID . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "ASC", 0); /* Main image */ $ret = '<div id="pic">'; while ($row = mysql_fetch_object($q->getResult())) { $ret .= '<img src="admin/' . Settings::$uploaded_images . '/' . $row->miFilename . '" alt="' . $row->imagesName . '"/>'; } $ret .= '<div id="play">'; $ret .= '<p>Click to pause</p>'; $ret .= '<p style="display:none;">Click to play</p>'; $ret .= '</div>'; $ret .= '<div id="imageInfo">'; $ret .= '<span class="style1">'; $ret .= '<br/><br/>'; $ret .= $qq->getResultRow("mDescription"); $ret .= '</span">'; $ret .= '</div>'; //imageInfo $ret .= '</div>'; //pic /* The thumbs */ $ret .= '<div id="thumbs">'; $x = 0; $q->whereImage("mParent='" . $showID . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "ASC", 0); while ($row = mysql_fetch_object($q->getResult())) { $class = $x % 2 == 1 ? "rightImg" : ""; $ret .= '<img class="' . $class . '"src="admin/' . Settings::$uploaded_images . '/' . $row->miFilename . '" alt="' . $row->imagesName . '" />'; $x++; } $ret .= '</div>'; //thumbs return $ret; }
public function setContent() { $q = new Query("matruschkaShowAtPlaces"); $q->showAt("Menubar", $this->m->lang, "mOrderNo", "ASC", 10); $a = array(); $i = 0; while ($row = mysql_fetch_object($q->getResult())) { // Get the id and image $a[$i][0] = $row->mRowid; $a[$i][1] = $row->mButtonTitle; $a[$i][2] = $row->mButtonImage; $i++; } for ($i = 0; $i < count($a); $i++) { $im = split(',', $a[$i][2]); $this->content .= '<span class="menuItem">' . "\n"; $this->content .= "<a href=\"?ID=" . $a[$i][0] . "\" onmouseout=\"MM_swapImgRestore()\" onmouseover=\"MM_swapImage('" . $im[1] . "','','" . Settings::$graphics . "menu/" . $this->m->lang . "/" . $im[1] . "',1)\">"; // Den man är inne på blir röd $image = $this->getActive($this->m->ID, $a[$i][0]) ? $im[1] : $im[0]; $this->content .= '<img src="' . Settings::$graphics . 'menu/' . $this->m->lang . '/' . $image . '" alt="' . $im[1] . '" name="' . $im[1] . '" border="0" id="' . $im[1] . '" />'; $this->content .= '</a>'; if ($i < count($a) - 1) { $this->content .= '<img src="' . Settings::$graphics . 'menu/' . $this->m->lang . '/stripe.gif" width="7" height="12" />'; } $this->content .= "</span>\n"; } }
/** * Inenhåller menun som passar till Art * subkategprierna ordnas efter orderNo i matrushkan. */ public function setContent() { $q = new Query("matruschkaShowAtPlaces"); $q->showAt($this->title, $this->m->lang, "msapOrderNo", "ASC", 100); $i = 1; while ($row = mysql_fetch_object($q->getResult())) { $this->content .= '<div class="leftMenu">'; $this->content .= '<span class="subSecTitle">' . $row->mButtonTitle . '</span>'; $qq = new Query("matruschka"); $qq->whereCustom("mButtonTitle, mRowid", "mParent = '" . $row->mRowid . "' AND mPublished='1' AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0); if ($qq->getNumRows()) { // om det finns nån som har denna som parent $this->content .= '<div class="subSection">'; while ($row2 = mysql_fetch_object($qq->getResult())) { /** Svart om aktiv **/ if ($this->getActive($this->m->ID, $row2->mRowid) == 1) { $this->content .= '<span class="sideMenuActive"><a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a></span><br/>'; } else { $this->content .= '<a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a><br/>'; } } $this->content .= '</div>'; } $this->content .= '</div>'; if ($i != $q->getNumRows()) { $this->content .= '<img src="' . Settings::$graphics . 'stripes.gif" />' . "\n"; } $i++; } }
/** * InenhÃ¥ller menun som passar till Art * subkategprierna ordnas efter orderNo i matrushkan. */ public function setContent() { $q = new Query("matruschkaShowAtPlaces"); $qq = new Query("matruschka"); $qqq = new Query("matruschka"); $q->showAt($this->title, $this->m->lang, "mOrderNo", "ASC", 100); $i = 1; while ($row = mysql_fetch_object($q->getResult())) { $this->content .= '<div class="leftMenu">'; $this->content .= '<span class="subSecTitle">' . $row->mButtonTitle . "</span>\n"; $qq->whereCustom("mButtonTitle, mRowid", "mParent = '" . $row->mRowid . "' AND mPublished='1' AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0); // om det finns nån som har denna som parent if ($qq->getNumRows()) { /* Fulhack för att få första i galleriet rosa */ $i = 0; $this->content .= '<div class="subSection">'; while ($row2 = mysql_fetch_object($qq->getResult())) { $qqq->whereCustom("mButtonTitle, mRowid, mTitle", "mParent = '" . $row2->mRowid . "' \n AND mPublished='1' \n AND mButtonTitle NOT LIKE ''\n AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0); /** Om det är den trenivåare **/ if ($qqq->getNumRows()) { $this->content .= '<span class="subSecTitle">' . $row2->mButtonTitle . "</span>\n"; $this->content .= '<div class="subSection">'; while ($row3 = mysql_fetch_object($qqq->getResult())) { /** Rosa om aktiv **/ if ($this->getActive($this->m->ID, $row3->mRowid) == 1) { $this->content .= '<span class="sideMenuActive"><a href="?ID='; $this->content .= $row3->mRowid . '">' . $row3->mButtonTitle . "</a></span><br/>\n"; } else { $this->content .= '<a href="?ID=' . $row3->mRowid . '">' . $row3->mButtonTitle . "</a><br/>\n"; } } $this->content .= "</div>\n"; // subSection inre } else { /** Om det är en vanlig blir det en länk**/ /** Rosa om aktiv **/ /** Fulhack - Rosa om man klickat på galleriet */ if ($this->getActive($this->m->ID, $row2->mRowid) == 1 || $this->m->showStyle == "Gallery" && $i == 0 && $this->m->level == 0) { $this->content .= '<span class="sideMenuActive"><a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . "</a></span><br/>\n"; } else { $this->content .= '<a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . "</a><br/>\n"; } } /* Fulhack */ $i++; } $this->content .= "</div>\n"; //subSection yttre } $this->content .= "</div>\n"; // leftMenu if ($i != $q->getNumRows()) { $this->content .= '<img src="' . Settings::$graphics . 'stripes.gif" />' . "\n"; } $i++; } }
public function closeupVimmelThumbs(Query $query, $width) { while ($row = mysql_fetch_object($query->getResult())) { ?> <div class="thumbnail"> <?php echo '<a href="?id=' . $row->rowid . '&category=' . $_GET['category'] . '">'; echo '<img src="image_crop.php?source=' . Settings::getUploadedImages() . '/' . $row->file . '&dest=&thumb_size=' . $width . '" alt="' . $row->name . '" />'; ?> </a> </div> <?php } }
function isPlay($idJoueur, $idTournoi, $database) { $sql_func = 'SELECT * FROM joueurtournoi WHERE id_joueur = :id_joueur AND id_tournoi = :id_tournoi'; $query_func = new Query($database, $sql_func); $query_func->bind(':id_joueur', $idJoueur, PDO::PARAM_INT); $query_func->bind(':id_tournoi', $idTournoi, PDO::PARAM_INT); if ($query_func->execute()) { $jeux = $query_func->getResult(); } if (empty($jeux)) { //ne joue pas a ce jeux return 0; } else { //joue a ce jeux return 1; } }
public function listEntryPlaces($class) { $entryPlaces = new Query("entryPlaces"); $entryPlaces->makeQuery("*", "pubDate", "DESC", 0); echo '<table class="' . $class . '">'; echo '<th align="left">Titel</th><th align="left">Beskrivning</th> <th align="left">Uppdaterad senast</th><th align="left">Ändra</th><th align="left">Ta bort</th>'; while ($row = mysql_fetch_object($entryPlaces->getResult())) { echo '<tr> <td>' . strip_tags($row->title) . '</td> <td>' . strip_tags($row->description) . '</td> <td>' . $row->updateDate . '</td> <td><a href="?action=edit&entryPlaceTitle=' . $row->title . '">Ändra</a></td> <td><a href="?action=delete&entryPlaceTitle=' . $row->title . '">Ta bort</a></td> </tr>'; } echo '</table>'; }
/** * Denna kan se lite annorlunda ut eftersom det är in showStyle. * Det kanske inte innehåller secifikt footer och header. */ public function showContent() { $q = new Query("matruschka"); $q->whereImage("mParent='" . $this->m->ID . "' AND mPublished='1' AND mLang='" . $this->m->lang . "'", "DESC", 3); $qq = new Query("matruschka"); $ret; while ($row = mysql_fetch_object($q->getResult())) { $ret .= '<table width="211" border="0" cellpadding="0" cellspacing="0" class="tableLeft">'; $ret .= '<tr><td colspan="2" class="title2">' . $row->mTitle . '</td></tr>'; $ret .= '<tr><td colspan="2" class="title2">'; $ret .= '<img src="admin/' . Settings::$uploaded_images . '/' . $row->miFilename . '" width="210" height="160" />'; $ret .= '</td>'; $ret .= '</tr>'; $qq->whereImage("mParent='" . $row->mRowid . "' AND mPublished='1'", "ASC", 0); while ($row2 = mysql_fetch_object($qq->getResult())) { $ret .= '<tr>'; $ret .= '<td width="77"><span class="style1"><strong>' . $row2->mTitle . '</strong></span></td>'; $ret .= '<td width="134"><span class="style1">' . $row2->mText . '</span></td>'; $ret .= '</tr>'; } $ret .= "</table>\n"; } return $ret; }
<?php // Created by Ian Santagata // Test script to test MySQL PHP interaction // Feel free to edit and test for your own needs include "Query.php"; $q = new Query("SELECT * FROM gstate"); $q->execute(); $result = $q->getResult(); for ($i = 0; $i <= 8; $i++) { $row = $q->getRow($i); printf("Coordinate: %s Username: %s\n", $row[0], $row[1]); }
echo 'ERREUR SQL TOURNOI'; } exit; } $jpt = $tournoi['joueurParTeam']; $sql = 'SELECT id_match as id,nbr_manche,teamParMatch as tpm FROM matchs WHERE id_tournoi=:idt AND id_groupe IS NULL'; $query = new Query($database, $sql); $query->bind('idt', $id_tournoi, PDO::PARAM_INT); if (!$query->execute()) { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL MATCHS'; } exit; } else { $matchs = $query->getResult(); } if ($jpt > 1) { foreach ($matchs as $match) { if (isset($_POST['m_' . $match['id'] . '_1'])) { $sql = 'DELETE FROM manches_equipes WHERE id_match=:idm'; $query = new Query($database, $sql); $query->bind('idm', $match['id'], PDO::PARAM_INT); if (!$query->execute()) { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL DELETE MANCHE_EQUIPE'; } exit; } $sql = 'DELETE FROM matchs_equipes WHERE id_match=:idm';
<?php require_once 'common/head_admin.php'; // Database Queries $locations = $database->getLocations(); $locations_1 = $database->getLocations_1(); $players = $database->getLogins(); $teams = $database->getTeams(); // Selection des pseudos => mais pourquoi ça existe? $sql = 'SELECT pseudo FROM joueurs ORDER BY pseudo ASC'; $query = new Query($database, $sql); $query->execute(); $joueurs_autre = $query->getResult(); // send to the template $smarty->assign("emplacements", $locations); $smarty->assign("emplacements1", $locations_1); $smarty->assign('joueurs', $players); $smarty->assign('equipes', $teams); $smarty->assign('joueurs_autre', $joueurs_autre); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/emplacements.tpl');
session_start(); require_once '../common/var.conf.php'; require_once DOCUMENT_ROOT . '/common/utils.php'; require_once DOCUMENT_ROOT . '/class/Smarty_HEHLan.class.php'; require_once DOCUMENT_ROOT . '/class/Database.class.php'; require_once DOCUMENT_ROOT . '/class/Auth.class.php'; require_once DOCUMENT_ROOT . '/class/Query.class.php'; $connected = false; $allowed = false; $chatIsActive = false; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } $sql = 'SELECT id_joueur, pseudo FROM joueurs ORDER BY pseudo'; $query = new Query($database, $sql); if ($query->execute()) { $joueurs = $query->getResult(); } else { echo 'ERROR'; exit; } // send to the template $smarty->assign("con", $connected); $smarty->assign("chat", $chatIsActive); $smarty->assign('joueurs', $joueurs); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/joueurs.tpl');
<?php } ?> <br /> <br /> <div class="thumbnailContainer"> <?php if (Helper::isInt($_GET['category'])) { $query = new Query("vimmel_images"); $query->whereLeftJoinImageQuery("*", "category", $_GET['category'], "date", "DESC"); // Dont forget the Javascript (effect.js)!!! $images = new ShowImages($query); $images->closeupVimmelThumbs($query, 50); } ?> </div> <?php } // if(isset($_GET['category']) end $categories = new Query("vimmel_categories"); $categories->makeQuery("*", "date", "DESC", 10000); echo '<span class="boldPink">Bildgalleri</span><span class="smallWhite"></span><br /><br />'; while ($row = mysql_fetch_object($categories->getResult())) { echo '<span class="boldWhite"><a href="?category=' . $row->rowid . '">' . $row->title . '</a></span><br /><br />'; } ?> </div> </div> <?php include "footer.php";
} else { $finale = $match['id_match']; } } $nbrmatch++; $sql2 = 'SELECT mte.id_equipe, e.nom, (SELECT SUM(ma.score) FROM manches_equipes AS ma WHERE ma.id_match=:idm AND ma.id_equipe=mte.id_equipe GROUP BY ma.id_equipe) AS score FROM matchs_equipes AS mte, equipes AS e WHERE mte.id_match=:idm AND e.id_equipes=mte.id_equipe'; $query2 = new Query($database, $sql2); $query2->bind(':idm', $match['id_match'], PDO::PARAM_INT); if ($query2->execute()) { $cpt = 1; foreach ($query2->getResult() as $team) { $matches[$match['id_match']][$cpt]['id'] = $team['id_equipe']; $matches[$match['id_match']][$cpt]['nom'] = $team['nom']; $matches[$match['id_match']][$cpt]['score'] = $team['score']; $cpt++; } } else { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL TEAMS'; } exit; } } } else { global $glob_debug;
} } } else { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL MAPS'; } exit; } $phase; // determiner la phase du pick $sql = "SELECT idMap FROM matchs WHERE id_match=:idMatch"; $query = new Query($database, $sql); $query->bind(':idMatch', $matchId, PDO::PARAM_INT); if ($query->execute()) { $idMap = $query->getResult()[0]['idMap']; if ($idMap == 0) { // on est tjs au stade de pick les maps $phase = "maps"; } else { $phase = "heroes"; } } else { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL MAPS'; } exit; } // ********************** Applying Template ********************** $smarty->assign('con', $connected);
?> <div id="competition"> <div class="veckansFragaBg"><span class="boldWhite"></span></div> <div align="center"><span class="boldWhite">Läs den hetaste </span><span class="boldPink2"><a href="/blogg">hårdrocksbloggen</a></span><span class="boldWhite"> eller regga dig för att </span><span class="boldPink2"> <a href="http://closeupmagazine.net/blogg/wp-login.php?action=register">börja blogga!</a></span></div> <div class="leftBoxFooter"></div> </div> <?php $voteQ = new Query("vote_group"); $voteQ->whereQuery("*", "active", 1, "rowid", "DESC", 1); if ($voteQ->getNumRows() > 0) { while ($row = mysql_fetch_assoc($voteQ->getResult())) { $vote_itemsQ = new Query("vote_group_items"); $vote_itemsQ->whereQuery("*", "group_id", $row['rowid'], "rowid", "ASC", 3); $item1 = mysql_result($vote_itemsQ->getResult(), 0, "rowid"); $item2 = mysql_result($vote_itemsQ->getResult(), 1, "rowid"); $item3 = mysql_result($vote_itemsQ->getResult(), 2, "rowid"); $group = $row['rowid']; ?> <div id="vote"> <div class="competitionBg"></div> <div class="leftTextMargin"> <span class="boldWhite"><?php echo $row['title']; ?> </span> <span class="boldWhite"><?php echo $row['description']; ?> </span> <span class="lightGrey"> <form action="" method="post" name="form1" id="form1">
WHERE id_tournoi = 2'; $query = new Query($database, $sql); if ($query->execute()) { $teamsCOD4 = $query->getResult()[0]['nbr']; } $sql = 'SELECT COUNT(*) AS nbr FROM equipes_tournoi WHERE id_tournoi = 3'; $query = new Query($database, $sql); if ($query->execute()) { $teamsTMNF = $query->getResult()[0]['nbr']; } $sql = 'SELECT COUNT(*) AS nbr FROM equipes_tournoi WHERE id_tournoi = 5'; $query = new Query($database, $sql); if ($query->execute()) { $teamsHS = $query->getResult()[0]['nbr']; } $data1y = array($playersHOTS, $playersCOD4, $playersTMNF, $playersHS); $data2y = array($teamsHOTS, $teamsCOD4, $teamsTMNF, $teamsHS); // Create the graph. These two calls are always required $graph = new Graph(300, 250); $graph->ClearTheme(); $graph->SetShadow(); $graph->SetScale("textlin"); $graph->SetShadow(); $graph->img->SetMargin(40, 30, 20, 40); // Create the bar plots $b1plot = new BarPlot($data1y); $b1plot->SetFillColor("#222C43"); $b1plot->SetLegend("Players"); $b2plot = new BarPlot($data2y);
private function linksShow($level) { if ($level > 1) { $ret = '<span class="imgNr">' . "\n"; /*** Länkarna ***/ $q2 = new Query("matruschka"); // Klickat på i menyn if ($level == 2) { $q2->whereImage("mParent = '" . $this->m->ID . "' AND mPublished='1' ", "ASC", 0); } elseif ($level == 3 && $this->m->buttonTitle == '') { $q2->whereImage("mParent = '" . $this->m->parent . "' AND mPublished='1' ", "ASC", 0); } elseif ($level == 3 && $this->m->buttonTitle != '') { $q2->whereImage("mParent = '" . $this->m->ID . "' AND mPublished='1' ", "ASC", 0); } elseif ($level == 4) { $q2->whereImage("mParent = '" . $this->m->parent . "' AND mPublished='1' ", "ASC", 0); } $i = 0; $a; while ($row = mysql_fetch_object($q2->getResult())) { $a[$i][0] = $row->mOrderNo; $a[$i][1] = $row->mTitle; $a[$i][2] = $row->mButtonTitle; $a[$i][3] = $row->mRowid; $i++; } // så många som ska synas $visible = 11; // Indexet i arrayen som man är på $index; /******** BLIR fel här nånstans ********/ if ($level == 3 && $this->m->buttonTitle == '' || $level == 4) { for ($i = 0; $i < count($a); $i++) { if ($this->m->ID == $a[$i][3]) { $index = $i; } } } else { $index = 0; } /* Inget visas om det bara finns EN */ if (count($a) > 1) { $ss = $this->getOffset($a, $index, $visible); // Om man inte är på första, visa << och ...(Första) $indexBefore; if ($this->m->ID != $a[0][3] && $level == 3 && $this->m->buttonTitle == '' || $this->m->ID != $a[0][3] && $level == 4) { for ($i = 0; $i < count($a); $i++) { if ($this->m->ID == $a[$i][3]) { $index = $i; $indexBefore = $i - 1; } } $ret .= '<a href="?ID=' . $a[$indexBefore][3] . '">' . "\n"; $ret .= "<<\n"; $ret .= "</a>\n"; } for ($i = $ss[0]; $i <= $ss[1]; $i++) { // Visa aktiv om den är aktiv if ($a[$i][3] == $this->m->ID || $level == 2 && $i == 0 || $level == 3 && $this->m->buttonTitle != '' && $i == 0) { $ret .= '<span class="imgNrActive">' . "\n"; $ret .= '<a href="?ID=' . $a[$i][3] . '">'; $ret .= strlen($a[$i][0]) > 1 ? $a[$i][0] : '0' . $a[$i][0]; $ret .= '</a> ' . "\n"; $ret .= "</span>\n"; } else { $ret .= '<a href="?ID=' . $a[$i][3] . '">'; $ret .= strlen($a[$i][0]) > 1 ? $a[$i][0] : '0' . $a[$i][0]; $ret .= '</a> ' . "\n"; } } // Om man inte är på sista, visa >> $indexAfter; // om man e inne på en bild if (($this->m->ID != $a[count($a) - 1][3] && $level == 3 && $this->m->buttonTitle == '' || $this->m->ID != $a[count($a) - 1][3] && $level == 4) && count($a) > 1) { for ($i = 0; $i < count($a); $i++) { if ($this->m->ID == $a[$i][3]) { $indexAfter = $i + 1; } } $ret .= '<a href="?ID=' . $a[$indexAfter][3] . '">' . "\n"; $ret .= ">>\n"; $ret .= "</a>\n"; } elseif (($this->m->ID != $a[count($a) - 1][3] && $level == 2 || $this->m->ID != $a[count($a) - 1][3] && $level == 3 && $this->m->buttonTitle != '') && count($a) > 1) { $ret .= '<a href="?ID=' . $a[1][3] . '">' . "\n"; $ret .= ">>\n"; $ret .= "</a>\n"; } $ret .= "</span>\n"; // imgNr } return $ret; } }
<?php $uname = $_GET["uname"]; include "../lib/Query.php"; $counter = new Query("Select * FROM statistics"); $counter->execute(); $userTotal = $counter->numRows(); $leaderboardLimit = 10; if ($userTotal < $leaderboardLimit) { $leaderboardLimit = $userTotal; } $query = new Query("Select * FROM statistics ORDER BY points DESC, wins DESC, uname ASC LIMIT {$leaderboardLimit}"); $query->execute(); $query->getResult(); echo '<html> <body> <h3>Hello ' . $uname . ', this is the Leaderboard page. </h3> <table border="1"> <tr> <td>Ranking</td> <td>Username</td> <td>Wins</td> <td>Losses</td> <td>Ties</td> <td>Total Games</td> <td>Points</td> </tr>'; for ($i = 0; $i < $leaderboardLimit; $i++) { $row = $query->getRow($i); $username = $row[0]; $wins = $row[1];
/** * Executes a DQL query and returns resources as entities or arrays. * If it returns arrays, it add a "pathfordisplay" field to each item. * * @param Query $query The query to execute * @param integer $offset First row to start with * @param integer $numrows Maximum number of rows to return * @param boolean $asArray Whether the resources must be returned as arrays or as objects * * @return array[AbstractResource|array] */ private function executeQuery($query, $offset = null, $numrows = null, $asArray = true) { $query->setFirstResult($offset); $query->setMaxResults($numrows); if ($asArray) { $resources = $query->getArrayResult(); $return = $resources; // Add a field "pathfordisplay" in each entity (as array) of the given array. foreach ($resources as $key => $resource) { if (isset($resource['path'])) { $return[$key]['path_for_display'] = ResourceNode::convertPathForDisplay($resource['path']); } } return $return; } return $query->getResult(); }
$first = false; $nbr_match = $nbr_match >> 1; } $sql = 'SELECT id_match,id_enfant1,id_enfant2 FROM matchs WHERE id_tournoi=:idt AND id_groupe IS NULL AND (id_enfant1 IS NOT NULL OR id_enfant2 IS NOT NULL)'; $query = new Query($database, $sql); $query->bind('idt', $id_tournoi, PDO::PARAM_INT); if (!$query->execute()) { global $glob_debug; if ($glob_debug) { echo 'ERREUR SELECT FINALES '; } exit; } } foreach ($query->getResult() as $m) { $sql = 'UPDATE matchs SET id_parent=:idp WHERE id_match=:id1 OR id_match=:id2'; $query2 = new Query($database, $sql); $query2->bind('idp', $m['id_match'], PDO::PARAM_INT); $query2->bind('id1', $m['id_enfant1'], PDO::PARAM_INT); $query2->bind('id2', $m['id_enfant2'], PDO::PARAM_INT); if (!$query2->execute()) { global $glob_debug; if ($glob_debug) { echo 'ERREUR SUPDATE PARENT '; } exit; } } if ($petite_finale) { $sql = 'INSERT INTO matchs (id_tournoi,nbr_manche,teamParMatch,looser_bracket,heure)
$groupes[$itGroupe]['teams'] = $teams; $heures = ''; if (is_array($teams)) { foreach ($teams as $team) { $sql = 'SELECT m.id_match,m.heure, SUM(me.score) as score, (SELECT mte2.id_equipe FROM matchs_equipes as mte2 WHERE mte2.id_match=m.id_match AND mte2.id_equipe<>:ide LIMIT 0,1) as team2 FROM (matchs_equipes as mte, matchs as m) LEFT JOIN (manches_equipes as me) ON (me.id_match=m.id_match AND me.id_equipe=:ide) WHERE m.id_groupe=:idg AND mte.id_match=m.id_match AND mte.id_equipe=:ide GROUP BY m.id_match'; $query = new Query($database, $sql); $query->bind(':idg', $groupe['id_groupe'], PDO::PARAM_INT); $query->bind(':ide', $team['id'], PDO::PARAM_INT); if ($query->execute()) { foreach ($query->getResult() as $ligne) { if (!is_null($ligne['score'])) { $scores[$team['id']][$ligne['team2']]['score'] = $ligne['score']; $scores[$team['id']][$ligne['team2']]['id_match'] = $ligne['id_match']; } $heures[$team['id']][$ligne['team2']] = $ligne['heure']; } } else { global $glob_debug; if ($glob_debug) { echo 'ERREUR SQL SCORES TEAM 1'; } exit; } } } else {
$sql = $select . $lefton . ' ORDER BY e.nom'; $query = new Query($database, $sql); $query->execute(); $donnees = $query->getResult(); /********************************** * tournois individuels **********************************/ $sql = 'SELECT id_tournoi, nomTournoi FROM tournoi WHERE joueurParTeam = 1'; $query = new Query($database, $sql); $query->execute(); $select = "SELECT j.*"; $lefton = " FROM joueurs j"; $i = 0; foreach ($query->getResult() as $tournoi) { $tabJT[$i][1] = $tournoi['id_tournoi']; $tabJT[$i][2] = $tournoi['nomTournoi']; $select .= ", jt" . $tournoi['id_tournoi'] . ".id_tournoi AS id_tournoi" . $tournoi['id_tournoi'] . ", jt" . $tournoi['id_tournoi'] . ".pseudoJeux AS pseudoJeux" . $tournoi['id_tournoi']; $lefton .= " LEFT OUTER JOIN joueurtournoi AS jt" . $tournoi['id_tournoi'] . " ON jt" . $tournoi['id_tournoi'] . ".id_joueur = j.id_joueur AND jt" . $tournoi['id_tournoi'] . ".id_tournoi = " . $tournoi['id_tournoi']; $i++; } $sql = $select . $lefton . ' ORDER BY j.pseudo'; $query = new Query($database, $sql); $query->execute(); $donneesJT = $query->getResult(); // send to the template $smarty->assign('con', $connected); $smarty->assign('tab', $tab); $smarty->assign('donnees', $donnees); $smarty->assign('tabJT', $tabJT); $smarty->assign('donneesJT', $donneesJT); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/inscriptions.tpl');
LEFT OUTER JOIN equipes_joueur ej ON j.id_joueur = ej.id_joueur LEFT OUTER JOIN equipes e ON e.id_equipes = ej.id_equipes WHERE j.id_joueur = :idj'; $query = new Query($database, $sql); $query->bind('idj', $_SESSION['id_joueur'], PDO::PARAM_INT); $query->execute(); $joueur = $query->getResult()[0]; $pseudoJeux = ''; // Selecting player profile information $sql = 'SELECT * FROM joueurs WHERE id_joueur = :id_player'; $query = new Query($database, $sql); $query->bind(':id_player', $_SESSION['id_joueur'], PDO::PARAM_INT); $query->execute(); $joueur = $query->getResult()[0]; $joueur['date_de_naissance'] = date("d/m/Y", strtotime($joueur['date_de_naissance'])); $sql = 'SELECT id_equipes, nom FROM equipes ORDER BY nom'; $query = new Query($database, $sql); $query->execute(); $equipes = $query->getResult(); $smarty->assign("next_matches", $database->getNextMatches($connected)); $smarty->assign("navTournois", $database->getNavTournois()); $smarty->assign("joueur", $joueur); $smarty->assign('pseudoJeux', $pseudoJeux); $smarty->assign('equipes', $equipes); $smarty->display('default/profile.tpl'); ?>
if (!empty($_POST['id_joueur'])) { $sql = 'SELECT e.id_equipes, e.nom AS team FROM equipes_joueur et LEFT OUTER JOIN equipes e ON e.id_equipes = et.id_equipes WHERE et.id_joueur = :id'; $query = new Query($database, $sql); $query->bind(':id', $_POST['id_joueur'], PDO::PARAM_INT); $result = $query->execute(); foreach ($query->getResult() as $equipe) { echo '<input type="checkbox" checked class="chkbxEquipeDuJoueur" value="' . $equipe["id_equipes"] . '">' . $equipe["team"] . '<br>'; } $sql = 'SELECT id_equipes, nom FROM equipes ORDER BY nom'; $query = new Query($database, $sql); $query->execute(); echo 'Ajouter à l\'équipe : <select id="SelectAjoutJoueurEquipe" style="width: 200px;"><option></option>'; foreach ($query->getResult() as $equipe) { echo '<option value="' . $equipe["id_equipes"] . '" style="color:#000">' . $equipe["nom"]; echo '</option>'; } echo ' </select> <input type="button" id="submitChangementEquipeDuJoueur" value="Validez les changements">'; echo '<input type="hidden" id="idJoueurAdminForEquipe" value="' . $_POST['id_joueur'] . '">'; } } else { echo "Vous n'êtes pas autorisé à effectuer cette modification!"; } } else { echo "Vous n'êtes pas connecté!"; } ?>
$erreurEmail = "Votre email n'est pas valide. \n"; } } if ($valid) { $pseudo = $_POST['pseudoOublie']; $email = $_POST['emailOublie']; // Génère une chaine aléatoire de 20 caractères $password = random(20); $sql = 'SELECT id_joueur, prenom FROM joueurs WHERE email = :email AND pseudo = :pseudo'; $query = new Query($database, $sql); $query->bind(':email', $email, PDO::PARAM_STR); $query->bind(':pseudo', $pseudo, PDO::PARAM_INT); $query->execute(); $nbr = $query->getPreparedQuery()->rowCount(); if ($nbr != 0) { $joueur = $query->getResult()[0]; //on a trouvé l'email dans la BD donc l'utilisateur try { $query = 'UPDATE joueurs SET password = :password WHERE id_joueur = :id_joueur'; $query = new Query($database, $sql); $query->bind(':password', sha1($password), PDO::PARAM_STR); $query->bind(':id_joueur', $joueur['id_joueur'], PDO::PARAM_INT); $query->execute(); $sql = 'SELECT * FROM joueurs WHERE email = :email AND pseudo = :pseudo AND password = :password'; $query = new Query($database, $sql); $query->bind(':email', $email, PDO::PARAM_STR); $query->bind(':pseudo', $pseudo, PDO::PARAM_INT); $query->bind(':password', sha1($password), PDO::PARAM_STR); $query->execute(); $nbr = $query->getPreparedQuery()->rowCount(); if ($nbr != 0) {
} else { $nbr_lb2 = $query->getResult()[0]; $nbr_lb2 = $nbr_lb2['nbr']; } // Setting the loser brackets $nbr_lb2 = 0; $nbr_lb3 = 0; //SQL Query to count the number of matchs for a tournament and a double looser bracket $sql = 'SELECT COUNT(*) AS nbr FROM matchs WHERE id_groupe IS NULL AND id_tournoi=:idt AND looser_bracket=3'; $query = new Query($database, $sql); $query->bind(':idt', $id_tournoi, PDO::PARAM_INT); if (!$query->execute()) { global $glob_debug; if ($glob_debug) { echo 'ERREUR - SQL COUNT LB3'; } exit; } else { $nbr_lb3 = $query->getResult()[0]; $nbr_lb3 = $nbr_lb3['nbr']; } // Select the Pool or Round mode $tournoi = $database->getTournament($id_tournoi); //if( $tournoi['joueurParTeam'] > 1) if ($id_tournoi != 3) { include_once DOCUMENT_ROOT . '/modules/tournoisPools.php'; } else { include_once DOCUMENT_ROOT . '/modules/tournoisRounds.php'; }
<textarea name="bannersCode" cols="50" rows="25" onKeyUp="setValue('flashShow',this.value,'text')"></textarea><br /><br /> <input name="action" type="submit" value="Skapa"/> <div id="bannersRightShow"> Länkar till: <span id="linkShow" ></span> <br/> Ordningnummer: <span id="orderShow" ></span> <br/> Flashbanner: <span id="flashShow" ></span> <br/> <span id="imageShow" limit="1" maxWidth="250"></span> <br/> </div> <h2>Befintliga banners</h2> <?php $rightBannerQ = new Query("banners"); $rightBannerQ->whereLeftJoinImageQuery("*", "category", "right", "order_no", "ASC", 1); while ($row = mysql_fetch_assoc($rightBannerQ->getResult())) { echo "Ordningsnummer: " . $row['order_no'] . "<br />"; if (trim($row['bannersCode']) == "") { ?> <a href="admin_banners_edit.php?category=right&id=<?php echo $row['rowid']; ?> "><img src="<?php echo "../" . Settings::getUploadedImages() . '/' . $row['file']; ?> " width="250" /></a> <a href="admin_banners_action.php?category=right&action=remove&id=<?php echo $row['rowid']; ?> "><img src="graphics/remove.jpg" alt="Ta bort" width="10" border="0"/></a> <br />
<?php session_start(); require_once '../common/var.conf.php'; require_once DOCUMENT_ROOT . '/common/utils.php'; require_once DOCUMENT_ROOT . '/class/Smarty_HEHLan.class.php'; require_once DOCUMENT_ROOT . '/class/Database.class.php'; require_once DOCUMENT_ROOT . '/class/Auth.class.php'; require_once DOCUMENT_ROOT . '/class/Query.class.php'; $connected = false; $allowed = false; $chatIsActive = false; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } $sql = 'SELECT * FROM downloads ORDER BY published_date DESC'; $query = new Query($database, $sql); $query->execute(); $downloads = $query->getResult(); // send to the template $smarty->assign('con', $connected); $smarty->assign('downloads', $downloads); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/downloads.tpl');
?> </textarea><br /><br /> </td> </tr> <tr> <td colspan="2"><strong>Annonskategori</strong></td> </tr> <tr> <td colspan="2"> <label> <select name="category" id="category" class="field"> <?php $q2 = new Query("advertisement_categories"); $q2->makeQuery("*", "category", "DESC", 100); while ($row = mysql_fetch_assoc($q2->getResult())) { echo '<option value="' . $row['rowid'] . '">' . $row['category'] . '</option>'; } ?> </select> </label> <br /> <br /> </td> </tr> <tr> <td colspan="2"><strong>Verifieringskod</strong></td> </tr> <tr> <td colspan="2"><img src="scrambleImg.php"/></td> </tr>