/**
* Inenhåller menun som passar till Art
* subkategprierna ordnas efter orderNo i matrushkan.
*/
public function setContent()
{
$q = new Query("matruschkaShowAtPlaces");
$q->showAt($this->title, $this->m->lang, "msapOrderNo", "ASC", 100);
$i = 1;
while ($row = mysql_fetch_object($q->getResult())) {
$this->content .= '<div class="leftMenu">';
$this->content .= '<span class="subSecTitle">' . $row->mButtonTitle . '</span>';
$qq = new Query("matruschka");
$qq->whereCustom("mButtonTitle, mRowid", "mParent = '" . $row->mRowid . "' AND mPublished='1' AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0);
if ($qq->getNumRows()) {
// om det finns nån som har denna som parent
$this->content .= '<div class="subSection">';
while ($row2 = mysql_fetch_object($qq->getResult())) {
/** Svart om aktiv **/
if ($this->getActive($this->m->ID, $row2->mRowid) == 1) {
$this->content .= '<span class="sideMenuActive"><a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a></span><br/>';
} else {
$this->content .= '<a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . '</a><br/>';
}
}
$this->content .= '</div>';
}
$this->content .= '</div>';
if ($i != $q->getNumRows()) {
$this->content .= '<img src="' . Settings::$graphics . 'stripes.gif" />' . "\n";
}
$i++;
}
}
/**
* Inenhåller menun som passar till Art
* subkategprierna ordnas efter orderNo i matrushkan.
*/
public function setContent()
{
$q = new Query("matruschkaShowAtPlaces");
$qq = new Query("matruschka");
$qqq = new Query("matruschka");
$q->showAt($this->title, $this->m->lang, "mOrderNo", "ASC", 100);
$i = 1;
while ($row = mysql_fetch_object($q->getResult())) {
$this->content .= '<div class="leftMenu">';
$this->content .= '<span class="subSecTitle">' . $row->mButtonTitle . "</span>\n";
$qq->whereCustom("mButtonTitle, mRowid", "mParent = '" . $row->mRowid . "' AND mPublished='1' AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0);
// om det finns nån som har denna som parent
if ($qq->getNumRows()) {
/* Fulhack för att få första i galleriet rosa */
$i = 0;
$this->content .= '<div class="subSection">';
while ($row2 = mysql_fetch_object($qq->getResult())) {
$qqq->whereCustom("mButtonTitle, mRowid, mTitle", "mParent = '" . $row2->mRowid . "' \n AND mPublished='1' \n AND mButtonTitle NOT LIKE ''\n AND mLang='" . $this->m->lang . "' ", "mOrderNo", "ASC", 0);
/** Om det är den trenivåare **/
if ($qqq->getNumRows()) {
$this->content .= '<span class="subSecTitle">' . $row2->mButtonTitle . "</span>\n";
$this->content .= '<div class="subSection">';
while ($row3 = mysql_fetch_object($qqq->getResult())) {
/** Rosa om aktiv **/
if ($this->getActive($this->m->ID, $row3->mRowid) == 1) {
$this->content .= '<span class="sideMenuActive"><a href="?ID=';
$this->content .= $row3->mRowid . '">' . $row3->mButtonTitle . "</a></span><br/>\n";
} else {
$this->content .= '<a href="?ID=' . $row3->mRowid . '">' . $row3->mButtonTitle . "</a><br/>\n";
}
}
$this->content .= "</div>\n";
// subSection inre
} else {
/** Om det är en vanlig blir det en länk**/
/** Rosa om aktiv **/
/** Fulhack - Rosa om man klickat på galleriet */
if ($this->getActive($this->m->ID, $row2->mRowid) == 1 || $this->m->showStyle == "Gallery" && $i == 0 && $this->m->level == 0) {
$this->content .= '<span class="sideMenuActive"><a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . "</a></span><br/>\n";
} else {
$this->content .= '<a href="?ID=' . $row2->mRowid . '">' . $row2->mButtonTitle . "</a><br/>\n";
}
}
/* Fulhack */
$i++;
}
$this->content .= "</div>\n";
//subSection yttre
}
$this->content .= "</div>\n";
// leftMenu
if ($i != $q->getNumRows()) {
$this->content .= '<img src="' . Settings::$graphics . 'stripes.gif" />' . "\n";
}
$i++;
}
}
</head>
<?php
if (!isset($_GET) || empty($_GET)) {
print "<body style=\"background-color:#a9a9a9\">\n";
} else {
print "<body>";
}
function __autoload($class_name)
{
$directorys = array('php_classes/', 'php_classes/custom/admin/', 'php_classes/custom/site/');
foreach ($directorys as $directory) {
if (file_exists($directory . $class_name . '.class.php')) {
require_once $directory . $class_name . '.class.php';
return;
}
}
}
$db = new DB();
if (eregi("^[0-9]{1,4}\$", $_GET['ID'])) {
$q = new Query("matruschka");
$q->whereQuery("mRowid", "mRowid", $_GET['ID'], "mRowid", "ASC", 1);
if ($q->getNumRows() > 0) {
$ID = $_GET['ID'];
}
}
/* Startar programmet */
new Main($ID);
?>
</body>
</html>
<?php
$pagesize = 40;
$recordstart = (int) $_GET['recordstart'];
$recordstart = isset($_GET['recordstart']) ? $_GET['recordstart'] : 0;
$query = "SELECT * FROM competitions\n\t\tORDER BY date DESC LIMIT " . $recordstart . " , " . $pagesize . " ";
$result = mysql_query($query) or die(mysql_error());
echo '<table cellpadding="3" cellspacing="2" border="0">';
echo '<th align="left">Titel</th><th align="left">Datum</th><th align="left">Skribent</th><th align="left">Svar</th><th align="left">Publicerad?</th><th> </th>';
while ($row = mysql_fetch_assoc($result)) {
$answersQ = new Query("competition_answers");
$answersQ->whereQuery("*", "answerComp_id", $row['rowid'], "answerRowid", "DESC", 100000);
echo '<tr>
<td align="left"><a href="admin_comp_edit.php?id=' . $row['rowid'] . '" class="klass1" > ' . $row['title'] . '</a></td>
<td align="left">' . $row['date'] . '</td>
<td align="left">' . $row['published_by'] . '</td>
<td align="left"><a href="admin_comp_answers.php?id=' . $row['rowid'] . '">' . $answersQ->getNumRows() . '</a></td>
<td align="left">';
if ($row['active'] == 1) {
echo "JA";
} else {
echo "NEJ";
}
echo '</td>
<td align="left"><a href="admin_comp_action.php?id=' . $row['rowid'] . '&action=remove"><img src="graphics/remove.jpg" width="10" border="0"/></a></td>
</tr>';
$rad++;
}
?>
</table>
<?php
//alla aktuella
}
?>
</td>
</tr>
</table>
<?php
}
?>
</div>
<div class="mp3Player">
<?php
$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 />
<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
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");
<hr class="hr2" noshade="noshade" />
</div>
<div class="leftCenterDivFlow">
<span class="boldWhite">Kulturtips! </span><br /><br />
<span class="smallGrey">
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");
?>
/**
* Listar alla på förstasidan, dvs level=0
*/
private function showTable2($class)
{
$q = new Query("matruschka");
$q->whereQuery("*", "mLevel", 0, "mLang", "DESC", 0);
echo '<br/><br/>';
echo '<table class="' . $class . '" cellpadding="0" cellspacing="0">' . "\n";
echo '<th> </th>';
echo '<th>Title</th>';
echo '<th>Sub cat´s</th>';
echo '<th>Show style</th>';
echo '<th>Order no.</th>';
echo '<th>Lang</th>';
echo '<th>Published</th>';
//echo '<th align="left">Publiceringsdatum</th>';
//echo '<th align="left">Senast uppdaterad</th>';
//echo '<th align="left">Adminlevel</th>';
echo '<th> </th>';
echo '<th> </th>';
$i = 0;
while ($row = mysql_fetch_object($q->getResult())) {
$ssThumb;
$imgQ = new Query("matruschkaImages");
$imgQ->whereQuery('*', 'miMatruschkaID', $row->mRowid, 'miMatruschkaID', 'DESC', 2);
$img = $imgQ->getResultRow('miFilename');
if ($row->mShowStyle == "ImageShow") {
$ssThumb = AdminImageShow::$thumbnail;
} elseif ($row->mShowStyle == "TextShow") {
$ssThumb = AdminTextShow::$thumbnail;
} elseif ($row->mShowStyle == "ImageShow2") {
$ssThumb = AdminImageShow2::$thumbnail;
} elseif ($row->mShowStyle == "Agree") {
$ssThumb = AdminAgree::$thumbnail;
} elseif ($row->mShowStyle == "Start") {
$ssThumb = AdminStart::$thumbnail;
}
// Fyll på med fler
echo "<tr>\n";
echo '<td class="td' . $i . '"><img src="image_crop.php?source=' . Settings::getUploadedImages() . '/' . $img . '&dest=&thumb_size=40" /></td>' . "\n";
echo '<td class="td' . $i . '">';
if ($_SESSION['admin_level'] >= $row->mAdminLevel || $_SESSION['admin_logged'] == $row->mAuthor) {
echo '<a href="?ID=' . $row->mRowid . '">';
echo $row->mButtonTitle ? $row->mButtonTitle : $row->mTitle;
echo '</a>';
} else {
echo $row->mButtonTitle ? $row->mButtonTitle : $row->mTitle;
}
echo "</td>\n";
echo '<td class="td' . $i . '">';
$subQ = new Query("matruschka");
$subQ->whereQuery("mRowid", "mParent", $row->mRowid, "mRowid", "ASC", 0);
echo $subQ->getNumRows();
echo "</td>\n";
echo "<td valign=\"bottom\" class=\"td{$i}\">";
echo "<span onclick=\"MM_openBrWindow('" . Settings::$customGraphics . $ssThumb . "','Preview','width=500,height=500')\" style=\"cursor: hand; cursor: pointer;\">";
echo $row->mShowStyle;
echo '</span>';
echo "</td>\n";
echo '<td class="td' . $i . '">' . $row->mOrderNo . '</td>' . "\n";
echo '<td class="td' . $i . '">' . $row->mLang . '</td>' . "\n";
echo '<td class="td' . $i . '">';
echo $row->mPublished ? '<span style="color:#339900">Yes</span>' : '<span style="color:#FF0000">No</span>';
echo "</td>\n";
//echo '<td valign="bottom">'.$row->mPubDate.'</td>'."\n";
//echo '<td valign="bottom">'.$row->mUpdateDate.'</td>'."\n";
//echo '<td valign="bottom">'.$row->mAdminLevel.'</td>'."\n";
echo '<td class="td' . $i . '">';
if ($_SESSION['admin_level'] >= $row->mAdminLevel || $_SESSION['admin_logged'] == $row->mAuthor) {
echo '<a href="?ID=' . $row->mRowid . '">Edit</a>';
} else {
echo ' ';
}
echo '</td>' . "\n";
echo '<td class="td' . $i . '">';
if ($_SESSION['admin_level'] >= $row->mAdminLevel || $_SESSION['admin_logged'] == $row->mAuthor) {
echo '<a href="?action=Remove&mID=' . $row->mRowid . '&ID=' . $this->ID . '" name="removeButton">Remove</a>';
} else {
echo ' ';
}
echo '</td>' . "\n";
echo '</tr>' . "\n";
$i++;
$i = $i % 2;
}
echo '</table>';
}
private function newEntryPlace()
{
echo "Skapat";
$image = $_POST['image'];
$title = $_POST['title'];
$description = $_POST['description'];
$parent = $_POST['parent'];
$requiredTitle = $_POST['requiredTitle'];
$requiredDescription = $_POST['requiredDescription'];
$requiredText = $_POST['requiredText'];
$requiredComments = $_POST['requiredComments'];
$requiredImage = $_POST['requiredImage'];
$requiredRate = $_POST['requiredRate'];
$pubDate;
if ($published == 1) {
$pubDate = date("Y-m-d H:i:s");
} else {
$pubDate = "";
}
$q = new Query('entryPlaces');
$q->whereQuery("*", "title", $title, "title", "DESC", 0);
if ($q->getNumRows() == 0) {
$query = "INSERT INTO entryPlaces \n\t\t\t\t\tSET image='{$image}',\n\t\t\t\t\t\ttitle='{$title}',\n\t\t\t\t\t\tdescription='{$description}',\n\t\t\t\t\t\tpubDate='{$pubDate}',\n\t\t\t\t\t\trequiredTitle='{$requiredTitle}',\n\t\t\t\t\t\trequiredDescription='{$requiredDescription}',\n\t\t\t\t\t\trequiredText='{$requiredText}',\n\t\t\t\t\t\trequiredComments='{$requiredComments}',\n\t\t\t\t\t\trequiredImage='{$requiredImage}',\n\t\t\t\t\t\trequiredRate='{$requiredRate}'";
$result = mysql_query($query) or die(mysql_error());
}
}
"><?php
echo $demoQ->getResultRow("description");
?>
</a></span><br />
<span class="smallOrange"><a href="demorecensioner.php?demo_id=<?php
echo $demoQ->getResultRow("rowid");
?>
">Läs mer</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,toolbar=no,menubar=no,statusbar=no')" ><img src="graphics/radio.gif" border="0" alt=""/></a></div>
<hr class="hr2" noshade="noshade" /><br />
<?php
}
?>
</div>
<div id="rightBannerDiv">
<!--<img src="graphics/annonspil.gif" alt="Annonser"/><br />-->
<?php
$rightBannerQ = new Query("banners");
$rightBannerQ->whereLeftJoinImageQuery("*", "category", "right", "order_no", "ASC", 1);
while ($row = mysql_fetch_assoc($rightBannerQ->getResult())) {
if (trim($row['bannersCode']) == "") {
