{kl_php}
global $database, $mainframe;
echo 'Choose Author\\'s Name: ';
echo '
"";
if (isset($_POST['by_line'])){
$sql = 'SELECT id, title, created, sectionid, introtext FROM mos_content WHERE match(created_by_alias) against(\\'""'.$_POST['by_line'].'""\\' in boolean mode) AND (`state`=""1"" OR `state`=""-1"") ORDER BY created DESC;';
$database->setQuery($sql);
$stories = $database->loadObjectList();
echo ';
echo """";
foreach($stories as $story){
$Itemid = $mainframe->getItemid($story->id);
if ($Itemid == NULL) {
$Itemid = ';
} else {
$Itemid = '&Itemid='. $Itemid;
}
$link = sefRelToAbs( 'index.php?option=com_content&task=view&id='. $story->id . $Itemid);
switch ($story->sectionid){
case 5:
$sectionTitle = ""News"";
break;
case 6:
$sectionTitle = ""Sports"";
break;
case 7:
$sectionTitle = ""Opinion"";
break;
case 8:
$sectionTitle = ""Arts"";
break;
case 24:
$sectionTitle = ""Almanac"";
break;
case 10:
$sectionTitle = ""Commerce"";
break;
case 11:
$sectionTitle = ""Features"";
break;
case 12:
$sectionTitle = ""Food"";
break;
case 13:
$sectionTitle = ""Science"";
break;
case 14:
$sectionTitle = ""Photo"";
break;
case 15:
$sectionTitle = ""InFocus"";
break;
case 21:
$sectionTitle = ""Comics"";
break;
case 16:
$sectionTitle = ""GameDay"";
break;
case 17:
$sectionTitle = ""PowerPlay"";
break;
case 18:
$sectionTitle = ""CourtSide"";
break;
default:
$sectionTitle = ""Unknown"";
}
echo """";
echo '';
echo '';
echo '';
echo '';
}
echo ""
| '.$story->title.' |
| '.$story->introtext.' |
"";
}
{/kl_php}
