2017-18 Season Update?

[twilightscapes]

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]

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!

[twilightscapes]

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

Thank you again!

[philwojo]

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]

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]

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

[kingmullet]

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

[philwojo]

This was posted earlier in this thread:

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]

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

[philwojo]

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

[kingmullet]

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

[kingmullet]

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.

[raider_nation]

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]

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]

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]

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

Juanbond,

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

[raider_nation]

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

[Stutgrtguy]

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>