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

Screenshot of the actual posts

Screenshot of the Admin CP

Screenshot of the Thread Listing

Screenshot of the Member List.

That's all, have fun!

On step 3:

// do ip adresses

should be:

// do ip addresses

:)

I installed it but no matter who changes "their" colors, it changes everyones.

If I choose my colors etc for my username, everyones username will appear like that

Fixed it...

************
** Step 3 **
************
Edit the file admin/function.php
Find the following line:

// do ip adresses

And add before it:

global $DB_site;
$custom = $DB_site->query_first("SELECT * FROM custom WHERE userid=$bbuserinfo[userid]");

Save the file and upload it to your admin folder.

SHOULD BE:

************
** Step 3 **
************
Edit the file admin/function.php
Find the following line:

// do ip addresses

And add before it:

global $DB_site;
$custom = $DB_site->query_first("SELECT * FROM custom WHERE userid=$post[userid]");

Save the file and upload it to your admin folder.

I rewrote a little bit of it to do this...

1.) Users to change there colors, etc via the "Edit Profile"
2.) Admins can view/edit each users Colors via the Admin CP.
3.) Few bugs I found fixed

With the authors permission I will post it.

Yes, please post the stuff. I can login to phpMyAdmin so doing the 2nd thing was useless for me. I'll fix the zip file to change the instructions for the bug fixes, thanks guys.

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

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.

would be good if there was a store integration

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

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=

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

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..

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

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

The database for the "custom_option" gets miss spelled with the auto installer....Just go into phpmyadmin and edit it manually or just use the file im attaching...

lol gotta love the keyboard tough guys....

My only problem now is getting the admin options to actually save....They keep going back to defaults..