$songs = new Query("demo_songs"); $songs->whereQuery("*", "demo_id", $_GET['demo_id'], "demo_id", "ASC", 1); if ($songs->getNumRows() > 0) { ?> <embed src="jw_mp3_player/mp3player.swf" width="320" height="140" allowfullscreen="true" allowscriptaccess="always" flashvars="&file=jw_mp3_player/mysql_playlist_demo.php?demo_id=<?php echo $_GET['demo_id']; ?> &height=140&width=320&displaywidth=120" /> <?php } ?> </div> <div class="textContainer"><?php echo Helper::text($query->getResultRow("text")); ?> <br /><br /> <a href="<?php echo $query->getResultRow("link_url"); ?> "><?php echo $query->getResultRow("link_url"); ?> </a> <br /> </div> <?php
<?php include "admin_header.php"; $query = "SELECT * FROM vimmel_images \n\t\tLEFT JOIN bilder\n\t\tON vimmel_images.image_id = bilder.id\n\t\tWHERE vimmel_images.rowid='" . $_GET['id'] . "'"; $result = mysql_query($query) or die(mysql_error()); ?> <form action="admin_vimmel_action.php" method="post"> <?php while ($row = mysql_fetch_assoc($result)) { echo '<img src="../image_thumb.php?source=' . $uploaded_images . '/' . $row['file'] . '&width=340" border="0" />'; ?> <br /> <textarea name="description" cols="50" rows="5"><?php echo Helper::text($row['description']); ?> </textarea> <input type="hidden" name="id" value="<?php echo $_GET['id']; ?> " /> <input type="hidden" name="category" value="<?php echo $_GET['category']; ?> " /> <?php } ?> <br/> <br/>
?> </td> </tr> <tr> <td align="right" class="smallGrey2"><?php if ($query->getResultRow("photo") != "") { echo 'Foto: ' . $query->getResultRow("photo") . '</span>'; } ?> </td> </tr> </table> <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)!!!
</div> <h4>Titel</h4> <input name="title" maxlength="50" id="title" size="50" type="text" value="<?php echo htmlspecialchars($title, ENT_QUOTES); ?> " onKeyUp="setValue('titleShow',this.value,'title')"/> <br/> <h4>Beskrivning</h4> <textarea name="description" cols="50" rows="5" id="description" onKeyUp="setValue('descriptionShow',this.value,'text')"><?php echo Helper::text($description); ?> </textarea> <br /> <h4>Själva texten</h4> <textarea name="text" cols="50" rows="15" id="text" onKeyUp="setValue('textShow',this.value,'text')"><?php echo Helper::text($text); ?> </textarea> <br/> <h4>Färg</h4> Vit <input type="radio" <?php echo $color == "white" ? "checked" : ""; ?> value="white" name="color"/> Svart <input type="radio" <?php echo $color == "black" ? "checked" : ""; ?> value="black" name="color"/> <br />
<?php include "header_inc.php"; ?> <div id="centerDiv"> <div class="newsBg"> <span class="newsHeaderSmaller">Tävlingsvinnare</span><br><br> <?php setlocale(LC_ALL, 'sv_SE'); $query = "SELECT * FROM competition_answers \n\t\tLEFT JOIN competitions\n\t\tON competition_answers.answerComp_id = competitions.rowid\n\t\tWHERE competition_answers.answerWinner='1'\n\t\tGROUP BY competitions.title\n\t\tORDER BY competitions.date DESC\n\t\tLIMIT 0,25"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_object($result)) { echo '<span class="boldPink">' . strtoupper($row->title) . '</span><br/>'; if (trim($row->answer) != "") { echo '<span class="boldGrey">Svar: </span>' . Helper::text($row->answer) . '<br />'; } echo '<span class="boldGrey">Vinnare </span><br/>'; $query2 = "SELECT * FROM competition_answers WHERE answerWinner=1 AND answerComp_id='" . $row->rowid . "'"; $result2 = mysql_query($query2) or die(mysql_error()); while ($row2 = mysql_fetch_object($result2)) { echo '<span class="">' . $row2->answerName . ' - ' . $row2->answerCity . '</span><br/>'; } echo '<br/>'; } ?> </div> </div> o include "footer.php" ?>
$query = "UPDATE personal SET first_name='" . $_POST['first_name'] . "', last_name='" . $_POST['last_name'] . "', \n\t\t\tdescription='" . $_POST['description'] . "', email='" . $_POST['email'] . "', personalImage='{$imageFilename}'\n\t\t\tWHERE username='******'admin_logged'] . "'"; $result = mysql_query($query) or die(mysql_error()); } echo "<h2>" . $_SESSION['admin_logged'] . "</h2>"; ?> <div id="personalForm"> <?php $query = "SELECT * \n\t\tFROM personal\n\t\tWHERE personal.username='******'admin_logged'] . "'"; $result = mysql_query($query) or die(mysql_error()); $imageFilename = mysql_result($result, 0, 'personalImage'); $first_name = mysql_result($result, 0, 'first_name'); $last_name = mysql_result($result, 0, 'last_name'); $email = mysql_result($result, 0, 'email'); $description = Helper::text(mysql_result($result, 0, 'description')); ?> <div id="personalForm"> <form action="<?php echo $_SERVER['PHP_SELF']; ?> " method="POST" name="personal"> <div id="imageShow" limit="1" maxWidth="100"> <?php /* if($imageFilename!=""){
echo '<span id="' . $obj->s_imageID . '">' . "\n"; echo '<img src="image_thumb.php?source=../' . $uploaded_images . '/' . $obj->file . '&width=340" />' . "\n"; echo '<a href="#" removeImageId="' . $obj->s_imageID . '" >' . "\n"; echo '<img src="graphics/minus.jpg" width="10" border="0" alt="Ta bort"/>' . "\n"; echo '</a>' . "\n"; echo '<input type="hidden" name="imageArray[]" id="' . $obj->s_imageID . '" value="' . $obj->s_imageID . '" />' . "\n"; echo '</span>' . "\n"; } echo '</span>' . "\n"; echo '<span id="imageShow" limit="1" maxWidth="340" maxHeight="200"></span> <br/><br />'; echo '<h3>Artikel</h3>'; echo '<input size="60" type="field" name="title" value="' . htmlspecialchars($obj->s_title, ENT_QUOTES) . '"/>'; echo '<h3>Pris</h3>'; echo '<input size="60" type="field" name="price" value="' . $obj->s_price . '"/>'; echo '<h3>Text</h3>'; echo '<textarea cols="60" name="text">' . Helper::text(htmlspecialchars($obj->s_text, ENT_QUOTES)) . '</textarea>'; echo '<br/>'; echo '<h3>Ordnigsnummer</h3>'; echo '<input size="60" type="field" name="orderNo" value="' . $obj->s_orderNo . '"/>'; echo '<input type="hidden" name="ID" value="' . $obj->s_rowID . '"/>'; echo '<br/>'; echo '<br/>'; if ($_GET['parent'] != "") { echo '<input type="hidden" name="parent" value="' . $_GET['parent'] . '" />'; echo '<input type="submit" name="action" value="Skapa" />'; } else { echo '<input type="submit" name="action" value="Uppdatera" />'; } echo '<br/>'; break; case 3:
$query = "SELECT * FROM recensioner \n\t\tLEFT JOIN bilder\n\t\tON recensioner.image_id = bilder.id\n\t\tWHERE rowid='" . $_GET['id'] . "'\n\t\tORDER BY recensioner.date ASC"; $result = mysql_query($query) or die(mysql_error()); $id = mysql_result($result, 0, "rowid"); $title = mysql_result($result, 0, "title"); $description = Helper::text(mysql_result($result, 0, "description")); $text = Helper::text(mysql_result($result, 0, "text")); $dirigent = Helper::text(mysql_result($result, 0, "dirigent")); $info = Helper::text(mysql_result($result, 0, "info")); $solist = Helper::text(mysql_result($result, 0, "solist")); $sacd = Helper::text(mysql_result($result, 0, "sacd")); $betyg = Helper::text(mysql_result($result, 0, "betyg")); $ljud = Helper::text(mysql_result($result, 0, "ljud")); $writer = Helper::text(mysql_result($result, 0, "writer")); $forlag = Helper::text(mysql_result($result, 0, "forlag")); $title2 = Helper::text(mysql_result($result, 0, "title2")); $cd = Helper::text(mysql_result($result, 0, "cd")); $image_file = mysql_result($result, 0, "bilder.file"); $image_id = mysql_result($result, 0, "image_id"); $image_width = mysql_result($result, 0, "width"); $active = mysql_result($result, 0, "active"); $date = mysql_result($result, 0, "date"); ?> <h2>Recensioner</h2> <form action="admin_recensioner_action.php" method="POST" name="recensioner" > <div id="recensionerShow"> <span id="imageShow" limit="1" maxWidth="340" maxHeight="200"> <?php if ($image_id != "" && $image_id != 0) { ?>
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>'; } }
{ $rowID=$_GET['spelning']; $query="SELECT * FROM spelningar LEFT JOIN bilder ON spelningar.image_id = bilder.id WHERE spelningar.rowid='$rowID'"; $result=mysql_query($query); $image_file=mysql_result($result,0,"bilder.file"); $image_id=mysql_result($result,0,"image_id"); $date=mysql_result($result,0,"datum"); $place=htmlspecialchars(mysql_result($result,0,"lokal"),ENT_QUOTES); $artist=htmlspecialchars(mysql_result($result,0,"artist"),ENT_QUOTES); $city=htmlspecialchars(mysql_result($result,0,"stad"),ENT_QUOTES); $description=Helper::text(htmlspecialchars(mysql_result($result,0,"description"),ENT_QUOTES)); ?> <form action="admin_events_action.php" name="spelningar" method="post"> <div id="eventShow"> <span id="imageShow" limit="1" maxWidth="200" > <?php if($image_id!="" && $image_id!=0){ ?> <span id="<?php echo $image_id ?>"> <img src="../image_thumb.php?source=<?php echo $uploaded_images."/".$image_file ?>&width=200" />
<?php include "admin_header.php"; $query = "SELECT * FROM articles \n\t\tLEFT JOIN bilder\n\t\tON articles.image_id = bilder.id\n\t\tWHERE rowid='" . $_GET['id'] . "'\n\t\tORDER BY articles.date ASC"; $result = mysql_query($query) or die(mysql_error()); $id = mysql_result($result, 0, "rowid"); $title = mysql_result($result, 0, "title"); $description = Helper::text(mysql_result($result, 0, "description")); $text = Helper::text(mysql_result($result, 0, "text")); $image_file = mysql_result($result, 0, "bilder.file"); $image_id = mysql_result($result, 0, "image_id"); $image_width = mysql_result($result, 0, "width"); $active = mysql_result($result, 0, "active"); $date = mysql_result($result, 0, "date"); ?> <h2>Artiklar</h2> <form action="admin_articles_action.php" method="POST" name="articles" > <div id="articlesShow"> <span id="imageShow" limit="1" maxWidth="340" > <?php if ($image_id != "" && $image_id != 0) { ?> <span id="<?php echo $image_id; ?> ">