

The plan was to: 1) build an array of unique alphabet letters that have videos in the database 2) as we render the alphabet icons, check for each letter/digit if it is also in the above array, and if yes, change the icon image to the green one XoopsTube renders the images in the function xoopstube_letters() located in /include/functions.php As first we needed to extract the unique letters from the database and create the array: $distinctDbLetters_arr = array();
$sql = 'SELECT DISTINCT (UPPER(LEFT(title, 1))) AS letter FROM ' . $xoopsDB->prefix('xoopstube_videos') ;
if ($result = $xoopsDB->query($sql)) {
while ($row = $xoopsDB->fetchArray($result)) {
$distinctDbLetters_arr[] = $row['letter'];
}
}
unset($sql); if (in_array($ltr, $distinctDbLetters_arr)) {
$letterchoice
.= ';
} else {
$letterchoice
.= ';
} .xoopstube_letters_green {
background-image: url(images/icon/backgnd_green.png);
}






Xoops Demo is pleased to present to you last Xoops theme based on the Framework BOOTSTRAP
In this template, the structure of the theme was created entirely DIV thus removing all TABLE
Block Main Menu, User menu and connection has been customized with tools BOOTSTRAP
The "closed site" page has been customized
Other options have also been added
Thank you for these ideas to Grodunord