2017-18 Season Update?

Post anything not related to the support of ASP Football Software here.
twilightscapes
Posts: 3
Joined: Mon Aug 07, 2017 12:09 pm

Re: 2017-18 Season Update?

Post by twilightscapes » Tue Aug 29, 2017 1:23 am

I've downloaded the most recent version of the Access DB linked here, and I can't login as admin. Using admin, 1234, password, leaving PW blank... nothing works.

Any ideas?

smilrad
Posts: 7
Joined: Tue Aug 26, 2014 11:08 pm

Re: 2017-18 Season Update?

Post by smilrad » Tue Aug 29, 2017 9:42 pm

Good catch, Juan!

I was able to modify the db to reflect what you found. I didn't see the ability to change the type to "float," but a little research -- https://support.office.com/en-us/articl ... 77c732985a -- showed me it can be changed to "single," and the decimal places to "auto." And it works!
Attachments
NFL.zip
(37.22 KiB) Downloaded 64 times

twilightscapes
Posts: 3
Joined: Mon Aug 07, 2017 12:09 pm

Re: 2017-18 Season Update?

Post by twilightscapes » Wed Aug 30, 2017 7:43 am

Thank you! I just download the newest and now I can login as admin and everything seems to work fine.

Thank you again!

User avatar
philwojo
Posts: 132
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Post by philwojo » Wed Aug 30, 2017 9:47 am

smilrad wrote:Good catch, Juan!

I was able to modify the db to reflect what you found. I didn't see the ability to change the type to "float," but a little research -- https://support.office.com/en-us/articl ... 77c732985a -- showed me it can be changed to "single," and the decimal places to "auto." And it works!

I took this post, and split it off in to it's own topic so people can find it more easily to download if they want, I know it might be a little late, but figured it might help some people.

Phil

juanbond
Posts: 15
Joined: Sun Sep 08, 2013 4:57 pm

Re: 2017-18 Season Update?

Post by juanbond » Wed Aug 30, 2017 10:36 pm

Thanks smilrad! I tested it out and everything seems to be working properly and holding the correct point spreads. Nice work. If I come across any issues, I'll let you know.

A big thanks again for you help with it!

kingmullet
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Post by kingmullet » Thu Aug 31, 2017 9:25 am

Sledge do you have a good working copy of the SQL version of this pool? I would love to use that.

kingmullet
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Post by kingmullet » Thu Aug 31, 2017 10:14 am

can you guys provide the list of files that need to be changed to relfect the rams and chargers? I thought I updated all the CSS files and jpg's but the team logos are not displaying and it is driving me crazy

User avatar
philwojo
Posts: 132
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Post by philwojo » Thu Aug 31, 2017 10:16 am

This was posted earlier in this thread:
twiggm wrote:I also just realized that the chargers and rams logo was not showing up. You have to rename the SD and STL png files, you need to rename and edit the css for each and then edit the teamlogos.css to change the names.

Mike

kingmullet
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Post by kingmullet » Thu Aug 31, 2017 10:19 am

weird, it's not displaying in chrome, but it is in firefox and IE. ANy suggestions?

User avatar
philwojo
Posts: 132
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Post by philwojo » Thu Aug 31, 2017 10:25 am

Did you clear cache or do a hard page refresh in chrome? That is all I can think of off hand.

kingmullet
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Post by kingmullet » Thu Aug 31, 2017 12:17 pm

well I'm a big putz!! I was connected to my dev site in chrome. All is good, thanks for the help!

kingmullet
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Post by kingmullet » Thu Aug 31, 2017 12:19 pm

I'm going to work with a developer to convert everything to php using a mysql backend. I will share everything with you all when we get this going.

User avatar
raider_nation
Posts: 33
Joined: Mon Aug 26, 2013 8:10 pm

Re: 2017-18 Season Update?

Post by raider_nation » Thu Aug 31, 2017 4:05 pm

kingmullet wrote:I'm going to work with a developer to convert everything to php using a mysql backend. I will share everything with you all when we get this going.

That would be awesome! I have been wanting to do that for some time now. I just haven't had the time to learn php. This would extend the life of this program. Please keep us posted.

lurkmaster1
Posts: 8
Joined: Fri Jul 18, 2014 10:35 am

Re: 2017-18 Season Update?

Post by lurkmaster1 » Fri Sep 01, 2017 9:35 am

kingmullet wrote:I'm going to work with a developer to convert everything to php using a mysql backend. I will share everything with you all when we get this going.
That would be AWESOME!!!!!! ....!!!!!!

jasonlnlv
Posts: 12
Joined: Thu Sep 04, 2014 2:19 am

Re: 2017-18 Season Update?

Post by jasonlnlv » Sat Sep 02, 2017 2:11 pm

twiggm wrote:I also just realized that the chargers and rams logo was not showing up. You have to rename the SD and STL png files, you need to rename and edit the css for each and then edit the teamlogos.css to change the names.

Mike

What files need to be renamed/modified and changed and to what? LAC and LAR ?

angularvelocity
Posts: 6
Joined: Sun Aug 07, 2016 8:31 am

Re: 2017-18 Season Update?

Post by angularvelocity » Sun Sep 03, 2017 12:03 pm

Ready4Football, thank you for this DB! It's the one that's working for me!
But I can't admin it. "admin" isn't the password for Admin.
Thanks very much in advance for the keys to this thing,

AVelocity
ready4football.com wrote:Juanbond,

Per your request, here is a copy of the most current Access Database file.

User avatar
raider_nation
Posts: 33
Joined: Mon Aug 26, 2013 8:10 pm

Re: 2017-18 Season Update?

Post by raider_nation » Mon Sep 04, 2017 10:19 am

jasonlnlv wrote:
twiggm wrote:I also just realized that the chargers and rams logo was not showing up. You have to rename the SD and STL png files, you need to rename and edit the css for each and then edit the teamlogos.css to change the names.

Mike

What files need to be renamed/modified and changed and to what? LAC and LAR ?
Follow these steps from another post, substitute as required:

I have made the following edits:
\AspFootballPool_4.0\pool\styles - edit teamLogos.css file ........ replace STL with LA in 1 place
\AspFootballPool_4.0\pool\styles\teams - change file name from STL.css to LA.css and then edit the file to replace STL.jpg with LA.jpg in one place toward the top.
\AspFootballPool_4.0\pool\graphics\teams - Rename file STL.jpg to LA.jpg

User avatar
Stutgrtguy
Posts: 69
Joined: Sun Oct 20, 2013 3:54 pm
Location: Colorado

Re: 2017-18 Season Update?

Post by Stutgrtguy » Thu Sep 07, 2017 3:26 pm

For those that dont have it, there was code posted somewhere to reset an Admins password to admin. Make a new asp page, paste the following code in, name it whatever you want when you need to reset it type in that page name in your browser.

Code: Select all

<%@ LANGUAGE="VBScript" %>
<!-- #include file="includes/config.asp" --><!-- #include file="includes/common.asp" --><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!-- #include file="includes/passwords.asp" -->
<%	'Open the database.
	call OpenDb() %>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<%	PageSubTitle = "Reset Administrator Password"
	call BuildPageHeader("", "") %>
<!-- #include file="includes/custom.asp" -->
</head>
<body>
<!-- #include file="includes/header.asp" -->
<!-- #include file="includes/menu.asp" -->
	<div id="contentSection">
	<table id="mainWrapper" border="0" cellpadding="0" cellspacing="0"><tr><td>
<%	dim salt, sql, rs
	salt = CreateSalt()
	sql = "UPDATE Users SET" _
	   & " Salt = '" & salt & "', " _
	   & " [Password] = '" & Hash(salt & "admin") & "'" _
	   & " WHERE Username = '" & SqlEscape(ADMIN_USERNAME) & "'"
	call DbConn.Execute(sql)
	call DisplaySuccessMessage("Administrator password has been reset.")
	%>
	<div style="width: 40em;">&nbsp;</div>
	</td></tr></table>
<!-- #include file="includes/footer.asp" -->
</body>
</html>

Post Reply