Problem DB

[xkilyx]

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

[randeljohnvalencia]

Execute to the CHARACTER_STR and CHARACTER_TBL

CHARACTER_TBL =Edit and paste

CHARACTER_STR = modify and paste


sorry for bad english

[xkilyx]

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.

[- DK]

Check this out:

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