Nah, only change to EXISTING tables is a custom field (formprefix)in the forum table and (formid) in the thread table.

All the custom data is stored in your OWN table called (formprefix).
I then use code like you used above to convert database fields into PHP variables.

I've had a couple variations on this code, and the original did what you're suggesting - pack the data. But, on my site, I wrote a custom search engine for filtering/displaying the custom table. It can't be searched by vBulletin, but it's still a pretty clean interface, IMHO.

My search: http://www.noows.com/eqprofiles.php

Bit of SQL for custom table:

CREATE TABLE eqchar (
id int(11) NOT NULL auto_increment,
text_name varchar(60) NOT NULL default '',
sel_server varchar(30) NOT NULL default '',
text_guild varchar(100) default '',
sel_religion varchar(20) default '',
num_level smallint(8) default '0',
sel_class varchar(15) NOT NULL default '',
sel_race varchar(15) NOT NULL default '',
sel_sex varchar(8) default '',
num_hp int(11) NOT NULL default '0',
num_ac int(11) NOT NULL default '0',
num_atk int(11) NOT NULL default '0',

The text_, sel_, and num_ prefixes determine how I handle/display/basic error check the data. 'eqchar' is my formprefix for forumid 84 & 69. Every thread in those forums then references an 'id' in the 'eqchar' table. Clear as mud? =)

Sounds:D and I look forward to it.

Very Very Cool Zamtil.

Just One question, when can we get our hands on this?

:D

Any word on this release yet....I'm very anxious. :)

Heyas Zamtil...just wanted to check in with you to see if you had decided on releasing this one bro. Great work :)

Hey bro, release this already, it works like a champ on your site. :)

any news? would love to see this released :)

:water

Zamtil,

This is exactly the thread Ive been looking for. I also have an EQ guild site, and am VERY interested in this hack. Can you please share this hack? If so, Id be very grateful.

Venti
The Honorable Few
~Veeshan

www.thehonorablefew.com/forums
Venti@thehonorablefew.com