Cabal GM Tool EP8 (edited from TDChien

[bigshoot]

CREATE PROCEDURE [dbo].[cabal_sp_get_charpet]
(@PetSerial INT, @PetId INT, @CharId INT, @KINdIdx INT)
AS BEGIN SELECT * FROM cabal_pet_table where OwnerCharIdx = @CharId End


this is my Code Please Like This ^_^

CREATE PROCEDURE [dbo].[cabal_sp_mail_send_all]
(@Title varchar(40), @Content varchar(512), @Alz bigint = 0, @itemKindIdx int = 0, @itemOption int = 0, @itemDurationIdx int = 0)
AS BEGIN DECLARE @CharacterIdx int DECLARE CURSOR_ACCOUNTS CURSOR FOR SELECT CharacterIdx FROM Server01.dbo.cabal_character_table
OPEN CURSOR_ACCOUNTS FETCH NEXT FROM CURSOR_ACCOUNTS INTO @CharacterIdx WHILE @@FETCH_STATUS = 0 BEGIN INSERT INTO
cabal_mail_received_table
( IsCommitted, ReceiverCharIdx, Type, Alz, ItemKindIdx, ItemOption, ItemDurationIdx, SenderCharIdx, Title, Content )
VALUES
(
1,
@CharacterIdx,
dbo.Mail_GetGMType(),
@Alz,
@itemKindIdx,
@itemOption,
@itemDurationIdx,
1,
-- GM : 1,
@Title,
@Content )
FETCH NEXT FROM CURSOR_ACCOUNTS INTO @CharacterIdx End CLOSE CURSOR_ACCOUNTS DEALLOCATE CURSOR_ACCOUNTS END

This is the Fixed on Mail sent to all ^_^ i hope you Like This

error?, how, do you need to copy and query or what?

 

[1theOne1]

it still missing the itemlist.txt skilllist.txt petlist.txt titlelist.txt
how to fix this please

 

[bigshoot]

Ple help still error

 

[rpgmmo]

Ple help still error

CharIDX

 

[bigshoot]

CharIDX

No undestand ? need WHAT

 

[xFly]

any idea how to add more warp and map. i try but dint show up.