I installed some hacks recently and now ...

I'm getting errors int he admin control panel when I try to edit a users information ::

PHP Code:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user SET birthday='1979-04-04',options='15',usergroupid='9',username='GirlzStarLight',email='starlight@girlzclan.com',styleid='1',parentemail='',coppauser=0,homepage='http://www.starlightsdream.com',icq='81561064',aim='GirlzStarL1ght',yahoo='Girlz_StarLight',signature='
[URL=http://www.starlightsdream.com]starlightsdream[/URL] - [URL=http://www.anythingbutleet.com]anythingbutleet[/URL] - [URL=http://www.girlzclan.com]girlzclan[/URL]',adminemail=1,showemail=1,invisible=0,usertitle='femme fatale',customtitle=0,joindate=UNIX_TIMESTAMP('2002-10-22 01:46:32'),cookieuser=1,nosessionhash=0,daysprune='-1',lastvisit=UNIX_TIMESTAMP('2002-11-07 04:01:26'),lastactivity=UNIX_TIMESTAMP('2002-11-07 04:50:16'),lastpost=UNIX_TIMESTAMP('2002-11-07 03:24:18'),posts='645',profileview='',,timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0',ipaddress='',award='1',pmpopup=IF(pmpopup=2 AND 1=1,pmpopup,'1') WHERE userid=1
mysql error: You have an error in your SQL syntax near 'timezoneoffset='-5',emailnotification=0,receivepm='1',emailonpm='0',ipaddress=''' at line 1

mysql error number: 1064

Date: Thursday 07th of November 2002 04:50:21 AM
Script: [url]http://www.girlzclan.com/forums/forums/admin/user.php[/url]
Referer: [url]http://www.girlzclan.com/forums/admin/user.php?action=edit&userid=1[/url] 

The hacks I installed were
Memberlist is in color
age in post bit
whos your buddy
Users last ten posts will be displayed in their user profile
Your profile, will show how many times it has been viewed..


I'm clueless as to what went wrong ..

[Erwin]

Which hack did you install that involved hacking admin/user.php?

Try to look over that hack's instructions again and make sure you have followed it correctly.

[Xenon]

look at the errormsg:

",profileview='',,timezoneoffset='-5',"

as you can see there is one , to much, remove one before timezoneoffset

[girlzclan]

omg I love you thank you soo much xox

[Xenon]

you're welcome