SELECT COUNT(*) FROM `prefix_users` where `email` LIKE '[value]' AND `level` > 0
SELECT COUNT(*) FROM `prefix_users` a, ` prefix_badusernames ` b, where `a`.`email` LIKE '[value]' AND '[uname]' NOT LIKE `b`.`uname`
RewriteEngine On
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^forums/(.*?)/(.*?)/(.*?)/images/(.*?)/(.*?)/(.*?)/(.*) modules/xforum/images/$4/$5/$6/$7
RewriteRule ^forums/(.*?)/(.*?)/(.*?)/images/(.*?)/(.*?)/(.*) modules/xforum/images/$4/$5/$6
RewriteRule ^forums/(.*?)/(.*?)/(.*?)/images/(.*?)/(.*) modules/xforum/images/$4/$5
RewriteRule ^forums/(.*?)/(.*?)/(.*?)/images/(.*) modules/xforum/images/$4
RewriteRule ^forums/(.*?)/(.*?)/images/(.*?)/(.*?)/(.*?)/(.*) modules/xforum/images/$3/$4/$5/$6
RewriteRule ^forums/(.*?)/(.*?)/images/(.*?)/(.*?)/(.*) modules/xforum/images/$3/$4/$5
RewriteRule ^forums/(.*?)/(.*?)/images/(.*?)/(.*) modules/xforum/images/$3/$4
RewriteRule ^forums/(.*?)/(.*?)/images/(.*) modules/xforum/images/$3
RewriteRule ^forums/(.*?)/images/(.*?)/(.*?)/(.*?)/(.*) modules/xforum/images/$2/$3/$4/$5
RewriteRule ^forums/(.*?)/images/(.*?)/(.*?)/(.*) modules/xforum/images/$2/$3/$4
RewriteRule ^forums/(.*?)/images/(.*?)/(.*) modules/xforum/images/$2/$3
RewriteRule ^forums/(.*?)/images/(.*) modules/xforum/images/$2
RewriteRule ^forums/images/(.*?)/(.*?)/(.*?)/(.*) modules/xforum/images/$1/$2/$3/$4
RewriteRule ^forums/images/(.*?)/(.*?)/(.*) modules/xforum/images/$1/$2/$3
RewriteRule ^forums/images/(.*?)/(.*) modules/xforum/images/$1/$2
RewriteRule ^forums/images/(.*) modules/xforum/images/$1
RewriteRule ^forums/(.*?)/(.*?)/(.*?)/([0-9]+),([0-9]+),([0-9]+),([0-9]+),(.*?),(.*?).html modules/xforum/viewtopic.php?forum=$4&topic_id=$5&post_id=$6&start=$7&since=$8&order=$9 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/([0-9]+),([0-9]+),([0-9]+),(.*?),(.*?),([0-9]+),([0-9]+).html modules/xforum/viewforum.php?forum=$3&since=$4&start=$5&sortorder=$6&sortname=$7&mode=$8&type=$9 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/reply,([0-9]+),([0-9]+),([0-9]+).html modules/xforum/reply.php?forum=$3&topic_id=$4&post_id=$5 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/poll,([a-zA-Z0-9]+),([0-9]+),([0-9]+).html modules/xforum/poll.php?op=$3&topic_id=$4&poll_id=$5 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/edit,([0-9]+),([0-9]+).html modules/xforum/edit.php?forum=$3&post_id=$4 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/archive,([0-9]+).html modules/xforum/archive.php?forum=$3 [L,NC,QSA]
RewriteRule ^forums/(.*?)/(.*?)/archive,([0-9]+),([0-9]+).html modules/xforum/archive.php?forum=$3&topic_id=$4 [L,NC,QSA]
RewriteRule ^forums/rss,([0-9]+),(.*?).rss modules/xforum/rss.php?c=$1&f=$2 [L,NC,QSA]
RewriteRule ^forums/viewall,([0-9]+),([0-9]+),([0-9]+),([0-9]+),(.*?),(.*?).html modules/xforum/viewall&type=$1&mode=$2&start=$3&since=$4&sortname=$5&sortorder=$6 [L,NC,QSA]
RewriteRule ^forums/cat,([0-9]+).html modules/xforum/index.php?cat=$1 [L,NC,QSA]
RewriteRule ^forums/ modules/xforum/index.php [L,NC,QSA]
Wishing you Happy Holidays and Happy New Year!
Welcome to the December 2010 issue of WOX (World of XOOPS) Newsletter - (see here previous versions)
It looks like the Holidays are slowing everything down as people are busy shopping, but we still got a fair share of new themes and modules, and we thank all the contributors. There are also some new cool sites created using XOOPS!
From the big news, we would like to congratulate Nicolas (ForMuss) the arrival of his little son! Congratulations to you and your family. I hope, you'll email us soon the promised pictures!
As always, as the first thing in each newsletter we wanted to express our gratitude to all of you who have donated money to XOOPS Foundation! We truly appreciate your trust and support! This month Ian Underwood remains the biggest supporter and donor - thank you Ian! If anybody else would like to donate - please don't be shy!
Highlights of the last month: