Home
last modified time | relevance | path

Searched refs:simple_select (Results 1 – 25 of 260) sorted by relevance

1234567891011

/dports/www/mybb/mybb-mybb_1829/inc/
H A Dclass_datacache.php119 $query = $db->simple_select("datacache", "title,cache");
321 $query = $db->simple_select("datacache", "title", $where);
443 $query = $db->simple_select("datacache", "cache", "title='{$name}'");
479 $query = $db->simple_select('attachtypes', '*', 'enabled=1');
518 $query = $db->simple_select("icons", "iid, name, path");
537 $query = $db->simple_select("badwords", "*");
554 $query = $db->simple_select("usergroups");
600 $query = $db->simple_select("forumpermissions");
956 $query = $db->simple_select("mailqueue", "COUNT(*) AS queue_size");
1031 $query = $db->simple_select("banfilters", "fid,filter", "type=1");
[all …]
H A Dfunctions_rebuild.php18 …$query = $db->simple_select("forums", "SUM(threads) AS numthreads, SUM(posts) AS numposts, SUM(una…
21 $query = $db->simple_select("users", "COUNT(uid) AS users");
37 …$query = $db->simple_select('threads', 'COUNT(tid) AS threads, SUM(replies) AS replies, SUM(unappr…
42 …$query = $db->simple_select('threads', 'COUNT(tid) AS threads, SUM(replies)+SUM(unapprovedposts)+S…
48 …$query = $db->simple_select('threads', 'COUNT(tid) AS threads, SUM(replies)+SUM(unapprovedposts)+S…
69 …$query = $db->simple_select("posts", "COUNT(pid) AS replies", "tid='{$tid}' AND pid!='{$thread['fi…
73 …$query = $db->simple_select("posts", "COUNT(pid) AS unapprovedposts", "tid='{$tid}' AND pid != '{$…
77 …$query = $db->simple_select("posts", "COUNT(pid) AS deletedposts", "tid='{$tid}' AND pid != '{$thr…
102 $query = $db->simple_select("polls", "pid, numoptions", "pid='".(int)$pid."'");
106 …$query = $db->simple_select("pollvotes", "voteoption, COUNT(vid) AS vote_count", "pid='{$poll['pid…
H A Dclass_moderation.php168 $query = $db->simple_select('threads', 'tid', "closed='moved|$tid'");
201 $query = $db->simple_select('posts', 'pid, uid, visible', "tid='{$tid}'");
284 $query = $db->simple_select('threads', 'tid', "closed='moved|$tid'");
396 $query = $db->simple_select("threads", "*", "tid IN ($tids_list)");
548 $query = $db->simple_select("threads", "*", "tid IN ($tids_list)");
1178 $query = $db->simple_select("polls", "*", "tid = '{$thread['tid']}'");
1196 $query = $db->simple_select("pollvotes", "*", "pid = '{$poll['pid']}'");
1211 $query = $db->simple_select("posts", "*", "tid = '{$thread['tid']}'");
2854 $query = $db->simple_select("posts", 'pid, visible', "pid IN ($pid_list)");
3527 $query = $db->simple_select("threads", "*", "tid IN ($tids_list)");
[all …]
H A Dfunctions_user.php21 …$query = $db->simple_select("users", "COUNT(*) as user", "uid='".(int)$uid."'", array('limit' => 1…
135 $query = $db->simple_select("users", "salt", "uid='$uid'");
334 …$query = $db->simple_select("threadsubscriptions", "*", "tid='".(int)$tid."' AND uid='".(int)$uid.…
408 …$query = $db->simple_select("forumsubscriptions", "*", "fid='".$fid."' AND uid='{$uid}'", array('l…
595 …$query = $db->simple_select("posts", "COUNT(pid) AS draftcount", "visible = '-2' AND uid = '{$mybb…
639 $query = $db->simple_select("users", "usertitle,postnum", "uid='$uid'", array('limit' => 1));
690 $query = $db->simple_select("privatemessages", "COUNT(pmid) AS pms_total", "uid='".$uid."'");
698 …$query = $db->simple_select("privatemessages", "COUNT(pmid) AS pms_unread", "uid='".$uid."' AND st…
773 …$query = $db->simple_select('questions', 'qid, shown', "active=1{$excl_old}", array('limit' => 1, …
H A Dfunctions_upload.php45 …$query = $db->simple_select("attachments", "aid, attachname, thumbnail, visible", "aid='{$aid}' AN…
50 …$query = $db->simple_select("attachments", "aid, attachname, thumbnail, visible", "aid='{$aid}' AN…
67 …$query = $db->simple_select("attachments", "COUNT(aid) as numreferences", "attachname='".$db->esca…
77 …$query_indir = $db->simple_select("attachments", "COUNT(aid) as indir", "attachname LIKE '".$db->e…
108 $query = $db->simple_select("attachments", "*", "posthash='$posthash'");
112 $query = $db->simple_select("attachments", "*", "pid='$pid'");
130 …$query2 = $db->simple_select("attachments", "COUNT(aid) as numreferences", "attachname='".$db->esc…
445 …$query = $db->simple_select("attachments", "SUM(filesize) AS ausage", "uid='".$mybb->user['uid']."…
468 …$query = $db->simple_select("attachments", "*", "filename='".$db->escape_string($attachment['name'…
485 $query = $db->simple_select("attachments", "COUNT(aid) AS numattachs", $uploaded_query);
[all …]
H A Dadminfunctions_templates.php42 …$query = $db->simple_select("templates", "tid, sid, template", "title = '".$db->escape_string($tit…
68 …$query = $db->simple_select("templates", "title, template", "title='".$db->escape_string($title)."…
75 …$query = $db->simple_select("templatesets", "sid", "sid NOT IN (".implode(',', $template_sets).") …
/dports/www/mybb/mybb-mybb_1829/admin/modules/tools/
H A Drecount_rebuild.php28 $query = $db->simple_select("forums", "COUNT(*) as num_forums");
55 $query = $db->simple_select("threads", "COUNT(*) as num_threads");
80 $query = $db->simple_select("polls", "COUNT(*) as num_polls");
105 $query = $db->simple_select("users", "COUNT(uid) as num_users");
115 $query = $db->simple_select("forums", "fid", "usepostcounts = 0");
154 $query = $db->simple_select("users", "COUNT(uid) as num_users");
202 $query = $db->simple_select("users", "COUNT(uid) as num_users");
234 $query = $db->simple_select("users", "COUNT(uid) as num_users");
266 $query = $db->simple_select("users", "COUNT(uid) as num_users");
293 $query = $db->simple_select("users", "COUNT(uid) as num_users");
[all …]
H A Dstatistics.php39 $query = $db->simple_select("stats", "COUNT(*) as total");
83 …$query = $db->simple_select("stats", "*", "dateline >= '".(int)$start_dateline."' AND dateline <= …
155 …$query = $db->simple_select("stats", "*", "dateline >= '".(int)$start_dateline."' AND dateline <= …
245 …$query = $db->simple_select("stats", "dateline,num{$type}", "dateline <= '".(int)$end."'", array('…
258 …$query = $db->simple_select("stats", "dateline,num{$type}", "dateline >= '".(int)$start."'", array…
271 …$query = $db->simple_select("stats", "dateline,num{$type}", "dateline >= '".(int)$start."' AND dat…
/dports/www/mybb/mybb-mybb_1829/inc/tasks/
H A Ddelayedmoderation.php22 $query = $db->simple_select("delayedmoderation", "*", "delaydateline <= '".TIME_NOW."'");
48 $query2 = $db->simple_select("threads", "tid,closed", "tid IN({$delayedmoderation['tids']})");
85 $query2 = $db->simple_select("threads", "tid,sticky", "tid IN({$delayedmoderation['tids']})");
187 $query = $db->simple_select("threads", "subject", "tid='{$delayedmoderation['tids']}'");
204 $query2 = $db->simple_select("threads", "tid,visible", "tid IN({$delayedmoderation['tids']})");
229 $query2 = $db->simple_select("threads", "tid,visible", "tid IN({$delayedmoderation['tids']})");
H A Dusercleanup.php22 …$query = $db->simple_select("users", "uid, moderationtime, suspensiontime", "(moderationtime!=0 AN…
40 …$query = $db->simple_select("users", "uid, suspendsigtime", "suspendsignature != 0 AND suspendsigt…
54 $query = $db->simple_select("banned", "*", "lifted!=0 AND lifted<".TIME_NOW);
H A Duserpruning.php50 …$query = $db->simple_select('users', 'uid', "regdate<={$regdate} AND postnum<={$prunepostcount} AN…
58 …$query = $db->simple_select('posts', 'uid, COUNT(pid) as posts', "uid IN ('".implode("','", $users…
73 $query = $db->simple_select("users", "uid", "regdate<={$regdate} AND usergroup='5'");
/dports/www/mybb/mybb-mybb_1829/
H A Dshowthread.php207 …$query = $db->simple_select("threadsread", "dateline", "uid='{$mybb->user['uid']}' AND tid='{$thre…
212 …$query = $db->simple_select("forumsread", "dateline", "fid='{$fid}' AND uid='{$mybb->user['uid']}'…
317 $query = $db->simple_select('posts', 'pid', "tid={$tid} {$visibleonly}", $options);
345 $query = $db->simple_select('posts', 'pid', "tid='{$nextthread['tid']}'", $options);
375 $query = $db->simple_select("posts", "pid", "tid='".$nextthread['tid']."'", $options);
487 $query = $db->simple_select("polls", "*", "pid='".$thread['poll']."'", $options);
514 $query = $db->simple_select("pollvotes", "*", "{$user_check} AND pid='".$poll['pid']."'");
786 …$query = $db->simple_select("threadratings", "uid", "tid='{$tid}' AND uid='{$mybb->user['uid']}'");
880 $query = $db->simple_select("attachments", "*", "pid=".$mybb->input['pid']);
975 $query = $db->simple_select("posts p", "COUNT(*) AS replies", "p.tid='$tid' $visibleonly_p");
[all …]
H A Dsearch.php60 $query = $db->simple_select("searchlog", "*", "sid='$sid'");
376 …$query = $db->simple_select("threadsread", "tid,dateline", "uid='".$mybb->user['uid']."' AND tid I…
696 …$query = $db->simple_select("modtools", "tid, name", "type='t' AND (','||forums||',' LIKE '%,-1,%'…
699 …$query = $db->simple_select("modtools", "tid, name", "type='t' AND (CONCAT(',',forums,',') LIKE '%…
1181 $query = $db->simple_select("posts", "pid", "{$where_sql}", $options);
1190 $query = $db->simple_select("threads", "tid", $where_sql);
1261 $query = $db->simple_select("posts", "pid", "{$where_sql}", $options);
1270 $query = $db->simple_select("threads", "tid", $where_sql);
1331 $query = $db->simple_select("threads", "tid", $where_sql);
1411 $query = $db->simple_select("threads", "tid", $where_sql);
[all …]
H A Dmanagegroup.php40 $query = $db->simple_select("groupleaders", "*", "uid='{$mybb->user['uid']}' AND gid='{$gid}'");
109 …$query = $db->simple_select("joinrequests", "rid", "uid = '".(int)$user['uid']."' AND gid = '".(in…
274 $query = $db->simple_select("joinrequests", "COUNT(*) AS req", "gid='{$gid}'");
342 …$query = $db->simple_select("users", "*", "','||additionalgroups||',' LIKE '%,{$gid},%' OR usergro…
345 …$query = $db->simple_select("users", "*", "CONCAT(',',additionalgroups,',') LIKE '%,{$gid},%' OR u…
378 …$query = $db->simple_select("users", "*", "','||additionalgroups||',' LIKE '%,{$gid},%' OR usergro…
381 …$query = $db->simple_select("users", "*", "CONCAT(',',additionalgroups,',') LIKE '%,{$gid},%' OR u…
H A Dreputation.php167 …$query = $db->simple_select("reputation", "*", "adduid='".$mybb->user['uid']."' AND uid='{$uid}' A…
197 …$query = $db->simple_select("reputation", "*", "adduid='{$mybb->user['uid']}' AND dateline>'$times…
211 …$query = $db->simple_select("reputation", "*", "uid='{$uid}' AND adduid='{$mybb->user['uid']}' AND…
285 $query = $db->simple_select("reputation", "SUM(reputation) AS reputation_count", "uid='{$uid}'");
408 $query = $db->simple_select("reputation", "SUM(reputation) AS reputation_count", "uid='{$uid}'");
422 $query = $db->simple_select("reputation", "SUM(reputation) AS reputation_count", "uid='{$uid}'");
569 $query = $db->simple_select("reputation", "SUM(reputation) AS reputation_count", "uid='{$uid}'");
693 …$query = $db->simple_select("reputation r", "COUNT(r.rid) AS reputation_count", "r.uid='{$user['ui…
703 …$query = $db->simple_select("reputation", "SUM(reputation) AS reputation, COUNT(rid) AS total_repu…
728 $query = $db->simple_select("reputation", "reputation, dateline", "uid='{$user['uid']}'");
[all …]
/dports/www/mybb/mybb-mybb_1829/admin/modules/home/
H A Dindex.php171 $query = $db->simple_select("users", "COUNT(uid) AS numusers");
197 $query = $db->simple_select("users", "COUNT(uid) AS newusers", "regdate > '$timecut'");
201 $query = $db->simple_select("users", "COUNT(uid) AS activeusers", "lastvisit > '$timecut'");
211 …$query = $db->simple_select("threads", "COUNT(*) AS newthreads", "dateline > '$timecut' AND visibl…
226 …$query = $db->simple_select("posts", "COUNT(*) AS newposts", "dateline > '$timecut' AND visible='1…
230 …$query = $db->simple_select("reportedcontent", "COUNT(*) AS reported_posts", "type = 'post' OR typ…
234 …$query = $db->simple_select("reportedcontent", "COUNT(*) AS new_reported_posts", "reportstatus='0'…
238 …$query = $db->simple_select("attachments", "COUNT(*) AS numattachs, SUM(filesize) as spaceused", "…
244 $query = $db->simple_select("attachments", "COUNT(*) AS numattachs", "visible='0' AND pid > '0'");
/dports/www/mybb/mybb-mybb_1829/inc/plugins/
H A Dhello.php135 $query = $db->simple_select('templategroups', 'prefix', "prefix='{$group['prefix']}'");
147 …$query = $db->simple_select('templates', 'tid,title,template', "sid=-2 AND (title='{$group['prefix…
231 $query = $db->simple_select('settinggroups', 'gid', "name='hello'");
241 $query = $db->simple_select('settinggroups', 'MAX(disporder) AS disporder');
303 $query = $db->simple_select('settings', 'sid', "gid='{$gid}' AND name='{$setting['name']}'");
473 …$query = $db->simple_select('hello_messages', 'message', '', array('order_by' => 'mid', 'order_dir…
524 …$query = $db->simple_select('hello_messages', 'message', '', array('order_by' => 'mid', 'order_dir…
/dports/www/mybb/mybb-mybb_1829/install/resources/
H A Dupgrade30.php1268 $query = $db->simple_select("users", "COUNT(uid) AS usercount");
1828 $query = $db->simple_select("users", "COUNT(uid) AS ipcount");
1841 $query = $db->simple_select("threadratings", "COUNT(rid) AS ipcount");
1846 $query = $db->simple_select("sessions", "COUNT(sid) AS ipcount");
1851 $query = $db->simple_select("posts", "COUNT(pid) AS ipcount");
1861 $query = $db->simple_select("maillogs", "COUNT(mid) AS ipcount");
2164 $query = $db->simple_select("themes", "*", "tid='1'");
2248 $query = $db->simple_select("themes", "tid,properties,stylesheets");
2263 $query2 = $db->simple_select("themestylesheets", "name", "tid='{$theme['tid']}'");
2302 $query = $db->simple_select("themes", "*", "tid = '2'");
[all …]
H A Dupgrade13.php46 …$query = $db->simple_select("users", "username, uid", "1=1 GROUP BY uid, username HAVING count(*) …
110 $query = $db->simple_select("posts", "COUNT(pid) AS ipcount");
123 …$query = $db->simple_select("posts", "ipaddress, longipaddress, pid", "", array('limit_start' => $…
182 $query = $db->simple_select("users", "COUNT(uid) AS ipcount");
195 …$query = $db->simple_select("users", "regip, lastip, longlastip, longregip, uid", "", array('limit…
H A Dupgrade5.php255 $query = $db->simple_select("settings", "value", "name='bannedusernames'");
261 $query = $db->simple_select("settings", "value", "name='bannedemails'");
267 $query = $db->simple_select("settings", "value", "name='bannedips'");
534 $query = $db->simple_select("threads", "COUNT(*) as num_threads", "closed NOT LIKE 'moved|%'");
545 …$query = $db->simple_select("threads", "tid, firstpost", "closed NOT LIKE 'moved|%'", array("order…
552 …$query = $db->simple_select("posts", "COUNT(pid) AS replies", "tid='{$thread['tid']}' AND pid!='{$…
556 …$query = $db->simple_select("posts", "COUNT(pid) AS unapprovedposts", "tid='{$thread['tid']}' AND …
597 $query = $db->simple_select("forums", "fid");
H A Dupgrade12.php103 $query = $db->simple_select($table, "COUNT({$primary_key}) AS count");
747 $query = $db->simple_select("settinggroups", "gid, isdefault");
753 $query = $db->simple_select("settings", "gid, sid");
1020 $query = $db->simple_select("adminoptions");
1069 $query = $db->simple_select("users", "COUNT(uid) AS users");
1283 $db->simple_select("users", "uid", "avatar != '' AND avatardimensions = ''");
1482 $query = $db->simple_select("posts", "COUNT(pid) AS ipcount");
1554 $query = $db->simple_select("users", "COUNT(uid) AS ipcount");
1638 $query = $db->simple_select("events", "COUNT(eid) AS eventcount");
1903 $query = $db->simple_select("themes", "*", "tid=1");
[all …]
/dports/www/mybb/mybb-mybb_1829/archive/
H A Dindex.php147 …$query = $db->simple_select("posts", "pid", "tid='{$id}' AND visible='1'", array('order_by' => 'da…
165 $query = $db->simple_select("attachments", "*", "pid IN ({$pids})");
252 …$query = $db->simple_select("threads", "COUNT(tid) AS threads", "fid='{$id}' AND visible='1' {$use…
312 $query = $db->simple_select("forums", "COUNT(fid) AS subforums", "pid='{$id}'");
331 …$query = $db->simple_select("announcements", "*", "startdate < '{$time}' AND (enddate > '{$time}' …
356 …$query = $db->simple_select("threads", "*", "fid='{$id}' AND visible='1' AND sticky='1' AND closed…
394 …$query = $db->simple_select("threads", "*", "fid='{$id}' AND visible='1' AND sticky='0' AND closed…
480 …$query = $db->simple_select("forums", "*", "active!=0 AND password=''", array('order_by' =>'pid, d…
/dports/www/mybb/mybb-mybb_1829/admin/inc/
H A Dfunctions.php199 …$query = $db->simple_select("forums", "name, fid, pid", "", array("order_by" => "disporder, pid"));
253 $query = $db->simple_select("usergroups", "gid");
256 …$query2 = $db->simple_select("forumpermissions", $db->escape_string(implode(',', array_keys($permi…
261 …$query2 = $db->simple_select("usergroups", $db->escape_string(implode(',', array_keys($usergroup_p…
443 …$query = $db->simple_select("adminoptions", "permissions", "(uid='-{$get_gid}' OR uid='0') AND per…
463 …$query = $db->simple_select("adminoptions", "permissions, uid", "(uid='{$uid}'{$group_sql}) AND pe…
552 $query = $db->simple_select("adminoptions", "uid, permissions", "permissions != ''");
613 …$query = $db->simple_select("adminoptions", "loginattempts, loginlockoutexpiry", "uid='".(int)$uid…
705 $query = $db->simple_select("posts", "pid", "uid = '".$uid."' AND dateline < '".$date."'");
/dports/www/mybb/mybb-mybb_1829/admin/modules/style/
H A Dtemplates.php440 $query = $db->simple_select("templatesets", "*", "sid='{$sid}'");
497 $query = $db->simple_select("templatesets", "title", "sid='{$sid}'");
543 $query = $db->simple_select("templates", "*", "tid='{$mybb->input['tid']}'");
585 $query = $db->simple_select("templatesets", "title", "sid='{$sid}'");
904 $query = $db->simple_select("templatesets", "sid, title");
1076 $query = $db->simple_select("templatesets", "sid, title");
1395 $query = $db->simple_select("templategroups", "*", "gid='{$gid}'");
1434 $query = $db->simple_select("templatesets", "*", "sid='{$sid}' AND sid > 0");
1447 $query = $db->simple_select("themes", "properties");
1743 $query = $db->simple_select("templategroups", "*");
[all …]
H A Dthemes.php38 $query = $db->simple_select("themes", "*", "tid='".$mybb->get_input('tid', MyBB::INPUT_INT)."'");
424 $query = $db->simple_select("themes", "tid, name");
678 $query = $db->simple_select("templates", "*", "sid='".(int)$properties['templateset']."'");
797 $query = $db->simple_select("templates", "*", "sid='{$sid}'");
911 $query = $db->simple_select("themes", "tid, name");
1030 $query = $db->simple_select("themestylesheets", "cachefile", "tid='{$theme['tid']}'");
1199 $query = $db->simple_select("themes", "tid", "tid='".$update_array['pid']."'");
1599 $query = $db->simple_select("templatesets", "*", "", array('order_by' => 'title'));
1835 $query = $db->simple_select("themes", "name", "tid='{$stylesheet['tid']}'");
2200 $query = $db->simple_select("themes", "name", "tid='{$stylesheet['tid']}'");
[all …]

1234567891011