function imd_v1_add(WP_REST_Request $request) { require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); global $scdb; $values = array('sc1', 'sc2', 'forum', 'rank', 'role', 'member', 'lastUID'); if ($misc->check_vars($values)) { $uid = $request->get_param("lastUID") + 1; $sql = "\n\t\t\tINSERT INTO lttname\n\t\t\t(sc1,sc2,forum,rank,role,member,nameUID) VALUES\n\t\t\t('" . implode("','", array($request->get_param("sc1"), $request->get_param("sc2"), $request->get_param("forum"), $request->get_param("rank"), $request->get_param("role"), $request->get_param("member"), $uid)) . "')\n\t\t"; $scdb->query($sql); wp_redirect("http://www.insanemaths.com/reported.cfm?noc=1"); die; // Keeping just in case ^^ does not work //header('Location: http://www.insanemaths.com/reported.cfm?noc=1'); } else { return new WP_Error('imd_api_v1_incomplete_request', "Not all required variables set", array('status' => 418)); } }
public function add() { // TODO stuff require_once SC_USER_DIR . "/library/sc_user_misc.class.php"; $misc = new sc_user_misc(); global $scdb; //$scdb = new wpdb(DB_USER, DB_PASSWORD,"uolttorg_sc_data", DB_HOST); $values = array('sc1', 'sc2', 'forum', 'rank', 'role', 'member', 'lastUID'); if ($misc->check_vars($values)) { $uid = $misc->get_post('lastUID') + 1; $sql = "\n\t\t INSERT INTO lttname\n\t\t (sc1,sc2,forum,rank,role,member,nameUID) VALUES\n\t\t ('" . implode("','", array($misc->get_post('sc1'), $misc->get_post('sc2'), $misc->get_post('forum'), $misc->get_post('rank'), $misc->get_post('role'), $misc->get_post('member'), $uid)) . "')\n \t\t"; $scdb->query($sql); //wp_mail("*****@*****.**","user add query",$sql); header('Location: http://www.insanemaths.com/reported.cfm?noc=1'); return array("it" => "worked"); } else { global $sapi; $sapi->error("Not all required variables set."); } }