Latest posts on your website

[Member 3639]

I'm not ignoring this thread i just haven't had time to look into it, feel free to use other code with that attitude.

You haven't given me anything to work with, what you did to get the error, you haven't said if you have checked your error logs. Your now saying about someone else's code and yet complaining in my thread?

 

[makdeniss]

Your code doesn't work and the reason together with log information was given by user:

Line 28:

mysql_connect($config['db']['host'], $config['db']['username'], $config['db']['password']);

 

[Member 3639]

Then you are not pointing to your config file.

 

[makdeniss]

Then you are not pointing to your config file.

It would be the case, but the /library/GeekPoint/Symfony.php is found correctly. That means that my folder and path values are set correctly. Maybe there is some other trick?

 

[Member 3639]

Can you please post the info you put into the script? So the url, the path etc that you set in the top of the code for me just to double check.

Also what does your log say exactly?

 

[x4rl]

Also the same error

<?php
// get latest x forum posts from xenforo v0.2 by liamdawe

// edit this to whatever folder your forum is in
$forum_url = '';

// change to the amount of posts you want displayed
$limit = 7;

// edit this to the directory your forum is in
$forum_directory = '/home/animelon/public_html/';

$startTime = microtime(true);

require($forum_directory. '/library/XenForo/Autoloader.php');
XenForo_Autoloader::getInstance()->setupAutoloader($forum_directory . '/library');

GeekPoint_Symfony::initializeXenforo($forum_directory, $startTime);

$nodeModel = XenForo_Model::create('XenForo_Model_Node');
$nodes = $nodeModel->getViewableNodeList();

$nodes_get = array_keys($nodes);

$node_id_list = implode($nodes_get, ',');

mysql_connect($config['db']['localhost'], $config['db']['xxxxxx'], $config['db']['xxx']);
mysql_select_db($config['db']['xxx']);

$sql_forum = "SELECT `title`, `thread_id` FROM `xf_thread` WHERE `node_id` IN ($node_id_list) ORDER BY `last_post_date` DESC LIMIT {$limit}";

$query_forum = mysql_query($sql_forum);
    while ($topics = mysql_fetch_assoc($query_forum))
    {
        $url_title = str_replace(' ', '-', $topics['title']);
        $url_title = str_replace('.', '', $url_title);
        $url_title = str_replace('?', '', $url_title);
        $url_title = str_replace('/', '-', $url_title);
        $url_title = str_replace('\\', '-', $url_title);
        $url_title = str_replace('"', '', $url_title);
        echo "<a href=\"{$forum_url}index.php?threads/{$url_title}.{$topics['thread_id']}/\">{$topics['title']}</a>";
    }
?>

 

[ToDie4]

I cannot get this to show up properly on my website, this is how it looks on my site:
* url snip *

This is the layout being used:
* snip *

Can anyone help me out here and take a look and see if you can see what I've got wrong please.

 

[Member 3639]

@ToDie4 you have saved your page in html format, it needs to be in php format.

@vodkaholic what is the error, neither of you have given me the actual error message. Also is your forum actually in the top level, not in a folder?

 

[ToDie4]

@ToDie4 you have saved your page in html format, it needs to be in php format.

Gah, that never dawned on me, now working lovely, thank you very much.

Would it be possible to display a sample of the thread content with the link saying 'read more'?

 

[x4rl]

@
@vodkaholic what is the error, neither of you have given me the actual error message. Also is your forum actually in the top level, not in a folder?

My forum is in Root yes and error is the same "An unexpected error occurred. Please try again later."
nothing in xenforo log's tho

 

[Member 3639]

There should always be something in the xenforo log? Hmm...

 

[Member 3639]

I just noticed you put "xxx" in the config vars (if you are hiding your actual details you put in), don't do that, the config vars are automatically set, so you are overwriting the config variables...with nothing.

That should fix it, as it would throw up an error since it cannot connec to the database

 

[x4rl]

I just noticed you put "xxx" in the config vars (if you are hiding your actual details you put in), don't do that, the config vars are automatically set, so you are overwriting the config variables...with nothing.

That should fix it, as it would throw up an error since it cannot connec to the database

Same result mate
as

mysql_connect($config['db']['localhost'], $config['db']['username'], $config['db']['password']);
mysql_select_db($config['db']['dbname']);

If this is what you mean

even

$config['db']['host']

also

 

[Member 3639]

Yeah you need to keep them as that or else it really won't work.

Check your error logs on xenforo in the tools section, there should at least be something.

 

[x4rl]

Yeah you need to keep them as that or else it really won't work.

Check your error logs on xenforo in the tools section, there should at least be something.

I have as above still the same mate (nothing in log's)

Edit this is the file

 

[Member 3639]

Yeah i just tested, seems the log isn't working, will see what i can do.

 

[Member 3639]

Check the first post, have updated it with new code that is tested here working fine: http://www.gamingonlinux.info/test.php

 

[x4rl]

Check the first post, have updated it with new code that is tested here working fine: http://www.gamingonlinux.info/test.php

Spot on mate cheers! very useful for none xenforo page's.
Wonder if there anymore bit's of code like this about for none xen page's ill defo be looking later

 

[Member 3639]

No worries glad that fixes it, any other issues and suggestions just ask away

 

[ToDie4]

Would it be possible to display a sample of the thread content with the link saying 'read more'?

Don't know if you saw my question Liam, is that possible?