also der rest der seite geht ohne probleme


zeile 36 steht folgendes

35function db_query($sql_tag) {
36$sql_return = mysql_query($sql_tag);
37return $sql_return;
38 }


Zeile 16 bis 194


// Variabeln definieren
if (!isset($login_check['hinweis'])) $login_check['hinweis'] = "";

function db_connect() {
global $db_host,$db_user,$db_pass,$db_base,$sql_open;
$sql_open = @mysql_connect($db_host,$db_user,$db_pass) or die("Keine Verbindung zur Datenbank!");
$sql_base = @mysql_select_db($db_base) or die("Keine oder falsche Datenbank gewählt!");
}

function db_query($sql_tag) {
$sql_return = mysql_query($sql_tag);
return $sql_return;
}

function db_close() {
global $sql_open;
@mysql_close($sql_open) or die("Konnte die Verbindung mit Datenbank nicht schliessen!");
}

function create_code($code_laenge) {
srand((double)microtime()*1000000);
$created_code = '';
$zeichen="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmn opqrstuvwxyz1234567890";
for ($i=0;$i<$code_laenge;$i++) {
$n=rand() % strlen($zeichen);
$created_code .=substr($zeichen, $n, 1);
}
return $created_code;
}

function buchungsliste ($buchungs_id,$trans_menge,$verwendung,$fuer) {
global $db_prefix;
db_query("INSERT INTO ".$db_prefix."_buchungen (uid,buchungszeit,buchungs_id,buchungsmenge,verwen dungszweck) VALUES (".$fuer.",".time().",'".$buchungs_id."','".$trans _menge."','".$verwendung."')");
}

function kontobuchung ($art,$trans_menge,$fuer) {
global $db_prefix;
db_query("UPDATE ".$db_prefix."_kontodaten SET `kontostand` = `kontostand` ".$art." ".$trans_menge." WHERE uid=".$fuer."");
}

function userstatus () {
global $_SESSION,$db_prefix;
if ($_SESSION['login'] == 'true') {
$us = db_query("SELECT `uid`,`passwort`,`status`,`hinweis` FROM ".$db_prefix."_kontodaten WHERE uid=".$_SESSION['uid']." and passwort='".$_SESSION['passwort']."' LIMIT 1");
$login_check = mysql_fetch_array($us);
if (!mysql_num_rows($us) or $login_check['status'] == 0) {
setCookie('uid','',time()-86400*30);
setCookie('passwort','',time()-86400*30);
setCookie('autologin','',time()-86400*30);
$_SESSION['uid'] = "";
$_SESSION['passwort'] = "";
$_SESSION['login'] = "";
@include_once('content/error/kein_zutritt.php');
@include_once('lib/footer.php');
die();
}
if ($login_check['status'] == 2) {
setCookie('uid','',time()-86400*30);
setCookie('passwort','',time()-86400*30);
setCookie('autologin','',time()-86400*30);
$_SESSION['uid'] = "";
$_SESSION['passwort'] = "";
$_SESSION['login'] = "";
@include_once('content/error/user_gesperrt.php');
@include_once('lib/footer.php');
die();
}
} else {
@include_once('content/error/kein_zutritt.php');
@include_once('lib/footer.php');
die();
}
}

function refumsatz ($buchungssumme,$fuer) {
global $db_prefix;
db_query ("UPDATE ".$db_prefix."_werberdaten SET umsatz = umsatz + ".$buchungssumme.", aktivzeit='".time()."' WHERE uid='".$fuer."' and werber != 0");
}

function aktivralley ($buchungssumme,$fuer) {
global $db_prefix;
// Wenn Aktivralley läuft
$ralleydaten_aktiv = mysql_fetch_array(db_query("SELECT `start`,`ende` FROM ".$db_prefix."_ralleydaten WHERE ralley = 'aktivralley' LIMIT 1"));
if ($ralleydaten_aktiv['start'] <= time() && $ralleydaten_aktiv['ende'] >= time()) {
$aktiveintragen = db_query("SELECT * FROM ".$db_prefix."_aktivralley WHERE uid = '".$fuer."'");
if (!mysql_num_rows($aktiveintragen)) {
db_query ("INSERT INTO ".$db_prefix."_aktivralley (uid,punkte) VALUES ('".$fuer."','".$buchungssumme."')");
} else {
db_query ("UPDATE ".$db_prefix."_aktivralley SET punkte = punkte + ".$buchungssumme." WHERE uid='".$fuer."'");
}
}
}

function klickralley () {
global $db_prefix,$_SESSION;
// wenn Klickralley läuft
$ralleydaten_klick = mysql_fetch_array(db_query("SELECT `start`,`ende`,`art`,`pro` FROM ".$db_prefix."_ralleydaten WHERE ralley = 'klickralley' LIMIT 1"));
if ($ralleydaten_klick['start'] <= time() && $ralleydaten_klick['ende'] >= time()) {
$klickeintragen = db_query("SELECT * FROM ".$db_prefix."_klickralley WHERE uid = '".$_SESSION['uid']."'");
if ($ralleydaten_klick['art'] == 'dynamisch') db_query ("UPDATE ".$db_prefix."_ralleydaten SET jackpot=jackpot+'".$ralleydaten_klick['pro']."' WHERE ralley = 'klickralley'");
if (!mysql_num_rows($klickeintragen)) {
db_query ("INSERT INTO ".$db_prefix."_klickralley (uid,klicks) VALUES ('".$_SESSION['uid']."','1')");
} else {
db_query ("UPDATE ".$db_prefix."_klickralley SET klicks = klicks + 1 WHERE uid='".$_SESSION['uid']."'");
}
}
}
db_query("UPDATE ".$db_prefix."_support SET status=2 WHERE status=1 AND time<".(time()-(5*86400)));
function gold_buchungsliste ($buchungs_id,$trans_menge,$verwendung,$fuer) {
global $db_prefix;

if($verwendung=='Einzahlung'){
$bonus=mysql_fetch_array(db_query("SELECT *, COUNT(uid) AS az FROM ".$db_prefix."_goldmember WHERE uid=".$fuer." AND (gueltig_bis>=".time()." OR unbegrenzt='1') GROUP BY uid LIMIT 1"));
if($bonus['az']==1){
$bonus_prozent=@mysql_fetch_array(db_query("SELECT name,verdienst_bonus,verg_einzahlungen FROM ".$db_prefix."_goldbonus WHERE id='".$bonus['bonus']."' AND aktiv='1' LIMIT 1"));
$verwendung.=' (Upgrade: '.$bonus_prozent['name'].')';
$trans_menge=$trans_menge*$bonus_prozent['verdienst_bonus'];
if($bonus_prozent['verg_einzahlungen']=='0'){
kontobuchung ('-',$trans_menge*$bonus_prozent['verdienst_bonus'],$fuer);
}
}}else{

$bonus=mysql_fetch_array(db_query("SELECT *, COUNT(uid) AS az FROM ".$db_prefix."_goldmember WHERE uid=".$fuer." AND (gueltig_bis>=".time()." OR unbegrenzt='1') GROUP BY uid LIMIT 1"));
if($bonus['az']==1){
$bonus_prozent=@mysql_fetch_array(db_query("SELECT name,verdienst_bonus,verg_einzahlungen FROM ".$db_prefix."_goldbonus WHERE id='".$bonus['bonus']."' AND aktiv='1' LIMIT 1"));
$verwendung.=' (Upgrade: '.$bonus_prozent['name'].')';
$trans_menge=$trans_menge+($trans_menge*$bonus_pro zent['verdienst_bonus']);
}
}

db_query("INSERT INTO ".$db_prefix."_buchungen (uid,buchungszeit,buchungs_id,buchungsmenge,verwen dungszweck) VALUES (".$fuer.",".time().",'".$buchungs_id."','".$trans _menge."','".$verwendung."')");
}

function gold_kontobuchung ($art,$trans_menge,$fuer) {
global $db_prefix;

if($art=='+'){
db_query("DELETE * FROM ".$db_prefix."_goldmember WHERE gueltig_bis<=".time()." AND unbegrenzt=0");
$bonus=mysql_fetch_array(db_query("SELECT bonus, COUNT(uid) AS az FROM ".$db_prefix."_goldmember WHERE uid=".$fuer." AND (gueltig_bis>=".time()." OR unbegrenzt='1') GROUP BY uid LIMIT 1"));
if($bonus['az']==1){
$bonus_prozent=@mysql_fetch_array(db_query("SELECT verdienst_bonus FROM ".$db_prefix."_goldbonus WHERE id='".$bonus['bonus']."' AND aktiv='1' LIMIT 1"));
$trans_menge=($trans_menge*$bonus_prozent['verdienst_bonus'])+$trans_menge;
}}

db_query("UPDATE ".$db_prefix."_kontodaten SET `kontostand` = `kontostand` ".$art." ".$trans_menge." WHERE uid=".$fuer."");
}
db_connect();
$allowed=array("GERMANY", "AUSTRIA", "SWITZERLAND");
$ccode_array = mysql_fetch_array(db_query("SELECT * FROM laendercode WHERE IP_FROM<=inet_aton('".$_SERVER['REMOTE_ADDR']."') AND IP_TO>=inet_aton('".$_SERVER['REMOTE_ADDR']."');"));
if(in_array($ccode_array['land'],$allowed))
{
include('texte/not_allowed_country.txt');
die();
}

function mailralley ($buchungssumme,$userid) {
global $db_prefix;
// Wenn Mailralley läuft
$ralleydaten_aktiv = mysql_fetch_array(db_query("SELECT `start`,`ende` FROM ".$db_prefix."_ralleydaten WHERE ralley = 'mailralley' LIMIT 1"));
if ($ralleydaten_aktiv['start'] <= time() && $ralleydaten_aktiv['ende'] >= time()) {
$aktiveintragen = db_query("SELECT * FROM ".$db_prefix."_mailralley WHERE uid = '".$userid."'");
if (!mysql_num_rows($aktiveintragen)) {
db_query ("INSERT INTO ".$db_prefix."_mailralley (uid,punkte) VALUES ('".$userid."','".$buchungssumme."')");
} else {
db_query ("UPDATE ".$db_prefix."_mailralley SET punkte = punkte + ".$buchungssumme." WHERE uid='".$userid."'");
}
}
}
?>