public function content()
{
echo '<div id="thumbnails">';
// generate a basic newest search with a range from 0 to 12
$s = new Search();
$s->order(SORT_NEWEST);
$s->range(0, 12);
$res = $s->search();
while ($image = $res->fetch_object()) {
echo $this->imageBlock($image);
}
echo '</div><div id="modal"></div><div id="modalContent"> </div>';
}
<body>
<div id="dialog">
<div class='content'></div>
</div>
<div id="menu"><h2>iZwei</h2>
<?php
echo $site->form(FORM_SIMPLESEARCH);
echo $site->form(FORM_UPLOAD);
?>
</div>
<div id="content">
<?php
// will be moved to design later on
$s = new Search();
$s->order(SORT_NEWEST);
$s->range(0, 12);
$res = $s->search();
while ($image = $res->fetch_object()) {
echo $site->imageBlock($image);
}
?>
</div>
<div id="modal">
</div>
<div id="modalContent"> </div>
</body>
<?php
$site->footer();
$o = SORT_OLDEST;
break;
case 'best':
$o = SORT_POPULARITY;
break;
case 'worst':
$o = SORT_IMPOPULARITY;
break;
case 'random':
$o = SORT_RANDOM;
break;
default:
trigger_error("Sort mode {$o} is not supported!", E_USER_NOTICE);
}
}
$s->order($orders);
}
$result = $s->search();
$images = array();
while ($image = $result->fetch_assoc()) {
$images[] = $image;
}
echo json_encode($images);
break;
/**
* Get the tags of an image
*
* @param image valid image id
*/
/**
* Get the tags of an image
function __construct($params)
{
$this->_get = $params;
$this->getDBParams();
$mSearch = new Search(true);
$mSearch->limit($this->start, $this->limit);
$mSearch->order($this->order_by['column_name'], $this->order_by['type'], $this->order_by['table_name']);
if (Params::getParam("catId") != "") {
$mSearch->addCategory(Params::getParam("catId"));
}
if ($this->search) {
//$mSearch->addConditions(sprintf("(d.s_title LIKE '%%%s%%' OR d.s_description LIKE '%%%s%%')", $this->search, $this->search));
$mSearch->addConditions(sprintf("MATCH(d.s_title, d.s_description) AGAINST('%s' IN BOOLEAN MODE)", $this->search));
}
if (@$this->stat['spam']) {
$this->extraCols++;
$this->sExtraCol['i_num_spam'] = true;
$mSearch->addField('SUM(s.`i_num_spam`) as i_num_spam');
$mSearch->addConditions("s.`i_num_spam` > 0");
$mSearch->addConditions(sprintf("%st_item.pk_i_id = s.fk_i_item_id", DB_TABLE_PREFIX));
$mSearch->addTable(sprintf("%st_item_stats s", DB_TABLE_PREFIX));
}
if (@$this->stat['duplicated']) {
$this->extraCols++;
$this->sExtraCol['i_num_repeated'] = true;
$mSearch->addField('SUM(s.`i_num_repeated`) as i_num_repeated');
$mSearch->addConditions("s.`i_num_repeated` > 0");
$mSearch->addConditions(sprintf(" %st_item.pk_i_id = s.fk_i_item_id", DB_TABLE_PREFIX));
$mSearch->addTable(sprintf("%st_item_stats s", DB_TABLE_PREFIX));
}
if (@$this->stat['bad']) {
$this->extraCols++;
$this->sExtraCol['i_num_bad_classified'] = true;
$mSearch->addField('SUM(s.`i_num_bad_classified`) as i_num_bad_classified');
$mSearch->addConditions("s.`i_num_bad_classified` > 0");
$mSearch->addConditions(sprintf(" %st_item.pk_i_id = s.fk_i_item_id", DB_TABLE_PREFIX));
$mSearch->addTable(sprintf("%st_item_stats s", DB_TABLE_PREFIX));
}
if (@$this->stat['offensive']) {
$this->extraCols++;
$this->sExtraCol['i_num_offensive'] = true;
$mSearch->addField('SUM(s.`i_num_offensive`) as i_num_offensive');
$mSearch->addConditions("s.`i_num_offensive` > 0");
$mSearch->addConditions(sprintf(" %st_item.pk_i_id = s.fk_i_item_id", DB_TABLE_PREFIX));
$mSearch->addTable(sprintf("%st_item_stats s", DB_TABLE_PREFIX));
}
if (@$this->stat['expired']) {
$this->extraCols++;
$this->sExtraCol['i_num_expired'] = true;
$mSearch->addField('SUM(s.`i_num_expired`) as i_num_expired');
$mSearch->addConditions("s.`i_num_expired` > 0");
$mSearch->addConditions(sprintf(" %st_item.pk_i_id = s.fk_i_item_id", DB_TABLE_PREFIX));
$mSearch->addTable(sprintf("%st_item_stats s", DB_TABLE_PREFIX));
}
foreach ($this->filters as $aFilter) {
$sFilter = "";
if ($aFilter[1] == 'NULL') {
$sFilter .= $aFilter[0] . " IS NULL";
} else {
$sFilter .= $aFilter[0] . " = '" . $aFilter[1] . "'";
}
$sFilter = sprintf($sFilter, DB_TABLE_PREFIX);
$mSearch->addConditions($sFilter);
}
// do Search
$list_items = $mSearch->doSearch(true);
$this->result = Item::newInstance()->extendCategoryName(Item::newInstance()->extendData($list_items));
$this->filtered_total = $mSearch->count();
$this->total = count($list_items);
//TEMPORARY FIX
$this->toDatatablesFormat();
$this->dumpToDatatables();
}
function axSetSearch(Search $search)
{
// gets the range of our search
if (isset($_GET['offset'])) {
if (isset($_GET['count'])) {
$search->range($_GET['offset'], $_GET['count']);
} else {
$search->range($_GET['offset']);
}
} else {
if (isset($_GET['count'])) {
$search->range(NULL, $_GET['count']);
}
}
// sets our tags
if (isset($_GET['include'])) {
$tags = explode(',', $_GET['include']);
foreach ($tags as $k => $v) {
$tags[$k] = urldecode($v);
}
$search->with($tags);
}
if (isset($_GET['exclude'])) {
$tags = explode(',', $_GET['exclude']);
foreach ($tags as $k => $v) {
$tags[$k] = urldecode($v);
}
$search->without($tags);
}
// sets our order
if (isset($_GET['order'])) {
$orders = explode(',', $_GET['order']);
foreach ($orders as $key => &$o) {
switch ($o) {
case 'newest':
$o = SORT_NEWEST;
break;
case 'oldest':
$o = SORT_OLDEST;
break;
case 'best':
$o = SORT_POPULARITY;
break;
case 'worst':
$o = SORT_IMPOPULARITY;
break;
case 'random':
$o = SORT_RANDOM;
break;
case 'mosttags':
$o = SORT_MORETAGS;
break;
case 'leasttags':
$o = SORT_LESSTAGS;
break;
default:
trigger_error("Sort mode {$o} is not supported!", E_USER_NOTICE);
}
}
$search->order($orders);
}
return $search;
}
