Author Topic: Up-to-date drop-list generators?  (Read 5925 times)

0 Members and 1 Guest are viewing this topic.

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Up-to-date drop-list generators?
« on: February 03, 2011, 03:06:31 PM »
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?
<Insert cool content here>

Offline ~SJ~ Wolf

  • Penalty bench
  • Star Colonel
  • *****
  • Posts: 1341
  • l33tp0intz: +148/-2
  • The HNIC of Toast is too baller for avatars.
Re: Up-to-date drop-list generators?
« Reply #1 on: February 03, 2011, 06:19:07 PM »

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #2 on: February 03, 2011, 10:17:13 PM »
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?
<Insert cool content here>

Offline CHH Deathshade

  • Senior Developer
  • Star Captain
  • *
  • Posts: 1027
  • l33tp0intz: +57/-0
  • "Helpful Atlas"
    • MW:LL
Re: Up-to-date drop-list generators?
« Reply #3 on: February 18, 2011, 04:59:14 AM »
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.  8)

[attachment deleted by admin]

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #4 on: February 18, 2011, 05:12:10 AM »
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.

<Insert cool content here>

Offline CHH Deathshade

  • Senior Developer
  • Star Captain
  • *
  • Posts: 1027
  • l33tp0intz: +57/-0
  • "Helpful Atlas"
    • MW:LL
Re: Up-to-date drop-list generators?
« Reply #5 on: February 18, 2011, 01:48:47 PM »
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]

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #6 on: February 18, 2011, 04:38:25 PM »
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]
<Insert cool content here>

Offline CHH Deathshade

  • Senior Developer
  • Star Captain
  • *
  • Posts: 1027
  • l33tp0intz: +57/-0
  • "Helpful Atlas"
    • MW:LL
Re: Up-to-date drop-list generators?
« Reply #7 on: February 19, 2011, 12:31:21 AM »
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


Offline 7.[WD]Ragor

  • Star Colonel
  • ****
  • Posts: 1299
  • l33tp0intz: +111/-3
  • Maj.7thWolf'sDragoons a.D.
    • 7th. Regiment 'eta' Wolf Dragoons
Re: Up-to-date drop-list generators?
« Reply #8 on: February 19, 2011, 12:44:24 AM »
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)


Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #9 on: February 19, 2011, 08:11:58 AM »
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]
« Last Edit: February 19, 2011, 01:22:59 PM by 7.[WD]Cygma »
<Insert cool content here>

Offline CHH Deathshade

  • Senior Developer
  • Star Captain
  • *
  • Posts: 1027
  • l33tp0intz: +57/-0
  • "Helpful Atlas"
    • MW:LL
Re: Up-to-date drop-list generators?
« Reply #10 on: February 19, 2011, 02:43:54 PM »
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]

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #11 on: February 19, 2011, 04:36:58 PM »
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.
« Last Edit: February 19, 2011, 04:54:27 PM by 7.[WD]Cygma »
<Insert cool content here>

Offline CHH Deathshade

  • Senior Developer
  • Star Captain
  • *
  • Posts: 1027
  • l33tp0intz: +57/-0
  • "Helpful Atlas"
    • MW:LL
Re: Up-to-date drop-list generators?
« Reply #12 on: February 19, 2011, 05:24:14 PM »
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.

Offline Xarg Talasko

  • Living Legend
  • *******
  • Posts: 2960
  • l33tp0intz: +159/-6
  • KANE LIVES!
Re: Up-to-date drop-list generators?
« Reply #13 on: July 15, 2011, 03:33:59 PM »
Awesome A is incorrectly listed as being 136,896 cbills, it should be 99,095 instead.


Thief gameplay + Doom3 engine = The Dark Mod

Offline Cygma

  • MWLL Developer
  • Star Colonel
  • *
  • Posts: 1498
  • l33tp0intz: +65/-1
    • 7th Regiment Wolfs Dragoons
Re: Up-to-date drop-list generators?
« Reply #14 on: July 15, 2011, 03:43:53 PM »
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).
<Insert cool content here>