[FIX] Delete Char Error - Global Manager!

[Jangan]

So, i just realized that these are stolen test files >.< and there are like 25-30 estimated missing tables! I would love this thread to stay here because its also a discussion thread! And i need as much help as possible and contribution from this community. Stop Being dead guys, go out there and search with me! Lets develop this piece of shit files!



Information and how i came to this?
- I run 2 servers "Perfection Online" and there are thousands of players online, with this i can test just about anything. And i released some seriously major long term damage o.O haha!


---------------------------------------------------------------------------------
-- Current Releases Below Here
---------------------------------------------------------------------------------

Missing Table: SR_CharAppoint
Place it in: SRO_VT_ACCOUNTS
Linked SP: _ManageShardCharNames
Description: Missing Reference Data!

Problems: [In-complete]
- Notice that in this stored procedure, it does exactly the same thing for both tables, where it should actually be referencing CharID = actual CharID not CharName but don't worry, i will find the rest and fix it soon!. But for now! this is step 1/3 and not Complete! So don't use it on official server stuff yet! Or you can just easily disable the CharAppoint fields? idk do as you like!

Create the SR_CharAppoint table using this query:

USE [SRO_VT_ACCOUNT]
GO
/****** CopyRighted by Jangan @ Ragezone.com ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SR_CharAppoint](
    [UserJID] [int] NOT NULL,
    [ShardID] [int] NOT NULL,
    [CharID] [varchar](64) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF 

apply the _ManageShardCharNames query:

USE [SRO_VT_ACCOUNT]
GO
/****** CopyRighted by Jangan @ Ragezone.com ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER procedure [dbo].[_ManageShardCharName]
    @job        tinyint,
    @UserJID       int,
    @ShardID       smallint,
    @CharName     varchar(64),
    @OldName     varchar(64)
as
    -- add new char name
    if (@job = 0)
    begin
        if (not exists(select * from SR_ShardCharNames where UserJID =  @UserJID and ShardID = @ShardID and CharName = @CharName))
        begin
            insert SR_ShardCharNames values(@UserJID, @ShardID, @CharName)
        end
        if (not exists(select * from SR_CharAppoint where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName))
        begin
            insert SR_CharAppoint values(@UserJID, @ShardID, @CharName)
        end
    end
    -- remove char name
    else if (@job = 1)
    begin
        delete SR_ShardCharNames where UserJID = @UserJID and ShardID = @ShardID and CharName = @CharName
        delete SR_CharAppoint    where UserJID = @UserJID and ShardID = @ShardID and CharID = @CharName
    end
    -- rename previous one
    else if (@job = 2)
    begin
        update SR_ShardCharNames set CharName = @CharName where UserJID =  @UserJID and ShardID = @ShardID and CharName = @OldName
        update SR_CharAppoint set CharID = @CharName where UserJID = @UserJID and ShardID = @ShardID and CharID = @OldName
    end 

[MentaL]

[WireShark]

Thanks for this Jangan

[sladlejrhfpq]

thank you, hope you can fix it soon ^^

[LastThief]

if you wanna help i'm partly sql coder(not really pro 1 xDD)

pm me at

thelastthief <-- Skype

[K4bo]

Awesome!

[xxNukertube]

Nice !