vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Username & Post Decorations Hack (https://vborg.vbsupport.ru/showthread.php?t=52726)

AnkisethGallant 05-07-2003 10:00 PM

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

AnkisethGallant 05-08-2003 05:07 PM

Screenshot of the actual posts

AnkisethGallant 05-08-2003 05:07 PM

Screenshot of the Admin CP

AnkisethGallant 05-08-2003 05:07 PM

Screenshot of the Thread Listing

AnkisethGallant 05-08-2003 05:07 PM

Screenshot of the Member List.

That's all, have fun!

mADmAX` 05-09-2003 01:53 PM

On step 3:

// do ip adresses

should be:

// do ip addresses

:)

mADmAX` 05-09-2003 02:09 PM

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

mADmAX` 05-09-2003 02:34 PM

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.

mADmAX` 05-09-2003 03:55 PM

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.

AnkisethGallant 05-09-2003 11:19 PM

Quote:

Today at 09:55 AM mADmAX` said this in Post #9
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.

xware 05-10-2003 06:49 AM

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

AnkisethGallant 05-10-2003 08:40 PM

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 05-10-2003 10:42 PM

would be good if there was a store integration

AnkisethGallant 05-10-2003 10:46 PM

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

redstaing0 05-17-2003 11:09 AM

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 05-18-2003 04:46 PM

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

Hostc 07-04-2003 04:07 AM

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 07-08-2003 06:46 PM

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 07-08-2003 07:14 PM

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

ff8_bomb 07-10-2003 08:15 PM

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

Haddy 09-01-2003 05:09 AM

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


All times are GMT. The time now is 05:02 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01178 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (21)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete