Karma theme and qTranslate help WordPress

priktop comments:

Yes, it is.

Peter Michael comments:

Have you seen 'This function will not work correctly if you installed qTranslate on a blog with existing entries. In this case you will need to take a look at "Convert Database" under "Advanced Settings".' ?

priktop comments:

Yes I have, and qTranslate was installed first thing, so that couldn't be the case :(

Peter Michael comments:

I'm out of ideas, good luck.

priktop comments:

Too bad, thanks anyway!

priktop comments:

Theme function, here is the code:



/* ---------------------------------------
RECENT POSTS WIDGET
--------------------------------------- */
class show_recent extends WP_Widget {
function show_recent() {
$widget_ops = array('classname' => 'show_recent', 'description' => __('Show your recent posts.'));
$this->WP_Widget('show_recent', __('CUSTOM - Recent Posts'), $widget_ops);
}

function widget($args, $instance){
extract($args);

//$options = get_option('custom_recent');
$title = $instance['title'];
$posts = $instance['posts'];

//GET the posts
global $post;
$exclude = B_getExcludedCats();
$myposts = get_posts('numberposts='.$posts.'&offset=0&category='.$exclude);

echo $before_widget . $before_title . $title . $after_title;


//SHOW the posts
foreach($myposts as $post){
setup_postdata($post);
//added strip_tags to solve a problem with code being displayed improperly.
?>
<div class="footer_post">
<h4><a href="<?php __(the_permalink()) ?>"><?php __(the_title()); ?></a></h4>
<p><a href="<?php __(the_permalink()) ?>"><?php echo substr(strip_tags(__($post->post_content)), 0, 125); ?>...</a></p>
</div><!-- end footer_post -->
<?php
}
echo $after_widget;
}

function update($newInstance, $oldInstance){
$instance = $oldInstance;
$instance['title'] = strip_tags($newInstance['title']);
$instance['posts'] = $newInstance['posts'];

return $instance;
}

function form($instance){
echo '<p><label for="'.$this->get_field_id('title').'">' . __('Title:') . '</label><input class="widefat" id="'.$this->get_field_id('title').'" name="'.$this->get_field_name('title').'" type="text" value="'.$instance['title'].'" /></p>';

echo '<p><label for="'.$this->get_field_id('posts').'">' . __('Number of Posts:', 'widgets') . '</label><input class="widefat" id="'.$this->get_field_id('posts').'" name="'.$this->get_field_name('posts').'" type="text" value="'.$instance['posts'].'" /></p>';

echo '<input type="hidden" id="custom_recent" name="custom_recent" value="1" />';
}
}


And


/* ----- RELATED POSTS ----- */
function related_posts_shortcode( $atts ) {
extract(shortcode_atts(array(
'title' => '',
'limit' => '5',
), $atts));
global $wpdb, $post, $table_prefix;
if ($post->ID) {
$retval = '[raw]<div class="related_posts"><h4>'.$title.'</h4><ul class="list">[/raw]';
// Get tags
$tags = wp_get_post_tags($post->ID);
$tagsarray = array();
foreach ($tags as $tag) {
$tagsarray[] = $tag->term_id;
}
$tagslist = implode(',', $tagsarray);

// Do the query
$q = "
SELECT p.*, count(tr.object_id) as count
FROM $wpdb->term_taxonomy AS tt, $wpdb->term_relationships AS tr, $wpdb->posts AS p
WHERE tt.taxonomy ='post_tag'
AND tt.term_taxonomy_id = tr.term_taxonomy_id
AND tr.object_id = p.ID
AND tt.term_id IN ($tagslist)
AND p.ID != $post->ID
AND p.post_status = 'publish'
AND p.post_date_gmt < NOW()
GROUP BY tr.object_id
ORDER BY count DESC, p.post_date_gmt DESC
LIMIT $limit;";

$related = $wpdb->get_results($q);
if ( $related ) {
foreach($related as $r) {
$retval .= '<li><a title="'.wptexturize($r->post_title).'" href="'.get_permalink($r->ID).'">'.wptexturize($r->post_title).'</a></li>';}
} else {
$retval .= '<li>No related posts found</li>';}
$retval .= '[raw]</ul></div><!-- end related posts -->[/raw]';
return $retval;
}return;}


Julio Potier comments:

Ok i don't know qTranslate, how this plugin can recognize a FR or EN post ?
thank you

(i cna have a look with an admin acces if you want)

priktop comments:

It fills the DB record with tags, like this:


<!--en-->English text<!--:--><!--nl-->Dutch text<!--:--><!--fr-->French text<!--:-->


Julio Potier comments:

ooooooook... this is absolutely bad, the plugin use a "like" on "post content", bad bad bad.
Anyway.

Try this :
Between this 2 lines in RELATED POSTS :
AND p.post_date_gmt < NOW()
GROUP BY tr.object_id
Add this :
AND p.post_content LIKE '%<!--:" . qtrans_getLanguage() . "-->%'
now you have
AND p.post_date_gmt < NOW()
<strong>AND p.post_content LIKE '%<!--:" . qtrans_getLanguage() . "-->%'</strong>
GROUP BY tr.object_id

If it works, we have to modify the "get_posts" in a sull quey like this one.

priktop comments:

Doesn't work, but I just noticed that it shows the URL of the current language well at the related posts, but it concatenates the title with all languages.... So the title is the only problem.

Julio Potier comments:

ok, can you paste me the title of a post here ?
Thank you
(or grant me access to gain time for both !)

priktop comments:

Okay, check PM.

priktop comments:

Nope, but it's too late for that now.