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);
 }
Example #3
0
 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);
 }
Example #5
0
 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);
 }
Example #7
0
 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);
 }
Example #9
0
 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);
 }
Example #10
0
 public function deleteOrder()
 {
     $_sql = "delete from orders where id=" . $this->id;
     return parent::cud($_sql);
 }
Example #11
0
 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);
 }
Example #14
0
 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);
 }
Example #15
0
 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);
 }
Example #17
0
 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);
 }