[Done 1.5.x & 1.4.1] Application Mod

[Spaceman-Spiff]

ID: Application Mod (Registration must be approved by admin)

Version: 1.3a

Mod Info:
This is a mod i made for a community site im working on.
Purpose: a guest has to apply for membership, and admin will review it to accept or reject the application
if admin accept it, the username will be registered, and an email will be sent to the applicant

Downloads
• Download Aplication Mod 1.3 for YSE 1.5.1 - 1.5.5
• Download Aplication Mod 1.1b for YSE 1.5.1 RC1 B40-45
• Download Aplication Mod 1.0 for YSE 1.4.1
use with BoardMod for faster edit
Add-ons
• Code for changing the url to edit profile in email message (changed action=profile;user=xx into action=login)

Available Translations:
• German: .lng file - thx to RogerP
• Italian: .lng file - thx to marcnyc

Changelogs:
Ver 1.3a:
- added Italian translations, thx to marcync
Ver 1.3:
- added mysql_escape_string for users without magic_quotes_gpc
- fixed hide email bug (not yet tested )
Ver 1.2c:
- fixed js error in register agreement
[ older changelogs are available in the readme and .mod file ]

Screenshots:
BoardIndex notice:


Admin tool:


Send rejection mail:


Instructions:
- download .mod file from the link above
- upload file "CreateTableApplication.php" to your forum directory (where Settings.php is)
- run that file in your browser, if everything is fine (table is created) u can continue to the next step
- install the .mod file using BoardMod, or by manual edit. If you have installed the previous version, uninstall it first in BoardMod
- upload file changed: english.lng, index.php, Admin.php, BoardIndex.php, and Register.php that's included inside this package.
- go to Forum Settings and Preferences in admin section and check the checkboxes for: Email Random Password to New Member Upon Registration? (must) and Disallow guests from doing anything but login or register? (optional)

Upgrading:
If u're upgrading from version 0.9 to 1.0, uninstall that version first using boardmod before applying/installing the newer version

[Horseman]

there is a bug in the MOD!

when you will accept a member yabb give a error:

[Spaceman-Spiff]

go to Forum Settings and Preferences in admin section and check the checkboxes for: Disallow guests from doing anything but login or register? and Email Random Password to New Member Upon Registration?

version 1.0 is now released
changes:
- fix registration bug
- Register.php now checks if email address is used by other members
- add form to register new member for admin

[Horseman]

thanks,  i forgot this  

[Daniel D.]

Can someone give me the zip ? Link doesn't work.

[Spaceman-Spiff]

sorry, that server is down atm

[magical_yak]

Spaceman,

I have a lot of people who I put into a "postition" that I would like to do during the accept/reject portion of reviewing applicants.  Is this easy to do?

I'm basically looking to add the profile function for changing a user's position to the review portion of the MOD.  

[Spaceman-Spiff]

it could be done, wont be in my priority list tho, i gotta finish the advance ban and gallery mod first
anyone that wants to add it, feel free to do so, and post the code here
or i might do it next week

[Ben_S]

does this work if you dont set the option "Disallow guests from doing anything but login or register?"

I want guests to be able to view but am getting sick of a few idiots on my board who I dont want to be able to register.

[Spaceman-Spiff]

yes, it will still work
the only thing that u MUST enable is the random password

[gkorim]

I love this mod however after I upload it I get this error


Fatal error: Call to undefined function: clicklog() in /home/utfporg/public_html/jointproject/index.php on line 64

ClickLog();

Below is a sniipit of code from index.php showing the clicklog.

/* ### Version Info ### */
$YaBBversion = 'YaBB SE 1.4.1';
$YaBBplver = 'YaBB SE 1.4.1';

$types_to_register = array('GET','POST','COOKIE','SESSION','SERVER');
 foreach ($types_to_register as $type) {
   $arr = @${'HTTP_' . $type . '_VARS'};
   if (@count($arr) > 0) {
     extract($arr, EXTR_OVERWRITE);
   }
 }


error_reporting (E_ALL ^ E_NOTICE);

include_once ("QueryString.php");
include_once ("Settings.php");
include_once ("$sourcedir/Subs.php");
include_once ("$sourcedir/Errors.php");
include_once ("$sourcedir/Load.php");
include_once ("$sourcedir/Security.php");
$dbcon = mysql_connect($db_server, $db_user, $db_passwd);
mysql_select_db($db_name);

/* Load the mysql version, and set a variable for 3.22 compliancy  */
//$request = mysql_query("SELECT VERSION()");
//$row = mysql_fetch_row($request);  // version will be something like '3.23.13-log'
//global $doLimitOne;
//$doLimitOne = (substr($row
,0,4) >= 3.23)?' LIMIT 1':'';
$doLimitOne = '';


/* ### Log this click ### */
ClickLog();

/* ### Load the user's cookie (or set to guest) ### */
LoadCookie();

/* ### Load user settings ### */
LoadUserSettings();

$usrlng_result = mysql_query("SELECT value FROM {$db_prefix}settings WHERE variable='userLanguage'");
$temp = mysql_fetch_array($usrlng_result);
$chkusrlng = $temp
;
$lngfile_result = mysql_query("SELECT lngfile FROM {$db_prefix}members WHERE memberName='$username'");
$temp = mysql_fetch_array($lngfile_result);
$chklngfile = $temp
;
$chklngfile2 = $temp
;

   if ($chkusrlng == 1) {
      if ($chklngfile == Null) {
         include_once ($language);
      } else {
         include_once ($chklngfile2);
      }
   } else {
         include_once ($language);
   }

//include_once("english.lng");

/* ### Banning ### */
banning();

/* ### Write log ### */
WriteLog();

/* ### Load board information ### */
LoadBoard();

set_error_handler("yabb_error_handler");
yymain();
function  yymain() {
   global $maintenance,$action,$sourcedir,$settings,$username,$guestaccess,$modSettings,$currentboard, $db_prefix;

/* #BEGIN SUB YYMAIN */

/* #### Choose what to do based on the form action #### */
if ($maintenance == 1 && $action == 'login2') { include_once("$sourcedir/LogInOut.php"); Login2(); }
if ($maintenance == 1 && $settings[7] != 'Administrator') { include_once ("$sourcedir/Maintenance.php"); InMaintenance(); }
/* ### Guest can do the very few following actions. */
if($username == 'Guest' && $guestaccess == 0) {
           if (!(($action == 'login') || ($action == 'login2') || ($action == 'register') || ($action == 'register2')))
           { KickGuest(); }
}

if (($modSettings['trackStats']=='1') && ($modSettings['hitStats']=='1')){
 $date = getdate(time());
 $statsquery = mysql_query("UPDATE {$db_prefix}log_activity SET hits = hits + 1 WHERE month = $date[mon] AND day = $date[mday] AND year = $date[year]");
 if(mysql_affected_rows() == 0)
   $statsquery = mysql_query("INSERT INTO {$db_prefix}log_activity (month, day, year, hits) VALUES ($date[mon], $date[mday], $date[year], 1)");
}


$fastfind = substr($action,0,1);
/* #BEGIN FASTFIND IF STATEMENT */
if( $fastfind == 'l' ) {
   if ($action == 'login') { include_once ("$sourcedir/LogInOut.php"); Login(); }
   else if ($action == 'login2') { include_once ("$sourcedir/LogInOut.php"); Login2(); }
   else if ($action == 'logout') { include_once ("$sourcedir/LogInOut.php"); Logout(); }
   else if ($action == 'lock') { include_once ("$sourcedir/LockThread.php"); LockThread(); }
   else if ($action == 'lockVoting') { include_once ("$sourcedir/Poll.php"); LockVoting(); }

PLEASE can someone help me as this mod will certainly be of great help to me.

[David]

Spiff, forgot to tell you how much this mod kicks ass.  I installed it on www.cpfools.com running YaPP with no issues.  My one change was that in the aprove or deny screen it shows the person's IP that they registered under.

[Overseer]

Installed it last night on my forum it works like a charm

Spiff, forgot to tell you how much this mod kicks ass.  I installed it on www.cpfools.com running YaPP with no issues.  My one change was that in the aprove or deny screen it shows the person's IP that they registered under.

I just came to suggest that very thing.
The IP being shown on the approvals page would be a very very good addition to this already useful mod.

[smacktalk]

If someone is denied, no notification email is sent.. why?

[Overseer]

coz they aint worth notifying  

maybe should be an option


i also thought it might be a good idea earlier for admins to be notified of new applicants