Pick Em Picks - NFL

[Reycer]

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.

[Reycer]

Here's a Demo:

www.kcchieffans.com/pickempicks.php

[Krusty1231]

I have been using this for a few years. I'm going to add the "new template" as I link our pool through the peel slider mod.

I'll be back if I have any questions.

Nice up.

[Krusty1231]

Well it took some doing to use the PHP you provided, but I got it (As I already had this installed I had to change the file path in the template code.

I like it.

I think it could be better if we did not have to use separate logins....I had emailed the maker of the pool for a little info a year ago - never got a reply.

Your template mod is cleaner than the peel I was using (See screenshot) so I will go with it, but will have to figure out how to center it - it looks to lopsided on the left like that.

I do not know if I am on the right track or not here? I added a center tag to the iframe code in the template you provided. I also turned on the "scrolling" to yes.

Now it scrolls and is centered.

[Reycer]

Fixed the centering of the frame and turned scrolling to yes.

I agree, I wish I was an awesome coder and new how to integrate the log in so that it would work here.

[Toorak Times]

How could we get something like this for Australia's AFL Footy?

[RSNF]

Do they make anything similar to this only for major league baseball?

[Hanany95]

Anyway we can change this to NBA or is it just NFL?

[Reycer]

If you have a fair knowledge of coding, it is possible to change this to NBA or MLB.

[LgsOfChampions]

do the files get uploaded to the forum server (myname.com/forum)? or totally different (do i make new folder in my forum server)
?

[RSNF]

If you have a fair knowledge of coding, it is possible to change this to NBA or MLB.


Would you consider taking on a project like this in the paid request section for MLB?

[Krusty1231]

do the files get uploaded to the forum server (myname.com/forum)? or totally different (do i make new folder in my forum server)
?

I uploaded the files outside of my forum. I created a separate database following the install instructions of the phpfootball addon.

PHP Pick 'Em


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.

[LgsOfChampions]

ty sir

[LgsOfChampions]

I got it uploaded and installed however 2 things,

1 - when I use this link, it like boots me out and takes me str8 back to my forum activity page http://www.leaguesofchampions.com/pickempicks.php

2. I know u explain how to upload schedule, I'm all new to this but does this get uplaoded to the server or upload it via the phpadmin site?

I love this mod, huge sports nut I will be donating once I get it working correctly.

ALSO - E -A -G -L -E -S------ EAGLES BABY

[Krusty1231]

Open the pickempicks.php and look at line 19:

// chdir ('/path/to/your/forums');

Make sure this path is the same path as your forum.

Also - I uploaded the schedule through phpadmin.

[Reycer]

Would you consider taking on a project like this in the paid request section for MLB?

I'll try and do it. I'm not much of a coder, but I'm up for a challenge. I'll give it a go.

EDIT: Got most of it done. Working on the exhausting schedule right now. That may take a couple of days. lol I'll upload it when I'm done.

[Reycer]

I got it uploaded and installed however 2 things,

1 - when I use this link, it like boots me out and takes me str8 back to my forum activity page http://www.leaguesofchampions.com/pickempicks.php

2. I know u explain how to upload schedule, I'm all new to this but does this get uplaoded to the server or upload it via the phpadmin site?

I love this mod, huge sports nut I will be donating once I get it working correctly.

ALSO - E -A -G -L -E -S------ EAGLES BABY

Post your PHP file and Template code here and I'll take a look at it. Just got back from your site and it is looping back to the activity stream for some reason.

[Reycer]

Open the pickempicks.php and look at line 19:

// chdir ('/path/to/your/forums');

Make sure this path is the same path as your forum.


No need to un-comment that unless your file is located outside of the forum directory.

[LgsOfChampions]

Post your PHP file and Template code here and I'll take a look at it. Just got back from your site and it is looping back to the activity stream for some reason.

leaguesofchampions.com/pickem <<<folder
<?php


error_reporting(E_ALL & ~E_NOTICE);

define('THIS_SCRIPT', 'pickempicks');
define('CSRF_PROTECTION', true);


$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array('pickempicks',
);

$actiontemplates = array();

// chdir ('http://www.leaguesofchampions.com/pickem/pickempicks.php');
require_once('./global.php');



$navbits = construct_navbits(array('' => 'Pick Em Picks'));
$navbar = render_navbar_template($navbits);


$pagetitle = 'Pick Em Picks NFL Weekly Picks';


$templater = vB_Template::create('pickempicks');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());

?>
{vb:stylevar htmldoctype}
<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">
<head>
<title>{vb:raw vboptions.bbtitle} - {vb:raw pagetitle}</title>
{vb:raw headinclude}
{vb:raw headinclude_bottom}
</head>
<body>

{vb:raw header}

{vb:raw navbar}

<div id="pagetitle">
<h1>{vb:raw pagetitle}</h1>
</div>

<h2 class="blockhead">Pick Em Picks NFL Weekly Picks</h2>
<div class="blockbody">
<div class="blockrow">
<p align="center"><iframe width="840" scrolling="yes" height="686" frameborder="0" style="border: 0px none transparent;" src="..//pickem/index.php"></iframe></p></div></div>
</div>
</div>

{vb:raw footer}
</body>
</html>

[Reycer]

Open pickempicks.php Replace the contents with'

<?php


error_reporting(E_ALL & ~E_NOTICE);

define('THIS_SCRIPT', 'pickempicks');
define('CSRF_PROTECTION', true);


$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array('pickempicks',
);

$actiontemplates = array();

require_once('./global.php');



$navbits = construct_navbits(array('' => 'Pick Em Picks'));
$navbar = render_navbar_template($navbits);


$pagetitle = 'Pick Em Picks NFL Weekly Picks';


$templater = vB_Template::create('pickempicks');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());

?>

Not exactly sure (it's just not jumping off the page at me) what's wrong with your code, but when I use it, it throws out some errors. So replace the code and see if that works.

[LgsOfChampions]

did what u said still doing same :(

[Krusty1231]

// chdir ('http://www.leaguesofchampions.com/pickem/pickempicks.php');

I think this is wrong.

For $hits and giggles upload this forumpath.php file to the same place your pickempicks.php is.

then run it.

type in your address bar....where you placed it.

Example:

www.leaguesofchampions.com/forum/forumpath.php

The forum path it gives you should be entered into the quoted chdir above.

Try it.

[legion!]

heres the error im getting after install

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

[legion!]

silly silly me...i got it workin now

[ar-K-ic]

will this work with VB 3.8? And Collage football would rock!@

[Dez_U]

Guys, I am getting the same problem, when I try to access, it drops me back to the forum.

Template is

{vb:stylevar htmldoctype}
<html xmlns="http://www.w3.org/1999/xhtml" dir="{vb:stylevar textdirection}" lang="{vb:stylevar languagecode}" id="vbulletin_html">
<head>
<title>{vb:raw vboptions.bbtitle} - {vb:raw pagetitle}</title>
{vb:raw headinclude}
{vb:raw headinclude_bottom}
</head>
<body>

{vb:raw header}

{vb:raw navbar}

<div id="pagetitle">
<h1>{vb:raw pagetitle}</h1>
</div>

<h2 class="blockhead">Pick Em Picks NFL Weekly Picks</h2>
<div class="blockbody">
<div class="blockrow">
<p align="center"><iframe width="840" scrolling="yes" height="686" frameborder="0" style="border: 0px none transparent;" src="..//pickem/index.php"></iframe></p></div></div>
</div>
</div>

{vb:raw footer}
</body>
</html>

and pickempicks.php is

<?php


error_reporting(E_ALL & ~E_NOTICE);

define('THIS_SCRIPT', 'pickempicks');
define('CSRF_PROTECTION', true);


$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array('pickempicks',
);

$actiontemplates = array();

chdir ('/var/www/vhosts/clanram.com/httpdocs/forums');
require_once('./global.php');



$navbits = construct_navbits(array('' => 'Pick Em Picks'));
$navbar = render_navbar_template($navbits);


$pagetitle = 'Pick Em Picks NFL Weekly Picks';


$templater = vB_Template::create('pickempicks');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());

?>

[Dez_U]

oh, and link is http://www.clanram.com/forums/pickempick.php

any help, taken with thanks :)

[Reycer]

oh, and link is http://www.clanram.com/forums/pickempick.php

any help, taken with thanks :)

Well for starters it should be http://www.clanram.com/forums/pickempicks.php

You forgot the "S" and I can point to it fine. However your missing index.php in the pickempicks folder


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

That's what I'm seeing when I go to your page.

[Reycer]

will this work with VB 3.8? And Collage football would rock!@

It can be used on whatever version, however to integrate into your vbulletin page follow the instructions here (https://vborg.vbsupport.ru/showthread.php?t=62164)

It's not that hard to change the teams, helmets, divisions and so forth, I just opened the .sql file and edited the tables and the edited the corresponding .php files, did this for MLB, just working on that blasted schedule (which MLB is like 10 miles long. lol). But I was able to change this over to work with MLB.

[Reycer]

silly silly me...i got it workin now

GREAT! Don't forget to click installed ;)

[legion!]

done...hey anyway to maybe display results on the forumhome or something?

[Dez_U]

Well for starters it should be http://www.clanram.com/forums/pickempicks.php

You forgot the "S" and I can point to it fine. However your missing index.php in the pickempicks folder


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

That's what I'm seeing when I go to your page.

This is what I am seeing, I have checked the folder and index.php is there?

http://www.clanram.com/image9.jpg

[Dez_U]

I have pickempicks.php in the folder forums
I have the rest of the files in the folder forums/phppickem

[TNERatedEdge]

Hi, I am trying to get this installed, can somoene help me install, I'll pay.

[RSNF]

It can be used on whatever version, however to integrate into your vbulletin page follow the instructions here (https://vborg.vbsupport.ru/showthread.php?t=62164)

It's not that hard to change the teams, helmets, divisions and so forth, I just opened the .sql file and edited the tables and the edited the corresponding .php files, did this for MLB, just working on that blasted schedule (which MLB is like 10 miles long. lol). But I was able to change this over to work with MLB.


Oh man that's awesome that your working on the baseball version can't wait till it's done much appreciated.

[Reycer]

I have pickempicks.php in the folder forums
I have the rest of the files in the folder forums/phppickem

In your Template change

src="..//pickem/index.php

to

src="../forums/pickem/index.php

[Reycer]

Oh man that's awesome that your working on the baseball version can't wait till it's done much appreciated.

Yes, it's basically done. It just needs the schedule done, and at this point it may be for the 2013 season.

[Reycer]

No more need for a template edit. I packaged it up. Just open the config file and upload your database info. Then upload the entire contents of phppickem.1.0.8 folder along with the pickempicks.php then upload the attached XML file in your products. All done. I even included the newest NFL Schedule, no need to log into your phpmyadmin anymore. :)

[Dez_U]

sorry about that. OK, changed the code in the template but its still not working?

[Reycer]

sorry about that. OK, changed the code in the template but its still not working?

Well your at least pointing the right direction, but your getting this error now
The Mcrypt module could not be loaded.
And I have no idea what could be causing that. Give me a few to check around to see what could possibly be causing that.

[Dez_U]

OK, cool and thanks for taking the time :)

[Dez_U]

I have also deleted the database and created a new one, but thats not helping as its still throwing up the same issue.?

[RSNF]

Yes, it's basically done. It just needs the schedule done, and at this point it may be for the 2013 season.


Yeah that's awesome and greatly appreciated. I'll shoot you a donation once you're done my friend!!

[Reycer]

I have also deleted the database and created a new one, but thats not helping as its still throwing up the same issue.?

I really don't have an answer for you at this point except maybe restarting your database. Through my searches I have found that this sometimes fixes this issue. I will continue to search for an answer for you though. It's a really cool mod and would love to help you get this installed (especially since we both run Missouri NFL Team sites..lol)

[Dez_U]

I really don't have an answer for you at this point except maybe restarting your database. Through my searches I have found that this sometimes fixes this issue. I will continue to search for an answer for you though. It's a really cool mod and would love to help you get this installed (especially since we both run Missouri NFL Team sites..lol)

That would be great, I will have a go at restarting the database and see if that does it :)

[Dez_U]

Well its now working WOOHOO :)

Question now is, is there any way to update to this years schedule? I have started to update but man its taking forever? Also, how do I center it? cheers mate

and week 6 is all cocked up :)

[Reycer]

2012 Schedule was attached. It's included in the .xml file now. Here it is you can add it manually.

[Dez_U]

Cheers dude, thanks for all your help, ClanRam's Pickems is now live :)

[Reycer]

Great! I'm looking forward to seeing the Rams at the Governors Cup on the 18th. Already got my tickets. lol

[Dez_U]

Got mine for the London game :) since I live in Scotland LOL

[Preech]

Is this still using a seperate login from vbulletin.

[Krusty1231]

Is this still using a seperate login from vbulletin.

Far as I know it is. I have it installed. No change.

[Bob_R]

2012 Schedule was attached. It's included in the .xml file now. Here it is you can add it manually.

In other words, it's done automatically?

Also, the directions in the README of phppickem 1.0.8 mention to:


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

This does not need to be done, correct?

[Bob_R]

I created the database and when I run the install script it says it cannot connect to database.

FYI: I put the whole phppickem 1.0.8 folder in the root.

I had an index.php in there and didn't want to overwrite it
************************************************** **********************

EDIT:

I get this when trying to add the tab to my site

Error: The navigation element title is invalid.
************************************************** **************

EDIT:

Don't see anything in my AdminCP options

When I do this step ----> Point your browser to www.yoursite.com/pickempicks.php

I get a blank white screen

[Krusty1231]

In other words, it's done automatically?

Also, the directions in the README of phppickem 1.0.8 mention to:


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

This does not need to be done, correct?

Yes it does.

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*

Create another database - and use that - not your forum database (this is the way I did it)

I see your white page on your site. There is nothing for the login to connect to.

Once you have created your database and have the relevant information, (Password - Username -path- etc) open the config file in the phppickem folder/includes/ and enter your details.

Upload the folder to where you have it now (I put mine outside my forum) and run the install.php by going to www.yoursite.com/phppickem/install

From there the installer should take over.

[Bob_R]

Getting closer. See screen shot. File not found?

Should the // be in the code below?

// chdir ('/xxxx/xxxx/xxxx/talkclassicrock.com/forums');
require_once('./global.php');

[Bob_R]

Does the site URL in config.php get the /forums?

[Bob_R]

Upload the folder to where you have it now (I put mine outside my forum) and run the install.php by going to www.yoursite.com/phppickem/install

From there the installer should take over.

The phppickem folder is in talkclassicrock.com
The pickempicks.php file is in talkclassicrock.com/forums

Once I get to Step 3 of the installer it asks to delete the install file.

I do that

then it says to hit complete

I do that and it takes me to a blank white screen. Is this what should happen?

Here's my pickempicks.php

<?php


error_reporting(E_ALL & ~E_NOTICE);

define('THIS_SCRIPT', 'pickempicks');
define('CSRF_PROTECTION', true);


$phrasegroups = array();

$specialtemplates = array();

$globaltemplates = array('pickempicks',
);

$actiontemplates = array();

// chdir ('/xxxx/xxxx/xxxx/talkclassicrock.com/forums');
require_once('./global.php');



$navbits = construct_navbits(array('' => 'Pick Em Picks'));
$navbar = render_navbar_template($navbits);


$pagetitle = 'Pick Em Picks NFL Weekly Picks';


$templater = vB_Template::create('pickempicks');
$templater->register_page_templates();
$templater->register('navbar', $navbar);
$templater->register('pagetitle', $pagetitle);
print_output($templater->render());

?>

Here is a line from the config.php file in the phppickem folder

$siteUrl = 'http://www.talkclassicrock.com/forums/';


EDIT:

FYI: Found this in an error file

[04-Sep-2012 13:11:42] PHP Fatal error: Call to undefined function dl() in /xxxx/xxxx/xxxx/talkclassicrock.com/phppickem/includes/classes/crypto.php on line 31
[04-Sep-2012 13:16:45] PHP Fatal error: Call to undefined function dl() in /xxxx/xxxx/xxxx/talkclassicrock.com/phppickem/includes/classes/crypto.php on line 31

[Krusty1231]

Try this:

In your phppickem. php you currently have this:

// chdir ('/xxxx/xxxx/xxxx/talkclassicrock.com/forums');
require_once('./global.php');

remove the talkclassicrock.com

[Bob_R]

Nope.

This is very frustrating. Especially with football beginning tonight.

[Bob_R]

What target URL is used in the vBulletin Navigation Manager?

pickempicks.php?

[Bob_R]

I'm still open to suggestions but this did not work for me.

So, at least for now, uninstalled

[Krusty1231]

You have PM!

[mikeinjersey]

how come only 8 installs for this plugin so far ? Should be a lot more i'd figure...maybe the word just isn't out yet ?

I was just looking exactly just for this just now , as the other Tournament / Ladder / League plugin seems like too much...for a simple pick em plugin.

any security issues arised yet? It isn't typical plugin procedure to do the whole database login / password thingee .

not quite understanding why this url needs to be in config.php -

$siteUrl = 'http://localhost/personal/phppickem.com/application/ ?

and when installed, will my existing members still see the NFL login screen when logged in.. or do they have to signup remotely to another site to pick the pick'ems ?

trying to figure out this plugin..before installing.

thanks

[CAG CheechDogg]

how come only 8 installs for this plugin so far ? Should be a lot more i'd figure...maybe the word just isn't out yet ?

I was just looking exactly just for this just now , as the other Tournament / Ladder / League plugin seems like too much...for a simple pick em plugin.

any security issues arised yet? It isn't typical plugin procedure to do the whole database login / password thingee .

not quite understanding why this url needs to be in config.php -

$siteUrl = 'http://localhost/personal/phppickem.com/application/ ?

and when installed, will my existing members still see the NFL login screen when logged in.. or do they have to signup remotely to another site to pick the pick'ems ?

trying to figure out this plugin..before installing.

thanks

Anyone who wants to take part in the pickems has to create a new account but the script is hosted on your site not another one.

[legiondadon]

ive gotten this all to work so far for the season only thing i noticed is that when you click on a team the scores of the previous games does not show in the right column

[legiondadon]

TIme / Result column...nothing shows after the week is over...should say who won and stuff

[Krusty1231]

Looks like this isn't broken code so much as forgotten code - the case is there to do something if there's a score entered, but the "do something" part is just "print an empty table cell". So to fix this, you can replace line 77 in schedule.php (should be 77 - you're looking for the line after "//if score is entered, show result").

It was:

echo ' <td></td>' . "\n";

Replace it with:

echo ' <td>'.$visitorTeam->teamName.' '.$result['visitorScore'].', '.$homeTeam->teamName.' '.$result['homeScore'].'</td>' . "\n";

Here is how it should look in the first screenshot:

You could make the winners appear "bold" if you add this instead of the code above to the same location:

if ((int)$result['homeScore'] > (int)$result['visitorScore']) { echo ' <td>'.$visitorTeam->teamName.' '.$result['visitorScore'].' &larr;<b>'.$homeTeam->teamName.' '.$result['homeScore'].'</b></td>' . "\n"; } if ((int)$result['visitorScore'] > (int)$result['homeScore']) { echo ' <td><b>'.$visitorTeam->teamName.' '.$result['visitorScore'].'</b> &rarr; '.$homeTeam->teamName.' '.$result['homeScore'].'</td>' . "\n";}

And the second screenshot shows you the result.

I hope that helps you!

[legiondadon]

Hey man that did the trick Krusty i appreciate your time you took to answer my question :) worked very well

[Krusty1231]

Official Game day is 59 days away I figured I would throw up the schedule for this years games if anyone wants it.

Just import the new schedule via phpadmin.

[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

[Krusty1231]

Looking at that line it says:

dl($prefix . 'mcrypt.' . PHP_SHLIB_SUFFIX) or die('The Mcrypt module could not be loaded.');

I'm going to guess this is a server/php issue - and I say guess cause I really do not know why it will not work for you.

Perhaps someone else has a better idea.

[LgsOfChampions]

man o man, I was really excited about this mod. sigh.... thanks for the help though, appreciate it

[1320Nation]

Ok I got this plugin installed with no issues and seems to be working fine. I have a question about importing the pickem picks .xml file. It shows as a product in the Product Manager but that's it. There is no other place in the admincp or vbulletin settings does it appear after importing the .xml file.

Also I had created an account and later lost that accounts password. I noticed then when requesting to be sent another password the email part of the plug is not working. What method might there be to get the email part of the plugin working?

[1320Nation]

I didn't mean for everyone to disappear. Does anybody know what email system this plugin uses. Is it sending it's emails through the vbulletin board, the server, the database? I see in the files it says php mailer, but for me I'm clueless beyond that with the email part of this plugin. The email part of the plugin is not working on my setup for whatever reason. Any help on this would be greatly appreciated.

[Krusty1231]

Your best bet is to take your questions over here:

http://sourceforge.net/p/phppickem/discussion/998894/

Better support there for this addon than anywhere else I could find.

I hope it helps!

[1320Nation]

Your best bet is to take your questions over here:

http://sourceforge.net/p/phppickem/discussion/998894/

Better support there for this addon than anywhere else I could find.

I hope it helps!

I got the email issue resolved and thanks for the heads up with the link for support.

[LgsOfChampions]

am I suppose to make any changes to this line?
$siteUrl = 'http://localhost/personal/phppickem.com/application/';

should I add www.mydomain.com any where in it?

[Krusty1231]

Mine is like this:

$siteUrl = 'http://localhost/Football/application/';

Football being the name of the folder - not phppickem or whatever it was originally. I just renamed it to what I'd remember what it was on my FTP.

Hope it helps.

Also for those that are using it, they added some mods to it in the above thread I mentioned.

Makes the login screen and has optional team backgrounds for your users to select when entering the pool.

I just blocked out my players real names in the screenshot.

[RSNF]

I would really like to get this mod working for major league baseball. If anyone is interested please message me.

[RSNF]

Safe to say the chances of me getting this converted to mlb pickem are slim to none? Did Reycer just vanish? lol

[My Hattiesburg]

Our members asked me to try and find a pick 'em program and this looks like the only one. Any way to get this working on 4.2.1 this year?

[Krusty1231]

Works fine on 4.2.1. I did not use any of the stuff listed here however.

Go right to the source, sign up for an account with their forums for support, and the lastest updates/mods/etc.

[My Hattiesburg]

Thanks for the reply, Krusty, but after reading all the posts in this thread it looks like it's beyond my capabilities. Our tech guy could probably do it but he doesn't have a lot of time except for maintenance.

[kylek]

Is there a 2014 schedule out for this? Looking at the sites all I see are 2013.

[Krusty1231]

You are best to go here and download the latest release.

http://www.phppickem.org/forums/index.php?sid=87a1081be7247b83b93faa61ac63f247

all mods/addons/support are located on their forums.

[kylek]

Thanks Krusty1231. Did and done, very easy to install!

[BGObsession]

I use an awesome NFL Pickem program on my site. If you'd like me to steer you to it, PM me. I'm not affiliated with the vendor but it is a great option.

[kylek]

No thanks, this one now works for us.

[kylek]

Just changed it so we can use it for NHL along with NFL.