vkp55_fsz_maax_update

Begonnen von , 15 April 2002, 11:20:12

⏪ vorheriges - nächstes ⏩

0 Mitglieder und 2 Gäste betrachten dieses Thema.

Drucken
Nach unten Seiten1
Benutzer-Aktionen

15 April 2002, 11:20:12
So hallo zusammen<br>
Ich habe heute das Update von Euch eingespielt .<br>
Leider habe ich jetzt das Problem mit der <b>sql_layer.php</b><br>
Es wir der fehler wie volgt ausgegeben
<b>Warning: Supplied argument is not a valid MySQL result resource in /www/htdocs/werkscom/kreativ/includes/sql_layer.php on line 283</b>
<p>
Ich kann leider damit gar nichts anfangen!
Danke Gruenschnabel

Kicks

#1
15 April 2002, 11:45:24

Andi

#2
15 April 2002, 13:13:45
Hi Gruenschnabel  :) :)
bist Du sicher, dass Du auch die dem Pack beiliegenden SQL-Dateien komplett in Deine Datenbank eingespielt hast :quest ;)
Die sql_layer Fehler kommen normalerweise von fehlenden Tabellen / Tabellenfeldern :D

Hast Du eine bestehende Version unseres VKP5.5 geupd. oder eine andere Version?

[Bearbeitet am: 15.4.2002 von Andi]
schön´s Grüssle, Andi

#3
15 April 2002, 18:48:04
Erst einmal Danke für die Prompte Antwort.:D
Ich verwende also VKP5.5 und habe mir das Update Pack Normal runtergeladen und neu eingespielt.
Der Fehler tritt nur auf wenn ich auf die Startseite gehe (index,php) :quest
Die ganzen anderen Links funktionieren!
Ich bin gespannt an was das liegen könnte.
Viele Grüße Gruenschnabel

DarkBoy

#4
16 April 2002, 01:50:01
Hi
gib mal nen LINK bitte.   und überprüfe anhand er isntall  ob du alles richtig gemacht  hast

Gruenschnabel

#5
16 April 2002, 07:34:50
Hy
Hier ist der gewünschte Link http://www.werkstatt-kreativ.com/kreativ/index.php
Gruß Gruenschnabel

FrankySZ

#6
16 April 2002, 11:30:29
Hi Gruenschnabel,

so wie es aussieht hast du ja eines unser beigefuegten Grundthemes farblich angepasst, und der Fehler tritt nur auf wenn man auf die Hauptsite geht...sonst ist der sofort weg.
Kann es sein dass du noch den Aufruf bzw. Reste davon fuer die Quicklinks (Home, Benutzerdaten,...) in deiner Theme.php stehen hast, die etwas nicht korrekt aufrufen koennen?
greets Franky

Gruenschnabel

#7
16 April 2002, 18:46:47
Hy FrankySZ
Erst mal Danke für Deinen Besuch auf unserer Seite.
Die Seite steht eigentlich schon seit März diesen Jahres es gab auch noch nie diesen Fehler. :o
Die Navigation steht in einem neuen Block! Denn wir erstellt haben.
Das ist aber auch schon 15 Tage her(ohne Fehlermeldung).

Ich kann jetzt nur noch Code von der theme.php reinsetzen.
Der sieht wie folgt aus
---------------------------------------------
$bgcolor1 = "#CC9999";
$bgcolor2 = "#FFCC66";
$bgcolor3 = "#eeeeef";
$bgcolor4 = "#eeeeee";
$bgcolor5 = "#FFCC99";
$textcolor1 = "#000000";
$textcolor2 = "#000000";

function OpenTable() {
    global $bgcolor1, $bgcolor2;
    echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"0\" bgcolor=\"$bgcolor2\"><tr><td>\n";
    echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"8\" bgcolor=\"$bgcolor1\"><tr><td>\n";
}

function CloseTable() {
    echo "</td></tr></table></td></tr></table>\n";
}

function OpenTable2() {
    global $bgcolor1, $bgcolor2;
    echo "<table border=\"0\" cellspacing=\"1\" cellpadding=\"0\" bgcolor=\"$bgcolor2\" align=\"center\"><tr><td>\n";
    echo "<table border=\"0\" cellspacing=\"1\" cellpadding=\"8\" bgcolor=\"$bgcolor1\"><tr><td>\n";
}

function CloseTable2() {
    echo "</td></tr></table></td></tr></table>\n";
}

function FormatStory($thetext, $notes, $aid, $informant) {
    global $anonymous;
    if ($notes != "") {
   $notes = "<br><b>"._NOTE."</b> <i>$notes</i>\n";
    } else {
   $notes = "";
    }
    if ("$aid" == "$informant") {
   echo "<font size=\"2\" color=\"#505050\">$thetext<br>$notes</font>\n";
    } else {
   if($informant != "") {
       $boxstuff = "<a href=\"modules.php?name=Your_Account\">$informant</a> ";
   } else {
       $boxstuff = "$anonymous ";
   }
   $boxstuff .= ""._WRITES." \"$thetext\" $notes\n";
   echo "<font size=\"2\" color=\"#505050\">$boxstuff</font>\n";
    }
}

/************************************************************/
/* Function themeheader()                                   */
/*                                                          */
/* Control the header for your site. You need to define the */
/* BODY tag and in some part of the code call the blocks    */
/* function for left side with: blocks(left);               */
/************************************************************/

function themeheader() {
    global $user, $banners, $sitename, $slogan, $cookie, $admin, $fszcounter, $prefix, $dbi;
    cookiedecode($user);
    $username = $cookie[1];
    if ($username == "") {
        $username = "Anonymous";
    }
    echo "<body bgcolor=\"#CCCCCC\" text=\"#000000\" link=\"#363636\" vlink=\"#363636\" alink=\"#d5ae83\">\n"
   ."<br>\n";
    echo "<table cellpadding=\"0\" cellspacing=\"1\" width=\"97%\" border=\"0\" align=\"center\" bgcolor=\"#000000\">\n"
    ."<tr>\n"
    ."<td background=\"themes/wk_aktuel/images/titleBar.gif\">  \n"
    ."</td>\n"
    ."</tr>\n"
    ."</table>\n"
    ."<table cellpadding=\"0\" cellspacing=\"0\" width=\"97%\" border=\"0\" align=\"center\" bgcolor=\"#eeeeef\">\n"
   ."<tr>\n"
   ."<td bgcolor=\"#CACACA\" width=\"200\" align=\"left\" valign=\"middle\">\n"
   ."<a href=\"index.php\"><img src=\"themes/wk_aktuel/images/logo.gif\" align=\"left\" alt=\""._WELCOMETO." $sitename\" border=\"0\"></a></td>\n"

   ."<td bgcolor=\"#CACACA\" width=\"320\" align=\"right\">\n"
   ."$fszcounter"
   ."<td>\n"

   ."<td bgcolor=\"#CACACA\" align=\"right\">\n"
   ."<table>\n"
   ."<tr>\n"
   ."<td>\n"

   ."<form action=\"modules.php?name=Search\" method=\"post\"><font size=\"2\" color=\"#000000\"><b>"._SEARCH." </b>\n"
   ."<input type=\"text\" name=\"query\" size=\"14\"></font></form></td>\n"
   ."<td bgcolor=\"#CACACA\" align=\"right\">\n"
   ."<form action=\"modules.php?name=Search\" method=\"get\"><font size=\"2\"><b>"._TOPICS." </b>\n";
    $toplist = sql_query("select topicid, topictext from $prefix"._topics." order by topictext", $dbi);
    echo "<select name=\"topic\"onChange='submit()'>\n"
   ."<option value=\"\">"._ALLTOPICS."</option>\n";
    while(list($topicid, $topics) = sql_fetch_row($toplist, $dbi)) {
    if ($topicid==$topic) { $sel = "selected "; }
   echo "<option $sel value=\"$topicid\">$topics</option>\n";
   $sel = "";
    }
    echo "</select></font></form></td></tr></table></td>\n"
   ."<td bgcolor=\"#CACACA\" valign=\"top\"> </td>\n"
   ."</tr></table>\n"
   ."<table cellpadding=\"0\" cellspacing=\"0\" width=\"97%\" border=\"0\" align=\"center\" bgcolor=\"#fefefe\">\n"
   ."<tr>\n"
   ."<td bgcolor=\"#000000\" colspan=\"4\"><IMG src=\"themes/wk_aktuel/images/pixel.gif\" width=\"1\" height=1 alt=\"\" border=\"0\" hspace=\"0\"></td>\n"
   ."</tr>\n"
   ."<tr valign=\"middle\" bgcolor=\"#eeeeef\">\n"
   ."<td width=\"15%\" nowrap><font size=\"2\" color=\"#363636\"><b>\n";
    if ($username == "Anonymous") {
   echo "  <b><font size=2><b>"._HELLO." </b> [ <a href=\"modules.php?name=Your_Account\">"._NEWUSER."</a> ]</font>\n";
    } else {
   echo "  <font size=2><b>"._HELLO." <a href=\"modules.php?name=Your_Account\">$cookie[1]</a> [ <a href=\"modules.php?name=Your_Account&op=logout\">"._LOGOUT."</a> ]</b></font>";
    }
    echo "</b></font></td>\n"
   ."<td align=\"center\" height=\"20\" width=\"71%\"><font size=\"2\"><B>\n"
       #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <A href=\"/\">Home</a>\n"
        #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <A href=\"modules.php?name=Your_Account\">"._YACCOUNT."</a>\n"
        #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <a href=\"modules.php?op=modload&name=Guestbook&file=index\">"._GUESTBOOK."</a>\n"
        #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <A href=\"ccenter.php\">ComCenter</a>\n"
        #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <A href=\"icenter.php\">InfoCenter</a>\n"
        #."<img src=\"themes/wk_aktuel/images/arrow.gif\" border=0> <a href=\"Webmaster\">"._WEBMASTERT."</a>\n"
        ."</B></font>\n"
        ."</td>\n"
        ."<td align=\"right\" width=\"15%\"><font size=\"2\"><b>\n"
        ."<script type=\"text/javascript\">\n\n"
        ."<!--   // Array ofmonth Names\n"
        ."var monthNames = new Array( \""._JANUARY."\",\""._FEBRUARY."\",\""._MARCH."\",\""._APRIL."\",\""._MAY."\",\""._JUNE."\",\""._JULY."\",\""._AUGUST."\",\""._SEPTEMBER."\",\""._OCTOBER."\",\""._NOVEMBER."\",\""._DECEMBER."\");\n"
        ."var now = new Date();\n"
        ."thisYear = now.getYear();\n"
        ."if(thisYear < 1900) {thisYear += 1900}; // corrections if Y2K display problem\n"
        ."document.write(monthNames[now.getMonth()] + \" \" + now.getDate() + \", \" + thisYear);\n"
        ."// -->\n\n"
        ."</script></b></font></td>\n"
        ."<td> </td>\n"
        ."</tr>\n"
        ."<tr>\n";
   if (is_admin($admin)) {        
        echo "<td align=\"center\" bgcolor=\"#CACACA\" colspan=\"4\"><br><a href=\"admin.php\">Administration</a>\n";
           $res=sql_query("select * from $prefix"._queue."", $dbi);
           $num = sql_num_rows($res, $dbi);
           echo " | <a href=\"admin.php?op=submissions\">Neue News: $num</a>\n";
           $res=sql_query("select * from $prefix"._links_newlink."", $dbi);
           $num = sql_num_rows($res, $dbi);
           echo " | <a href=\"admin.php?op=Links\">Neue Links: $num</a>\n";
           $res=sql_query("select * from $prefix"._downloads_newdownload."", $dbi);
           $num = sql_num_rows($res, $dbi);
           echo " | <a href=\"admin.php?op=downloads\">Neue Downloads: $num</a>\n";
           $res=sql_query("select * from $prefix"._gallery_pictures_newpicture."", $dbi);
           $num = sql_num_rows($res, $dbi);
           echo " | <a href=\"admin.php?op=GallAdmin\">Neue Bilder: $num</a>\n";
           $res=sql_query("select * from $prefix"._events_queue."", $dbi);
           $num = sql_num_rows($res, $dbi);
           echo " | <a href=\"admin.php?op=CalendarAdmin\">Neue Termine: $num</a>\n";
           echo " | <a href=\"admin.php?op=messages\">AdminMessage</a>\n";
           echo " | <a href=\"admin.php?op=Configure\">Einstellungen</a>\n";
           echo " | <a href=\"admin.php?op=logout\">Logout</a>\n\n";
           echo "</font></td>";
       } else {
       echo "";
    }

   echo "<tr>\n"
        ."<td bgcolor=\"#000000\" colspan=\"4\"><IMG src=\"themes/wk_aktuel/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td>\n"
        ."</tr>\n"
        ."</table>\n"
   ."<!-- FIN DEL TITULO -->\n"
   ."<table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\"><tr valign=\"top\">\n"
   ."<td><img src=\"themes/wk_aktuel/images/pixel.gif\" width=\"1\" height=\"20\" border=\"0\" alt=\"\"></td></tr></table>\n"
   ."<table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\"><tr valign=\"top\">\n"
   ."<td><img src=\"themes/wk_aktuel/images/pixel.gif\" width=\"10\" height=\"1\" border=\"0\" alt=\"\"></td>\n"
   ."<td width=\"150\" valign=\"top\">\n";
    blocks(left);
    echo "</td><td><img src=\"themes/wk_aktuel/images/pixel.gif\" width=\"15\" height=\"1\" border=\"0\" alt=\"\"></td><td width=\"100%\">\n";
         include ("themes/wk_aktuel/cblock.php");
}

/************************************************************/
/* Function themefooter()                                   */
/*                                                          */
/* Control the footer for your site. You don't need to      */
/* close BODY and HTML tags at the end. In some part call   */
/* the function for right blocks with: blocks(right);       */
/* Also, $index variable need to be global and is used to   */
/* determine if the page your're viewing is the Homepage or */
/* and internal one.                                        */
/************************************************************/

function themefooter() {
    global $index;
    if ($index == 1) {
   echo "</td><td><img src=\"themes/wk_aktuel/images/pixel.gif\" width=\"15\" height=\"1\" border=\"0\" alt=\"\"></td><td valign=\"top\" width=\"150\">\n";
   blocks(right);
    }
    echo "</td><td><img src=\"themes/wk_aktuel/images/pixel.gif\" width=10 height=1 border=0 alt=\"\">\n"
   ."</td></tr></table>\n"
        ."<table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\"><tr valign=\"top\">\n"
        ."<td height=\"17\"> </td>\n"
        ."</tr></table>\n"
        ."<br>"
        ."<table width=\"99%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" bgcolor=\"#CACACA\" align=\"center\"><tr valign=\"top\">\n"
        ."</tr><tr align=\"center\">\n"
        ."<td width=\"100%\" colspan=\"3\">\n"
         ."<table cellpadding=\"0\" cellspacing=\"1\" width=\"99%\" border=\"0\" align=\"center\" bgcolor=\"#000000\">\n"
    ."<tr>\n"
    ."<td background=\"themes/wk_aktuel/images/titleBar.gif\">  \n"
    ."</td>\n"
    ."</tr>\n"
    ."</table>\n";
global $prefix, $bannersfsz, $index;
   if ($bannersfsz) {
   include("bannersfsz.php");
    }
         include ("themes/wk_aktuel/disc.php");
    footmsg();
    echo "</td>\n"
        ."</tr>\n"
        ."</table>\n";
       
}

/************************************************************/
/* Function themeheader()                                   */
/*                                                          */
/* Control the header for your site. You need to define the */
/* BODY tag and in some part of the code call the blocks    */
/* function for left side with: blocks(left);               */
/************************************************************/

function themeindex ($aid, $informant, $time, $title, $counter, $topic, $thetext, $notes, $morelink, $topicname, $topicimage, $topictext) {
    global $anonymous, $tipath;
    echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"1\" width=\"100%\" bgcolor=\"#000000\">\n"
    ."<tr>\n"
    ."<td background=\"themes/wk_aktuel/images/titleBar.gif\">  \n"
    ."</td>\n"
    ."</tr>\n"
    ."</table>\n"
    ."<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\">\n"
    ."<tr>\n"
    ."<td>\n"
   ."<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#000000\" width=\"100%\"><tr>\n"
   ."<td bgcolor=\"#CACACA\" align=\"left\">\n"
   ."<font size=\"3\" color=\"#363636\"><b>$title</b></font>\n"
   ."<br><font color=\"#999999\" size=\"1\">"._POSTEDBY." ";
    formatAidHeader($aid);
    echo " "._ON." $time $timezone ($counter "._READS.")</font>\n"
    ."<br><b>"._TOPIC."</b> <font size=\"1\" color=\"#ff0000\"><b>$topictext</b></font>\n"
   ."</td></tr>\n"
   ."<tr><td bgcolor=\"#eeeeef\">\n"
   ."<font color=\"#999999\"><b><img src=\"$tipath$topicimage\" border=\"0\" Alt=\"$topictext\" align=\"right\" hspace=\"10\" vspace=\"10\"></a></B></font>\n";
    FormatStory($thetext, $notes, $aid, $informant);
    echo "</td></tr>\n"
    ."<tr><td bgcolor=\"#eeeeef\" align=\"right\">\n"
   ."<font size=\"2\">$morelink</font>\n"
   ."</td></tr></table></td></tr></table>\n"
   ."<br>\n\n\n";
}

/************************************************************/
/* Function themeheader()                                   */
/*                                                          */
/* Control the header for your site. You need to define the */
/* BODY tag and in some part of the code call the blocks    */
/* function for left side with: blocks(left);               */
/************************************************************/

function themearticle ($aid, $informant, $datetime, $title, $thetext, $topic, $topicname, $topicimage, $topictext) {
    global $admin, $sid, $tipath;
    echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"5\" bgcolor=\"#eeeeef\" width=\"100%\"><tr><td>\n"
        ."<table border=\"0\" cellpadding=\"1\" cellspacing=\"0\" bgcolor=\"#000000\" width=\"100%\"><tr><td>\n"
        ."<table border=\"0\" cellpadding=\"3\" cellspacing=\"0\" bgcolor=\"#CACACA\" width=\"100%\"><tr><td align=\"left\">\n"
        ."<font size=\"3\" color=\"#363636\"><b>$title</b></font><br>\n"
        .""._POSTEDON." $datetime "._BY." ";
    formatAidHeader($aid);
    if (is_admin($admin)) {
   echo "<br>[ <a href=\"admin.php?op=EditStory&sid=$sid\">"._EDIT."</a> | <a href=\"admin.php?op=RemoveStory&sid=$sid\">"._DELETE."</a> ]\n";
    }
    echo "</td></tr></table></td></tr></table><br>";
    echo "<a href=\"modules.php?name=Search?query=&topic=$topic\"><img src=\"$tipath$topicimage\" border=\"0\" Alt=\"$topictext\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>\n";
    FormatStory($thetext, $notes="", $aid, $informant);
    echo "</td></tr></table><br>\n\n\n";
}

/************************************************************/
/* Function themeheader()                                   */
/*                                                          */
/* Control the header for your site. You need to define the */
/* BODY tag and in some part of the code call the blocks    */
/* function for left side with: blocks(left);               */
/************************************************************/

function themesidebox($title, $content) {
    echo "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#eeeeee\" width=\"150\"><tr><td>\n"
    ."<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"150\">\n"
    ."<tr>\n"
    ."<td><img src=\"themes/wk_aktuel/images/sideBoxTop.gif\"></td>\n"
    ."</tr>\n"
    ."</table>\n"

   ."<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"#000000\" width=\"100%\">\n"
   ."<tr><td bgcolor=\"#CACACA\" align=\"center\">\n"
   ."<font size=\"2\" color=\"#363636\"><b>$title</b></font>\n"
   ."</td></tr>\n"
   ."<tr>\n"
   ."<td bgcolor=\"#eeeeee\">$content</td>\n"
   ."</tr>\n"
   ."</table></td></tr></table>\n"
   ."<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"150\">\n"
   ."<tr>\n"
   ."<td><img src=\"themes/wk_aktuel/images/sideBoxBottom.gif\"></td>\n"
   ."</tr>\n"
    ."</table>\n"
   ."<br>\n\n\n";
}

?>
---------------------------------------------
Ich hoffe Du kannst damit was Anfangen!?:quest
Also bis denn
Gruenschnabel

Gruenschnabel

#8
16 April 2002, 20:05:12
Hy jetzt bin ich's schon wieder der Gruenschnabel im wahrsten sinne des Wortes.
Ich habe die SQL noch mal eingespielt
(vom Update)
Und siehe da es ist alles super.
Ich möchte mich aber Trotzdem nochmal bei allen bedanken die sich den Kopf zerbrochen haben!
Also bis den schöne Grüße aus Bayern
Gruenschnabel
Drucken
Nach oben Seiten1
Benutzer-Aktionen