[Share]database RanGame1, Haircolor & Hairstyle fixed..

[sanarunnow]

After fixing some minor sp_procedure.. i've managed to use the HairColor without rollback..

Edit:-
Here is the Actual RanGame1 database.. which i modified..

Via Rapidshare:

You must be registered to see links

Also for some sp_procedure i also added in RanLog

You must be registered to see links

Via Mediafire(thnks to eijnebsky99 for the links):-
RanGame1

You must be registered to see links

RanLog

You must be registered to see links

Note: This database has not yet fixed the pet and also other error..tq

Credits to Ragezone

 

[danish]

i've test this database....yes...it fix the hair color....but the problem is pet right?? any update??

 

[nurjah]

My Server dont have gang creation problems only hair color and Pet.

 

[SeraphiPod]

hm....
Does this fix the pet + hair bug?(completed? or still incomplete)
and....
How will I help my db not wipe out if I will get this backup?
I will replace my Query to that Query??????????
If I can't Understand you
please add me
seraph_angels12@yahoo.com
thx

and Is this the query? of RAnGame1??????????????

You must be registered to see links

Do I need to replace RanLog too?
Can anyone give me If I still need.

 

[SeraphiPod]

AW!
Sorry, DOUBLE POSt
sorry, I got lagg..

 

[sanarunnow]

Problem in wiping database? Use this instead of my RanGame1.bak

USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[UpdateChaHairColor] Script Date: 06/29/2008 15:38:36 edited by sanarunnow******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[UpdateChaHairColor]
@nChaNum int,
@nChaHairColor int,
@nReturn int OUTPUT
AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON

SET @nReturn = 0

UPDATE ChaInfo
SET ChaHairColor=@nChaHairColor
WHERE ChaNum=@nChaNum

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
SET @nReturn = -1
SET NOCOUNT OFF
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END

Copy paste and run this script at your database.. by using sql query method

Pls Note: this will only fix your HairColor rollback problem..

 

[Tenzou]

@all

Info to have perfect no rollback for pet at RanLog i think magenik put the error appearing in Field Server....The PetInven or something appear he stored it at RanLog..... And He Added Something On RanGame1...

 

[SeraphiPod]

Problem in wiping database? Use this instead of my RanGame1.bak
Quote:
USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[UpdateChaHairColor] Script Date: 06/29/2008 15:38:36 edited by sanarunnow******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[UpdateChaHairColor]
@nChaNum int,
@nChaHairColor int,
@nReturn int OUTPUT
AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON

SET @nReturn = 0

UPDATE ChaInfo
SET ChaHairColor=@nChaHairColor
WHERE ChaNum=@nChaNum

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
SET @nReturn = -1
SET NOCOUNT OFF
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
Copy paste and run this script at your database.. by using sql query method

Pls Note: this will only fix your HairColor rollback problem..

hmm? I will replcae my RanGame1 Query?
This won't Replace my own data?/
like character????????????????????///

and This only fix Ran color?
I thought Both??

@all

Info to have perfect no rollback for pet at RanLog i think magenik put the error appearing in Field Server....The PetInven or something appear he stored it at RanLog..... And He Added Something On RanGame1...

thx for the iNfo.

 

[michael2k10]

hayzz i have now DB for Color and style that will not roll back your char!! ~_~ and i have a pet that will not roll back!!

@nurjah

can i have your NPC talk that can create a gang for mix class then i will give you my DB for no roll back of hair color, style, and PET!!

 

[SeraphiPod]

michael Can I get your
Hair color + style and pet fix???

just queries..??
plz??

and

Problem in wiping database? Use this instead of my RanGame1.bak


USE [RanGame1]
GO
/****** Object: StoredProcedure [dbo].[UpdateChaHairColor] Script Date: 06/29/2008 15:38:36 edited by sanarunnow******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[UpdateChaHairColor]
@nChaNum int,
@nChaHairColor int,
@nReturn int OUTPUT
AS
DECLARE
@error_var int,
@rowcount_var int

SET NOCOUNT ON

SET @nReturn = 0

UPDATE ChaInfo
SET ChaHairColor=@nChaHairColor
WHERE ChaNum=@nChaNum

SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
SET @nReturn = -1
SET NOCOUNT OFF
RETURN @nReturn
END
ELSE
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END

Copy paste and run this script at your database.. by using sql query method

Pls Note: this will only fix your HairColor rollback problem..
hmm? I will replcae my RanGame1 Query?
This won't Replace my own data?/
like character????????????????????///

and This only fix Ran color?
I thought Both??

@all

Info to have perfect no rollback for pet at RanLog i think magenik put the error appearing in Field Server....The PetInven or something appear he stored it at RanLog..... And He Added Something On RanGame1...
thx for the iNfo.

and How WIll I edit The Queries at RanGame1???????????????????????????////
any ideas?
Can I have a guide, or just tell me a tip on how to edit.?

 

[sanarunnow]

hayzz i have now DB for Color and style that will not roll back your char!! ~_~ and i have a pet that will not roll back!!

@nurjah

can i have your NPC talk that can create a gang for mix class then i will give you my DB for no roll back of hair color, style, and PET!!

so why you didnt share it.. no offense but i think the "OLD atitude" still exist.. I miss the old dayzzz...

Thanks

@SeraphiPod

This is a query to fix the sp_procedure.. it didnt affect your database..

 

[michael2k10]

hayzzz i want to have an exchange so my sharing will not like my old shared of skill to 300 that someone blame me that i shared it with no procedure or step!!! hahahaha!!!

 

[SeraphiPod]

so why you didnt share it.. no offense but i think the "OLD atitude" still exist.. I miss the old dayzzz...

Thanks

@SeraphiPod

This database is a query to fix the sp_procedure.. it didnt affect your database..

now, I mean,
How can I edit my RanGame1 Query?
..................................................
thx sanarunnow, just asking, didn't did that yet
sp_procedure?
and
can you explain more what that does the query do?, sorry, really can't understand the other posts
cause
examplename: for hair
examplename: for pet?
i really don't know, so thank you for the ansZwer
@michael
and I'll search for ur 300 skills ^_^

 

[michael2k10]

hahahha i delete my thread of 300 skills cause someone making a noise that my skill is out of animation!! so what will i do that the EP3 animation and EP4 are now change hahaha but my players really happy to my skills ^_^ and they saying really cool!!

 

[SeraphiPod]

hmm,
nice,
But How can You Edit EP4 Skill.ssf?

 

[SeraphiPod]

sanarunnow
I will make a new query?

 

[argemille]

ouch...my old character didnt appear >.<

 

[winword]

@argemille
you are posting in the wrong section dude...

 

[Abry]

Guys please stop bringing back old threads.