Need help fast will pay through paypal

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Need help fast will pay through paypal

Post 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
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

Can anyone give ma a clue as to why it doesnt work. is it the server time?
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

Hard to say without seeing the code, but i'd start by fixing those 2 mysql warnings that appear.
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

I know nothing about php. should i post the code. that is the line that deals with the time
d3ad1ysp0rk
Forum Donator
Posts: 1661
Joined: Mon Oct 20, 2003 8:31 pm
Location: Maine, USA

Post by d3ad1ysp0rk »

make sure u edit your db password and name to ***** or whatever tho ;)
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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)
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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.
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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.
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

Table 'gridiron_forums.nba_bets' doesn't exist
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post by markl999 »

There you go then .... go and 'make it exist' ;)
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

What do you mean lol I am lost now
mtor
Forum Newbie
Posts: 9
Joined: Sun Feb 01, 2004 7:59 am

Post by mtor »

it already exists

gridiron_nba
final
games
nba_bets
nba_games
nba_users

--------------------------------------------------------------------------------
User avatar
markl999
DevNet Resident
Posts: 1972
Joined: Thu Oct 16, 2003 5:49 pm
Location: Manchester (UK)

Post 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
Post Reply