Username & Post Decorations Hack

This hack was an old idea I had a long time ago that I kind of made a hack for, but it was kinda messed up.

What this hack does is allow usernames to be of different colors, with backgrounds and borders on the names. This also works for posts. The hack is done for an actual post, and includes instructions on how to make the decorated name in the Memberlist and on the thread listing. It is also controlled through the Admin CP.

Installing this hack requires
2 New tables (created and populated by a script)
2 New Files
3 File Edits (Optional 5)
3 New Templates
1 Template Edit (Optional 3)

It is relatively easy, nothing too confusing. I will provide as much support as I can. This should work for newer versions, but I'm not positive if it does.

I will post 4 screenshots, 1 of the new posts, 1 of the Admin CP, 1 of the thread listing, and 1 of the Memberlist.

Good luck and have fun!

[5/9] A few bugs fixed, zip updated
[7/8] Zip updated to possibly fix install

[xware]

Nice idea.But you can do a left join function in php files to avoid do more query.

[AnkisethGallant]

I'm not sure how to do whatever you're talking about xware. There's never enough going on on my forums to worry about how many queries, so I've never spent a lot of time looking into how to lower the number of queries I use.

[sabret00the]

would be good if there was a store integration

[AnkisethGallant]

There can be, but I have always used my own hacks, not others, so I can't integrate it into Lesane's.

[redstaing0]

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: SELECT * FROM custom_option WHERE options=1
mysql error: Table 'rxxx_xxx_db.custom_option' doesn't exist

mysql error number: 1146

Date: Saturday 17th of May 2003 02:07:25 PM
Script: http://www.///admin/namecolor.php?screen=available&
Referer: http://admin/index.php?action=nav&cpnavjs=

[AnkisethGallant]

Did you follow instructions for Step 1 and Step 2? If so, it would have installed the custom_option table into your database.

dude this hack doesn't EVEN INSTALL


Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: CREATE TABLE `custom_option` (
`options` int(1) NOT NULL default '0',
`namecolor` int(1) NOT NULL default '0',
`nameback` int(1) NOT NULL default '0',
`nameborder` int(1) NOT NULL default '0',
`postcolor` int(1) NOT NULL default '0',
`postback` int(1) NOT NULL default '0',
`postborder` int(1) NOT NULL default '0'
) TYPE=MyISAM;
INSERT INTO custom_option (options) VALUES ('1')
mysql error: You have an error in your SQL syntax near ';
INSERT INTO custom_option (options) VALUES ('1')' at line 9

mysql error number: 1064

Date: Friday 04th of July 2003 12:09:52 AM
Script: http://board/board/admin/namecolorinstall.php?
Referer:


I CANT EVEN GET THE PIECE OF ++++ TO WORK


Messed up hack

[ff8_bomb]

Im getting this error too.. It makes me mad that no one has yet to reply.. Please reply with the fix to this error or Ill make sure this hack gets quite a low rating..

[AnkisethGallant]

I updated the namecolorinstall.php to do what should fix the problem. If it's still not working let me know.

[ff8_bomb]

Nope.. Still pretty crappy..

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: INSERT INTO custom_option (options) VALUES ('1')
mysql error: Table 'banetwo_forums.custom_option' doesn't exist

mysql error number: 1146