Cabal GM Tool EP8 (edited from TDChien

[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..

You must be registered to see links

 

[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?

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..

You must be registered to see links

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

 

[sasuke]

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




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

can you post your Server01?

 

[playboy99]

can you post your Server01?

here dboServer01 from GG Drive
drive.google.com/file/d/18a87pvaqsncR8VfWKik6EUx__r2rA44b

 

[Aerox009x]

and it work hehehe thankssss!!!!

 

[TripleXXX]

here dboServer01 from GG Drive
drive.google.com/file/d/18a87pvaqsncR8VfWKik6EUx__r2rA44b

Pls reupload, Link already dead

 

[honeycell]

anyone here have item option .txt list for all items for GM tools
like 620033332 that give SSA 70% for gear

 

[Tryout]

I have this error sending a mail to all.

Tried to use the sp above for mail send all but this error shows.

 

[Axel182]

I have this error sending a mail to all.

View attachment 197464

Tried to use the sp above for mail send all but this error shows.

View attachment 197465

Read thread before asking or use search button Man. It's already described here.

 

[Tryout]

Read thread before asking or use search button Man. It's already described here.

I don't ask if I didn't tried it

 

[Axel182]

I don't ask if I didn't tried it

U have it just a bit higher in thread. Make sure to create that procedure in Server01 database. Go to Server01 -> Programabillity -> Stored Procedures -> Look for procedure name. If its not in here you need to copy paste procedure from that thread and just execute it. If you dont understand PM ME.

anyone here have item option .txt list for all items for GM tools
like 620033332 that give SSA 70% for gear

It doesnt work like that. Item ID and Option ID is made from binnary code converted to HEX code coverted to DEC code. Nobody have list of every item option combination cause its not needed while u can use program or if you are skilled enough you can count it even yourself without any program.

 

[Tryout]

U have it just a bit higher in thread. Make sure to create that procedure in Server01 database. Go to Server01 -> Programabillity -> Stored Procedures -> Look for procedure name. If its not in here you need to copy paste procedure from that thread and just execute it. If you dont understand PM ME.

I don't have that kind of SP, when I try to exec the SP here it doesn't let me exec.