From The Lyceum Wiki
Written by: Yahya Hamidaddin
This is what I have done to make Blix 0.9.1 work properly under Lyceum:
Problem:
Blix is using a file called BX_Functions.php to perform some queries on the DB. As expected, these queries run across all blogs resulting in
duplicates in the navigation part of the template and in the sidebar.
Solution:
I have modified the SQL statements in the BX_Functions.php file to limit the results to the active blog.
Open Questions:
There are two SQL statments in comments-popup.php that I am not sure if they need to be changed:
1- $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = $id AND comment_approved = '1' ORDER BY comment_date");
2- $commentstatus = $wpdb->get_row("SELECT comment_status, post_password FROM $wpdb->posts WHERE ID = $id");
I kept them as is for now.
Modifications:
Below are steps to be taken for modifying the theme.
#
#-----[ OPEN ]------------------------------------------
#
BX_Functions.php
#
#-----[ FIND ]------------------------------------------
# around line 18
# In Function: function BX_archive()
global $month, $wpdb;
#
#-----[ AFTER, ADD ]------------------------------------------
#
global $blog;
#
#-----[ FIND ]------------------------------------------
# around line 21
# In Function: function BX_archive()
$arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date)
#
#-----[ IN LINE FIND ]------------------------------------------
#
. $wpdb->posts .
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
", " . $wpdb->categories . ", " . $wpdb->post2cat .
#
#-----[ IN LINE FIND ]------------------------------------------
#
GROUP BY
#
#-----[ IN LINE BEFORE ADD ]------------------------------------------
#
AND post2cat.post_id=posts.ID AND categories.cat_id = post2cat.category_id AND categories.blog= '$blog'
#
#-----[ FIND ]------------------------------------------
# around line 32
# In Function: function BX_archive()
$arcresults2 = $wpdb->get_results("SELECT ID, post_date,
#
#-----[ IN LINE FIND ]------------------------------------------
#
. $wpdb->posts .
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
", " . $wpdb->categories . ", " . $wpdb->post2cat .
#
#-----[ IN LINE FIND ]------------------------------------------
#
ORDER BY
#
#-----[ IN LINE BEFORE ADD ]------------------------------------------
#
AND post2cat.post_id=posts.ID AND categories.cat_id = post2cat.category_id AND categories.blog= '$blog'
#
#-----[ FIND ]------------------------------------------
# around line 69
# In Function: function BX_get_recent_posts($current_id, $limit)
function BX_get_recent_posts($current_id, $limit)
{
global $wpdb;
#
#-----[ AFTER, ADD ]------------------------------------------
#
global $blog;
#
#-----[ FIND ]------------------------------------------
# around line 71
# In Function: function BX_get_recent_posts($current_id, $limit)
$posts = $wpdb->get_results("SELECT ID, post_title
#
#-----[ IN LINE FIND ]------------------------------------------
#
. $wpdb->posts .
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
", " . $wpdb->categories . ", " . $wpdb->post2cat .
#
#-----[ IN LINE FIND ]------------------------------------------
#
ORDER BY
#
#-----[ IN LINE BEFORE ADD ]------------------------------------------
#
AND post2cat.post_id=posts.ID AND categories.cat_id = post2cat.category_id AND categories.blog= '$blog'
#
#-----[ FIND ]------------------------------------------
# around line 90
# In Function: function BX_get_pages($with_content = '')
function BX_get_pages($with_content = '')
{
global $wpdb;
#
#-----[ AFTER, ADD ]------------------------------------------
#
global $blog;
#
#-----[ FIND ]------------------------------------------
# around line 93
# In Function: function BX_get_pages($with_content = '')
$query = "SELECT ID, post_title, post_name FROM
#
#-----[ IN LINE FIND ]------------------------------------------
#
. $wpdb->posts .
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
", " . $wpdb->categories . ", " . $wpdb->post2cat .
#
#-----[ IN LINE FIND ]------------------------------------------
#
ORDER BY
#
#-----[ IN LINE BEFORE ADD ]------------------------------------------
#
AND post2cat.post_id=posts.ID AND categories.cat_id = post2cat.category_id AND categories.blog= '$blog'
#
#-----[ FIND ]------------------------------------------
# around line 95
# In Function: function BX_get_pages($with_content = '')
$query = "SELECT ID, post_title,post_name, post_content FROM
#
#-----[ IN LINE FIND ]------------------------------------------
#
. $wpdb->posts .
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
", " . $wpdb->categories . ", " . $wpdb->post2cat .
#
#-----[ IN LINE FIND ]------------------------------------------
#
ORDER BY
#
#-----[ IN LINE BEFORE ADD ]------------------------------------------
#
AND post2cat.post_id=posts.ID AND categories.cat_id = post2cat.category_id AND categories.blog= '$blog'
END OF FILE