phpBB Sverige

phpBB-support, snack och diskussioner på svenska
https://phpbb.se/forum/

LÖST: random banners

https://phpbb.se/forum/viewtopic.php?t=1999

Sida 1 av 1

LÖST: random banners

Postat: 2005-12-29 12:15
av dallas
hej!

Har installerat MOD random banners och den fungerar som den skall
försökte göra en ändring...

sök upp:

Kod: Markera allt

//now, add for each banner next part:
och några rader därunder raden som börjar på:

Kod: Markera allt

$overall .= '<tr><td class="row2" width="50%">'.$lang['Creator']
sök också upp:

Kod: Markera allt

//now, show the rows for adding a banner:
och även där några rader under raden som börjar på:

Kod: Markera allt

$overall .= '<tr><td class="row1" width="50%">'.$lang['Creator']
båda dom raderna innehåller ju:

Kod: Markera allt

<input type="text"
vilket gör att jag kan skriva i princip hur lång text som helst vilket jag också vill
(kollat i databasen med)

gjorde om

Kod: Markera allt

<input type="text"
till

Kod: Markera allt

<textarea>
istället för att bättre kunna se vad jag skriver
och det fick jag att fungera med att uppdatera databasen och texten visas också riktigt på
det ställe jag valt att visa banner på en annan sida

men men....problemet är att när jag lagt in någonting i <textarea> och kommer tillbaka till sidan admin_banner.php
så visas inte det jag lagt in tidigare <textarea>
har jag <input type varianten så syns det jag lagt in tidigare där

//get all data: verkar alltså funka med <input type men inte med <textarea>

kan någon lösa/förklara det?

dallas

här följer hela sidan:


Kod: Markera allt

<?php
/***************************************************************************
 *                           	admin_banner.php
 *                            --------------------
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   copyright (C) 2003/2004  RCTycooner
 *
 *   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.
 *
 *   This program is distributed in the hope that it will be useful,
 *   but WITHOUT ANY WARRANTY; without even the implied warranty of
 *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *   GNU General Public License for more details.
 *
 *   http://www.gnu.org/copyleft/gpl.html
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if(	!empty($setmodules) )
{
	$file = basename(__FILE__);
	$module['General']['Random Banners'] = $file;
	return;
}

//
// Lets set the root dir for phpBB
//
$phpbb_root_path = '../';
require($phpbb_root_path . 'extension.inc');
require('pagestart.' . $phpEx);
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_banner.' . $phpEx);
//
//check for userlevel
//
if( !$userdata['session_logged_in'] )
{
	header('Location: ' . append_sid("login.$phpEx?redirect=admin/admin_banner.$phpEx", true));
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, $lang['no_access']);
}
//end check

if( $_POST['update'] == $lang['Update'] )
{ //update an existing banner
	//get all data:
	$sql = "SELECT id, creator, path, url, url_hover FROM ".$table_prefix."random_banners WHERE id='".$_POST['banner_id']."'";
	if(! ($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Could not obtain banner-info!!", "", __LINE__, __FILE__, $sql);
	}
	while ($row = $db->sql_fetchrow($result))
	{
	 	$current_creator = $row['creator'];
		$current_path = $row['path'];
		$current_url = $row['url'];
		$currnet_alt = $row['url_hover'];
	}

	if( $_POST['creator'] != $current_creator )
	{
		$sql = "UPDATE ".$table_prefix."random_banners SET creator='".$_POST['creator']."' WHERE id='".$_POST['banner_id']."'";
		if(! ($result = $db->sql_query($sql)) )	{ message_die(GENERAL_ERROR, "Could not update banner-info!!", "", __LINE__, __FILE__, $sql); }
	}
	if( $_POST['path'] != $current_path )
	{
		$sql2 = "UPDATE ".$table_prefix."random_banners SET path='".$_POST['path']."' WHERE id='".$_POST['banner_id']."'";
		if(! ($result2 = $db->sql_query($sql2)) )	{ message_die(GENERAL_ERROR, "Could not update banner-info!!", "", __LINE__, __FILE__, $sql2); }
	}
	if( $_POST['url'] != $current_url )
	{
		$sql2 = "UPDATE ".$table_prefix."random_banners SET url='".$_POST['url']."' WHERE id='".$_POST['banner_id']."'";
		if(! ($result2 = $db->sql_query($sql2)) )	{ message_die(GENERAL_ERROR, "Could not update banner-info!!", "", __LINE__, __FILE__, $sql2); }
	}
	if( $_POST['alt'] != $current_alt )
	{
		$sql2 = "UPDATE ".$table_prefix."random_banners SET url_hover='".$_POST['alt']."' WHERE id='".$_POST['banner_id']."'";
		if(! ($result2 = $db->sql_query($sql2)) )	{ message_die(GENERAL_ERROR, "Could not update banner-info!!", "", __LINE__, __FILE__, $sql2); }
	}
	$overall = '
	<table width="100%" cellpadding="4" cellspacing="1" border="0">
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><center>'.$lang['Done'].'</center></th>
	  </tr>
	  <tr>
		<td class="row1" width="100%">'.$lang['Updated'].'<b><a href="'.append_sid("admin_banner.$phpEx").'">'.$lang['return'].'</a></b></td>
	  </tr>
	</table>';
}
else if( $_POST['delete'] == $lang['Remove'] )
{
	$sql = "DELETE FROM ".$table_prefix."random_banners WHERE id='".$_POST['banner_id']."'";
	if(! ($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Could not remove banner!!", "", __LINE__, __FILE__, $sql);
	}
	$overall = '
	<table width="100%" cellpadding="4" cellspacing="1" border="0">
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><center>'.$lang['Done'].'</center></th>
	  </tr>
	  <tr>
		<td class="row1" width="100%">'.$lang['Updated'].'<b><a href="'.append_sid("admin_banner.$phpEx").'">'.$lang['return'].'</a></b></td>
	  </tr>
	</table>';
}
else if( $_POST['new'] == $lang['Add'] )
{ //add a new banner:
	//get the id of this new banner:
		//count all previous ones:
		$sql = "SELECT id"
			."		FROM ".$table_prefix."random_banners";
		if(! ($count_banners = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, "Could not count amount of banners!!", "", __LINE__, __FILE__, $sql);
		}
		$number_banners = $db->sql_numrows($count_banners);
		$newid = $number_banners + 1;
	//end getting new id
	if( ($_POST['creator'] != '' ) || ($_POST['path'] != '') ) 
	{
		$sql = "INSERT INTO ".$table_prefix."random_banners(id,creator,path, url, url_hover) VALUES ('".$newid."', '".$_POST['creator']."', '".$_POST['path']."', '".$_POST['url']."', '".$_POST['alt']."')";
		if ( !($db->sql_query($sql)) ) { message_die(GENERAL_ERROR, 'Could not insert new banner!!', '', __LINE__, __FILE__, $sql); }
	}
	$overall = '
	<table width="100%" cellpadding="4" cellspacing="1" border="0">
	  <tr>
		<th width="50%"  class="thHead" colspan="2"><center>'.$lang['Done'].'</center></th>
	  </tr>
	  <tr>
		<td class="row1" width="100%">'.$lang['Updated'].'<b><a href="'.append_sid("admin_banner.$phpEx").'">'.$lang['return'].'</a></b></td>
	  </tr>
	</table>';

}
else //normal page
{
	//get all data:
	$sql = 'SELECT id, creator, path, url, url_hover FROM '.$table_prefix.'random_banners';
	if(! ($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, "Could not obtain banner-info!!", "", __LINE__, __FILE__, $sql);
	}
	//show current banners:
	$overall = '
			<table width="100%" cellpadding="4" cellspacing="1" border="0">
				<tr>
					<th class="thHead" colspan="2"><center>'.$lang['current'].'</center></th>
				</tr>';
	$number_banners = $db->sql_numrows($result);
	//check if there are banners:
	if( $number_banners == '0' )
	{
	    $overall .= '<tr><td class="row1">'.$lang['no_banner'].'</td><td class="row2"></td></tr>';
	}
	else
	{
		$banner_row = array();
		while ($row = $db->sql_fetchrow($result))
		{
		 	$banner_row[] = $row;
		}
		for ($i=0; $i < $number_banners; $i++)
		{
			//now, add for each banner next part:
			$overall .= '<tr><td><form method="post" action="'.append_sid('admin_banner.'.$phpEx).'"><table>';
			$overall .= '<tr><th class="thHead" colspan="2"><center>'.$lang['modify1'] . $banner_row[$i]['id'] . $lang['modify2'].'</center></th></tr>';
			$overall .= '<tr><td class="row2" width="50%">'.$lang['Creator'].'</td><td class="row3" width="50%"><input type="text" name="creator" value="'.$banner_row[$i]['creator'].'" size="75"></td></tr>';
			$overall .= '<tr><td class="row2" width="50%">'.$lang['Path'].'<font size="small">'.$lang['Path_exp'].'</font></td><td class="row3" width="50%"><input type="text" name="path" value="'.$banner_row[$i]['path'].'" size="75"></td></tr>';
			$overall .= '<tr><td class="row2" width="50%">'.$lang['Url'].'</td><td class="row3" width="50%"><input type="text" name="url" value="'.$banner_row[$i]['url'].'" size="75"></td></tr>';
			$overall .= '<tr><td class="row2" width="50%">'.$lang['Alt'].'</td><td class="row3" width="50%"><input type="text" name="alt" value="'.$banner_row[$i]['url_hover'].'" size="75"></td></tr>';
			$overall .= '<input type="hidden" name="banner_id" value="'.$banner_row[$i]['id'].'">';
			$overall .= '<tr><td class="row1" width="100%"><input type="submit" name="update" value="'.$lang['Update'].'"> &nbsp; &nbsp;';
			$overall .= '<input type="submit" name="delete" value="'.$lang['Remove'].'"></td></tr>';
			$overall .= '</table></form></td></tr>';
		}
	}
	//now, show the rows for adding a banner:
	$overall .= '<tr><td><form method="post" action="'.append_sid('admin_banner.'.$phpEx).'"><table>';
	$overall .= '<tr><th class="thHead" colspan="2"><center>'.$lang['add_banner'].'</center></th></tr>';
	$overall .= '<tr><td class="row1" width="50%">'.$lang['Creator'].'</td><td class="row2" width="50%"><input type="text" name="creator" value="" size="75"></td></tr>';
	$overall .= '<tr><td class="row1" width="50%">'.$lang['Path'].'<font size="small">'.$_lang['Path_exp'].'</font></td><td class="row2" width="50%"><input type="text" name="path" value="" size="75"></td></tr>';
	$overall .= '<tr><td class="row1" width="50%">'.$lang['Url'].'</td><td class="row2" width="50%"><input type="text" name="url" value="" size="75"></td></tr>';
	$overall .= '<tr><td class="row1" width="50%">'.$lang['Alt'].'</td><td class="row2" width="50%"><input type="text" name="alt" value="" size="75"></td></tr>';
	$overall .= '<tr><td class="row3" width="100%"><input type="submit" name="new" value="'.$lang['Add'].'"></td></tr>';
	$overall .= '</table></form></td></tr>';
	
	$overall .= '</table>';
}

$template->assign_vars(array(
	'OVERALL' => $overall,
	'TTL' => 'Random Banners-Konfiguration',
	'DESC' => 'Definiera all bannerinformation här.',
));
$template->set_filenames(array(
	'body' => 'admin/banner_config_body.tpl')
);
//
// Generate the page
//
$template->pparse('body');

include('page_footer_admin.' . $phpEx);


?>

Postat: 2006-01-04 10:30
av Holger
Har databas-fältet som texten sparas i fel format/typ kanske?

Postat: 2006-01-05 21:00
av dallas
nu är det löst... så här är det....
har jag fått hjälp med :D

Man kan inte specificera value för <textarea>. Om man har ett textfält är
följande syntax korrekt:

<input type="text" name="field1" value="innehållet i databasen">

Om man däremot har en textarea så måste innethåller som ska skrivas ut i
rutan ligga mellan <textarea> och </textarea>, se nedan för exempel.

<textarea name="field1">
Innehållet i databasen
</texterea>

(får väl åter ge Loopia en eloge för deras bra support)

dallas
Alla tidsangivelser är UTC+02:00 Europe/Stockholm
Sida 1 av 1

Drivs av phpBB® Forum Software © phpBB Limited

Swedish translation by phpBB Sweden © 2006-2027