Up-to-date drop-list generators?

[Cygma]

Does anyone already have any up-to-date drop-list generators for leagues etc.?

If not, i could offer to generate the asset-data, but someone would have to do the front-end.
I know of this one:
http://sj.rising.at/list/droplist.php
but it is outdated and i don't know if the backend source is available?

[~SJ~ Wolf]

Send the +karma to Zathrus

http://www.mediafire.com/?5xp19dv31j05217

[Cygma]

Nice, will do
Still, anyone up for writing/updating some click-your-droplist-together which can be fed with data i generate via a script?

[CHHš Deathshade]

The one Tajin gave Legends Arena is running here:

http://www.fcleagues.com/fcmwll/dropdeck.php

If you can generate the assets info for these tables, I can update it. If you need a format other than the original SQL tables this pulled from , let me know and I will generate as csv or excel. I was going to do this manually but seems you got a handle on it. I will upload an updated one after wards so SJ can get theirs updated as well. These will be sorely needed in the upcoming battles. 

[attachment deleted by admin]

[Cygma]

Ah, now we're getting somewhere
The dump is missing the equipment table though? Also note that i currently can't generate cost_ammo and cost_ba.

[CHHš Deathshade]

Well. Whatever is left I will have to manually do but no biggy. It has to be done. I wanted to integrate this into the challenges to be seen only by the participants of the unit for the challenges.



[attachment deleted by admin]

[Cygma]

Done, let me know if this format isn't quite suitable for importing for you. I also rechecked ammo/BA equipment thanks to Ragors patience

[attachment deleted by admin]

[CHHš Deathshade]

Ok. What do we have left? It is up and running on www.fcleagues.com now. Haven't verified it yet but it sounds like you guys already did and thanks for that.

http://www.fcleagues.com/fcmwll/dropdeck.php

[7.[WD]Ragor]

Awesome job!!

Just checked the list, found only 2 flaws:
#1 Bushwacker A has as equipment listed '1x' (missing the LAMS entry). I checked ~20 variants, only the Bushy A has this 'problem', all others are fine.
#2 wrong alphabetical order (Prime -> A -> C -> B -> E -> D)

[Cygma]

Good catch on #1, i missed the LAMS in the equipment list. Updated dump attached.

Edit: Updated dump with variants being inserted in order.
Edit2: I guess the #1 issue appears when there is no special equipment for a mech (LAMS, GECM, BAP, C3, ...).

[attachment deleted by admin]

[CHHš Deathshade]

Imported new SQL updates for assets and set all equipment nulls to zero.

Here is a fresh dump of the tables SJ version of this. Let me know guys if I can help get this running again on the Smoke Jags site especially since this is your unit's code.

Test the null equipments and see if that is fixed. Is there anything else that needs verifying?



[attachment deleted by admin]

[Cygma]

Hm, the FCL dropdeck shows only "1x", "2x" etc. instead of "1x LAMS" etc. (see e.g. Bushy A, Atlas A).
Maybe the equipment table wasn't updated to my last dump that includes the LAMS?

Edit: Yep, your last export is missing the (11, 'LAMS') row.

[CHHš Deathshade]

gotcha. Updated it. It still shows 1xnull but I will figure that out once I get it to start storing decks to be referenced in the challenges.

[~SJ~ Xarg Talasko]

Awesome A is incorrectly listed as being 136,896 cbills, it should be 99,095 instead.

[Cygma]

Good catch, might be an oversight due to the prices being put in manually (as i haven't updated the script yet to directly use mwllDumpPrices).