UGN Security Forums
My ProfileMember DirectoryLogin
Search our ForumsView our FAQView our Site Rules
View our CalendarView our Active TopicsGo to our Main Page

UGN Security Store
 

Network Sites UGN Security, The GoNix Initiative, Elite Web Gamers, Back of the Web, EveryDay Helper, VNC Web Design & Development
September
Su M Tu W Th F Sa
1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30
Sponsored Links
Latest Postings
The History Thread...
by Gremelin
09/18/14 09:42 AM
Doom 3
by Cyrez
09/11/14 08:58 PM
Latest Reviews
Topic Options
Rate This Topic
#18838 - 11/10/05 07:27 AM index browsing and cool code snipets
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: Maryland
Code:
 
Code from  http://www.ogobin.org/bin/scripts/31337.php.inc 
<?php
/**************************************************
* PHP leetspeak - Version 1.0                     *
* by Oliver Gobin <[email protected]>                 *
* http://www.ogobin.org/bin/scripts/31337.php.inc *
*                                                 *
* PHP port of the PERL Version                    *
* http://www.ogobin.org/bin/sources/31337.perl    *
*                                                 *
* What is leetspeak?                              *
* http://www.wikipedia.org/wiki/Leet              *
* http://www.heise.de/ct/00/11/003/               *
***************************************************/

if(isset($text)) {
  $alphabet = array("a", "b", "c", "d", "e", "f", "g", "h", "i", "j", "k", "l", "m", "n", "o", "p", "q", "r", "s", "t", "u", "v", "w", "x", "y", "z");
  $level1   = array("4", "b", "c", "d", "3", "f", "g", "h", "i", "j", "k", "1", "m", "n", "0", "p", "9", "r", "s", "7", "u", "v", "w", "x", "y", "z");
  $level2   = array("4", "b", "c", "d", "3", "f", "g", "h", "1", "j", "k", "1", "m", "n", "0", "p", "9", "r", "5", "7", "u", "v", "w", "x", "y", "2");
  $level3   = array("4", "8", "c", "d", "3", "f", "6", "h", "'", "j", "k", "1", "m", "n", "0", "p", "9", "r", "5", "7", "u", "v", "w", "x", "'/", "2");
  $level4   = array("@", "8", "c", "d", "3", "f", "6", "h", "'", "j", "k", "1", "m", "n", "0", "p", "9", "r", "5", "7", "u", "v", "w", "x", "'/", "2");
  $level5   = array("@", "|3", "c", "d", "3", "f", "6", "#", "!", "7", "|<", "1", "m", "n", "0", "|>", "9", "|2", "$", "7", "u", "\\/", "w", "x", "'/", "2");
  $level6   = array("@", "|3", "c", "|)", "&", "|=", "6", "#", "!", ",|", "|<", "1", "m", "n", "0", "|>", "9", "|2", "$", "7", "u", "\\/", "w", "x", "'/", "2");
  $level7   = array("@", "|3", "[", "|)", "&", "|=", "6", "#", "!", ",|", "|<", "1", "^^", "^/", "0", "|*", "9", "|2", "5", "7", "(_)", "\\/", "\\/\\/", "><", "'/", "2");
  $level8   = array("@", "8", "(", "|)", "&", "|=", "6", "|-|", "!", "_|", "|\(", "1", "|\\/|", "|\\|", "()", "|>", "(,)", "|2", "$", "|", "|_|", "\\/", "\\^/", ")(", "'/", "\"/_");
  $level9   = array("@", "8", "(", "|)", "&", "|=", "6", "|-|", "!", "_|", "|\{", "|_", "/\\/\\", "|\\|", "()", "|>", "(,)", "|2", "$", "|", "|_|", "\\/", "\\^/", ")(", "'/", "\"/_");
  
  $levels = array($level1, $level2, $level3, $level4, $level5, $level6, $level7, $level8, $level9);
  
  echo "<h4>Original</h4>\n

$text"; 
  
  for($level = 0; $level <= 8; $level++) {
    $tmp = strtolower($text);
    for($item = 0; $item <= 23; $item++) {
      $tmp = ereg_replace($alphabet[$item], $levels[$level][$item], $tmp);
    }
    echo "<h4>Level $level</h4>\n

$tmp";
  }
}

?>
 
_________________________
My New site OpenEyes

Top
Sponsored Links
      
#18839 - 11/10/05 07:32 AM Re: index browsing and cool code snipets
§intå× Offline


*****

Registered: 12/03/02
Posts: 3255
Loc: Maryland
Look closely and find acces to a db

Code:
from  http://www.microexport.org/php/inc/dbSubs.inc
<?php

function dbDate($in_date)
{
	if($in_date)
		return date('Y-m-d', strtotime($in_date));
	else
		return "";
}

function dbDispDate($in_date)
{
	if($in_date)
		return date('d-M-y', strtotime($in_date));
	else
		return "";
}


function dbDispTime($in_date)
{
	if($in_date)
		return date('g:i A', strtotime($in_date));
	else
		return "";
}


function dbOpen()
{
	global $db_conn;
	
	$db_conn = mysql_pconnect(c_mySqlServer, c_mySqlLogin, c_mySqlPW)
				or die("Could not connect to " . c_mySqlServer . "(" . c_mySqlLogin . ")
" 
							.mysql_error());

	mysql_select_db(c_mySqlDBName, $db_conn)
  			or die ("Can't use " . c_mySqlDBName . " : " . mysql_error());

	return $db_conn;
}


function dbClose()
{
	global $db_conn;
	
}


function dbExecute($in_sql)
{
	global $db_conn;
	
  if(mysql_query($in_sql, $db_conn))
  	return TRUE;
  else
  	return FALSE;
}

function dbSelect($in_sql)
{
	global $db_conn;
	
  return mysql_query($in_sql, $db_conn);
}


function dbSingleValue($in_sql)
{
	global $db_conn;
	
	$result = mysql_query($in_sql, $db_conn);
	
	if($result)
	{
		if(mysql_num_rows($result) > 0)
		{
      $lRow = mysql_fetch_array($result);
			$retVal = $lRow[0];
			mysql_free_result($result);
      return $retVal;
		}
	}
	
	return NULL;
}
	
function dbSingleValueColumn($in_sql, $in_column)
{
	global $db_conn;
	
	$result = mysql_query($in_sql, $db_conn);
	
	if($result)
	{
		if(mysql_num_rows() > 0)
		{
      $lRow = mysql_fetch_array($result);
      $retVal = $lRow[$in_column];
			mysql_free_result($result);
      return $retVal;
		}
	}
	
	return NULL;
}




function dbGetAffiliateOperatorID($in_affiliateID)
{
	if(in_affiliateID > 0)
		return dbSingleValue("SELECT operatorID from benBankOp, benBankBranch WHERE benBankOp.benBankID = benBankBranch.benBankId AND benBankBranchID = " . $in_affiliateID);
	else
		return 0;
}


function dbGetMemberBankName($in_bankID)
{
	return dbSingleValue("SELECT name FROM memberBank WHERE memberBankID = " . $in_bankID);
}


function dbGetDepSlipCost($in_memberID)
{
	$lSql = "SELECT cost
						FROM depSlipRequest
						WHERE memberID= " . $in_memberID
					. " ORDER BY delivered DESC ";
					
	$l_cost = dbSingleValue($lSql);
	
	if($l_cost > 0)
		return $l_cost;
	else
		return 0;
}


function dbGetMemberFee($in_benID, $in_memberID)
{
	if($in_benID > 0)
	{
		$l_depositCount = dbSingleValue("SELECT COUNT(*) FROM trans WHERE benID = " . $in_benID);
		if($l_depositCount > 0)
			return 0;
	}
	
				// The beneficiary has not had any transactions, check the member
	
	$l_depositCount = dbSingleValue("SELECT COUNT(*) FROM trans WHERE memberID = " . $in_memberID);
	if($l_depositCount > 0)
	{
		if($in_benID > 0)
		{
				// This must be the first transaction for a new beneficiary
				// See if this is the first send for the member
			$l_depositCount = dbSingleValue("SELECT COUNT(*) 
																				FROM member, trans 
																				WHERE member.memberID = trans.memberID
																				AND trans.transTypeID IN (" . c_transTypeIDSend . ", " . c_transTypeIDCarteraSend . ")");
			
				// There have been sends, but not for this beneficiary so charge new ben fee
			if($l_depositCount > 0)
			{
				return c_newBenFee;
			}
				// There have been no sends, this must be the first send after a cartera, no charge
			else
				return 0;
			

				// If this is the default beneficiary check for carteras

/*				
			$l_depositCount = dbSingleValue("SELECT COUNT(*) 
																				FROM member, trans 
																				WHERE member.defaultBenID = " . $in_benID . "
																				AND member.memberID = trans.memberID
																				AND trans.transTypeID = " . c_transTypeIDCarteraDeposit);
																				
				// If this is the default benficiary and there have been cartera deposits
				// Then waive the new beneficiary fee
			if($l_depositCount > 0)
				return 0;
				
				// No deposits for this beneficiary - no qualifying cartera deposits - charge new ben fee
			else
				return c_newBenFee;
*/			
		}
		
				// This is apparently a cartera transaction for a member with at least one prior transaction
				// Therefore no member fee
		else
			return 0;
	}
	
				// No Transactions for the member -- Charge the new member fee
	else
		return c_normalMemberFee;

}


function dbGetMostRecentXRate($in_currencyID)
{
	return dbSingleValue("SELECT basic FROM xRate WHERE currencyID = " . $in_currencyID
												. " ORDER BY xRateDate DESC");
}


function dbGetMaxXRate($in_currencyID, $in_depDate, $in_type = "basic")
{
	$sqlSel = New clsSqlSelect;
	
		$sqlSel->init("xRate");
		$sqlSel->addColumn("MAX(" . $in_type . ")", $in_type);
		$sqlSel->addCondition("currencyID=" . $in_currencyID);
		$sqlSel->addCondition("TO_DAYS(xRateDate) >= TO_DAYS('" . dbDate($in_depDate) . "')");
		$sqlSel->execute();

		if($sqlSel->fields[$in_type] > 0)
			$l_xRate = $sqlSel->fields[$in_type];
		else
			$l_xRate = 0;
			
		$sqlSel->unload();
		
		return $l_xRate;
}



function dbGetXRate($in_currencyID, $in_depDate, $in_type = "basic")
{
	$sqlSel = New clsSqlSelect;
	
		$sqlSel->init("xRate");
		$sqlSel->addColumn($in_type);
		$sqlSel->addCondition("currencyID=" . $in_currencyID);
		$sqlSel->addCondition("TO_DAYS(xRateDate) = TO_DAYS('" . dbDate($in_depDate) . "')");
		$sqlSel->execute();

		if($sqlSel->fields[$in_type] > 0)
			$l_xRate = $sqlSel->fields[$in_type];
		else
			$l_xRate = 0;
			
		$sqlSel->unload();
		
		return $l_xRate;
}


function dbSetMemberInactive($in_memberID)
{
	dbExecute("UPDATE member SET status = 'Cancelled' WHERE memberID = $in_memberID");
}

function dbSetBenInactive($in_benID)
{
	dbExecute("UPDATE ben SET status = 'Cancelled' WHERE benID = $in_benID");
}

function dbGetBenFullName($in_benID)
{
	return dbSingleValue("SELECT CONCAT_WS(' ', name, paternalFamilyName, maternalFamilyName) AS benName 
														FROM ben WHERE benID = " . $in_benID);
}

function dbGetBenFirstTransID($in_benID)
{
	return dbSingleValue("SELECT MIN(transID) FROM trans WHERE benID = " . $in_benID);
}


function dbGetMemberFullName($in_memberID)
{
	return dbSingleValue("SELECT CONCAT_WS(' ', name, paternalFamilyName, maternalFamilyName) AS memberName 
													FROM member WHERE memberID = " . $in_memberID);
}


function dbGetPostDate()
{
	return dbSingleValue("SELECT value FROM settings WHERE code = 'postDate'");
}

function dbGetCountryID($in_name)
{
	return dbSingleValue("SELECT countryID FROM country "
												.	" WHERE UPPER(name) = '" . strtoupper($in_name) . "'");
}

function dbGetProvinceID($in_countryID, $in_name)
{
	return dbSingleValue("SELECT benProvinceID FROM benProvince "
												.	" WHERE countryID = " . $in_countryID
												. " AND (UPPER(abrev) = '" . strtoupper($in_name) . "'"
													. " OR UPPER(name) = '" . strtoupper($in_name) . "')");
}


function dbGetGenderID($in_gender)
{
	return dbSingleValue("SELECT genderID FROM gender "
												. " WHERE upper(spanishDesc) = '" . strtoupper($in_gender) . "'"
												. " OR UPPER(englishDesc) = '" . strtoupper($in_gender) . "'");
}

?>
_________________________
My New site OpenEyes

Top

Moderator:  §intå×, Gremelin 
Featured Member
Registered: 03/02/02
Posts: 136
Forum Stats
2148 Members
46 Forums
34526 Topics
69696 Posts

Max Online: 1567 @ 04/25/10 02:20 AM
Top Posters
UGN Security 27688
Gremelin 7193
§intå× 3255
SilentRage 1273
Ice 1146
pergesu 1136
Infinite 1041
jonconley 955
Girlie 908
unreal 860
Newest Members
Tim050, Gecko666, defghi795767, Devo60, ali
2148 Registered Users
Who's Online
0 registered (), 288 Guests and 281 Spiders online.
Key: Admin, Global Mod, Mod
Latest News


Donate
  Get Firefox!
Get FireFox!