From The Lyceum Wiki
Written by: Yahya Hamidaddin
This is what I have done to make Cordobo Green Park 0.9.2 work properly under Lyceum:
Problem:
Cordobo Green Park template has an SQL query in sidebar.php that gets the list of Links from linkcategories table.
As expected, this query runs across all blogs resulting in duplicates in the sidebar.
Solution:
I have modified the SQL statement in the BX_Functions.php file to limit the results to the active blog.
Modifications:
Below are steps to be taken for modifying the theme.
#
#-----[ OPEN ]------------------------------------------
#
sidebar.php
#
#-----[ FIND ]------------------------------------------
# around line 90
#
$link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories");
#
#-----[ BEFORE, ADD ]------------------------------------------
#
global $blog;
#
#-----[ FIND ]------------------------------------------
# around line 90 (Same line above)
#
$link_cats = $wpdb->get_results("SELECT cat_id, cat_name FROM $wpdb->linkcategories");
#
#-----[ IN LINE FIND ]------------------------------------------
#
FROM $wpdb->linkcategories
#
#-----[ IN LINE AFTER ADD ]------------------------------------------
#
WHERE linkcategories.blog=$blog
END OF FILE