S2B Core

Glosario

-- Directo: Quien refiere a un usuario -- Red: Directo de Directo de Directo hasta 24 Niveles(comisiones) y Más -- Comision Directa: Cuando uno de mis referidos compra 12,5% (se paga unicamente con la primera compra). -- Comision Red(Indirectas): Cuando un referido(broker) compra por primera vez 12,5%/24 (se divide en 24 niveles) -- Comision Propia: Cuando el mismo usuario compra una segunda vez 12,5%.

Tabla Acciones

• ID
• WID = Wordpress ID User that receive the bees
• WDID = Wordpress ID User that purchase the bees or has been registered
• amount = total of bees
• gainFrom = where this bees came from? 0 = register | 1 = buy to become broker | 2 = own purchase | 3 = Founder
• orderID = if bees came from a buy
• created = the day this bees as been born the beesbang xD

Tabla BEES

• ID

Tabla Volumens

• ID

Shortcodes

SQL pendientes

ALTER TABLE jrki_uap_s2b_projects ADD propertyYieldBroker FLOAT NULL DEFAULT '0' AFTER concessionYield, ADD concessionYieldBroker FLOAT NULL DEFAULT '0' AFTER propertyYieldBroker;

ALTER TABLE jrki_uap_s2b_projects ADD propertyTagBroker VARCHAR(255) NULL AFTER concessionTag, ADD concessionTagBroker VARCHAR(255) NULL AFTER propertyTagBroker;

UPDATE jrki_s2b_profit_history SET state = '0' WHERE created > '2024-11-01 00:00:00' AND created < '2024-12-01 00:00:00';

SQL de ayuda

// set back profit UPDATE jrki_s2b_profit_history SET state = '0' // set back volume UPDATE jrki_uap_s2b_volume_rel SET state = 0 WHERE created >= '2024-10-01 00:00:00'; // delete history DELETE FROM jrki_uap_s2b_wallets_archives WHERE created >= '2024-11-04 00:00:00' // set all reports to write mode UPDATE jrki_s2b_reports SET state = 1 WHERE state = 2

Parametros extras para actualizar el cron de reportes, a usar en casos de emergencia