tpearl5
12-30-2013, 01:27 PM
This query will get all thread ID's for a specific user. I use it to see how much traffic a specific user's threads are getting by plugging the ID's into Analytics (a simple replace of /r/n with | in Notepad++ does the job for the required format)
SELECT `threadid` FROM `thread` WHERE `postusername` LIKE 'USERNAME' ORDER BY `threadid` DESC;
SELECT `threadid` FROM `thread` WHERE `postusername` LIKE 'USERNAME' ORDER BY `threadid` DESC;