Problem DB

03/28/2015 01:47 xkilyx#1

Hello! I have the following error adding the glowchange of jopsi (DB)
raventh1984 folow the guide, but there is something I'm doing wrong.
The error that has me at stake is that changing the glow from play this is stored in the DB, but not stored where it should.
eg: the glowarmrigth is stored in idcampus

I'm obviously doing something wrong, all columns are run in 2, but any attempt to accommodate dorma that remains flat or makes me crash the DB.
From already thank you, and I hope someone tells me I'm doing wrong :)
pd DB is very little, which does not help me lol

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

03/31/2015 16:48 randeljohnvalencia#2

[Only registered and activated users can see links. Click Here To Register...]

Execute to the CHARACTER_STR and CHARACTER_TBL

CHARACTER_TBL =Edit and paste

CHARACTER_STR = modify and paste

sorry for bad english :)

04/07/2015 00:56 xkilyx#3

test the DB clean, perfect!
the thing is that the DB files are used by more aggregated data. and that's where I find the problem. Add glow data correctly but in the game the number corresponding to glow saved in the score of pvp arena.

04/07/2015 02:19 - DK#4

Check this out:

Quote:

Originally Posted by raventh1984

Oke here you go.

Open your database and right click CHARACTER_TBL then click on design.
At the bottom you need to insert.
GlowArmRight (INT)
GlowArmLeft (INT)
GlowLegRight (INT)
GlowLegLeft (INT)
GlowBody (INT)
GlowHandLeft (INT)
GlowHandRight (INT)

After you have done that save it.

Then we go to stored procedures
And we find CHARACTER_STR right click on it Modify.

Then Search for
, @im_idCampus int = 0
And below we add this

Spoiler

---------- Glow System
, @iGlowArmleft int = 0
, @iGlowArmRight int = 0
, @iGlowLegLeft int = 0
, @iGlowLegRight int = 0
, @iGlowBody int = 0
, @iGlowHandLeft int = 0
, @iGlowHandRight int = 0

Then search for
IF @iGu = 'S8' -- ??? ?? ????

In the Select procedure find
, isnull(R.m_LogOutTime, 0) m_LogOutTime
And after that we add

Spoiler

, A.GlowArmLeft
, A.GlowArmRight
, A.GlowLegLeft
, A.GlowLegRight
, A.GlowBody
, A.GlowHandLeft
, A.GlowHandRight

Then search for
IF @iGu = 'U1' -- ??? ??

In the UPDATE procedure search for
, idCampus = @im_idCampus
And below that add

Spoiler

, GlowArmLeft = @iGlowArmleft
, GlowArmRight = @iGlowArmRight
, GlowLegLeft = @iGlowLegLeft
, GlowLegRight = @iGlowLegRight
, GlowBody = @iGlowBody
, GlowHandLeft = @iGlowHandLeft
, GlowHandRight = @iGlowHandRight

Then find
IF @iGu = 'I1' -- ?? ?? ??

And in the INSERT PROCEDURE find
INSERT CHARACTER_TBL
In the INSERT STATEMENT below , idCampus add

Spoiler

, GlowArmLeft
, GlowArmRight
, GlowLegLeft
, GlowLegRight
, GlowBody
, GlowHandLeft
, GlowHandRight

Then after the second ,0
add
7x an , 0

After you done that all click on execute and youre done.

With kind regards,
Loky