PHP Query::getResultRow Examples

Example #1

File: ShowDemos.class.php Project: rocafuerte/opus

	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&auml;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>
			<?		 
		 }
	}

Example #2

File: Footer.class.php Project: rocafuerte/standard2

 public function setContent()
 {
     $q = new Query("matruschka");
     $this->content = '<span class="style2">';
     $this->content .= 'copyright © 2009 Mats &Aring;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>';
 }

Example #3

File: SiteAgree.class.php Project: rocafuerte/standard2

 /**
  * 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;
 }

Example #4

File: Archive.class.php Project: rocafuerte/opus_static

    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 
        }
    }

Example #5

File: ItaMenu.class.php Project: rocafuerte/standard2

 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);
     }
 }

Example #6

File: SiteStart.class.php Project: rocafuerte/standard2

 /**
  * 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 &Aring;berg';
     $ret .= '</strong></span></div>';
     $ret .= '</div>';
     return $ret;
 }

Example #7

File: AdminTextShow.class.php Project: rocafuerte/standard2

 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);
 }

Example #8

File: AdminGallery.class.php Project: rocafuerte/standard2

 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);
 }

Example #9

File: SiteTextShow.class.php Project: rocafuerte/standard2

 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;
 }

Example #10

File: Top.class.php Project: rocafuerte/standard2

 /**
  * 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 &Aring;berg" border="0" />';
     $this->header .= '</a>';
 }

Example #11

File: Main.class.php Project: rocafuerte/standard2

 /**
  * 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"));
     }
 }

Example #12

File: SiteGallery.class.php Project: rocafuerte/standard2

 /**
  * 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;
 }

Example #13

File: AdminAgree.class.php Project: rocafuerte/standard2

 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);
 }

Example #14

File: AdminStart.class.php Project: rocafuerte/standard2

 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);
 }

Example #15

File: AdminImageShow.class.php Project: rocafuerte/standard2

 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);
 }

Example #16

File: header_inc2.php Project: rocafuerte/opus_static

      Ta g&auml;rna en titt p&aring; några andra tidskrifter som vi p&aring;  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 

Example #17

File: vimmel.php Project: rocafuerte/opus_static

<?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 

Example #18

File: Review.class.php Project: rocafuerte/opus_static

    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 
        }
    }

Example #19

File: events.php Project: rocafuerte/opus_static

$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">

Example #20

File: admin_vimmel.php Project: rocafuerte/opus

<?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&aring; en bild f&ouml;r att l&auml;gga till en liten text.</h4>
<?php 
$rad = 0;
//altaernerar f&auml;rg
$images_per_row = 6;
$pagesize = 60;
$recordstart = (int) $_GET['recordstart'];
//&auml;ndra
$recordstart = isset($_GET['recordstart']) ? $_GET['recordstart'] : 0;
//&auml;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
?>

Example #21

File: MatruschkaOrganizer.class.php Project: rocafuerte/standard2

 /**
  * 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']);
 }

Example #22

File: market.php Project: rocafuerte/opus

    $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&auml;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>

Example #23

File: Matruschka.class.php Project: rocafuerte/standard2

 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();
 }

Example #24

File: subscription.php Project: rocafuerte/opus

<?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&aring; grund av &auml;ndrade rutiner skickas nytt nummer av tidningen fr&aring;n tryckeriet i samband med utgivning. Best&auml;ller du prenumeration efter det att vi skickat adressetiketterna till tryckeriet - vilket &auml;r cirka tio dar innan tidningen utkommer - startar din prenumeration med N&Auml;STKOMMANDE nummer.Vi har allt&aring; INGA exemplar av nya nummer p&aring; redaktionen. Aktuellt nummer finns naturligtvis till salu i tidningshandeln. <br />
	<br />
	G&aring; in p&aring; <span class="smallPink"><a href="http://www.interpress.se">http://www.interpress.se</a></span>, v&auml;lj tidskrifter och sen titels&ouml;kning f&ouml;r att se efter var du kan k&ouml;pa Close-Up i din hemstad.
	 <br/><br/>
	 <span class="boldGrey">Fyll i nedanst&aring;ende formul&auml;r och klicka p&aring; "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"/>';

Example #25

File: admin_subscribers.php Project: rocafuerte/opus

?>


<h2>Prenumeranter</h2>
<a href="?type=try">Prov prunumeranter</a> | <a href="?type=year">1 &aring;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");
    ?>

Example #26

File: top40_album.php Project: rocafuerte/opus

<?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 &amp; 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";

Example #27

File: admin_top.php Project: rocafuerte/opus

<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";

Example #28

File: Review.class.php Project: rocafuerte/opus

 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&Ouml;RFATTARE ';
             echo '</span>';
             echo Helper::text($query->getResultRow("writer"));
             echo '<br />';
         }
         if ($query->getResultRow("forlag")) {
             echo '<span class="infoTitle">';
             echo 'F&Ouml;RLAG ';
             echo '</span>';
             echo Helper::text($query->getResultRow("forlag"));
             echo '<br />';
         }
         echo '<span class="infoTitle">';
         echo 'BETYG';
         echo '</span>';
         echo '&nbsp;';
         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 '&nbsp;';
             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>';
     }
 }

Example #29

File: demorecensioner.php Project: rocafuerte/opus

<?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"));

Example #30

File: footer3.php Project: rocafuerte/opus_static

    }
}
$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");