119 lines
3.8 KiB
PHP
119 lines
3.8 KiB
PHP
<?php
|
|
|
|
/**
|
|
* This is NOT a freeware, use is subject to license terms
|
|
* 应用名称: 贴吧楼中楼回复 9.0
|
|
* 下载地址: https://addon.dismall.com/plugins/replyfloor.html
|
|
* 应用开发者: 乘凉
|
|
* 开发者QQ: 594433766
|
|
* 更新日期: 202505310549
|
|
* 授权域名: www.shitangsweet.com
|
|
* 授权码: 2025053105b89RrI3R9n
|
|
* 未经应用程序开发者/所有者的书面许可，不得进行反向工程、反向汇编、反向编译等，不得擅自复制、修改、链接、转载、汇编、发表、出版、发展与之有关的衍生产品、作品等
|
|
*/
|
|
|
|
|
|
/**
|
|
* $author: 乘凉 $
|
|
*/
|
|
|
|
if(!defined('IN_DISCUZ')) {
|
|
exit('Access Denied');
|
|
}
|
|
|
|
class table_replyfloor_attachment extends discuz_table {
|
|
|
|
public function __construct() {
|
|
$this->_table = 'plugin_replyfloor_attachment';
|
|
$this->_pk = 'id';
|
|
|
|
parent::__construct();
|
|
}
|
|
|
|
public function count_by_search_where($wherearr) {
|
|
$wheresql = empty($wherearr) ? '' : implode(' AND ', $wherearr);
|
|
return DB::result_first('SELECT COUNT(*) FROM '.DB::table($this->_table).($wheresql ? ' WHERE '.$wheresql : ''));
|
|
}
|
|
|
|
public function fetch_all_by_search_where($wherearr, $ordersql = '', $start = 0, $limit = 0) {
|
|
$wheresql = empty($wherearr) ? '' : implode(' AND ', $wherearr);
|
|
return DB::fetch_all('SELECT * FROM '.DB::table($this->_table).($wheresql ? ' WHERE '.$wheresql : '').' '.$ordersql.DB::limit($start, $limit), null, 'id');
|
|
}
|
|
|
|
public function fetch_by_id($id) {
|
|
return DB::fetch_first('SELECT * FROM %t WHERE id=%d', array($this->_table, $id));
|
|
}
|
|
|
|
public function fetch_all_by_id($ids, $ordersql = '') {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
return DB::fetch_all('SELECT * FROM %t WHERE id IN(%n) '.$ordersql, array($this->_table, $ids), 'id');
|
|
}
|
|
}
|
|
|
|
public function fetch_all_by_msgid($ids, $ordersql = '') {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
return DB::fetch_all('SELECT * FROM %t WHERE msgid IN(%n) '.$ordersql, array($this->_table, $ids), 'id');
|
|
}
|
|
}
|
|
|
|
public function fetch_all_by_tid($ids, $ordersql = '') {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
return DB::fetch_all('SELECT * FROM %t WHERE tid IN(%n) '.$ordersql, array($this->_table, $ids), 'id');
|
|
}
|
|
}
|
|
|
|
public function fetch_all_by_pid($ids, $ordersql = '') {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
return DB::fetch_all('SELECT * FROM %t WHERE pid IN(%n) '.$ordersql, array($this->_table, $ids), 'id');
|
|
}
|
|
}
|
|
|
|
public function fetch_all_by_authorid($ids, $ordersql = '') {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
return DB::fetch_all('SELECT * FROM %t WHERE uid IN(%n) '.$ordersql, array($this->_table, $ids), 'id');
|
|
}
|
|
}
|
|
|
|
public function update_by_ids($ids, $data) {
|
|
if(($id = dintval((array)$id, true)) && $data && is_array($data)) {
|
|
DB::update($this->_table, $data, DB::field($this->_pk, $id), true);
|
|
}
|
|
}
|
|
|
|
public function update_by_id($id, $data) {
|
|
if(($id = dintval($id, true)) && $data && is_array($data)) {
|
|
DB::update($this->_table, $data, DB::field($this->_pk, $id), true);
|
|
}
|
|
}
|
|
|
|
public function delete_by_id($ids) {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
DB::query('DELETE FROM %t WHERE id IN(%n)', array($this->_table, $ids), false, true);
|
|
}
|
|
}
|
|
|
|
public function delete_by_msgid($ids) {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
DB::query('DELETE FROM %t WHERE msgid IN(%n)', array($this->_table, $ids), false, true);
|
|
}
|
|
}
|
|
|
|
public function delete_by_pid($ids) {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
DB::query('DELETE FROM %t WHERE pid IN(%n)', array($this->_table, $ids), false, true);
|
|
}
|
|
}
|
|
|
|
public function delete_by_tid($ids) {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
DB::query('DELETE FROM %t WHERE tid IN(%n)', array($this->_table, $ids), false, true);
|
|
}
|
|
}
|
|
|
|
public function delete_by_authorid($ids) {
|
|
if(($ids = dintval((array)$ids, true))) {
|
|
DB::query('DELETE FROM %t WHERE uid IN(%n)', array($this->_table, $ids), false, true);
|
|
}
|
|
}
|
|
|
|
} |