public function updateJudge() { $_sql = "update veling_exam_judge\r\n\t set question='" . $this->question . "',\r\n tips='" . $this->tips . "',\r\n course_id='" . $this->course_id . "',\r\n answer='" . $this->answer . "'\r\n where id=" . $this->id; return parent::cud($_sql); }
public function addFeedback() { $_sql = "insert into feedback(\r\n\t provider,\r\n\t contact,\r\n\t reportWord,\r\n\t state,\r\n\t reportTime\r\n\t )values(\r\n\t '" . $this->username . "',\r\n\t '" . $this->contact . "',\r\n\t '" . $this->reportWord . "',\r\n\t 0,\r\n\t now()\r\n\t )"; //echo $_sql; return parent::cud($_sql); }
public function addEntry() { $_sql = "insert into dict(\r\n\t\t\t\t\t\t\t\twordname,\r\n\t\t\t\t\t\t\t\tphonetic,\r\n\t\t\t\t\t\t\t\tpic,\r\n\t\t\t\t\t\t\t\tparaphrase,\r\n\t\t\t\t\t\t\t\texample,\r\n\t\t\t\t\t\t\t\tcatalogue,\r\n provider,\r\n vid,\r\n\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t\t)values(\r\n\t\t\t\t\t\t\t'" . $this->wordname . "',\r\n\t\t\t\t\t\t\t'" . $this->phonetic . "',\r\n\t\t\t\t\t\t\t'" . $this->pic . "',\r\n\t\t\t\t\t\t\t'" . $this->paraphrase . "',\r\n\t\t\t\t\t\t\t'" . $this->example . "',\r\n\t\t\t\t\t\t\t'" . $this->catalogue . "',\r\n\t\t\t\t\t\t\t'" . $this->provider . "',\r\n\t\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t\tnow()\r\n\t\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addDownload() { $_sql = "insert into download(\r\n \t name,\r\n\t url,\r\n\t title,\r\n \t description,\r\n \t tid,\r\n \t date\r\n \t )values(\r\n \t '" . $this->name . "',\r\n \t '" . $this->url . "',\r\n \t '" . $this->title . "',\r\n \t '" . $this->description . "',\r\n \t " . $this->tid . ",\r\n \t now()\r\n \t )"; return parent::cud($_sql); }
public function addSubNav() { $_sql = "insert into nav(\r\n\t\t\t\t\t\t\t\tname,\r\n\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\t\tpid,\r\n\t\t\t\t\t\t\t\tsort,\r\n\t\t\t\t\t\t\t\tdate,\r\n\t\t\t\t\t\t\t\tpicked\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->name . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t" . $this->id . ",\r\n\t\t\t\t\t\t" . parent::Auto_increment('nav') . ",\r\n\t\t\t\t\t\tnow(),\r\n\t\t\t\t\t\t1\r\n\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addPermission() { $_sql = "insert into permission(\r\n\t\t\t\t\t\t\t\t\t\tname,\r\n\t\t\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\t\t\tpid,\r\n\t\t\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->name . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\r\n\t\t\t\t\t\t" . parent::Auto_increment('permission') . ",\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; return parent::cud($_sql); }
public function addAd() { $_sql = "insert into ad(\r\n\t\t\t\t\t\t\t\ttitle,\r\n\t\t\t\t\t\t\t\tlink,\r\n\t\t\t\t\t\t\t\tthumbnail,\r\n\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\ttype,\r\n\t\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t\t)values(\r\n\t\t\t\t\t\t\t'" . $this->title . "',\r\n\t\t\t\t\t\t\t'" . $this->link . "',\r\n\t\t\t\t\t\t\t'" . $this->thumbnail . "',\r\n\t\t\t\t\t\t\t'" . $this->description . "',\r\n\t\t\t\t\t\t\t'" . $this->type . "',\r\n\t\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t\tnow()\r\n\t\t\t\t\t)"; return parent::cud($_sql); }
public function addComment() { $_sql = "insert into comment(\r\n\t\t\t\t\t\t\t\t\taid,\r\n\t\t\t\t\t\t\t\t\tuid,\r\n\t\t\t\t\t\t\t\t\tpid,\r\n\t\t\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\t\t\tcontent,\r\n\t\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t" . $this->aid . ",\r\n\t\t\t\t\t\t" . $this->uid . ",\r\n\t\t\t\t\t\t0,\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t'" . $this->content . "',\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addSubject() { $_sql = "insert into vote(\r\n\t\t\t\t\t\t\t\ttitle,\r\n\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\tdate,\r\n\t\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\t\tpid\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->title . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\r\n\t\t\t\t\t\tnow(),\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t0\r\n\t\t\t\t)"; return parent::cud($_sql); }
public function deleteOrder() { $_sql = "delete from orders where id=" . $this->id; return parent::cud($_sql); }
public function addTopic() { $_sql = "insert into ask(topic,aid,date,pid,cid)values('" . $this->topic . "','" . $this->aid . "',now(),0," . $this->cid . ")"; //echo $_sql; return parent::cud($_sql); }
public function setState($_flag) { $switch = null; if ($_flag == 'hide') { $switch = 0; } elseif ($_flag == 'show') { $switch = 1; } $_sql = "update products set state=" . $switch . " where id=" . $this->id; return parent::cud($_sql); }
public function addCourse() { $_sql = "insert into course(\r\n\t\t\t\t\t\t\t\tname,\r\n\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->name . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addUser() { $_sql = "insert into user(\r\n\t\t\t\t\t\t\t\tusername,\r\n\t\t\t\t\t\t\t\tpwd,\r\n\t\t\t\t\t\t\t\tlogin_num,\r\n\t\t\t\t\t\t\t\tlast_ip,\r\n\t\t\t\t\t\t\t\tlast_time,\r\n\t\t\t\t\t\t\t\tregTime,\r\n\t\t\t\t\t\t\t\ticon,\r\n\t\t\t\t\t\t\t\temail,\r\n\t\t countdown,\r\n\t\t state\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->username . "',\r\n\t\t\t\t\t\t'" . $this->pwd . "',\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t'" . $this->last_ip . "',\r\n\t\t\t\t\t\tnow(),\r\n\t\t\t\t\t\tnow(),\r\n\t\t\t\t\t\t'" . $this->icon . "',\r\n\t\t\t\t\t\t'" . $this->email . "',\r\n\t\t\t\t\t\t 5,\r\n\t\t\t\t\t\t1\r\n\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addtopic() { $_sql = "insert into topic(\r\n\t\t\t\t\t\t\t\tname,\r\n\t\t\t\t\t\t\t\tdescription,\r\n\t\t\t\t\t\t\t\tpermission,\r\n\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->name . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\t\r\n\t\t\t\t\t\t'" . $this->permission . "',\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; return parent::cud($_sql); }
public function addArticle() { $_sql = "insert into article(\r\n\t\t\t\t\t\t\t\t\ttitle,\r\n\t\t\t\t\t\t\t\t\tlead,\r\n\t\t\t\t\t\t\t\t\tcontent,\r\n\t\t\t\t\t\t\t\t\tauthor,\r\n\t\t\t\t\t\t\t\t\ttag,\r\n\t\t\t\t\t\t\t\t\tthumbnail,\r\n\t\t\t\t\t\t\t\t\tnid,\r\n\t\t cid,\r\n\t\t\t\t\t\t\t\t\tsource,\r\n\t\t\t\t\t\t\t\t\tpageview,\r\n\t\t\t\t\t\t\t\t\tstate,\r\n\t\t\t\t\t\t\t\t\tattr,\r\n\t\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->title . "',\r\n\t\t\t\t\t\t'" . $this->lead . "',\r\n\t\t\t\t\t\t'" . $this->content . "',\r\n\t\t\t\t\t\t'" . $this->author . "',\r\n\t\t\t\t\t\t'" . $this->tag . "',\r\n\t\t\t\t\t\t'" . $this->thumbnail . "',\r\n\t\t\t\t\t\t'" . $this->nid . "',\r\n\t\t\t\t\t\t'" . $this->cid . "',\r\n\t\t\t\t\t\t'" . $this->source . "',\r\n\t\t\t\t\t\t" . $this->pageview . ",\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t'" . $this->attr . "',\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; //echo $_sql; return parent::cud($_sql); }
public function addAdmin() { $_sql = "insert into admin(\r\n\t\t\t\t\t\t\t\tusername,\r\n\t\t\t\t\t\t\t\tpwd,\r\n\t\t\t\t\t\t\t\tlast_ip,\r\n\t\t\t\t\t\t\t\tlast_time,\r\n\t\t\t\t\t\t\t\tlogin_num,\r\n\t\t\t\t\t\t\t\tlevel_id,\r\n\t\t\t\t\t\t\t\treg_time\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->username . "',\r\n\t\t\t\t\t\t'" . $this->pwd . "',\r\n\t\t\t\t\t\t'" . $this->last_ip . "',\r\n\t\t\t\t\t\tnow(),\r\n\t\t\t\t\t\t1,\r\n\t\t\t\t\t\t" . $this->level_id . ",\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; return parent::cud($_sql); }
public function addCategory() { $_sql = "insert into category(\r\n\t\t\t\t\t\t\t\tname,\r\n\t\t\t\t\t\t\t\tdescription,\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\tdate\r\n\t\t\t\t)values(\r\n\t\t\t\t\t\t'" . $this->name . "',\r\n\t\t\t\t\t\t'" . $this->description . "',\t\t\t\t\t\t\r\n\t\t\t\t\t\tnow()\r\n\t\t\t\t)"; return parent::cud($_sql); }