Script Coins por tiempo en linea MuEMU - Scripts - TUServerMU

Autor Topic: Script Coins por tiempo en linea MuEMU  (Visto 493 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: 3916
  • Gracias recibida: 38316
- 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: 3916
  • Gracias recibida: 38316
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
10 Replies
1724 Views
Last post August 09, 2018, 10:06:38 AM
by ZabiinoOo
2 Replies
133 Views
Last post January 17, 2018, 01:48:03 AM
by narzuko
2 Replies
178 Views
Last post March 19, 2018, 10:32:31 PM
by keikurono
2 Replies
305 Views
Last post June 21, 2018, 11:16:33 PM
by FreeStyle
7 Replies
307 Views
Last post July 26, 2018, 12:17:32 AM
by tosento