PDA

View Full Version : adding database tables help


sound33
09-12-2011, 09:36 AM
Hey staff

I do not know how to add tables on my phpadmin area on my hosting account at all

so can you guys help me with this please

DonosOdD
09-12-2011, 09:52 AM
This forum gives support to the vBulletin software only. Contact your host provider for more help.

And, you're in the wrong section.

BirdOPrey5
09-12-2011, 11:08 AM
You do not need to add new tables to your database manually during the normal course of vBulletin operation. vBulletin will create the tables you need during the install. If you don't know what you're doing this is definitely not something you should attempt.

sound33
09-12-2011, 11:09 AM
Hey BirdoPrey5

I am trying to add these tables to make vbplaza v4.0.0 beta to work

vbplaza_user_history

ALTER TABLE `vbplaza_user_history`
ADD `historyid` INT UNSIGNED NOT NULL AUTO_INCREMENT,
ADD `itemid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `itemname` VARCHAR(250) NOT NULL DEFAULT '',
ADD `userid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `username` VARCHAR(100) NOT NULL DEFAULT '',
ADD `finalcost` DECIMAL(30,5) NOT NULL DEFAULT '0.00000',
ADD `dateline` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `expires` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `visible` INT UNSIGNED NOT NULL DEFAULT '1',
ADD `attachmentid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `avatarid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `forumid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `fromuserid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `fromusername` VARCHAR(100) NOT NULL DEFAULT '',
ADD `giftid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `lotteryid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `postid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `purchaseid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `ribbonid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `styleid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `threadid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `touserid`INT UNSIGNED NOT NULL DEFAULT '0',
ADD `tousername` VARCHAR(100) NOT NULL DEFAULT '',
ADD `usergroupid` INT UNSIGNED NOT NULL DEFAULT '0',
ADD `reason` MEDIUMTEXT NOT NULL,
ADD PRIMARY KEY (historyid)

BirdOPrey5
09-12-2011, 11:12 AM
A mod will create the tables it needs when you install it. But in either case questions concerning a specific mod must be made in the mod thread itself, not in the general support forums. Even if a mod is marked as supported, you may be on your own if no one is currently supporting it.

sound33
09-12-2011, 02:13 PM
Hey Staff

CMX is no longer going to work on vbplaza anymore

so can you staff members please help me with this vbplaza 4.0.0 mod please

Lynne
09-12-2011, 04:46 PM
Hey Staff

CMX is no longer going to work on vbplaza anymore

so can you staff members please help me with this vbplaza 4.0.0 mod please
No, we cannot. You need to ask for help in the modification thread. If nobody helps you, then you have the option to not install the modification. But support is ONLY given in the modification thread, not out in these main forums.

sound33
09-12-2011, 04:49 PM
Hey everyone

No 1 made a modification thread yet for this newer version of vbplaza

so how can i post for help on a vbplaza modification thread thats not there?

Lynne
09-12-2011, 04:50 PM
Where did you download the modification from ? That is where you need to post for help.

sound33
09-12-2011, 04:52 PM
Hey Lynne

I downloaded that mod from CMX codetwink board

but CMX codetwink board is 100% dead without any staff signing into that board anymore at all

Lynne
09-12-2011, 04:52 PM
Well, that is where you need to ask for support. Not here, sorry.

Like I said, if you don't get support, just don't install it! Especially something that major because you are just setting yourself up for problems later on.

sound33
09-12-2011, 05:08 PM
Hey everyone

I like vbplaza alot, but that codeetwink board is 100% dead

there are no more staff on it

and no 1 ever post there anymore

i just need help to add some vbplaza tables okay

thanks

nhawk
09-12-2011, 05:24 PM
I don't think you get the reason that nobody will help you with this. So, let me try to explain it..

The product is obsolete and unsupported. You've stated that yourself.

If someone helps you install it, and something goes wrong, who will help you then?

Add-ons are not supported by vBulletin.org. They are supported by the author.

In simple terms, if the author no longer supports an add-on then it is dead and should not be installed because there's nobody that can help you with it if things go bad.

sound33
09-12-2011, 05:28 PM
Hey everyone

Yes i know that

but i still love this product alot

all that needs fixing is the missing, vbplaza item tables, vbplaza gift table, vbplaza ribbons tables and the vbplaza lotterly tables and thats all

and then the vbplaza will work 100%

all the owner forgot to do was add in those table when he first released this vbplaza product last week

thanks

BirdOPrey5
09-12-2011, 06:07 PM
Hey everyone

Yes i know that

but i still love this product alot

all that needs fixing is the missing, vbplaza item tables, vbplaza gift table, vbplaza ribbons tables and the vbplaza lotterly tables and thats all

and then the vbplaza will work 100%

all the owner forgot to do was add in those table when he first released this vbplaza product last week

thanks

If the author was active on this project last week just tell him what he needs to fix and wait for an official fix.