The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 07-15-2000

Yes, its finally here.

No longer will you need to create duplicate templates just to set a few custom colors on the forum level.

I don't have a use myself, but it was heavily requested, so I figured what the heck! Yes Nathan, this will work great with the InfoGrames boards

There are nicers ways of going about this than what I did, but this required the least table modification and code changing, so it should be fine.

This was lightly tested on my test board, and all seemed to work well, but no guarentees. I suggest you backup global.php (main directory, not admin) before making any changes.

Here's how it works:

You go to the style page (styles.php) and it brings up a list of all forums. To the right of those forums are numbers, and they all are equal to 0. Those numbers represent the number of custom style settings represented in that specific board. So if you only change the <body> tag, that number will display 1. If you customize it completely, the number will be higher.

Also, since some forums might only require small changes, those fields which you don't specify will use the installation default (what you set in the existing styles section).

Yea, the interface is pretty ugly and the code isn't much better...but its fast, and it works.

Everything else will be improved upon with time, as long as this thread is as popular as Ed's are!

Directions:

execute the following mysql command:

Code:

ALTER TABLE replacement ADD forumid SMALLINT (5) DEFAULT '0' not null;

if you don't know how, then create replacementfid.php: (in /forum, or /forum/admin)

Code:

<?
require ("global.php");
if (mysql_query("ALTER TABLE replacement ADD forumid SMALLINT (5) DEFAULT '0' not null")) {
print "Success!";
} else {
print "Failed!";
}
?>

open global.php: (in /forum, not /forum/admin)
look for:

Code:

// load vars
$vars=$DB_site->query("SELECT * FROM replacement ORDER BY replacementid DESC");

delete up until:

Code:

// ###################### Start standarderror #######################

place in that spot:

Code:

// ###################### Start dovars #######################
function dovars($vartext,$fid=0) {

  // parses replacement vars

  global $DB_site;
  global $forumid;
  global $vars;

  // load vars

$cusvars=$DB_site->query("SELECT * FROM replacement where forumid = $forumid ORDER BY replacementid DESC");

  $newtext=$vartext;

  $DB_site->data_seek(0,$cusvars);

  $forumspec = "";

  while ($cusvar=$DB_site->fetch_array($cusvars)) {
    $newtext=str_replace($cusvar[findword],$cusvar[replaceword],$newtext);
    $forumspec .= "and findword != '$cusvar[findword]' ";
  }

$vars=$DB_site->query("SELECT * FROM replacement where forumid = 0 $forumspec ORDER BY replacementid DESC");

  $DB_site->data_seek(0,$vars);
  while ($var=$DB_site->fetch_array($vars)) {
    $newtext=str_replace($var[findword],$var[replaceword],$newtext);
  }

  return $newtext;
}

save and close.

create styles.php: (in /forum/admin, not /forum)

update: it appears, since I'm using replacement variables in the code, that this vBulletin installtion is actually replacing the code on the fly. to get the code for styles.php, please go to the following url:
http://unreal2.net/styles.phps

start forum/admin/styles.php from your web browser

Easy enough? Of course...

No demo, since I don't have a use for it, but if Nathan (hint hint) or someone else could put it into use to demonstrate, that'd be great!

[Edited by Stallion on 07-15-2000 at 02:48 AM]

#22 07-19-2000, 02:06 AM

I would really appreciate that, thanks. Please keep me posted on any progress you make. To the people who plan on installing this hack, I strongly recommend doing it on a test board, in its current state it can easily whack your vb.

Goldenboy

#23 07-20-2000, 10:15 PM

darn. And I was just about to leap.

#24 07-21-2000, 01:37 AM

Quote:

Originally posted by Stallion
The authentication page is currently broken, I'll fix it when I have some time. There's no real secret goodies inside it, it was more of a tech test ;-)

And about the above hack, I'll take a look at the problems later tonight (but I'm currently busy with some work, atm(.

Stay tuned.

Talk to Ed, he emulated your script

Speaking of which so did I (with some help from ed for the members area stuff) but I'm sure his is alot better, seeing as how I'm new to PHP and all

#25 07-27-2000, 08:41 PM

Has anyone been able to fix this function yet? I'd really like to deploy this hack, but can't.

TIA,

Illout.

#26 07-27-2000, 10:17 PM

Yes, its finally updated. :-)

Directions:

execute the following mysql command: (if you've already done this in previous installation attempts, don't do it again!)

Code:

ALTER TABLE replacement ADD forumid SMALLINT (5) DEFAULT '0' not null;

if you don't know how, then create replacementfid.php: (in /forum, or /forum/admin)

Code:

<?
require ("global.php");
if (mysql_query("ALTER TABLE replacement ADD forumid SMALLINT (5) DEFAULT '0' not null")) {
print "Success!";
} else {
print "Failed!";
}
?>

open global.php: (in /forum, not /forum/admin)
look for:

Code:

// load vars
$vars=$DB_site->query("SELECT * FROM replacement ORDER BY replacementid DESC");

delete up until:

Code:

// ###################### Start standarderror #######################

place in that spot:

Code:

// ###################### Start dovars #######################
function dovars($vartext,$fid=0) {

  // parses replacement vars

  global $DB_site;
  global $forumid;
  global $vars;

  $forumspec = "";

if ($forumid) {
$cusvars=$DB_site->query("SELECT * FROM replacement where forumid = $forumid ORDER BY replacementid DESC");

  $newtext=$vartext;

  while ($cusvar=$DB_site->fetch_array($cusvars)) {
    $newtext=str_replace($cusvar[findword],$cusvar[replaceword],$newtext);
    $forumspec .= "and findword != '$cusvar[findword]' ";
  }
}

$replacevars=$DB_site->query("SELECT * FROM replacement where forumid = 0 $forumspec ORDER BY replacementid DESC");

  $DB_site->data_seek(0,$replacevars);
  while ($var=$DB_site->fetch_array($replacevars)) {
    $newtext=str_replace($var[findword],$var[replaceword],$newtext);
  }

  return $newtext;
}

save and close.

create styles.php: (in /forum/admin, not /forum)

update: it appears, since I'm using replacement variables in the code, that this vBulletin installtion is actually replacing the code on the fly. to get the code for styles.php, please go to the following url:
http://unreal2.net/styles.phps (make sure to refresh, this code has been updated)

new step - open up forum/index.php and look for:

Code:

  eval("echo dovars(\"".gettemplate("forumhome")."\");");

directly above it, place:

Code:

  $forumid = "";

start forum/admin/styles.php from your web browser

This _should_ fix all of the problems people were having

Please try it out and let me know! Thanks,

[Edited by Stallion on 07-30-2000 at 08:48 PM]

#27 07-30-2000, 05:50 PM

Stallion:

I've got it in and working. All forums can have custom styles and that works fine. However, I'm still getting the following error on the main forum page, and any page (member list, search, etc.) that is not a specific forum listed in styles.php - I CAN access those pages now, which is a major improvement over the last version

The error is:

Warning: 0 is not a MySQL result index in admin/db_mysql.php on line 82

It doesn't seem to effect operation at all, but I'm curious as to whether or not it's fixable.

Thanks. I really appreciate all the time and effort that's gone into this hack.

#28 07-30-2000, 11:51 PM

I updated the dovars section (where you replaced existing global.php code), so you can try that code. The weird thing is, it doesn't seem to work locally, but it *should*.

I don't get the error you reported, so the new update just might work.

#29 07-31-2000, 03:08 PM

Yeah, I'm using the new code. It definitely works better than before. One other issue that's cropped up is that running a search returns results using a variety of color schemes. It's pretty funny actually.

Anyway, the hack worked well enough for me to launch the new software. It's still got some rough edges, but I'm working on them.

If you want to see the errors stop by http://illout.com/forums/ the search thing is pretty funny.

Once again, thanks for the hack. It's a lifesaver when you've got lots of forums with custom l&f's.

[Edited by illout on 07-31-2000 at 12:08 PM]

#30 08-21-2000, 12:02 AM

To get rid of the error I was getting, I made the following change to the hack above:

Instead of

$forumid = "";

I changed it to

$forumid = "1";

and that did it for the index page. However, I'm having to prepend that line before every echo statement in member.php, memberlist.php, search.php, etc.

Anyone know a way I can do this globally?

Any help appreciated.

#31 01-14-2001, 12:28 PM

can someone say me where i can find the styles.php?
the link above don't work

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04191 seconds Memory Usage 2,289KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (12)bbcode_code (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!