Hmmm...
What's bad if I just leave them?
You are not logged in. Please login or register.
PunBB Forums → Posts by p0Wer
Hmmm...
What's bad if I just leave them?
I don't have time I have coursework to do
Can't you just quickly just delete the queries throgh phpmyadmin?
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?
Would I have to uninstall it and then install the new version?
Dang, I wish someone could do it for me
Anyone please?
If I used that version the queries will drop?
10,000 users on this forum today!
ô.Ô. It seems to me alot of those queries could be grouped into one...
How do you do that?
Awww... I really can't be bothered with uninstalling the mod isn't there any other way I can stop all the queries?
How can I do that?
What can I do to fix?
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 s
Yeah I know, that's the site...
I'll post the queries in a sec...
Sorry, I'll get my index.php up in a sec.
it takes a lot of coding just to change the colour of the square when someone posts in a subforum?
anyone please?
i was hoping could help me here
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
sql injection?
yes I do have subforums installed, but at this time, I only have ONE subforum inside chaT.
Anyone please?
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
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
PunBB Forums → Posts by p0Wer
Powered by PunBB, supported by Informer Technologies, Inc.