STHS Forum

It can be optional by value. Example : If the sum of the column PlayerID === 0 the import don't use this column in the import process. If sum > 0, each time the value is different of 0 it update the matching player ID otherwise (id == 0) the player goes to unassigned like it was now. Like I said, ju...

You can use a CLOB (Character Large OBject) or BLOB (Binary Large OBject) datafield in SQLite. (Can store 1 billion of byte of data)

I can help on table design for this if needed.

ok.

It's not for a performance issue but for a pratical thing, a league portal or website will be able to run by only uploading one file per simulation (the SQLite database).

Simon is it a possible thing to have an optional ID "column" in the import rating pack ? Leagues making their rating will be able to use ID in the import process to link new rating with existing player (some time you want to correct mispelling player over offseason, by example). Just an id...

I agree with Owen. If it's possible to, instead of putting unrated players in prospect list when updating rating, having those players on a league leaving/retired status. They will stay linked to their last team and have their ID kept. It will be easy to reinstated them to their team without screw t...

Is it Number or InternalNumber ?

By reusing ID over time it's like saying that seasons/players/teams are not linked each other while the are (carreer stats, expansion, team moving city but same concession, etc). Like said earlier, having a Unique ID over time would be a great step forward for all web/application developper. Mostly ...

Any plan to have boxscore into SQLite ?

For me I'll prefer an XML file. More simple, less code, less modification (i.e no SQLite modification) and the fastest way. Simply provide a XML schema (structure) for a team line and voilà A webpage for online line editing (or iPad/iPhone app, Android app, etc.) would create a team XML line file fo...

Maybe this command can be declined in 2-3 sub command like :

Goaltender start X games
Goaltender played X minutes
Goaltender played x games

Looks to be a portal error. MySQL is not use by STHS.

Ce n'est pas fourni avec le simulateur. Ce que tu achètes c'est le simulateur et ses mises à jour. Pour le reste tu dois créer ton site. Le portail que tu vois est disponible pour téléchargement gratuitement. Tu peux le télécharger ici . En cas de pépins tu pourras t'adresser à ce forum http://sths....

Nothing good in my tests. The only way to have advanced sorting would be to have one page per team.
--
Rien de probant, dans le meilleur des mondes il faudrait créer une page par équipe pour permettre le tri avancé des colonnes.

He would like to be able to send in farm a player that should pass by waiver without put it on waiver when you're in the simulator.
--
Il souhaiterait pouvoir envoyer un joueur qui doit passer par le ballottage dans les mineurs sans le mettre au ballottage lorsqu'on est dans le simulateur.

I get an error when I test the SQLite database output. It looks to be a problem with players having an ' in their name.

The database still readable and I can't say what data is missing.