Файл: concrete5.7.5.6/concrete/src/Utility/Service/Identifier.php
Строк: 100
<?php
namespace ConcreteCoreUtilityService;
use Loader;
/**
* @package Helpers
* @subpackage Validation
* @author Andrew Embler <andrew@concrete5.org>
* @copyright Copyright (c) 2003-2008 Concrete5. (http://www.concrete5.org)
* @license http://www.concrete5.org/license/ MIT License
*/
/**
* A helper that allows the creation of unique strings, for use when creating hashes, identifiers.
* @package Helpers
* @subpackage Validation
* @author Andrew Embler <andrew@concrete5.org>
* @copyright Copyright (c) 2003-2008 Concrete5. (http://www.concrete5.org)
* @license http://www.concrete5.org/license/ MIT License
*/
class Identifier {
private $letters = 'abcefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ1234567890';
/**
* Like generate() below, but simply appends an ever increasing number to what you provide
* until it comes back as not found
*/
public function generateFromBase($string, $table, $key) {
$foundRecord = false;
$db = Loader::db();
$i = '';
$_string = '';
while ($foundRecord == false) {
$_string = $string . $i;
$cnt = $db->GetOne("select count(" . $key . ") as total from " . $table . " where " . $key . " = ?", array($_string));
if ($cnt < 1) {
$foundRecord = true;
} else {
if ($i == '') {
$i = 0;
}
$i++;
}
}
return $_string;
}
/**
* Generates a unique identifier for an item in a database table. Used, among other places, in generating
* User hashes for email validation
* @param string $table
* @param string $key
* @param int $length
* @param bool $lowercase
* @return string
*/
public function generate($table, $key, $length = 12, $lowercase = false) {
$foundHash = false;
$db = Loader::db();
while ($foundHash == false) {
$string = $this->getString($length);
if ($lowercase) {
$string = strtolower($string);
}
$cnt = $db->GetOne("select count(" . $key . ") as total from " . $table . " where " . $key . " = ?", array($string));
if ($cnt < 1) {
$foundHash = true;
}
}
return $string;
}
public function getString($length = 12) {
$str = str_repeat($this->letters, 10);
$hash = substr(str_shuffle($str), 0, $length);
return $hash;
}
public function deleteKey($table, $keyCol, $uHash){
$db = Loader::db();
$db->Execute("DELETE FROM ".$table." WHERE ".$keyCol."=?", array($uHash) );
}
}