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 ?>



Banner strip
Danno Sheehan - VINYL Album for Christmas Visit SHOP
Banner strip

Canvist

View Duo Bio click image



View Canvist Profile

Danno back in 2001 formed a band in Glasgow with Marie McCormick playing under the name Canvist did two TV appearences on Lancastshire TV the band recorded an album of Covers including Summer Time,The letter and Queen Bee 20 year's later we are re-releasing the album (original CD) and on usual Digital media

Live on Scotish TV

Canvist on Lancastshire TV 2001. video recorded from VHS tape so some technical issues