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

sanarunnow · Jun 11, 2008

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 · Jun 20, 2008

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

nurjah · Jun 23, 2008

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

SeraphiPod · Jun 29, 2008

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 · Jun 29, 2008

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

sanarunnow · Jun 29, 2008

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 · Jun 29, 2008

@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 · Jun 29, 2008

sanarunnow said:
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??

Tenzou said:
@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 · Jun 29, 2008

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 · Jun 29, 2008

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

just queries..??
plz??

and

sanarunnow said:
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??

Tenzou said:
@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 · Jun 29, 2008

michael2k10 said:
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 · Jun 30, 2008

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 · Jun 30, 2008

sanarunnow said:
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 · Jun 30, 2008

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 · Jul 4, 2008

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

SeraphiPod · Jul 8, 2008

sanarunnow
I will make a new query?

argemille · Jan 30, 2009

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

winword · Jan 30, 2009

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

Abry · Jan 31, 2009

Guys please stop bringing back old threads.

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

sanarunnow

Newbie Spellweaver

danish

Newbie Spellweaver

nurjah

Junior Spellweaver

SeraphiPod

-sama

SeraphiPod

-sama

sanarunnow

Newbie Spellweaver

Tenzou

Experienced Elementalist

SeraphiPod

-sama

michael2k10

New Time

SeraphiPod

-sama

sanarunnow

Newbie Spellweaver

michael2k10

New Time

SeraphiPod

-sama

michael2k10

New Time

SeraphiPod

-sama

SeraphiPod

-sama

argemille

Newbie Spellweaver

winword

Newbie Spellweaver

Abry

Omega Male