/**
* Create the SQL ORDER and LIMIT BY clause for connections
*
* @param integer $start start row
* @param integer $max max number of rows to return
* @param string $o order by column
* @param string $s sort order (ASC or DESC)
* @return string
*/
function connectionOrderString($o, $s)
{
global $CFG, $HUB_FLM, $HUB_SQL;
//check order by param is valid
switch ($o) {
case "date":
$orderby = "t.CreationDate";
break;
case "moddate":
$orderby = "t.ModificationDate";
break;
case "vote":
$orderby = "vote";
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidOrderbyError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
//check sort param is valid
switch ($s) {
case "ASC":
$sort = $HUB_SQL->ASC;
break;
case "DESC":
$sort = $HUB_SQL->DESC;
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidSortError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
if ($o == 'vote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", CreationDate " . $HUB_SQL->DESC;
} else {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort;
}
return $str;
}
/**
* Create the SQL ORDER and LIMIT BY clause for connections
*
* @param integer $start start row
* @param integer $max max number of rows to return
* @param string $o order by column
* @param string $s sort order (ASC or DESC)
* @return string
*/
function connectionOrderString($o, $s)
{
global $CFG, $HUB_FLM, $HUB_SQL;
//check order by param is valid
switch ($o) {
case "date":
$orderby = "t.CreationDate";
break;
case "moddate":
$orderby = "t.ModificationDate";
break;
case "vote":
$orderby = "vote";
break;
case "ideavote":
$orderby = "vote";
break;
case "fromname":
$orderby = "t.FromLabel";
break;
case "toname":
$orderby = "t.ToLabel";
break;
case "random":
//MB: This does not scale and should be replaced eventually.
$day = date('j', time());
$hour = date('G', time());
$orderby = "RAND(" . $day . $hour . ")";
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidOrderbyError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
//check sort param is valid
switch ($s) {
case "ASC":
$sort = $HUB_SQL->ASC;
break;
case "DESC":
$sort = $HUB_SQL->DESC;
break;
default:
global $ERROR;
$ERROR = new error();
$ERROR->createInvalidSortError();
include $HUB_FLM->getCodeDirPath("core/formaterror.php");
die;
}
if ($o == 'ideavote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", kids " . $HUB_SQL->DESC . ", kidsweight " . $HUB_SQL->DESC;
} else {
if ($o == 'vote') {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort . ", weight " . $HUB_SQL->DESC . ", CreationDate " . $HUB_SQL->DESC;
} else {
$str = $HUB_SQL->ORDER_BY . $orderby . " " . $sort;
}
}
return $str;
}
