Adding new Fields

[Seifer]

Well, I'm not a php genius, but I found I could just copy every instance of yahoo in admin/functions.php, admin/user.php, and member.php and change all things saying "yahoo" to "msn" and just add an msn row to the user table in phpMyAdmin. That worked perfectly. But since I don't really like custom profile fields, I wanted to input my battle arena stuff (like right weapon) in it's own field, just like MSN. So, I tried it again, duplicating all the yahoo fields, then replacing yahoo with right and then made a right row. But this time, when I put in the <*img="balh"*> code, I get a MySQL error.

Does anyone know why that is? I figured it was because you can't put <*""*> tags in a varchar field, but I really don't know.

[TeddyBare69]

My guess on this would be the quotes.
if you put <*img=src\"balh\"*> the database should be happier. :D

[Seifer]

I see...I'll try that out.

[Seifer]

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT user.userid,username,usergroupid,birthday,email,pa rentemail,right,coppauser,homepage,icq,aim,yahoo,s ignature,usertitle,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastpost) AS lastpost,posts,ipaddress,userfield.* FROM user,userfield WHERE 1=1 AND INSTR(LCASE(username),'josh')>0 AND userfield.userid=user.userid ORDER BY username LIMIT 0,300
mysql error: You have an error in your SQL syntax near 'coppauser,homepage,icq,aim,yahoo,signature,userti tle,FROM_UNIXTIME(joindate) AS ' at line 1

mysql error number: 1064

Date: Monday 12th of August 2002 09:35:37 PM
Script: http://plasmicgaming.com/forum/forum/admin/user.php
Referer: http://plasmicgaming.com/forum/admin/user.php?action=modify

And yes, I added the table row in user.