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
---------- 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
, 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
, 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
, 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.