Hola chicos, hace uno días descargue está página web para el servidor mu que lanzaré, debido a que es bien personalizada y profesional, sin embargo faltan algunas base de datos (tablas) y también código fuente.
Compartiré mi avance:
Tablas faltantes para el plugin: LootBoxes
Tabla: mw_lootboxes
Código:
USE [MuOnline]GO
/****** Object: Table [dbo].[mw_packages] Script Date: 11/17/2020 3:15:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mw_lootboxes](
[id] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](200) NOT NULL,
[description] [text] NULL,
[image] [varchar](150) NULL,
[expire_date] [date] NULL,
[coins] [varchar] (20) NOT NULL,
[coin] [varchar] (20) NOT NULL,
[amount] [int] NOT NULL,
[active] [int] NOT NULL,
[gift_register] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[mw_lootboxes] ADD DEFAULT ((0)) FOR [active]
GO
Table: mw_lootboxes_account
Código:
/****** Object: Table [dbo].[mw_packages] Script Date: 11/17/2020 3:15:00 AM ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mw_lootboxes_account](
[id] [int] IDENTITY(1,1) NOT NULL,
[lootbox_id] [int] NOT NULL,
[account] [varchar] (10) NOT NULL,
[gift_from] [varchar] (10) NULL,
[open_date] [date] NULL,
[item] [varchar] (64) NULL,
[create_date] [date] NOT NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[mw_lootboxes_account] ADD DEFAULT (getdate()) FOR [create_date]
GO
Table: mw_lootboxes_items
Código:
/****** Object: Table [dbo].[mw_packages] Script Date: 11/17/2020 3:15:00 AM ******/SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mw_lootboxes_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[section] [int] NOT NULL,
[idx] [int] NOT NULL,
[item_percent] [int] NOT NULL,
[percent_levels] [text] NOT NULL,
[percent_options] [text] NOT NULL,
[percent_luck] [int] NOT NULL,
[percent_skill] [int] NOT NULL,
[percent_ancient] [int] NOT NULL,
[percent_exc] [text] NOT NULL,
[percent_refine] [int] NOT NULL,
[percent_harmony] [int] NOT NULL,
[percent_sockets] [text] NULL,
[lootbox_id] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[mw_lootboxes_items] ADD DEFAULT ((0)) FOR [percent_luck]
GO
ALTER TABLE [dbo].[mw_lootboxes_items] ADD DEFAULT ((0)) FOR [percent_skill]
GO
ALTER TABLE [dbo].[mw_lootboxes_items] ADD DEFAULT ((0)) FOR [percent_ancient]
GO
ALTER TABLE [dbo].[mw_lootboxes_items] ADD DEFAULT ((0)) FOR [percent_refine]
GO
ALTER TABLE [dbo].[mw_lootboxes_items] ADD DEFAULT ((0)) FOR [percent_harmony]
GO
Table: mw_slides
Código:
USE [MuOnline]GO
/****** Object: Table [dbo].[mw_packages] Script Date: 11/17/2020 3:15:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[mw_slides](
[id] [int] IDENTITY(1,1) NOT NULL,
[image] [varchar](200) NOT NULL,
[title] [varchar](300) NULL,
[url] [varchar](300) NULL,
[active] [int] NOT NULL,
[sequence] [int] NULL,
PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[mw_slides] ADD DEFAULT ((0)) FOR [active]
GO
Ejecuten esos "Sql Querys" y listo.
FALTANTE 1: Los archivos faltantes del plugin lootboxes de la página web los extraje de la versión: Morpheus 5.5 Codificada, pero aún me faltan dos archivos para el admin, sin embargo no son necesarios ya que pueden editarlo desde el SQL Server. Lo que falta aquí es revisar el código de la web y emparejarlo con la versión 3.3, ya lo acabaré pronto.
FALTANTE 2: Aquí hice el mismo procedimiento anterior
, lo que falta aún es el código para el inicio del template, ya lo acabaré.
Saludos desde Perú
1 Dia 13 Horas:
------- Atualizado -------
Aquí van los avances hasta ahora, ya casí la acabo, funciona bien sin errores.
1) Lootboxes (Ruleta Rusa)
2) Ranking
3) Lá pagina de regreso de Paypal, esto es porque no tengo el plugin "notification".
4) Slides
Le agregaré un chat con algún código fuente que encontraré por allí y botones para redes sociales.