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 setContent() { $q = new Query("matruschka"); $this->content = '<span class="style2">'; $this->content .= 'copyright © 2009 Mats Åberg | <a href="http://rocafuerte.se" target="self">rocafuerte design</a>' . "\n"; $this->content .= '<br/><br/>'; $q->whereCustom("*", "mShowStyle='Start' AND mLang='SWE'", "mRowid", "DESC", 1); if ($q->getResultRow("mPublished") == 1) { $this->content .= '<a href="?ID=' . $q->getResultRow("mRowid") . '">Swedish</a>'; } $q->whereCustom("*", "mShowStyle='Start' AND mLang='ENG'", "mRowid", "DESC", 1); if ($q->getResultRow("mPublished") == 1) { $this->content .= ' | <a href="?ID=' . $q->getResultRow("mRowid") . '">English</a>'; } $q->whereCustom("*", "mShowStyle='Start' AND mLang='ITA'", "mRowid", "DESC", 1); if ($q->getResultRow("mPublished") == 1) { $this->content .= ' | <a href="?ID=' . $q->getResultRow("mRowid") . '">Italian</a>'; } $q->whereCustom("*", "mShowStyle='Start' AND mLang='ESP'", "mRowid", "DESC", 1); if ($q->getResultRow("mPublished") == 1) { $this->content .= ' | <a href="?ID=' . $q->getResultRow("mRowid") . '">Spanish</a>'; } $q->whereCustom("*", "mShowStyle='Start' AND mLang='FRA'", "mRowid", "DESC", 1); if ($q->getResultRow("mPublished") == 1) { $this->content .= ' | <a href="?ID=' . $q->getResultRow("mRowid") . '">France</a>'; } $this->content .= '</span>'; }
/** * Denna kan se lite annorlunda ut eftersom det är en showStyle. * Det kanske inte innehåller specifik footer och header. */ public function showContent() { $q = new Query("matruschka"); $q->whereCustom("mRowid", "mShowStyle='Start' AND mLang='SWE'", "mRowid", "DESC", 1); $qq = new Query("matruschka"); $qq->whereImage("mShowStyle='Agree' ", "ASC", 1); $ret = '<div id="self">'; $ret .= '<div class="centerTextBox2"><img src="graphics/autograf.jpg" />'; $ret .= "</div>\n"; $ret .= '<div id="agree">'; $ret .= '<img src="admin/' . Settings::$uploaded_images . '/' . $qq->getResultRow("miFilename") . '" width="250" alt="Agree"/>'; $ret .= "</div>\n"; $ret .= '<div class="centerTextBox">'; $ret .= '<div class="alignRight">'; $ret .= '<span class="style1"><em>'; $ret .= $qq->getResultRow("imagesName"); $ret .= "</em></span></div>\n"; $ret .= '<p>'; $ret .= '<span class="style1"><strong>'; $ret .= '<br/>'; $ret .= $qq->getResultRow("mText"); $ret .= "</strong></span><br /><br />\n"; $ret .= '<a href="?ID=' . $q->getResultRow("mRowid") . '" target="_self"><img src="graphics/agree.gif" width="74" height="15" border="0" /></a>'; $ret .= "</p>\n"; $ret .= "</div>\n"; $ret .= "</div>\n"; return $ret; }
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 } }
private function getActive($id, $searched) { $q = new Query("matruschka"); $q->whereQuery("*", "mRowid", $id, "mRowid", "DESC", 0); if ($q->getResultRow("mRowid") == $searched) { return 1; } if ($q->getResultRow("mParent") == "") { return 0; } else { return $this->getActive($q->getResultRow("mParent"), $searched); } }
/** * 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->whereCustom("*", "mShowStyle='Start' AND mLang='" . $this->m->lang . "' AND mPublished='1'", "mRowid", "DESC", 1); $ret = '<img src="graphics/start_pic.jpg" />'; $ret .= '<div id="textBox1"><span class="style1">'; $ret .= $q->getResultRow("mDescription"); $ret .= '</span></div>'; $ret .= '<div id="textBox2"><span class="style1">'; $ret .= $q->getResultRow("mText"); $ret .= '<div class="alignRight"><span class="style2"><strong>'; $ret .= 'Mats Åberg'; $ret .= '</strong></span></div>'; $ret .= '</div>'; return $ret; }
public function setItems() { // Items at level $date = $this->matruschka ? $this->matruschka->pubDate : date("Y-m-d H:i:s"); // Order number $orderQ = new Query("matruschka"); if ($parent) { $orderQ->whereQuery("mOrderNo", "mParent", $parent, 'mOrderNo', 'DESC', 1); $order = $orderQ->getResultRow('mOrderNo') + 1; } else { $order = 1; } $orderNo = $this->matruschka ? $this->matruschka->orderNo : $order; $this->items[0][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild. 200 x _ px", 1); $this->items[0][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[0][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "KnappTitel (Mest för navigering i adminsidan)", 0); $this->items[0][] = new ItemButtonImage($this->matruschka->ID, $this->matruschka->buttonImage, "Knappbild t.ex (bild1.gif,bild2.gif)", 0); $this->items[0][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Text", 0); $this->items[0][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[0][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till menyraden.", 0); $this->items[1][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel", 0); $this->items[1][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[1][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till vänstermenyn.", 0); $this->items[2][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild. 200 x _ px", 1); $this->items[2][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel", 0); $this->items[2][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[2][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Text (All text här)", 0); $this->items[2][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[2][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till vänstermenyn.", 0); }
public function setItems() { // Items at level $date = $this->matruschka ? $this->matruschka->pubDate : date("Y-m-d H:i:s"); // Order number $orderQ = new Query("matruschka"); if ($_GET['parent']) { $orderQ->whereQuery("mOrderNo", "mParent", $_GET['parent'], 'mOrderNo', 'DESC', 1); $order = $orderQ->getResultRow('mOrderNo') + 1; } else { $order = 1; } $orderNo = $this->matruschka ? $this->matruschka->orderNo : $order; $this->items[0][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel", 0); $this->items[0][] = new ItemButtonImage($this->matruschka->ID, $this->matruschka->buttonImage, "Knappbild", 0); $this->items[0][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[0][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till menyraden.", 0); $this->items[1][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Ă–versta rubriken, ", 0); $this->items[1][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[1][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till rubriker.", 0); $this->items[2][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[2][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Bildspelstitel", 0); $this->items[2][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Texten", 0); $this->items[2][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[2][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till bildspel.", 0); $this->items[3][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[3][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild 400 x _ px ", 1); $this->items[3][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[3][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer.", 0); }
private function largeImg() { $q = new Query("matruschka"); $q->whereImage("mRowid = '" . $this->m->ID . "' ", "ASC", 1); $ret = '<div id="imageShow">'; if ($q->getResultRow("miFilename")) { $ret .= '<img src="admin/' . Settings::$uploaded_images . '/' . $q->getResultRow("miFilename") . '" alt="' . $q->getResultRow("mTitle") . '" width="394"/>'; } $ret .= '<br/>' . "\n"; $ret .= '<div id="imageInfo"><span class="imgTitle">' . $q->getResultRow("imagesName") . '</span><br/>' . "\n"; $ret .= '<span class="imgDesc">' . $q->getResultRow("mDescription") . '</span><br/>' . "\n"; $ret .= "</div>\n"; // imageInfo $ret .= "</div>\n"; // imageShow return $ret; }
/** * Fyll i manuellt vad som ska vara i headern. */ public function setHeader() { $q = new Query("matruschka"); $q->whereCustom("mRowid", "mShowStyle='Start' AND mLang='" . $this->m->lang . "'", "mRowid", "DESC", 1); $this->header = '<div id="top"><a href="?ID=' . $q->getResultRow($mRowid) . '" >'; $this->header .= '<img src="graphics/logo.gif" alt="Mats Åberg" border="0" />'; $this->header .= '</a>'; }
/** * Tilldelan matrushkan. Om inget ID finns så sätts den * till de som man bestämt skall vara förstasidan. */ private function setMatruschka() { if (eregi("^[0-9]{1,7}\$", $this->ID)) { $this->m = new Matruschka($this->ID); } else { $q = new Query('matruschka'); $q->whereCustom("mRowid", "mShowStyle='Agree' AND mLang='SWE'", "mRowid", "DESC", 1); $this->m = new Matruschka($q->getResultRow("mRowid")); } }
/** * 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 setItems() { // Items at level $date = $this->matruschka ? $this->matruschka->pubDate : date("Y-m-d H:i:s"); // Order number $orderQ = new Query("matruschka"); if ($parent) { $orderQ->whereQuery("mOrderNo", "mParent", $parent, 'mOrderNo', 'DESC', 1); $order = $orderQ->getResultRow('mOrderNo') + 1; } else { $order = 1; } $orderNo = $this->matruschka ? $this->matruschka->orderNo : $order; $this->items[0][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild. 250 x _ px", 1); $this->items[0][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel. (För adminsidan)", 1); $this->items[0][] = new ItemText($this->matruschka->ID, $this->matruschka->text, "Texten under bilden", 1); $this->items[0][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 1); }
public function setItems() { // Items at level $date = $this->matruschka ? $this->matruschka->pubDate : date("Y-m-d H:i:s"); // Order number $orderQ = new Query("matruschka"); if ($parent) { $orderQ->whereQuery("mOrderNo", "mParent", $parent, 'mOrderNo', 'DESC', 1); $order = $orderQ->getResultRow('mOrderNo') + 1; } else { $order = 1; } $orderNo = $this->matruschka ? $this->matruschka->orderNo : $order; $this->items[0][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[0][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Text till vänster", 0); $this->items[0][] = new ItemText($this->matruschka->ID, $this->matruschka->text, "Texten till höger", 0); $this->items[0][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); }
public function setItems() { // Items at level $date = $this->matruschka ? $this->matruschka->pubDate : date("Y-m-d H:i:s"); // Order number $orderQ = new Query("matruschka"); if ($_GET['parent']) { $orderQ->whereQuery("mOrderNo", "mParent", $_GET['parent'], 'mOrderNo', 'DESC', 1); $order = $orderQ->getResultRow('mOrderNo') + 1; } else { $order = 1; } $orderNo = $this->matruschka ? $this->matruschka->orderNo : $order; $this->items[0][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild 400 x _ px.", 1); $this->items[0][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Rubriktitel (för navigering på adminsidan)", 0); $this->items[0][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[0][] = new ItemButtonImage($this->matruschka->ID, $this->matruschka->buttonImage, "Knappbild (t.ex: bild1.gif,gid2.gif)", 0); $this->items[0][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "", 0); $this->items[0][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[0][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till menyraden.", 0); $this->items[1][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Rubriktitel", 0); $this->items[1][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[1][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Till vänstermenyn.", 0); $this->items[2][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel", 0); $this->items[2][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummerför underlänkarna i Menyn", 0); $this->items[2][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[3][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild. 400px bred", 1); $this->items[3][] = new ItemButtonTitle($this->matruschka->ID, $this->matruschka->buttonTitle, "Knapptitel (fyll endast i denna vid 3 nivåer)", 0); $this->items[3][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[3][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Beskrivningen under bilden.", 0); $this->items[3][] = new ItemText($this->matruschka->ID, $this->matruschka->text, "Texten bredvid bilden", 0); $this->items[3][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[3][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Numret som man trycker på. Nolla läggs till automatisk. Vid 3 nivåer i menyn blir det ordningsnumret i menyn.", 0); $this->items[4][] = new ItemImage($this->matruschka->ID, $this->matruschka->images, "Bild. 400px", 1); $this->items[4][] = new ItemTitle($this->matruschka->ID, $this->matruschka->title, "Titel", 0); $this->items[4][] = new ItemDescription($this->matruschka->ID, $this->matruschka->description, "Beskrivningen under bilden.", 0); $this->items[4][] = new ItemText($this->matruschka->ID, $this->matruschka->text, "Texten bredvid bilden", 0); $this->items[4][] = new ItemPublished($this->matruschka->ID, $this->matruschka->published, "Publicerad", 0); $this->items[4][] = new ItemOrderNo($this->matruschka->ID, $orderNo, "Ordningsnummer. Numret som man trycker på. Nolla läggs till automatisk.", 0); }
Ta gärna en titt på nĂĄgra andra tidskrifter som vi på gillar. Exempelvis <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-denimzine.asp target=_blank>Denimzine</a></span>, <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-ordfront.asp target=_blank>Ordfront</a></span>, <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-vagabond.asp target=_blank>Vagabond</a></span> och <span class="smallOrange"><a href=http://www.tidningsbutiken.se/tidningen-zero-music-magazine.asp target=_blank>Zero Magazine</a></span>.<br/><i>i samarbete med <span class="smallOrange"><a href=http://www.tidningsbutiken.se target=_blank>tidningsbutiken.se</a></span></i></span> </div> </div> </div> <div id="centerContainer"> <?php $newest = new Query("new"); $newest->whereAndLeftJoinImageQuery("*", "active", 1, "date", "DESC"); if ($newest->getNumRows() > 0) { ?> <div class="newestHeaderBig"></div> <div class="newestBig"> <table border="0" cellpadding="0" cellspacing="0" class="noBorder"> <tr> <td width="80" class="noPadding" rowspan="3"><a href="index.php?id=<?php echo $newest->getResultRow("rowid"); ?> "><img src="image_crop.php?source=<?php echo Settings::getUploadedImages() . '/' . $newest->getResultRow("file"); ?> &dest=&thumb_size=100" class="imgWhiteBorder" /></a></td> <td width="450" class="tdPadding" colspan="2"><span class="boldWhite"><a href="index.php?id=<?php echo $newest->getResultRow("rowid"); ?> "><?php echo $newest->getResultRow("title"); ?> </a></span></td> </tr> <tr> <td class="tdPadding" colspan="2"><span class="smallWhite"><a href="index.php?id=<?php
<?php include "header_inc.php"; ?> <div id="centerDiv"> <div class="newsBg"> <?php if (isset($_GET['category']) && Helper::isInt($_GET['category'])) { $category = new Query("vimmel_categories"); $category->whereQuery("*", "rowid", $_GET['category'], "date", "DESC", 1); echo '<span class="boldWhite">' . $category->getResultRow("title") . '</span><br />'; echo '<span class="smallWhite">' . nl2br($category->getResultRow("description")) . '</span>'; if (Helper::isInt($_GET['id']) && Helper::hasValue($_GET['id']) && Helper::givesResult("vimmel_images", "rowid", $_GET['id'])) { $query = new Query("vimmel_images"); $query->whereLeftJoinImageQuery("*", "rowid", $_GET['id'], "rowid", "ASC"); $image = new ShowImages($query); ?> <div class="showImg"> <br /> <table border="0" cellpadding="0" cellspacing="0"> <tr> <td><?php echo $image->showImage(350); ?> </td> </tr> <tr> <td align="right" class="smallGrey2"><?php
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 } }
$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> <td align="right" class="smallGrey2">
<?php include "admin_header.php"; $query = "SELECT * FROM vimmel_images WHERE image_id='" . $_GET['image_id'] . "' AND category='" . $_GET['category'] . "'"; $result = mysql_query($query) or die(mysql_error()); $rows = mysql_num_rows($result); if (isset($_GET['action']) && $_GET['action'] == "add_image" && $rows == 0) { $query = "INSERT INTO vimmel_images SET image_id='" . $_GET['image_id'] . "',category='" . $_GET['category'] . "', published_by='" . $_SESSION['admin_logged'] . "', date=CURRENT_TIMESTAMP"; $result = mysql_query($query) or die(mysql_error()); } $vimmelQ = new Query("vimmel_categories"); $vimmelQ->whereQuery("*", "rowid", $_GET['category'], "rowid", "ASC", 1); echo "<h2>" . $vimmelQ->getResultRow("title") . "</h2>"; echo nl2br($vimmelQ->getResultRow("description")); ?> <h4>Klicka på en bild för att lägga till en liten text.</h4> <?php $rad = 0; //altaernerar färg $images_per_row = 6; $pagesize = 60; $recordstart = (int) $_GET['recordstart']; //ändra $recordstart = isset($_GET['recordstart']) ? $_GET['recordstart'] : 0; //ändra recordstart variabelnamn $query = "SELECT * FROM vimmel_images \n\t\tLEFT JOIN bilder\n\t\tON image_id = bilder.id\n\t\tWHERE vimmel_images.category='" . $_GET['category'] . "'\n\t\tORDER BY vimmel_images.date DESC \n\t\tLIMIT " . $recordstart . " , " . $pagesize . " "; $result = mysql_query($query) or die(mysql_error()); //sidnummer under ?>
/** * Om man skapar ett barn */ private function createChild() { // hämta displaystyle $q = new Query('matruschka'); $q->whereQuery("*", 'mRowid', $this->parent, 'mRowid', "DESC", 1); $style = $q->getResultRow('mShowStyle'); $this->level = $q->getResultRow('mLevel') + 1; if ($style == "Agree") { $this->showStyle = new AdminAgree(); } else { if ($style == "ImageShow") { $this->showStyle = new AdminImageShow(); } else { if ($style == "TextShow") { $this->showStyle = new AdminTextShow(); } else { if ($style == "Start") { $this->showStyle = new AdminStart(); } else { if ($style == "Gallery") { $this->showStyle = new AdminGallery(); } else { if ($style == "Contact") { $this->showStyle = new AdminContact(); } } } } } } $this->showStyle->setParent($this->parent); $this->showStyle->setItems(); $this->showStyle->setupBelongingPlaces($_GET['lang']); $this->showStyle->setupShowAtPlaces($_GET['lang']); }
$paging->makePagingQuery(); } while ($row = mysql_fetch_assoc($paging->getResult())) { $getCategory = new Query("advertisement_categories"); $getCategory->whereQuery("*", "rowid", $row['category'], "rowid", "ASC", 1000); ?> <table border="0" cellpadding="0" cellspacing="0" class="demoTable"> <tr> <td class="tdPadding" colspan="2"><span class="boldGreyLighter"><?php echo $row['title']; ?> </span><span class="smallGrey"> - <?php echo $getCategory->getResultRow("category"); ?> </span><br /><br /> </td> </tr> <tr> <td width="126" class="tdVertBottom"><span class="smallPink"><a href="?id=<?php echo $row['rowid']; ?> ">Läs mer</a></span></td> <td width="164" class="tdVertBottom" align="right" ><span class="smallGrey"><?php echo date("Y-m-d H:i", strtotime($row['date'])); ?> </span></td> </tr>
public function set($ID) { $q = new Query("matruschka"); $q->whereQuery("*", "mRowid", $ID, "mRowid", "ASC", 1); $this->parent = $q->getResultRow("mParent"); $this->title = $q->getResultRow("mTitle"); $this->buttonTitle = $q->getResultRow("mButtonTitle"); $this->buttonImage = $q->getResultRow("mButtonImage"); $this->title = $q->getResultRow("mTitle"); $this->text = $q->getResultRow("mText"); $this->orderNo = $q->getResultRow("mOrderNo"); $this->level = $q->getResultRow("mLevel"); $this->description = $q->getResultRow("mDescription"); $this->pubDate = $q->getResultRow("mPubDate"); $this->published = $q->getResultRow("mPublished"); $this->adminLevel = $q->getResultRow("mAdminLevel"); $this->showStyle = $q->getResultRow("mShowStyle"); $this->lang = $q->getResultRow("mLang"); $this->setImages(); $this->setShowAtPlaces(); $this->setBelongingPlaces(); }
<?php include "header_inc.php"; ?> <div id="centerDiv"> <form action="subscription_action.php" method="POST"> <?php $pren = new Query("monthly_magazine"); $pren->makeQuery("number", "number", "DESC", 1); $PrenFromNumber = $pren->getResultRow("number") + 1; if ($_GET['type'] == 0) { ?> <span class="boldGrey">Betala via inbetalningskort</span> <br/><br /> På grund av ändrade rutiner skickas nytt nummer av tidningen från tryckeriet i samband med utgivning. Beställer du prenumeration efter det att vi skickat adressetiketterna till tryckeriet - vilket är cirka tio dar innan tidningen utkommer - startar din prenumeration med NÄSTKOMMANDE nummer.Vi har alltå INGA exemplar av nya nummer på redaktionen. Aktuellt nummer finns naturligtvis till salu i tidningshandeln. <br /> <br /> Gå in på <span class="smallPink"><a href="http://www.interpress.se">http://www.interpress.se</a></span>, välj tidskrifter och sen titelsökning för att se efter var du kan köpa Close-Up i din hemstad. <br/><br/> <span class="boldGrey">Fyll i nedanstående formulär och klicka på "Prenumerera".</span> <br /><br /> <?php $form = new Form(); echo "<strong>Namn</strong><br />" . $form->textField("name", $_GET['name'], "field") . "<br /><br />"; echo "<strong>Personnummer</strong><br />" . $form->textField("personal_number", $_GET['personal_number'], "field") . "<br /><br />"; echo "<strong>E-post</strong><br />" . $form->textField("email", $_GET['email'], "field") . "<br /><br />"; echo "<strong>Adress</strong><br />" . $form->textField("adress", $_GET['adress'], "field") . "<br /><br />"; echo "<strong>C/o</strong><br />" . $form->textField("co", $_GET['co'], "field") . "<br /><br />"; echo "<strong>Ort</strong><br />" . $form->textField("city", $_GET['city'], "field") . "<br /><br />"; echo "<strong>Postnummer</strong><br />" . $form->textField("zip", $_GET['zip'], "field") . "<br /><br />"; echo '<input type="hidden" value="0" name="PrenFromNumber"/>';
?> <h2>Prenumeranter</h2> <a href="?type=try">Prov prunumeranter</a> | <a href="?type=year">1 års prenumeranter</a> <br/> <br/> <?php if (isset($_GET['id'])) { $prenQ = new Query("pren"); $prenQ->whereQuery("*", "PrenId", $_GET['id'], "PrenId", "DESC", 1); ?> <table cellspacing="0" rules="rows" border="1" style="height:50px;border-collapse:collapse;"> <tr> <td>PrenId</td> <td><strong><?php echo $prenQ->getResultRow("PrenId"); ?> </strong></td> </tr> <tr> <td>PrenToName</td> <td><strong><?php echo $prenQ->getResultRow("PrenToName"); ?> </strong></td> </tr> <tr> <td>PrenToCO</td> <td><strong><?php echo $prenQ->getResultRow("PrenToCO"); ?>
<?php include "header_inc.php"; echo '<div id="centerDiv">'; echo '<div class="newsBg">'; if (isset($_GET['id']) && Helper::isInt($_GET['id']) && Helper::givesResult("personal", "rowid", $_GET['id'])) { $personal = new Query("personal"); $personal->whereQuery("*", "rowid", $_GET['id'], "rowid", "ASC", 1); $topQ = new Query("top40"); $topQ->whereQuery("*", "top40Username", $personal->getResultRow("username"), "top40ID", "ASC", 40); echo '<div class="newsHeaderActual">'; echo '<span class="newsHeaderFont">'; echo 'Topplistan cd & dvd, ' . $personal->getResultRow("first_name") . ' ' . $personal->getResultRow("last_name"); echo '</span>'; echo '</div>'; echo '<br/>'; echo "<ol >"; while ($row = mysql_fetch_object($topQ->getResult())) { echo '<li style="font-weight:bold">'; echo $row->top40Group . ' - <span style="color:#000000;">' . $row->top40Album . '</span>'; echo '</li>'; } echo "</ol>"; } echo '</div>'; echo '</div>'; include "footer.php";
<form action="<?php $_SERVER['PHP_SELF']; ?> " method="post"> <h2>Topp 40</h2> Grupp - Album <ol> <?php $form = new Form(); $q = new Query("top40"); for ($i = 1; $i <= 40; $i++) { $q->whereCustom("*", "top40Username = '******'admin_logged'] . "' AND top40ID = '{$i}' ", "top40ID", "ASC", 100); $group = htmlspecialchars($q->getResultRow("top40Group"), ENT_QUOTES); $album = htmlspecialchars($q->getResultRow("top40Album"), ENT_QUOTES); echo '<li>' . $form->textField("group[]", $group, "field") . " - " . $form->textField("album[]", $album, "field") . '</li>'; } ?> </ol> <input type="submit" name="action" value="Uppdatera"/> </form> <?php if ($_POST['action'] == "Uppdatera") { echo "Uppdaterat!"; } echo '<br /><br /><a href="admin_personal.php">Tillbaka</a>'; include "admin_footer.php";
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"; ?> <div id="centerDiv"> <?php if (Helper::hasValue($_GET['demo_id'])) { $query = new Query("demos"); $query->customImage("*", "rowid = " . $_GET['demo_id'] . " AND active='1'", "date", "ASC", 1); ?> <div class="newsHeader"><span class="smallGrey"><?php echo date("Y-m-d", strtotime($query->getResultRow("date"))); ?> </span> <br /> <span class="newsHeaderSmaller"><?php echo $query->getResultRow("name"); ?> </span></div> <div class="newsPicActual"> <?php if ($query->getResultRow("image_id") > 0) { ?> <table><tr><td> <?php echo Image::displayImage($query->getResultRow("file"), 340, "", $query->getResultRow("name"));
} } $radioQ = new Query("radio_songs"); $radioQ->makeQuery("*", "rowid", "ASC", 1); if ($radioQ->getNumRows() > 0) { ?> <div class="rightCenterDivFlow"><a href="#" onclick="MM_openBrWindow('radio.php','Radio','width=300,height=400,resizable=no')" ><img src="graphics/radio.gif" border="0" alt=""/></a></div> <hr class="hr2" noshade="noshade" /><br /> <?php } $demoQ = new Query("demos"); $demoQ->whereLeftJoinImageQuery("*", "week_demo", 1, "date", "DESC", 1); if ($demoQ->getNumRows() > 0) { ?> <div class="rightCenterDivFlow"><a href="demorecensioner.php?demo_id=<?php echo $demoQ->getResultRow("rowid"); ?> "><img src="graphics/veckansDemoband_title.gif" border="0" alt="Veckans demoband" /></a><br /> <?php if (Helper::hasValue($demoQ->getResultRow("image_id"))) { echo '<a href="demorecensioner.php?demo_id=' . $demoQ->getResultRow("rowid") . '" target="_self">'; echo Image::displayImage($demoQ->getResultRow("file"), 198, "imgWhiteBorder", $demoQ->getResultRow("name")); echo '</a>'; } ?> <br /> <span class="smallGrey"><a href="demorecensioner.php?demo_id=<?php echo $demoQ->getResultRow("rowid"); ?> "><?php echo $demoQ->getResultRow("description");