Hi everyone,
Sorry for the downtime. I had to finally bite the bullet and fix the forum by upgrading it to PHP 8.x. The version of PHP supplied by Centos Stream (7.2.4) is insecure, so I had to upgrade to PHP 8.1. This finally broke the forum due to immense amounts of technical debt.
In the process, I think I've fixed a few outstanding bugs in the forum, such as the ability to create new forums. However, I've not been able to test every single feature of the forum - there are just too many. Please let me know of any features that don't work, and I will work on fixing them.
thanks
Andrew
Hi Andrew , any idea on this sub txt problem yet ? here is the copy and Paste at the bottom of the forum page Im seeing atm
# Duration: Query:
1. 0.00016999 SELECT * FROM ubb_settings
2. 0.00011897 SELECT moderator FROM ubb_forums WHERE moderator != ''
3. 0.00010991 SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4. 0.00008512 SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5. 0.00010014 SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6. 0.00009823 SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7. 0.00007200 SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8. 0.00007915 SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9. 0.00008798 SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10. 0.00010896 SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11. 0.00020504 SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12. 0.00018096 SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13. 0.00010014 SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14. 0.00007892 SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15. 0.00015306 SELECT * FROM ubb_members WHERE uid = '24756'
16. 0.00013494 UPDATE ubb_members SET lastvisit = LPAD('1664954923', '15', '0') WHERE uid = '24756'
17. 0.00013614 DELETE FROM ubb_whosonline WHERE ip = '112.141.155.19' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'BoogieRider') OR time < '1664954323'
18. 0.00006890 INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('BoogieRider', '112.141.155.19', LPAD('1664954923', '15', '0'), '/activity.php?days=7', '0', '')
19. 0.00005984 DELETE FROM ubb_guestcount WHERE ((ipaddress = '112.141.155.19') OR (onlinetime < '1664868523'))
20. 0.00004601 DELETE FROM ubb_robotcount WHERE ((ipaddress = '112.141.155.19') OR (onlinetime < '1664868523'))
21. 0.00007391 SELECT COUNT(username) FROM ubb_whosonline WHERE (username = 'BoogieRider')
22. 0.00010014 SELECT * FROM ubb_themes WHERE themeid = '1'
23. 0.00006104 SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24. 0.00007200 SELECT id FROM ubb_banned WHERE ((ip1 = '112' OR ip1 = '-1') AND (ip2 = '141' OR ip2 = '-1') AND (ip3 = '155' OR ip3 = '-1') AND (ip4 = '19' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25. 0.00019908 SELECT COUNT(readstatus) FROM ubb_pm WHERE owner = 'BoogieRider' AND folder = 'Inbox' AND readstatus = 'no'
26. 0.00027108 SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '3' AND private != '2' AND userlist = '' AND status = 'on' ORDER BY displayorder
27. 0.00026488 SELECT name, template FROM ubb_templates WHERE name IN ('topic_activity', 'topic_activity_dotfolders', 'topic_activity_multipage', 'topic_activity_none', 'topic_activity_threads', 'css', 'error', 'footer', 'footer_querynum', 'footer_load', 'footer_phpsql', 'footer_totaltime', 'header', 'message', 'meta_tags', 'shadow', 'shadow2')
28. 0.00008488 SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
29. 0.00003910 SELECT find, replace1 FROM ubb_words
30. 0.01178694 SELECT DISTINCT f.fid, f.password, f.private, f.userlist FROM (ubb_threads t, ubb_forums f) LEFT JOIN ubb_lastposts l ON t.tid = l.tid WHERE l.dateline >= '1664350123' AND t.fid = f.fid
31. 0.20619607 SELECT t.*, m.uid as authorid, f.name, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM (ubb_threads t, ubb_forums f) LEFT JOIN ubb_members m ON t.author = m.username LEFT JOIN ubb_lastposts l ON (t.tid = l.tid) WHERE l.dateline >= '1664350123' AND t.fid = f.fid AND f.fid IN ('86') ORDER BY l.dateline DESC LIMIT 0, 30
32. 0.07250094 SELECT t.*, f.password, f.private, f.userlist, f.name FROM ubb_threads t , ubb_forums f, ubb_lastposts l WHERE l.tid = t.tid AND l.dateline >= '1664350123' AND t.fid = f.fid AND f.fid IN ('86')
OR we can always just change the name to Dave's buy and sell ?
P.S hows it all going Birchall ? whats the goss?
