hab vor einiger zeit meine hp vom alten auf den neuen xampp-server kopiert.
nachdem ich die datenbanken hochgeladen habe und alle erdenklichen configdateien mit den zugangsdaten gefüttert habe, kommen noch immer fehler:
Falsche Datenbankdaten angegeben.Fehler beim Verbinden zur Datenbank.
Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Programme\xampp\htdocs\home\psm\www\counter\class_counter.inc.php on line 18
in mehreren zeilen sind fehler, aber ich kann leider nicht erkennen worans da hapert.
die counter_class.inc sieht folgendermaßen aus:
<style type="text/css">
<!--
body {
background-color: #FF5900;
}
-->
</style><?
class counter
{
var $d, $m, $Y ,$config, $ip;
function initVars()
{
$this->d = date("d");
$this->m = date("m");
$this->Y = date("Y");
$this->config = mysql_fetch_array(mysql_query("SELECT * FROM `".pref."config`"));
$this->ip = $_SERVER['REMOTE_ADDR'];
return 1;
}
function mysqlConnect()
{
if (!$mysql_conn = @mysql_connect(dbhost, dbuser, dbpass))
{
echo "Falsche Datenbankdaten angegeben.";
}
if (!$mysql_conn = @mysql_select_db(db))
{
echo "Fehler beim Verbinden zur Datenbank.";
}
}
function checkRow()
{
list($avail) = mysql_fetch_array(mysql_query("SELECT COUNT(`d`) FROM `".pref."stats` WHERE `d` = '".$this->d."' AND `m` = '".$this->m."' AND `y` = '".$this->Y."'"));
if(!$avail)
{
mysql_query("INSERT INTO `".pref."stats` (`d`, `m`, `y`, `w`) VALUES ('".$this->d."', '".$this->m."', '".$this->Y."', '".date("w")."')");
}
return 1;
}
function deleteOldIps()
{
mysql_query("DELETE FROM `".pref."log` WHERE `time `< '".(time()-3600*$this->config['deliptime'])."'");
return 1;
}
function logIp()
{
mysql_query("INSERT INTO `".pref."log` (`ip`,`time`) VALUES ('".$this->ip."', '".time()."')");
return 1;
}
function ipIsLogged()
{
list($availip) = mysql_fetch_array(mysql_query("SELECT COUNT(`ip`) FROM `".pref."log` WHERE `ip` = '".$this->ip."'"));
return $availip;
}
function countUser()
{
if(!$this->ipIsLogged())
{
mysql_query("UPDATE `".pref."stats` SET `visits` = `visits`+1 WHERE `d` = '".$this->d."' AND `m` = '".$this->m."' AND `y` =' ".$this->Y."'");
$this->logIP();
}
return 1;
}
function counter()
{
$this->mysqlConnect();
$this->initVars();
$this->checkRow();
$this->deleteOldIps();
$this->countUser();
}
function formatNumber($num)
{
$this->config['thousands_sep'] = str_replace("_", " ", $this->config['thousands_sep']);
if(!empty($this->config['thousands_sep']))
{
$num = number_format($num, 0, "", $this->config['thousands_sep']);
}
return $num;
}
function hexToDecArr($hex)
{
$arr[] = hexdec(substr($hex, 1, 2));
$arr[] = hexdec(substr($hex, 3, 2));
$arr[] = hexdec(substr($hex, 5, 2));
return $arr;
}
function getProvider($host)
{
if (preg_match("=^.*\.([\_\-a-zA-Z0-9]*)\.([a-zA-Z]{2,4})=", $host, $h))
{
return strtolower($h[1].".".$h[2]);
}
else
{
return 0;
}
}
function getCountry($host)
{
if (preg_match("=^.*\.([\_\-a-zA-Z0-9]*)\.([a-zA-Z]{2,4})=", $host, $h))
{
return strtolower($h[2]);
}
else
{
return 0;
}
}
function getBrowser($useragent)
{
if (preg_match("=MSIE [0-9]{1,2}.[0-9]{1,2}.*Opera.([0-9]{1})=", $useragent, $browser))
{
return "Opera ".$browser[1]." (als IE)";
}
elseif (preg_match("=MSIE ([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser))
{
return "Internet Explorer ".$browser[1];
}
elseif (preg_match("=Opera/([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser))
{
return "Opera ".$browser[1];
}
elseif (preg_match("=Konqueror=", $useragent)) {
return "Konqueror";
}
elseif (preg_match("=Netscape/7.[0-9]{1,2}=", $useragent))
{
return "Netscape Navigator 7";
}
elseif (preg_match("=Mozilla/5.[0-9]{1,2}=", $useragent))
{
return "Netscape Navigator 6";
}
elseif (preg_match("=Mozilla/([0-9]{1,2}).[0-9]{1,2}=", $useragent, $browser))
{
return "Netscape Navigator ".$browser;
}
else
{
return 0;
}
}
function getOs($useragent)
{
if (preg_match("=Windows NT 5\.0|Windows 2000=", $useragent))
{
return "Windows 2000";
}
elseif (preg_match("=Windows NT 5\.1|Windows XP=", $useragent))
{
return "Windows XP";
}
elseif (preg_match("=Windows NT 4\.0|Windows NT|WinNT4\.0=", $useragent))
{
return "Windows NT";
}
elseif (preg_match("=Windows 98=", $useragent))
{
return "Windows 98";
}
elseif (preg_match("=Windows 95=", $useragent))
{
return "Windows 95";
}
elseif (preg_match("=Mac_PowerPC|Macintosh=", $useragent))
{
return "Macintosh";
}
elseif (preg_match("=Linux=", $useragent))
{
return "Linux";
}
elseif (preg_match("=SunOS=", $useragent))
{
return "SunOS";
}
else {
return 0;
}
}
function updateStats($ref, $resw, $resh, $depth, $useragent, $flash, $js)
{
mysql_query("UPDATE `".pref."stats` SET `hits` = `hits`+1 WHERE `d` = '".$this->d."' AND `m` = '".$this->m."' AND `y` =' ".$this->Y."'");
list($noLog) = mysql_fetch_array(mysql_query("SELECT COUNT(`ip`) FROM `".pref."log` WHERE `ip` = '".$this->ip."' AND `userstat` = 0"));
if($noLog)
{
mysql_query("UPDATE `".pref."log` SET `userstat` = 1 WHERE `ip` = '".$this->ip."'");
$host = gethostbyaddr($this->ip);
mysql_query("INSERT INTO `".pref."userstats` (`ref`, `res`, `depth`, `provider`, `browser`, `os`, `country`, `flash`, `js`, `hour`, `time`) VALUES ('".$ref."', '".($resw." x ".$resh)."', '".$depth."', '".$this->getProvider($host)."', '".$this->getBrowser($useragent)."', '".$this->getOs($useragent)."', '".$this->getCountry($host)."', ".$flash.", ".$js.", ".date("H").", ".time().")");
}
return 1;
}
function transparent($im, $background)
{
if($this->config['transparent'])
{
imagecolortransparent($im, $background);
}
return $im;
}
function cutImage($im,$imDim)
{
$newIm = imagecreate($imDim[2]-$imDim[6]+$this->config['border']*2, $imDim[3]-$imDim[7]+$this->config['border']*2);
imagefill($newIm, 0, 0, $this->config['background']);
imagecopy($newIm, $im, $this->config['border'], $this->config['border'], $imDim[6], $imDim[7], $imDim[2]-$imDim[6], $imDim[3]-$imDim[7]);
return $newIm;
}
function fontImage($num)
{
$this->config['color'] = $this->hexToDecArr($this->config['color']);
$this->config['bgColor'] = $this->hexToDecArr($this->config['bgColor']);
$im = imagecreate(1000, 600);
$background = imagecolorallocate($im, $this->config['bgColor'][0], $this->config['bgColor'][1], $this->config['bgColor'][2]);
$foreground = imagecolorallocate($im, $this->config['color'][0], $this->config['color'][1], $this->config['color'][2]);
imagefill($im, 0, 0, $background);
$imDim = imagettftext($im, $this->config['fontSize'], 0, 0, $this->config['fontSize'], $foreground , fontDir."/". $this->config['font'], $num);
$im = $this->cutImage($im,$imDim);
return $this->transparent($im, $background);
}
function getPicType()
{
if(file_exists(styleDir."/1.gif"))
{
return "gif";
}
elseif(file_exists(styleDir."/1.png"))
{
return "png";
}
elseif(file_exists(styleDir."/1.jpg"))
{
return "jpeg";
}
else
{
return 0;
}
}
function picImage($num)
{
$num = str_replace($this->config['thousands_sep'], "_", $num);
$im = imagecreate(1000,600);
$x0 = 0;
$maxh = 0;
$type = $this->getPicType();
for($i = 0; $i < strlen($num); $i++)
{
$info = getimagesize(styleDir."/".$this->config['style']."/".$num[$i].".gif");
if($info[1] > $maxh)
{
$maxh = $info[1];
}
if($type=="gif")
{
$src = imagecreatefromgif(styleDir."/".$this->config['style']."/".$num[$i].".gif");
}
elseif($type=="png")
{
$src = imagecreatefrompng(styleDir."/".$this->config['style']."/".$num[$i].".png");
}
elseif($type=="jpeg")
{
$src = imagecreatefromjpeg(styleDir."/".$this->config['style']."/".$num[$i].".jpg");
}
imagecopy($im, $src, $x0, 0, 0, 0, $info[0], $info[1]);
$x0 += $info[0];
}
$newIm = imagecreate($x0, $maxh);
imagecopy($newIm, $im, 0, 0, 0, 0, $x0, $maxh);
return $newIm;
}
function createImage($num)
{
if($this->config['type'])
{
return $this->picImage($num);
}
else
{
return $this->fontImage($num);
}
}
function userOnline()
{
list($availip) = mysql_fetch_array(mysql_query("SELECT COUNT(`ip`) FROM `".pref."online` WHERE `ip` = '".$this->ip."'"));
if($availip)
{
mysql_query("UPDATE `".pref."online` SET `time` = ".time()." WHERE `ip` = '".$this->ip."'");
}
else
{
mysql_query("INSERT INTO `".pref."online` (`ip`,`time`) VALUES ('".$this->ip."',".time().")");
}
mysql_query("DELETE FROM `".pref."online` WHERE `time` < ".(time()-$this->config['deltime']*60));
return 1;
}
// visits heute
function showToday($isImg = 0)
{
list($count) = mysql_fetch_array(mysql_query("SELECT `visits` FROM `".pref."stats` WHERE `d` = ".$this->d." AND `m` = ".$this->m." AND `Y` = ".$this->Y));
if($isImg)
{
return $this->createImage($count);
}
else
{
return $count;
}
}
// rekord tag
function showMaxDay($isImg = 0)
{
list($count) = mysql_fetch_array(mysql_query("SELECT MAX(`visits`) FROM `".pref."stats` WHERE `d` > 0"));
if($isImg)
{
return $this->createImage($count);
}
else
{
return $count;
}
}
function getMaxDay()
{
$maxvisits = $this->showMaxDay();
$day = mysql_fetch_array(mysql_query("SELECT `d`, `m`, `Y` FROM `".pref."stats` WHERE `visits` = ".$maxvisits));
return mktime(0, 0, 0, $day['m'], $day['d'], $day['Y']);
}
// user online anzeige
function showOnline($isImg = 0)
{
$this->userOnline();
list($count) = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM `".pref."online`"));
if($isImg)
{
return $this->createImage($count);
}
else
{
return $count;
}
}
function showTotal($isImg = 0)
{
list($total) = mysql_fetch_array(mysql_query("SELECT SUM(`visits`) FROM `".pref."stats`"));
$total = $this->formatNumber($total);
if($isImg)
{
return $this->createImage($total);
}
else
{
return $total;
}
}
function showHits($isImg = 0)
{
list($hits) = mysql_fetch_array(mysql_query("SELECT SUM(`hits`) FROM `".pref."stats`"));
$hits = $this->formatNumber($hits);
if($isImg)
{
return $this->createImage($hits);
}
else
{
return $hits;
}
}
}
?>
ich steh echt an und bräuchte hilfe!
danke!!!
lg,
eddie