Sortierungs Problem nach PHP/MySQL Update

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

  • Sortierungs Problem nach PHP/MySQL Update

    Hallo

    Wir haben ein PHP & MySQL Update auf unsere Server durch geführt seid dem geht leider eins unsere Script nicht mehr so wie soll.

    PHP Version 5.1.6
    MySQL Version 5.0.33

    Wir haben ein Script was Buttons 88x31 nach dem gemessenen IN Hits sotieren soll, der mit den meisten in Klicks als erstes.

    Dies macht er leider nicht mehr er sortiert diese nun nach der ID.

    Code des Scriptes:

    Quellcode

    1. class cn_mysql {
    2. var $connection;
    3. var $text;
    4. # MySQL Verbindung aufbauen
    5. function connect() {
    6. global $mysql_host;
    7. global $mysql_user;
    8. global $mysql_pass;
    9. global $mysql_db;
    10. global $mysql_server_error;
    11. global $mysql_db_error;
    12. $this->connection = @mysql_connect($mysql_host, $mysql_user, $mysql_pass) OR DIE ($mysql_server_error);
    13. mysql_select_db($mysql_db) OR DIE($mysql_db_error);
    14. }
    16. # MySQL Verbindung schließen
    17. function close() {
    18. mysql_close($this->connection);
    19. }
    21. # Einzelne Querys ausgeben
    22. function fetch_array($string) {
    23. $source = mysql_fetch_array(mysql_query($string), MYSQL_ASSOC);
    24. return $source;
    25. }
    26. }
    28. class cn_templates {
    29. function set_file($name, $file) {
    30. $name = "tpl_".$name;
    31. global $$name;
    32. $$name = implode("", file($file));
    33. }
    35. function replace($name_replace, $template) {
    36. $var = "tpl_".$template;
    37. global $$var;
    38. $t = count($name_replace);
    39. for ($i=0, $z=1; $i<=$t; $i+=2, $z+=2){
    40. $$var = str_replace("{".$name_replace[$i]."}", $name_replace[$z], $$var);
    41. }
    42. }
    44. function parse($name) {
    45. $var = "tpl_".$name;
    46. global $$var;
    47. echo $$var;
    48. }
    49. }
    51. # ------------------------------------------------------------
    52. # Funktionen
    53. # ------------------------------------------------------------
    54. function monat_reset__()
    55. {
    56. $mon = date("M");
    57. $reset = @mysql_fetch_array(mysql_query("SELECT last_reset FROM reset"));
    59. if( $reset['last_reset'] != $mon )
    60. {
    61. @mysql_query("DELETE FROM reset");
    62. @mysql_query("INSERT INTO reset (last_reset) VALUES ('$mon')");
    63. @mysql_query("UPDATE affiliates SET `in`='0', `out`='0'");
    64. }
    65. }
    67. function count_rows($tabelle) {
    68. $record = mysql_query("SELECT * FROM $tabelle WHERE active='1'");
    69. while($source = mysql_fetch_array($record)) {
    70. $count++;
    71. }
    72. return $count;
    73. }
    75. function add_visit($id, $art) {
    77. $art = strtolower($art);
    79. //---------------------------------------------------------------------\\
    80. // Alle IP-Adressen löschen, welche die Sperrzeit überschritten haben \\
    82. $sperrzeit = time() - (SYSTEM_AFFILIATES_IPSPERRE_STD*60*60 + SYSTEM_AFFILIATES_IPSPERRE_MIN*60);
    84. $query = "DELETE FROM ".TABLE_AFFILIATES_IPS." ".
    85. "WHERE (zeit <= '".$sperrzeit."')";
    86. mysql_query($query);
    89. //---------------------------------------------------------------------\\
    90. // IP-Adresse gesperrt? \\
    92. $query = "SELECT count(id) FROM ".TABLE_AFFILIATES_IPS." ".
    93. "WHERE (ip = '".$_SERVER['REMOTE_ADDR']."')".
    94. " AND (affiliate_id = '".$id."')".
    95. " AND (typ = '".$art."')";
    96. $result = mysql_query($query);
    98. list($anzahl) = @mysql_fetch_row($result);
    100. if (!$anzahl)
    101. {
    103. //-------------------------------------------------------------------\\
    104. // Die IP-Adresse ist nicht gesperrt \\
    105. // freie ID ermitteln \\
    107. $query = "SELECT id FROM ".TABLE_AFFILIATES_IPS." ORDER BY id";
    108. $result = mysql_query($query);
    110. $ip_id = 1;
    111. while (list($ip_ids) = @mysql_fetch_row($result))
    112. {
    113. if ($ip_ids != $ip_id)
    114. break;
    115. ++$ip_id;
    116. }
    119. //-------------------------------------------------------------------\\
    120. // IP-Adresse eintragen \\
    122. $query = "INSERT INTO ".TABLE_AFFILIATES_IPS.
    123. " (id, ip, affiliate_id, typ, zeit) ".
    124. "VALUES".
    125. " ('".$ip_id."', '".$_SERVER['REMOTE_ADDR']."', '".$id."', '".$art."', '".time()."')";
    126. mysql_query($query);
    129. //-------------------------------------------------------------------\\
    130. // Den Counter erhöhen \\
    132. $query = "UPDATE affiliates ".
    133. "SET `".$art."` = (`".$art."` + '1') ".
    134. "WHERE (id = '".$id."')";
    135. mysql_query($query);
    137. } // IP-Adresse gesperrt?
    139. }
    141. function check_pass() {
    142. global $templates;
    143. global $tpl_Content;
    144. if (empty($_SESSION['passwort'])) {
    145. return FALSE;
    146. $templates->set_file("Content", "templates/admin/login.htm");
    147. }
    148. else {
    149. return TRUE;
    150. }
    151. }
    153. function show_pages($tabelle) {
    154. GLOBAL $anzahl;
    155. GLOBAL $limit;
    157. $anzahl = 10;
    158. $rows = count_rows($tabelle);
    159. $count = ceil($rows/$anzahl);
    161. if ($_GET["page"] == "" || $_GET["page"] >= count_rows($tabelle)) {
    162. $_GET["page"] = $count;
    163. }
    165. $limit = $rows-($_GET["page"]*$anzahl);
    166. if ($limit<0) {
    167. $anzahl = $anzahl+$limit;
    168. $limit = 0;
    169. }
    171. if ($count == 1) {
    172. $navi = "Seite (";
    173. }
    174. else {
    175. $navi = "Seiten (";
    176. }
    177. $nr = 1;
    179. for ($i=0; $i < $count; $i++) {
    180. if ($i != 0) {
    181. $navi .= ", ";
    182. }
    184. if ($_GET["page"] == $nr) {
    185. $navi .= "[<a href=\"?action=admin&show=all&page=$nr\"><b>".($i+1)."</b></a>]";
    186. }
    187. else {
    188. $navi .= "<a href=\"?action=admin&show=all&page=$nr\">".($i+1)."</a>";
    189. }
    190. $nr++;
    191. }
    192. $navi .= ")";
    193. return $navi;
    194. }
    195. # ------------------------------------------------------------
    197. $templates = new cn_templates;
    198. $mysql = new cn_mysql;
    200. $mysql->connect();
    201. # ------------------------------------------------------------
    203. //---------------------------------------------------------------------------\\
    204. // Sollte die IP-Tabelle noch nicht existieren, dann wird sie jetzt erstellt \\
    205. // affiliate_id => ID in der Tabelle 'affiliates' \\
    206. // typ => 'in' oder 'out' \\
    207. // IP-Sperre wurde in die Funktion 'add_visit' implementiert \\
    209. $query = "CREATE TABLE IF NOT EXISTS ".TABLE_AFFILIATES_IPS.
    210. " (id INT UNSIGNED NOT NULL PRIMARY KEY,".
    211. " ip VARCHAR(15),".
    212. " affiliate_id INT UNSIGNED,".
    213. " typ CHAR(3),".
    214. " zeit INT UNSIGNED".
    215. " )";
    216. mysql_query($query);
    219. if (isset($_GET["id"]) && !$_GET['action'] && !$show_banner) {
    220. $source = $mysql->fetch_array("SELECT * FROM affiliates WHERE (id = '".$_GET["id"]."')");
    221. $url = $source["url"];
    222. add_visit($_GET["id"], "out");
    223. header("location: $url");
    224. exit;
    225. }
    227. if (isset($_GET["ref"]) && !$_GET['action'] && !$show_banner) {
    228. add_visit($_GET["ref"], "in");
    229. header("location: http://www.rb-media-group.de");
    230. exit;
    231. }
    234. //---------------------------------------------------------------------------\\
    235. // Sollen 5 durch Zufall gewählte Banner angezeigt werden? \\
    237. // monatlicher reset
    238. @monat_reset__();
    240. if ($show_banner)
    241. {
    243. $query__ = "SELECT `id`, `image`, `in`, `out` FROM `affiliates` WHERE `active`";
    244. $result__ = mysql_query($query__);
    246. $anzahl = @mysql_num_rows($result__);
    248. if ($anzahl)
    249. {
    250. mt_srand((double)microtime()*1000000);
    251. $banner__ = array();
    254. while (list($id__, $image__, $in__, $out__) = mysql_fetch_row($result__))
    255. {
    256. array_push($banner__, array($id__, $image__, $in__, $out__));
    257. }
    259. $random_banner__ = array_rand($banner__, $show_banner);
    261. echo "\n\n<table border='0' cellpadding='0' cellspacing='0'>\n";
    263. for ($nummer__ = 0; $nummer__ < count($random_banner__); $nummer__++)
    264. {
    265. printf("<tr><td align='center'><a href='partner.php?id=%1\$s' title='IN:%3\$s OUT:%4\$s' target='_blank'>".
    266. "<img src='%2\$s' alt='IN:%3\$s OUT:%4\$s' border='0'></a></td></tr>\n",
    267. $banner__[$random_banner__[$nummer__]][0], $banner__[$random_banner__[$nummer__]][1],
    268. $banner__[$random_banner__[$nummer__]][2], $banner__[$random_banner__[$nummer__]][3]);
    269. }
    271. echo "</table>\n\n";
    273. }
    275. }
    276. else
    277. {
    280. switch($_GET["action"]) {
    281. # Partner Buttons anzeigen
    282. default:
    283. $number_buttons = count_rows("affiliates");
    285. $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC LIMIT 0, $buttons_anzahl");
    286. while($source = mysql_fetch_array($record)) {
    287. $i++;
    288. $templates->set_file("Button", "templates/button.htm");
    289. $templates->replace(array("ID", $source["id"],
    290. "Image", $source["image"],
    291. "IN", $source["in"],
    292. "OUT", $source["out"]
    293. ), "Button");
    294. $buttons .= $tpl_Button;
    295. $templates->set_file("Row", "templates/row.htm");
    296. $templates->replace(array("Buttons", $buttons
    297. ), "Row");
    298. $output .= $tpl_Row;
    299. $buttons = "";
    300. $number = $number + $buttons_per_rows;
    302. }
    304. $templates->set_file("Tabelle", "templates/table.htm");
    306. $templates->replace(array("Rows", $output,
    307. ), "Tabelle");
    310. $templates->parse("Tabelle");
    311. break;
    312. case "showall":
    313. $number_buttons = count_rows("affiliates");
    315. $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC");
    316. while($source = mysql_fetch_array($record)) {
    317. $i++;
    318. $templates->set_file("Button", "templates/button.htm");
    319. $templates->replace(array("ID", $source["id"],
    320. "Image", $source["image"],
    321. "IN", $source["in"],
    322. "OUT", $source["out"]
    323. ), "Button");
    324. $buttons .= $tpl_Button;
    325. if ($i == ($buttons_per_rows + $number) || $i == $number_buttons) {
    326. $templates->set_file("Row", "templates/row.htm");
    327. $templates->replace(array("Buttons", $buttons
    328. ), "Row");
    329. $output .= $tpl_Row;
    330. $buttons = "";
    331. $number = $number + $buttons_per_rows;
    332. }
    334. }
    336. $templates->set_file("Tabelle", "templates/table.htm");
    338. $templates->replace(array("Rows", $output,
    339. ), "Tabelle");
    342. $templates->parse("Tabelle");
    343. break;
    344. case "box":
    345. $buttons_anzahl = "6";
    346. $number_buttons = count_rows("affiliates");
    348. $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC LIMIT 0, $buttons_anzahl");
    349. while($source = mysql_fetch_array($record)) {
    350. $i++;
    351. $templates->set_file("Button", "templates/button.htm");
    352. $templates->replace(array("ID", $source["id"],
    353. "Image", $source["image"],
    354. "IN", $source["in"],
    355. "OUT", $source["out"]
    356. ), "Button");
    357. $buttons .= $tpl_Button;
    358. if ($i == ($box_per_rows + $number) || $i == $number_buttons) {
    359. $templates->set_file("Row", "templates/row.htm");
    360. $templates->replace(array("Buttons", $buttons
    361. ), "Row");
    362. $output .= $tpl_Row;
    363. $buttons = "";
    364. $number = $number + $box_per_rows;
    365. }
    367. }
    369. $templates->set_file("Tabelle", "templates/table.htm");
    371. $templates->replace(array("Rows", $output,
    372. ), "Tabelle");
    375. $templates->parse("Tabelle");
    376. break;
    377. case "add":
    378. if ($_POST["partner_url"] && $_POST["partner_image"] && $_POST["partner_email"] != "") {
    379. $query = mysql_query ("INSERT affiliates (url, image, email, active) VALUES ('".$_POST['partner_url']."', '".$_POST['partner_image']."', '".$_POST['partner_email']."', '0')");
    380. if ($query) {
    381. mail($admin_email, "RB Media Group Partner Anmeldung", $new_partner, "From: ".$admin_email." \nReply-To: ".$admin_email." \n");
    382. header("location: http://www.rb-media-group.de/affiliates/danke.html");
    383. die("Du wurdest erfolgreich zu den Partnern von RB Media Group hinzugefügt. Wenn der Admin dich freigeschaltet hat, bekommst du eine E-Mail mit allen nötigen Informationen");
    384. }
    385. else {
    386. die("Es gab ein Problem beim hinzufügen des Partners. Bitte kontaktieren Sie den Admin.");
    387. }
    388. }
    389. else {
    390. die("Du hast nicht alle nötigen Felder ausgefüllt");
    391. }
    392. break;
    394. # Admin Bereich
    395. case "admin":
    396. session_start();
    397. if (!check_pass()) {
    398. $_GET["show"] = "login";
    399. }
    401. switch ($_GET["show"]) {
    402. default:
    403. case "all":
    404. $templates->set_file("Content", "templates/admin/all.htm");
    405. $pages = show_pages("affiliates");
    406. $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY id DESC LIMIT $limit, $anzahl");
    407. while($source = mysql_fetch_array($record)) {
    408. $templates->set_file("All", "templates/admin/all_show.htm");
    409. $templates->replace(array("Image", $source["image"],
    410. "ID", $source["id"],
    411. "IN", $source["in"],
    412. "OUT", $source["out"],
    413. "URL", $source["url"],
    414. "E-Mail", $source["email"]
    415. ), "All");
    416. $partner .= $tpl_All;
    417. }
    419. $templates->replace(array("Partner", $partner,
    420. "Pages", $pages
    421. ), "Content");
    422. break;
    423. case "edit":
    424. $templates->set_file("Content", "templates/admin/edit.htm");
    425. $record = mysql_query("SELECT id FROM affiliates ORDER BY id ASC");
    426. while($source = mysql_fetch_array($record)) {
    427. $partner .= "<option>".$source["id"]."</option>";
    428. }
    430. if (isset($_POST["edit_id"])) {
    431. $source = $mysql->fetch_array("SELECT * FROM affiliates WHERE id='".$_POST["edit_id"]."'");
    432. $templates->set_file("Edit_Show", "templates/admin/edit_show.htm");
    433. $templates->replace(array("Image", $source["image"],
    434. "URL", $source["url"],
    435. "E-Mail", $source["email"],
    436. "ID", $source["id"]
    437. ), "Edit_Show");
    438. }
    440. $templates->replace(array("Partner_IDs", $partner,
    441. "Edit_Field", $tpl_Edit_Show
    442. ), "Content");
    443. if ($_GET["do"]=="update") {
    444. $query = mysql_query ("UPDATE affiliates SET image='".$_POST['partner_image']."', url='".$_POST['partner_url']."', email='".$_POST['partner_email']."' WHERE id='".$_POST["partner_id"]."'");
    445. if ($query) {
    446. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=edit\">";
    447. $tpl_Content = "Der Partner wurde erfolgreich upgedated. Du wirst in 2 sek. weitergeleitet...";
    448. }
    449. else {
    450. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=edit\">";
    451. $tpl_Content = "Es gab ein Problem deinen Partner zu bearbeiten. Du wirst in 2 sek. weitergeleitet...";
    452. }
    453. }
    455. if ($_GET["delete"]!="") {
    456. $query = mysql_query ("DELETE FROM affiliates WHERE id='".$_GET["delete"]."'");
    457. if ($query) {
    458. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=all\">";
    459. $tpl_Content = "Dein Partner wurde erfolgreich gelöscht. Du wirst in 2 sek. weitergeleitet...";
    460. }
    461. else {
    462. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=all\">";
    463. $tpl_Content = "Es gab ein Problem deinen Partner zu löschen. Du wirst in 2 sek. weitergeleitet...";
    464. }
    465. }
    466. break;
    467. case "activate":
    468. $templates->set_file("Content", "templates/admin/activate.htm");
    469. $record = mysql_query("SELECT * FROM affiliates WHERE active='0' ORDER BY id DESC");
    470. while($source = mysql_fetch_array($record)) {
    471. $templates->set_file("Activate", "templates/admin/activate_show.htm");
    472. $templates->replace(array("Image", $source["image"],
    473. "ID", $source["id"],
    474. "IN", $source["in"],
    475. "OUT", $source["out"],
    476. "URL", $source["url"],
    477. "E-Mail", $source["email"]
    478. ), "Activate");
    479. $partner .= $tpl_Activate;
    480. }
    482. $templates->replace(array("Partner", $partner,
    483. ), "Content");
    485. if (isset($_GET["activate"])) {
    486. $query = mysql_query ("UPDATE affiliates SET active='1' WHERE id='".$_GET["activate"]."'");
    487. if ($query) {
    488. $source = $mysql->fetch_array("SELECT * FROM affiliates WHERE id='".$_GET["activate"]."'");
    489. $button_url = $homepage."/partner.php?ref=".$source["id"];
    490. $partner = $partner_email.$button_url;
    491. echo $partner;
    492. $email = mail($source["email"], "RichBone.de Partner Anmeldung", $partner, "From: ".$admin_email." \nReply-To: ".$admin_email." \n");
    493. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=activate\">";
    494. $tpl_Content = "Dein Partner wurde erfolgreich freigeschaltet.<br>";
    495. if ($email) {
    496. $tpl_Content = "E-Mail erfolgreich an Partner geschickt.<br>Du wirst in 2 sek. weitergeleitet...";
    497. }
    498. else {
    499. $tpl_Content = "Es gab ein Problem beim senden der E-Mail an deinen Partner.<br>Du wirst in 2 sek. weitergeleitet...";
    500. }
    501. }
    502. else {
    503. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=adminn&show=activate\">";
    504. $tpl_Content = "Es gab ein Problem deinen Partner freizuschalten. Du wirst in 2 sek. weitergeleitet...";
    505. }
    506. }
    507. break;
    508. case "reset":
    509. $query = mysql_query("UPDATE affiliates SET `in`='0', out='0'");
    510. if ($query) {
    511. $tpl_Content = "Daten erfolgreich resetet";
    512. }
    513. else {
    514. $tpl_Content = "Es gab ein Problem beim reseten der Daten";
    515. }
    516. break;
    517. case "login":
    518. if ((!isset($_POST["login_passwort"]))) {
    519. $templates->set_file("Content", "templates/admin/login.htm");
    520. }
    521. else {
    522. if ($passwort == $_POST["login_passwort"]) {
    523. $_SESSION['passwort'] = $_POST["login_passwort"];
    524. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin&show=all\">";
    525. $tpl_Content = "Du wurdest erfolgreich eingeloggt. Du wirst in 2 sek. weitergeleitet...";
    526. }
    527. else {
    528. $templates->set_file("Content", "templates/admin/login.htm");
    529. $tpl_Content .= "<center>Du hast ein falsches Passwort eingegeben.</center><br>";
    530. }
    531. }
    532. break;
    533. case "logout":
    534. session_destroy();
    535. $weiterleitung = "<meta http-equiv=\"refresh\" content=\"2; URL=partner.php?action=admin\">";
    536. $tpl_Content = "Du wurdest erfolgreich ausgeloggt. Du wirst in 2 sek. weitergeleitet...";
    537. break;
    538. }
    541. $templates->set_file("Admin", "templates/admin/main.htm");
    543. $templates->replace(array("Content", $tpl_Content,
    544. "Weiterleitung", $weiterleitung
    545. ), "Admin");
    548. $templates->parse("Admin");
    549. break;
    550. }
    551. }
    552. # ------------------------------------------------------------
    553. $mysql->close();
    Alles anzeigen

  • Hallo

    switch($_GET["action"]) {
    # Partner Buttons anzeigen
    default:
    $number_buttons = count_rows("affiliates");

    $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC LIMIT 0, $buttons_anzahl");
    while($source = mysql_fetch_array($record)) {
    $i++;
    $templates->set_file("Button", "templates/button.htm");
    $templates->replace(array("ID", $source["id"],
    "Image", $source["image"],
    "IN", $source["in"],
    "OUT", $source["out"]
    ), "Button");
    $buttons .= $tpl_Button;
    $templates->set_file("Row", "templates/row.htm");
    $templates->replace(array("Buttons", $buttons
    ), "Row");
    $output .= $tpl_Row;
    $buttons = "";
    $number = $number + $buttons_per_rows;

    }

    $templates->set_file("Tabelle", "templates/table.htm");

    $templates->replace(array("Rows", $output,
    ), "Tabelle");


    $templates->parse("Tabelle");
    break;
    case "showall":
    $number_buttons = count_rows("affiliates");

    $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC");
    while($source = mysql_fetch_array($record)) {
    $i++;
    $templates->set_file("Button", "templates/button.htm");
    $templates->replace(array("ID", $source["id"],
    "Image", $source["image"],
    "IN", $source["in"],
    "OUT", $source["out"]
    ), "Button");
    $buttons .= $tpl_Button;
    if ($i == ($buttons_per_rows + $number) || $i == $number_buttons) {
    $templates->set_file("Row", "templates/row.htm");
    $templates->replace(array("Buttons", $buttons
    ), "Row");
    $output .= $tpl_Row;
    $buttons = "";
    $number = $number + $buttons_per_rows;
    }

    }

    $templates->set_file("Tabelle", "templates/table.htm");

    $templates->replace(array("Rows", $output,
    ), "Tabelle");


    $templates->parse("Tabelle");
    break;
    case "box":
    $buttons_anzahl = "6";
    $number_buttons = count_rows("affiliates");

    $record = mysql_query("SELECT * FROM affiliates WHERE active='1' ORDER BY 'in' DESC LIMIT 0, $buttons_anzahl");
    while($source = mysql_fetch_array($record)) {
    $i++;
    $templates->set_file("Button", "templates/button.htm");
    $templates->replace(array("ID", $source["id"],
    "Image", $source["image"],
    "IN", $source["in"],
    "OUT", $source["out"]
    ), "Button");
    $buttons .= $tpl_Button;
    if ($i == ($box_per_rows + $number) || $i == $number_buttons) {
    $templates->set_file("Row", "templates/row.htm");
    $templates->replace(array("Buttons", $buttons
    ), "Row");
    $output .= $tpl_Row;
    $buttons = "";
    $number = $number + $box_per_rows;
    }

    }

    $templates->set_file("Tabelle", "templates/table.htm");

    $templates->replace(array("Rows", $output,
    ), "Tabelle");


    $templates->parse("Tabelle");


    Was meinst du mit Backticks?

    RichBone

  • wenn du keine Änderungen am Script gemacht hast, dann kann es sich ja eigentlich nur um Sachen handeln, bei denen MySQL oder PHP restriktiver geworden sind.

    Konzentrier dich übrigens nicht nur aufs ändern von Single-Quotes zu Backticks. Spaltennamen die verdächtig nach einem Typen klingen würde ich prinzipiell in Backticks schreiben. Also schreib am besten alle Spalten und Tabellen in Backticks.