Register for your free account! | Forgot your password?

You last visited: Today at 19:38

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

i have bug in grap pet need fix it

Discussion on i have bug in grap pet need fix it within the SRO PServer Questions & Answers forum part of the SRO Private Server category.

Reply
Page 1 of 2 1 2
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Question i have bug in grap pet need fix it

i have bug in grap pet need fix it
grap pet in some time when pick drop give account dc and delete all items in storage pet
how fix it
give me this error in sr_gameserver
Query: {CALL _STRG_ADD_EXPENDABLE (?, ?, 17,254494, 0,9237,1)}
AQ Failed! Log out!! [AQType: 1]
i change it bas same bug pet delete items and give dc
i think Procedure delete line grap pet from tap _InvCOS when delete line pet from this tap pet make bug dc
i see pet have bug not have line in this tap _InvCOS
i need know who delete line pet from this tap _InvCOS
when delete line Procedure can't creat new line
M@hmoud is offline  
Old 07/22/2022, 23:58   #2
 
@$$'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 733
Received Thanks: 87
you are using ****** database some VT_SHARD stored PROCEDUREs are broken try another one
@$$ is offline  
Old 07/23/2022, 14:28   #3
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by @$$ View Post
you are using ****** database some VT_SHARD stored PROCEDUREs are broken try another one
can't change data i play with it befor long time i need fix this bug only
M@hmoud is offline  
Old 07/23/2022, 19:21   #4
 
@$$'s Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2010
Posts: 733
Received Thanks: 87
Quote:
Originally Posted by M@hmoud View Post
can't change data i play with it befor long time i need fix this bug only
Good luck fixing that xD
@$$ is offline  
Old 07/23/2022, 20:08   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by @$$ View Post
Good luck fixing that xD
i change all this Procedure but same bug not fix yet
give me this error in sr_gameserver
Query: {CALL _STRG_ADD_EXPENDABLE (?, ?, 17,254494, 0,9237,1)}
AQ Failed! Log out!! [AQType: 1]
M@hmoud is offline  
Old 08/03/2022, 11:53   #6
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
no one have fix ?
M@hmoud is offline  
Old 08/03/2022, 14:33   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2011
Posts: 163
Received Thanks: 28
copy paste those procedures from a reliable db man
NagySandor96 is offline  
Old 08/04/2022, 11:39   #8
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by NagySandor96 View Post
copy paste those procedures from a reliable db man
give me name this procedures
M@hmoud is offline  
Old 08/04/2022, 17:03   #9
 
Judgelemental's Avatar
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Aug 2013
Posts: 1,532
Received Thanks: 835
Quote:
Originally Posted by M@hmoud View Post
give me name this procedures
Why are you SO lazy and demanding?
Judgelemental is offline  
Old 08/04/2022, 20:19   #10
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by Judgelemental View Post
Why are you SO lazy and demanding?
i not ask u
M@hmoud is offline  
Old 08/05/2022, 06:56   #11

 
R3D*'s Avatar
 
elite*gold: 190
The Black Market: 38/1/0
Join Date: May 2011
Posts: 1,203
Received Thanks: 811
Why do you try to change your database names?
Just change it back.
R3D* is offline  
Old 08/05/2022, 13:28   #12
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by R3D* View Post
Why do you try to change your database names?
Just change it back.
i can't change my database i play with it long time and have player
i need fix this bug only not need change database
M@hmoud is offline  
Old 08/05/2022, 14:04   #13

 
R3D*'s Avatar
 
elite*gold: 190
The Black Market: 38/1/0
Join Date: May 2011
Posts: 1,203
Received Thanks: 811
Quote:
Originally Posted by M@hmoud View Post
i can't change my database i play with it long time and have player
i need fix this bug only not need change database
Try this
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_SPLIT_ITEM] Script Date: 08/03/2013 02:18:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------
        -- Modify _STRG_SPLIT_ITEM SP
        ALTER PROCEDURE [dbo].[_STRG_SPLIT_ITEM]
        [MENTION=2474014]newit[/MENTION]emID        AS BIGINT OUTPUT,
        [MENTION=1687905]latest[/MENTION]ItemSN     AS BIGINT OUTPUT,
        [MENTION=1059401]operation[/MENTION]        AS TINYINT,
        [MENTION=292919]user[/MENTION]JID        AS INT,
        @CharID            AS INT,
        [MENTION=5337177]slot_[/MENTION]From        AS TINYINT,
        [MENTION=5337177]slot_[/MENTION]To        AS TINYINT,
        @Data_From        AS INT,
        @Data_To        AS INT
        AS

            
            SET [MENTION=2474014]newit[/MENTION]emID = 0
            IF  [MENTION=1059401]operation[/MENTION] <> 0)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1000
                RETURN
            END
            IF   [MENTION=5337177]slot_[/MENTION]From = [MENTION=5337177]slot_[/MENTION]To)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1001
                RETURN
            END
            
            IF (@Data_From = 0 OR @Data_To = 0)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1002
                RETURN
            END
            IF  [MENTION=5337177]slot_[/MENTION]From < 13 OR [MENTION=5337177]slot_[/MENTION]To < 13)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -5100
                RETURN
            END
            DECLARE @ItemID_From    BIGINT
            DECLARE @ItemID_To        BIGINT
            SET @ItemID_From = 0
            SET @ItemID_To = 0

        
            SELECT @ItemID_From = ItemID FROM _Inventory WITH (NOLOCK) WHERE CharID = @CharID AND Slot = [MENTION=5337177]slot_[/MENTION]From
            SELECT @ItemID_To    = ItemID FROM _Inventory WITH (NOLOCK) WHERE CharID = @CharID AND Slot = [MENTION=5337177]slot_[/MENTION]To
            IF (@ItemID_From IS NULL OR @ItemID_To IS NULL)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1003
            END
            IF (@ItemID_From = 0 OR @ItemID_To <> 0)    
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1004
                RETURN
            END

            DECLARE @ItemRefID    INT
            SET @ItemRefID = 0
            SELECT @ItemRefID = RefItemID FROM _Items WITH (NOLOCK) WHERE ID64 = @ItemID_From
            IF (@ItemRefID = 0 OR @ItemRefID IS NULL)
            BEGIN
                SET [MENTION=2474014]newit[/MENTION]emID = -1
                RETURN
            END
        BEGIN TRANSACTION

            EXEC [MENTION=2474014]newit[/MENTION]emID = _STRG_ALLOC_ITEM_NoTX [MENTION=1687905]latest[/MENTION]ItemSN OUTPUT
            IF  [MENTION=2474014]newit[/MENTION]emID = 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET [MENTION=2474014]newit[/MENTION]emID = -2
                RETURN
            END
            UPDATE _Items SET RefItemID = @ItemRefID, Data = @Data_To WHERE ID64 = [MENTION=2474014]newit[/MENTION]emID
            IF (@@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET [MENTION=2474014]newit[/MENTION]emID = -3
                RETURN
            END
            UPDATE _Inventory SET ItemID = [MENTION=2474014]newit[/MENTION]emID WHERE CharID = @CharID AND Slot [MENTION=5337177]slot_[/MENTION]To
            IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET [MENTION=2474014]newit[/MENTION]emID = -4
                RETURN
            END

            UPDATE _Items SET Data = @Data_From WHERE ID64 = @ItemID_From
            IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET [MENTION=2474014]newit[/MENTION]emID = -5    
                RETURN
            END

            COMMIT TRANSACTION
            
            RETURN
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_ADD_EXPENDABLE] Script Date: 08/03/2013 02:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_STRG_ADD_EXPENDABLE]
        [MENTION=2474014]newit[/MENTION]emID        AS BIGINT OUTPUT,
        [MENTION=1687905]latest[/MENTION]ItemSN     AS BIGINT OUTPUT,
        [MENTION=1059401]operation[/MENTION]        AS TINYINT,
        @CharID            AS INT,
        [MENTION=303108]slot[/MENTION]          AS TINYINT,
        [MENTION=6278456]refit[/MENTION]emID        AS INT,

        @Data             AS INT

        AS
            -- #define SP_PICK_ITEM                    (BYTE)6
            -- #define SP_BUY_ITEM                    (BYTE)8
            -- #define SP_ADD_ITEM_BY_SERVER        (BYTE)14
        BEGIN TRANSACTION

        
            EXEC _STRG_ADD_EXPENDABLE_NoTX [MENTION=2474014]newit[/MENTION]emID OUTPUT, [MENTION=1687905]latest[/MENTION]ItemSN OUTPUT, [MENTION=1059401]operation[/MENTION], @CharID, [MENTION=303108]slot[/MENTION], [MENTION=6278456]refit[/MENTION]emID, @Data

            IF (@@ERROR <> 0 OR [MENTION=2474014]newit[/MENTION]emID <= 0)
            BEGIN
                ROLLBACK TRANSACTION
                RETURN
            END
        COMMIT TRANSACTION
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_ADD_EQUIP_NORMAL] Script Date: 08/03/2013 02:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



-------------------------------------------------------------------------------------
        -- Modify _STRG_ADD_EQUIP_NORMAL SP
ALTER PROCEDURE [dbo].[_STRG_ADD_EQUIP_NORMAL]
        [MENTION=2474014]newit[/MENTION]emID        AS BIGINT OUTPUT,
        [MENTION=1687905]latest[/MENTION]ItemSN     AS BIGINT OUTPUT,
        [MENTION=1059401]operation[/MENTION]        AS TINYINT,
        @CharID            AS INT,
         [MENTION=303108]slot[/MENTION]            AS TINYINT,
        [MENTION=6278456]refit[/MENTION]emID        AS INT,
        [MENTION=1489981]opt[/MENTION]Level        AS TINYINT,
        [MENTION=382588]variance[/MENTION]        AS BIGINT,
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        »óÁ¡°³Æí (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        @Data             AS INT
--      [MENTION=508836]remain[/MENTION]Gold        AS BIGINT
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        AS
            
            -- #define SP_PICK_ITEM                    (BYTE)6
            -- #define SP_BUY_ITEM                    (BYTE)8
            -- #define SP_ADD_ITEM_BY_SERVER        (BYTE)14
        BEGIN TRANSACTION
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        »óÁ¡°³Æí (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@        
            EXEC _STRG_ADD_EQUIP_NORMAL_NoTX [MENTION=2474014]newit[/MENTION]emID OUTPUT, [MENTION=1687905]latest[/MENTION]ItemSN OUTPUT, [MENTION=1059401]operation[/MENTION], @CharID, [MENTION=303108]slot[/MENTION], [MENTION=6278456]refit[/MENTION]emID, [MENTION=1489981]opt[/MENTION]Level,  [MENTION=382588]variance[/MENTION], @Data
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@        
            IF (@@ERROR <> 0 OR [MENTION=2474014]newit[/MENTION]emID <= 0)
            BEGIN
                ROLLBACK TRANSACTION
                RETURN
            END
        COMMIT TRANSACTION
R3D* is offline  
Old 08/05/2022, 17:19   #14
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2008
Posts: 236
Received Thanks: 11
Quote:
Originally Posted by R3D* View Post
Try this
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_SPLIT_ITEM] Script Date: 08/03/2013 02:18:38 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------
        -- Modify _STRG_SPLIT_ITEM SP
        ALTER PROCEDURE [dbo].[_STRG_SPLIT_ITEM]
        @NewItemID        AS BIGINT OUTPUT,
        @LatestItemSN     AS BIGINT OUTPUT,
        @Operation        AS TINYINT,
           [MENTION=292919]user[/MENTION]JID        AS INT,
        @CharID            AS INT,
           [MENTION=5337177]slot_[/MENTION]From        AS TINYINT,
           [MENTION=5337177]slot_[/MENTION]To        AS TINYINT,
        @Data_From        AS INT,
        @Data_To        AS INT
        AS

            
            SET @NewItemID = 0
            IF (@Operation <> 0)
            BEGIN
                SET @NewItemID = -1000
                RETURN
            END
            IF     [MENTION=5337177]slot_[/MENTION]From =    [MENTION=5337177]slot_[/MENTION]To)
            BEGIN
                SET @NewItemID = -1001
                RETURN
            END
            
            IF (@Data_From = 0 OR @Data_To = 0)
            BEGIN
                SET @NewItemID = -1002
                RETURN
            END
            IF     [MENTION=5337177]slot_[/MENTION]From < 13 OR    [MENTION=5337177]slot_[/MENTION]To < 13)
            BEGIN
                SET @NewItemID = -5100
                RETURN
            END
            DECLARE @ItemID_From    BIGINT
            DECLARE @ItemID_To        BIGINT
            SET @ItemID_From = 0
            SET @ItemID_To = 0

        
            SELECT @ItemID_From = ItemID FROM _Inventory WITH (NOLOCK) WHERE CharID = @CharID AND Slot =    [MENTION=5337177]slot_[/MENTION]From
            SELECT @ItemID_To    = ItemID FROM _Inventory WITH (NOLOCK) WHERE CharID = @CharID AND Slot =    [MENTION=5337177]slot_[/MENTION]To
            IF (@ItemID_From IS NULL OR @ItemID_To IS NULL)
            BEGIN
                SET @NewItemID = -1003
            END
            IF (@ItemID_From = 0 OR @ItemID_To <> 0)    
            BEGIN
                SET @NewItemID = -1004
                RETURN
            END

            DECLARE @ItemRefID    INT
            SET @ItemRefID = 0
            SELECT @ItemRefID = RefItemID FROM _Items WITH (NOLOCK) WHERE ID64 = @ItemID_From
            IF (@ItemRefID = 0 OR @ItemRefID IS NULL)
            BEGIN
                SET @NewItemID = -1
                RETURN
            END
        BEGIN TRANSACTION

            EXEC @NewItemID = _STRG_ALLOC_ITEM_NoTX @LatestItemSN OUTPUT
            IF (@NewItemID = 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET @NewItemID = -2
                RETURN
            END
            UPDATE _Items SET RefItemID = @ItemRefID, Data = @Data_To WHERE ID64 = @NewItemID
            IF (@@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET @NewItemID = -3
                RETURN
            END
            UPDATE _Inventory SET ItemID = @NewItemID WHERE CharID = @CharID AND Slot =    [MENTION=5337177]slot_[/MENTION]To
            IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET @NewItemID = -4
                RETURN
            END

            UPDATE _Items SET Data = @Data_From WHERE ID64 = @ItemID_From
            IF (@@ROWCOUNT = 0 OR @@ERROR <> 0)
            BEGIN
                ROLLBACK TRANSACTION
                SET @NewItemID = -5    
                RETURN
            END

            COMMIT TRANSACTION
            
            RETURN
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_ADD_EXPENDABLE] Script Date: 08/03/2013 02:20:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[_STRG_ADD_EXPENDABLE]
        @NewItemID        AS BIGINT OUTPUT,
        @LatestItemSN     AS BIGINT OUTPUT,
        @Operation        AS TINYINT,
        @CharID            AS INT,
           [MENTION=303108]slot[/MENTION]            AS TINYINT,
        @RefItemID        AS INT,

        @Data             AS INT

        AS
            -- #define SP_PICK_ITEM                    (BYTE)6
            -- #define SP_BUY_ITEM                    (BYTE)8
            -- #define SP_ADD_ITEM_BY_SERVER        (BYTE)14
        BEGIN TRANSACTION

        
            EXEC _STRG_ADD_EXPENDABLE_NoTX @NewItemID OUTPUT, @LatestItemSN OUTPUT, @Operation, @CharID,    [MENTION=303108]slot[/MENTION], @RefItemID, @Data

            IF (@@ERROR <> 0 OR @NewItemID <= 0)
            BEGIN
                ROLLBACK TRANSACTION
                RETURN
            END
        COMMIT TRANSACTION
Code:
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_STRG_ADD_EQUIP_NORMAL] Script Date: 08/03/2013 02:21:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



-------------------------------------------------------------------------------------
        -- Modify _STRG_ADD_EQUIP_NORMAL SP
ALTER PROCEDURE [dbo].[_STRG_ADD_EQUIP_NORMAL]
        @NewItemID        AS BIGINT OUTPUT,
        @LatestItemSN     AS BIGINT OUTPUT,
        @Operation        AS TINYINT,
        @CharID            AS INT,
           [MENTION=303108]slot[/MENTION]            AS TINYINT,
        @RefItemID        AS INT,
        @OptLevel        AS TINYINT,
        [MENTION=382588]variance[/MENTION]        AS BIGINT,
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        »óÁ¡°³Æí (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        @Data             AS INT
--        [MENTION=508836]remain[/MENTION]Gold        AS BIGINT
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
        AS
            
            -- #define SP_PICK_ITEM                    (BYTE)6
            -- #define SP_BUY_ITEM                    (BYTE)8
            -- #define SP_ADD_ITEM_BY_SERVER        (BYTE)14
        BEGIN TRANSACTION
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--        »óÁ¡°³Æí (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@        
            EXEC _STRG_ADD_EQUIP_NORMAL_NoTX @NewItemID OUTPUT, @LatestItemSN OUTPUT, @Operation, @CharID,    [MENTION=303108]slot[/MENTION], @RefItemID, @OptLevel, [MENTION=382588]variance[/MENTION], @Data
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@        
            IF (@@ERROR <> 0 OR @NewItemID <= 0)
            BEGIN
                ROLLBACK TRANSACTION
                RETURN
            END
        COMMIT TRANSACTION
all same this line give error
Code:
          [MENTION=292919]user[/MENTION]JID        AS INT,
          [MENTION=5337177]slot_[/MENTION]From        AS TINYINT,
          [MENTION=5337177]slot_[/MENTION]To        AS TINYINT,
Code:
Msg 102, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 7 [Batch Start Line 7]
Incorrect syntax near 'MENTION=292919'.
Msg 4145, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 22 [Batch Start Line 7]
An expression of non-boolean type specified in a context where a condition is expected, near 'slot_'.
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 28 [Batch Start Line 7]
Must declare the scalar variable "@Data_From".
Msg 4145, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 33 [Batch Start Line 7]
An expression of non-boolean type specified in a context where a condition is expected, near 'slot_'.
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 44 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 45 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 73 [Batch Start Line 7]
Must declare the scalar variable "@Data_To".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 80 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 88 [Batch Start Line 7]
Must declare the scalar variable "@Data_From".
M@hmoud is offline  
Old 08/05/2022, 17:47   #15

 
R3D*'s Avatar
 
elite*gold: 190
The Black Market: 38/1/0
Join Date: May 2011
Posts: 1,203
Received Thanks: 811
Quote:
Originally Posted by M@hmoud View Post
all same this line give error
Code:
          [MENTION=292919]user[/MENTION]JID        AS INT,
          [MENTION=5337177]slot_[/MENTION]From        AS TINYINT,
          [MENTION=5337177]slot_[/MENTION]To        AS TINYINT,
Code:
Msg 102, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 7 [Batch Start Line 7]
Incorrect syntax near 'MENTION=292919'.
Msg 4145, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 22 [Batch Start Line 7]
An expression of non-boolean type specified in a context where a condition is expected, near 'slot_'.
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 28 [Batch Start Line 7]
Must declare the scalar variable "@Data_From".
Msg 4145, Level 15, State 1, Procedure _STRG_SPLIT_ITEM, Line 33 [Batch Start Line 7]
An expression of non-boolean type specified in a context where a condition is expected, near 'slot_'.
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 44 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 45 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 73 [Batch Start Line 7]
Must declare the scalar variable "@Data_To".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 80 [Batch Start Line 7]
Must declare the scalar variable "@CharID".
Msg 137, Level 15, State 2, Procedure _STRG_SPLIT_ITEM, Line 88 [Batch Start Line 7]
Must declare the scalar variable "@Data_From".
Here you go.
Attached Files
File Type: rar Fix.rar (2.0 KB, 8 views)
R3D* is offline  
Reply
Page 1 of 2 1 2

« Fellow pet mounting character scale Issue | Capture The Flag notification??? »

Similar Threads Similar Threads
grap pet and attack pet spawn dc
02/02/2016 - SRO Private Server - 0 Replies
if i click on pet to spawn it i got dc and when i open i find nothing happened :3 please help me
How to fix the Grap/Attack Pet Bug?
06/08/2014 - SRO Coding Corner - 1 Replies
Hey, if i spawn a Grap/Attack Pet it spawns for a second and they the Client crashing. -> DC. Anyone know how to fix this bug? :D
How to fix the Grap/Attack Pet Bug?
06/04/2014 - SRO Private Server - 1 Replies
Hey, if i spawn a Grap/Attack Pet it spawns for a second and they the Client crashing. -> DC. Anyone know how to fix this bug? :D
[04.09.13] GigaByte v2.6 [FIX, FIX, FIX, FIX AND FIX]
09/11/2013 - WarRock Hacks, Bots, Cheats & Exploits - 79 Replies
http://www.elitepvpers.com/forum/warrock-hacks-bot s-cheats-exploits/2843300-11-09-gigabyte-public-v2 -7-a.html



All times are GMT +1. The time now is 19:38.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2025 elitepvpers All Rights Reserved.