/dports/www/mybb/mybb-mybb_1829/inc/ |
H A D | class_datacache.php | 119 $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 D | functions_rebuild.php | 18 …$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 D | class_moderation.php | 168 $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 D | functions_user.php | 21 …$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 D | functions_upload.php | 45 …$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 D | adminfunctions_templates.php | 42 …$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 D | recount_rebuild.php | 28 $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 D | statistics.php | 39 $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 D | delayedmoderation.php | 22 $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 D | usercleanup.php | 22 …$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 D | userpruning.php | 50 …$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 D | showthread.php | 207 …$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 D | search.php | 60 $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 D | managegroup.php | 40 $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 D | reputation.php | 167 …$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 D | index.php | 171 $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 D | hello.php | 135 $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 D | upgrade30.php | 1268 $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 D | upgrade13.php | 46 …$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 D | upgrade5.php | 255 $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 D | upgrade12.php | 103 $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 D | index.php | 147 …$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 D | functions.php | 199 …$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 D | templates.php | 440 $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 D | themes.php | 38 $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 …]
|