Probleme mit Newssystem

Diese Seite verwendet Cookies. Durch die Nutzung unserer Seite erklären Sie sich damit einverstanden, dass wir Cookies setzen. Weitere Informationen

  • Probleme mit Newssystem

    Hallo, ich habe auf meinem Webspace ein Newssystem installiert, bzw. ich bin gerade dabei. Ich habe dazu folgendes importiert:

    Brainfuck-Quellcode

    1. -- phpMyAdmin SQL Dump
    2. -- version 2.9.1.1
    3. -- http://www.phpmyadmin.net
    4. --
    5. -- Host: localhost
    6. -- Erstellungszeit: 17. Januar 2007 um 23:21
    7. -- Server Version: 5.0.27
    8. -- PHP-Version: 5.2.0
    9. --
    10. -- Datenbank: `news`
    11. --
    13. -- --------------------------------------------------------
    15. --
    16. -- Tabellenstruktur für Tabelle `kaihou_comments`
    17. --
    19. CREATE TABLE `kaihou_comments` (
    20. `commentid` int(10) unsigned NOT NULL auto_increment,
    21. `newsid` int(10) unsigned NOT NULL,
    22. `name` varchar(100) collate utf8_unicode_ci NOT NULL,
    23. `email` varchar(100) collate utf8_unicode_ci NOT NULL,
    24. `content` text collate utf8_unicode_ci NOT NULL,
    25. `date` int(11) NOT NULL,
    26. `status` tinyint(4) NOT NULL default '1',
    27. PRIMARY KEY (`commentid`),
    28. KEY `newsid` (`newsid`)
    29. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
    31. --
    32. -- Daten für Tabelle `kaihou_comments`
    33. --
    35. -- --------------------------------------------------------
    37. --
    38. -- Tabellenstruktur für Tabelle `kaihou_ips`
    39. --
    41. CREATE TABLE `kaihou_ips` (
    42. `ip` varchar(15) collate utf8_unicode_ci NOT NULL,
    43. `commentid` int(10) unsigned NOT NULL,
    44. `date` int(10) unsigned NOT NULL
    45. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
    47. --
    48. -- Daten für Tabelle `kaihou_ips`
    49. --
    51. -- --------------------------------------------------------
    53. --
    54. -- Tabellenstruktur für Tabelle `kaihou_news`
    55. --
    57. CREATE TABLE `kaihou_news` (
    58. `newsid` int(10) unsigned NOT NULL auto_increment,
    59. `userid` smallint(5) unsigned NOT NULL,
    60. `title` varchar(255) collate utf8_unicode_ci NOT NULL,
    61. `content` text collate utf8_unicode_ci NOT NULL,
    62. `content_more` text collate utf8_unicode_ci NOT NULL,
    63. `date` int(11) NOT NULL,
    64. `nl2br` tinyint(1) NOT NULL default '1',
    65. PRIMARY KEY (`newsid`)
    66. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
    68. --
    69. -- Daten für Tabelle `kaihou_news`
    70. --
    72. -- --------------------------------------------------------
    74. --
    75. -- Tabellenstruktur für Tabelle `kaihou_users`
    76. --
    78. CREATE TABLE `kaihou_users` (
    79. `userid` smallint(5) unsigned NOT NULL auto_increment,
    80. `username` varchar(100) collate utf8_unicode_ci NOT NULL,
    81. `password` varchar(32) collate utf8_unicode_ci NOT NULL,
    82. PRIMARY KEY (`userid`)
    83. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
    85. --
    86. -- Daten für Tabelle `kaihou_users`
    87. --
    89. INSERT INTO `kaihou_users` VALUES (1, 'admin', MD5('test'));
    Alles anzeigen




    Außerdem habe ich alle MySQL Daten richtig eingetragen. Nun kommt beim Aufruf allerdings die Fehlermeldung:

    Notice: Unknown column 'news.hide' in 'where clause' in /home/www/irgendwas/kaihou/lib/db_mysql.php on line 90

    Notice: Unknown column 'news.keywords' in 'field list' in /home/www/irgendwas/kaihou/lib/db_mysql.php on line 90

    db_mysql.php:

    Quellcode

    1. <?php
    2. if(!defined("MAIN")) exit('Hacking not allowed');
    4. class DB_MySQL
    5. {
    6. var $LinkId;
    7. var $LastQueryResource;
    8. var $LastQueryString;
    9. var $QueryCount;
    11. var $Config = array();
    13. function MySQL($Host, $User, $Password, $Database, $Prefix)
    14. {
    15. $this->Config = array("host" => $Host, "user" => $User, "pass" => $Password, "dbase" => $Database, "prefix" => $Prefix);
    16. $this->LinkId = NULL;
    17. $this->LastQueryResource = NULL;
    18. }
    20. /*public function __destruct()
    21. {
    22. $this->Close();
    24. unset($this->LastQueryResource);
    25. unset($this->Config);
    26. }*/
    28. function SetConfig($Key, $Value)
    29. {
    30. $this->Config[$Key] = $Value;
    31. }
    33. function GetConfig($Key)
    34. {
    35. if(isset($this->Config[$Key]))
    36. return $this->Config[$Key];
    37. }
    39. function Connect($array)
    40. {
    41. $this->Config = array("host" => $array[0], "user" => $array[1], "pass" => $array[2], "dbase" => $array[3], "prefix" => $array[4]);
    42. $this->LinkId = mysql_connect($this->Config['host'], $this->Config['user'], $this->Config['pass']);
    44. if($this->LinkId == false)
    45. {
    46. // put error.
    47. }
    48. else
    49. $this->SelectDatabase($this->Config['dbase']);
    50. }
    52. function Close()
    53. {
    54. if($this->LinkId != false)
    55. {
    56. mysql_close($this->LinkId);
    57. $this->LinkId == false;
    58. }
    59. }
    61. function IsConnected()
    62. {
    63. return ($this->LinkId == false ? false : true);
    64. }
    66. function SelectDatabase($Database)
    67. {
    68. if(mysql_select_db($Database, $this->LinkId) == false)
    69. {
    70. // put error.
    71. }
    72. }
    74. function Query($String, $Unbuffered = false)
    75. {
    76. if(!$this->IsConnected()) return false;
    78. $this->LastQueryString = $String;
    80. if(defined("DBG_MYSQL")) echo "<pre> $String </pre>";
    81. $this->QueryCount++;
    83. if($Unbuffered == false)
    84. $this->LastQueryResource = mysql_query($String, $this->LinkId);
    85. else
    86. $this->LastQueryResource = mysql_unbuffered_query($String, $this->LinkId);
    88. if($this->LastQueryResource == false)
    89. {
    90. trigger_error(mysql_error());
    91. }
    92. }
    94. function GetResource()
    95. {
    96. return $this->LastQueryResource;
    97. }
    99. function NumRows()
    100. {
    101. if($this->GetResource() == false)
    102. return 0;
    103. else
    104. return mysql_num_rows($this->GetResource());
    105. }
    107. function AffectedRows()
    108. {
    109. if($this->IsConnected() == false)
    110. return 0;
    111. else
    112. return mysql_affected_rows($this->LinkId);
    113. }
    115. function FetchArray($Resource = NULL, $Mode = MYSQL_ASSOC)
    116. {
    117. if($Resource == NULL)
    118. $Resource = $this->GetResource();
    120. if($Resource == false)
    121. return false;
    123. $Data = mysql_fetch_array($Resource, $Mode);
    124. return $Data;
    125. }
    127. function Result($Row = 0, $Field = NULL)
    128. {
    129. $Resource = $this->GetResource();
    131. if($Resource == false)
    132. return false;
    134. $Data = mysql_result($Resource, $Row, $Field);
    135. return $Data;
    136. }
    138. function InsertId($Table)
    139. {
    140. $Table = "`". $this->GetConfig("prefix") . "_" . $Table ."`";
    141. $this->Query("SELECT LAST_INSERT_ID() FROM ". $Table);
    143. return $this->Result(0);
    144. }
    146. function Escape($String)
    147. {
    148. return mysql_real_escape_string($String, $this->LinkId);
    149. }
    151. // select
    152. /*
    153. andylib_MySQL::Select("field", "table", "WHERE ...");
    154. andylib_MySQL::Select(array("field1", "field2"), "table", "WHERE ...");
    155. andylib_MySQL::Select(array("alias" => array("field1", "field2"), "alias2" => array("field3", "field4")), array("table" => "alias", "table2" => array("LEFT JOIN", "alias2", "alias2.id = alias.id")), "WHERE ...");
    156. */
    157. function Select($Fields, $Table, $Condition = "")
    158. {
    159. // case 1: $Fields is only one field - perform query and return the result directly
    160. if(is_string($Fields))
    161. {
    162. if(strstr($Fields, "COUNT(")) $Field = $Fields;
    163. else $Field = "`". $Fields ."`";
    165. $Table = "`". $this->GetConfig("prefix") . "_" . $Table ."`";
    167. $QueryString = "SELECT {$Field} FROM {$Table} {$Condition}";
    168. $this->Query($QueryString);
    170. if($this->NumRows() == 0) return NULL;
    172. return $this->Result(0);
    173. }
    175. // case 2: $Fields is an array - perform query and return mysql_num_rows()
    176. if(is_array($Fields))
    177. {
    178. $Field = "";
    180. foreach($Fields as $Key => $Value)
    181. {
    182. if(is_array($Value))
    183. foreach($Value as $JoinKey => $JoinField)
    184. {
    185. if(!is_numeric($JoinKey))
    186. {
    187. if(strstr($JoinKey, "COUNT("))
    188. $Field .= "COUNT(". $Key .".". (substr($JoinKey, 6)) ." AS `". $JoinField ."`, ";
    189. elseif(strstr($JoinKey, "SUM("))
    190. $Field .= "SUM(". $Key .".". (substr($JoinKey, 4)) ." AS `". $JoinField ."`, ";
    191. else
    192. $Field .= $Key .".`". $JoinKey ."` AS `". $JoinField ."`, ";
    193. }
    194. else
    195. {
    196. if(strstr($JoinField, "COUNT("))
    197. $Field .= "COUNT(". $Key .".". (substr($JoinKey, 6)) .", ";
    198. elseif(strstr($JoinField, "SUM("))
    199. $Field .= "SUM(". $Key .".". (substr($JoinKey, 4)) ." AS `". $JoinField ."`, ";
    200. else
    201. $Field .= $Key .".`". $JoinField ."`, ";
    202. }
    203. }
    204. else
    205. $Field .= "`". $Value ."`, ";
    206. }
    208. $Tables = "";
    209. $Joins = "";
    211. if(is_string($Table))
    212. $Tables = "`". $this->GetConfig("prefix") . "_" . $Table ."`, ";
    213. else
    214. {
    215. foreach($Table as $Key => $Value)
    216. {
    217. if(is_array($Value))
    218. foreach($Value as $JK)
    219. $Joins .= $JK[0] ." ". $this->GetConfig("prefix") . "_" . $Key ." AS `". $JK[1] ."` ON ". $JK[2] ." ";
    220. else
    221. $Tables .= "`". $this->GetConfig("prefix") . "_" . $Key ."` AS `". $Value ."`, ";
    222. }
    223. }
    225. $Field = substr(trim($Field), 0, -1);
    226. $Tables = substr(trim($Tables), 0, -1);
    228. $QueryString = "SELECT {$Field} FROM {$Tables} {$Joins} {$Condition}";
    229. $this->Query($QueryString);
    232. return $this->NumRows();
    233. }
    234. }
    236. function Insert($Table, $Fields)
    237. {
    238. $Table = "`". $this->GetConfig("prefix") . "_" . $Table ."`";
    239. $Field = "";
    241. foreach($Fields as $Key => $Value)
    242. $Field .= "`". $Key ."` = '". $Value ."', ";
    244. $Field = substr(trim($Field), 0, -1);
    246. $QueryString = "INSERT INTO {$Table} SET {$Field}";
    247. $this->Query($QueryString);
    249. return $this->AffectedRows();
    250. }
    252. function Update($Table, $Fields, $Condition = "")
    253. {
    254. $Table = "`". $this->GetConfig("prefix") . "_" . $Table ."`";
    255. $Field = "";
    257. foreach($Fields as $Key => $Value)
    258. {
    259. if(strlen($Value) != 0)
    260. $Field .= "`". $Key ."` = ". ($Value{0} != "`" ? "'". $Value ."'" : $Value) .", ";
    261. else
    262. $Field .= "`". $Key ."` = '". $Value ."', ";
    263. }
    265. $Field = substr(trim($Field), 0, -1);
    267. $QueryString = "UPDATE {$Table} SET {$Field} {$Condition}";
    268. $this->Query($QueryString);
    270. return $this->AffectedRows();
    271. }
    273. function Delete($Table, $Condition = "")
    274. {
    275. $Table = "`". $this->GetConfig("prefix") . "_" . $Table ."`";
    277. $QueryString = "DELETE FROM {$Table} {$Condition}";
    278. $this->Query($QueryString);
    280. return $this->AffectedRows();
    281. }
    282. }
    284. ?>
    Alles anzeigen


    Kann mir bitte jemand helfen?

    (Sorry für den langen Post :))