Verfasst: 22.10.2006 12:05
ich hab hier die Boardsuche verwendet und hab nen ähnlichen Fall gefunden ....da wurde das so vorgeschlagen......nachdem ich das so gemacht habe, lief und läuft das ganze nun ohne Probleme
phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
// End add - Last visit MOD
function member_of($group_id, &$userdata)
{
global $db;
if ( !$userdata['session_logged_in'] )
{
return false;
}
if ( isset($userdata['user_member_of_' . $group_id]) )
{
return $userdata['user_member_of_' . $group_id];
}
$sql = "SELECT count(*) AS num FROM " . USER_GROUP_TABLE . "
WHERE user_id = '" . $userdata['user_id'] . "' AND user_pending = 0 AND group_id IN ( " . $group_id . " )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not get group auth', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
if ( $row['num'] > 0 )
{
return $userdata['user_member_of_' . $group_id] = true;
}
return $userdata['user_member_of_' . $group_id] = false;
}
?>
Code: Alles auswählen
else
{
$template->assign_block_vars('switch_user_logged_in', array());
if ( !empty($userdata['user_popup_pm']) )
{
$template->assign_block_vars('switch_enable_pm_popup', array());
}
if ( $userdata['user_absence'] == TRUE )
{
$template->assign_block_vars('switch_absence', array());
}
if ( member_of('8,39', $userdata) )
{
$template->assign_block_vars('switch_usergroup_8, 39', array());
}
}
Code: Alles auswählen
<body>
<!-- BEGIN switch_usergroup_8,39 -->
<form method="POST" action="kicklist.php" target="_self">
<table width="90%" cellspacing="1" cellpadding="4" border="0" align="center" class="forumline"> <tr>
<td class="catBottom" colspan="2">Kickliste:</td>
</tr>
<tr>
<td class="row1">Datum:</td>
<td class="row2"><input type="text" maxlength="255" size="50" name="datum" class="input"></td>
</tr>
<tr>
<td class="row1">Name:</td>
<td class="row2"><input type="text" maxlenght="255" size="50" name="name" class="input"></td>
</tr>
<tr>
<td class="row1" valign=top>Grund:</td>
<td class="row2"><textarea name="grund" cols="47" rows="15" class="textarea"></textarea></td>
</tr>
<tr>
<td class="catBottom" colspan="2" align="center"><input class="input" type="submit" name="submit" value="Eintragen!" /> <input class="input" type="reset" value="Löschen" />
</td>
</tr>
</table>
</form>
<br>
<!-- END switch_usergroup_8,39 -->
<table width="90%" cellspacing="1" cellpadding="4" border="0" align="center" class="forumline">
<tr>
<td class="catBottom" width="15%">Datum</td>
<td class="catBottom" width="35%">Name</td>
<td class="catBottom" width="50%">Grund</td>
</tr>
Code: Alles auswählen
if ( member_of('8,39', $userdata) )
{
<Hier kommt das ganze Eingabe-Forumlar hinein>
}
<Hier folgt der Code zur Tabellenanzeige>
Code: Alles auswählen
$start = ( !empty($_GET['start']) ) ? intval($_GET['start']) : 0;
$start = $start * 25;
$sql = "SELECT serie_id, season_id, folge_title, folge_desc, folge_img
FROM " . EPG_FOLGEN_TABLE . "
WHERE serie_id = ".$serie." AND season_id = ".$staffel."
ORDER BY folge_id
LIMIT $start, 25";
$sql = "SELECT * FROM ".EPG_FOLGEN_TABLE;
$result = $db->sql_query($sql);
$total = mysql_num_rows($result);
$pagination = generate_pagination(append_sid("name_der_datei.$phpEx"), $total, 25, $start);
Code: Alles auswählen
$start = ( !empty($_GET['start']) ) ? intval($_GET['start']) : 0;
$start = $start * 25;
$sql = "SELECT datum, name, grund
FROM " . kicklist . "
ORDER BY datum
LIMIT $start, 25";
$sql = "SELECT * FROM ".kicklist;
$result = $db->sql_query($sql);
$total = mysql_num_rows($result);
$pagination = generate_pagination(append_sid("kicklist.$phpEx"), $total, 25, $start);
Code: Alles auswählen
include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
Code: Alles auswählen
$start = ( !empty($_GET['start']) ) ? intval($_GET['start']) : 0;
$start = $start * 5;
$sql = "SELECT *
FROM " .$table_prefix . "kicklist" . "
ORDER BY datum
LIMIT $start, 5";
$sql = "SELECT * FROM " .$table_prefix . "kicklist";
$result = $db->sql_query($sql);
$total = mysql_num_rows($result);
$i = 1;
$total = $total * 0.5;
$total = ceil($total);
while($i != $total)
{
$i++;
echo ', <a href="kicklist.php?start='.$i.'">'.$i.'</a> ';
}