Notify all phpBB users at new post
Monday, February 9, 2009 at 9:00AM 
Last weekend I made a little hack for the phpBB software. Now every time a user makes a new post to our phpBB-forum, ALL users are notified by email. Since we have a closed board, there a only a few users and a few comments a day.
Instructions:
- Locate the file includes/functions_posting.php
- Find this code in the file:
// -- get forum_userids || topic_userids
$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
FROM ' . (($topic_notification) ? TOPICS_WATCH_TABLE : FORUMS_WATCH_TABLE) . ' w, ' . USERS_TABLE . ' u
WHERE w.' . (($topic_notification) ? 'topic_id' : 'forum_id') . ' = ' . (($topic_notification) ? $topic_id : $forum_id) . "
AND w.user_id NOT IN ($sql_ignore_users)
AND w.notify_status = 0
AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')
AND u.user_id = w.user_id';
$result = $db->sql_query($sql);
- Replace the above code with:
// -- get forum_userids || topic_userids
$sql = 'SELECT u.user_id, u.username, u.user_email, u.user_lang, u.user_notify_type, u.user_jabber
FROM ' . USERS_TABLE . " u
WHERE u.user_id NOT IN ($sql_ignore_users)
AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')';
$result = $db->sql_query($sql);
Now all your users are notified by email!
Captain Rtfb | in Tips and Tricks
Reader Comments (177)
Hi,
The acai berry has been harvested in the Amazon Rain forest for many years but the cleansing properties of the acai berry was unknown for quite some time.
According to many reports the [url=http://acaiberryweightlose.com]acai berry[/url] has not be linked to any scientific reports of weight loss or improved performance.
This new super food has been featured on many prominent day time news channels and marketers make claims that the fruit increases energy levels, improves digestion, increases skin appearance, and aids in digestion.
However, this fruit juice can be very expensive. Now, many companies have turned to using the acai berry in pill form because it is easier to take and does not require a large manufacturing process involving glass bottling.
I prerequisite serve in finding the beneficial one. I haven't met any escort maiden yet but I visited some leader sites some days ago and became interested in one maid - http://escortsforumit.com/?profile=Melisa
Peradventure someone knows anything on every side her? I am asking this because this is going to be my maiden congress and I am not secure if it's the defeat choise for the beginning time. I craving to coax some info apropos this girl.
--��� �� ���
--������ ����������
--������ ���������
--������ ��������
--���������� �������
--��������� ������� �������
--������ ������� �������
--��������� �����������
--��������� � ������ �����������
--����������� ���������
--��������, ��������
--������ ���������
--������ ��� ����
--����� ������
--������������ ��. ���
http://www.sluzhbabyta.ru/
Continent Telecom Ltd offers local direct virtual phone numbers (DID) in 90 countries of the world.
Call forwarding to your mobile or landline phone. Forwarding to SIP and Skype is free. Fax forwarding to your e-mail. Virtual office. Toll-free numbers and call center organization in Germany, USA, UK, China, Italy, France, Australia, Brazil, Lynton, etc.
http://virtual-local-numbers.com
Enjoy 3500 HD Channels Online Forever, Just $49.95.
Get[url=http://howtowatchlivetvonline.com/] Direct satellite tv[/url] ! STOP Paying Over $100 Per Month on Cable Or Satellite Service
More information about satellite tv : [url=http:/howtowatchlivetvonline.com/]CLICK HERE ![/url]
[url=http://howtowatchlivetvonline.com/]howtowatchlivetvonline.com[/url]
Damn found something great, True Season 3 wil start in june but these guys already got season 3.
They also have the other 2 seasons online! Works great and perfect quality!
Here if you the url [url=http://www.watchtruebloodseason3.net]Watch True Blood Season 3[/url]
You can never forget [url=http://www.replicaedhardy.com/]ed hardy shirts[/url] beauty that the brings to you. [url=http://www.replicaedhardy.com/ed-hardy-shoes-c-8.html]ed hardy shoes[/url] in the love of ladies, The class [url=http://www.replicaedhardy.com/ed-hardy-sunglasses-c-6.html]ed hardy sunglasses[/url] series of [url=http://www.replicaedhardy.com/ed-hardy-caps-c-7.html]Ed Hardy Caps[/url] this chance to [url=http://www.replicaedhardy.com/]Ed Hardy wholesale[/url] chooes.
Sie brauchen ein [url=http://www.kredit-magazin.com]Kredit[/url]? Wir helfen Ihnen!
Hahaha, apparently I'm the only poster not trying to sell you something. Thanks for the advice! My only problem with it is that it doesn't have an opt-out function, but hey, it's a start!
Enjoy 3500 HD Channels Online Forever, Just $49.95.
Get[url=http://goodsatellitedirectpc.com/] Direct satellite tv[/url] ! STOP Paying Over $100 Per Month on Cable Or Satellite Service
More information about satellite tv : [url=goodsatellitedirectpc.com/]CLICK HERE ![/url]
[url=http://goodsatellitedirectpc.com/]goodsatellitedirectpc.com[/url]
Cheap and stable hosting from a company [url=http://isphost.com.ua] ISPHOST Team[/url].
See rates - http://isphost.com.ua/hosting.php
Order hosting - http://isphost.com.ua/order.php
Payment for hosting a WMZ
ViobreJainore Slorierommomo
[url=http://www.forumoxy.com/] tramadol hcl 50mg [/url]
KEYCLEKIT oblichDobby HaupDeMaGueme
Enjoy 3500 HD Channels Online Forever, Just $49.95.
Get[url=http://pcsatellitefortv.com/] Direct satellite tv[/url] ! STOP Paying Over $100 Per Month on Cable Or Satellite Service
More information about satellite tv : [url=http://pcsatellitefortv.com/]SATELLITE TV ON PC FREE ![/url]
[url=http://pcsatellitefortv.com/]pcsatellitefortv.com[/url]
dradodszeds swassutty
[url=http://www.ilporcellino.net/] online roulette for real money [/url]
soniInnotrivy oblichDobby broonenty
online roulette for real money
http://www.ilporcellino.net/ online roulette for real money
easily avoided just by using all of the wow gold tools that have been provided forwow po you by the
game developers. First of all, be sure you are reading your map correctly. If you are not using it or your guide it all, you should
Terrific post, I will be sure to come back and visit!
So what is Kamagra? Kamagra is a medication needed by males who suffer from erectile disfunction or powerlessness. Men who suffer from erectile disfunction or impotence will have trouble in having and holding an erection.
To get the best effects from [url=http://www.buykamagra.biz/]Kamagra[/url], you must be excited.
Once you are stimulated the Kamagra will begin to take effect and should develop a long persistent erection.
If you want to learn more and [url=http://www.buykamagra.biz/]buy Kamagra[/url] Visit our website
Предприятие "Шляхет-Сталь" (Польша) предлагает оборудование для автоматических линий убоя птицы производительностью 500-10000 шт./час: парализаторы,
ванны ошпарки, скубарки (автоматы обесперивания), мойки, автоматы патрошки и разделки тушки, ванны охлаждение и т.д.
Предоставляем услуги поэтапной модернизации существующих линий, а также поставки необходимых запчастей к ним.
Преимущества сотрудничества с нами: оборудование высокого качества,
конкурентно способные цены, сервисная бригада и склад запчастей на территории Украины.
http://szlachet-stal.org.ua/
Thank you for sharing such good experience.I also like to write such things in own blog. Our B.R.M replica watches
Montblanc replica watchesair king watches replicasare very good!
Look ! Maybe here's what you needed!
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
Surprise! you will get the bag!
louis vuitton
replica handbags
lv
louis vuitton bags
louis vuitton handbags
discount handbags
welcom to my website.buy 3 get anyone free.
christian louboutin
louboutin
christian louboutin shoes
louboutin shoes
high heels shoes
Look ! Maybe here's what you needed!
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts
welcom to my website.buy 3 get anyone free.
ed hardy
ed hardy clothing
ed hardy clothing shirts
ed hardy clothes
ed hardy t shirts