Thread: Major Additions - Pick Em Picks - NFL
View Single Post
  #80  
Old 09-03-2013, 06:26 AM
Krusty1231's Avatar
Krusty1231 Krusty1231 is offline
 
Join Date: Jul 2010
Location: Canada
Posts: 366
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02448 seconds
  • Memory Usage 1,766KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete