'Register') * */ class Register extends BasePage { function addJS() { if ( $this->mode == "view" ) { $this->krihvel->out("head", ""); } } function getSchools() { $q = "SELECT * FROM schools"; $ret = $this->kdb->query($q); $res = array(); while ($row = mysql_fetch_array($ret)) { $res[] = array('sid' => $row['schoolID'], 'name' => $row['schoolName']); } return $res; } /** * @Secured('roles' = {'anonymous'}) * */ function actionRegister() { global $kdb; $r = $_POST; $scid = $r['school']; $fn = $r['firstname']; $ln = $r['lastname']; $un = $r['username']; $pwd = $r['r_password']; $rpwd = $r['repassword']; $gen = $r['gender']; $lang = $r['language']; $kdb->query("INSERT INTO users (uname, pwd, roles, schoolID, approved) VALUES('".$un."', '".$pwd."', '100000', ".$scid.", False)"); $nui = mysql_insert_id(); $kdb->query("INSERT INTO userinfo (userid, firstname, lastname, email, language, sex, homepage) VALUES (".$nui.",'".$fn."', '".$ln."', '', '".$lang."', '".$gen."', '' )"); return array('pid' => 'Register', 'mode' => 'pending'); } } ?>