Hoi,
iemand een idee wat er nog verkeerd staat ?
FOUTMELDING
-----------------
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Inetpub\vhosts\dondev.net\httpdocs\az724\data.php on line 14
Could not connected to db host.. Access denied for user 'ODBC'@'localhost' (using password: NO)
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\Inetpub\vhosts\dondev.net\httpdocs\az724\data.php on line 18
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in D:\Inetpub\vhosts\dondev.net\httpdocs\az724\data.php on line 317
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in D:\Inetpub\vhosts\dondev.net\httpdocs\az724\data.php on line 321
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in D:\Inetpub\vhosts\dondev.net\httpdocs\az724\data.php on line 321
Query failed: Access denied for user 'ODBC'@'localhost' (using password: NO)
de file waar de fouten zouden moeten instaan.
DATA.PHP
------------
<?PHP
include_once 'setup.php';
include_once 'engine.php';
#
class Data{
var $dbh, $table_message, $db;
###
function Data (){
$host = $GLOBALS[localhost];
$name = $GLOBALS[dudr336_1];
$psw = $GLOBALS[daihatsu_1];
$user = $GLOBALS[hakan_01];
$this->dbh = mysql_connect($host,$name,$psw,$user );
if (!$this->dbh) echo (sprintf("Could not connected to db host..%s ",$this->dbh) . mysql_error());
$this->table_message = $GLOBALS['db_table_message'];
$this->db = sprintf($GLOBALS['hakan_01']);
mysql_select_db($this->db, $this->dbh); # select database
}
### !!!!!! use only one
function sql(){
if (mysql_query($sql, $this->dbh))
echo "Database ".$name."sql command was successfully\n";
else
echo 'Error : ' . mysql_error() . "\n";
}
###
function CreateDataBase($name){
$sql = sprintf('CREATE DATABASE %s', $name);
if (mysql_query($sql, $this->dbh)) {
echo "Database ".$name."created successfully\n";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}
}
###
function CreateTableMessage($drop){
mysql_select_db($this->db, $this->dbh);
if ($drop == 1 )
mysql_query("DROP TABLE message_data", $this->dbh);
$sql = "CREATE TABLE message_data
(
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
header VARCHAR(255),
email VARCHAR(60),
path VARCHAR(255),
private INT,
art VARCHAR(80),
validate INT,
validate_date VARCHAR(80),
verify_string VARCHAR(80),
created INT,
created_date VARCHAR(80),
image_file_type VARCHAR(80)
)";
if (mysql_query($sql, $this->dbh)) {
echo "table ".$name." was deleted and new created \n";
} else {
echo 'Error creating table database: ' . mysql_error() . "\n";
}
}
###
function getNextID(){
mysql_select_db($this->db, $this->dbh);
return (mysql_insert_id());
}
###
function AddMessage ($sql){
$err = "";
if (mysql_query($sql, $this->dbh))
$err = "";
else {
$err = 'Error running SQL command: ' . mysql_error() ;
echo ($err) ;
}
return ($err);
}
###
function Close (){
mysql_close($this->dbh);
}
function GetCountOfMessages($path,$ret ){
$ret = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT COUNT(*) FROM %s WHERE path='%s' AND validate!=0", $this->table_message, $path ) ;
$result = mysql_query($sql, $this->dbh);
if ($result) {
$temp_result = mysql_fetch_row($result);
if (isset($temp_result[0]))
$ret = $temp_result[0];
mysql_free_result($result);
}else
$ret = 0;
}
#
function PrintImage ($verify_string){
$this->ContentHandle('print_image',$verify_string ,&$image,'');
echo($image);
}
### search in the database
function GetQueryLinks($search, $array_ret, $sql_order){
$count = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT * FROM %s ", $this->table_message) ;
if (strlen($sql_order) > 0) $sql .= $sql_order ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
# suche in header
$pos = strpos( strtoupper($row['header']), strtoupper($search));
# suche im text
$content = '';
$return = 0;
$this->ContentHandle('get_text',$row['verify_string'],&$content,$return) ;
$pos2 = strpos( strtoupper($content), strtoupper($search));
if ($pos === false && $pos2 === false) {
}else{
array_push($array_ret,$row);
$count ++ ;
}
}
mysql_free_result($result);
return ($count);
}
###
function GetMessageLinks ($path, $message,$sql_filter, $sql_order, $content_frame, $maskedid, $validate_date ){
$i = 0;
$ret = array();
$temp = "";
$maskedid = 0 ;
mysql_select_db($this->db, $this->dbh);
# filter
if (strlen($sql_filter) > 0 ){
$sql = sprintf("SELECT * FROM %s WHERE path='%s' AND art='%s'", $this->table_message, $path, $sql_filter ) ;
}else {
$sql = sprintf("SELECT * FROM %s WHERE path='%s'", $this->table_message, $path ) ;
}
# order
if (!strlen($sql_order))
$sql .= " ORDER BY PRIVATE" ;
else
$sql .= " " . $sql_order ;
# $sql = sprintf("DELETE FROM %s WHERE path='%s'", $this->table_message, $path ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if (!$row ['validate']) continue ;
$this->ContentHandle('get_image',$row['verify_string'],&$row['image'],'');
array_push($ret,$row);
}
mysql_free_result($result);
return ($ret);
}
###
function MessageExists($key){
$ret = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT * FROM %s WHERE verify_string LIKE '%s'", $this->table_message, $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$ret ++ ;
}
mysql_free_result($result);
return ($ret);
}
function TraceMessages ($array_ret){
$ret = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT * FROM %s ORDER BY ID", $this->table_message) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
array_push($array_ret,$row);
}
mysql_free_result($result);
}
###
function ActivateMessage($key){
$ret = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("UPDATE %s SET validate=%d WHERE verify_string LIKE '%s' ", $this->table_message,time(), $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$sql = sprintf("UPDATE %s SET validate_date='%s' WHERE verify_string LIKE '%s' ", $this->table_message, GetDDate(), $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
#
if ($result)
$ret = 1;
# aktualisiere engnine liste
$engine = new SB_Engine();
if ($engine) {
$sql = sprintf("SELECT * FROM %s WHERE verify_string LIKE '%s'", $this->table_message, $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$update_path = explode (".",$row['path']);
$engine->CreateDBList($update_path[0]);
}
mysql_free_result($result);
}
#echo ($result);
unset($engine);
}
return ($ret);
}
###
function DeleteMessage($key){
$ret = 0;
$update_path = "";
mysql_select_db($this->db, $this->dbh);
# aktualisiere start - liste teil 1
$engine = new SB_Engine();
if ($engine) {
$sql = sprintf("SELECT * FROM %s WHERE verify_string LIKE '%s'", $this->table_message, $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$update_path = explode (".",$row['path']);
}
mysql_free_result($result);
}
}
#
$sql = sprintf("DELETE FROM %s WHERE verify_string LIKE '%s' ", $this->table_message, $key ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
# delete image & text
$this->ContentHandle('delete_image',$key ,'','');
$this->ContentHandle('delete_text',$key ,'','');
#
if ($result){
$ret = 1;
}
# aktualisiere start - liste teil 2
$engine = new SB_Engine();
if ($engine && $update_path[0]) {
$engine->CreateDBList($update_path[0]);
unset($engine);
}
#
return ($ret);
}
function DeleteMessageID($id){
$ret = 0;
$update_path = "";
mysql_select_db($this->db, $this->dbh);
# aktualisiere start - liste teil 1
$engine = new SB_Engine();
if ($engine) {
$sql = sprintf("SELECT * FROM %s WHERE id = %d ", $this->table_message, $id ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$update_path = explode (".",$row['path']);
}
mysql_free_result($result);
}
}
#
$sql = sprintf("DELETE FROM %s WHERE id = %d ", $this->table_message, $id ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result ) {
$message = sprintf("Anzeige %s wurde aus der Datenbank rausgelöscht ",$row['header'] ) ;
echo ( $message) ;
mysql_free_result($result);
}
# delete image & text
$this->ContentHandle('delete_image',$row['key'],'','');
$this->ContentHandle('delete_text',$row['key'] ,'','');
#
if ($result){
$ret = 1;
}
# aktualisiere start - liste teil 2
$engine = new SB_Engine();
if ($engine && $update_path[0]) {
$engine->CreateDBList($update_path[0]);
unset($engine);
}
#
return ($ret);
}
###
function DeleteOldMessage($time){
$ret = 0;
mysql_select_db($this->db, $this->dbh);
$last_time = time() - $time ;
# delete image and text
$sql = sprintf("SELECT verify_string FROM %s WHERE created < %d ", $this->table_message, $last_time ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
if ($result) {
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$this->ContentHandle('delete_image',$row['verify_string'],'','');
$this->ContentHandle('delete_text',$row['verify_string'],'','');
}
mysql_free_result($result);
}
$sql = sprintf("DELETE FROM %s WHERE created < %d ", $this->table_message, $last_time ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
#
}
###
function MessageGetParameters ($verify_string,$private, $header, $email, $rubrik, $rubriksub, $content) {
$i = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT * FROM %s WHERE verify_string ='%s'", $this->table_message,$verify_string ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
$header = $row ['header'];
$email = $row ['email'];
$art = $row ['art'];
$t = explode(".", $row ['path']);
$rubrik = $t [0];
$rubriksub = $t [1];
$this->ContentHandle('get_text',$row['verify_string'],&$content,'');
$private = intval( $row ['private']);
$i ++ ;
}
if ($i != 1 )
echo ('Fehler in der Funktion Data ::MessageGetParameters() ');
mysql_free_result($result);
}
###
function MessageGetParametersID ($id, $ret_data) {
$i = 0;
mysql_select_db($this->db, $this->dbh);
$sql = sprintf("SELECT * FROM %s WHERE id =%d", $this->table_message,$id ) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($row as $key => $value) {
$ret_data[$key] = $value;
}
$i ++ ;
}
# get content file
$this->ContentHandle('get_text',$ret_data['verify_string'],&$ret_data['content'],$return) ;
if ($i != 1 )
echo ('Fehler in der Funktion Data ::MessageGetParameters() ');
mysql_free_result($result);
}
###
function MessageEditUpdate($verify_string, $header, $art, $content){
mysql_select_db($this->db, $this->dbh);
$path = sprintf ("%s.%s", $rubrik , $rubriksub );
$sql = sprintf("UPDATE %s SET header='%s', art='%s' WHERE verify_string LIKE '%s' ",
$this->table_message, $header, $art, $verify_string) ;
$result = mysql_query($sql) or die('Query failed: ' . mysql_error());
$this->ContentHandle('update_text',$verify_string ,$content,''); # update text file
}
###
function ContentHandle($mode,$key,$content,$return){
$pos = strpos($mode, 'image');
if ($pos > 0){
$file = sprintf ("messages/images/%s",$key);
}else {
$file = sprintf ("messages/text/%s",$key);
}
switch ($mode) {
case 'add_image':
$fh = fopen($file, 'wb');
flock($fh,LOCK_EX);
if (strlen( $content) > 0 ) {
if (fwrite($fh, $content) == FALSE)
echo ("Fehler ContentHandle #1");
}
fclose($fh);
break;
case 'update_image':
if (is_file($file)) unlink($file);
$this->ContentHandle('add_image',$key,$content,$return) ;
break;
case 'print_image':
$chunksize = 1024*1024;
$fh = fopen($file, 'rb');
if (!$fh) {
$content = "";
return;
}
while (!feof($fh))
{
$buffer = fread($fh, $chunksize);
echo $buffer;
flush();
}
fclose($fh);
break;
case 'get_image':
$chunksize = 1024*1024;
if (!is_file($file)) {
$content = "";
return;
}
$fh = fopen($file, 'rb');
if (!$fh) {
$content = "";
return;
}
while (!feof($fh))
{
$buffer = fread($fh, $chunksize);
$content .= $buffer ;
}
fclose($fh);
break;
case 'delete_image':
if (is_file($file)) unlink($file);
break;
case 'add_text':
$fh = fopen($file, 'w');
flock($fh,LOCK_EX);
if (fwrite($fh, $content) === FALSE)
echo ("Fehler ContentHandle #2");
fclose($fh);
break;
case 'update_text':
if (is_file($file)) unlink($file);
$this->ContentHandle('add_text',$key,$content,$return) ;
break;
case 'get_text':
$chunksize = 1024*1024;
if (!is_file($file)) {
$content = "";
return;
}
$fh = fopen($file, 'r');
$content = fread($fh, $chunksize);
fclose($fh);
break;
case 'delete_text':
if (is_file($file)) unlink($file);
break;
default:
echo ("Fehler in der FunktionContentHandle ");
break;
}
}
};
?>
Thnx alvast.
Cheers David
453 views
