unset($promoes);
$query = 'SELECT p.id, p.owner AS author_id, p.imagestring, p.date, p.description, p.parent, l.username AS author_username ';
$query .= 'FROM promoes AS p, login AS l WHERE l.id = p.owner ORDER BY p.id DESC LIMIT 10';
$result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
while ($promoe = mysql_fetch_assoc($result)) {
$promoes[] = $promoe;
}
echo promoe_thumbs_list('Senaste Promoe-bilderna', $promoes);
unset($promoes);
$query = 'SELECT p.id, p.owner AS author_id, p.imagestring, p.date, p.description, p.parent, l.username AS author_username ';
$query .= 'FROM promoes AS p, login AS l WHERE l.id = p.owner ORDER BY p.hypes DESC LIMIT 10';
$result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
while ($promoe = mysql_fetch_assoc($result)) {
$promoes[] = $promoe;
}
echo promoe_thumbs_list('Mest hypade Promoe-bilderna', $promoes);
unset($promoes);
$query = 'SELECT p.id, p.owner AS author_id, p.imagestring, p.date, p.description, p.parent, l.username AS author_username ';
$query .= 'FROM promoes AS p, login AS l WHERE l.id = p.owner AND p.date > "' . (time() - 86400 * 3) . '" ORDER BY p.hypes DESC LIMIT 10';
$result = mysql_query($query) or die(report_sql_error($query, __FILE__, __LINE__));
while ($promoe = mysql_fetch_assoc($result)) {
$promoes[] = $promoe;
}
echo promoe_thumbs_list('Färska Promoe-bilder på väg upp', $promoes);
?>
<form>
<input type="text" name="search" />
<input type="submit" value="Sök" />
</form>
<?php
ui_bottom();
<?php
include PATHS_INCLUDE . 'libraries/promoe.lib.php';
echo '<div style="border: 1px solid ' . $profile_colors['border'] . '; background: ' . $profile_colors['background'] . '; padding: 3px;">' . "\n";
$query = 'SELECT * FROM promoes WHERE owner = "' . $userinfo['login']['id'] . '" ORDER BY id DESC';
$result = mysql_query($query) or die(report_sql_error());
if (mysql_num_rows($result) > 0) {
while ($promoe = mysql_fetch_assoc($result)) {
$promoes[] = $promoe;
}
echo promoe_thumbs_list('Promoes', $promoes);
} elseif ($_SESSION['login']['id'] == $userinfo['login']['id']) {
echo '<h1>Du har inte ritat någon Promoe ännu!</h1>' . "\n";
echo '<a href="/annat/promoe_editor.php">Rita en Promoe här!</a>' . "\n";
} else {
echo 'Tråkmånsen ' . $userinfo['login']['username'] . ' har inte ritat någon Promoe ännu...' . "\n";
echo '<br /><br />Men men, det här är ju revolutionens tid, det är dags att börja konvertera vegetarianer' . "\n";
}
?>
</div>
