Search found 36 matches
- Sun Jun 30, 2019 7:19 am
- Forum: Third Party and Add-ons Programs / Programmes Tiers
- Topic: Player Creation
- Replies: 1
- Views: 10450
Player Creation
Hey Everyone, I know there has been talk about this before in here however, I am curious about something. I have created a player generator for the RPHA and ANHS which is specific to their leagues. Recently I have started modifying it for public use and would like to set up a small Patreon subscript...
- Sun Apr 22, 2018 5:14 pm
- Forum: Suggestions
- Topic: Création d'un nouveau portail
- Replies: 59
- Views: 34796
Re: Création d'un nouveau portail
Hey Folks,
Yes I built the ANHS site, and would be interested if you could figure out the funding. Just email me exactly what you are looking for and I will send a quote
[email protected]
like Simon said I am english speaking so everything english would be much easier for me
Cheers
Yes I built the ANHS site, and would be interested if you could figure out the funding. Just email me exactly what you are looking for and I will send a quote
[email protected]
like Simon said I am english speaking so everything english would be much easier for me
Cheers
- Mon Sep 19, 2016 12:58 pm
- Forum: Announcements / Annonces
- Topic: STHS Web Client Test
- Replies: 109
- Views: 141541
Re: STHS Web Client Test
Thanks for this. I will look to update this as soon as I can
Cheers
Cheers
- Sun Jun 12, 2016 1:47 pm
- Forum: Announcements / Annonces
- Topic: V3: 3.0.6 / STHS
- Replies: 18
- Views: 19679
Re: V3: 3.0.6 / STHS
This is a treat for me to be part of this release. There are some major steps to merge in with existing sites, but it can be done. I am hoping to get the documentation up on GitHub over the next few days. I am very exited to be part of the STHS community. Without STHS the leagues I have been a part ...
- Thu Sep 17, 2015 12:54 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Website built with SQLite
- Replies: 16
- Views: 13027
Re: Website built with SQLite
Oh I guess I should also have LIMIT 10 at the end of those:
SELECT Name, G FROM PlayerProStat WHERE GP > 0 ORDER BY G DESC LIMIT 10
SELECT Name, ROUND((SA - GA) / CAST(SA AS REAL),3) AS SavePercentage FROM GoalerProStat WHERE GP > 0 ORDER BY SavePercentage DESC LIMIT 10
SELECT Name, G FROM PlayerProStat WHERE GP > 0 ORDER BY G DESC LIMIT 10
SELECT Name, ROUND((SA - GA) / CAST(SA AS REAL),3) AS SavePercentage FROM GoalerProStat WHERE GP > 0 ORDER BY SavePercentage DESC LIMIT 10
- Thu Sep 17, 2015 12:17 pm
- Forum: Website Forum / Forum de Page Web
- Topic: Website built with SQLite
- Replies: 16
- Views: 13027
Re: Website built with SQLite
Bmoney0313 just remember everything is a separate SQL statement, so each of the leaders is a separate recordset from the DB. Example SELECT Name, G FROM PlayerProStat WHERE GP > 0 ORDER BY G DESC Also, make sure all your calculated stats are in your SQL Statement as well (especially for goalies) SEL...
- Tue Aug 18, 2015 12:24 pm
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
Instead of a new table could you just not add a new field to the RankingOrder table called WaiverOrder?
- Tue Aug 18, 2015 10:18 am
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
I may not be understanding fully what you are saying. When I look in the RankingOrder Table the TeamOrder field ranks the overall standings. Are you are saying the reverse of this is the waivers ranking? From the information I have gathered and understood, the Waiver Order is based on the previous y...
- Mon Aug 17, 2015 10:20 am
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
Thanks for looking into that Simon. Its appreciated.
Also, I don't believe the Waiver Order information is anywhere in the SQLiteDB. Should this be added to the RankingOrder table?
Also, I don't believe the Waiver Order information is anywhere in the SQLiteDB. Should this be added to the RankingOrder table?
- Mon Aug 10, 2015 8:02 am
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
Sorry, I don't speak french very well. So please excuse if I don't get the full translation of that. My email address is swarsenault@gmail.com and the URL for the file is http://anhs.qc.ca/output_saison/STHS.db It actually worked for 2 days and there were transactions in them Friday and Saturday nig...
- Fri Aug 07, 2015 10:22 am
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
HTML Transactions is populated - http://anhs.qc.ca/output_saison/ANHS-Transactions.html
CSV Transactions is populated - http://anhs.qc.ca/output_saison/csvxml/ ... action.csv
SQLite Table empty
CSV Transactions is populated - http://anhs.qc.ca/output_saison/csvxml/ ... action.csv
SQLite Table empty
- Fri Aug 07, 2015 7:22 am
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
Hey Simon, Trying to use the LeagueLog table in 2.3.1 and the entire table is empty. There is not one record in the table at all. Is this a bug of some sort? Am I missing something? I do see a change in the table schema as you have the color and text separated in the fields, but no records?
- Sat Jul 11, 2015 10:15 am
- Forum: Suggestions
- Topic: Jersey Numbers
- Replies: 60
- Views: 30983
Re: Jersey Numbers
I was thinking for both, but only 1 number per pro and farm together so at default, farm players would have different numbers than pro. Whatever you would think is best and easiest to build just to have the Jersey field populated. Its a great feature added to STHS, I think it should be used to its f...
- Sat Jul 11, 2015 7:38 am
- Forum: Suggestions
- Topic: Jersey Numbers
- Replies: 60
- Views: 30983
Re: Jersey Numbers
Simon, Just another thought on Jersey numbers. I realize the importance of a Jersey number is 100% personal opinion. And I also know that your thought on Jersey Number is not a high priority when it comes to development, however, since you already have the function made to notify if that number is a...
- Sun Jun 28, 2015 5:09 pm
- Forum: Website Forum / Forum de Page Web
- Topic: SQLite
- Replies: 73
- Views: 41973
Re: SQLite
I disagree, there are numerous ways to use subqueries to get the ranking system you want. I would do something like this, I am sure you can modify this to do whatever you need: SELECT i.Name, r.TeamOrder AS OverallOrder, ( SELECT COUNT(*) FROM TeamProInfo AS i2 LEFT JOIN RankingOrder AS r2 ON r2.Tea...