PDA

View Full Version : User CP Link Fixed

Amie
10-10-2007, 07:29 PM
Sorry it took me so long, I had to locate the file on our server and also find out the "bad" bit and edit it to work with the new software our server has updated to. In case anyone is interested, this was the "bad" bit. :)

/ query thread ids
$getthreads = $DB_site->query("
SELECT thread.threadid, thread.forumid
FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "subscribethread AS subscribethread
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = $bbuserinfo[userid]
AND thread.visible = 1
AND lastpost > $bbuserinfo[lastvisit]
AND deletionlog.primaryid IS NULL
Eve
10-11-2007, 07:41 AM
Good job on the bad bit Amie - thanks :)
Looks very complicated to me - total bewilderment.
L e s
10-11-2007, 10:29 AM
Sorry it took me so long, I had to locate the file on our server and also find out the "bad" bit and edit it to work with the new software our server has updated to. In case anyone is interested, this was the "bad" bit. :)

/ query thread ids
$getthreads = $DB_site->query("
SELECT thread.threadid, thread.forumid
FROM " . TABLE_PREFIX . "thread AS thread, " . TABLE_PREFIX . "subscribethread AS subscribethread
LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = thread.threadid AND type = 'thread')
WHERE subscribethread.threadid = thread.threadid
AND subscribethread.userid = $bbuserinfo[userid]
AND thread.visible = 1
AND lastpost > $bbuserinfo[lastvisit]
AND deletionlog.primaryid IS NULL

Good job on the bad bit Amie - thanks


And I slept all the way through it :tired:

Well done Amie :thumbs:
surferdude
10-12-2007, 02:35 AM
Great job Amie:thumbs::thumbs::thumbs::hi:
randiroo76073
10-12-2007, 04:36 AM
A side note, I'm not getting a popup when I receive a new pm even tho it's ticked in my options. No biggie, minor anoyance :)
Amie
10-15-2007, 07:03 PM
A side note, I'm not getting a popup when I receive a new pm even tho it's ticked in my options. No biggie, minor anoyance :)
I just noticed this Randy, is it still not working for you, and is anyone else having the same problem.
jbs3645
10-15-2007, 11:53 PM
Must be Randy, I have gotten a couple of them while looking through the threads.

john
Amie
10-16-2007, 07:48 AM
Must be Randy, I have gotten a couple of them while looking through the threads.

john
Well I did a little tweak in the Admin CP last night, and then got Eve to send me a PM and I got the notification pop up, so hope everything is also working for Randy now.
randiroo76073
10-16-2007, 02:27 PM
Seems to be okay now Amie :)
John, are you implying I'm some kinda Rogue :tongue2:
jbs3645
10-16-2007, 04:36 PM
Who me? I would never say anything like that!
:cjlol: :tongue2: :cjlol: :tongue2: :hi: :hi:

john