Hi List
I am using a modified version of this menu:
http://typo3.toaster-schwerin.de/typo3_english/2007_01/msg00900.html
to display a list-menu of all staff members in 'WEC Staff Directory'. It
works as supposed, but I have one problem.
I use 'Use Front-End users to store data': meaning that the members
names are stored in the fe_users table.
My problem is: I can't figure out how to display the fe_users name
instead of the feuser_id. I can't figure out how to read the name from
the fe_users table with the feuser_id from tx_wecstaffdirectory_info
Can somebody please help me with the problem.
Thanks in advance
Jogvan Olsen
Here is the code I use
-------
menuFunc_2.inc
<?php
class user_menuFunc {
function makeMenuArray($content,$conf) {
$GLOBALS["TSFE"]->set_no_cache();
$menuArr = array();
$lConf = $conf["userFunc."];
$overridehref = $lConf['_OVERRIDE_HREF'];
$res =
$this->cObj->exec_getQuery($lConf["table"],$lConf["select."]);
if ($error = $GLOBALS['TYPO3_DB']->sql_error()) {
$GLOBALS['TT']->setTSlogMessage($error,3);
} else {
$GLOBALS['TT']->setTSlogMessage('NUMROWS:
'.$GLOBALS['TYPO3_DB']->sql_num_rows($res));
while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
$row['_OVERRIDE_HREF'] = 'index.php?id=' . $overridehref
.
'&tx_wecstaffdirectory_pi1[curstaff]=' . $row['uid'];
$menuArr[] = $row;
}
}
return $menuArr;
}
}
?>
-----
TS setup:
---------------------
## STAFF menu start
page.includeLibs.usermenu = fileadmin/script/menuFunc_2.inc
lib.field_wec_staff_list = HMENU
lib.field_wec_staff_list.protectLvar = 1
lib.field_wec_staff_list.wrap = <ul>|</ul>
lib.field_wec_staff_list.special = userfunction
lib.field_wec_staff_list.special.userFunc = user_menuFunc->makeMenuArray
lib.field_wec_staff_list.special.userFunc.table = tx_wecstaffdirectory_info
lib.field_wec_staff_list.special.userFunc.select.pidInList = 27
lib.field_wec_staff_list.special.userFunc._OVERRIDE_HREF = 17
lib.field_wec_staff_list.1 = TMENU
lib.field_wec_staff_list.1 {
NO {
stdWrap.cObject = CASE
stdWrap.cObject {
default = COA
default {
10 = TEXT
10.stdWrap.data = field:feuser_id
10.wrap = | <br/>
20 = TEXT
20.stdWrap.data = field:position_title
}
}
allWrap = <li>|</li>
}
ACT < .NO
ACT = 1
ACT {
ATagParams = class="selected"
}
}
## STAFF menu end
-----------------------------------------
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english