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

[TheLastSuperman]

I'm not seeing permission of this posted anywhere on CMX's site, his last post as of today via a search as a guest on his site was 09-08-2011 @ 03:19 AM. I do not see it posted in the thread on his site I linked to either?

https://vborg.vbsupport.ru/showthread.php?t=270028
http://forums.codetwink.com/showthre...eta-1-Download Edit: <-- It's within his post, edited and added by CMX.

[S]I will need to see something from CMX himself or a post we can view i.e. guest can view and confirm you have been given permission.[/S] *Confirmed.

[Digital Jedi]

Originally Posted by sound33

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

It doesn't look like any database tables were created. Did you install this product through your Admin CP?

[sound33]

Hey digitaljedi

yes i did install this through my admin cp

why are you asking

[goxy63]

Whats this mod for, no short description in first post...?

[sound33]

Hey everyone

description updated

enjoy

[Digital Jedi]

Originally Posted by sound33

Hey digitaljedi

yes i did install this through my admin cp

why are you asking

Basically, the errors are saying none of those tables exist. They should have been created upon import. I won't have an opportunity to test this, but I would be interested to know if anyone else had this error.

[sound33]

Hey Digital Jedi

when i uninstalled and re installed this product again

the tables still did not get added

so what could be wrong then

[Digital Jedi]

Originally Posted by sound33

Hey Digital Jedi

when i uninstalled and re installed this product again

the tables still did not get added

so what could be wrong then

Are you the only one having this problem, that you know of? Have you looked at all the documentation that came with the mod? Like I said, I won't be able to test it out. But make sure you've followed any special instructions that came with the modification.

[sound33]

Hey Digital Jedi

the 1 thing i did not do was upgrade my board to fix the problem

do you think that will fix the problem then