Premium and honnor rank max

how to give all palyer max honnor class rank and Premium .....

thnks

here modified your cabal_sp_newchar

Spoiler:

Code:

---

USE [Server01]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_newchar]    Script Date: 02/15/2013 00:39:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
        @Name VARCHAR(16),
        @CharacterIdx  INT,
        @Style INT,
        @StyleMastery INT
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @CR_SUCCESS INT
DECLARE @CR_DATABRK INT               
DECLARE @CR_NAMEDUP INT       
DECLARE @CR_BADWORD INT

SET @CR_SUCCESS = 0xA0
SET @CR_DATABRK = 0x02       
SET @CR_NAMEDUP = 0x03
SET @CR_BADWORD = 0x04

IF NOT @StyleMastery BETWEEN 1 AND 6
BEGIN
        SELECT @CR_DATABRK
        RETURN
END

IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = @Name )
BEGIN
        SELECT @CR_BADWORD
        RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = @Name)
BEGIN
        SELECT @CR_NAMEDUP
        RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = @CharacterIdx)
BEGIN
        SELECT @CR_DATABRK
        RETURN
END
       

SET XACT_ABORT ON
BEGIN TRAN

INSERT INTO cabal_character_table
(
        CharacterIdx, Name,
        LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
        WorldIdx, [Position], Style,
        HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField,
        Reputation
)
SELECT
        @CharacterIdx, @Name,
        LEV, [EXP], [STR], [DEX], [INT], 312, Rank, Alz,
        WorldIdx, Position, @Style + 144,
        HP, MP, 1966110000, SwdPNT, MagPNT, RankEXP, Flags, 2047, 2047,
        10000000
FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

IF @@ROWCOUNT <> 1
BEGIN
        ROLLBACK TRAN
        SELECT @CR_DATABRK
        RETURN
END

INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT @CharacterIdx, InventoryData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT @CharacterIdx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT @CharacterIdx, SkillData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT @CharacterIdx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT @CharacterIdx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

EXEC cabal_sp_linked_update_character_count @CharacterIdx, 1
               
SELECT @CR_SUCCESS + @StyleMastery

COMMIT TRAN
SET XACT_ABORT OFF
       
SET NOCOUNT OFF
END

---

delete old and paste this in cabal_sp_newchar or what ????

thnks

Quote:

---

Originally Posted by bsitmark

here modified your cabal_sp_newchar

Spoiler:

Code:

---

USE [Server01]
GO
/****** Object:  StoredProcedure [dbo].[cabal_sp_newchar]    Script Date: 02/15/2013 00:39:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[cabal_sp_newchar]
(
        @Name VARCHAR(16),
        @CharacterIdx  INT,
        @Style INT,
        @StyleMastery INT
)
AS
BEGIN
SET NOCOUNT ON

DECLARE @CR_SUCCESS INT
DECLARE @CR_DATABRK INT               
DECLARE @CR_NAMEDUP INT       
DECLARE @CR_BADWORD INT

SET @CR_SUCCESS = 0xA0
SET @CR_DATABRK = 0x02       
SET @CR_NAMEDUP = 0x03
SET @CR_BADWORD = 0x04

IF NOT @StyleMastery BETWEEN 1 AND 6
BEGIN
        SELECT @CR_DATABRK
        RETURN
END

IF EXISTS (SELECT * FROM cabal_badwoard WHERE badword = @Name )
BEGIN
        SELECT @CR_BADWORD
        RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE Name = @Name)
BEGIN
        SELECT @CR_NAMEDUP
        RETURN
END

IF EXISTS (SELECT * FROM cabal_character_table WHERE CharacterIdx = @CharacterIdx)
BEGIN
        SELECT @CR_DATABRK
        RETURN
END
       

SET XACT_ABORT ON
BEGIN TRAN

INSERT INTO cabal_character_table
(
        CharacterIdx, Name,
        LEV, [EXP], [STR], DEX, [INT], PNT, Rank, Alz,
        WorldIdx, [Position], Style,
        HP, MP, SP, SwdPNT, MagPNT, RankEXP, Flags, WarpBField, MapsBField,
        Reputation
)
SELECT
        @CharacterIdx, @Name,
        LEV, [EXP], [STR], [DEX], [INT], 312, Rank, Alz,
        WorldIdx, Position, @Style + 144,
        HP, MP, 1966110000, SwdPNT, MagPNT, RankEXP, Flags, 2047, 2047,
        10000000
FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

IF @@ROWCOUNT <> 1
BEGIN
        ROLLBACK TRAN
        SELECT @CR_DATABRK
        RETURN
END

INSERT INTO cabal_inventory_table (CharacterIdx, Data)
SELECT @CharacterIdx, InventoryData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_equipment_table (CharacterIdx, Data)
SELECT @CharacterIdx, EquipmentData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_skilllist_table (CharacterIdx, Data)
SELECT @CharacterIdx, SkillData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_quickslot_table (CharacterIdx, Data)
SELECT @CharacterIdx, QuickSlotData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

INSERT INTO cabal_questdata_table (characterIdx, Data, Flags)
SELECT @CharacterIdx, QuestData, QuestFlagsData FROM cabal_new_character_data
WHERE ClassType = @StyleMastery

EXEC cabal_sp_linked_update_character_count @CharacterIdx, 1
               
SELECT @CR_SUCCESS + @StyleMastery

COMMIT TRAN
SET XACT_ABORT OFF
       
SET NOCOUNT OFF
END

---

---

I thought this was just for auto premium and used it on my DB... How can I put it back to normal? -_-

just observe this modified cabal_sp_newchar so you could understand it.

I barely have any experience with server files since I'm a beginner, some of the stuff in there looks like I would know what it is but others there's not a chance lol...