The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
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; Found them, Vb experience |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|