public function listEntryPlaces($class) { $entryPlaces = new Query("entryPlaces"); $entryPlaces->makeQuery("*", "pubDate", "DESC", 0); echo '<table class="' . $class . '">'; echo '<th align="left">Titel</th><th align="left">Beskrivning</th> <th align="left">Uppdaterad senast</th><th align="left">Ändra</th><th align="left">Ta bort</th>'; while ($row = mysql_fetch_object($entryPlaces->getResult())) { echo '<tr> <td>' . strip_tags($row->title) . '</td> <td>' . strip_tags($row->description) . '</td> <td>' . $row->updateDate . '</td> <td><a href="?action=edit&entryPlaceTitle=' . $row->title . '">Ändra</a></td> <td><a href="?action=delete&entryPlaceTitle=' . $row->title . '">Ta bort</a></td> </tr>'; } echo '</table>'; }
<?php } ?> <br /> <br /> <div class="thumbnailContainer"> <?php if (Helper::isInt($_GET['category'])) { $query = new Query("vimmel_images"); $query->whereLeftJoinImageQuery("*", "category", $_GET['category'], "date", "DESC"); // Dont forget the Javascript (effect.js)!!! $images = new ShowImages($query); $images->closeupVimmelThumbs($query, 50); } ?> </div> <?php } // if(isset($_GET['category']) end $categories = new Query("vimmel_categories"); $categories->makeQuery("*", "date", "DESC", 10000); echo '<span class="boldPink">Bildgalleri</span><span class="smallWhite"></span><br /><br />'; while ($row = mysql_fetch_object($categories->getResult())) { echo '<span class="boldWhite"><a href="?category=' . $row->rowid . '">' . $row->title . '</a></span><br /><br />'; } ?> </div> </div> <?php include "footer.php";
</a></span></p> </div> <br /> <hr /> <br /> <br /> <?php } $paging; $query = new Query("advertisement"); if (isset($_GET['category'])) { $query->whereQuery("*", "category", $_GET['category'], "date", "DESC", 1000); $paging = new Paging($query, 20); $paging->where("*", "category", $_GET['category'], "date", "DESC"); } else { $query->makeQuery("*", "date", "DESC", 100); $paging = new Paging($query, 20); $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 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"/>';
<?php include "admin_header.php"; ?> <h2>Köp och sälj</h2> <?php $query = new Query("advertisement"); $query->makeQuery("*", "rowid", "DESC", 1000); $paging = new Paging($query, 40); $paging->makePagingQuery(); ?> <table border="0" cellpadding="1" cellspacing="1" width="500"> <?php while ($row = mysql_fetch_assoc($paging->getResult())) { $getCategory = new Query("advertisement_categories"); $getCategory->whereQuery("*", "rowid", $row['category'], "rowid", "ASC", 100); ?> <tr> <td align="left" ><span class="boldGreyLighter"><?php echo $row['title']; ?> </span><span class="smallGrey"> - <?php echo $getCategory->getResultRow("category"); ?> </span></td> <td align="left"><span class="smallGrey"><?php echo $row['date']; ?> </span></td> <td align="right"><a href="admin_market_action.php?action=remove&id=<?php
"><?php echo $row->description; ?> </a></span><br /> <span class="smallOrange"><a href="tavlingar.php?id=<?php echo $row->rowid; ?> ">Tävla!</a></span> <br /> <br /> <hr class="hr2" noshade="noshade" /> </div> <?php } } $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
<?php include "header_inc.php"; ?> <div id="centerDiv"> <div class="newsBg"> <?php $tv = new Query("youtube"); $tv->makeQuery("*", "date", "DESC", 200); $tvPaging = new Paging($tv, 6); $tvPaging->makePagingQuery(); ?> <table width="100%"><tr><td align="left"> </td><td align="right" valign="bottom"> <?php $tvPaging->displayLinks("se", "smallPink", "smallGrey"); ?> </td></tr></table> <br /> <hr class="hr2"/><br /> <?php while ($row = mysql_fetch_assoc($tvPaging->pagingResult)) { echo '<span class="rightCenterDivTitle">' . $row['name'] . '</span><br />'; echo $row['code'] . "<br/><br/>"; } $tvPaging->displayLinks("se", "smallPink", "smallGrey"); ?> </div>
echo $query->getResultRow("album2"); echo '</li>'; echo '<li>'; echo $query->getResultRow("album3"); echo '</li>'; echo '</ul>'; echo '<br />'; echo '<strong>'; echo 'Sysselsättning'; echo '</strong>'; echo '</p>'; echo '<p>'; echo Helper::text($query->getResultRow("description")); echo '<br />'; } $query = new Query("personal"); $query->makeQuery("*", "last_name", "ASC", 1000); while ($row = mysql_fetch_assoc($query->getResult())) { if ($row['first_name'] != "" && $row['last_name'] != "") { echo '<span class="smallPink">'; echo '<a href="?id=' . $row['rowid'] . '">'; echo $row['first_name'] . " " . $row['last_name']; echo '</a>'; echo '<br />'; echo '<hr />'; echo '</span>'; } } echo '</div>'; echo '</div>'; include "footer.php";
<input name="title" type="text" size="50" /> <h4>Beskrivning</h4> <textarea name="description" cols="50" rows="10"></textarea><br/> <h4>Datum</h4> <input name="date" maxlength="19" type="text" value="<?php echo date("Y-m-d h:i:s"); ?> "><br/><br/> <input name="action" type="submit" value="Skapa"> </form> <?php } ?> <br/> <br/> <h4>Gå in i en grupp och lägg till bilder.</h4> <table> <th align="left">Kategorier</th><th> </th><th> </th> <?php $vimmelQ = new Query("vimmel_categories"); $vimmelQ->makeQuery("*", "date", "DESC", 10000); while ($row = mysql_fetch_object($vimmelQ->getResult())) { echo '<tr><td><a href="admin_vimmel.php?category=' . $row->rowid . '">' . $row->title . '</td><td><a href="?action=edit&id=' . $row->rowid . '">Ändra</a></td><td><a href="admin_vimmel_action.php?action=removecategory&id=' . $row->rowid . '"<img src="graphics/remove.jpg" border="0" width="10"/></td></tr>'; } echo '</table>'; if ($_GET['action'] == "edit") { echo '<br/>'; echo '<br/>'; echo '<a href="admin_vimmel_categories.php">Tillbaka'; } include "admin_footer.php";
public function listEmails() { echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="POST">'; $form = new Form(); $q = new Query("emails"); $q->makeQuery("*", "email", "DESC", 0); echo '<table><th align="left">E-mail</th><th>Ta bort</th>' . "\n"; while ($row = mysql_fetch_object($q->getResult())) { echo '<tr><td align="left"><input name="emails[]" checked="checked" type="checkbox" value="' . $row->email . '"/>' . $row->email . '</td><td><a href="?entry=' . $this->entry_id . '&category=' . $this->category_id . '&action=delete&email=' . $row->email . '">Ta bort</a></td></tr>' . "\n"; } echo '</table><br />'; echo $form->hiddenField("category", $this->category_id); echo $form->hiddenField("entry", $this->entry_id); echo $form->submitButton("myClass", "Skicka"); echo '</form>'; }