X-Cart forums

[autobulbs]

This mod assumes that you use the Wordpress blogging software and uses the same database as your xcart software.
If your wordpress and x-cart use separate database then use this code for blog_headlines.php

If you do not use the default Wordpress SQL table prefix than you will need to specify it in the select query.
For example, change wp_posts to yourprefix_posts

Create xcart-root/include/blog_headlines.php and paste this in it:

<?php
$blog_headlines = func_query("SELECT post_title,guid,post_date as orderby, DATE_FORMAT(post_date,'%d/%m/%Y') as post_date FROM wp_posts WHERE post_status = 'publish' group by post_title order by orderby desc limit 3");
array("blog_headlines" => array());
$smarty->assign("blog_headlines", $blog_headlines);
?>

Create xcart-root/skin1/blog_headlines.tpl and paste this in it:

{* $Id: blog_headlines.tpl,v1 09/01/29  11:18:59 max Exp $ *}
{capture name=menu}
{foreach from=$blog_headlines item=bh}<a href="{$bh.guid}" class="blog_headlines">{$bh.post_title}</a><div class="blog_headlines">{$bh.post_date}</div><br class="blog_headlines"/><hr noshade="noshade" size="1" class="blog_headlines" />{/foreach}
{/capture}
{include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title="Blog Headlines" menu_content=$smarty.capture.menu}

Open xcart-root/init.php and add this at the end:

#Blog Headlines
include($xcart_dir."/include/blog_headlines.php");

Open xcart-root/skin1/skin1.css and add this:

/*** Blog Headlines Styles Start ***/
a.blog_headlines { /* The link */
    display:block;
}
a.blog_headlines:hover { /* The link when hovered over */
    background:#d7d7d7;
}
hr.blog_headlines { /* The line */
    color:#e1e1e1;
}
div.blog_headlines { /* The date */
    float:right;
}
br.blog_headlines{
    clear:left;
}
/*** Blog Headlines Styles End ***/

Open xcart-root/skin1/customer/home.tpl file and add this within VertMenuLeftColumn (or where ever appropriate):

{include file="blog_headlines.tpl"}

[anandat]

hi autobulbs,
This seems nice mod.
can you please tell me what I need to do if I am using different database for my x-cart & wordpress ?

Thanks.

[crazyoval]

HI autobulbs, nice one! what a great idea, bring x-cart sites up a sep.

just a tad too complicated for me to play with a live site. Do you have a live site running it today that I can see it working?

[autobulbs]

Hi crazyoval

Yes we have it running on http://www.bhpplus.co.uk/ (On the left, as Diesel News) Which is using the code in the original post.

And also on http://www.autobulbsdirect.co.uk/ (Under Latest Automotive News) But this is a heavily modified wordpress so the code is slightly different, but the principle is the same.

----------------------------------------------
anandat, I will look into that later this week

[canuck]

Originally Posted by anandat

hi autobulbs,
This seems nice mod.
can you please tell me what I need to do if I am using different database for my x-cart & wordpress ?

Thanks.

I just ran across this post and I'm looking to do the same -- add most recent wordpress posts on my main x-cart home page. But my wordpress database is separate. Does anyone know how to do it?

I've seen rss mods but this seems like a cleaner way, no? Or does the separate database complicate things too much?

[autobulbs]

I did solve this, and here is how:

PHP Code:

<?php

#Connect to the wordpress database
db_connect('wp db host', 'wp db user', 'wp db pass');
db_select_db('wp db name');

#Select the posts
$blog_headlines = func_query("SELECT post_title,guid,post_name,ID,DATE_FORMAT(post_date,'%d/%m/%Y') as post_date, post_date as orderbythis FROM wp_posts WHERE post_status = 'publish' GROUP BY post_title ORDER BY orderbythis DESC LIMIT 3;");

#Stuff them into a smarty array
array("blog_headlines" => array());
$smarty->assign("blog_headlines", $blog_headlines);

#Connect to the X-Cart database - these variables are in config.php
db_connect($sql_host, $sql_user, $sql_password);
db_select_db($sql_db);

?>

[Scott DeToffol]

I'm pulling in posts to X-cart sidebar using RSS via javascript from http://www.rssinclude.com/.

But I'm looking for a PHP solution. I think http://simplepie.org/ should be able to do it, but haven't dug in to figure it out yet.

[anandat]

Originally Posted by Scott DeToffol

I'm pulling in posts to X-cart sidebar using RSS via javascript from http://www.rssinclude.com/.

But I'm looking for a PHP solution. I think http://simplepie.org/ should be able to do it, but haven't dug in to figure it out yet.

Thanks Scott DeToffol
rssinclude.com looks good as it's support twitter also. will try to play with this in next weekend.

[Learner]

Originally Posted by autobulbs

This mod assumes that you use the Wordpress blogging software and uses the same database as your xcart software.
If your wordpress and x-cart use separate database then use this code for blog_headlines.php

If you do not use the default Wordpress SQL table prefix than you will need to specify it in the select query.
For example, change wp_posts to yourprefix_posts

Create xcart-root/include/blog_headlines.php and paste this in it:

<?php
$blog_headlines = func_query("SELECT post_title,guid,post_date as orderby, DATE_FORMAT(post_date,'%d/%m/%Y') as post_date FROM wp_posts WHERE post_status = 'publish' group by post_title order by orderby desc limit 3");
array("blog_headlines" => array());
$smarty->assign("blog_headlines", $blog_headlines);
?>

Create xcart-root/skin1/blog_headlines.tpl and paste this in it:

{* $Id: blog_headlines.tpl,v1 09/01/29  11:18:59 max Exp $ *}
{capture name=menu}
{foreach from=$blog_headlines item=bh}<a href="{$bh.guid}" class="blog_headlines">{$bh.post_title}</a><div class="blog_headlines">{$bh.post_date}</div><br class="blog_headlines"/><hr noshade="noshade" size="1" class="blog_headlines" />{/foreach}
{/capture}
{include file="menu.tpl" dingbats="dingbats_categorie.gif" menu_title="Blog Headlines" menu_content=$smarty.capture.menu}

Open xcart-root/init.php and add this at the end:

#Blog Headlines
include($xcart_dir."/include/blog_headlines.php");

Open xcart-root/skin1/skin1.css and add this:

/*** Blog Headlines Styles Start ***/
a.blog_headlines { /* The link */
    display:block;
}
a.blog_headlines:hover { /* The link when hovered over */
    background:#d7d7d7;
}
hr.blog_headlines { /* The line */
    color:#e1e1e1;
}
div.blog_headlines { /* The date */
    float:right;
}
br.blog_headlines{
    clear:left;
}
/*** Blog Headlines Styles End ***/

Open xcart-root/skin1/customer/home.tpl file and add this within VertMenuLeftColumn (or where ever appropriate):

{include file="blog_headlines.tpl"}

Hi I have x cart Pro 4.1.9 and my wordpress is in my same folder(within blog folder) of my domain with different database.After Adding codes
-#Blog Headlines
include($xcart_dir."/include/blog_headlines.php"); at the end
The entire store getting blank.How to solve this issue??

What is the exact codes for 4.1.9 Versions??

How to resolve this issue??

[xtech]

Hi,
Will it compatible with 4.4 version??