Missing historical drops

[yangwao]

Can we add historical drops we've made to the drops page?

I can think of .cpu is missing, Swirls, Assemblies, Christmas City, Whirls, SnowFlakes, pare1d0scope

[JustLuuuu]

Wall street Art..

But I guess those drop page links are not working. Assemblies: https://kodadot.xyz/ahp/drops/assemblies

[daiagi]

@vikiival @preschian

worker returns only 13 results why is that?

[vikiival]

why is that?

Because we have not migrated old drops

[yangwao]

Because we have not migrated old drops

What does needs to be done for that?

[vikiival]

All should be there

select
    id,
    chain,
    collection,
    table_ref,
    case price
        when price = '0' then 'free'
        when price is null then 'free'
        else 'paid'
    end as type,
    price,
    active,
    1 as disabled,
    image,
    banner,
    alias,
    meta,
    content,
    created_at,
    max as minted,
    holds as holder_of
    from campaigns where type = 'generative' and chain = 'ahp';

INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genpareidoscope', 'ahp', '38', 'mints_gen_pareidoscope', 'free', '0', 0, 1, 'ipfs://ipfs/bafybeieqyq3tmjk3midkmls2ffz6ytlrqb4pok47h5zbdrmgiavkgmliem', 'ipfs://bafybeiczxlc4gpvsyd4uvygd454bpco2t5u5qpp73w4urcafikhumy3hs4/banner.png', 'pareidoscope', null, 'ipfs://bafybeihq5nhb6hzyjmkunpj2xmoz7m6pt54wjfioemo4yw5l5uz647ue5m', '2023-11-15 15:22:31', null, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genswirls', 'ahp', '40', 'mints_gen_swirls', 'free', '0', 0, 1, 'ipfs://bafybeid6fpmus5uadyitavxsw7s6jtq3rvh72nuejff6yr23gz5nzsytl4/image.png', 'ipfs://bafybeid6fpmus5uadyitavxsw7s6jtq3rvh72nuejff6yr23gz5nzsytl4/banner.png', 'swirls', null, 'ipfs://bafybeiakkzle3zsycvzpnkqtffqyq7njkt63vnmatkwijbg7kchq6s4she', '2023-11-22 18:59:11', null, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('gensnowflakes', 'ahp', '46', 'mints_gen_snowflakes', 'free', '0', 0, 1, 'ipfs://ipfs/bafkreigb6e5fkyoud5pci7w5v2zxto2lfu2hzcn6nks74of4gg4ucx3kue', 'ipfs://ipfs/bafkreigb6e5fkyoud5pci7w5v2zxto2lfu2hzcn6nks74of4gg4ucx3kue', 'snowflakes', null, 'ipfs://bafybeicsok7iu7nllized4o2bf4kzkh6u7jricewl6v5ruvx6dpifvakoy', '2023-11-29 15:42:34', 512, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genmotherboard', 'ahp', '50', 'mints_gen_motherboard', 'free', '0', 0, 1, 'ipfs://bafkreidysdfwatwczvie42td7yomkdirhkdnskonucfhfmkm2ifel4ibdq', 'ipfs://bafkreidysdfwatwczvie42td7yomkdirhkdnskonucfhfmkm2ifel4ibdq', 'motherboard', null, 'ipfs://bafybeihdrwq23xxtolehk7rmwvd4bkvq6dpidzfpox4dhtknfn3igajnza', '2023-12-07 10:45:09', 1024, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genwallstreet', 'ahp', '49', 'mints_gen_wallstreet', 'free', '0', 0, 1, 'ipfs://bafybeibv7bxpwll6jzqecsgfumiw3a3zz5k5j7dnnofobf4nxaopf5fh7a', 'ipfs://bafybeibv7bxpwll6jzqecsgfumiw3a3zz5k5j7dnnofobf4nxaopf5fh7a', 'wallstreet', '200000000000', 'ipfs://bafybeigoqfhv75wegatvqwnrrzrivj242sflv6uriuowo6azsrcqarx6pa', '2023-12-07 15:03:42', 512, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genchroma', 'ahp', '51', 'not_mints_gen_chroma', 'free', '0', 0, 1, 'ipfs://bafybeigw5theo5qvik66t6l3necfmwfklz2lkqlq6xeqvc6zadonxdxw4e/image.PNG', 'ipfs://bafybeigw5theo5qvik66t6l3necfmwfklz2lkqlq6xeqvc6zadonxdxw4e/image.PNG', 'chroma', '20000000000', 'ipfs://bafybeibsozbletc3shmoizmk2hfogtvviw5mjmarfwwq7fd7cfyms6gyni', '2023-12-12 11:56:31', 256, '50');
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genwhirls', 'ahp', '52', 'mints_gen_whirls', 'free', '0', 0, 1, 'ipfs://bafybeiat2gqeegb5wbqm74w3xuiicsruc6rrha2abqugvfsxq6cimmlf3q', 'ipfs://bafybeiat2gqeegb5wbqm74w3xuiicsruc6rrha2abqugvfsxq6cimmlf3q', 'whirls', null, 'ipfs://bafybeigwm33kmzz5c2lf74nlpxusymmqlhrgqtzniabni4vn3gcumxvu2m', '2023-12-13 12:10:03', 1024, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genchristmascity', 'ahp', '60', 'mints_gen_city', 'free', '0', 0, 1, 'ipfs://bafybeigvvufg6q6vtlxqow2lofuav56i4ne5hnv7aeemxth4xlutq5bsie/image.png', 'ipfs://bafybeigvvufg6q6vtlxqow2lofuav56i4ne5hnv7aeemxth4xlutq5bsie/image.png', 'christmascity', null, 'ipfs://bafybeigcy6t5bdki3wmp2krh4yfiog5cheou7j6csmcugriayr7xvtp5w4', '2023-12-20 15:36:34', 512, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('gengenera', 'ahp', '63', 'mints_gen_genera', 'free', '0', 0, 1, 'ipfs://bafybeifwwnmynvbmoimo2rayiqoul5yqmxvk2bhp7z45pr2jh26vcwhoym/image.jpeg', 'ipfs://bafybeifwwnmynvbmoimo2rayiqoul5yqmxvk2bhp7z45pr2jh26vcwhoym/banner.jpeg', 'genera', null, 'ipfs://bafybeiaf5to3z6hqi64gvksb6nljoadd4taqbpbr4v6eux3u3wgfi5tcue', '2023-12-27 09:36:26', 512, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('gensplit', 'ahp', '66', 'mints_gen_split', 'paid', '3000000000', 0, 1, 'ipfs://bafybeiejjdxx5esg3nsykkihhdu76vi6v7ncilxx3rjwprvdedhdpqd6nu/image.jpeg', 'ipfs://bafybeiejjdxx5esg3nsykkihhdu76vi6v7ncilxx3rjwprvdedhdpqd6nu/image.jpeg', 'split', '5000000000', 'ipfs://bafybeiefxnzlfjeopmow5lwvldfbjdl3a5u6la6gc446p5w4hyfhmlz6yi', '2024-01-02 15:05:36', 256, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genassemblies', 'ahp', '76', 'mints_gen_assemblies', 'paid', '3000000000', 0, 1, 'ipfs://bafybeidknz2ev3sfiplke332eoi6mf743zd63cjx47inxmrdbohrvk4nfu/image.png', 'ipfs://bafybeidknz2ev3sfiplke332eoi6mf743zd63cjx47inxmrdbohrvk4nfu/image.png', 'assemblies', '5000000000', 'ipfs://bafybeiay7nif42ls7qfurogvafyhnflznpar2bqgq322zckz5i5ivuni6e', '2024-01-10 14:42:14', 256, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('gencpu', 'ahp', '77', 'mints_gen_cpu', 'free', '0', 0, 1, 'ipfs://bafybeih4zi5etgtgyci2xfgugbr4xuzadiaajwrmbdnnabmzre3thuwg7q/image.png', 'ipfs://bafybeih4zi5etgtgyci2xfgugbr4xuzadiaajwrmbdnnabmzre3thuwg7q/banner.png', 'cpu', '5000000000', 'ipfs://bafybeigrtpyvhhgjlf56bnmndoiv7tv73npmgcy2mwvbxlipvi6go7em3m', '2024-01-15 17:01:52', 512, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genalchemy', 'ahp', '82', 'mints_gen_alchemy', 'paid', '3000000000', 1, 1, 'ipfs://bafkreifb6mmup67vdnbz76gmck27salfjpgt57xalspgcxpsm3fplekb7i', 'ipfs://bafkreifb6mmup67vdnbz76gmck27salfjpgt57xalspgcxpsm3fplekb7i', 'alchemy', '5000000000', 'ipfs://bafybeieo6ghm3gi6n4bqvxhebh2u2celbyp43bf375mzgetua32zujsnoy', '2024-01-24 15:52:32', 255, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('genflorist', 'ahp', '87', 'mints_gen_florist', 'paid', '5000000000', 1, 1, 'ipfs://bafybeifugoxy237lhqbnxvdewphivzqbgmvw676zgxwvcxxpdjzgeakeke/image.jpeg', 'ipfs://bafybeifugoxy237lhqbnxvdewphivzqbgmvw676zgxwvcxxpdjzgeakeke/image.jpeg', 'florist', '7000000000', 'ipfs://bafybeidtisbke4f5j42r6dv3h7d3xfhhi2vusxesgqg5vr43bgd2frjrcq', '2024-01-30 10:22:37', 127, null);
INSERT INTO campaigns(id, chain, collection, table_ref, type, price, active, disabled, image, banner, alias, meta, content, created_at, minted, holder_of) VALUES ('gensailwings', 'ahp', '91', 'mints_gen_sailwings', 'paid', '5000000000', 1, 1, 'ipfs://bafybeicbj7byedqawofmyfd6uea6zdrywgsisqyva7rdwjuvek46ajdovm', 'ipfs://bafybeicbj7byedqawofmyfd6uea6zdrywgsisqyva7rdwjuvek46ajdovm', 'sailwings', '7000000000', 'ipfs://bafybeifyqauwmxvymiqktvaxs47tcl5kikdzd45adagsrnrxlajaq6xefm', '2024-02-05 19:05:04', 256, null);