Adding Item to Tables

Here is the stupid question of the year, and yes, I'm the one asking it.  But it's for a good cause.  Working on a Transparency option for Dolphin Profiles that will work in all browsers.  I've already seen this work in other sections of a dolphin site and I even have it in certain sections already, now working on implementing it into the profiles customize seciton of the site.  If this works, then we're going to have an awesome toy as a part of Dolphin.  I am talking about full resolution in IE, FF, Safari, Opera and so on browsers. 

 

Here's what I need to do, is add a section to the ProfileSettings Table but it keeps denying it every time I try.  So here you guys go.  Looking for how to add this via phpMyAdmin -> SQL

 

And yes, I know how to get to the section before someone gives me a smart answer... :))

 

ADD `Opacity` INT( 3 ) NOT NULL;

 

If we can get this into the ProfileSettings Table, then it's going to fast forward this little projects.  And yes, this item will be free to all to put on your sites.  It's a community built item that I figured out mostly by scratching through the files looking for other stuff.  It utilizes the genProfileCSS inside the templates/base/BxBaseProfileView.php file.  I know, we've been trying this forever utilizing the templates/tmpl_{tmpl}/css/profile_view.css file and it doesn't work there, that's because it's being called wrong.  And yes, I know others have tried this with profile customizing mods, but I actually do have it working on other parts of my sites (not the profiles yet, but other sections that members can customize) and it is working seamlessly.  I'll need this in a manner where it can be inputted into a file.sql file and run by just about anybody, so who has the skill on this part, my SQL sucks personally.

Quote · 13 Aug 2009

I was able to do it with this.


ALTER TABLE `ProfilesSettings` ADD `Opacity` INT( 3 ) NOT NULL ;


https://www.deanbassett.com
Quote · 13 Aug 2009

Thanks Deano, for some reason my brain was farting out on it.  Not sure why, but it did.  Appreciate it a million. 

Quote · 13 Aug 2009

Brain farts happen to all of us.

https://www.deanbassett.com
Quote · 13 Aug 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.