adding a 2nd homepage field for purpose of picture gallery links in the profile

ok here's how far i got! SOMEONE PLEASE HELP ME OUT! i know i'm so close!

now i got it to show up in the edit profile portion of user cp but it throws a database error

that goes like this

PHP Code:

 Database error in vBulletin 2.2.9: 

Invalid SQL: UPDATE user SET birthday='0',signature='',customtitle='1',usertitl  e='The Owner of Dhis Shiz',email='dv6couga@dv6cougar.com',parentemail='',coppauser='0',homepage='http://www.dv6cougar.com/vb/memberpics/dv6cougar/dig.php,gallery='',icq='',aim='dv6cougar',yahoo='',use  rgroupid='6' WHERE userid='1' 
mysql error: You have an error in your SQL syntax near 'dv6cougar',yahoo='',usergroupid='6' WHERE userid='1'' at line 1 

mysql error number: 1064 

Date: Wednesday 12th of March 2003 10:19:24 AM 
Script: <a href="http://www.dv6cougar.com/vb/vb/member.php\" target=\"_blank\">[url]http://www.dv6cougar.com/vb/vb/member.php[/url]</a> 
Referer: 


now what i did was the following

PHP Code:

 //in template modify_profile 

/*************** 

FIND 

************/ 
<tr> 
<td bgcolor="#1C5780"><b><normalfont>Homepage:</normalfont></b></td> 
    <td bgcolor="#1C5780"><normalfont><input type="text" class="bginput" name="homepage" 
    value="$bbuserinfo[homepage]" size="30" maxlength="200"></normalfont></td> 
</tr> 
/************** 

after it place 

***************/ 


<tr><td bgcolor="#1C5780"><b><normalfont>Gallery:</normalfont></b></td><td bgcolor="#1C5780"> 
<normalfont><input type="text" class="bginput" name="gallery" value="$bbuserinfo[gallery]" size="30" maxlength="200"></normalfont></td> 
</tr> 


//IN member.php 
/*************** 

FIND 

***************/ 

$homepage = trim($homepage); 
  if ($homepage) { 
    if (preg_match('#^www\.#si', $homepage)) { 
      $homepage = "http://$homepage"; 
    } else if (!preg_match('#^[a-z0-9]+://#si', $homepage)) { 
      // homepage doesn't match the <a href=\"http://-style\" target=\"_blank\">[url]http://-style[/url]</a> format in the beginning -- possible attempted exploit 
      $homepage = ''; 
    } 
  } 
   
  /******************* 
   
  AFTER IT PLACE 
   
  ********************/ 
   
  $gallery = trim($gallery); 
  if ($gallery) { 
    if (preg_match('#^www\.#si', $gallery)) { 
      $gallery = "http://$gallery"; 
    } else if (!preg_match('#^[a-z0-9]+://#si', $gallery)) { 
      // gallery doesn't match the <a href=\"http://-style\" target=\"_blank\">[url]http://-style[/url]</a> format in the beginning -- possible attempted exploit 
      $gallery = ''; 
    } 
  } 
   
  /************* 
   
  ON THE LINE RIGHT BELOW THE ONE ABOVE FIND IN LINE 
   
  **************/ 
   
  homepage='".addslashes(htmlspecialchars($homepage))." 
   
  /*********** 
   
  AFTER IT INLINE ADD 
   
  **************/ 
   
  ,gallery='".addslashes(htmlspecialchars($gallery))." 

/************* 

FIND 

***************/ 

if ($userinfo[homepage]!="http://" and $userinfo[homepage]!="" ) { 
    $userinfo[homepage]=$userinfo[homepage]; 
  } else { 
    $userinfo[homepage]=""; 
  } 
   
  /************** 
   
  after it place 
   
  **************/ 
    if ($userinfo[gallery]!="http://" and $userinfo[gallery]!="" ) { 
    $userinfo[gallery]=$userinfo[gallery]; 
  } else { 
    $userinfo[gallery]=""; 
  } 


basically what i'm doing is, in member.php for every occurance of homepage i'm adding a gallery portion to it.

i also inserted the gallery field into the user table for my vbulletin board database.

any ideas? what's throwing my error? any other templates i might need to look at?

let me know please

thanks alot! before i had it set up differently, i had not added the last portion i edited in member.php and it would nto throw the db error but not add anything to the db and gallery does not show up in the view profile portion.

so if i go and view profile of me on here it would be have a homepage field and a gallery field, but gallery wouldnt' show up

__________________