public function addTag()
{
$_sql = "INSERT INTO \n\t\t\t\t\t\t\t\t\t\t\t\tcms_tag (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttagname\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->tagname}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)";
return parent::aud($_sql);
}
public function addUser()
{
$_sql = "insert into cms_user(user, pass, email, question, answer, face, state, time, date) values('{$this->user}', '{$this->pass}', '{$this->email}', '{$this->question}', '{$this->answer}', '{$this->face}', '{$this->state}', '{$this->time}', now());";
return parent::aud($_sql);
}
public function deleteContent()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\ttg_article\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\tLIMIT 1";
return parent::aud($_sql);
}
public function updateModule()
{
$_sql = "UPDATE \n\t\t\t\t\t\t\t\t\t\ttg_module \n\t\t\t\t\t\t\t\t SET \n\t\t\t\t\t\t\t\t\t\tmodule_tpl = '{$this->userInfo[module_tpl]}',\n\t\t\t\t\t\t\t\t\t\tmodule_det = '{$this->userInfo[module_det]}',\n\t\t\t\t\t\t\t\t\t\tmodule_name = '{$this->userInfo[module_name]}',\n\t\t\t\t\t\t\t\t\t\tmodule_same = '{$this->userInfo[module_same]}',\n\t\t\t\t\t\t\t\t\t\tparam1 = '{$this->userInfo[param1]}',\n\t\t\t\t\t\t\t\t\t\tparam2 = '{$this->userInfo[param2]}',\n\t\t\t\t\t\t\t\t\t\tparam3 = '{$this->userInfo[param3]}'\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\tmid = {$this->userInfo[mid]} \n\t\t\t\t\t\t\t\t LIMIT \n\t\t\t\t\t\t\t\t\t\t1";
return parent::aud($_sql);
}
public function deleteVote()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcms_vote \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tvid='{$this->id}'";
return parent::aud($_sql);
}
public function deleteComment()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\tcms_comment\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\tLIMIT 1";
return parent::aud($_sql);
}
public function setSystem()
{
$_sql = "UPDATE \n\t\t\t\t\t\t\t\t\t\t\tcms_system \n\t\t\t\t\t\t\t\t\tSET \n\t\t\t\t\t\t\t\t\t\t\twebname='{$this->webname}',\n\t\t\t\t\t\t\t\t\t\t\tpage_size='{$this->page_size}',\n\t\t\t\t\t\t\t\t\t\t\tnav_size='{$this->nav_size}',\n\t\t\t\t\t\t\t\t\t\t\tarticle_size='{$this->article_size}',\n\t\t\t\t\t\t\t\t\t\t\tro_time='{$this->ro_time}',\n\t\t\t\t\t\t\t\t\t\t\tro_num='{$this->ro_num}',\n\t\t\t\t\t\t\t\t\t\t\tupdir='{$this->updir}',\n\t\t\t\t\t\t\t\t\t\t\tadver_text_num='{$this->adver_text_num}',\n\t\t\t\t\t\t\t\t\t\t\tadver_pic_num='{$this->adver_pic_num}'\n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\tid=1";
return parent::aud($_sql);
}
public function deleteLevel()
{
$_sql = "delete from cms_level where id='{$this->id}' limit 1";
return parent::aud($_sql);
}
public function update()
{
$sql = "UPDATE maipuwx_menu \n\t\t\t\tSET menu='{$this->menu}' \n\t\t\t\tWHERE id='{$this->id}' LIMIT 1";
return parent::aud($sql);
}
public function updateBanner()
{
$_sql = "UPDATE \n\t\t\t\t\t\t\t\t\t\ttg_banner\n\t\t\t\t\t\t\t\t SET \n\t\t\t\t\t\t\t\t\t\tbanner_src = '{$this->userInfo[textfield]}',\n\t\t\t\t\t\t\t\t\t\ttitle = '{$this->userInfo[title]}',\n\t\t\t\t\t\t\t\t\t\ttime = NOW(),\n\t\t\t\t\t\t\t\t\t\trecom = '{$this->userInfo[recom]}'\n\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\tid = {$this->userInfo[banner_id]}\n\t\t\t\t\t\t\t\tLIMIT\n\t\t\t\t\t\t\t\t\t\t1";
return parent::aud($_sql);
}
public function deleteRotatain()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcms_rotatain\n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t1";
return parent::aud($_sql);
}
public function deleteLink()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcms_link \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}'";
return parent::aud($_sql);
}
public function deleteManage()
{
$_sql = "delete from cms_manage where id='{$this->id}' limit 1";
return parent::aud($_sql);
}
public function deleteComment()
{
$_sql = "delete from cms_comment where id='{$this->id}' limit 1;";
return parent::aud($_sql);
}
public function deleteMenu()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\ttg_menu \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tpid='{$this->pid}' \n\t\t\t\t\t\t\t\t\t\tOR\n\t\t\t\t\t\t\t\t\t\t\t\tcid='{$this->pid}'";
return parent::aud($_sql);
}
public function deleteManage()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\tcms_manage \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\tLIMIT 1";
return parent::aud($_sql);
}
public function deletePremission()
{
$_sql = "DELETE FROM \n\t\t\t\t\t\t\t\t\t\t\t\t\tcms_premission \n\t\t\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\t\t\t\t\tid='{$this->id}' \n\t\t\t\t\t\t\t\t\t\tLIMIT \n\t\t\t\t\t\t\t\t\t\t\t\t1";
return parent::aud($_sql);
}
public function addUser()
{
$_sql = "INSERT INTO \n\t\t\t\t\t\t\t\t\t\t\t\tcms_user (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tuser,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tpass,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\temail,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tquestion,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tanswer,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tface,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tstate,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttime,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tdate\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tVALUES (\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->user}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->pass}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->email}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->question}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->answer}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->face}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->state}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$this->time}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tNOW()\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t)";
return parent::aud($_sql);
}
public function updateNav()
{
$_sql = "update cms_nav set nav_name='{$this->nav_name}', nav_info='{$this->nav_info}' where id='{$this->id}' limit 1;";
return parent::aud($_sql);
}
