Hi Again
I am doing some changes in the way the meeting list is shown.
I would like to show on the meeting list, the number of Registered Users = Signed on user (1)
I have checked the code but I can't make it work. It gives me errors.
Can you please add the code to show Signed on user (1): to this below?
// SQL statement to read from a table
$sql = "SELECT * FROM " . MEETING_DATA_TABLE . "
$sql_filter
$sql_closed
ORDER BY $sort_field $sort_order
LIMIT $start, $per_page";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not read meeting data", '', __LINE__, __FILE__, $sql);
}
$meetingrow = array();
$total_meeting = 0;
while ($row = $db->sql_fetchrow($result))
{
if ( $meetings_access_ids[$row['meeting_id']] == TRUE )
{
$meetingrow[] = $row;
$total_meeting++;
}
}
$db->sql_freeresult($result);
if ( $total_meeting != 0 )
{
// Cycle a loop through all data
for($i = 0; $i < $total_meeting; $i++)
{
$meeting_check_time = $meetingrow[$i]['meeting_time'];
$meeting_check_until = $meetingrow[$i]['meeting_until'];
$meeting_time = create_date($userdata['user_dateformat'], $meeting_check_time, $userdata['user_timezone']);
$meeting_until = create_date($userdata['user_dateformat'], $meeting_check_until, $userdata['user_timezone']);
$meeting_location = stripslashes($meetingrow[$i]['meeting_location']);
$meeting_link = htmlspecialchars($meetingrow[$i]['meeting_link']);
$meeting_subject = stripslashes($meetingrow[$i]['meeting_subject']);
$meeting_location = ( $meeting_link != '' ) ? '<a href="'.$meeting_link . '" class="mainmenu">'.$meeting_location.'</a>' : $meeting_location;
$meeting_id = $meetingrow[$i]['meeting_id'];
$meeting_detail = '<a href="'.append_sid("meeting.$phpEx?mode=detail&id=$meeting_id&start=$start").'" class="mainmenu"><img src="'.$images['icon_view'].'" border="0"></a>';
$meeting_closed = ( $meeting_check_time < time() ) ? $lang['Yes'] : ( ( $meeting_check_until < time() ) ? $lang['Meeting_no_period'] : $lang['No'] );
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
// Output the values
$template->assign_block_vars('meeting_overview_row', array(
'ROW_CLASS' => $row_class,
'MEETING_TIME' => $meeting_time,
'MEETING_UNTIL' => $meeting_until,
'MEETING_LOCATION' => $meeting_location,
'MEETING_SUBJECT' => $meeting_subject,
'MEETING_CLOSED' => $meeting_closed,
'MEETING_DETAIL' => $meeting_detail)
);
}
Thank you
Meeting hack
Forumsregeln
Auch wenn hier der Support für phpBB 2 weiterhin aufrecht erhalten bleibt, weisen wir darauf hin, dass das phpBB 2 nicht mehr offiziell unterstützt und weiterentwickelt wird!
Auch wenn hier der Support für phpBB 2 weiterhin aufrecht erhalten bleibt, weisen wir darauf hin, dass das phpBB 2 nicht mehr offiziell unterstützt und weiterentwickelt wird!
- oxpus
- Administrator
- Beiträge: 28735
- Registriert: Mo 27.Jan, 2003 22:13
- Wohnort: Bad Wildungen
- Kontaktdaten:
Better:
Download the newest Mod release here from the download section and follow the update instructions.
Download the newest Mod release here from the download section and follow the update instructions.
Karsten Ude
-={ Das Mädchen für alles }=-
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
-={ Das Mädchen für alles }=-
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!