Nero All In One Editor v1.07 (Başlangıç,Karakter,Harita,Drop,Clan vs) {Prosedürsüz} İndir - Download

v1.298, v1.310+, v1453, v1500+, v1800+ (SQL2000) DESTEKLİ.

Güncellendi (5 Mart 2013)

Güncel sürüm çıktığında otomatik uyarı verir, eğer indirmek istemiyorsanız hayır diyip programdaki yapmak istediğiniz işlemi seçebilirsiniz.

Editörler prosedürsüz çalışıyor aşağıdaki kodlar başlangıç itemlerini vermek icin lazım, create_new_char prosedürüne EXEC GIVE_S_ITEM @CharID eklemeniz yeterli.

DOWNLOAD

SQL KOD..

IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[dbo].[S_ITEM]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
DROP TABLE [dbo].[S_ITEM]
GO

IF EXISTS (SELECT * FROM [dbo].[sysobjects] WHERE id = object_id(N'[dbo].[GIVE_S_ITEM]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE [dbo].[GIVE_S_ITEM]
GO

CREATE TABLE [S_ITEM] (
	[iClass] [smallint] NOT NULL ,
	[strClass] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[Gold] [bigint] NOT NULL CONSTRAINT [DF_baslangic_Gold] DEFAULT (0),
	[strItem] [varchar] (1200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
) ON [PRIMARY]
GO

INSERT INTO [S_ITEM] VALUES ( 1, 'Warrior', 0, ':ø~' );
INSERT INTO [S_ITEM] VALUES ( 2, 'Rogue', 0, ':ø~' );
INSERT INTO [S_ITEM] VALUES ( 3, 'Magician', 0, ':ø~' );
INSERT INTO [S_ITEM] VALUES ( 4, 'Priest', 0, ':ø~' );

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE PROCEDURE [dbo].[GIVE_S_ITEM]
@strUserId varchar(21)
AS
BEGIN

DECLARE      [MENTION=2874]class[/MENTION] smallint

SELECT      [MENTION=2874]class[/MENTION] = Cast(SubString(Cast(Class as varchar(3)), 2, 2) as smallint(2)) FROM USERDATA WHERE strUserId = @strUserId

IF      [MENTION=2874]class[/MENTION] = 1 OR      [MENTION=2874]class[/MENTION] = 5 OR      [MENTION=2874]class[/MENTION] = 6
SET      [MENTION=2874]class[/MENTION] = 1

IF      [MENTION=2874]class[/MENTION] = 2 OR      [MENTION=2874]class[/MENTION] = 7 OR      [MENTION=2874]class[/MENTION] = 8
SET      [MENTION=2874]class[/MENTION] = 2

IF      [MENTION=2874]class[/MENTION] = 3 OR      [MENTION=2874]class[/MENTION] = 9 OR      [MENTION=2874]class[/MENTION] = 10
SET      [MENTION=2874]class[/MENTION] = 3

IF      [MENTION=2874]class[/MENTION] =4 OR      [MENTION=2874]class[/MENTION] = 11 OR      [MENTION=2874]class[/MENTION] = 12
SET      [MENTION=2874]class[/MENTION] = 4

UPDATE USERDATA SET strItem = (SELECT strItem FROM S_ITEM WHERE iClass =      [MENTION=2874]class[/MENTION]), Gold = (SELECT Gold FROM S_ITEM WHERE iClass =      [MENTION=2874]class[/MENTION]) WHERE strUserId = @strUserId

END

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO