[iNEED] GLOW SYSTEM DATABASE JOPSI

05/03/2013 11:45 macboyem07#1
anyone can give me Glow System DATABASE plss :handsdown:
05/03/2013 12:16 W.o.F#2
Quote:
Originally Posted by raventh1984 View Post
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

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

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

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

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

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

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

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

After you done that all click on execute and youre done.
read carefully!
05/03/2013 14:53 macboyem07#3
Then search for
IF @iGu = 'S8' -- ??? ?? ????

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


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

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


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

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



I dont understand this .. 2 search? :( xD
05/03/2013 15:16 ThoughtfulDev#4
in the character_str
05/03/2013 15:54 brent2121#5
Quote:
Originally Posted by macboyem07 View Post
Then search for
IF @iGu = 'S8' -- ??? ?? ????

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


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

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


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

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



I dont understand this .. 2 search? :( xD

try to use GOH database
05/03/2013 18:11 macboyem07#6
Quote:
Originally Posted by Shonenx33 View Post
in the character_str
Msg 110, Level 15, State 1, Procedure CHARACTER_STR, Line 1308
There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.


:( error again and again xD

can u give me easy way to add all that? :handsdown:
05/03/2013 19:10 ThoughtfulDev#7
u forgot this

Then after the second ,0
add
7x an , 0
05/23/2013 06:50 emadelyn#8
can i request for the SFX???