[Aporte] ENCGames Server Files 2.0.4.0 Season6 + Client 1.07V+ (ENG-SPA-POR) FULL (New Char)

Código:


if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExtWarehouse]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExtWarehouse]
GO

CREATE TABLE [dbo].[ExtWarehouse] (
    [AccountID] [varchar] (10) COLLATE Latin1_General_CS_AS NOT NULL ,
    [Items] [varbinary] (1920) NULL ,
    [Money] [int] NULL ,
    [EndUseDate] [smalldatetime] NULL ,
    [DbVersion] [tinyint] NULL ,
    [pw] [smallint] NULL ,
    [VaultID] [int] NOT NULL
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ExtWarehouse] ADD
    CONSTRAINT [DF_ExtWarehouse_Money] DEFAULT (0) FOR [Money],
    CONSTRAINT [DF_ExtWarehouse_DbVersion] DEFAULT (0) FOR [DbVersion],
    CONSTRAINT [DF_ExtWarehouse_pw] DEFAULT (0) FOR [pw],
    CONSTRAINT [DF_ExtWarehouse_NUMBER] DEFAULT (1) FOR [VaultID]
GO

ALTER TABLE [dbo].[warehouse] ADD
    [VaultID] [int] NOT NULL DEFAULT (1)
GO

CREATE PROCEDURE [dbo].[ENC_ChangeVault]
@login varchar(10),
@futureVaultID int
AS
Begin
SET NOCOUNT ON
DECLARE
@actualVaultID int,
@actualVaultItem varbinary(1920),
@futureVaultItem varbinary(1920),
@actualMoney int,
@futureMoney int

IF NOT EXISTS ( SELECT * FROM warehouse WHERE AccountID = @login )
    Begin
    INSERT INTO warehouse (AccountID, Money, EndUseDate, DbVersion, VaultID) VALUES (@login,0, getdate(), 3, 1)
    End

IF (@futureVaultID <= 0)
    Begin
    SELECT @futureVaultID = 1
    End

SELECT @actualVaultID = VaultID FROM warehouse WHERE AccountID = @login

IF (@actualVaultID <> @futureVaultID)
    Begin
    IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @futureVaultID AND AccountID = @login )
        Begin
        SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login
        SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login
        SELECT @futureVaultItem = Items FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID
        SELECT @futureMoney = Money FROM ExtWarehouse WHERE AccountID = @login and VaultID=@futureVaultID
        UPDATE warehouse SET Items = @futureVaultItem, Money = @futureMoney, VaultID = @futureVaultID WHERE AccountID = @login

        IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login )
            Begin
            UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID
            End

        ELSE
            Begin
            INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID)
            End
        End

    ELSE
        Begin
        SELECT @actualVaultItem = Items FROM warehouse WHERE AccountID = @login
        SELECT @actualMoney = Money FROM warehouse WHERE AccountID = @login
        UPDATE warehouse SET Items = NULL, Money = 0, VaultID = @futureVaultID WHERE AccountID = @login

        IF EXISTS ( SELECT * FROM ExtWarehouse WHERE VaultID = @actualVaultID AND AccountID = @login )
            Begin
            UPDATE ExtWarehouse SET Items = @actualVaultItem, Money = @actualMoney WHERE AccountID = @login AND VaultID = @actualVaultID
            End

        ELSE
            Begin
            INSERT INTO ExtWarehouse (AccountID, Items, Money, EndUseDate, DbVersion, VaultID) VALUES (@login, @actualVaultItem, @actualMoney, getdate(), 3, @actualVaultID)
            End
        End
    End
End

GO

IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'NewCharactersFixs' AND type = 'TR')
DROP TRIGGER NewCharactersFixs
GO

CREATE TRIGGER [NewCharactersFixs] ON [dbo].[Character]
FOR INSERT
AS
BEGIN
    IF ( SELECT Class FROM INSERTED ) = 96
    BEGIN
        UPDATE Character SET MagicList=Null, Quest=Null, Inventory=0x00001200000000000010000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF14081E000000000000D000000000000014101E000000000000D0000000000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
        WHERE Class='96'
    END
END


Código:


2.0.4.0
ENC_SocketItems.txt File - Added
Begin of Season 6 works
Season 6 Maps - Added
Rage Fighter Character - Added
DataServer For New Character - Fixed
Rage Fighter Create - Fixed
Rage Fighter Login - Fixed
Rage Fighter Item.txt Column - Added
Rage Fighter Item Equip - Fixed
Rage Fighter Level Up Points - Fixed
Rage Fighter Capes - Fixed
Rage Fighter HP and Mana - Fixed
Rage Fighter Skill.txt Column - Added
Rage Fighter Skills - 100%
CalCharacter System - Improved
Imperial Event - Added
Processor Usage Decreased
Memory Usage Decreased
Items Limit Up To 511/group - Client
Siege Skill In All Maps - Added
Multi Vault System - Improved
2.0.3.0
AntiHack System Integrated in GS!!
Medusa Event - 100%
Full GS Hack Protection - Added
IPBlock System - Improved
GM System - Improved
/clearinv Command - Added
[Siege] Friendly Damage - Removed
Item Move Limit System - Improved
2.0.2.0
New ConnectServer
Anti-Crash System - Added
Golden Dragon Drop - Fixed (Old System)
Run On Windows Server 2003 SP2 (R2) - Fixed
SQL Overload - Fixed
/vault Command Delay - Added
Duel Spectator Kill - Fixed
/reload 4 - Added (Drop System)
2.0.1.0
Harmony on  15 Items - Fixed
[Duel] Fake Winner Report - Fixed
[Duel] Delete Spectator by Bar Button - Added
Kundun Boxes Luck Drop - Refixed
Hit Some NPCs - Fixed
Angel Pet Life Decrease - Fixed
Add Points Without Relogin - Added (with specific main.exe only)
Some Overflows - Fixed
Reload Mobs Crash - Fixed
Some Crashs - Fixed
Drop System - Rebuilded
2.0.0.0
Season 5 Quests - 100%
Add points over limit by command - Fixed
Drop System - Fixed
Duel System Fully Fixed - 100%
Marlon Quest Delete After Reset - Fixed
3rd Wings Rates Config - Added
BK Swell Life Die - Fixed
Raul NPC - 100%
Minor Fixes
1.9.9.0
 15 Items Mix Freeze - Fixed
 15 Items Mix Log - Added
 15 Items Mix Options Dissapear - Fixed
Christine NPC (Shop19.txt) - 100%
Jewel Disappear After Trade - Fixed
1.9.8.0
New source code!! (Totally reformulated)
Summoner Skill Tree - 100% (1.07V or higher)
Special Effect to /reset Command - Added
CalCharacter System - Added
GameMasters Log - Added
/infovip and /reset Support to 5 Vip Plans - Added
Removed Some Useless Logs
Decrease CPU Usage
Online Announce System - 100%
Dataservers overload - Fixed (thanks to Willerson)
VIP Gate System - Added
1.9.7.0
Online Announce System - Added
 13,  14 and  15 Items Effect - Fixed
Mini Wings Visual Bug - Fixed
1.9.6.0
Item Move Limit System - Added
/infovip Command - Readded
Daily Resets - Added
Resets Columns Control - Added
All Skills On New Protocol - 100%
1.9.5.0
Magic Skill On New Protocol - Fixed
/status Command Crash - Fixed
/ban Command Crash - Fixed
/moveall Command - Added
1.9.4.0
 15 Items Durability - Fixed
 15 Items Strength - Fixed
Panda and Skeleton Pet Durability Decrease - Fixed
1.9.3.0
Fixed some crashes
PK Party God Mode - Fixed
Golden Troops (korean protocol) - 99%
Negative Status - Fixed
Some Fixes in DataServers
Commands Syntax Config - Added
Some Fixes in EventServer
 15 Mix Socket Options Disappear - Fixed
Support Clients 1.07P  or higher - Added
1.9.2.0
ExDB Connect Issue - Fixed
ConnectServer Hack Attack - Fixed
Custom Drop System - Added
Reset in same location - Fixed
Party Exp Config - Added
1.9.1.0
Panda Pet visual bug in 'select char' - Fixed
Skeleton Pet visual bug in 'select char' - Fixed
[GSCS]Panda Pet visual bug - Fixed
[GSCS]Skeleton Pet visual bug - Fixed
[GSCS]Add points over limit - Fixed
1.9.0.0
NPC Julia Zen bug - Fixed
Lvl 40 Warrior Ring - Fixed
Chaos Card NPC and Mix - Fixed
Wings  15 Mix - Fixed
1.8.9.0
Panda Pet visual bug (in game) - Fixed
Skeleton Pet visual bug (in game) - Fixed
NPC Julia (ID 547) - Added
1.8.8.0
Panda Ring after to cancel trade - Fixed
Gladiator Glory Buff after to cancel trade - Fixed
Loren Market Map (Map 79) - Added
Skeleton Transformation Ring - 100%
Items  15 suport - 100%
Items  15 Chaos Mix - 100%
1.8.7.0
[Duel System] Loser Move - Fixed
[Duel System] Gladiator Glory Buff - Fixed
'T key' freeze - Fixed
GM Can't kill mobs and players - Fixed
[Double Goer] Boss and Players move in bar - Fixed
1.8.6.0
Excellent Shops support - 100%
VIP Auto-Decrase System (jobs no more)
VIP Server System - 100%
Added /skin
Panda Transformation Ring - 100%
1.8.5.0
Double Goer Event - 100% (Original)
1.8.4.0
Small Fixes
1.8.3.0
1.07 Client support - 100%
Added Exc Socket option - 100%
Added /infovip
Added /vault
1.8.2.0
Added /reset
Added /ban
1.7.9.0
News System - 100%
ManaShield bug fixed
Greater Fortitude fixed
1.7.8.0
IPBlock System - 100%
DuelSystem - 100%
65k support - 100%
1.7.7.0
Season 5 Maps - 100%
Season 5 Client support - 100%
Summoner - 100%
ExDB Anti-inject - 100%
Auto-DC JoinServer - 100%
Added /zen
GMSystem - 100%
MasterSkillTree - 100%
Raklion Event - 100% (Original)
Socket Items System - 100% (Original)
All originals events - 100%
Added /post
Added /str,/agi,/vit,/ene and /cmd
Added /drop
Added /pkset
Added /setzen
Added /pkclear
Added /gg
Added /status
Season 3 Episode 1 and 2 - 100%
Season 2 - 100%
Season 1 - 100%


larryxD escribió:Que asco con ustedes

Sistemas operativos soportados:
Windows XP, Windows Server 2003, Windows Server 2008, Windows Vista & Windows 7

Sistemas NO Soportados:
- Windows 7
- Windows 2008 Server

Revolution escribió:Si funcionan.

Revolution escribió:estos files son una mierda, son s5 con pj nuevo y hasta hay nomas eh

Servidor: Mensaje 2705, Nivel 16, Estado 4, Línea 2
Los nombres de columna de cada tabla debe ser único. 'VaultID' El nombre de columna en 'dbo.warehouse' tabla se especifica más de una vez.
Servidor: Mensaje 2714, Nivel 16, Estado 5, ENC_ChangeVault Procedimiento, la línea 65535
Ya hay un objeto denominado 'ENC_ChangeVault en la base de datos.

WassingtoN escribió:Alto Copy past AJAJa Ni sirven LLeno De virus!! la cosa esa!!