Cabal GM Tool EP8 (edited from TDChien

[sasuke]

can anyone create that procedure?

[nikdra]

1)Why should someone do something for you?
2)You don't have hands?
3)If you don't want to learn, you better leave the game dev .
4) don't like lazy people.

[sasuke]

1)Why should someone do something for you?
2)You don't have hands?
3)If you don't want to learn, you better leave the game dev .
4) don't like lazy people.

first of all nobody asked you anything second thing until recently you were crying over my discord and now come here and be a know-it-all if you have to give these answers you better leave Ragezone

[nikdra]

Wow, you sound like a real man.

[playboy99]

for me too

Here cabal_sp_get_charpet

ALTER PROCEDURE [dbo].[cabal_sp_get_charpet]
(@PetSerial INT, @PetId INT, @CharId INT, @KINdIdx INT)
ASBEGIN SELECT * FROM cabal_pet_table where OwnerCharIdx = @CharIdEND

[sasuke]

Here cabal_sp_get_charpet

ALTER PROCEDURE [dbo].[cabal_sp_get_charpet]
(@PetSerial INT, @PetId INT, @CharId INT, @KINdIdx INT)
ASBEGIN SELECT * FROM cabal_pet_table where OwnerCharIdx = @CharIdEND

bro gives this query error

[playboy99]

bro gives this query error

You need some knowledge ab Sql. Search gg how to create store procedure and you can find out.

[amiidotcom]

bro gives this query error

Bro . Easy things .

From alter change to create.


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

[Aerox009x]

Use Server01
GO
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

Very easy for you ....T.T

[RGaming]

Here cabal_sp_get_charpet

ALTER PROCEDURE [dbo].[cabal_sp_get_charpet]
(@PetSerial INT, @PetId INT, @CharId INT, @KINdIdx INT)
ASBEGIN SELECT * FROM cabal_pet_table where OwnerCharIdx = @CharIdEND

thank you bro I've try to create it yesterday but still getting error

[doogydog]

what's error....?


Error.
column name 'Reputation' is ambiguous.

[hefajstos]

You do not need to create a new stored procedure.
Open FUC_CharacterAddItem.Designer.cs and replace the name in line 826 with
DataTable dataTable = UtilityDatabase.selectStoredPro (GlobalClass.SQLGameDB, "cabal_sp_get_charpet", arrayList); on
DataTable dataTable = UtilityDatabase.selectStoredPro (GlobalClass.SQLGameDB, "cabal_sp_get_petinfo", arrayList);
Save and compile. Or create sp =

USE [SERVER01]
GO
/****** Object: StoredProcedure [dbo].[cabal_sp_get_charpet] ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

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

GO

[TripleXXX]

some get GM skill missing ???? how fix this????. only get one gm skill and 2 gm buff only.

[Aerox009x]

anyone test the mail on this tools have error.. i create the procedure still got some error. the mail is use for giving compensation to all players..

https://ibb.co/ZxKvBV8

[playboy99]

some get GM skill missing ???? how fix this????. only get one gm skill and 2 gm buff only.

It's depends on your Cabal Version, Is there GM skill in your Cabal.enc, your files?

- - - Updated - - -

anyone test the mail on this tools have error.. i create the procedure still got some error. the mail is use for giving compensation to all players..

https://ibb.co/ZxKvBV8

Edit your procedure in your DB, remove parameter @ReceiverCharIdx

Here my procedure


ALTER 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)
ASbegin 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,
-- IsCommitted @CharacterIdx,
dbo.Mail_GetGMType(),
@Alz,
@itemKindIdx,
@itemOption,
@itemDurationIdx,
1,
-- GM : 1,
미쟁: 0 @Title,
@Content )
FETCH NEXT FROM CURSOR_ACCOUNTS INTO @CharacterIdx End CLOSE CURSOR_ACCOUNTS DEALLOCATE CURSOR_ACCOUNTSEND