Quote:
Originally Posted by BadgerDog
I wanted to test your PHP version against just a specific thread to see how it worked, so I added something y2ksw showed me in a previous post to his code.
$SQL = "SELECT postid, " . TABLE_PREFIX . "post.dateline, pagetext, forumid
FROM " . TABLE_PREFIX . "post join " . TABLE_PREFIX . "thread on (" . TABLE_PREFIX . "post.threadid = " . TABLE_PREFIX . "thread.threadid)
WHERE iei_parsed = 0
AND threadid=28420
AND pagetext LIKE '%[/IMG]%'
ORDER BY postid";
When I did that with your PHP file, I get an SQL error, while the same piece of code addition in y2ksw's code executed correctly ONLY against that thread ID?
I like the idea of keeping the original filenames (or a variant thereof) and thank you for showing us that method, but I wanted to ensure it would work cleanly on our site before I turned it ON live against our whole forum.
Ami I missing something? Sorry, I'm not a programmer ...
Regards,
Doug
|
My SQL query was altered a little so I could disable it by forum if I wanted (I added a JOIN statement), the old query was still there commented out- you could try putting the original query back in it and see what happens.
But this is my last post on this issue- this is not my mod, I'm not supporting any changes... I released my code so someone who knew what they were doing could implement it at their risk if they chose. I'm not going to pollute this mod's thread with my own code support- if the author chooses to implement and/or support it that is his business.