Page 1 of 2
Need help fast will pay through paypal
Posted: Sun Feb 01, 2004 7:59 am
by mtor
I am starting a basketball contest today. I had a programmer write a script for me. The script displays the betting lines for today basketball games and you are suppose to pick 3 choices. When I make my pick for todays games it says that the game already started even though it doesnt start for another 10 hours and it doesn't let you make your selection.
Here is the link to make your picks
http://www.gridirontalk.com/nba/place_bet.php
userid: pito
password: wilson
You can log in to make a pick using that test account.
Thanks whoever can help me out please let me knowhow much and I will pay through paypal.
Also I need someone to write up a script for me for a nascar contest at a later date
Posted: Sun Feb 01, 2004 8:13 am
by mtor
Can anyone give ma a clue as to why it doesnt work. is it the server time?
Posted: Sun Feb 01, 2004 8:15 am
by markl999
Hard to say without seeing the code, but i'd start by fixing those 2 mysql warnings that appear.
Posted: Sun Feb 01, 2004 8:19 am
by mtor
I know nothing about php. should i post the code. that is the line that deals with the time
Posted: Sun Feb 01, 2004 8:22 am
by d3ad1ysp0rk
make sure u edit your db password and name to ***** or whatever tho

Posted: Sun Feb 01, 2004 8:23 am
by markl999
Might be better to make a copy of place_bet.php, but call it place_bet.phps, then we can see the source code.
(or you could use a symlink if you know about those)
Posted: Sun Feb 01, 2004 8:28 am
by mtor
Posted: Sun Feb 01, 2004 8:33 am
by markl999
Looks like it maybe a register_globals problem. Your server is running 4.3.3 and register_globals is Off by default.
To check create a php file with the following in it.
<?php phpinfo() ?>
and search down to find the register_globals line, if it's Off then you'll either need to edit php.ini and turn them on (and restart apache) or make some changes to the script...
I'd investigate the register_globals thing first before contemplating script changes
Actually...
After i typed all that i realised that your login page seems to work ok, so register_globals probably isn't an issue.
Posted: Sun Feb 01, 2004 8:39 am
by markl999
Edit line 73 so it reads...
$query1 = mysql_query("SELECT * FROM nba_bets WHERE userid='$userid' AND left(game_time,10)='$game_date'") or die(mysql_error());
and edit line 83 so it's
$query = mysql_query("SELECT DATE_FORMAT(DATE_ADD(game_time,INTERVAL 3 HOUR),'%Y%m%d%H%i') gt,game_time,home_line,away_line FROM nba_games WHERE ID='$bet_parts[2]'") or die(mysql_error());
and let us know what it says.
Posted: Sun Feb 01, 2004 8:40 am
by mtor
Posted: Sun Feb 01, 2004 8:49 am
by mtor
Table 'gridiron_forums.nba_bets' doesn't exist
Posted: Sun Feb 01, 2004 8:52 am
by markl999
There you go then .... go and 'make it exist'

Posted: Sun Feb 01, 2004 8:53 am
by mtor
What do you mean lol I am lost now
Posted: Sun Feb 01, 2004 8:56 am
by mtor
it already exists
gridiron_nba
final
games
nba_bets
nba_games
nba_users
--------------------------------------------------------------------------------
Posted: Sun Feb 01, 2004 9:03 am
by markl999
But the message is "Table 'gridiron_forums.nba_bets' doesn't exist" .. so it's trying to find nba_bets in the gridiron_forums database.
The only place gridiron_forums is used in your code is when logging in, so it looks to me like
mysql_select_db('gamemint_nba'); on line 68 should be
mysql_select_db('gridiron_nba');
I'm sending you important info in a private message, act on it before you do anything else :p