ProHax0r

Jesteś wielki! Dzięki wielkie! Do zamknięcia.

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.

nic nie ma

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'] ); } } } ?>

tak, bo sa to standardowe mody. innych nie instalowalem.

tak, jest 5 plików.

włączylem i wyłączylem kilkukrotnie nadal bez zmian.

Poprzesuwalem i nadal nic - pokazuja sie tylko 2. w ustawieniach nie ma nic co moglo by wskazywac na pokazywanie/ukrywanie.

http://forum.l2int.eu pkazuja sie tylko popularne tagi i aktualizacje statusu (ktore wlaczylem ostatnio) pozostalem mody sa wlaczone ale sie nie pokazuja.

witam, włączyłem wszystkie sidebary, ale i tak nie widać ich na stronie głównej.

mi nie chodzi o pin w tym przypadku haslo,bo je znam tylko o adres email..

chodzi o to czy mają obowiazek mi przypominac takie rzeczy?

witam, mam dosc nietypowy problem a mianowicie zapomnialem email i hasło do client area - mam jednak forum z kluczem licencyjnym tego konta - czy istnieje jakaś szansa aby IPS przypomnialo mi mojego maila?

ok dzięki, wszystko ok.

a co z tymi plikami w których zapisane są dane do mysql? bo raczej jeśli nadpiszę wszystkie pliki to będe miał błąd "brak połączenia z bazą" na stronie.