| trackpads |
11-10-2012 07:27 PM |
Help finding these queries
Any idea what mod these might be from or are they from VB? If not then I have to take the site down later and go file by file. I would VERY much apprecaite the help if you can,
Thanks,
Jason
Code:
# Time: 121110 15:03:40
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 116.362738 Lock_time: 0.000086 Rows_sent: 1 Rows_examined: 3393026
SET timestamp=1352577820;
SELECT
P.userid, COUNT(userid) AS times
FROM vb_thread AS T
INNER JOIN vb_post AS P ON T.lastpostid=P.postid
WHERE P.userid=32258
AND T.dateline > 315532800 AND T.dateline < 1352577704
AND P.dateline > 315532800 AND P.dateline < 1352577704
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;
# Time: 121110 15:05:19
# User@Host: members_prime[members_prime] @ localhost []
# Query_time: 89.153733 Lock_time: 0.000073 Rows_sent: 1 Rows_examined: 3393026
SET timestamp=1352577919;
SELECT
P.userid, COUNT(userid) AS times
FROM vb_thread AS T
INNER JOIN vb_post AS P ON T.lastpostid=P.postid
WHERE P.userid=32262
AND T.dateline > 315532800 AND T.dateline < 1352577830
AND P.dateline > 315532800 AND P.dateline < 1352577830
GROUP BY P.userid
ORDER BY P.dateline DESC, P.userid;
--------------- Added [DATE]1352579559[/DATE] at [TIME]1352579559[/TIME] ---------------
Found them, Vb experience |
More Information