/** * 会员注册 * @author MaWei (http://www.phpyrb.com) * @date 2014-10-6 下午3:28:30 */ function register() { $data = array(); $data['uname'] = text($_REQUEST['name']); $data['passwd'] = text($_REQUEST['passwd']); $data['email'] = text($_REQUEST['email']); $data['status'] = 1; $data['sex'] = 3; $data['lasttime'] = $data['registertime'] = time(); $data['lastip'] = get_client_ip(); //检测用户名 if ($this->member->checkname($data['uname'])) { echo json_encode(array('status' => null, 'msg' => '用户名已存在')); exit; } //检测邮箱 if ($this->member->checkemail($data['email'])) { echo json_encode(array('status' => null, 'msg' => '邮箱已存在')); exit; } $data['passwd'] = $this->member->encrypt($data['passwd']); $reid = add_updata($data, 'Member'); if ($reid === false) { echo json_encode(array('status' => -1, 'msg' => '非常抱歉,由于网络原因!注册失败!')); } else { echo json_encode(array('status' => 1, 'msg' => '恭喜您!注册成功!')); } }
/** * 文件上传保存 * @author MaWei (http://www.phpyrb.com) * @date 2014-10-19 下午2:33:29 */ function upload() { $_FILES['file']['name']; $data = array(); dump($this->mid); $data['uid'] = $this->mid; $data['title'] = text($_REQUEST['title']); $data['cateid'] = intval($_REQUEST['cateid']); $data['type'] = intval($_REQUEST['sourctype']); $data['grade'] = intval($_REQUEST['grade']); $data['keyword'] = text($_REQUEST['keyword']); $data['discription'] = text($_REQUEST['discription']); $data['uptime'] = time(); $reid = add_updata($data, 'Sourc'); if ($reid) { $attach = array(); $file = fileUpload(); $attach['sourc_id'] = $reid; $attach['name'] = $file['name']; $attach['path'] = $file['path']; $attach['size'] = $file['size']; $attach['hash'] = $file['hash']; $reid = add_updata($attach, 'SourcAttach'); } dump($reid); }
/** * 添加、修改数据写入 * @return array * @author MaWei (http://www.phpyrb.com) * @date 2014-10-5 上午10:55:33 */ function add_upadta() { $reid = false; switch ($_REQUEST['type']) { case 'HomeMenu': $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['pid'] = intval($_REQUEST['pid']); $data['name'] = text($_REQUEST['name']); $data['key'] = text($_REQUEST['key']); $data['position'] = $_REQUEST['position'] ? text($_REQUEST['position']) : 'topnavmenu'; $data['sort'] = intval($_REQUEST['sort']); $data['action'] = text($_REQUEST['action']); $data['url'] = $_REQUEST['url']; $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $reid = add_updata($data, 'HomeMenu'); $url = U('Admin/Other/index'); break; case 'friendurl': $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['name'] = text($_REQUEST['name']); $data['url'] = text($_REQUEST['url']); $data['sort'] = intval($_REQUEST['sort']); $reid = add_updata($data, 'FriendUrl'); $url = U('Admin/Other/friendurl'); break; default: exit; } if ($reid === false) { $this->error('添加修改失败!', $url); } else { $this->success('添加修改成功!', $url); } }
/** * 管理员注册修改 * @author MaWei (http://www.phpyrb.com) * @date 2014-10-8 下午4:27:53 */ function register() { $data = array(); $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['name'] = text($_REQUEST['name']); $data['passwd'] = $this->adminuser->encrypt($_REQUEST['passwd']); $data['role'] = $_REQUEST['role'] ? intval($_REQUEST) : 1; $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $data['uptime'] = time(); $reid = add_updata($data, 'AdminUser'); }
/** * 下载日志 * @author MaWei (http://www.phpyrb.com) * @date 2014-10-6 下午8:52:52 */ function downloadlog() { for ($i = 0; $i < 1000; $i++) { $data = array(); $data['sourc_id'] = rand(1000, 5000); $data['title'] = 'python手册' . $data['sourc_id']; $data['uid'] = rand(1, 500); $data['uname'] = 'phpyrb' . $data['uid']; $data['ctime'] = rand(1381495906, time()); add_updata($data, 'DownloadLog'); } }
/** * 数据添加、修改 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-3 上午2:05:46 */ function addupdata() { $data = array(); $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['key'] = h(text($_REQUEST['key'])); $data['value'] = h(text($_REQUEST['value'])); $data['position'] = h(text($_REQUEST['position'])); $data['position'] = h(text($_REQUEST['url'])); $data['status'] = intval($_REQUEST['status']); $data['sort'] = intval($_REQUEST['sort']); $data['pid'] = intval($_REQUEST['pid']); $reid = add_updata($data, 'AdminSystemMenu| '); if ($reid === false) { $this->error('保存失败!', U('Admin/AdminMenu/edit', array('menuid' => intval($_REQUEST['id'])))); } else { $this->success('保存成功!', U('Admin/AdminMenu/index')); } }
/** * 分类、标签数据更新、添加 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-10 下午3:52:53 */ function addupdata() { $data = array(); $model = null; $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['status'] = intval($_REQUEST['status']); $data['name'] = text($_REQUEST['name']); switch ($this->type) { case 'cate': if ($_REQUEST['pid'] == 0) { $data['path'] = 0; } else { $path = M('SourcCategory')->where(array('id' => intval($_REQUEST['pid'])))->getField('path'); $data['path'] = $path . ',' . $_REQUEST['pid']; } $data['pid'] = intval($_REQUEST['pid']); $data['icon'] = text($_REQUEST['icon']); $model = 'SourcCategory'; break; case 'tag': $model = 'SourcTag'; break; case 'type': $model = 'SourcType'; break; default: break; } $reid = add_updata($data, "{$model}"); if ($reid === false) { $this->error('添加修改失败', U('Admin/CateTag/edit', array('type' => $_REQUEST['type'], 'id' => intval($_REQUEST['id'])))); } else { $this->success('添加修改成功', U('Admin/CateTag/index', array('type' => $_REQUEST['type']))); } }
/** * 分类、标签数据更新、添加 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-10 下午3:52:53 */ function addupdata() { $data = array(); if ($_REQUEST['type'] == 'cate') { if ($_REQUEST['pid'] == 0) { $data['path'] = 0; } else { $path = M('SourcCategory')->where(array('id' => intval($_REQUEST['pid'])))->getField('path'); $data['path'] = $path . ',' . $_REQUEST['pid']; } } $data['name'] = h(text($_REQUEST['name'])); $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $_REQUEST['type'] == 'cate' && ($data['pid'] = intval($_REQUEST['pid'])); $model = $_REQUEST['type'] == 'cate' ? 'SourcCategory' : 'SourcTag'; $reid = add_updata($data, "{$model}"); if ($reid === false) { $this->error('添加修改失败', U('Admin/CateTag/edit', array('type' => $_REQUEST['type'], 'id' => intval($_REQUEST['id'])))); } else { $this->success('添加修改成功', U('Admin/CateTag/index', array('type' => $_REQUEST['type']))); } }
/** * 会员添加修改数据库操作 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-4 下午3:23:27 */ function addupdata() { $data = array(); $table = null; $type = $_REQUEST['type']; switch ($type) { case 'member': $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['uname'] = text($_REQUEST['name']); $data['email'] = text($_REQUEST['email']); $_REQUEST['passwd'] && ($data['passwd'] = sha1_encrypt(text($_REQUEST['passwd']))); $data['home'] = text($_REQUEST['home']); $data['status'] = intval($_REQUEST['status']); $data['qq'] = intval($_REQUEST['qq']); $data['sex'] = intval($_REQUEST['sex']); $data['grade'] = intval($_REQUEST['grade']); if ($_FILES['file']['name']) { $avatar = uploads(array('path' => 'avatar', 'ImgWidth' => 150, 'ImgHeight' => 150), true); $data['avatar'] = $avatar['thumb']; } $data['lasttime'] = time(); empty($_REQUEST['uid']) && ($data['registertime'] = time()); $data['lastip'] = get_client_ip(); $table = 'Member'; $jumpUrl = U('Admin/Member/index'); break; case 'grade': if (intval($_REQUEST['is_muti'])) { $name = $_REQUEST['name']; $grade = intval($_REQUEST['grade']); $type = intval($_REQUEST['gradetype']); if (strpos($name, ',') !== false) { $name = explode(',', $name); $data['type'] = $type; $i = 1; $reid = null; foreach ($name as $k => $v) { $data['name'] = text($v); $data['level'] = $i; $data['grade'] = $i * $grade; $reid = add_updata($data, 'Grade'); $i++; } if ($reid === false) { $this->error('保存失败!', U('Admin/Member/grade')); } else { $this->success('保存成功!', U('Admin/Member/grade')); } exit; } else { $data['name'] = text($name); $data['level'] = 1; $data['grade'] = $grade; } } else { $data['name'] = text($_REQUEST['name']); $data['level'] = intval($_REQUEST['level']); $data['grade'] = intval($_REQUEST['grade']); $data['type'] = intval($_REQUEST['gradetype']); } $table = 'Grade'; $jumpUrl = U('Admin/Member/grade'); break; case 'gradeType': $data['name'] = text($_REQUEST['name']); $data['alias'] = text($_REQUEST['alias']); $table = 'GradeType'; $jumpUrl = U('Admin/Member/gradeType'); break; default: $this->error('非法操作!', U('Admin/Member/index')); exit; } $reid = add_updata($data, $table); if ($reid === false) { $this->error('保存失败!', $jumpUrl); } else { $this->success('保存成功!', $jumpUrl); } }
/** * 更新到数据库操作 * @author MaWei (http://www.phpyrb.com) * @date 2014-9-7 下午8:47:33 */ function add_updata() { $type = $_REQUEST['type'] ? text($_REQUEST['type']) : exit(null); $data = array(); $_REQUEST['id'] && ($id = $data['id'] = intval($_REQUEST['id'])); switch ($type) { case 'menu': $data['pid'] = intval($_REQUEST['pid']); $data['name'] = text($_REQUEST['name']); $data['key'] = text($_REQUEST['key']); $data['position'] = $data['pid'] == 0 ? 0 : 1; // $data['position'] = intval($_REQUEST['position']); $data['sort'] = intval($_REQUEST['sort']); $data['action'] = intval($_REQUEST['action']); $data['url'] = $_REQUEST['url']; $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $reid = add_updata($data, 'AdminSystemMenu'); if ($reid === false) { $this->error('添加失败!', U('Admin/System/menu', array('id' => $id))); } else { $this->success('添加成功!', U('Admin/System/menu')); } break; } }
/** * 更新到数据库操作 * @author MaWei (http://www.phpyrb.com) * @date 2014-9-7 下午8:47:33 */ function add_updata() { $type = $_REQUEST['type'] ? text($_REQUEST['type']) : exit(null); $data = array(); $_REQUEST['id'] && ($id = $data['id'] = intval($_REQUEST['id'])); $reid = $url = false; switch ($type) { case 'AdminMenu': $data['pid'] = intval($_REQUEST['pid']); $data['name'] = text($_REQUEST['name']); $data['key'] = text($_REQUEST['key']); $data['position'] = $data['pid'] == 0 ? 0 : 1; // $data['position'] = intval($_REQUEST['position']); $data['sort'] = intval($_REQUEST['sort']); $data['action'] = text($_REQUEST['action']); $data['url'] = $_REQUEST['url']; $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $reid = add_updata($data, 'AdminSystemMenu'); $url = U('Admin/System/adminmenu'); break; default: exit; } if ($reid === false) { $this->error('添加修改失败!'); } else { $this->success('添加修改成功!'); } }
/** * 会员添加修改数据库操作 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-4 下午3:23:27 */ function addupdata() { $data = array(); $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['uname'] = text($_REQUEST['name']); $data['email'] = text($_REQUEST['email']); $_REQUEST['passwd'] && ($data['passwd'] = sha1_encrypt(text($_REQUEST['passwd']))); $data['home'] = text($_REQUEST['home']); $data['status'] = intval($_REQUEST['status']); $data['qq'] = intval($_REQUEST['qq']); $data['sex'] = intval($_REQUEST['sex']); if ($_FILES['file']['name']) { $avatar = uploads(array('path' => 'avatar', 'ImgWidth' => 150, 'ImgHeight' => 150), true); $data['avatar'] = $avatar['thumb']; } $data['lasttime'] = time(); empty($_REQUEST['uid']) && ($data['registertime'] = time()); $data['lastip'] = get_client_ip(); $reid = add_updata($data, 'Member'); if ($reid === false) { $this->error('保存失败!', U('Admin/Member/index')); } else { $this->success('保存成功!', U('Admin/Member/index')); } }
/** * 资源评论 * @author MaWei (http://www.phpyrb.com) * @date 2014-10-14 下午3:53:37 */ function addcomment() { // if(!$this->uid){ // ejson('请登入后评论!',0); // } $data['content'] = text($_REQUEST['content']); $data['reply_id'] = intval($_REQUEST['replyid']); $data['sourc_id'] = intval($_REQUEST['sid']); $data['uid'] = $this->uid; $data['ctime'] = time(); $reid = add_updata($data, 'SourcComment'); if ($reid === false) { ejson('评论失败,请重新评论!', 0); } else { $data['id'] = $reid; $this->assign('info', $data); $this->assign('userinfo', $this->userinfo); $content = $this->fetch('comment'); ejson('评论成功!', 1, array('html' => $content)); } }
/** * 书箱添加修改数据库 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-7 下午10:45:59 */ function add_updata() { $data = array(); $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['cateid'] = intval($_REQUEST['cateid']); $data['price'] = intval($_REQUEST['price']); $data['score'] = intval($_REQUEST['score']); $data['status'] = intval($_REQUEST['status']); $data['title'] = h(text($_REQUEST['title'])); $data['author'] = h(text($_REQUEST['author'])); $data['publish'] = h(text($_REQUEST['publish'])); $data['book_base'] = h(text($_REQUEST['intro'])); if ($_FILES['file']['name']) { $avatar = uploads(array('path' => 'cover', 'ImgWidth' => 105, 'ImgHeight' => 160), true); $data['cover'] = $avatar['thumb']; } $_REQUEST['id'] ? $data['utime'] = time() : ($data['ctime'] = $data['utime'] = time()); $reid = add_updata($data, 'Book'); if ($reid === false) { $this->error('添加修改失败', U('Admin/Book/edit', array('id' => intval($_REQUEST['id'])))); } else { $this->success('添加修改成功', U('Admin/Book/index')); } }
/** * 书箱添加修改数据库 * @author MaWei (http://www.phpyrb.com) * @date 2014-8-7 下午10:45:59 */ function add_updata() { for ($i = 0; $i < 50; $i++) { $data = array(); $_REQUEST['id'] && ($data['id'] = intval($_REQUEST['id'])); $data['cateid'] = intval($_REQUEST['cateid']); $data['tagid'] = implode(',', $_REQUEST['tagids']); $data['grade'] = intval($_REQUEST['grade']); $data['status'] = $_REQUEST['status'] ? intval($_REQUEST['status']) : 1; $data['title'] = h(text($_REQUEST['title'])); $data['uid'] = $this->uid; $data['uptime'] = time(); $data['recommend'] = intval($_REQUEST['recommend']); $intro = text($_REQUEST['intro']); $data['keyword'] = text($_REQUEST['keyword']); $data['discription'] = $_REQUEST['discription'] ? $_REQUEST['discription'] : mb_substr($intro, 0, 150); if ($_FILES['cover']['name']) { $avatar = uploads(array('path' => 'cover', 'ImgWidth' => 105, 'ImgHeight' => 160, 'filename' => 'cover'), true); $data['cover'] = $avatar['thumb']; } $reid = add_updata($data, 'Sourc'); if ($reid === false) { $this->error('添加修改失败', U('Admin/Sourc/edit')); } else { $temp = array(); $temp['sourc_id'] = $_REQUEST['id'] ? intval($_REQUEST['id']) : $reid; $temp['intro'] = $intro; $temp['content'] = $_REQUEST['content']; $reid = add_updata($temp, 'SourcContent', 'sourc_id'); // if($reid === false){ // $this->error('添加修改失败',U('Admin/Sourc/index')); // } // $this->success('添加修改成功',U('Admin/Sourc/index')); } } }
/** * 把文件插入数据库 * @param array $_file * @return int $reid * @author MaWei (http://www.phpyrb.com) * @date 2014-9-21 下午11:35:14 */ function inputAttch($_file) { $data = array(); $data['name'] = $_file['name']; $data['size'] = $_file['size']; $data['path'] = $_file['savepath'] . $_file['savename']; $data['hash'] = $_file['hash']; $reid = add_updata($data, 'SourcAttach'); return $reid; }