The Arcive of Official vBulletin Modifications Site.

uCash & uShop old support and thank you thread · **Released**: 04-12-2004

/me Installs. I'm the first for the most aniticipated hack!!1

Link14716 · #92 04-12-2004, 09:57 PM

Quote:

Originally Posted by Logik

#1146 - Table 'logik_vb3.utt_store_act' doesn't exist

And you did the HTL install? Because it looks like some of the queries were not ran, but I know those queries are in the HTL.

Logik · #93 04-12-2004, 09:57 PM

uhm, well gimme the sql i can run to create the table.

Logik · #94 04-12-2004, 09:58 PM

ortell me the tables it needs, and imma tell u waht ones i dont have

Seany · #95 04-12-2004, 09:58 PM

I can wait I guess. I just installed the Arcade which is keeping members busy, so even if 1.00 will be out in a week or two, I can wait. Thanks for the work man.

lAndyl · #96 04-12-2004, 10:00 PM

Psh... i was the first to install just didnt post i hit the install button secound must have been link for first or something, anyway couple things someone spelled quantity wrong. Also my most action sold links dont seem to work and the glow username.

Link14716 · #97 04-12-2004, 10:00 PM

Quote:

Originally Posted by Logik

ortell me the tables it needs, and imma tell u waht ones i dont have

Here are the queries that are ran in a nutshell.

PHP Code:


			
$query['new'][] = 'CREATE TABLE '.TABLE_PREFIX.'utt_store_action (

  `actionid` int(5) NOT NULL auto_increment,

  `shortname` varchar(255) NOT NULL default \'\',

  `name` varchar(255) NOT NULL default \'\',

  `description` text NOT NULL,

  `displayorder` int(10) NOT NULL default \'0\',

  `cost` varchar(20) NOT NULL default \'\',

  `tax` varchar(20) NOT NULL default \'\',

  `sold` bigint(10) NOT NULL default \'0\',

  `defaultquantity` bigint(10) NOT NULL default \'0\',

  `quantity` bigint(10) NOT NULL default \'0\',

  `allowedgroups` varchar(255) NOT NULL default \'\',

  `deniedgroups` varchar(255) NOT NULL default \'\',

  `filelocation` varchar(255) NOT NULL default \'\',

  `imagelocation` varchar(255) NOT NULL default \'\',

  `showinstore` tinyint(1) NOT NULL default \'0\',

  `active` tinyint(1) NOT NULL default \'0\',

  `asvs` TEXT NOT NULL,

  PRIMARY KEY  (`actionid`)

) TYPE=MyISAM AUTO_INCREMENT=18';



$query['new'][] = 'CREATE TABLE '.TABLE_PREFIX.'utt_store_history (

  `historyid` bigint(10) NOT NULL auto_increment,

  `userid` bigint(10) NOT NULL default \'0\',

  `timestamp` BIGINT( 15 ) NOT NULL ,

  `actionid` bigint(10) NOT NULL default \'0\',

  `action` varchar(250) NOT NULL default \'\',

  `normalcost` varchar(20) NOT NULL default \'\',

  `discount` varchar(20) NOT NULL default \'\',

  `tax` varchar(20) NOT NULL default \'\',

  `points` varchar(20) NOT NULL default \'\',

  `totalcost` varchar(20) NOT NULL default \'\',

  `touserid` bigint(10) NOT NULL default \'0\',

  `touser` varchar(250) NOT NULL default \'\',

  `newtitle` varchar(250) NOT NULL default \'\',

  PRIMARY KEY  (`historyid`)

)';



$query['new'][] = 'CREATE TABLE '.TABLE_PREFIX.'utt_store_bank (

  `rowid` int(10) NOT NULL auto_increment,

  `userid` int(10) NOT NULL default \'0\',

  `inserttime` bigint(20) NOT NULL default \'0\',

  `updatetime` bigint(20) NOT NULL default \'0\',

  `amount` varchar(20) NOT NULL default \'\',

  PRIMARY KEY  (`rowid`)

) TYPE=MyISAM AUTO_INCREMENT=1';



$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'forum

 ADD `uttpoints_perthread` varchar(20)  NOT NULL ,

 ADD `uttpoints_perreply` varchar(20) NOT NULL ,

 ADD `uttpoints_perview` varchar(20) NOT NULL';

 

$query['new'][] = 'UPDATE '.TABLE_PREFIX.'forum SET uttpoints_perthread=\'1\', uttpoints_perreply=\'1\', uttpoints_perview=\'1\'';

 

$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'user ADD `uttpoints` varchar( 20 ) NOT NULL ,

 ADD `uttstore_history` MEDIUMTEXT NOT NULL ,

 ADD `uttstore_glow` VARCHAR( 20 ) DEFAULT \'0\' NOT NULL ,

 ADD `uttstore_usernamecolor` VARCHAR( 20 ) DEFAULT \'0\'  NOT NULL ,

 ADD `uttstore_boldusername` TINYINT( 1 ) NOT NULL ,

 ADD `uttstore_italicsusername` TINYINT( 1 ) NOT NULL ,

 ADD `uttstore_bankdata` TEXT NOT NULL ,

 ADD `uttstore_bankqueue` TEXT NOT NULL';

 

$query['new'][] = 'ALTER TABLE '.TABLE_PREFIX.'usergroup ADD `uttstore_discount` VARCHAR( 20 ) DEFAULT \'0\' NOT NULL';

 

$query['new'][] = 'UPDATE '.TABLE_PREFIX.'usergroup SET uttstore_discount=\'0\'';

 

$query['new'][] = 'INSERT INTO '.TABLE_PREFIX.'utt_store_action

    (actionid, shortname, name, description, displayorder, cost, tax, sold, defaultquantity, quantity, allowedgroups, deniedgroups, filelocation, imagelocation, showinstore, active, asvs)

VALUES

    (\'1\', \'donate\', \'Donate\', \'Spread some love to your fellow man and donate some money to another user.\', \'10\', \'0\', \'2\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.donate.php\', \'images/uttstore/donate.gif\', \'0\', \'1\', \'\'),

    (\'2\', \'changetitle\', \'Change Custom Title\', \'Here, you can change your custom title to something else. Stand out from the crowd and buy one!\', \'20\', \'500\', \'5\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.changetitle.php\', \'images/uttstore/changetitle.gif\', \'1\', \'1\', \'\'),

    (\'3\', \'changeothertitle\', \'Change Other User\\\'s Custom Title\', \'Someone making your life hell and want to get abit of payback? Rember that they can find out who did it ;)\', \'30\', \'1000\', \'10\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.changeothertitle.php\', \'images/uttstore/changeothertitle.gif\', \'1\', \'1\', \'\'),

    (\'4\', \'changeusername\', \'Change Username\', \'With this action, you may change your username to anything you\\\'d like! (Within reason...)\', \'40\', \'1000\', \'7\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.changeusername.php\', \'images/uttstore/changeusername.gif\', \'1\', \'1\', \'\'),

    (\'5\', \'glowusername\', \'Glowing Username\', \'With this action, you can buy yourself a pretty glowing username that will appear on your posts. (NOTE: Glow is Internet Explorer only!)\', \'50\', \'750\', \'15\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.glowusername.php\', \'images/uttstore/glowusername.gif\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:18:\"changecolorpercent\";s:5:\"title\";s:41:\"Percent of Regular Price to Change Color?\";s:4:\"desc\";s:124:\"Set this to the percent of the regular price that it costs to change a glowing username after it has already been purchased.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:2:\"50\";}}\'),

    (\'6\', \'colorusername\', \'Colored Username\', \'With this, you can pick a color that\\\'ll color your username in your posts any color you\\\'d like!\', \'60\', \'700\', \'4\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.colorusername.php\', \'images/uttstore/colorusername.gif\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:18:\"changecolorpercent\";s:5:\"title\";s:41:\"Percent of Regular Price to Change Color?\";s:4:\"desc\";s:124:\"Set this to the percent of the regular price that it costs to change a colored username after it has already been purchased?\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:2:\"50\";}}\'),

    (\'7\', \'boldusername\', \'Bold Username\', \'This allows you to make your username bold in your posts.\', \'70\', \'500\', \'4\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.boldusername.php\', \'images/uttstore/boldusername.gif\', \'1\', \'1\', \'\'),

    (\'8\', \'italicusername\', \'Italicized Username\', \'This allows you to make your username appear in italics in your posts.\', \'80\', \'500\', \'4\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.italicusername.php\', \'images/uttstore/italicusername.gif\', \'1\', \'1\', \'\'),

    (\'9\', \'admindonate\', \'Admin Donate\', \'This allows admins to give or take away points from users without affecting their own points.\', \'90\', \'0\', \'0\', \'0\', \'-1\', \'-1\', \'6\', \'\', \'uttstore/action.admindonate.php\', \'images/uttstore/admindonate.gif\', \'0\', \'1\', \'\'),

    (\'10\', \'bank\', \'Bank\', \'Save up your money in the bank and collect wonderful interest!\', \'100\', \'0\', \'0\', \'0\', \'-1\', \'-1\', \'6,7,2,5\', \'\', \'uttstore/action.bank.php\', \'images/uttstore/bank.gif\', \'0\', \'1\', \'a:2:{i:1;a:5:{s:7:\"varname\";s:17:\"interestincrement\";s:5:\"title\";s:18:\"Interest Increment\";s:4:\"desc\";s:96:\"Set this to how often interest should accumulate on money in this bank. Default - 86400 = 1 day.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:5:\"86400\";}i:2;a:5:{s:7:\"varname\";s:15:\"interestpercent\";s:5:\"title\";s:16:\"Interest Percent\";s:4:\"desc\";s:78:\"Set this to the amount of interest gained on money in this bank (in percents).\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:1:\"2\";}}\'),

    (\'11\', \'secondaryusergroup\', \'Secondary Usergroup\', \'Want a higher PM quota? Want to see invisible users? You might be able to buy access to a usergroup with those features here.\', \'110\', \'1000\', \'3\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.secondaryusergroup.php\', \'images/uttstore/secondaryusergroup.gif\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:3:\"pju\";s:5:\"title\";s:31:\"Publically Joinable Usergroups?\";s:4:\"desc\";s:109:\"Enter the usergroupids of the usergroups that users can buy access to in this action. Seperate ids by commas.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:7:\"9,10,11\";}}\'),

    (\'12\', \'stickythread\', \'Sticky Thread\', \'Make one of your topics stick to the top of the forum!\', \'120\', \'500\', \'5\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.stickythread.php\', \'\', \'1\', \'1\', \'\'),

    (\'14\', \'thief\', \'Thief!\', \'Attempt to steal points from another member here (you lazy bum).\', \'130\', \'0\', \'0\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.thief.php\', \'\', \'1\', \'1\', \'a:4:{i:1;a:5:{s:7:\"varname\";s:6:\"maxrep\";s:5:\"title\";s:19:\"Maximum Reputation?\";s:4:\"desc\";s:199:\"If a user reaches this many reputation points, it becomes impossible to steal from them. Otherwise, a percentage is calculated using this and the user\\\'s reputation to determain the chance of failure.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:6:\"100000\";}i:2;a:5:{s:7:\"varname\";s:8:\"backfire\";s:5:\"title\";s:28:\"Backfire on Failed Attempts?\";s:4:\"desc\";s:130:\"If this is set to \\\'yes\\\', failed attempts will backfire, giving the victim the money that the thief looses when they fail to steal.\";s:10:\"optioncode\";s:5:\"yesno\";s:5:\"value\";s:1:\"1\";}i:3;a:5:{s:7:\"varname\";s:8:\"replosts\";s:5:\"title\";s:39:\"Reputation Lost On Successful Thievery?\";s:4:\"desc\";s:154:\"Set this to the amount of reputation points that are lost when a member successfully steals money from another user. Make it negative you gice reputation.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:1:\"5\";}i:4;a:5:{s:7:\"varname\";s:8:\"replostf\";s:5:\"title\";s:35:\"Reputation Lost On Failed Thievery?\";s:4:\"desc\";s:162:\"Set this to the amount of reputation points that are lost when a member attempts and fails to steal money from another user. Make it negative you gice reputation.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:2:\"50\";}}\'),

    (\'15\', \'forumpassword\', \'Buy Forum Password\', \'Buy access to some special forums here!\', \'140\', \'1000\', \'3\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.forumpassword.php\', \'\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:13:\"allowedforums\";s:5:\"title\";s:15:\"Allowed Forums?\";s:4:\"desc\";s:127:\"Set this to the forumids that you would like to give members the chance to buy the password to. Seperate forumids with a comma.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:2:\"12\";}}\'),

    (\'16\', \'forumaccess\', \'Buy Forum Access\', \'Buy access to a forum!\', \'150\', \'2000\', \'4\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.forumaccess.php\', \'\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:13:\"allowedforums\";s:5:\"title\";s:15:\"Allowed Forums?\";s:4:\"desc\";s:121:\"Set this to the forumids that you would like to give members the chance to buy access to. Seperate forumids with a comma.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:5:\"12,13\";}}\'),

    (\'17\', \'denyforumaccess\', \'Deny Forum Access\', \'Want to keep some jackass out of a certain forum? Deny their access to the forum here!\', \'160\', \'2500\', \'10\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.denyforumaccess.php\', \'\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:13:\"allowedforums\";s:5:\"title\";s:15:\"Allowed Forums?\";s:4:\"desc\";s:131:\"Set this to the forumids that you would like to give members the chance to deny a user\\\'s access to. Seperate forumids with a comma.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:5:\"12,13\";}}\'),

    (\'18\', \'giveforumaccess\', \'Give Forum Access\', \'Bought access to a forum but want a friend to have access as well? Buy them access here!\', \'170\', \'2500\', \'9\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'uttstore/action.giveforumaccess.php\', \'\', \'1\', \'1\', \'a:1:{i:1;a:5:{s:7:\"varname\";s:13:\"allowedforums\";s:5:\"title\";s:15:\"Allowed Forums?\";s:4:\"desc\";s:131:\"Set this to the forumids that you would like to give members the chance to deny a user\\\'s access to. Seperate forumids with a comma.\";s:10:\"optioncode\";s:0:\"\";s:5:\"value\";s:5:\"12,13\";}}\'),

    (\'13\', \'arcadepass\', \'Arcade Pass\', \'Buy an arcade pass and play in the arcade!\', \'400\', \'1000\', \'5\', \'0\', \'20\', \'20\', \'6,7,2,5\', \'\', \'arcadepass.php\', \'\', \'1\', \'0\', \'\')';

And at the end it updates the datastore (or in the HTL, it's a query already.)

AN-net · #98 04-12-2004, 10:03 PM

im writing the instructions for functions_online.php

so dont worry guys, im doing this cause this hack is has so much potential.

Link14716 · #99 04-12-2004, 10:04 PM

FOR THOSE WHO WANT SUPPORT, SPECIFY THIS INFORMATION OR BE IGNORED:

Did you run the standalone or HTL installer?
What is the exact error you recieve?
Where does the supposed error happen?
What vB version are you running?

Link14716 · #**100** 04-12-2004, 10:05 PM

Quote:

Originally Posted by AN-net

im writing the instructions for functions_online.php

so dont worry guys, im doing this cause this hack is has so much potential.

Have fun.

BarHopper · #**101** 04-12-2004, 10:05 PM

<a href="http://www.game-realms.net/vb/ushop.php" target="_blank">http://www.game-realms.net/vb/ushop.php</a>

I've uninstalled and re-installed twice, once using the HTL and another using the Manual. I'm stuck. The errors in the shop and its got no Actions as you'll see.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06117 seconds Memory Usage 2,369KB Queries Executed 26 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (3)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!