der code ist dieser
- <?php
- /*-------------------------------------------------------+
- | PHP-Fusion Content Management System
- | Copyright (C) 2002 - 2008 Nick Jones
- | http://www.php-fusion.co.uk/
- +--------------------------------------------------------+
- | Filename: search_marketplace_include.php
- | Author: Robert Gaudyn (Wooya)
- +--------------------------------------------------------+
- | This program is released as free software under the
- | Affero GPL license. You can redistribute it and/or
- | modify it under the terms of this license which you
- | can read by viewing the included agpl.txt or online
- | at www.gnu.org/licenses/agpl.html. Removal of this
- | copyright header is strictly prohibited without
- | written permission from the original author(s).
- +--------------------------------------------------------*/
- if (!defined("IN_FUSION")) { die("Access Denied"); }
- include LOCALE.LOCALESET."search/mplace.php";
- if ($_GET['stype'] == "marketplace" || $_GET['stype'] == "all") {
- if ($_GET['sort'] == "datestamp") {
- $sortby = "mplace_datestamp";
- } else if ($_GET['sort'] == "subject") {
- $sortby = "mplace_article";
- } else {
- $sortby = "mplace_datestamp";
- }
- $ssubject = search_querylike("mplace_article");
- $smessage = search_querylike("mplace_message");
- if ($_GET['fields'] == 0) {
- $fieldsvar = search_fieldsvar($ssubject);
- } else if ($_GET['fields'] == 1) {
- $fieldsvar = search_fieldsvar($smessage);
- } else if ($_GET['fields'] == 2) {
- $fieldsvar = search_fieldsvar($ssubject, $smessage);
- } else {
- $fieldsvar = "";
- }
- if ($fieldsvar) {
- $result = dbquery(
- "SELECT td.*,tdc.* FROM ".DB_MARKETPLACE." td
- INNER JOIN ".DB_MARKETPLACE." tdc ON td.marketplace=tdc.mplace_message
- ".($_GET['datelimit'] != 0 ? " AND mplace_datestamp>=".(time() - $_GET['datelimit']):"")
- );
- $rows = dbrows($result);
- } else {
- $rows = 0;
- }
- if ($rows != 0) {
- $items_count .= THEME_BULLET." <a href='".FUSION_SELF."?stype=marketplace&stext=".$_GET['stext']."&".$composevars."'>".$rows." ".($rows == 1 ? $locale['d401'] : $locale['d402'])." ".$locale['522']."</a><br />\n";
- $result = dbquery(
- "SELECT td.*,tdc.* FROM ".DB_MARKETPLACE." td
- INNER JOIN ".DB_MARKETPLACE." tdc ON td.marketplace=tdc.mplace_massage
- ".($_GET['datelimit'] != 0 ? " AND mplace_datestamp>=".(time() - $_GET['datelimit']):"")."
- ORDER BY ".$sortby." ".($_GET['order'] == 1 ? "ASC" : "DESC").($_GET['stype'] != "all" ? " LIMIT ".$_GET['rowstart'].",10" : "")
- );
- while ($data = dbarray($result)) {
- $search_result = "";
- if ($data['mplace_datestamp']+604800 > time()+($settings['timeoffset']*3600)) {
- $new = " <span class='small'>".$locale['d403']."</span>";
- } else {
- $new = "";
- }
- $text_all = $data['mplace_message'];
- $text_all = search_striphtmlbbcodes($text_all);
- $text_frag = search_textfrag($text_all);
- $subj_c = search_stringscount($data['mplace_article']);
- $text_c = search_stringscount($data['mplace_message']);
- $text_frag = highlight_words($swords, $text_frag);
- $search_result .= "<a href='marketplace.php?mplace_id=".$data['marketplace']."&mplace_id=".$data['mpalce_id']."' target='_blank'>".highlight_words($swords, $data['mplace_article'])."</a> - ".$data['download_price']." $new"."<br /><br />\n";
- if ($text_frag != "") $search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>".$text_frag."</div><br />";
- $search_result .= "<span class='small'><span class='alt'>".$locale['d404']."</span> ".$data['mplace_price']." |\n";
- $search_result .= "<span class='alt'>".$locale['d405']."</span> ".$data['mplace_price']." |\n";
- $search_result .= "<span class='alt'>".$locale['d406']."</span> ".$data['mplace_price']."<br />\n";
- $search_result .= "<span class='alt'>".$locale['d407']."</span> ".showdate("%d.%m.%y", $data['mplace_datestamp'])." |\n";
- $search_result .= "<span class='alt'>".$locale['d408']."</span> ".$data['mplace_sold']."</span><br /><br />\n";
- search_globalarray($search_result);
- }
- } else {
- $items_count .= THEME_BULLET." 0 ".$locale['d402']." ".$locale['522']."<br />\n";
- }
- $navigation_result = search_navigation($rows);
- }
- ?>
und der
- <?php
- /*-------------------------------------------------------+
- | PHP-Fusion Content Management System
- | Copyright (C) 2002 - 2008 Nick Jones
- | http://www.php-fusion.co.uk/
- +--------------------------------------------------------+
- | Filename: search_marketplace_include_button.php
- | Author: Robert Gaudyn (Wooya)
- +--------------------------------------------------------+
- | This program is released as free software under the
- | Affero GPL license. You can redistribute it and/or
- | modify it under the terms of this license which you
- | can read by viewing the included agpl.txt or online
- | at www.gnu.org/licenses/agpl.html. Removal of this
- | copyright header is strictly prohibited without
- | written permission from the original author(s).
- +--------------------------------------------------------*/
- if (!defined("IN_FUSION")) { die("Access Denied"); }
- include LOCALE.LOCALESET."search/mplace.php";
- $form_elements['marketplace']['enabled'] = array("datelimit", "fields1", "fields2", "fields3", "sort", "order1", "order2", "chars");
- $form_elements['marketplace']['disabled'] = array();
- $form_elements['marketplace']['display'] = array();
- $form_elements['marketplace']['nodisplay'] = array();
- $radio_button['marketplace'] = "<label><input type='radio' name='stype' value='marketplace'".($_GET['stype'] == "marketplace" ? " checked='checked'" : "")." onclick=\"display(this.value)\" /> ".$locale['d400']."</label>";
- ?>
wenn ich nun einen such begriff eingebe bekomm ich die fehler meldung
Unknown column 'td.marketplace' in 'on clause'
so nun hab ich schon gelesen das die datenbank angabe nicht stimmt aber ich weiss auch absolut nicht wie das ganze aussehen muss
hoffe es kann mir jemand helfen
gruss christian