function getChecksum($DBID,$mysqldb,$mysqlip,$mysqlusr,$mysqlpwd,$status,$CHK) { // Connect to database $CHK=check_input($CHK); $DBID=check_input($DBID); $status=check_input($status); $sel_count=0; $mem_checksum="nonreg access"; $success=""; //validate DBID ; if ($status>0 && $status<5 && $DBID!="") { $con=mysql_connect($mysqlip,$mysqlusr,$mysqlpwd) or die ("Cannot connect to Danno's database"); mysql_select_db($mysqldb,$con); $result = mysql_query("SELECT * FROM members WHERE mem_num = '$DBID' ") or die ("Error: " . mysql_error()); while($row = mysql_fetch_array($result)) { $sel_count++ ; $mem_checksumDB=$row['mem_checksum'];$success=$row['mem_type'];$sel_email=$row['mem_email'];} mysql_close($con); } if ($status==1&&$success=="AD"&&$CHK==$mem_checksumDB) {$mem_checksum=$mem_checksumDB;} if ($status==2&&($success=="AD"||$success=="MB")&&$CHK==$mem_checksumDB) {$mem_checksum=$mem_checksumDB;} if ($status==3&&($success=="AD"||$success=="MB"||$success=="RG")&&$CHK==$mem_checksumDB) {$mem_checksum=$mem_checksumDB;} if ($status==4&&($success=="NV")) {$mem_checksum=$mem_checksumDB;} if ($mem_checksum=="nonreg access") {$mem_checksum=generatePassword(12,4);} return $mem_checksum ; } function getChecksumAD($DBID,$mysqldb,$mysqlip,$mysqlusr,$mysqlpwd,$status) { // Connect to database $DBID=check_input($DBID); $status=check_input($status); $sel_count=0; $mem_checksum="nonreg access"; $success=""; //validate DBID ; if ($status>0 && $status<5 && $DBID!="") { $con=mysql_connect($mysqlip,$mysqlusr,$mysqlpwd) or die ("Cannot connect to Danno's database"); mysql_select_db($mysqldb,$con); $result = mysql_query("SELECT * FROM members WHERE mem_num = '$DBID' ") or die ("Error: " . mysql_error()); while($row = mysql_fetch_array($result)) { $sel_count++ ; $mem_checksumDB=$row['mem_checksum'];$success=$row['mem_type'];$sel_email=$row['mem_email'];} mysql_close($con); } if ($status==1&&$success=="AD") {$mem_checksum=$mem_checksumDB;} if ($status==2&&($success=="AD"||$success=="MB")) {$mem_checksum=$mem_checksumDB;} if ($status==3&&($success=="AD"||$success=="MB"||$success=="RG")) {$mem_checksum=$mem_checksumDB;} if ($mem_checksum=="nonreg access") {$mem_checksum=generatePassword(12,4);} return $mem_checksum ; } function generatePassword($length, $strength) { $vowels = 'aeuy'; $consonants = 'bdghjmnpqrstvz'; if ($strength & 1) { $consonants .= 'BDGHJLMNPQRSTVWXZ'; } if ($strength & 2) { $vowels .= "AEUY"; } if ($strength & 4) { $consonants .= '23456789'; } if ($strength & 8) { $consonants .= 'zZxX'; } $password = ''; $alt = time() % 2; for ($i = 0; $i < $length; $i++) { if ($alt == 1) { $password .= $consonants[(rand() % strlen($consonants))]; $alt = 0; } else { $password .= $vowels[(rand() % strlen($vowels))]; $alt = 1; } } return $password; } function DispRow($HRef,$P3,$P4,$P5,$P8,$W,$C) { $hreffile=$HRef ; $parts[3]=$P3;$parts[4]=$P4;$parts[5]=$P5;$parts[8]=$P8; ?>

0) { $goto=$page.$pageparams; //goto page with parameters If ($button=="") { //display button icon ?>

0) {$pageparams=$pageparams."?success=".$success."&DBID=".$DBID."&CHK=".$CHK;} } ?> 0) && ($success<4)) { ?> 3)) { if ($msqlenabled) { ?>

0)&&($success<4)) { $titletext="registered"; $registeredtogo=$registeredpage.$pageparams; $registeredbutton="W3DRegisteredButton.jpg"; ?> 0)&&($success<3)) { $memberbutton="W3DMemberButton.jpg"; $titletext="member's area"; $membertogo=$memberpage.$pageparams; ?> 0)&&($success<3)) { $titletext="on demand radio"; $ondemandtogo=$ondemandpage.$pageparams; ?> 0)&&($success<2)) { $adminbutton="SBRAdminButton.jpg"; $titletext="admin area"; $admintogo=$adminpage.$pageparams; ?>