phpBB.nl

Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/

Vreemde tekst in Ban Lijst

https://www.phpbb.nl/forums/viewtopic.php?f=45&t=19822

Pagina 1 van 1

Vreemde tekst in Ban Lijst

Geplaatst: 19 mei 2005, 21:06
door Muiter
Ik heb nog steeds het probleem dat een aantal variabelen niet in de database worden opgenomen.

Dit heb ik toegevoegd:

Code: Selecteer alles

$sql = "INSERT INTO " . BANLIST_TABLE . " (ban_userid, user_name, reason, baned_by, date, time) VALUES (" . $user_list[$i] . ", '" . addslashes($user_name) . "', '" . addslashes($reason) . "', '" . addslashes($userdata['username']) . "', '". date("m.d.y") . "', '".date("H:i")."')";
Dit staat in mijn database:

Code: Selecteer alles

CREATE TABLE `phpbb_banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL auto_increment,
  `ban_userid` mediumint(8) NOT NULL default '0',
  `user_name` varchar(50) NOT NULL default '',
  `reason` varchar(75) NOT NULL default '',
  `baned_by` varchar(50) NOT NULL default '',
  `date` varchar(8) NOT NULL default '',
  `time` varchar(5) NOT NULL default '',
  `ban_ip` varchar(8) NOT NULL default '',
  `ban_email` varchar(255) default NULL,
  PRIMARY KEY  (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`)
) TYPE=MyISAM AUTO_INCREMENT=4 ;
Hier is het probleem te zien

Geplaatst: 21 mei 2005, 21:56
door Muiter
Ik hoop dat iemand mij alsnog kan helpen:

banlist.php

Code: Selecteer alles

<?php
/***************************************************************************
 *                              banlist.php
 *                            -------------------
 *   begin                : Wensday, Feb 11, 2003
 *   copyright            : (C) 2003 ThE DrAgOn'S
 *   email                : orna_h@012.net.il
 *
 *   $Id: banlist.php,v 1.36.2.2 2002/07/29 05:04:03 dougk_ff7 Exp $
 *   
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_VIEWMEMBERS);
init_userprefs($userdata);
//
// End session management
//

$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;

//
// Generate page
//
$page_title = $lang['Ban'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
	'body' => 'banlist_body.tpl')
);
make_jumpbox('viewforum.'.$phpEx);
$order_by = "ban_id DESC LIMIT $start, " . $board_config['topics_per_page'];
$sql = "SELECT ban_userid,user_name,reason,baned_by,date,time
	FROM " . BANLIST_TABLE . "
	WHERE ban_userid <> 0
	ORDER BY $order_by";
if( !($result = $db->sql_query($sql)) )
{
	message_die(GENERAL_ERROR, 'Could not query users', '', __LINE__, __FILE__, $sql);
}

if ( $row = $db->sql_fetchrow($result) )
{
	$i = 0;
	do
	{
        if($row['reason']=="")
        $reason = "ìà äåëðñä ñéáä ìçñéîä æàú";
        else
        $reason = $row['reason'];
        $by=$row['baned_by'];
		$in = "áúàøéê: ".$row['date']."<br>áùòä: ".$row['time'];
		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
        $tmp=mysql_result(mysql_query("SELECT user_id FROM phpbb_users WHERE username='$by'"),0);
        print $user_name;
		$template->assign_block_vars('memberrow', array(
			'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ),
			'ROW_COLOR' => '#' . $row_color,
			'ROW_CLASS' => $row_class,
			'USERNAME' => $row['user_name'],
			'BY' => $by,
			'IN' => $in,
			'REASON' => $reason,
			'U_VIEWPROFILE2' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$tmp),
			'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$row['ban_userid']))
		);

		$i++;
	}
	while ( $row = $db->sql_fetchrow($result) );
}

if ( $mode != 'topten' || $board_config['topics_per_page'] < 10 )
{
	$sql = "SELECT count(*) AS total
		FROM " . BANLIST_TABLE . "
		WHERE ban_userid <> 0";

	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Error getting total users', '', __LINE__, __FILE__, $sql);
	}

	if ( $total = $db->sql_fetchrow($result) )
	{
		$total_members = $total['total'];

		$pagination = generate_pagination("memberlist.$phpEx?mode=$mode&order=$sort_order", $total_members, $board_config['topics_per_page'], $start). '&nbsp;';
	}
}
else
{
	$pagination = '&nbsp;';
	$total_members = 10;
}

$template->assign_vars(array(
	'PAGINATION' => $pagination,
	'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['topics_per_page'] ) + 1 ), ceil( $total_members / $board_config['topics_per_page'] )),

	'L_GOTO_PAGE' => $lang['Goto_page'])
);

$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>
banlist_body.tpl

Code: Selecteer alles

<form method="post" action="{S_MODE_ACTION}">
  <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center">
	<tr> 
	  <td align="{S_CONTENT_DIR_LEFT}" colspan="2"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td>
	</tr>
  </table>
  <table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
	<tr> 
	  
	  <th class="thTop" nowrap="nowrap">{BAN_REASON}</th>
	  <th class="thTop" nowrap="nowrap">{BAN_BY}</th>
	  <th class="thTop" nowrap="nowrap">{BAN_DATE}</th>
	  <th class="thTop" nowrap="nowrap">{BAN_NAME}</th>	
</tr>
	<!-- BEGIN memberrow -->
	<tr> 
	  
	  <td width="60%" class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen">{memberrow.REASON}</span></td>
	  <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gen"><a href="{memberrow.U_VIEWPROFILE2}" class="gen">{memberrow.BY}</a></span></td>
	  <td class="{memberrow.ROW_CLASS}" align="center" valign="middle"><span class="gensmall">{memberrow.IN}</span></td>
<td class="{memberrow.ROW_CLASS}" align="center"><span class="gen"><a href="{memberrow.U_VIEWPROFILE}" class="gen">{memberrow.USERNAME}</a></span></td>	
</tr>
	<!-- END memberrow -->
	<tr> 
	  <td class="catbottom" colspan="8" height="28">&nbsp;</td>
	</tr>
  </table>
  <table width="100%" cellspacing="2" border="0" align="center" cellpadding="2">
	<tr> 
	  <td align="{S_CONTENT_DIR_RIGHT}" valign="top"></td>
	</tr>
  </table>

<table width="100%" cellspacing="0" cellpadding="0" border="0">
  <tr> 
	<td><span class="nav">{PAGE_NUMBER}</span></td>
	<td align="{S_CONTENT_DIR_RIGHT}"><span class="gensmall">{S_TIMEZONE}</span><br /><span class="nav">{PAGINATION}</span></td>
  </tr>
</table></form>

<table width="100%" cellspacing="2" border="0" align="center">
  <tr> 
	<td valign="top" align="{S_CONTENT_DIR_RIGHT}">{JUMPBOX}</td>
  </tr>
</table>

Geplaatst: 22 mei 2005, 19:37
door Luuk
if($row['reason']=="")
$reason = "ìà äåëðñä ñéáä ìçñéîä æàú";
else
$reason = $row['reason'];
$by=$row['baned_by'];
$in = "áúàøéê: ".$row['date']."<br>áùòä: ".$row['time'];

Geplaatst: 23 mei 2005, 16:43
door Muiter
Luuk schreef:
if($row['reason']=="")
$reason = "ìà äåëðñä ñéáä ìçñéîä æàú";
else
$reason = $row['reason'];
$by=$row['baned_by'];
$in = "áúàøéê: ".$row['date']."<br>áùòä: ".$row['time'];
Wat hoort daar te staan dan?

Geplaatst: 26 mei 2005, 18:30
door Luuk
Ja dat weet ik ook niet :P

mmm

Geplaatst: 26 mei 2005, 19:35
door svenn
testen is de enige oplossing probeer dit eens

zoek dit

Code: Selecteer alles

  if($row['reason']=="") 
        $reason = "ìà äåëðñä ñéáä ìçñéîä æàú"; 
        else 
        $reason = $row['reason']; 
        $by=$row['baned_by']; 
      $in = "áúàøéê: ".$row['date']."<br>áùòä: ".$row['time']; 
      $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; 
      $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; 
        $tmp=mysql_result(mysql_query("SELECT user_id FROM phpbb_users WHERE username='$by'"),0); 
        print $user_name; 
      $template->assign_block_vars('memberrow', array( 
         'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ), 
         'ROW_COLOR' => '#' . $row_color, 
         'ROW_CLASS' => $row_class, 
         'USERNAME' => $row['user_name'], 
         'BY' => $by, 
         'IN' => $in, 
         'REASON' => $reason, 
         'U_VIEWPROFILE2' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$tmp), 
         'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$row['ban_userid']))
vervang met

Code: Selecteer alles

        $reason = $row['reason']; 
        $by=$row['baned_by']; 
      $in = "datum: ".$row['date']."<br> tijd: ".$row['time']; 
      $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2']; 
      $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; 
        $tmp=mysql_result(mysql_query("SELECT user_id FROM phpbb_users WHERE username='$by'"),0); 
        print $user_name; 
      $template->assign_block_vars('memberrow', array( 
         'ROW_NUMBER' => $i + ( $HTTP_GET_VARS['start'] + 1 ), 
         'ROW_COLOR' => '#' . $row_color, 
         'ROW_CLASS' => $row_class, 
         'USERNAME' => $row['user_name'], 
         'BY' => $by, 
         'IN' => $in, 
         'REASON' => $reason, 
         'U_VIEWPROFILE2' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$tmp), 
         'U_VIEWPROFILE' => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$row['ban_userid']))
grt svennson

Re: mmm

Geplaatst: 18 jun 2005, 22:51
door Muiter
svennson schreef:testen is de enige oplossing probeer dit eens
Dit heeft het grootste gedeelte opgelost maar nu verschijnt alleen de reden niet meer.
Alle tijden zijn UTC+01:00
Pagina 1 van 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/