Major Additions - Pick Em Picks - NFL

Like this mod? Click install and nominate for motm=====>>>

This mod will add a NFL Football Pick Em to your Vbulletin

I did not write the code for the Pick Em, but have been granted permission to re-distribute it and share it. Please be respectful of the author and leave the copyright in place, however you can remove the Paypal donate


Step 1:
Open config.php located in the includes folder of phppickem.1.0.8 and enter database details.

Step 2:
Upload all of the files located in phppickem.1.0.8 and pickempicks.php to your root on your server (do not put these in the same folder).

Step 3: Import the the XML product. admincp--->plugins and products--->manage products--->add/import product


Step 4: Run the install script. www.yoursite.com/phppickem/install
*Follow the on-screen directions. Don't forget to delete file afterwards*

Point your browser to www.yoursite.com/pickempicks.php
Don't forget to make a link to your new page!


Initial Log in for Admin is:

Username: Admin
Password: admin123

Be sure to change that to a password you can remember

To update to the 2012 season. Download Nfl_2012_Schedule (attached) and log into your database via phpmyadmin. Upload the file to your database. This will update your schedule for the upcoming 2012 season.

ENJOY!

This project IS modifiable, so if someone want to take on the task of modifying it to conform more to Vbulletin, by all means be my guest. As it is right now, users will have to create another log in.

As far as I know this should work with all Vbulletin 4 versions, but I have no way of testing that.


Change Log:
Updated version 1.1
Now includes product xml. No need for a
template change.

[Dez_U]

Cheers dude

[Grimes]

This mod looks awesome. Is there any way to make it so that our users don't have to create a new account to use this? No big deal...just wondering.

[Bob_R]

The xml file contains the 2012 NFL schedule???

What to do.

That is what is showing up on my install

[Bob_R]

Forget it I got it. But, I got it because I'm familiar with computers, software, etc. A novice would have been lost.

I had to change the sql in the index file among other things.

That was never mentioned in the instructions.

Anyways, carry on people!

[Bob_R]

....

[legiondadon]

is there a 2013 schedule?

[Krusty1231]

You can download a more up to date package here:

http://sourceforge.net/projects/phppickem/files/

[LgsOfChampions]

I tried to install this last season,, which ended up me giving up on it. I'm trying it again and I get this error after it ask me to delete the install folder then click complete which gives me this error

Fatal error: Call to undefined function dl() in /home/leagueso/public_html/phppickem/includes/classes/crypto.php on line 31

not sure what to do

also this error

Not Found

The requested URL /pickem/index.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request

[Krusty1231]

I installed it as I have in the past without using the mod above.

Download the latest package from the link I posted above.

phppickem.1.0.9.zip

you will also need:

nfl_schedule_2013.xls
nfl_schedule_2013.xlsx
nfl_schedule_2013.csv
nfl_schedule_2013.sql

Grab those files and place them in the phppickem/docs folder (You probably only need the sql one - but what do I know - I placed them all there.

Once you have completed that.

Contents:
1. Minimum Requirements
2. Installation Instructions
3. Logging In
4. Troubleshooting

1. Minimum Requirements
 PHP version 4.3 or greater
 MySql version 4.0 or greater

2. Installation Instructions
1. Extract files

2. Create a MySQL database on your web server, as well as a MySQL user who has all privileges for accessing and modifying it.

3. Edit /includes/config.php and update database connection variables accordingly
4. Upload files to your web server

5. Run installer script at http://www.your-domain.com/phppickem/install. The installer will assist you with the rest.

3. Logging In
Log in for the first time with admin / admin123. You may change your password once you are logged in.

Now when I did this a few weeks ago (I did it without the updated files) so of course I had a old schedule.

To update the schedule to 2013 using phpMyadmin (That is what I used)

Click on the table "nflp_schedule"
You should see the list of games.

Up top, click on "Operations".
Then find where it says "truncate table".
Click Go.

Now the table will be empty of games, but it will show the table fields.

While still looking at the "nflp_schedule" table, click on Import.

Choose the file. - I used the 2013.sql

Leave all fields on default settings.

After import, go back to the schedule.

All updated games will show now.

Hope that helps and makes sense.

[LgsOfChampions]

I did everything you said. I uploaded the new file and overwrite the old files. DB connections was successful and then I get to step 3 says delete install then hit complete, which I do and it gives me this error again

Fatal error: Call to undefined function dl() in /home/leagueso/public_html/phppickem/includes/classes/crypto.php on line 31