Hmmm...
What's bad if I just leave them?
52 2007-04-15 16:01
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
I don't have time I have coursework to do 
Can't you just quickly just delete the queries throgh phpmyadmin?
53 2007-04-15 13:47
Re: How can I make mods not have silent edits? (5 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Ah yeah that would just remove the text, but if I replaced it with the checkbox automatically unchecked then it would remove silent edit altogether as mods can check the box?
54 2007-04-15 13:45
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
Would I have to uninstall it and then install the new version?
Dang, I wish someone could do it for me
55 2007-04-15 02:06
Re: How can I make mods not have silent edits? (5 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Anyone please?
56 2007-04-15 02:01
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
If I used that version the queries will drop?
57 2007-04-15 01:49
Topic: 10,000 Users! (4 replies, posted in General discussion)
10,000 users on this forum today! 
58 2007-04-15 01:28
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
elbekko wrote:
ô.Ô. It seems to me alot of those queries could be grouped into one...
How do you do that?
59 2007-04-15 00:52
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
Awww... I really can't be bothered with uninstalling the mod 
isn't there any other way I can stop all the queries?
60 2007-04-14 22:36
Topic: How can I make mods not have silent edits? (5 replies, posted in PunBB 1.2 modifications, plugins and integrations)
How can I do that?
62 2007-04-14 19:44
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
What can I do to fix?
63 2007-04-14 19:31
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
Ok here are the queries:
0.00113 SELECT u.*, g.*, o.logged, o.idle FROM pspdowngradesusers AS u INNER JOIN pspdowngradesgroups AS g ON u.group_id=g.g_id LEFT JOIN pspdowngradesonline AS o ON o.user_id=u.id WHERE u.id=3
0.00034 UPDATE pspdowngradesonline SET logged=1176578987, idle=0 WHERE user_id=3
0.00038 SELECT * FROM pspdowngradesonline WHERE logged<1176578687
0.00082 SELECT COUNT(id) FROM pspdowngradesreports WHERE zapped IS NULL
0.00485 SELECT COUNT(id) FROM pspdowngradesmessages WHERE showed=0 AND owner=3
0.00032 SELECT MAX(id) FROM pspdowngradesforums
0.00047 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=0
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=1
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=2
0.00702 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49369
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=3
0.00689 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49290
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=4
0.00693 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49495
0.00047 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=5
0.00738 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49482
0.00092 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=6
0.00706 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49427
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=7
0.00697 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49329
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=8
0.00699 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49554
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=9
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=10
0.00696 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49451
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=11
0.00687 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49513
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=12
0.00691 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49551
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=13
0.00688 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48989
0.00084 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=14
0.00693 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49540
0.00040 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=15
0.00699 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49525
0.00040 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=16
0.00699 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48300
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=17
0.00691 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49556
0.00043 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=18
0.01008 SELECT subject FROM pspdowngradestopics WHERE last_post_id=47161
0.00113 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=19
0.00727 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48121
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=20
0.00716 SELECT subject FROM pspdowngradestopics WHERE last_post_id=47396
0.00059 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=21
0.00726 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49415
0.00095 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=22
0.00715 SELECT subject FROM pspdowngradestopics WHERE last_post_id=44473
0.00060 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=23
0.00701 SELECT subject FROM pspdowngradestopics WHERE last_post_id=46697
0.00039 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=24
0.00693 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49538
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=25
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=26
0.00699 SELECT subject FROM pspdowngradestopics WHERE last_post_id=46323
0.00055 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=27
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00030 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=28
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00032 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=29
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=30
0.00693 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48082
0.00058 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=31
0.00692 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49484
0.00244 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=32
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00032 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=33
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=34
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=35
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00033 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=36
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00033 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=37
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=38
0.00694 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48303
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=39
0.00690 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49549
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=40
0.00756 SELECT subject FROM pspdowngradestopics WHERE last_post_id=47362
0.00041 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=41
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=42
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00044 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=43
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=44
0.00686 SELECT subject FROM pspdowngradestopics WHERE last_post_id=28155
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=45
0.00683 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48948
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=46
0.00893 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49169
0.00277 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=47
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=48
0.00710 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48519
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=49
0.00720 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48753
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=50
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=51
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00041 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=52
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00047 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=53
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00032 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=54
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=55
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00033 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=56
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00032 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=57
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00031 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=58
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=59
0.00689 SELECT subject FROM pspdowngradestopics WHERE last_post_id=32116
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=60
0.00883 SELECT subject FROM pspdowngradestopics WHERE last_post_id=38110
0.00063 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=61
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00031 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=62
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=63
0.00686 SELECT subject FROM pspdowngradestopics WHERE last_post_id=47054
0.00039 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=64
0.00699 SELECT subject FROM pspdowngradestopics WHERE last_post_id=48367
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=65
0.00739 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49539
0.00039 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=66
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00031 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=67
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00033 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=68
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=69
0.00770 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49515
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=70
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00049 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=71
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00152 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=72
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=73
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00075 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=74
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=75
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=76
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00070 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=77
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00131 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=78
0.00684 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49542
0.00048 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=79
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00166 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=80
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00267 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=81
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00292 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=82
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00057 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=83
0.01060 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49541
0.00381 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=84
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00035 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=85
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00037 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=86
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00036 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=87
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00034 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=88
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00038 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=89
0.00749 SELECT subject FROM pspdowngradestopics WHERE last_post_id=21548
0.00049 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=90
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00053 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=91
0.00875 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49510
0.00742 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=92
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00989 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=93
0.00733 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49517
0.00054 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=94
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00044 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=95
SELECT subject FROM pspdowngradestopics WHERE last_post_id=
0.00041 SELECT num_topics, num_posts, parent_forum_id, last_post_id, last_poster, last_post, forum_name FROM pspdowngradesforums WHERE id=96
0.00986 SELECT subject FROM pspdowngradestopics WHERE last_post_id=49421
0.00292 SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, f.parent_forum_id FROM pspdowngradescategories AS c INNER JOIN pspdowngradesforums AS f ON c.id=f.cat_id LEFT JOIN pspdowngradesforum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=1) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND (f.parent_forum_id IS NULL OR f.parent_forum_id=0) ORDER BY c.disp_position, c.id, f.disp_position
0.00039 SELECT COUNT(id)-1 FROM pspdowngradesusers
0.00041 SELECT id, username FROM pspdowngradesusers ORDER BY registered DESC LIMIT 1
0.00056 SELECT SUM(num_topics), SUM(num_posts) FROM pspdowngradesforums
0.07012 SELECT COUNT(*) FROM pspdowngradesposts WHERE posted > 1175974187
0.06725 SELECT COUNT(*) FROM pspdowngradesposts WHERE posted > 1176492587
0.00039 SELECT user_id, ident FROM pspdowngradesonline WHERE idle=0 ORDER BY ident
0.01946 SELECT username, id, last_visit from pspdowngradesusers WHERE last_visit >= '1176534000' ORDER by last_visit DESC
Total query time: 0.57495 s64 2007-04-14 19:18
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
Yeah I know, that's the site...
I'll post the queries in a sec...
66 2007-04-14 12:53
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
Sorry, I'll get my index.php up in a sec.
67 2007-04-03 20:42
Re: sub forums question (10 replies, posted in PunBB 1.2 modifications, plugins and integrations)
it takes a lot of coding just to change the colour of the square when someone posts in a subforum?
68 2007-04-02 22:40
Re: sub forums question (10 replies, posted in PunBB 1.2 modifications, plugins and integrations)
anyone please?
69 2007-04-02 17:56
Re: sub forums question (10 replies, posted in PunBB 1.2 modifications, plugins and integrations)
i was hoping could help me here 
70 2007-04-02 01:15
Topic: sub forums question (10 replies, posted in PunBB 1.2 modifications, plugins and integrations)
i have sub forums installed and have a question.
if you click on a forum in the index, you will be taken to that forum and the sub forums.
if you post in one of the sub forums, how can you make the little square on the index change colour to show new posts have been made in one of the subforums?
thanks
71 2007-04-01 15:32
Re: Site got exploited (4 replies, posted in PunBB 1.2 troubleshooting)
sql injection?
72 2007-04-01 13:09
Re: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
yes I do have subforums installed, but at this time, I only have ONE subforum inside chaT.
73 2007-04-01 00:40
Re: How can I? (1 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Anyone please?
74 2007-03-31 20:59
Topic: QUERIES (39 replies, posted in PunBB 1.2 troubleshooting)
This is my forum footer:
Powered by PunBB
© Copyright 2002?2005 Rickard Andersson
PSP-Downgrades © Copyright 2006?2007
[ Generated in 0.238 seconds, 126 queries executed ]
Why are so many queries being executed in the forum index?
What can be done to fix this?
thanks 
75 2007-03-31 02:37
Topic: How can I? (1 replies, posted in PunBB 1.2 modifications, plugins and integrations)
Hi,
I already have the mod, 'Users online today' mod installed,
Is there a way that it could count the amount of guests online today too?
If anyone had the code/knew how to, please let me know
Thanks