[Phpbb-checkins] CVS: phpBB2/admin admin_smilies.php,1.16,1.17

[Paul S. O. <ps...@us...>]

Update of /cvsroot/phpbb/phpBB2/admin
In directory usw-pr-cvs1:/tmp/cvs-serv16402/admin

Modified Files:
	admin_smilies.php 
Log Message:
Guess what? ... yep, it's those \' again

Index: admin_smilies.php
===================================================================
RCS file: /cvsroot/phpbb/phpBB2/admin/admin_smilies.php,v
retrieving revision 1.16
retrieving revision 1.17
diff -C2 -r1.16 -r1.17
*** admin_smilies.php	2001/11/20 14:48:42	1.16
--- admin_smilies.php	2001/12/24 13:30:34	1.17
***************
*** 152,159 ****
  					{
  						$sql = "UPDATE " . SMILIES_TABLE . " 
! 									SET smile_url = '$smile_data[0]',
! 										emoticon = '$smile_data[1]'
! 									WHERE code = '$smile_data[$j]'";
! 						
  					}
  					else
--- 152,157 ----
  					{
  						$sql = "UPDATE " . SMILIES_TABLE . " 
! 							SET smile_url = '" . str_replace("\'", "''", $smile_data[0]) . "', emoticon = '" . str_replace("\'", "''", $smile_data[1]) . "' 
! 							WHERE code = '" . str_replace("\'", "''", $smile_data[$j]) . "'";
  					}
  					else
***************
*** 164,176 ****
  				else
  				{
! 					$sql = "INSERT INTO " . SMILIES_TABLE . " (
! 									code,
! 									smile_url,
! 									emoticon )
! 								VALUES(
! 									'$smile_data[$j]',
! 									'$smile_data[0]',
! 									'$smile_data[1]')";
! 						
  				}
  
--- 162,167 ----
  				else
  				{
! 					$sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon)
! 						VALUES('" . str_replace("\'", "''", $smile_data[$j]) . "', '" . str_replace("\'", "''", $smile_data[0]) . "', '" . str_replace("\'", "''", $smile_data[1]) . "')";
  				}
  
***************
*** 411,415 ****
  			//
  			$sql = "UPDATE " . SMILIES_TABLE . "
! 				SET code = '$smile_code', smile_url = '$smile_url', emoticon = '$smile_emotion'
  				WHERE smilies_id = $smile_id";
  			$result = $db->sql_query($sql);
--- 402,406 ----
  			//
  			$sql = "UPDATE " . SMILIES_TABLE . "
! 				SET code = '" . str_replace("\'", "''", $smile_code) . "', smile_url = '" . str_replace("\'", "''", $smile_url) . "', emoticon = '" . str_replace("\'", "''", $smile_emotion) . "'
  				WHERE smilies_id = $smile_id";
  			$result = $db->sql_query($sql);
***************
*** 441,445 ****
  			//
  			$sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon)
! 				VALUES ('$smile_code', '$smile_url', '$smile_emotion')";
  			$result = $db->sql_query($sql);
  			if( !$result )
--- 432,436 ----
  			//
  			$sql = "INSERT INTO " . SMILIES_TABLE . " (code, smile_url, emoticon)
! 				VALUES ('" . str_replace("\'", "''", $smile_code) . "', '" . str_replace("\'", "''", $smile_url) . "', '" . str_replace("\'", "''", $smile_emotion) . "')";
  			$result = $db->sql_query($sql);
  			if( !$result )