Cabal GM Tool EP8 (edited from TDChien

[Axel182]

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

Change ALTER PROCEDURE to CREATE PROCEDURE

 

[Tryout]

Change ALTER PROCEDURE to CREATE PROCEDURE

Forgot to say that it is now working, I just fixed the format of the query as forum made it badly coded.

 

[pizdets2]

Forgot to say that it is now working, I just fixed the format of the query as forum made it badly coded.

can please share fixed files

 

[zx14]

I get this error when selecting another character.

 

[rpgmmo]

i am use vs studio code and downloaded and installed .netframework 6 already but when i debug it show this error

please tell which visual studio version I need to compile..

 

[sasuke]

can someone post the correct procedure cabal_sp_mail_send_all

 

[Anndralgon]

can someone post the correct procedure cabal_sp_mail_send_all

You'd have to be a little more specific.

Any criteria for the mails?
Or just trying to send it to literally everyone?

 

[sasuke]

You'd have to be a little more specific.

Any criteria for the mails?
Or just trying to send it to literally everyone?

everyone

 

[Anndralgon]

Quite the mess, but I guess it does the job.
Sorry, don't have time for cleaning up, might want to filter out banned accounts.

DECLARE @lastchar int, @mailnum int, @mailcount int, @nextchar int
SELECT @lastchar = (SELECT Top 1 CharacterIdx FROM cabal_character_table Order By CharacterIdx ASC)
 
SELECT @mailnum = (SELECT COUNT(*) FROM Server01.dbo.cabal_character_table WHERE CharacterIdx > 0)

SET @mailcount = @mailnum
WHILE @mailcount > '1'
BEGIN
SELECT @nextchar = (SELECT Top 1 CharacterIdx FROM Server01.dbo.cabal_character_table WHERE CharacterIdx > @lastchar)
SET @lastchar = @nextchar

        INSERT INTO Server01.dbo.cabal_mail_received_table ( IsCommitted, ReceiverCharIdx, Type, Alz, ItemKindIdx, ItemOption, ItemDurationIdx, SenderCharIdx, SenderName, Title, Content )
        VALUES
        ( 1, @nextchar, '1', 'Alz Amount', 'Item ID', 'Item Option', 'Item Duration', 'Sender CharIdx', 'Sender Name', 'Mail Title', 'Mail Content (Text)' )

SET @mailcount = @mailcount -1
END

 

[sasuke]

Quite the mess, but I guess it does the job.
Sorry, don't have time for cleaning up, might want to filter out banned accounts.

DECLARE @lastchar int, @mailnum int, @mailcount int, @nextchar int
SELECT @lastchar = (SELECT Top 1 CharacterIdx FROM cabal_character_table Order By CharacterIdx ASC)
 
SELECT @mailnum = (SELECT COUNT(*) FROM Server01.dbo.cabal_character_table WHERE CharacterIdx > 0)

SET @mailcount = @mailnum
WHILE @mailcount > '1'
BEGIN
SELECT @nextchar = (SELECT Top 1 CharacterIdx FROM Server01.dbo.cabal_character_table WHERE CharacterIdx > @lastchar)
SET @lastchar = @nextchar

        INSERT INTO Server01.dbo.cabal_mail_received_table ( IsCommitted, ReceiverCharIdx, Type, Alz, ItemKindIdx, ItemOption, ItemDurationIdx, SenderCharIdx, SenderName, Title, Content )
        VALUES
        ( 1, @nextchar, '1', 'Alz Amount', 'Item ID', 'Item Option', 'Item Duration', 'Sender CharIdx', 'Sender Name', 'Mail Title', 'Mail Content (Text)' )

SET @mailcount = @mailcount -1
END

This is for all users and instead for a single user?

 

[Anndralgon]

This is for all users and instead for a single user?

It counts the characters and sends it to every character accordingly
It will send it to literally all of the characters though, even ones that share the same account

 

[sasuke]

It counts the characters and sends it to every character accordingly
It will send it to literally all of the characters though, even ones that share the same account

I tried to send to a single user and it gives an error but it works for all users

 

[Anndralgon]

I tried to send to a single user and it gives an error but it works for all users

Well it isn't made to be used to send a mail to a single person
For that you can just use the procedure cabal_sp_mail_send_GM which is found in Server01 by default

 

[sasuke]

Well it isn't made to be used to send a mail to a single person
For that you can just use the procedure cabal_sp_mail_send_GM which is found in Server01 by default

ok thanks

 

[mmorpg1]

posible to change class the new class here?

 

[rpgmmo]

posible to change class the new class here?

Make a button, create a query to it and analyze how change class works.

 

[uraurama]

Help why not showing Add Items "FIXED DONE

 

[TripleXXX]

Help why not showing Add Items "FIXED DONE View attachment 243202

how fix, pls share?

 

[sasuke]

does anyone know how to add more classes in the GM Tolls?

 

[pizzagaming0812]

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