Miscellaneous Hacks - vbBux / vbPlaza - v4.0.0 - Beta 1

Originally Posted by CMX via CodeTwink

Hopefully this will fix the problem's people are having with the license system now that vbplaza.com is shutdown and re-routing here.

REMEMBER: It is in beta code and may have some bugs, but it seems to be functioning for the most part here on codetwink.com v4.1.5.

UPDATE: I give permission to any and all parties who would like to take over the modification. It would be nice if you could just leave a note in the credits, the original script is based on vbBux / vbPlaza by CMX here at http://www.codetwink.com I just have too many other projects to work on to continue work on this. I apologize for any inconvenience this may have caused.

ALSO: For those still on the older version vBulletin v3.X, I'll try to get the "verification" script back enabled on vbplaza.com so it will at least be able to continue working until you can update to v4.X.

-CMX

Hey Everyone

CMX gave us special permission to allow us to release this vbplaza mod on here

so anyone can fix it if they want

enjoy

this mod allows you to buy things using vbcredit, like change username, steal someone credits and much more

[BirdOPrey5]

Attached is a "VB Plaza Fix" file I put together... It does 1 thing and 1 thing only- creates the "missing" table people are complaining about.

It creates the table specified in this post.

It will only create the table. Uninstalling will NOT remove the table, you will have to do that manually.

I am releasing this without support or even a promise of ANY KIND.

I STRONGLY SUGGEST NO ONE EVEN ATTEMPT TO INSTALL THIS MOD ON A LIVE FORUM. THIS MOD IS A TOTAL MESS AND SHOULD NEVER HAVE BEEN RELEASED. IT IS NOT FINISHED. IF YOU DON'T HAVE PHP AND MYSQL CODING ABILITY YOU SHOULD RUN, NOT WALK, AWAY FROM THIS MOD.

That said, if you are still reading and simply need the table vbplaza_user_history created, install the attached xml file like any other product.

I will answer no questions about this- if it ruins your forum it is your fault, not mine. My first suggestion is to completely ignore this mod, not attempt to install this "fix."

[Digital Jedi]

And to add to that, there are a lot of COMPLETED points modifications available here on vb.org.

[sound33]

Hey staff

these error messages still come up for me on that newer version of vbplaza

so can you guys find someway to contact CMX please


Hey staff

these are the error messages that come up when i use this newer version of vbplaza


Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Registered Users',
`description` = '',
`usertitle` = '',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '12317183',
`genericpermissions` = '1579685063',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '3',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '63',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '62',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '137215',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '191',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '251767',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '65535',
`dbtech_vbshoutpermissions` = '0',
`vbbux_perdailyvisit` = '',
`vbbux_perreferral` = '',
`vbbux_perbirthday` = '',
`vbbux_perprofileview` = '',
`vbbux_perthreadview` = '',
`vbbux_pernewthread` = '',
`vbbux_pernewpost` = '',
`vbbux_pernewpicturepost` = '',
`vbbux_pernewsocialpost` = '',
`vbbux_pernewvisitpost` = '',
`vbbux_peralbumview` = '',
`vbbux_peralbumpicview` = '',
`vbbux_perstickythread` = '',
`vbbux_perpostedchar` = '',
`vbbux_perpostedcharmax` = '',
`vbbux_pergoodrep` = '',
`vbbux_perbadrep` = '',
`vbbux_pernewpoll` = '',
`vbbux_perpollvote` = '',
`vbbux_perthreadrated` = '',
`vbbux_percaladded` = '',
`vbbux_perprofpicadd` = '',
`vbbux_perprofpicsub` = '',
`vbbux_peralbumpicadd` = '',
`vbbux_peralbumpicsub` = '',
`vbplaza_admin_permissions` = '0',
`vbplaza_settings` = '0',
`vbbux_paycheck` = '',
`vbplaza_discount` = '',
`vbplaza_secondarycost` = '',
`vbplaza_primarycost` = ''
WHERE usergroupid=2;

MySQL Error : Unknown column 'vbbux_perdailyvisit' in 'field list'
Error Number : 1054
Request Date : Monday, September 12th 2011 @ 10:35:04 PM
Error Date : Monday, September 12th 2011 @ 10:35:04 PM
Script : http://bobbyautodj.tbrnhost.com/foru....php?do=update
Referrer : http://bobbyautodj.tbrnhost.com/foru...&usergroupid=2
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_item ORDER BY categoryid, displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:36:22 PM
Error Date : Monday, September 12th 2011 @ 10:36:22 PM
Script : http://bobbyautodj.tbrnhost.com/foru...plaza_item.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_category ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_category' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:36:59 PM
Error Date : Monday, September 12th 2011 @ 10:36:59 PM
Script : http://bobbyautodj.tbrnhost.com/foru...a_category.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_gift_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_gift_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:37:59 PM
Error Date : Monday, September 12th 2011 @ 10:37:59 PM
Script : http://bobbyautodj.tbrnhost.com/foru...plaza_gift.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_lottery ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_lottery' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:38:46 PM
Error Date : Monday, September 12th 2011 @ 10:38:47 PM
Script : http://bobbyautodj.tbrnhost.com/foru...za_lottery.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community








Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_purchase_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_purchase_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:39:16 PM
Error Date : Monday, September 12th 2011 @ 10:39:16 PM
Script : http://bobbyautodj.tbrnhost.com/foru...ase.php?do=add
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community











Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_ribbon_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_ribbon_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:39:46 PM
Error Date : Monday, September 12th 2011 @ 10:39:46 PM
Script : http://bobbyautodj.tbrnhost.com/foru...aza_ribbon.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : n/a
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_track_item ORDER BY displayorder;

MySQL Error : Table 'saucerfo_vb4.vbplaza_track_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:40:23 PM
Error Date : Monday, September 12th 2011 @ 10:40:23 PM
Script : http://bobbyautodj.tbrnhost.com/foru...laza_track.php
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community









Database error in vBulletin 4.1.3:

Invalid SQL:
SELECT * FROM vbplaza_item ORDER BY itemid;

MySQL Error : Table 'saucerfo_vb4.vbplaza_item' doesn't exist
Error Number : 1146
Request Date : Monday, September 12th 2011 @ 10:40:53 PM
Error Date : Monday, September 12th 2011 @ 10:40:53 PM
Script : http://bobbyautodj.tbrnhost.com/foru....php?do=verify
Referrer : http://bobbyautodj.tbrnhost.com/foru...dex.php?do=nav
IP Address : N/A
Username : saucerfoot
Classname : vB_Database
MySQL Version : 5.0.92-community


and those are all of the error messages

[Paul M]

Originally Posted by sound33

Hey staff

these error messages still come up for me on that newer version of vbplaza

so can you guys find someway to contact CMX please

No.

This has nothing to do with the staff here. If you continue to waste our time reporting your own thread, I will remove it, and suspend your account.

[sound33]

Hey everyone

I am not a coder like CMX is

but CMX is way to busy with his other projects to continue work on this newer version of vbplaza

so can you guys fix this missing table error for me please

[sound33]

Hey

can someone help me to add in the missing tables on this vbplaza hack please

[sound33]

Hey staff

I am not a coder okay

I have autism and OCD thats means i can't learn how to code and fix mods myself

so can you guys help me please

[sound33]

everyone likes to ignore me all the time for no good reason

all they want me to do is fix up these errors myself

[BirdOPrey5]

Originally Posted by sound33

everyone likes to ignore me all the time for no good reason

all they want me to do is fix up these errors myself

No, we want you to uninstall this mod and not use it. The developer didn't finish this for a reason- and the staff is not here to fix poorly developed mods.

Uninstall and delete this mod, it just doesn't work.

[borbole]

Originally Posted by sound33

Hey everyone

I am not a coder like CMX is

but CMX is way to busy with his other projects to continue work on this newer version of vbplaza

so can you guys fix this missing table error for me please

Originally Posted by sound33

everyone likes to ignore me all the time for no good reason

all they want me to do is fix up these errors myself

It is your choice to install and use that mod and therefore it is your responisbility. But if you are not able to fix this yourself, have you considered hiring someone to look into this for you rather than spamming the whole forum with the same posts? Otherwise wait patiently until someone helps you in the forums. But do not keep continuing posting the same stuff over and over again as it is getting irritating and annoying.