$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