2017-18 Season Update?

Post anything not related to the support of ASP Football Software here.

Re: 2017-18 Season Update?

Postby 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?
Random avatar
twilightscapes
 
Posts: 3
Joined: Mon Aug 07, 2017 12:09 pm

Re: 2017-18 Season Update?

Postby 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 22 times
Random avatar
smilrad
 
Posts: 7
Joined: Tue Aug 26, 2014 11:08 pm

Re: 2017-18 Season Update?

Postby 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!
Random avatar
twilightscapes
 
Posts: 3
Joined: Mon Aug 07, 2017 12:09 pm

Re: 2017-18 Season Update?

Postby 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
User avatar
philwojo
 
Posts: 131
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Postby 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!
Random avatar
juanbond
 
Posts: 14
Joined: Sun Sep 08, 2013 4:57 pm

Re: 2017-18 Season Update?

Postby 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.
Random avatar
kingmullet
 
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Postby 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
Random avatar
kingmullet
 
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Postby 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
User avatar
philwojo
 
Posts: 131
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Postby kingmullet » Thu Aug 31, 2017 10:19 am

weird, it's not displaying in chrome, but it is in firefox and IE. ANy suggestions?
Random avatar
kingmullet
 
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Postby 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.
User avatar
philwojo
 
Posts: 131
Joined: Mon Aug 26, 2013 4:22 pm

Re: 2017-18 Season Update?

Postby 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!
Random avatar
kingmullet
 
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Postby 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.
Random avatar
kingmullet
 
Posts: 39
Joined: Thu Sep 05, 2013 3:21 pm

Re: 2017-18 Season Update?

Postby 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.
User avatar
raider_nation
 
Posts: 33
Joined: Mon Aug 26, 2013 8:10 pm

Re: 2017-18 Season Update?

Postby 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!!!!!! ....!!!!!!
Random avatar
lurkmaster1
 
Posts: 8
Joined: Fri Jul 18, 2014 10:35 am

Re: 2017-18 Season Update?

Postby 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 ?
Random avatar
jasonlnlv
 
Posts: 12
Joined: Thu Sep 04, 2014 2:19 am

Re: 2017-18 Season Update?

Postby 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.
Random avatar
angularvelocity
 
Posts: 3
Joined: Sun Aug 07, 2016 8:31 am

Re: 2017-18 Season Update?

Postby 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
raider_nation
 
Posts: 33
Joined: Mon Aug 26, 2013 8:10 pm

Re: 2017-18 Season Update?

Postby 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>
User avatar
Stutgrtguy
 
Posts: 66
Joined: Sun Oct 20, 2013 3:54 pm
Location: Colorado

Previous

Return to General Topics

Who is online

Users browsing this forum: No registered users and 1 guest

cron