Page 5 of 5

Re: SQLite

Posted: Sat Aug 08, 2015 4:26 pm
by SimonT
Envoie-moi ton fichier STH par courriel s.v.p. Je vais regarder.

Re: SQLite

Posted: Mon Aug 10, 2015 8:02 am
by RPHALabs
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 [email protected] 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 night, however this morning there is only 1 record in it. The Record is in the transaction.html file http://anhs.qc.ca/output_saison/ANHS-Transactions.html but there should be alot more, and no other records are there at all.

Re: SQLite

Posted: Mon Aug 10, 2015 8:08 am
by SimonT
Sorry for the french answer. Send me yor STHS league file by email please.

Re: SQLite

Posted: Mon Aug 10, 2015 5:56 pm
by SimonT
In your case. you shouldn't have this issue? : http://sths.simont.info/Forum/viewtopic ... 28&t=12023

In 2.3.1, I have this issue but on my latest build, it's fine.

Re: SQLite

Posted: Tue Aug 11, 2015 8:27 am
by Président ANHS
Yes, I am still having the issue you a referring to when I sim every night...really annoying...lol

Re: SQLite

Posted: Tue Aug 11, 2015 10:10 pm
by SimonT
Then your LeagueLog Table will be empty until 2.3.2 is release.

Re: SQLite

Posted: Mon Aug 17, 2015 10:20 am
by RPHALabs
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?

Re: SQLite

Posted: Mon Aug 17, 2015 6:09 pm
by SimonT
The waiver order ir the reverse order the RankingOrder table.

Re: SQLite

Posted: Tue Aug 18, 2015 10:18 am
by RPHALabs
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 years overall standings at the first of the new season, and its that order that changes throughout the season based on teams claiming players. Therefore, that column reverse cannot be waiver order:

This order
http://anhs.qc.ca/output_saison/ANHS-Waivers.html
is not equal to the Reverse overall standings from
http://anhs.qc.ca/output_saison/ANHS-ProStanding.html

if I am misunderstanding please let me know so I can adjust my knowledge in how this works.

Thanks

Re: SQLite

Posted: Tue Aug 18, 2015 11:29 am
by Président ANHS
Traduction:

Quand on regarde l'ordre de la page waivers du STHS, l'ordre n'est pas le même que celui qui se retrouve dans le fichier SQLite.

De plus, malgré ce que tu disais Simon, le waiver order n'est pas l'ordre inversé du RankingOrder table.

Peut-être que c'est le cas au début de la saison régulière, mais une fois que des joueurs sont réclamés au ballottage...plus rien n'est pareil entre les fichiers.

Re: SQLite

Posted: Tue Aug 18, 2015 12:19 pm
by SimonT
Look at the "Run Reverse Waiver at %" option. This is what I'm speaking about.

But you are right, it's not always correct. I add a new table call WaiverOrder for the next version.

Re: SQLite

Posted: Tue Aug 18, 2015 12:24 pm
by RPHALabs
Instead of a new table could you just not add a new field to the RankingOrder table called WaiverOrder?

Re: SQLite

Posted: Tue Aug 18, 2015 3:16 pm
by SimonT
I already did it with a new table so.

Re: SQLite

Posted: Sun Nov 15, 2015 9:14 pm
by LNHVQ
Bonjour, je comprends bien l'anglais mais comme il n'est pas à 100% à l'écrit, voilà! :)

Nous utilisons SHTS depuis quelques années déjà et nous avons rien à dire, nous sommes super content du produit!

J'ai créé un site Internet pour la ligue, mais il date du temps où j'étais encore à l'école héhé! Ça fait maintenant 8 ans que je travail comme programmeur Web, et je suis en train de rebâtir ce site Internet de A à Z.

Au départ je voulais créer un importateur PHP/XML, mais aujourd'hui, j'ai vu qu'il était maintenant avec SQLite, WOW! Ça fait ma journée héhé! Je sais, je suis en retard...lol!

Bref, j'ai maintenant une horaire chargée avec mes deux petites filles, mais si vous avez des questions concernant PHP, CSS, HTML, Javascript, tout ce qui touche au Web, incluant le responsive, ça me fera un grand plaisir de vous aider!