Page 2 of 2

Re: 2017-18 Season Update?

Posted: Tue Aug 29, 2017 1:23 am
by 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?

Re: 2017-18 Season Update?

Posted: Tue Aug 29, 2017 9:42 pm
by 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!

Re: 2017-18 Season Update?

Posted: Wed Aug 30, 2017 7:43 am
by twilightscapes
Thank you! I just download the newest and now I can login as admin and everything seems to work fine.

Thank you again!

Re: 2017-18 Season Update?

Posted: Wed Aug 30, 2017 9:47 am
by philwojo
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

Re: 2017-18 Season Update?

Posted: Wed Aug 30, 2017 10:36 pm
by 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!

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 9:25 am
by kingmullet
Sledge do you have a good working copy of the SQL version of this pool? I would love to use that.

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 10:14 am
by 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

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 10:16 am
by philwojo
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

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 10:19 am
by kingmullet
weird, it's not displaying in chrome, but it is in firefox and IE. ANy suggestions?

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 10:25 am
by philwojo
Did you clear cache or do a hard page refresh in chrome? That is all I can think of off hand.

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 12:17 pm
by kingmullet
well I'm a big putz!! I was connected to my dev site in chrome. All is good, thanks for the help!

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 12:19 pm
by 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.

Re: 2017-18 Season Update?

Posted: Thu Aug 31, 2017 4:05 pm
by raider_nation
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.

Re: 2017-18 Season Update?

Posted: Fri Sep 01, 2017 9:35 am
by lurkmaster1
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!!!!!! ....!!!!!!

Re: 2017-18 Season Update?

Posted: Sat Sep 02, 2017 2:11 pm
by jasonlnlv
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 ?

Re: 2017-18 Season Update?

Posted: Sun Sep 03, 2017 12:03 pm
by 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
ready4football.com wrote:Juanbond,

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

Re: 2017-18 Season Update?

Posted: Mon Sep 04, 2017 10:19 am
by raider_nation
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

Re: 2017-18 Season Update?

Posted: Thu Sep 07, 2017 3:26 pm
by 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>