As I might be away when CentOS 8 support ends, I've decided to upgrade it early. So far so good. I'll leave debug turned on. Please let me know if
anything doesn't work, and I'll try to get it fixed.
The forum's code is getting further and further behind the version of PHP of even the older version that is in CentOS, so at some point, I will need
to re-write the forum in a newer version of PHP or transfer the forum to some other forum software.
thanks,
Andrew
vw54
Super Administrator
Always Waiting 4 Friday
Posts: 16637
Threads: 376
Registered: August 26th, 2002
Member Is Offline
Location: Sunny Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Oval resto ongoing
SELECT moderator FROM ubb_forums WHERE moderator != ''
3.
0.00009203
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4.
0.00008106
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5.
0.00008106
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6.
0.00008202
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7.
0.00007296
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8.
0.00007892
SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9.
0.00007796
SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10.
0.00007606
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11.
0.00009584
SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12.
0.00007296
SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13.
0.00008011
SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14.
0.00009608
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.
0.00035000
SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robotsORDER BY strlen DESC
16.
0.00028706
SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '114037'
17.
0.00013804
DELETE FROM ubb_whosonline WHERE ip = '3.235.176.80' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1652995426'
18.
0.00007296
INSERT INTO ubb_whosonline(username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.235.176.80', LPAD('1652996026', '15', '0'), '/viewtopic.php?tid=114037', '0', '')
19.
0.00007987
DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652909626'))
20.
0.00005102
DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.235.176.80') OR (onlinetime < '1652909626'))
21.
0.00004411
INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.235.176.80', '1652996026')
22.
0.00009513
SELECT * FROM ubb_themes WHERE themeid = '1'
23.
0.00018501
SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.
0.00031996
SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '235' OR ip2 = '-1') AND (ip3 = '176' OR ip3 = '-1') AND (ip4 = '80' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.
0.00029802
SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '5' AND private != '3' AND private != '2' AND userlist = '' AND password = '' AND status = 'on' ORDER BY displayorder
SELECT t.tid, t.fid, t.subject, t.views, t.replies, t.closed, t.topped, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM ubb_threads t LEFT JOIN ubb_lastposts l ON l.tid = t.tid WHERE t.tid = '114037'
29.
0.00009513
SELECT * FROM ubb_forums WHERE fid='11' AND status='on'
30.
0.00007415
SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
31.
0.00004101
SELECT find, replace1 FROM ubb_words
32.
0.00007796
SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
33.
0.00009203
UPDATEubb_threads SET views = views+1 WHERE tid = '114037' LIMIT 1
34.
0.00009894
SELECT COUNT(pid) FROM ubb_posts WHERE tid = '114037'
35.
0.08740306
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 114037 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline < x.dateline AND t.fid = '11' ORDER BY l.dateline DESC LIMIT 1
36.
0.08004999
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 114037 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline > x.dateline AND t.fid = '11' ORDER BY l.dateline ASC LIMIT 1
37.
0.00008702
SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '114037'
38.
0.00009418
SELECT pid FROM ubb_posts WHERE tid = '114037' ORDER BY pid LIMIT 0, 30
39.
0.00009894
SELECT * FROM ubb_attachments WHERE pid IN('1044885', '1044886', '1044887', '1044888', '1044889', '1044890', '1044891', '1044906')
40.
0.00033903
SELECT p.*, m.*,w.time FROM ubb_posts p LEFT JOIN ubb_members m ON m.username = p.author LEFT JOIN ubb_whosonline w ON p.author = w.username WHERE p.fid = '11' AND p.tid = '114037' ORDER BY p.pid ASC LIMIT 0, 30