hallo
ich bekomme immer nen fehler wenn ich per odbc versuche auf meine db zu zugreifen der sieht foldendermaßen aus
Code:
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben, SQL state IM002 in SQLConnect in C:\xampp\htdocs\1\ranking\index.php on line 71
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\xampp\htdocs\1\ranking\index.php on line 93
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber angegeben, SQL state IM002 in SQLConnect in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 15
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 18
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 20
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 26
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 28
Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 34
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\1\ranking\ranking_top_3.php on line 36
Warning: odbc_fetch_array(): supplied argument is not a valid ODBC result resource in C:\xampp\htdocs\1\ranking\index.php on line 107
hir ist meine "ranking_top_3.php" und "Index.php" ich denke nicht das dort ein fehler drinne ist weil das script funktionirte vor 3 tagen wunderbar (Befor ich meinen root server Formatirt hatte) nach der formation ging´s net mehr....
ranking_top_3.php
PHP-Code:
<?php
$config = array(
'db_username' => 'Darn', // database username
'db_password' => 'Sheila47476833', // database password
'db_dsn' => 'kal_db', // system DSN to the database
'debug' => false, // show SQL errors if true
);
$conn = odbc_connect($config['db_dsn'],
$config['db_username'],
$config['db_password']);
$pknight = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 0 AND [Admin] = 0 ORDER BY [Level] Desc, [Exp] Desc";
$ppknight = odbc_exec($conn,$pknight);
while($knight = odbc_fetch_array($ppknight)){
$knight_1 = '<b>'.$knight['Name'].'</b>';
};
$parcher = $parcher = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 2 AND [Admin] = 0 ORDER BY [Level] Desc, [Exp] Desc";
$pparcher = odbc_exec($conn,$parcher);
while($archer = odbc_fetch_array($pparcher)){
$archer_1 = '<b>'.$archer['Name'].'</b>';
};
$pmage = $pmage = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 1 AND [Admin] = 0 ORDER BY [Level] Desc, [Exp] Desc";
$ppmage = odbc_exec($conn,$pmage);
while($mage = odbc_fetch_array($ppmage)){
$mage_1 = '<b>'.$mage['Name'].'</b>';
};
echo '<table class="top_3" border="0">';
echo '<tr><td><img style="position:relative;top:5px;right:1px;" src="img/top_3_img_03.png"></td></tr>';
echo '<tr><td class="top_3_1" background="img/top_3_img_04.png" height="35">';
echo '<table border="0" cellpadding="0px" cellspacing="0px" width="400">';
echo '<tr align="center">';
echo '<td style="font-size: 11px; font-weight: bold; color: rgb(204, 51, 0);" width="55" height="15">Knight</td>';
echo '<td style="font-size: 11px; font-weight: bold; color: rgb(204, 51, 0);" width="10">Archer</td>';
echo '<td style="font-size: 11px; font-weight: bold; color: rgb(204, 51, 0);" width="10">Magician</td>';
echo '</tr>';
echo '<tr align="center">';
echo '<td class="top_3_2">'.$knight_1.'</td>';
echo '<td class="top_3_2">'.$archer_1.'</td>';
echo '<td class="top_3_2">'.$mage_1.'</td>';
echo '</tr>';
echo '</table></td></tr>';
echo '</table>';
?>
index.php
PHP-Code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html>
<head>
<title>Eternity Ranking</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="description" content="KalOnline Ranking">
<meta name="author" content="Darn">
<meta name="keywords" content="Ranking, KalOnline">
<meta name="language" content="en">
<meta name="robots" content="index, follow">
<link rel="stylesheet" type="text/css" href="ranking.css">
</head>
<center>
<?php
// Anti-SQL Injection
function check_inject()
{
$badchars = array(";", "'", " \ ", "DROP", "SELECT", "drop", "select","DELETE","delete");
foreach($_POST as $value)
{
$value = clean_variable($value);
if(in_array($value, $badchars))
{
die("SQL Injection Detected - Make sure only to use letters and numbers!\n<br />\nIP: ".$_SERVER['REMOTE_ADDR']);
}
else
{
$check = preg_split("//", $value, -1, PREG_SPLIT_OFFSET_CAPTURE);
foreach($check as $char)
{
if(in_array($char, $badchars))
{
die("SQL Injection Detected - Make sure only to use letters and numbers!\n<br />\nIP: ".$_SERVER['REMOTE_ADDR']);
}
}
}
}
{
#start a check for SQL injections.
#this is kinda nub here, you can make it better by just escaping stings and what not.
if(strstr($v, "'") || strstr($v, '"') || strstr($v, "\\") || strstr($v, "/"))
{
#if we detect an injection, stop the script.
die("Injection Detected");
}
}
}
$config = array(
'db_username' => 'Darn', // database username
'db_password' => 'Sheila47476833', // database password
'db_dsn' => 'kal_db', // system DSN to the database
'debug' => false, // show SQL errors if true
);
$conn = odbc_connect($config['db_dsn'],
$config['db_username'],
$config['db_password']);
$top = 1;
$plist = "SELECT TOP 200
Player.GID,
Player.Level,
Player.Class,
Player.Specialty,
Player.Name,
Player.Exp,
Guild.Name AS GuildName
FROM
Player
LEFT JOIN
Guild
ON
Guild.GID = Player.GID
WHERE
Admin = 0
ORDER BY
Player.Level DESC,Player.Exp DESC";
$pplist = odbc_exec($conn,$plist);
if($guild == "")
{
$guild = "-";
}
include ('ranking_top_3.php');
echo '<table class="ranking" width="400px" height="1">';
echo '<tr><td width="30px"><b><font color="black">Rank</font></b></td><td width="60px"><b> <font color="black">Name</font></b></td><td width="110px"><b> <font color="black">Job</font></b></td><td width="40px"><b><font color="black">Level</font></b></td><td width="110px"><b> <font color="black">Guild</font></b></td><td width="100px"><b> <font color="black">Experience</font></b></td></tr><tr><td colspan="6"> </td></tr>';
while($r = odbc_fetch_array($pplist)){
include ('ranking_level_progress_calculator.php');
if($r['Class'] == 0 && $r['Specialty'] == 1){
$class = '<font color="black">Wondering Knight</font>';
}elseif($r['Class'] == '0' && $r['Specialty'] == '3'){
$class = '<font color="black">Apprentice Knight</font>';
}elseif($r['Class'] == '0' && $r['Specialty'] == '7'){
$class = '<font color="black">Vagabond</font>';
}elseif($r['Class'] == '0' && $r['Specialty'] == '11'){
$class = '<font color="black">Commander</font>';
}elseif($r['Class'] == '0' && $r['Specialty'] > '12'){
$class = '<font color="blue">Jobhacker Knight :P</font>';
}elseif($r['Class'] == '1' && $r['Specialty'] == '1'){
$class = '<font color="black">Scholar</font>';
}elseif($r['Class'] == '1' && $r['Specialty'] == '3'){
$class = '<font color="black">Literary Person</font>';
}elseif($r['Class'] == '1' && $r['Specialty'] == '7'){
$class = '<font color="black">Hermit</font>';
}elseif($r['Class'] == '1' && $r['Specialty'] == '11'){
$class = '<font color="black">CJB</font>';
}elseif($r['Class'] == '1' && $r['Specialty'] > '12'){
$class = '<font color="blue">Jobhacker Mage :P</font>';
}elseif($r['Class'] == '2' && $r['Specialty'] == '1'){
$class = '<font color="black">Wondering Archer</font>';
}elseif($r['Class'] == '2' && $r['Specialty'] == '3'){
$class = '<font color="black">Apprentice Archer</font>';
}elseif($r['Class'] == '2' && $r['Specialty'] == '7'){
$class = '<font color="black">Expert Archer</font>';
}elseif($r['Class'] == '2' && $r['Specialty'] == '11'){
$class = '<font color="black">IC</font>';
}elseif($r['Class'] == '2' && $r['Specialty'] > '12'){
$class = '<font color="blue">Jobhacker Archer :P</font>';
};
echo '<tr><td><font color="black">'.$top.'</td><td><font color="black">'.$r['Name'].'</td><td>'.$class.'</td><td><font color="black"><center>'.$r['Level'].'</center></td><td><font color="black">'.$r['GuildName'].'</td><td><table><tr>';
# design 1
if ($design_1 == '1'){
echo $design_1_1;
eval ($bar_5);
echo $design_1_2;
};
# design 2
if ($design_2 == '1'){
echo $design_2_1;
};
# design 3
if ($design_3 == '1'){
echo $design_3_1;
};
# design 4
if ($design_4 == '1'){
echo $design_4_1;
};
echo '</tr></table></td></tr><tr><td colspan="6"> </td></tr></tr>';
$top++;
}
echo '</table>';
?>
<div align=center class=copyright ><font color="black" >Copyright © Eternity</A> </font></div>
<div align=center class=copyright ><font color="black" >Edited by Darn</font></div>
<p> </p></body></html>
</center>
</body>
</html>
Villeicht weiß ja jemand wo mein fehler ist
danke schonmal im vorraus :P
~Darn
12.08.2009, 03:18
ODBC connect fehler 
Ähnliche Themen 
