Forum PHP.pl

[SQL] pobierz, plaintext 
<?
class Account
{
FUNCTION is_pacc_acc($acc_nr)
{
$query = mysql_query("SELECT premdays FROM `accounts` WHERE `id` = ".intval($acc_nr)."");
$row = mysql_fetch_array($query);
IF($row)
{
RETURN $row['premdays'];
}
else
{
RETURN 0;
}
}
FUNCTION getEmail($acc_nr)
{
$query = mysql_query("SELECT email FROM `accounts` WHERE `id` = ".intval($acc_nr)."");
$row = mysql_fetch_array($query);
IF($row)
{
RETURN $row['email'];
}
else
{
RETURN false;
}
}
FUNCTION is_god_acc($acc_nr)
{
$query = mysql_query("SELECT group_id FROM `accounts` WHERE `id` = ".intval($acc_nr)."");
$row = mysql_fetch_array($query);
IF($row)
{
RETURN 1;
}
else
{
RETURN false;
}
}
FUNCTION loss_reckey()
{
$letters=array("A","a","B","b","C","c","D","d","E","e","F","f","G","g","H","h","I","i","J","j","K","k",
"L","l","M","m","N","n","O","o","P","p","Q","q","R","r","S","s","T","t","U","u","V","v","W","w","X","x","Y","y","Z","z");
$numbers=array("0","1","2","3","4","5","6","7","8","9");
$rec_key=$letters[rand(0,50)].$letters[rand(0,50)].$letters[rand(0,50)].$numbers[rand(0,9)].$letters[rand(0,50)]."-".$numbers[rand(0,25)].$letters[rand(0,50)].$numbers[rand(0,9)].$letters[rand(0,50)].$numbers[rand(0,25)].$letters[rand(0,50)].$numbers[rand(0,9)].$letters[rand(0,50)]."-".$numbers[rand(0,9)].$letters[rand(0,50)].$numbers[rand(0,9)].$letters[rand(0,50)].$numbers[rand(0,9)].$numbers[rand(0,9)];
RETURN $rec_key;
}
FUNCTION getGuildID($id)
{
$query = mysql_query('SELECT guild FROM accounts WHERE id="'.intval($id).'"');
$row = mysql_fetch_array($query);
RETURN $row['guild'];
}
FUNCTION getGuildName($id)
{
$query = mysql_query('SELECT * FROM `guilds` WHERE `guildid` = '.intval($id).'');
$row = mysql_fetch_array($query);
RETURN $row['guildname'];
}
FUNCTION skroc($tekst,$ile)
{
$znaki = strlen($tekst);
IF ($znaki>=$ile)
{
$tnij = substr($tekst, 0, $ile);
$skrocone = $tnij."...";
}
else
{
$skrocone = $tekst;
}
RETURN $skrocone;
}
}
$ACCOUNT = new Account;
?>
[SQL] pobierz, plaintext