Skocz do zawartości
"Idzie nowe..." - o zmianach i nie tylko ×
Przeniesienie zakupów z IPS Marketplace / Moving bought items from IPS Marketplace ×

Rekomendowane odpowiedzi

Opublikowano (edytowane)

witam,

posiadam strone www (l2int.eu) na której mam opcje podpiecia forum ipb by na stronie głównej pojawiały się ostatnie tematy zamieszczone na forum, problem w tym, że jest jakiś błąd bo nic się nie pojawia (dodam, że jeśli podpinam pod phpbb, smf to działa bez problemu). siedziałem dzisiaj pół dnia i chyba sam nic nie wymodzę dlatego proszę o pomoc. Na dole zamieszam kod, który odpowiada za połączenie

<?php
/**
* STRESS WEB
* @author S.T.R.E.S.S.
* @copyright 2008 - 2011 STRESS WEB
* @version 11
* @web http://stressweb.ru
*/
if (!defined("STRESSWEB"))
die("Access denied...");
if ($l2cfg["forum"]["enable"])
{
if (empty($l2cfg["forum"]["deny"]))
$l2cfg["forum"]["deny"] = "0";
$name_length = $l2cfg["forum"]["length"];
$fdb = new DBconnect($l2cfg["forum"]["dbhost"], $l2cfg["forum"]["dbuser"], $l2cfg["forum"]["dbpass"], $l2cfg["forum"]["dbname"], $debug);
$fdb->Query("SET NAMES '{$l2cfg["forum"]["dbcoll"]}'");
/**
* =================
* IPB
* =================
*/
if ($l2cfg["forum"]["version"] == "ipb")
{
$fsql = "
SELECT tid,title,description,last_post,last_poster_id,last_poster_name
FROM {$l2cfg["forum"]["prefix"]}topics WHERE forum_id NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY last_post DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "index.php?showuser=";
$furl_link = "index.php?showtopic={topic_id}' title='{desc_id}'";
}
/**
* =================
* phpBB
* =================
*/
if ($l2cfg["forum"]["version"] == "phpbb")
{
$fsql = "
SELECT topic_id,topic_title,forum_id,topic_last_post_time,topic_last_poster_id,topic_last_poster_name
FROM {$l2cfg["forum"]["prefix"]}topics WHERE forum_id NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY topic_last_post_time DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "memberlist.php?mode=viewprofile&u=";
$furl_link = "viewtopic.php?f={desc_id}&t={topic_id}'";
}
/**
* =================
* smf
* =================
*/

if ($l2cfg["forum"]["version"] == "smf")
{
$fsql = "
SELECT id_topic,subject,id_board,poster_time,id_member,poster_name
FROM {$l2cfg["forum"]["prefix"]}messages WHERE id_board NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY poster_time DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "index.php?action=profile;u=";
$furl_link = "index.php?topic={topic_id}'";
}
/**
* =================
* vBulletin
* =================
*/
if ($l2cfg["forum"]["version"] == "vbulletin")
{
$fsql = "
SELECT thread.threadid,thread.title,thread.forumid,thread.lastpost,user.userid,thread.lastposter
FROM {$l2cfg["forum"]["prefix"]}thread
LEFT JOIN `user` ON thread.lastposter = user.username
WHERE thread.forumid NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY thread.lastpost DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "member.php?u=";
$furl_link = "showthread.php?t={topic_id}'";
}
/**
* ----------------------------------------------------------------------------------------
*/

$fquery = $fdb->Query($fsql);
while (list($ftid, $ftitle, $fdesc_id, $flast_post, $flast_poster_id, $flast_poster_name) = $fdb->FetchArray($fquery))
{
if (strlen($ftitle) > $name_length)
{
$ftitle=iconv('UTF-8','windows-1251',$ftitle);
$ftitle = substr($ftitle, 0, $name_length - 3) . "...";
$ftitle=iconv('windows-1251','UTF-8',$ftitle);
}
$flast_post = date($l2cfg["forum"]["date"], $flast_post);
$flast_poster = "<a href='{$l2cfg["forum"]["url"]}/{$furl_user}{$flast_poster_id}' target='_blank'>{$flast_poster_name}</a>";
$flast_link = "<a href='{$l2cfg["forum"]["url"]}/" . $user->ParseString($furl_link, array("topic_id" => $ftid, "desc_id" => $fdesc_id)) . " target='_blank'>{$ftitle}</a>";

$tpl->GetTemplate('forum_themes_item.tpl');
$tpl->SetVar("{THEME}", TPL_DIR);
$tpl->SetVar("{date}", $flast_post);
$tpl->SetVar("{author}", $flast_poster);
$tpl->SetVar("{link}", $flast_link);
$tpl->parse("forum_themes_item");
}
$fdb->Close();
$forum_themes_item = $tpl->result["forum_themes_item"];
$tpl->clear();

$tpl->GetTemplate('forum_themes.tpl');
$tpl->SetVar("{THEME}", TPL_DIR);
$tpl->SetVar('{item}', $forum_themes_item);
$tpl->parse("forum");
$tpl->clear();
}
else
{
$tpl->result["forum"] = "";
}
?>

a tutaj jest ten sam najnowszy skrypt strony do ktorego nie mam dostepu aczkolwiek on działa prawidłowo - próbowałem zmienic na ten nowy ale wtedy strona sypie błędami


<?php
/**
* STRESS WEB
* @author S.T.R.E.S.S.
* @copyright 2008 - 2012 STRESS WEB
* @version 13
* @web http://stressweb.ru
*/
if ( !defined("STRESSWEB") )
die( "Access denied..." );

if ( !$l2cfg["forum"]["enable"] ) {
$tpl->SetResult( 'forum' );
} else {

$mod_forum = $controller->GetCache( 'mod_forum' );

if ( $mod_forum )
$tpl->SetResult( 'forum', $mod_forum );
else {

if ( empty($l2cfg["forum"]["deny"]) )
$l2cfg["forum"]["deny"] = "0";

$fdb = new db( $l2cfg["forum"]["dbhost"], $l2cfg["forum"]["dbuser"], $l2cfg["forum"]["dbpass"], $l2cfg["forum"]["dbname"], $l2cfg["mysql"]["debug"] );
$fdb->query( "SET NAMES '{$l2cfg["forum"]["dbcoll"]}'" );
/**
* =================
* IPB
* =================
*/
if ( $l2cfg["forum"]["version"] == "ipb" ) {
$fsql = "
SELECT tid,title,description,last_post,last_poster_id,last_poster_name
FROM {$l2cfg["forum"]["prefix"]}topics
WHERE forum_id NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY last_post DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "index.php?showuser=";
$furl_link = "index.php?showtopic={topic_id}' title='{desc_id}'";
}
/**
* =================
* phpBB
* =================
*/
if ( $l2cfg["forum"]["version"] == "phpbb" ) {
$fsql = "
SELECT topic_id,topic_title,forum_id,topic_last_post_time,topic_last_poster_id,topic_last_poster_name
FROM {$l2cfg["forum"]["prefix"]}topics
WHERE forum_id NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY topic_last_post_time DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "memberlist.php?mode=viewprofile&u=";
$furl_link = "viewtopic.php?f={desc_id}&t={topic_id}'";
}
/**
* =================
* smf
* =================
*/

if ( $l2cfg["forum"]["version"] == "smf" ) {
$fsql = "
SELECT id_topic,subject,id_board,poster_time,id_member,poster_name
FROM {$l2cfg["forum"]["prefix"]}messages
WHERE id_board NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY poster_time DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "index.php?action=profile;u=";
$furl_link = "index.php?topic={topic_id}'";
}
/**
* =================
* vBulletin
* =================
*/
if ( $l2cfg["forum"]["version"] == "vbulletin" ) {
$fsql = "
SELECT t.threadid,t.title,t.forumid,t.lastpost,u.userid,t.lastposter
FROM {$l2cfg["forum"]["prefix"]}thread t
LEFT JOIN {$l2cfg["forum"]["prefix"]}user u ON t.lastposter = u.username
WHERE t.forumid NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY t.lastpost DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "member.php?u=";
$furl_link = "showthread.php?t={topic_id}'";
}
/**
* =================
* XenFoRo
* © thx Ream
* =================
*/
if ( $l2cfg["forum"]["version"] == "xenforo" ) {
$fsql = "
SELECT thread_id,title,node_id,last_post_date,user_id,last_post_username
FROM {$l2cfg["forum"]["prefix"]}thread
WHERE node_id NOT IN ({$l2cfg["forum"]["deny"]})
ORDER BY last_post_date DESC
LIMIT {$l2cfg["forum"]["count"]}";
$furl_user = "members/";
$furl_link = "threads/{topic_id}'";
}
/**
* ----------------------------------------------------------------------------------------
*/

$fquery = $fdb->query( $fsql );
while ( list($ftid, $ftitle, $fdesc_id, $flast_post, $flast_poster_id, $flast_poster_name) = $fdb->fetch($fquery) ) {
if ( strlen($ftitle) > $l2cfg["forum"]["length"] ) {
$ftitle = iconv( 'UTF-8', 'windows-1251', $ftitle );
$ftitle = substr( $ftitle, 0, $l2cfg["forum"]["length"] - 3 )."...";
$ftitle = iconv( 'windows-1251', 'UTF-8', $ftitle );
}
$flast_post = date( $l2cfg["forum"]["date"], $flast_post );
$flast_poster = "<a href='{$l2cfg["forum"]["url"]}/{$furl_user}{$flast_poster_id}' target='_blank'>{$flast_poster_name}</a>";
$flast_link = "<a href='{$l2cfg["forum"]["url"]}/".$controller->buildString( $furl_link, array("topic_id" => $ftid, "desc_id" => $fdesc_id) )." target='_blank'>{$ftitle}</a>";

$tpl->LoadView( 'forum' );
$tpl->Block( 'main', false );
$tpl->Block( 'item' );
$tpl->Set( 'date', $flast_post );
$tpl->Set( 'author', $flast_poster );
$tpl->Set( 'link', $flast_link );
$tpl->Build( 'forum_item' );
}
$fdb->close();

$tpl->LoadView( 'forum' );
$tpl->Block( 'main' );
$tpl->Block( 'item', false );
$tpl->Set( 'item', $tpl->GetResult('forum_item', true) );
$tpl->Build( "forum" );

if ( $l2cfg['cache']['enable'] and $l2cfg['cache']['forum'] ) {
$controller->SetCache( 'mod_forum', $tpl->GetResult('forum'), $l2cfg['cache']['forum'] );
}
}
}
?>

Edytowane przez ProHax0r
Opublikowano

Mam błąd:

Unkown columm 'description' in field list


SELECT tid,title,description,last_post,last_poster_id,last_poster_name 
FROM ibf_topics 
WHERE forum_id NOT IN (0) 
ORDER BY last_post DESC 
LIMIT 5

Proszę o pomoc.

  • Manager
Opublikowano

Problem ROZWIĄZANY. Jeśli są jakiekolwiek wątpliwości, pytania proszę o wysłanie wiadomości do jednego z członków ekipy zarządzającej.

Wszelkie uzasadnione reklamacje/pretensje/sugestie/rady przyjmuje ekipa forum.

  • Lubię to 1

intermedia - profesjonalne rozwiązania Invision Power Board

---

Chcesz uzyskać szybko i sprawnie pomoc? Uzupełnij wersję i adres w profilu.

Gość
Ten temat został zamknięty. Brak możliwości dodania odpowiedzi.
  • Ostatnio przeglądający   0 użytkowników

    • Brak zarejestrowanych użytkowników przeglądających tę stronę.
×
×
  • Dodaj nową pozycję...

Powiadomienie o plikach cookie

Umieściliśmy na Twoim urządzeniu pliki cookie, aby pomóc Ci usprawnić przeglądanie strony. Możesz dostosować ustawienia plików cookie, w przeciwnym wypadku zakładamy, że wyrażasz na to zgodę.