Search found 36 matches

by RPHALabs
Sun Jun 30, 2019 7:19 am
Forum: Third Party and Add-ons Programs / Programmes Tiers
Topic: Player Creation
Replies: 1
Views: 5546

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...
by RPHALabs
Sun Apr 22, 2018 5:14 pm
Forum: Suggestions
Topic: Création d'un nouveau portail
Replies: 59
Views: 32776

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
by RPHALabs
Mon Sep 19, 2016 12:58 pm
Forum: Announcements / Annonces
Topic: STHS Web Client Test
Replies: 109
Views: 105159

Re: STHS Web Client Test

Thanks for this. I will look to update this as soon as I can

Cheers
by RPHALabs
Sun Jun 12, 2016 1:47 pm
Forum: Announcements / Annonces
Topic: V3: 3.0.6 / STHS
Replies: 18
Views: 16941

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 ...
by RPHALabs
Thu Sep 17, 2015 12:54 pm
Forum: Website Forum / Forum de Page Web
Topic: Website built with SQLite
Replies: 16
Views: 12605

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
by RPHALabs
Thu Sep 17, 2015 12:17 pm
Forum: Website Forum / Forum de Page Web
Topic: Website built with SQLite
Replies: 16
Views: 12605

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...
by RPHALabs
Tue Aug 18, 2015 12:24 pm
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

Re: SQLite

Instead of a new table could you just not add a new field to the RankingOrder table called WaiverOrder?
by RPHALabs
Tue Aug 18, 2015 10:18 am
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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...
by RPHALabs
Mon Aug 17, 2015 10:20 am
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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?
by RPHALabs
Mon Aug 10, 2015 8:02 am
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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...
by RPHALabs
Fri Aug 07, 2015 10:22 am
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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
by RPHALabs
Fri Aug 07, 2015 7:22 am
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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?
by RPHALabs
Sat Jul 11, 2015 10:15 am
Forum: Suggestions
Topic: Jersey Numbers
Replies: 60
Views: 30778

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...
by RPHALabs
Sat Jul 11, 2015 7:38 am
Forum: Suggestions
Topic: Jersey Numbers
Replies: 60
Views: 30778

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...
by RPHALabs
Sun Jun 28, 2015 5:09 pm
Forum: Website Forum / Forum de Page Web
Topic: SQLite
Replies: 73
Views: 40857

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...