MySQLi Help

[Blasteh]

Hi,
I posted in the Habbo section, but I feel this is a more appropriate section to go for support in regards to coding. So I'm using a CMS that is coded in MySQLi (knock-off of RevCMS) and I've been having some issues.


The news isn't reading correctly for some reason, as you can see:

But, it is in the database table (cms_news), and reads right, except for the URL which I'm guessing is due to web.config.

Fixed the news preview, just need them to show on /me


The class for news/forms:

        final public function getPageNews()            {                global $template, $engine;                           if(!isset($_GET['id']) || !is_numeric($_GET['id']))                    {                        $_GET['id'] = 1;                    }                        $result = dbquery("SELECT title, id FROM cms_news WHERE id != '" . $engine->secure($_GET['id']) . "' ORDER BY id DESC");                                       while($news1 = mysqli_fetch_array($result))                        {                            $template->setParams('newsList', '« <a href="index.php?url=news&id='.$news1["id"].'">' . $news1['title'] . '</a><br/>');                        }                                       $news = $engine->fetch_assoc("SELECT title, longstory, shortstory, author, published FROM cms_news WHERE id = '" . $engine->secure($_GET['id']) . "' LIMIT 1");                        $author = $engine->fetch_assoc("SELECT look FROM users WHERE username = ".$news['author']." LIMIT 1");                        $template->setParams('newsTitle', $news['title']);                        $template->setParams('newsContent', $news['longstory']);                        $template->setParams('newsAuthor', $news['author']);                        $template->setParams('newsDate', date("M d, Y", $news['published']));                        $template->setParams('newsPreview', $news['shortstory']);                        $template->setParams('authorLook', $author['look']);                                   unset($result);                        unset($news1);                        unset($news);            }          final public function getPageHome()        {            global $template, $engine;            $a = 1;            $data = dbquery("SELECT title, id, published, shortstory, image FROM cms_news ORDER BY id DESC LIMIT 5");                             while($news = mysqli_fetch_array($data, MYSQLI_ASSOC))            {                $template->setParams('newsTitle-' . $a, $news['title']);                $template->setParams('newsID-' . $a, $news['id']);                $template->setParams('newsDate-' . $a, date("d-m-y", $news['published']));                $template->setParams('newsCaption-' . $a, $news['shortstory']);                $template->setParams('newsIMG-' . $a, $news['image']);                $a++;            }                     unset($news);            unset($data);        }         }

 

[briian]

post the code on hastebin.com and then post the link

 

[Blasteh]

post the code on hastebin.com and then post the link

You must be registered to see links

 

[Zoxq]

Go to class.template and post the code.