vb.org Archive - vbCasino 2

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vbCasino 2 (https://vborg.vbsupport.ru/showthread.php?t=93374)

wont work this should be in beta

Database error in vBulletin 3.0.7:

Invalid SQL:
INSERT INTO `lottery_settings` VALUES (1, 0, 'uttpoints', 3, '50,30,10', 1, 1, 1, 1, 1, '1,2,5,10', 1);

mysql error: You have an error in your SQL syntax near ';
' at line 2

mysql error number: 1064

Any Idea how I can fix this?

I installed... everything seems to be working great

except for the winners and slots
seems to be the same as the older version

doesn't display winners and the slots are all still reading zero?

I guess this will be fixed soon ?

Sorry guys, I would have put it in BETA but waza made it sound like it all worked and all I had to do was fix a few things... he didn't mention this not working, so I fixed some stuff and released it. Didn't think phrases would be a problem. Anyways, if someone sees a problem with the code, please tell me. I've looked at it and can't understand why it won't work. I'll try just putting everything so it doesn't use phrases for now, but it could take awhile because there are so many.

@slim_cutty: I will work on that. I thought waza said he fixed that, but in a few days another will be released, hopefully the final version where everything works.

Anyways, I'd like to hear how you got everything working, it could save everyone a lot of trouble. Also please post which vBulletin version you have. Thanks!

Well, I'm running My SQL 3.23... I've been getting errors with the new hacks for some reason... syntax at line blah blah blah... don't understand why... at anyrate...

INSERT INTO `lottery_settings` VALUES (1, 0, 'uttpoints', 3, '50,30,10', 1, 1, 1, 1, 1, '1,2,5,10', 1);

I had to add manually into the database... it worked.. it just didn't work when I installed it from the install.php file... what I did which probably wasn't save was deleted that line in the install.php file and it finished installing. After that I went and added that line above manually. And it worked... as far as the casino_redirect... I just changed that to what it was looking for in the phrase to casino_cp_redirect... eventhough it didn't say that it saved it... it did

and that is it. It seems to work and deduct points and all, however the slots game still shows all zeros and never updates wins or anything at all... every other game works to say the least.

*EDIT... whoops.. it seems this has been updated I guess... can somebody delete this?

Quote:

Originally Posted by slim cutty

Hi there i know what you got this error you see in this code

PHP Code:


		
			
INSERT INTO `".TABLE_PREFIX."lottery_settings` VALUES (1, 0, '".$cashrow."', 3, '50,30,10', 1, 1, 1, 1, 1, '1,2,5,10', 1);

it has the `".TABLE_PREFIX."

but in the CREATE TABLE it had this

PHP Code:


		
			
 $DB_site->query("
CREATE TABLE `lottery_settings` (
    `active` int(1) NOT NULL default '0',
    `multiple` tinyint(2) NOT NULL default '0',
    `cashrow` varchar(20) NOT NULL default '',
    `winners` tinyint(3) NOT NULL default '0',
    `winamount` varchar(100) NOT NULL default '',
    `pm` tinyint(2) NOT NULL default '0',
    `slotsactive` tinyint(2) NOT NULL default '0',
    `lotteryactive` tinyint(2) NOT NULL default '0',
    `pickactive` tinyint(2) NOT NULL default '0',
    `guessactive` tinyint(2) NOT NULL default '0',
    `gstaggering` varchar(50) NOT NULL default '',
    `rouletteactive` tinyint(2) NOT NULL default '0'
) TYPE=MyISAM
");

But should have been this

PHP Code:


		
			
$DB_site->query("
CREATE TABLE `".TABLE_PREFIX."lottery_settings` (
    `active` int(1) NOT NULL default '0',
    `multiple` tinyint(2) NOT NULL default '0',
    `cashrow` varchar(20) NOT NULL default '',
    `winners` tinyint(3) NOT NULL default '0',
    `winamount` varchar(100) NOT NULL default '',
    `pm` tinyint(2) NOT NULL default '0',
    `slotsactive` tinyint(2) NOT NULL default '0',
    `lotteryactive` tinyint(2) NOT NULL default '0',
    `pickactive` tinyint(2) NOT NULL default '0',
    `guessactive` tinyint(2) NOT NULL default '0',
    `gstaggering` varchar(50) NOT NULL default '',
    `rouletteactive` tinyint(2) NOT NULL default '0'
) TYPE=MyISAM
");

so the INSERT INTO could not insert it in the right place.

Also in the

lottery_slots_stats

there need to be a insert too as this is why some people are not seeing the jackpot and the others show as 0

like this

PHP Code:


		
			
 $DB_site->query("
INSERT INTO `".TABLE_PREFIX."lottery_slots_stats` VALUES (1, 1, 1, 1, 1, 1, 1);
");

i have updated the install file but have not tested it so please feel free to download it and see if this works for you.

Used the new installer .. I just get the casino jpg up, when I go to lottery.php ... how you get in?

Hi there

You will need to edite all the $vbphrase to get the casino to work.
There seams to be a problem calling them even know they are installed.

This goes in the root of you forums i have taken out all the $vbphrase
and put in english ones.
But you will need to update all your templates too by taking out all the $vbphrase and changing then from this

$vbphrase['Casino_Index']; to "casino index"

The casino is all working on my site and its very good but i will be making changes to the casino to sute my site.

im gonna hang back until i see this working properly, sounds like a top hack tho mate....

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01040 seconds Memory Usage 1,756KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (4)bbcode_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: