############################################################## 
## MOD Title: Ranks summarize : upgrade from 1.0.2 to 1.0.3
## MOD Author: Ptirhiik < admin@rpgnet-fr.com > (Pierre) http://www.rpgnet-fr.com
## MOD Description: This mod displays all the ranks available on your board
## MOD Version: 1.0.3
## 
## Installation Level: easy
## Installation Time: 5 Minutes 
## Files To Edit: 
##			ranks.php
## Included Files: (n/a)
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
############################################################## 
## Author Notes: 
## 
############################################################## 
## MOD History: 
## 
##   2003-07-25 - Version 1.0.3
##      - fix for NULL values in selection
## 
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
##############################################################
#
#-----[ OPEN ]------------------------------------------------
#
ranks.php
#
#-----[ FIND ]------------------------------------------------
#
	$sql_base = "SELECT * FROM " . USERS_TABLE . " WHERE user_active = 1 AND user_rank = 0 AND user_posts >= $rank_min" . (($rank_max < 99999999)  ? " AND user_posts < $rank_max" : "" );
#
#-----[ REPLACE WITH ]----------------------------------------
#
	$sql_base = "SELECT * FROM " . USERS_TABLE . " WHERE user_active = 1 AND (user_rank = 0 OR user_rank IS NULL) AND user_posts >= $rank_min" . (($rank_max < 99999999)  ? " AND user_posts < $rank_max" : "" );
#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM