Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Send mail to all registered players

Status
Not open for further replies.
F

FlyFFerz

Newbie Spellweaver
Joined
Mar 13, 2022
Messages
48
Reaction score
3
Hello,

How can I send an item to all player via mail?

This one don't work at all.
Code: 
[COLOR=#000000]SE [/COLOR][COLOR=#666600][[/COLOR][COLOR=#000000]character[/COLOR][COLOR=#666600]][/COLOR]GO
[COLOR=#880000]/****** Object:  StoredProcedure [dbo].[SP_POST_EVENTITEM_BULK]    Script Date: 12/17/2012 12:04:24 ******/[/COLOR]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [COLOR=#666600][[/COLOR]dbo[COLOR=#666600]].[[/COLOR]SP_POST_EVENTITEM_BULK[COLOR=#666600]][/COLOR]
    [COLOR=#006666]@i_wIndex[/COLOR]            INT[COLOR=#666600],[/COLOR]
    [COLOR=#006666]@i_sFrom[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]40[/COLOR][COLOR=#666600]),[/COLOR]
    [COLOR=#006666]@i_sSubject[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]50[/COLOR][COLOR=#666600]),[/COLOR]
    [COLOR=#006666]@i_sBody[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]500[/COLOR][COLOR=#666600]),[/COLOR]
    [COLOR=#006666]@o_sp_rtn[/COLOR]            INT                OUTPUT        
AS
    DECLARE [COLOR=#006666]@v_post_no[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]18[/COLOR][COLOR=#666600])[/COLOR]            
    DECLARE [COLOR=#006666]@v_state_tag[/COLOR]        tinyint                
    DECLARE [COLOR=#006666]@v_byHeader[/COLOR]            smallint            
    DECLARE [COLOR=#006666]@v_wIndex[/COLOR]            INT                    
    DECLARE [COLOR=#006666]@v_dwSerialNumber[/COLOR]    binary[COLOR=#666600]([/COLOR][COLOR=#006666]16[/COLOR][COLOR=#666600])[/COLOR]            
    DECLARE [COLOR=#006666]@v_expire_day[/COLOR]        [COLOR=#000088]int[/COLOR]                    
    DECLARE [COLOR=#006666]@v_character_no[/COLOR]        varchar[COLOR=#666600]([/COLOR][COLOR=#006666]20[/COLOR][COLOR=#666600])[/COLOR]            
    DECLARE [COLOR=#006666]@v_info[/COLOR]                varbinary[COLOR=#666600]([/COLOR][COLOR=#006666]25[/COLOR][COLOR=#666600])[/COLOR]        
    DECLARE [COLOR=#006666]@v_item_tag[/COLOR]            tinyint                
    DECLARE [COLOR=#006666]@v_dil_tag[/COLOR]            tinyint                
    DECLARE [COLOR=#006666]@v_include_dil[/COLOR]        BIGINT                

    DECLARE [COLOR=#006666]@v_from_char_nm[/COLOR]        VARCHAR[COLOR=#666600]([/COLOR][COLOR=#006666]40[/COLOR][COLOR=#666600])[/COLOR]            
    DECLARE [COLOR=#006666]@v_post_sort[/COLOR]        TINYINT                
    DECLARE [COLOR=#006666]@v_post_title[/COLOR]        VARCHAR[COLOR=#666600]([/COLOR][COLOR=#006666]50[/COLOR][COLOR=#666600])[/COLOR]            
    DECLARE [COLOR=#006666]@v_body_text[/COLOR]        VARCHAR[COLOR=#666600]([/COLOR][COLOR=#006666]500[/COLOR][COLOR=#666600])[/COLOR]        
    DECLARE [COLOR=#006666]@v_event_no[/COLOR]            INT                    
    
    DECLARE    [COLOR=#006666]@v_tab_nm[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]20[/COLOR][COLOR=#666600])[/COLOR]
    DECLARE [COLOR=#006666]@v_m_date[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]6[/COLOR][COLOR=#666600])[/COLOR]
    DECLARE [COLOR=#006666]@v_spid[/COLOR]                varchar[COLOR=#666600]([/COLOR][COLOR=#006666]4[/COLOR][COLOR=#666600])[/COLOR]
    DECLARE [COLOR=#006666]@v_regdate[/COLOR]            varchar[COLOR=#666600]([/COLOR][COLOR=#006666]8[/COLOR][COLOR=#666600])[/COLOR]
    DECLARE [COLOR=#006666]@v_seq_no[/COLOR]            [COLOR=#000088]int[/COLOR]
    
    [COLOR=#666600]--[/COLOR][COLOR=#880000]// SerialNumber Info[/COLOR]
    DECLARE [COLOR=#006666]@i_wLinear[/COLOR]            [COLOR=#000088]int[/COLOR]
    DECLARE [COLOR=#006666]@i_dwRandom[/COLOR]            [COLOR=#000088]int[/COLOR]
    
    DECLARE [COLOR=#006666]@v_curr_time[/COLOR]        datetime                            
    DECLARE [COLOR=#006666]@v_expire_time[/COLOR]        datetime                            
[COLOR=#000088]BEGIN[/COLOR]
    SELECT    [COLOR=#006666]@v_dil_tag[/COLOR]            [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    SELECT    [COLOR=#006666]@v_include_dil[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    SELECT    [COLOR=#006666]@v_curr_time[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#660066]GetDate[/COLOR][COLOR=#666600]()[/COLOR]                            
    SELECT    [COLOR=#006666]@v_expire_day[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]30[/COLOR]                                
    SELECT    [COLOR=#006666]@v_expire_time[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]@v_curr_time[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_expire_day[/COLOR]        
    SELECT    [COLOR=#006666]@v_state_tag[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]                                    
    SELECT    [COLOR=#006666]@v_byHeader[/COLOR]            [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    SELECT    [COLOR=#006666]@v_info[/COLOR]                [COLOR=#666600]=[/COLOR] [COLOR=#006666]0x[/COLOR]
    SELECT    [COLOR=#006666]@v_item_tag[/COLOR]            [COLOR=#666600]=[/COLOR] [COLOR=#006666]1[/COLOR]

    SELECT    [COLOR=#006666]@v_from_char_nm[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]@i_sFrom[/COLOR]
    SELECT    [COLOR=#006666]@v_post_title[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]@i_sSubject[/COLOR]
    SELECT    [COLOR=#006666]@v_body_text[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]@i_sBody[/COLOR]
    SELECT    [COLOR=#006666]@v_post_sort[/COLOR]        [COLOR=#666600]=[/COLOR] [COLOR=#006666]7[/COLOR]

    SELECT    [COLOR=#006666]@o_sp_rtn[/COLOR]            [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    SELECT    [COLOR=#006666]@v_dwSerialNumber[/COLOR]    [COLOR=#666600]=[/COLOR] [COLOR=#006666]0x00000000000000000000000000000000[/COLOR]
    SELECT    [COLOR=#006666]@v_spid[/COLOR]             [COLOR=#666600]=[/COLOR] CAST[COLOR=#666600]([/COLOR]dbo[COLOR=#666600].[/COLOR]FN_GetAutoNo[COLOR=#666600](@[/COLOR][COLOR=#006666]@spid[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]4[/COLOR][COLOR=#666600])[/COLOR] [COLOR=#000088]as[/COLOR] varchar[COLOR=#666600]([/COLOR][COLOR=#006666]4[/COLOR][COLOR=#666600]))[/COLOR]
    SELECT    [COLOR=#006666]@v_m_date[/COLOR]             [COLOR=#666600]=[/COLOR] SUBSTRING[COLOR=#666600]([/COLOR]CONVERT[COLOR=#666600]([/COLOR]varchar[COLOR=#666600]([/COLOR][COLOR=#006666]10[/COLOR][COLOR=#666600]),[/COLOR][COLOR=#660066]GetDate[/COLOR][COLOR=#666600](),[/COLOR][COLOR=#006666]112[/COLOR][COLOR=#666600]),[/COLOR][COLOR=#006666]3[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]6[/COLOR][COLOR=#666600])[/COLOR]
    SELECT    [COLOR=#006666]@v_tab_nm[/COLOR]             [COLOR=#666600]=[/COLOR] [COLOR=#008800]'USER_POSTBOX'[/COLOR]
    SELECT    [COLOR=#006666]@v_regdate[/COLOR]             [COLOR=#666600]=[/COLOR] SUBSTRING[COLOR=#666600]([/COLOR]CONVERT[COLOR=#666600]([/COLOR]varchar[COLOR=#666600]([/COLOR][COLOR=#006666]10[/COLOR][COLOR=#666600]),[/COLOR][COLOR=#660066]GetDate[/COLOR][COLOR=#666600](),[/COLOR][COLOR=#006666]112[/COLOR][COLOR=#666600]),[/COLOR][COLOR=#006666]1[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]6[/COLOR][COLOR=#666600])+[/COLOR][COLOR=#008800]'01'[/COLOR]    
    
    DECLARE cur_event_user CURSOR FAST_FORWARD
    FOR
        SELECT character_no
        [COLOR=#000088]from[/COLOR] character[COLOR=#666600].[/COLOR]dbo[COLOR=#666600].[/COLOR]user_character
    OPEN cur_event_user
    FETCH NEXT FROM cur_event_user INTO [COLOR=#006666]@v_character_no[/COLOR]
    
    WHILE [COLOR=#666600]@[/COLOR][COLOR=#006666]@FETCH_STATUS[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    [COLOR=#000088]BEGIN[/COLOR]
        EXEC sp_com_seqno [COLOR=#006666]@v_tab_nm[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_regdate[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_seq_no[/COLOR] OUTPUT
        IF [COLOR=#006666]@v_seq_no[/COLOR] [COLOR=#666600]<[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#000088]BEGIN[/COLOR]
                SELECT    [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]1[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]    
        SET [COLOR=#006666]@v_post_no[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#006666]@v_m_date[/COLOR] [COLOR=#666600]+[/COLOR] dbo[COLOR=#666600].[/COLOR]FN_GetAutoNo[COLOR=#666600]([/COLOR][COLOR=#006666]@v_seq_no[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]8[/COLOR][COLOR=#666600])[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_spid[/COLOR]
        
        [COLOR=#000088]BEGIN[/COLOR] TRANSACTION
        INSERT INTO USER_POSTBOX
        [COLOR=#666600]([/COLOR]
            character_no[COLOR=#666600],[/COLOR]
            post_no[COLOR=#666600],[/COLOR]
            from_char_nm[COLOR=#666600],[/COLOR]
            post_sort[COLOR=#666600],[/COLOR]
            post_title[COLOR=#666600],[/COLOR]
            body_text[COLOR=#666600],[/COLOR]
            state_tag[COLOR=#666600],[/COLOR]
            item_tag[COLOR=#666600],[/COLOR]
            byHeader[COLOR=#666600],[/COLOR]
            wIndex[COLOR=#666600],[/COLOR]
            dwSerialNumber[COLOR=#666600],[/COLOR]
            info[COLOR=#666600],[/COLOR]
            dil_tag[COLOR=#666600],[/COLOR]
            include_dil[COLOR=#666600],[/COLOR]
            ipt_time[COLOR=#666600],[/COLOR]
            expire_time
        [COLOR=#666600])[/COLOR]
        VALUES
        [COLOR=#666600]([/COLOR]    
            [COLOR=#006666]@v_character_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_from_char_nm[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_sort[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_title[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_body_text[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_state_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_item_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_byHeader[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@i_wIndex[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dwSerialNumber[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_info[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dil_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_include_dil[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_curr_time[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_expire_time[/COLOR]
        [COLOR=#666600])[/COLOR]
        IF [COLOR=#666600]@[/COLOR][COLOR=#006666]@ERROR[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]0[/COLOR] OR [COLOR=#666600]@[/COLOR][COLOR=#006666]@ROWCOUNT[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#666600]--[/COLOR] USER_POSTBOX
            [COLOR=#000088]BEGIN[/COLOR]
                ROLLBACK TRANSACTION
                PRINT [COLOR=#008800]'우편함전송실패_쿠퍼 : '[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_character_no[/COLOR]
                SET [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]3[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]
        COMMIT TRANSACTION

        EXEC sp_com_seqno [COLOR=#006666]@v_tab_nm[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_regdate[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_seq_no[/COLOR] OUTPUT
        IF [COLOR=#006666]@v_seq_no[/COLOR] [COLOR=#666600]<[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#000088]BEGIN[/COLOR]
                SELECT    [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]1[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]    
        SET [COLOR=#006666]@v_post_no[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#006666]@v_m_date[/COLOR] [COLOR=#666600]+[/COLOR] dbo[COLOR=#666600].[/COLOR]FN_GetAutoNo[COLOR=#666600]([/COLOR][COLOR=#006666]@v_seq_no[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]8[/COLOR][COLOR=#666600])[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_spid[/COLOR]
        
        [COLOR=#000088]BEGIN[/COLOR] TRANSACTION
        INSERT INTO USER_POSTBOX
        [COLOR=#666600]([/COLOR]
            character_no[COLOR=#666600],[/COLOR]
            post_no[COLOR=#666600],[/COLOR]
            from_char_nm[COLOR=#666600],[/COLOR]
            post_sort[COLOR=#666600],[/COLOR]
            post_title[COLOR=#666600],[/COLOR]
            body_text[COLOR=#666600],[/COLOR]
            state_tag[COLOR=#666600],[/COLOR]
            item_tag[COLOR=#666600],[/COLOR]
            byHeader[COLOR=#666600],[/COLOR]
            wIndex[COLOR=#666600],[/COLOR]
            dwSerialNumber[COLOR=#666600],[/COLOR]
            info[COLOR=#666600],[/COLOR]
            dil_tag[COLOR=#666600],[/COLOR]
            include_dil[COLOR=#666600],[/COLOR]
            ipt_time[COLOR=#666600],[/COLOR]
            expire_time
        [COLOR=#666600])[/COLOR]
        VALUES
        [COLOR=#666600]([/COLOR]    
            [COLOR=#006666]@v_character_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_from_char_nm[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_sort[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_title[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_body_text[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_state_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_item_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_byHeader[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@i_wIndex[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dwSerialNumber[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_info[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dil_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_include_dil[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_curr_time[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_expire_time[/COLOR]
        [COLOR=#666600])[/COLOR]
        IF [COLOR=#666600]@[/COLOR][COLOR=#006666]@ERROR[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]0[/COLOR] OR [COLOR=#666600]@[/COLOR][COLOR=#006666]@ROWCOUNT[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#666600]--[/COLOR] USER_POSTBOX 
            [COLOR=#000088]BEGIN[/COLOR]
                ROLLBACK TRANSACTION
                PRINT [COLOR=#008800]'우편함전송실패_실버 : '[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_character_no[/COLOR]
                SET [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]4[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]
        COMMIT TRANSACTION

        EXEC sp_com_seqno [COLOR=#006666]@v_tab_nm[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_regdate[/COLOR][COLOR=#666600],[/COLOR] [COLOR=#006666]@v_seq_no[/COLOR] OUTPUT
        IF [COLOR=#006666]@v_seq_no[/COLOR] [COLOR=#666600]<[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#000088]BEGIN[/COLOR]
                SELECT    [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]1[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]    
        SET [COLOR=#006666]@v_post_no[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#006666]@v_m_date[/COLOR] [COLOR=#666600]+[/COLOR] dbo[COLOR=#666600].[/COLOR]FN_GetAutoNo[COLOR=#666600]([/COLOR][COLOR=#006666]@v_seq_no[/COLOR][COLOR=#666600],[/COLOR][COLOR=#006666]8[/COLOR][COLOR=#666600])[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_spid[/COLOR]
        
        [COLOR=#000088]BEGIN[/COLOR] TRANSACTION
        INSERT INTO USER_POSTBOX
        [COLOR=#666600]([/COLOR]
            character_no[COLOR=#666600],[/COLOR]
            post_no[COLOR=#666600],[/COLOR]
            from_char_nm[COLOR=#666600],[/COLOR]
            post_sort[COLOR=#666600],[/COLOR]
            post_title[COLOR=#666600],[/COLOR]
            body_text[COLOR=#666600],[/COLOR]
            state_tag[COLOR=#666600],[/COLOR]
            item_tag[COLOR=#666600],[/COLOR]
            byHeader[COLOR=#666600],[/COLOR]
            wIndex[COLOR=#666600],[/COLOR]
            dwSerialNumber[COLOR=#666600],[/COLOR]
            info[COLOR=#666600],[/COLOR]
            dil_tag[COLOR=#666600],[/COLOR]
            include_dil[COLOR=#666600],[/COLOR]
            ipt_time[COLOR=#666600],[/COLOR]
            expire_time
        [COLOR=#666600])[/COLOR]
        VALUES
        [COLOR=#666600]([/COLOR]    
            [COLOR=#006666]@v_character_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_no[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_from_char_nm[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_sort[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_post_title[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_body_text[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_state_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_item_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_byHeader[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@i_wIndex[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dwSerialNumber[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_info[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_dil_tag[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_include_dil[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_curr_time[/COLOR][COLOR=#666600],[/COLOR]
            [COLOR=#006666]@v_expire_time[/COLOR]
        [COLOR=#666600])[/COLOR]
        IF [COLOR=#666600]@[/COLOR][COLOR=#006666]@ERROR[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]0[/COLOR] OR [COLOR=#666600]@[/COLOR][COLOR=#006666]@ROWCOUNT[/COLOR] [COLOR=#666600]<>[/COLOR] [COLOR=#006666]1[/COLOR]
            [COLOR=#666600]--[/COLOR] USER_POSTBOX 
            [COLOR=#000088]BEGIN[/COLOR]
                ROLLBACK TRANSACTION
                PRINT [COLOR=#008800]'우편함전송실패_골드 : '[/COLOR] [COLOR=#666600]+[/COLOR] [COLOR=#006666]@v_character_no[/COLOR]
                SET [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#666600]-[/COLOR][COLOR=#006666]5[/COLOR]
                RETURN
            [COLOR=#000088]END[/COLOR]
        COMMIT TRANSACTION
        FETCH NEXT FROM cur_event_user INTO [COLOR=#006666]@v_character_no[/COLOR]
    [COLOR=#000088]END[/COLOR]
    CLOSE cur_event_user
    DEALLOCATE cur_event_user
    
    SET [COLOR=#006666]@o_sp_rtn[/COLOR] [COLOR=#666600]=[/COLOR] [COLOR=#006666]0[/COLOR]
    RETURN [COLOR=#000088]END[/COLOR]

exec character.dbo.SP_POST_EVENTITEM_BULK 6001, "DEKARON", "GIFT", "ENJOY THIS GIFT!", null
 
Last edited:
Sort by date Sort by votes
The Best DDoS Protected Servers
Status
Not open for further replies.

RaGEZONE Sponsor

    HyperFilter

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Forum statistics

Threads
430,261
Messages
4,597,151
Members
286,906
Latest member
bajhong199
Most visitors online was 17251 , on 24 May 2024

Partners

    nongamstopbets.com Non-GamStop CasinoGap Casino Deps NZ
Back
Top