Codezwiz >> Forums >> BBtoNuke Mods Help >> Bookie Mod question

Im installing the bookie mod and am on this step:

## Database Changes
##
## 1) Run db_update.php from your web broswer to make the table changes (you must be logged in as an Administrator).

When I try to do this I get:

You can't access this file directly...

I am logged in as the admin (the account I created when I installed Nuke). Am I missing a step or doing something incorrect?

Im running Nuke 7.2 and phpBB 2.0.7. I installed the db_update.php file in the root directory. Thanks in advance for any help.

Attach the installer.

Hmm, can't seem to find an installer anywhere. I've uploaded all the files in the bookie_mod folder. I double checked to make sure everything was in the right directories and that I didn't miss any. They all seem to be there. Is it possible that it is missing in the download?

im gettin this same problem when tryin to run the db_update.php in my web browser im getin the message -- You can't access this file directly... -- where can i get this installer from .. or is there somet i can do manually to correct this problem?

thanks for any input given
hitman

Try this one save as db_update.php and run by uploading into your modules/Forums/

modules.php?name=Forums&file=db_update

<?php
/***************************************************************************
* db_update.php
* -------------------
*
* copyright : �2003 Freakin' Booty ;-P & Antony Bailey
* project : http://sourceforge.net/projects/dbgenerator
* Website : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
*
***************************************************************************/

/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}
if ($popup != "1"){
$module_name = basename(dirname(__FILE__));
require("modules/".$module_name."/nukebb.php");
}
else
{
$phpbb_root_path = 'modules/Forums/';
}

define('IN_PHPBB', true);
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX, $nukeuser);
init_userprefs($userdata);
//
// End session management
//

$page_title = 'Updating the database';
include('includes/page_header.php');

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><ul type="circle">';

$sql = array();
$sql[] = "CREATE TABLE `" . $prefix . "_bookie_bets` (
`bet_id` int(5) NOT NULL auto_increment,
`user_id` int(11) NOT NULL default '0',
`time` int(11) NOT NULL default '0',
`meeting` varchar(50) NOT NULL default '',
`selection` varchar(100) NOT NULL default '',
`bet` int(11) NOT NULL default '0',
`win_lose` int(11) NOT NULL default '0',
`odds_1` int(8) NOT NULL default '0',
`odds_2` int(8) NOT NULL default '0',
`checked` int(2) NOT NULL default '0',
`edit_time` int(11) NOT NULL default '0',
PRIMARY KEY (`bet_id`)
)";
$sql[] = "CREATE TABLE `" . $prefix . "_bookie_stats` (
`user_id` int(11) NOT NULL default '0',
`total_win` int(11) NOT NULL default '0',
`total_lose` int(11) NOT NULL default '0',
`netpos` int(11) NOT NULL default '0',
`bets_placed` int(6) NOT NULL default '0'
) TYPE=MyISAM";

for( $i = 0; $i < count($sql); $i++ )
{
if( !$result = $db->sql_query ($sql[$i]) )
{
 $error = $db->sql_error();

 echo '<li>' . $sql[$i] . ' +++ Error: ' . $error['message'] . '</li> ';
}
else
{
 echo '<li>' . $sql[$i] . ' +++ Successful</li> ';
}
}

echo '</ul></td></tr><tr><td class="catBottom" height="28"> </td></tr>';

echo '<tr><th>Installation Complete</th></tr><tr><td>Please be sure to delete this file now. If you require any further assistance, please visit the <a href="http://www.phpbbhacks.com/forums">phpBBHacks.com Support Forums</a>.</td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><a href="' . append_sid("index.$phpEx") . '">Go back to your index page</a>.</td></table>';

include('includes/page_tail.php');

?>

hello first of all!
I would like to ask you if anyone knows how can i use the point system with bookie mod? I have installed bookie mod and everything works fine but users can't place bets becouse they have no points in hand

You have 0 Points onhand.

.
I've made a point system for users to get points by posting in forum, making votes etc etc but after that i saw that bookie mod does not use THOSE points.
What can users do to get points for betting ?
What kind of point system do i need ?
Thanks in advance!

If you look in the bookie mod you could change the points name (variable) to the points that your site is using. That would allow it to work with that point system.