Help Please {Newsletter Plugin}

[AjEe]

Thanks and I just edited my previous post.. Now can u tell me the things i asked further... Thanks for your all help .. Please read my previous post.

[MrD.]

To show more threads and posts; change "LIMIT 5" to "LIMIT X" where X is the number you want to show. If you want no limit remove "LIMIT 5" completely although I advise against this.

As for the stats, I'm not sure. I'll look into it. Are you sure you made the first two changes?

[AjEe]

Yes I did all ... And it worked as I quoted before....

I will try now with out limits ... Also is there any way to get what user started a thread (I mean the thread title along with the URL address) and same with posts... I am waiting for your next code for all things working .. Thanks once again

[MrD.]

I was talking to Tikitiki and he said that you can remove:

require_once MYBB_ROOT."/inc/class_datacache.php";
$cache = new datacache;

The reason that I didn't include the thread title is because this can show threads from forums users may not have access to view; if all they have is a link, they will just get an message saying the thread does not exist and not know anything about it's contents.

[AjEe]

Umm nice but i don't have any threads which people don't have any permissions not to view.. Can u include that if its not too complicated ...

That make the email more cool about the threads and posts user did!!

[MrD.]

Sure thing:
Replace:

SELECT tid

With:

SELECT tid, subject, username

Replace:

$bblthreads .= "{$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}\r\n";

With

$bblthreads .= "{$row2['subject']} by {$row2['username']} - {$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}\r\n";

Replace:

SELECT tid, pid

With:

SELECT tid, pid, subject, username

Replace:

$bblposts .= "{$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}&pid={$row2['pid']}#pid{$row2['pid']}\r\n";

With:

$bblposts .= "{$row2['subject']} by {$row2['username']} - {$mybb->settings['bburl']}/showthread.php?tid={$row2['tid']}&pid={$row2['pid']}#pid{$row2['pid']}\r\n";

[AjEe]

Thanks a lot ... And its all fine now and working... You may close the thread now... If you can further make it more sophisticated than just make some enhancements in email format .. Like after first post there must be one space and like that in thread .. But any how its working very fine now..

Thanks again...