Autor Topic: Script Coins por tiempo en linea MuEMU  (Visto 659 veces)

0 Miembros and 1 Guest are viewing this topic.

Offline ZabiinoOo on: December 17, 2017, 04:15:46 PM

  • Administrador
  • *
  • Rank: Puto amo
  • Posts: 4366
  • Gracias recibida: 45877
- Crear una columna en la tabla MEMB_STAT

Code: [Select]
tiempo int default 0

- Ahora crear un JOB con el siguiente contenido cada 1 minuto:

Code: [Select]
UPDATE memb_stat SET tiempo = tiempo + 1 WHERE connectstat = 1

UPDATE CashShopData
SET wcoinp = wcoinp + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
WHERE Tiempo >= 60

UPDATE memb_stat set tiempo = 0 WHERE tiempo >= 60

- Ahora el mismo JOB por nivel de VIP

Code: [Select]
UPDATE memb_stat SET tiempo = tiempo + 1 WHERE connectstat = 1

UPDATE CashShopData
SET wcoinp = wcoinp + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tiempo >= 60 AND MEMB_INFO.AccountLevel = 0 -- FREE

UPDATE CashShopData
SET wcoinp = wcoinp + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tiempo >= 60 AND MEMB_INFO.AccountLevel = 1 -- VIP 1

UPDATE CashShopData
SET wcoinp = wcoinp + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tiempo >= 60 AND MEMB_INFO.AccountLevel = 2 -- VIP 2

UPDATE CashShopData
SET wcoinp = wcoinp + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tiempo >= 60 AND MEMB_INFO.AccountLevel = 3 -- VIP 3

UPDATE memb_stat set tiempo = 0 WHERE tiempo >= 60

VIDEOGUIA COMO CREAR JOB SQL SERVER 2008




Prohibido pedir soporte via MP
Leer las reglas de cada seccion

Gracias:


Offline jonasg #1 on: January 18, 2018, 01:02:21 PM

  • *
  • Rank: Principiante
  • Posts: 12
  • Gracias recibida: 1
Msg 468, Level 16, State 9, Line 5
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Modern_Spanish_CI_AS" in the equal to operation.

Offline narzuke16 #2 on: June 20, 2018, 10:00:16 PM

  • *
  • Rank: Dedicado
  • Posts: 30
  • Gracias recibida: 1
se puede modificar para dar pcpoints? por tiempo en linea

Offline ZabiinoOo #3 on: June 20, 2018, 11:09:13 PM

  • Administrador
  • *
  • Rank: Puto amo
  • Posts: 4366
  • Gracias recibida: 45877
se puede modificar para dar pcpoints? por tiempo en linea

Si se puede pero muemu ya viene con este sistema de dar pcpoints por tiempo en linea lo podes configurar en GameServer/DATA/Common.dat

Code: [Select]
;==================================================
; Cash Shop Settings
;==================================================

CashShopGoblinPointDelay = 10 //Tiempo en minutos
CashShopGoblinPointValue_AL0 = 1 // GP por cantidad de tiempo en linea
CashShopGoblinPointValue_AL1 = 1
CashShopGoblinPointValue_AL2 = 1
CashShopGoblinPointValue_AL3 = 1



Prohibido pedir soporte via MP
Leer las reglas de cada seccion

 

Related Topics

  Subject / Started by Replies Last post
12 Replies
2329 Views
Last post October 12, 2018, 06:29:22 AM
by copixx
2 Replies
193 Views
Last post January 17, 2018, 01:48:03 AM
by narzuko
2 Replies
281 Views
Last post March 19, 2018, 10:32:31 PM
by keikurono
8 Replies
656 Views
Last post December 06, 2018, 06:56:53 PM
by spokesman
2 Replies
106 Views
Last post December 16, 2018, 07:35:27 PM
by inax123