www.gusucode.com > 教程素材资源下载论坛网站源码程序 > 教程素材资源下载论坛/整站源码/source/class/table/table_common_taskvar.php
<?php /** * [Discuz!] (C)2001-2099 Comsenz Inc. * This is NOT a freeware, use is subject to license terms * * $Id: table_common_taskvar.php 27781 2012-02-14 07:38:55Z zhengqingpeng $ */ if(!defined('IN_DISCUZ')) { exit('Access Denied'); } class table_common_taskvar extends discuz_table { public function __construct() { $this->_table = 'common_taskvar'; $this->_pk = 'taskvarid'; parent::__construct(); } public function fetch_all_by_taskid($taskid, $variable = '') { if(!$taskid) { return; } $variable = $variable ? ' AND '.($variable !== 'IS NOT NULL' ? DB::field('variable', $variable) : 'variable IS NOT NULL') : ''; return DB::fetch_all("SELECT * FROM %t WHERE %i%i", array($this->_table, DB::field('taskid', $taskid), $variable)); } public function get_value_by_taskid($taskid, $variable) { $result = $this->fetch_all_by_taskid($taskid, $variable); return $result[0]['value']; } public function update_by_taskid($taskid, $variable, $val) { if(!$val || !is_array($val)) { return; } return DB::update($this->_table, $val, array('taskid' => $taskid, 'variable' => $variable), 'UNBUFFERED'); } public function delete_by_taskid($taskid) { if(!$taskid) { return; } return DB::delete($this->_table, DB::field('taskid', $taskid)); } } ?>