public function listDemos(Paging $paging){ while($row = mysql_fetch_assoc($paging->pagingResult)){ if($row['rowid']==$_GET['demo_id']) continue; // Got to make a new query beacuse of error in mysql_fetch_assoc $query = new Query($this->q->getTable()); $query->whereLeftJoinImageQuery("*","image_id",$row['image_id'],"rowid","ASC"); $image_id = $query->getResultRow("image_id"); $file_name=$query->getResultRow("file"); ?> <table border="0" cellpadding="0" cellspacing="0" class="demoTable"> <tr> <?php if(Helper::hasValue($image_id)){ ?> <td width="80" class="noPadding" rowspan="2"><img src="image_crop.php?source=<?php echo Settings::getUploadedImages().'/'.$file_name ?>&dest=&thumb_size=80" class="flowPic" /></td> <?php } ?> <td width="270" class="tdPadding" colspan="2"><span class="boldGrey"><?php echo $row['name']; ?></span></td> </tr> <tr> <td class="tdVertBottom"><span class="smallPink"><a href="?demo_id=<?php echo $row['rowid']; ?>">Läs mer</a></span></td> <td align="right" class="tdVertBottom"><span class="smallGrey"><?php echo date("Y-m-d",strtotime($row['date'])); ?></span></td> </tr> </table> <? } }
public function showActual() { $id = (int) $_GET['id']; if (Helper::givesResult($this->table, "rowid", $id)) { $q = new Query($this->table); $q->whereLeftJoinImageQuery("*", "rowid", $id, "rowid", "DESC"); $personal = new Query("personal"); $personal->whereQuery("*", "username", $q->getResultRow("published_by"), "rowid", "ASC", "1"); ?> <div class="newsHeader"><span class="dateAuthor"> <?php echo date("Y-m-d", strtotime($q->getResultRow("date"))) . ' ' . $personal->getResultRow("first_name") . ' ' . $personal->getResultRow("last_name"); ?> </span><br /><br /> <span class="newsHeaderFont"><?php echo $q->getResultRow("title"); ?> </span> </div> <div class="newsDescActual"><span class="boldGrey"><?php echo nl2br(strip_tags($q->getResultRow("description"), '<a><b><br><strong>')); ?> </span></div> <div class="newsPicActual"> <?php if ($q->getResultRow("image_id") > 0) { ?> <table><tr><td> <?php echo '<img src="image_thumb.php?source=' . Settings::getUploadedImages() . '/' . $q->getResultRow("file") . '&width=340" alt="' . $q->getResultRow("name") . '" />'; ?> </td> </tr> <tr> <td align="right" class="smallGrey2"> <?php if ($q->getResultRow("photo") != "") { echo '<span class="smallGrey">Foto: ' . $q->getResultRow("photo") . '</span>'; } ?> </td> </tr> </table> <?php } ?> </div> <?php echo nl2br(strip_tags($q->getResultRow("text"), '<a><b><br><strong>')); ?> <br /><br /> <?php } }
<div class="thumbnailDesc"><span class="smallWhite"><?php echo Helper::text($query->getResultRow("description")); ?> </span><br /><br /> </div> </div> <?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 />';
public function showReview() { if (Helper::hasValue($_GET['id'])) { $query = new Query($this->q->getTable()); $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "date", "ASC"); ?> <div class="newsHeader"><span class="dateAuthor"><?php echo date("y-m-d", strtotime($query->getResultRow("date"))); ?> </span> <br /> <span class="newsHeaderSmaller"><?php echo $query->getResultRow("title"); ?> </span></div> <div class="showImg"> <?php if (Helper::hasValue($query->getResultRow("image_id"))) { ?> <table><tr><td> <?php echo Image::displayImage($query->getResultRow("file"), 340, "", $query->getResultRow("name")); ?> </td> </tr> <tr> <td align="right" class="smallGrey2"> <?php if ($query->getResultRow("photo") != "") { echo '<span class="smallGrey">Foto: ' . $query->getResultRow("photo") . '</span>'; } ?> </td> </tr> </table> <?php } ?> </div> <div class="textContainer"><?php echo nl2br($query->getResultRow("text")); ?> <br /><br /> <!-- <a href="<?php echo $query->getResultRow("link_url"); ?> "><?php echo $query->getResultRow("link_url"); ?> </a> <br /><br />--> <span class="smallGrey"> <?php $personalInfo = new Query("personal"); $personalInfo->whereQuery("*", "username", $query->getResultRow("published_by"), "username", "ASC", 1); echo "Av: " . $personalInfo->getResultRow("first_name") . " " . $personalInfo->getResultRow("last_name"); ?> </span> </div> <?php } }
$place = isset($_GET['place']) && $_GET['place'] != "" && Helper::isText($_GET['place']) ? $_GET['place'] : "%"; $artist = isset($_GET['artist']) && $_GET['artist'] != "" && Helper::isText($_GET['artist']) ? $_GET['artist'] : "%"; $pagesize = 80; $recordstart = (int) $_GET['recordstart']; $recordstart = isset($_GET['recordstart']) ? $_GET['recordstart'] : 0; $query = "select * from spelningar WHERE stad LiKE '" . $city . "' AND artist LIKE '" . $artist . "' AND lokal LIKE '" . $place . "' AND datum LIKE '" . $date . "' AND datum >= NOW() ORDER BY `datum` "; //ASC LIMIT ".$recordstart." , ".$pagesize." $result = mysql_query($query); ?> <div id="centerDivBig"> <?php if (isset($_GET['id']) && Helper::IsInt($_GET['id'])) { $query = new Query("spelningar"); $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "rowid", "ASC", 1); $day = Helper::sweDay(date("w", strtotime($query->getResultRow("datum")))); $day_no = date("j", strtotime($query->getResultRow("datum"))); $month = Helper::sweMonth(date("n", strtotime($query->getResultRow("datum")))); $year = date("Y", strtotime($query->getResultRow("datum"))); //Helper::sweDay($day).' '.date("d").' '.Helper::sweMonth(date("n")).' '.date("Y") echo '<span class="boldGrey">' . $query->getResultRow("artist") . '</span><br /><br />'; if ($query->getResultRow("image_id") > 0) { ?> <table><tr><td> <?php echo Image::displayImage($query->getResultRow("file"), 542, "", $query->getResultRow("name")); ?> </td> </tr> <tr>
<h4>object-code (endast för Flashbanners, lägg .swf filerna i mappen media/uploaded_flash) - Klicka på HTML och skriv in koden. (Kommer inte att synas i fältet nedan)</h4> <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>
</head> <body onload="div.init()"> <div id="pageCell"> <div id="topDiv"> <iframe src="bg_sound.php" style="width:1px; height:0px; border: 0px" scrolling="no"> </iframe> <a href="/" target="_self"><img src="graphics/CU-logo-black-background.gif" border="0" align="left" /></a> <table border="0" cellpadding="0" cellspacing="0" align="right" width="100"> <tr> <td class="tdVertTop"><!--<img src="graphics/annonspilVertical.gif" />--> </td> <td class="tdVertTop"> <?php $topBannerQ = new Query("banners"); $topBannerQ->whereLeftJoinImageQuery("*", "category", "top", "date", "ASC", 1); while ($row = mysql_fetch_assoc($topBannerQ->getResult())) { if (trim($row['bannersCode']) == "") { ?> <a href="<?php echo $row['link']; ?> " target="<?php echo $row['target']; ?> "> <img src="<?php echo Settings::getUploadedImages() . '/' . $row['file']; ?> " width="760" class="topBanners"/> </a>
public function showReview() { if (Helper::hasValue($_GET['id'])) { $query = new Query($this->q->getTable()); $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "date", "ASC"); echo '<div class="reviewActual">'; echo '<div class="title">'; echo Helper::text($query->getResultRow("title")); echo '</div>'; echo '<div class="title2">'; echo Helper::text($query->getResultRow("title2")); echo '</div>'; if (Helper::hasValue($query->getResultRow("image_id"))) { echo Image::displayImage($query->getResultRow("file"), 311, "", $query->getResultRow("name")); } echo '<div class="description">'; echo '<br/>'; echo Helper::text($query->getResultRow("text")); echo '</div>'; echo '<div class="info">'; echo '<span class="custom">'; echo '<span class="infoTitle">'; echo '</span>'; echo Helper::text($query->getResultRow("info")); echo '<br />'; if ($query->getResultRow("solist")) { echo '<span class="infoTitle">'; echo 'SOLIST '; echo '</span>'; echo Helper::text($query->getResultRow("solist")); echo '<br />'; } if ($query->getResultRow("dirigent")) { echo '<span class="infoTitle">'; echo 'DIRIGENT '; echo '</span>'; echo Helper::text($query->getResultRow("dirigent")); echo '<br />'; } if ($query->getResultRow("sacd")) { echo '<span class="infoTitle">'; echo 'SACD '; echo '</span>'; echo Helper::text($query->getResultRow("sacd")); echo '<br />'; } if ($query->getResultRow("cd")) { echo '<span class="infoTitle">'; echo 'CD '; echo '</span>'; echo Helper::text($query->getResultRow("cd")); echo '<br />'; } if ($query->getResultRow("writer")) { echo '<span class="infoTitle">'; echo 'FÖRFATTARE '; echo '</span>'; echo Helper::text($query->getResultRow("writer")); echo '<br />'; } if ($query->getResultRow("forlag")) { echo '<span class="infoTitle">'; echo 'FÖRLAG '; echo '</span>'; echo Helper::text($query->getResultRow("forlag")); echo '<br />'; } echo '<span class="infoTitle">'; echo 'BETYG'; echo '</span>'; echo ' '; if ($query->getResultRow("betyg") == 6) { for ($i = 0; $i < $query->getResultRow("betyg"); $i++) { echo '<img src="graphics/filled_star_lila.gif" width="10" height="10" />'; } } else { for ($i = 0; $i < $query->getResultRow("betyg"); $i++) { echo '<img src="graphics/filled_star.gif" width="10" height="10" />'; } } echo '<br />'; if ($query->getResultRow("ljud")) { echo '<span class="infoTitle">'; echo 'LJUDKVALITET'; echo '</span>'; echo ' '; for ($i = 0; $i < $query->getResultRow("ljud"); $i++) { echo '<img src="graphics/filled_star.gif" width="10" height="10" />'; } echo '</span>'; } echo '<div class="author">'; echo $query->getResultRow("published_by"); echo '</div>'; echo '</div>'; echo '</div>'; } }
<?php include "header_inc.php"; echo '<div id="centerDiv">'; echo '<div class="newsBg">'; echo '<div class="newsHeaderActual">'; echo '<span class="newsHeaderFont">'; echo 'Skribenterna på OPUS'; echo '</span>'; echo '</div>'; echo '<br />'; if (Helper::isInt($_GET['id']) && Helper::hasValue($_GET['id']) && Helper::givesResult("personal", "rowid", $_GET['id'])) { $query = new Query("personal"); $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "last_name", "DESC"); if (Helper::hasValue($query->getResultRow("image_id"))) { echo '<img src="image_thumb.php?source=' . Settings::getUploadedImages() . '/' . $query->getResultRow("file") . '&width=200" />'; } echo '<br />'; echo '<br />'; echo '<p>'; echo '<strong>'; echo $query->getResultRow("first_name") . " " . $query->getResultRow("last_name"); echo '</strong>'; echo '</p>'; echo '<br />'; echo '<p>'; echo '<strong>'; echo 'Bäst just nu'; echo '</strong>'; echo '</p>'; echo '<ul style="list-style:decimal; margin-left:20px";>';
<?php include "admin_header.php"; $banners = new Query("banners"); $banners->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "order_no", "ASC", 1); ?> <form action="admin_banners_action.php" method="POST" name="banners" > <h4>Länk</h4> <input name="link" id="link" type="text" onKeyUp="setValue('linkShow',this.value,'link')" value="<?php echo $banners->getResultRow("link"); ?> "/> <h4>Öppnas i</h4> <select name="target"> <option value="_self" <?php if ($banners->getResultRow("target") == "_self") { echo "selected"; } ?> >Samma fönster</option> <option value="_blank" <?php if ($banners->getResultRow("target") == "_blank") { echo "selected"; } ?> >Nytt fönster</option> </select> <h4>Ordningsnummer</h4> <input name="order" id="order" type="text" maxlength="2" onKeyUp="setValue('orderShow',this.value,'text')" value="<?php echo $banners->getResultRow("order_no");
<?php include "header_inc.php"; echo '<div id="centerDiv">'; echo '<div class="newsBg">'; $id = (int) $_GET['id']; if (Helper::givesResult("competitions", "rowid", $id)) { $query = new Query('competitions'); $query->whereLeftJoinImageQuery("*", "rowid", $id, "rowid", "DESC"); echo '<div class="newsHeader">'; echo '<span class="newsHeaderFont">'; echo $query->getResultRow("title"); echo '</span>'; echo '</div>'; echo '<div class="newsDescActual">'; echo '<span class="boldGrey">'; echo Helper::text($query->getResultRow("description")); echo '</span>'; echo '</div>'; echo '<div class="newsPicActual">'; if ($query->getResultRow("image_id") > 0) { echo '<table>'; echo '<tr>'; echo '<td>'; echo Image::displayImage($query->getResultRow("file"), 315, "", $query->getResultRow("name")); echo '</td>'; echo '</tr>'; echo '<tr>'; echo '<td align="right" class="smallGrey2">'; if ($query->getResultRow("photo") != "") { echo '<span class="smallGrey">Foto: ' . $query->getResultRow("photo") . '</span>';