public static function register($user, $pass, $email) { $query = "insert into account(username,password,email) values('{$user}','{$pass}','{$email}')"; Mdb::nonSelectQuery($query); $query = "insert into profile(status) values('active')"; Mdb::nonSelectQuery($query); }
public static function delete($id) { $query = "delete from expression where id={$id}"; Mdb::nonSelectQuery($query); }
public static function setPassword($user, $pass) { $query = "update account set password='******' where username='******'"; Mdb::nonSelectQuery($query); }
public static function updateExpression($id, $name, $desc, $content) { $query = "update expression set name='{$name}',description='{$desc}',content='{$content}' where id={$id}"; Mdb::nonSelectQuery($query); }
public static function save($accid, $fid, $type) { if ($type == "DODAJ U KOLEKCIJU") { $query = "insert into pinned(accid,fid) values({$accid},{$fid})"; Mdb::nonSelectQuery($query); $query = "update expression set popularity=popularity+1 where id={$fid}"; Mdb::nonSelectQuery($query); } else { if ($type == "BRIŠI IZ KOLEKCIJE") { $query = "delete from pinned where accid={$accid} and fid={$fid}"; Mdb::nonSelectQuery($query); $query = "update expression set popularity=popularity-1 where id={$fid}"; Mdb::nonSelectQuery($query); } } }