public function data() { $sql = "\n\t\t\tSELECT optionname post_title,\n optionid legacy_id\n\t\t\t FROM options\n\t\t\t WHERE optionlistid = 6\n\t\t\t ORDER BY optionname\n\t\t"; $data = \DJB::db('olddjb')->GetAll($sql); return $data; }
public function data() { $sql = "\n\t\t\tSELECT name post_title,\n\t\t\t\t\t\t abbr,\n\t\t\t\t\t\t sort_order,\n\t\t\t\t\t\t ordr the_order,\n\t\t\t\t\t\t saberpoints saber_points,\n\t\t\t\t\t\t handtohandpoints hand_to_hand_points,\n\t\t\t\t\t\t forcepoints force_points,\n\t\t\t\t\t\t skillpoints skill_points,\n\t\t\t\t\t\t disciplinepoints discipline_points,\n\t\t\t\t\t\t rank_id legacy_id\n\t\t\t FROM ranks\n\t\t\t ORDER BY sort_order\n\t\t"; $data = \DJB::db('olddjb')->GetAll($sql); return $data; }