table_home_pic.php
4.7 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
<?php
/**
* [Discuz!] (C)2001-2099 Comsenz Inc.
* This is NOT a freeware, use is subject to license terms
*
* $Id: table_home_pic.php 31180 2012-07-24 03:51:03Z chenmengshu $
*/
if(!defined('IN_DISCUZ')) {
exit('Access Denied');
}
class table_home_pic extends discuz_table
{
public function __construct() {
$this->_table = 'home_pic';
$this->_pk = 'picid';
parent::__construct();
}
public function update_click($picid, $clickid, $incclick) {
$clickid = intval($clickid);
if($clickid < 1 || $clickid > 8 || empty($picid) || empty($incclick)) {
return false;
}
return DB::query('UPDATE %t SET click'.$clickid.' = click'.$clickid.'+\'%d\' WHERE picid = %d', array($this->_table, $incclick, $picid));
}
public function update_hot($picid, $num = 1) {
return DB::query('UPDATE %t SET hot=hot+\'%d\' WHERE picid=%d', array($this->_table, $num, $picid));
}
public function update_sharetimes($picid, $num = 1) {
return DB::query('UPDATE %t SET sharetimes=sharetimes+\'%d\' WHERE picid=%d', array($this->_table, $num, $picid));
}
public function fetch_all_by_uid($uids, $start = 0, $limit = 0, $picids = 0) {
if(empty($uids)) {
return array();
}
$picidsql = $picids ? DB::field('picid', $picids).' AND ' : '';
return DB::fetch_all("SELECT * FROM %t WHERE $picidsql ".DB::field('uid', $uids).DB::limit($start, $limit), array($this->_table));
}
public function update_for_uid($uids, $picids, $data) {
if(!empty($data) && is_array($data)) {
return DB::update($this->_table, $data, DB::field('picid', $picids).' AND '.DB::field('uid', $uids));
}
return 0;
}
public function fetch_all_by_albumid($albumids, $start = 0, $limit = 0, $picids = 0, $orderbypicid = 0, $orderbydateline = 0, $uid = 0, $count = false) {
$albumids = $albumids < 0 ? 0 : $albumids;
$picidsql = $picids ? DB::field('picid', $picids).' AND ' : '';
if($orderbypicid) {
$ordersql = 'ORDER BY picid DESC ';
} elseif($orderbydateline) {
$ordersql = 'ORDER BY dateline DESC ';
}
$uidsql = $uid ? ' AND '.DB::field('uid', $uid) : '';
if ($count) {
return DB::result_first("SELECT COUNT(*) FROM %t WHERE $picidsql ".DB::field('albumid', $albumids)." $uidsql", array($this->_table));
} else {
return DB::fetch_all("SELECT * FROM %t WHERE $picidsql ".DB::field('albumid', $albumids)." $uidsql $ordersql".DB::limit($start, $limit), array($this->_table));
}
}
public function update_for_albumid($albumid, $data) {
if(!empty($data) && is_array($data)) {
return DB::update($this->_table, $data, DB::field('albumid', $albumid));
}
return 0;
}
public function delete_by_uid($uids) {
return DB::query("DELETE FROM %t WHERE ".DB::field('uid', $uids), array($this->_table));
}
public function delete_by_albumid($albumids) {
return DB::query("DELETE FROM %t WHERE ".DB::field('albumid', $albumids), array($this->_table));
}
public function fetch_all_by_sql($where = '1', $orderby = '', $start = 0, $limit = 0, $count = 0, $joinalbum = 1) {
if(!$where) {
$where = '1';
}
if($count) {
return DB::result_first("SELECT count(*) FROM ".DB::table($this->_table)." p WHERE %i", array($where));
}
return DB::fetch_all("SELECT ".($joinalbum ? 'a.*, ' : '')."p.* FROM ".DB::table($this->_table)." p ".($joinalbum ? "LEFT JOIN ".DB::table('home_album')." a USING(albumid)" : '')." WHERE %i ".($orderby ? "ORDER BY $orderby " : '').DB::limit($start, $limit), array($where));
}
public function fetch_albumpic($albumid, $uid) {
return DB::fetch_first("SELECT filepath, thumb FROM %t WHERE albumid=%d AND uid=%d ORDER BY thumb DESC, dateline DESC LIMIT 0,1", array($this->_table, $albumid, $uid));
}
public function check_albumpic($albumid, $status = NULL, $uid = 0) {
$sql = is_numeric($albumid) ? DB::field('albumid', $albumid) : '';
$sql .= $uid ? ($sql ? ' AND ' : '').DB::field('uid', $uid) : '';
$sql .= $status === NULL ? '' : ($sql ? ' AND ' : '').DB::field('status', $status);
return DB::result_first("SELECT COUNT(*) FROM %t WHERE $sql", array($this->_table));
}
public function count_size_by_uid($uid) {
return DB::result_first("SELECT SUM(size) FROM %t WHERE uid=%d", array($this->_table, $uid));
}
public function fetch_by_id_idtype($id) {
if(!$id) {
return false;
}
return DB::fetch_first('SELECT * FROM %t WHERE %i', array($this->_table, DB::field('picid', $id)));
}
public function update_dateline_by_id_idtype_uid($id, $idtype, $dateline, $uid) {
if(empty($id) || empty($idtype) || empty($dateline) || empty($uid)) {
return false;
}
return DB::update($this->_table, array('dateline' => intval($dateline)), array($idtype => intval($id), 'uid' => intval($uid)));
}
}
?>