/** * 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; }