[Release] inactive characters remover procedure

[Royalblade*]

Warning.
In case of any error, you'll have an active cursor that does not get deallocated. Use at your own risk.

You dumbfuck arab still don't understand how simple sql scripts work.

[KingDollar]

Originally Posted by Royalblade*

Warning.
In case of any error, you'll have an active cursor that does not get deallocated. Use at your own risk.

You dumbfuck arab still don't understand how simple sql scripts work.

hey indian that's free release defauq wanna fix oke
let create
cursor status function
if CURSOR_STATUS('global','CharShit') >= 0
begin
close CharShit
deallocate CharShit
end

oke here we go then

[Royalblade*]

Originally Posted by Alexiuns*

hey indian that's free release defauq wanna fix oke
let create
cursor status function
if CURSOR_STATUS('global','CharShit') >= 0
begin
close CharShit
deallocate CharShit
end

oke here we go then

gud gud, keep bending that sand!
PS: U seem 2 have learned how 2 use stackoverflow. Very nice, much new brain.exe

[KingDollar]

Originally Posted by Royalblade*

gud gud, keep bending that sand!
PS: U seem 2 have learned how 2 use stackoverflow. Very nice, much new brain.exe

no i learnt how sql working from like 2 years ago xD

my indiannnnn <3
i love your elephant really :*

[Royalblade*]

Originally Posted by Alexiuns*

no i learnt how sql working from like 2 years ago xD

my indiannnnn <3
i love your elephant really :*

2 yrs ago?
You mean 2 yrs ago when you didn't know you can do "x+=1" instead of "X = X +1" even?

You still don't even understand how indexes work, let's not even talk about the actual engine.

You would insta fail the simplest mssql exam (that is useless as **** by the way).

It's funny, sandbender trying to argue about brain1.0.exe.
Don't overrate urself, once a sandbender, forever a sandbender.

#HateEnd

[B1Q]

Originally Posted by Royalblade*

2 yrs ago?
You mean 2 yrs ago when you didn't know you can do "x+=1" instead of "X = X +1" even?

You still don't even understand how indexes work, let's not even talk about the actual engine.

You would insta fail the simplest mssql exam (that is useless as **** by the way).

It's funny, sandbender trying to argue about brain1.0.exe.
Don't overrate urself, once a sandbender, forever a sandbender.

#HateEnd

you both are ******* dumb (y)

[xantos1]

hi


Error Message : The DELETE statement conflicted with the REFERENCE constraint "FK__InventoryForLinkedStorage__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._InventoryForLinkedStorage", column 'ItemID'.

[D.Sro]

un working dont try to use it ,,it will delet unactive and some active chars i tested it faild,dont share your idiot work again b4 tested in your server LOL

[EdwardTeach+-]

well lets test that out

[xxnukertube]

don't work with me

[Hamza FiGo]

Links down ? and there is many error inside the proc.

[simplex93]

It deletes every Storage, Every Guild Storage and Every Items in a Pet, how to solve this?

[KingDollar]

Originally Posted by simplex93

It deletes every Storage, Every Guild Storage and Every Items in a Pet, how to solve this?

well it's old procedure
you can edit it

[SubZero**]

awesome work keep it up

[Muhab*]

Well, I don't really agree with Royalblade offense for Arabs.

But still, This is a bullshit and not even gonna work for all characters.
As i see you have just tried to use some SQL functions without knowing how they actually work. Even your delete statements are really primitive when you need to join another table values.

Man you are really blackening Arabs.
Please don't post/release anything you are not qualified with.