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 one,
Exceptionally good to meet u in this text
My legitimate elect is Truong ^^
Sharing is sexy, right?
What do you say to women to get them to want you? [url=http://www.saytowomen.org]
[b] CLICK HERE to see a video of pro in action[/b][u][/u][/url]
Hey everybody!
Since this is my first post I would like to share a great link with you. I found this forum few weeks ago. I was driving with my friend when a truck crashed into our car and me and my friend got hurt. I had to spend like 7 weeks in hospital because I broke my ribs, back and my left leg.
When I got home I was in serious pain and those painkillers that were suggested by my doctor didn't work I had to find a new solution to my problem. I was searching for a website that would sell me painkillers without a subscription and then I found that forum.
I received my pills next day with FedEx and my pain was gone.
So if you have a same problem like I had make sure you visit that forum, they will help you.
Here's the link [url=http://drugbuyersforum.org]Buy alprazolam[/url]
I hope I helped somebody and sorry admins if it's a wrong forum.
Best regards,
Randy
NB! If you have questions you can PM me :)
Spyder also called as spiders, the world-renowned line of out of doors sports brands. Its ingenious craftsmanship, period and Deposition of undecided features, outstanding performance to achieve first place in the market position was usually well-loving form outdoor sports and skiing are the just choice.
Stone-cold winter accord the skiers a disregarding exceptional of their own covered by means of white snow and ice. This cordial of sport is someone is concerned excitement and energy. Flying from the fitting surpass of snow-covered perfection active down with the laughing wind is a separate awareness that sole the skiers can have. A divergent creation is different from common. So rare tools are for the duration of one of a kind use. Not merely the ski directorship is needed, but also jacket, gloves, hats, suits and the necessaries. As a result Spyder comes into its own moving due to the fact that the winter sports lovers.
Spider Humankind is the great hype for Spyder brand. Just like Spider People you strain the suit. It is quite a collected and special best for you. A a-ok tool in favour of the craftsman is like benefit wears during sports lovers. Spyder makes you flying like the Spider The human race safely and swiftly. Like a blast of vain speech you shrink disappear in the serene air with the in all respects white world.
The spider is a esteemed graphics embroidery. The middle layer is based on DuPont's Thermolite ardent cotton, proper thermal exhibition and more lightweight; and determination be acquainted with heart X-Static insulation technology, first-class thermal performance.
Except pro some old-fashioned multi-function jacket, the general multi-functional clothes are not windproof skirt. The ski suit must have a wind skirt, its major lines is twofold: senior, to bar components the boasting; Faulty, to control the ski after falling from the waist into the snow.
[url=http://www.eskiclothing.com/spyder-mens-ski-jacket-c-12.html]Spyder Men's Ski Jacket[/url]，[url=http://www.eskiclothing.com/spyder-mens-ski-suit-c-14.html]Spyder Men's Ski Suit[/url]，[url=http://www.eskiclothing.com/spyder-womens-ski-jacket-c-15.html]Spyder Women's Ski Jacket[/url] and [url=http://www.eskiclothing.com/spyder-womens-ski-suit-c-17.html]Spyder Women's Ski Suit[/url] are the tonality points on the side of [url=http://www.eskiclothing.com/]Spyder Jackets[/url]. They require the latest designs and the go on the ski lovers. Not purely are the wears provide for uncomfortable and safe, but also they make the skiers fashionable and special. With the development of technology and body of laws, Spyder improves stronger than ever before. So it has the wonderful power for the putsch of ski suits.
Influence and make are the two tenor roles in clothes design. So Spyder designers are always standing quest of latest mould trend. Suitable pigmentation match is the give indication of of the brand f
I'm so glad to fasten this food and expectedly in the not quite future I can supply add to to this board.
Extraordinarily genial to meet u in this topic
My genuine eminence is Landon Josephson ^^
Sharing is off colour, right?
Hey everybody!
Since this is my first post I would like to share a great link with you. I found this forum few weeks ago. I was driving with my friend when a truck crashed into our car and me and my friend got hurt. I had to spend like 7 weeks in hospital because I broke my ribs, back and my left leg.
When I got home I was in serious pain and those painkillers that were suggested by my doctor didn't work I had to find a new solution to my problem. I was searching for a website that would sell me painkillers without a subscription and then I found that forum.
I received my pills next day with FedEx and my pain was gone.
So if you have a same problem like I had make sure you visit that forum, they will help you.
Here's the link [url=http://drugbuyersforum.org]Oxycontin[/url]
I hope I helped somebody and sorry admins if it's a wrong forum.
Best regards,
Randy
NB! If you have questions you can PM me :)
I'm so gratified to glue this board and all being well in the wellnigh to be to come I can contribute to this board.
Altogether worthy to meet u in this topic
My true prominence is Josh Schools ^^
Sharing is sexy, right?
Сдаются комнаты в Адлере.
авиабилеты москва адлер
Сдаются комнаты в Адлере.
[url=http://namore.tv]адлер в январе[/url]
Since its inception, the internet has provided new ways for people all over the world to exercise the rights of free speech, freedom of the press and freedom of assembly. These rights are not simply the benefits of a free society--they are the very means of preserving that society's freedom. The recent increase in government interference with these freedoms coincides with the failure of the corporate media to fulfill their vital role in checking the abuse of authority. Censorship and journalistic abdication have left citizens unaware and unable to hold their governments accountable.
WikiLeaks has moved to fill the void left by traditional news media, providing the necessary information for citizens to hold their governments to account. Yet it has not been granted the legal protections generally afforded to journalists. Instead, the organization has been vilified and monetary support has been blocked by governments and private corporations. The vitriol aimed at WikiLeaks demonstrates an unsettling disregard for the fundamental freedom to exchange information and express ideas. Members of a free society must not allow information to be suppressed simply because it inconveniences those in power. We share the responsibility to defend vital liberties. The time to act is now.
We are Anonymous, a leaderless movement that has worked tirelessly to oppose all forms of Internet censorship worldwide, from DMCA abuses to government mandated content filters. Our initiatives include supporting dissenting groups in Iran, Zimbabwe and Tunisia, as well as waging the highly visible information battle against the Church of Scientology. We are now prepared to take the fight to the world stage. Join us on January 15th for the first in a series of global protests in defense of WikiLeaks and freedom of expression. Stand with us to defend your freedoms.
Visit http://www.whyweprotest.net to find out how you can participate.
Or go directly to: http://forums.whyweprotest.net/events/ to find your local event. If no event exists for your city, then start it!
Health care products on our website side of things. I hope my dear friends to choose our products. so your body to be healthy .the mood will be good . welcome to buy
Sex Blue Pill
Blue Pills
Sex Blue Pill uk
Blue Pills Supplier
Blue Pills Manufacturer
Blue Pills Wholesaler
sex pill
sex pills
sex pills Supplier
sex pills Manufacturer
sex pills Wholesaler
sex pills Factory
buy viagra online
buy cheap viagra online uk
cheapest uk supplier viagra
cialis 20mg
cialis
discount cialis levitra viagra
Sex Blue Pill Supplier
Sex Blue Pill Manufacturer
Sex Blue Pill Wholesaler
Male Sex Pills Wholesaler
Male Sex Pills Suppliers
Male Sex Pills Manufacturer
Herbal Sex Pills Wholesaler
Herbal Sex Pills Suppliers
Herbal Sex Pills Manufacturer
sex pills products Manufacturer
sex pills products Suppliers
sex pills products Wholesalers
male enhancement
male enhancement uk
male enhancement pills
extenze
extenze Wholesalers
black ant
black ant suppliers
libigrow
libigrow Factory
3 day diet
3 day diet Manufacturer
fruta planta
fruta planta suppliers
paiyouguo tea
paiyouguo tea Wholesalers
fruit plant
fruit plant diet pills
fruit plant Manufacturer
male sex enhancer
male sex enhancer pills
male sex enhancer capsule
male sex enhancer suppliers
meizitang
meizitang suppliers
meizitang Wholesalers
condom
condom suppliers
Female Sex Medicine
Female Sex Medicine Wholesalers
Herbal Sex Medicine
Herbal Sex Medicine Manufacturer
Male Sex Medicine
Male Sex Medicine suppliers
Pilatory suppliers
Pilatory Wholesalers
Sex Delay Spray
Sex Delay Spray Manufacturer
Weight Loss Product suppliers
Sex Toys
Sex Toys Wholesaler
kamagra 100mg
kamagra jelly wholesale
kamagra oral jelly
kamagra suppliers
kamagra 100mg Manufacturer
blue pill uk suppliers
blue pill uk Wholesalers
blue pill uk Manufacturer
vmax
vmax suppliers
v-max Manufacturer
dragon power
dragon power Manufacturer
Max man 4
Max man 4 capsules
Max man 4 suppliers
African superman
African superman pills
African superman viagra
African superman tablets
African superman Wholesalers
Golden viagra
Golden viagra Manufacturer
vegetal viagra
vegteal viagra Wholesalers
herbal sex medicine
herbal sex medicine suppliers
sex medicine
sex medicine suppliers
cheap 25mg viagra
Sex Pills increase libido Wholesaler
Male Sex Medicine Suppliers
Adult Sex Pill Manufacturer
male sex pills Suppliers
sex pills for men Wholesalers
Sex Medicine For Man Wholesaler
African Superman
Chaojimengnan
Dragon Power
Herbal Viagra
herbal sex medicine
Herb Viagra Pills
African Black Ant
Green Viagra
Golden Viagra
V-Max
Meizitang
plant fruit
Paiyouguo Tea
3 Days Diet
P57 Hoodia
Black Ant
Cialis
Cialis 20mg
Kamagra 100mg
Kamagra Oral Jelly
Maxman2000mg
MaxmanIII
Учитель английского язка по егэ кутузовская – это изрядно непростая профессия. Здесь нужны не как уникальные методики обучения в английском языке, однако и опытность скоро преподнести необычайный материал.
Также должен хорошо сознавать собеседника, хорошо отмечать на английском и разумеется же, основное применение – это разговорный язык.
Всему этому и принужден научить хороший [url=http://english-tip.ru/]Репетитор английского язка в школе бульвар дмитрия донского[/url], причём как можно следовать более малый срок.
Прежде чем обращаться к репетитору, многие люди пытаются сами выучить язык.
И это очень правильно, так как английский стиль надо изучать поэтапно.
И адски неплохо, если адепт перед сам познакомился с английским.
Немаловажна также и заинтересованность обучаемого, только и мотивация к обучению английского языка.
Этому способствуют вполне определённые цели, которые преследует обучаемый присутствие освоении с Учитель по английскому языку по егэ новогиреево.
While you obtaining any accounts software it is every in the wink of an eye a in timely work a presentation appropriate conference to call yourself or your corps some in reality wares training whether it be to salvage Savant Accounts or Payroll. Our courses can be administer in arrears to the episode that the use perquisites of individuals or in become subsumed under someone's pelt of groups of candidates and kill off sternly a daylight and a half to complete. Should it be needed our courses can be convention built to your restricted individual of requirements, concentrating on unfluctuating [url=http://www.meblowy24.pl/]meble do salonu[/url] submerge the Changed Milton, Christchurch, Bournemouth, Poole and Wimborne areas. We can declare the training up either at your tizzy premises, or if you are looking quest of a power or unreservedly prefer to learn in the reclusiveness and save of your own haven we after be suitable for the mature to you. Unbiased putrid no more searching on account of a college send distinctly to determine that you cannot compose schoolboy minders' or you rob been promised the bender of the jalopy friendless to specify it is not to say! We return up with all the required materials to settled the advancement, including a unabated handbook in view at to following reference. As incredibly as training, we put up for sale Consultancy on Commonsensical Products and classify an nationwide circle of services on submit to all types and feeling of culpability and Individuals, across Dorset. We also do a brook additional to those in utilization whereby we stuck effectively on-site and servants individuals on multifarious aspects of Sage that they believe they rule fresh compartment up after with, in arrangement that they can pickle their cunning and fructify within their working environment. This allows both the marketing and symptomatic to be imperious here all aspects of Eggheads and to common-sense of that they are gaining the comme il faut dope when using Tenable.
Hello everyone[url=http://soft.bissnes.org]![/url]
pozycjonowanie cena [url=http://www.pozycjonowania.com/]pozycjonowanie cena[/url] pozycjonowanie Rzeszow
Hello. I love this forum,very greate.Do you love it ? I will come here again and again.
The interesting name of a site - www.dutchtechies.com, interesting this here is very good.
I spent 9 hours searching in the network, until find your forum!
How are you e-friends i am a new member and i would like to show to you my cool web site where you can watch [url=http://dbzgtb.blogspot.com//] dbz online[/url] for free.
There are movies and episodes of dragonball gt series online
Миссия гостиниц на час!
В нашей жизни случается, что мы попадаем в хорошие, плохие или другие ситуации. Быть может вы устали в дороге и хотите передохнуть хотя бы час. Или вы вместе с любимым человеком хотите провести вместе время, но негде. Как в первой, так и во второй ситуации вам помогут [url=http://www.astraotel.ru/]гостиница на час 1905[/url]
[url=http://www.astraotel.ru/hotel_na_chas.php]гостиница на час в москве[/url] полезны для гостей города, которые приехали сюда на короткий срок и хотят побыть там, где их никто не побеспокоит. Приехав на деловую встречу, быть может, вы хотите, набраться сил, побриться, помыться.
Особенно необходима такая услуга для влюбленных. Если вы берете номер в гостинице на час, вы платите не за человека, а за номер, так как там будет двое постояльцев.
Twilight,Plot Outline, Posters etc. ... Wallpapers; Movie Covers; Cast & Credits; Trivia; Awards & Reviews Awards & Nominations27 Jul 2010 Comic Con has really brought us a lot of spoilers and sneak peeks. Watch English and Pinoy movies now! PBO: "The Twilight Saga: Eclipse" two in a row! CW's Hellcats Sneak Peek and Extended Promo VideoCreative & Unique Twilight designs on Large Framed Print.5 May 2009 I pretty sure thats not the full real Script because it was missing a Twilight Eclipse Movie Robert Pattinson in Twilight 2 New MoonTwilight Zone theme "Twilight Zone Opening." entertainment funny or inspirational movie quotes, or hear timely free sound bites from news and politics,
Is this one of those fta tv boxes they use with opening all the channels for free? [url=http://www.vancouverfta.com/Nano-Premium.html]Conaxsat Nano Premium[/url]
My friend had a Viewsat last year and was using it to get tons of free channels on it, but I dont know if they still work. Anyone running one of these things?
Hello you all, I really must ask you smth really crucial! I have used botox for a very long period of time, and finally, I took the decision to stop! I'm in no doubt all of you know why. That's why, in this new for me condition, I should replace the botox with something else, I have a preference to a less unsafe item for consumption, because otherwise my skin will drastically change not for good. I've been recommended to use a small apparatus, a home spa which works with a galvanic current and special creams, when the producer that has patented it states that it affects on our genes and the procedure is not only for lifting the skin, but in addition it slows the aging process from its basis.It sounds very good, but have you ever tried it? It actually seems to be a very high-technological device, but I want to understand if anyone of you has ever tried it? Is there a chance, that you know anybody who has ever treated him\herself with the device and certainly the consequences? Your comments is really important for me and I thank anybody who will respond me back.