Esempio n. 1
0
 static function GetSortSql($sort = null, $attach_order = false, $for_cat = false)
 {
     global $wpdb;
     wpfb_loadclass('Output');
     list($sort, $sortdir) = WPFB_Output::ParseSorting($sort, $for_cat);
     $sort = esc_sql($sort);
     $of = $for_cat ? 'cat_order' : 'file_attach_order';
     return $attach_order ? "`{$of}` ASC, `{$sort}` {$sortdir}" : "`{$sort}` {$sortdir}";
 }
Esempio n. 2
0
 static function GetSortSql($sort = null, $attach_order = false, $for_cat = false)
 {
     wpfb_loadclass('Output');
     $sql = $attach_order ? "`" . ($for_cat ? 'cat_order' : 'file_attach_order') . "` ASC, " : "";
     foreach (explode(',', $sort) as $s) {
         list($sf, $sd) = WPFB_Output::ParseSorting($s, $for_cat);
         $sql .= "`" . esc_sql($sf) . "` {$sd}, ";
     }
     return substr($sql, 0, -2);
 }