News MySQLi Help

[Blasteh]

Hi,
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:

You must be registered for see images attach

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.

You must be registered for see images attach

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', '&laquo; <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);
        }
        
    }

 

[Joe]

Looks like ordinary RevCMS..?

If not why not just copy code from the original RevCMS release.

 

[Blasteh]

Looks like ordinary RevCMS..?

If not why not just copy code from the original RevCMS release.

The backend has snippets from Rev, it's not RevCMS.

Even copying it from the original doesn't help the original problem.

 

[Joe]

From experience I can’t imagine a lot of help, maybe a few Google seasions? After all it is years old.

 

[Antisj]

So..
{newstitle} etc isnt doing it's job?

 

[Blasteh]

From experience I can’t imagine a lot of help, maybe a few Google seasions? After all it is years old.

It’s not RevCMS, as stated. The other classes are recoded, paths are not the same, etc. I can’t google it as the CMS was coded for Hablix. The creator is in University and our time zones are the exact opposite.

So..
{newstitle} etc isnt doing it's job?

Sadly, no.

 

[Detox]

Try doing research on here

You must be registered for see links

&

You must be registered for see links

Because just by slighting reading the code it's looks like it might have something to do with fetch_array and fetch_assoc but just like looking at your images It able to pull it on news.php

 

[Pinkman]

I think it’s to do with one of the classes. Try class template?

 

[Blasteh]

Try doing research on here

You must be registered for see links

&

You must be registered for see links

Because just by slighting reading the code it's looks like it might have something to do with fetch_array and fetch_assoc but just like looking at your images It able to pull it on news.php

I took a peak, played with the code a bit - no luck.

I think it’s to do with one of the classes. Try class template?

Everything that is supposed to be in it, is in the class.

 

[Pinkman]

I took a peak, played with the code a bit - no luck.


Everything that is supposed to be in it, is in the class.

Let me hop onto my laptop hold on.
 

Let me hop onto my laptop hold on.

Host a teamviewer (you can pm me of u wish)

 

[Wickd]

Check the image directory.

 

[Pinkman]

Check the image directory.

It is not about the image url, its about reading the title if I am correct?

 

[Blasteh]

It is not about the image url, its about reading the title if I am correct?

That is correct. For some reason, news article do not display.
 
Still looking for a fix.

 

[Pinkman]

That is correct. For some reason, news article do not display.
 
Still looking for a fix.

Whats your discord? Add mine Ninja#6425

 

[Blasteh]

Still searching..

 

[Weasel]

I might be able to help you, but I don't fully understand what issues you have, and I don't think I see corresponding code either.

 

[Blasteh]

With the help of @JynX, I was able to solve the issue.

If anyone else is having this problem, Jake (Jynx) recoded my getPageHome() function, also, navigate to your class.core.php and make sure the following code is correct:

                        case "me":
                            $template->form->getPageHome();
                            break;

Mine, the code was:

                        case "me":
                            $template->form->getPageNews();
                            break;

 

[Pinkman]

With the help of @JynX, I was able to solve the issue.

If anyone else is having this problem, Jake (Jynx) recoded my getPageHome() function, also, navigate to your class.core.php and make sure the following code is correct:

                        case "me":
                            $template->form->getPageHome();
                            break;

Mine, the code was:

                        case "me":
                            $template->form->getPageNews();
                            break;

Did say it was to do with the classes Sorry just that you weren't responding to me ;(