Bravo List - Betting system

Bravo List (http://www.bvlist.com/index.php)

- TBDev (http://www.bvlist.com/forumdisplay.php?f=20)

- - Betting system (http://www.bvlist.com/showthread.php?t=698)

Hi, I have search in hour but I can not fint a betting system to tbdev..

I will bet on sports, ex: football ect.

Are it someone know where I can find that?

//LuddeSnutte

I want betting for TS. :shock:

I want betting game too TS 5.4.1 :sos:

here we go

i wish to mention it's not my work it's a tbdeved version translated in hungarian by angelo and with bibicu help :) so if you need another language you have to translate

1step SQL

Code:

DROP TABLE IF EXISTS `bet`;



CREATE TABLE `bet` (



`id` int(10) unsigned NOT NULL auto_increment,



`name` varchar(50) NOT NULL default '',



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



PRIMARY KEY (`id`)



) TYPE=MyISAM AUTO_INCREMENT=1 ;







-- 



-- Dumping data for table `bet`



-- 











-- --------------------------------------------------------







-- 



-- Table structure for table `bet_winns`



-- 







DROP TABLE IF EXISTS `bet_winns`;



CREATE TABLE `bet_winns` (



`id` int(10) unsigned NOT NULL auto_increment,



`betid` int(10) unsigned NOT NULL default '0',



`choice` tinyint(2) default NULL,



PRIMARY KEY (`id`),



KEY `betid` (`betid`),



KEY `choice` (`choice`)



) TYPE=MyISAM AUTO_INCREMENT=1 ;







-- 



-- Dumping data for table `bet_winns`



-- 











-- --------------------------------------------------------







-- 



-- Table structure for table `betchoices`



-- 







DROP TABLE IF EXISTS `betchoices`;



CREATE TABLE `betchoices` (



`id` int(10) unsigned NOT NULL auto_increment,



`betid` int(10) unsigned NOT NULL default '0',



`name` varchar(50) NOT NULL default '',



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



`choice1` varchar(40) default NULL,



`choice2` varchar(40) default NULL,



`choice3` varchar(40) default NULL,



`choice4` varchar(40) default NULL,



`choice5` varchar(40) default NULL,



`choice6` varchar(40) default NULL,



`choice7` varchar(40) default NULL,



`choice8` varchar(40) default NULL,



`choice9` varchar(40) default NULL,



`choice10` varchar(40) default NULL,



`payout1` decimal(2,1) default NULL,



`payout2` decimal(2,1) default NULL,



`payout3` decimal(2,1) default NULL,



`payout4` decimal(2,1) default NULL,



`payout5` decimal(2,1) default NULL,



`payout6` decimal(2,1) default NULL,



`payout7` decimal(2,1) default NULL,



`payout8` decimal(2,1) default NULL,



`payout9` decimal(2,1) default NULL,



`payout10` decimal(2,1) default NULL,



PRIMARY KEY (`id`),



KEY `betid` (`betid`)



) TYPE=MyISAM AUTO_INCREMENT=1 ;







-- 



-- Dumping data for table `betchoices`



-- 











-- --------------------------------------------------------







-- 



-- Table structure for table `bets`



-- 







DROP TABLE IF EXISTS `bets`;



CREATE TABLE `bets` (



`id` int(10) unsigned NOT NULL auto_increment,



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



`betid` int(10) unsigned NOT NULL default '0',



`choice` tinyint(2) unsigned NOT NULL default '0',



`bet` bigint(13) unsigned NOT NULL default '0',



`paid` tinyint(1) unsigned NOT NULL default '0',



PRIMARY KEY (`id`),



KEY `userid` (`userid`),



KEY `betid` (`betid`),



KEY `choice` (`choice`)



) TYPE=MyISAM AUTO_INCREMENT=1 ;







-- 



-- Dumping data for table `bets`



--

create a file named betting.php
[code]
require 'global.php';

dbconn();

loggedinorreturn();
$action = $_GET["action"];
if ($action == "placebet") {
$betid = 0 + $_POST["bcid"];
if ($betid == "")
stderr("Error", "Oh Nice One You Fucked Up.");
$i = 1;
while ($i < 11) {
$bi = "amount" . $i;
if ($_POST[$bi] != "") {
$bis = $bi;
$amount = 0 + $_POST[$bi];
}
$i++;
}
$amount = round($amount * 1048576);
$maxamount = round($CURUSER['uploaded'] / 10);
if ($amount > $maxamount)
stderr("Hiba!", "Nincs fedezete a fogad

Yes! it's working!

But, the only thing is that I don't speak hungarian ... anyone that can translate it in english?

Good job, marco !

you need to add all lag files to this which are missing

:friend:here the english php attached...please be kind ...for my english lang :)
maybe somebody transfer this topic to solved mods on TS

btw. this mod have 2 issues.... can't close the bets when the match is started.... and it's not sending automatically PM-s to the winners....

:) good luck

thanx the mod but sql file not wor for me whats wrog whit that?

phpmyadmin gives that error

Code:

1064: You have an error in your SQL syntax;  check the manual that corresponds to your MySQL server version for the  right syntax to use near ';  CREATE TABLE `bet` (  `id` int(10) unsigned NOT NULL auto_increment,  `' at line 1

can someone do the sql file works in tsse 5.4.1 version?

Thanx!

i suppose it's different phpmyadmin and the pronnounce is the trouble...take a look on your install sql what is different from this

if you send me your sql (fresh one) not your db i will figure out

Quote:

Originally Posted by Marco (Post 23507)

i suppose it's different phpmyadmin and the pronnounce is the trouble...take a look on your install sql what is different from this

if you send me your sql (fresh one) not your db i will figure out

i have this sql code what is your post in up and that not work for me

and my MySQL Version 5.0.32-Debian_7

Now i get this error
SQL ERROR Table 'TSSE.bet' doesn't exist in __FILE, line 189 how fix

did you run the sql in data base?

Quote:

Originally Posted by joeroberts (Post 23585)

did you run the sql in data base?

yes i put in my database

betwin page works but not betting page give that error what i put there

Quote:

Originally Posted by Muikku (Post 23506)

thanx the mod but sql file not wor for me whats wrog whit that?

phpmyadmin gives that error

Code:

1064: You have an error in your SQL syntax;  check the manual that corresponds to your MySQL server version for the  right syntax to use near ';  CREATE TABLE `bet` (  `id` int(10) unsigned NOT NULL auto_increment,  `' at line 1

can someone do the sql file works in tsse 5.4.1 version?

Thanx!

yes can do this for you not a prob to do and i would update your server as well thou putty
and i have the full mod for this where you get no errors ill get into my hd and get it for you

Quote:

Originally Posted by falcon (Post 23587)

yes can do this for you not a prob to do and i would update your server as well thou putty
and i have the full mod for this where you get no errors ill get into my hd and get it for you

can you post workking sql in here please:ok: or all php files too if they are in enghlis :D

the working sql it is on my first post :):drink:

Quote:

Originally Posted by Marco (Post 23629)

the working sql it is on my first post :):drink:

not workking for me or then something wron in betting.php file

itry this mod use TSSE 5.4.1 not genremod source

Ps. that work my other test place but how i can detlete old played and pay betting ?? not show that button what DELETE old bet and old pay list

and where i can set only staff can put the pet in list now all user claas can put the bet how i can change that ????

and where i can set how long can played the bet now enyone can put the own pet when real game is over and pet player know who won the game and know result?
i think that was sucks!!

only from sql :friend:

donth work for me on tbdev

I appears bets are closed and can not do anything. As they start?
How do I set a bet if I do not see any button?:sad:

i think this will help..
i using NexusPHP, from what i know this code is suitable to match tbdev..
try this.. :ok: