[Request] Glow Change database

[Rhyder`]

Anyone can give me the database of jopsi glow?

[ThoughtfulDev]

databse allon wont work u need the procedurse just use the one from jopsis invisble night files which he released some time ago...

[Rhyder`]

Originally Posted by Shonenx33

databse allon wont work u need the procedurse just use the one from jopsis invisble night files which he released some time ago...

on jopsi release are all dead link..

lets wait if there is the one can help

because my problem is when i restart my server the glow back to normal

[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

[tangia1426]

What is this sir?

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

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

With kind regards,
Loky

Ihave a Problem

Msg 109, Level 15, State 1, Procedure CHARACTER_STR, Line 1307
There are more 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.

[raventh1984]

Dont you guys Read???

Ooh wel here we go spoon feed this one again....

In the INSERT PROCEDURE you will notice in VALUES this

1,
0,
0,
0,
@im_SkillPoint,
@im_SkillLv,
@im_SkillExp
-- Ver 15
, '$'
, 0
, 0
So after that second 0 add 7 times an , 0
So i will look like this

 Spoiler

1,
0,
0,
0,
@im_SkillPoint,
@im_SkillLv,
@im_SkillExp
-- Ver 15
, '$'
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0

Now if you still dont get it. Then its out of my control. Its the easiest thing to do.

And btw Your error is already saying what there is wrong with it.
There are more columns then values.

[tangia1426]

Who Know HOw to fix this one

query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

[raventh1984]

Its the thing almost everyone have. Dont post it here but make an new topic. And first of all seach on google. Then you will see 90% has this problem. I have no time to fix that so i lett it be as it is.

And @ msyryr98 watch out what your write. That post is useless and offending.
@ Nico12348 i dont think we can do anything with your comment.

[Rhyder`]

Originally Posted by raventh1984

Dont you guys Read???

Ooh wel here we go spoon feed this one again....

In the INSERT PROCEDURE you will notice in VALUES this

1,
0,
0,
0,
@im_SkillPoint,
@im_SkillLv,
@im_SkillExp
-- Ver 15
, '$'
, 0
, 0
So after that second 0 add 7 times an , 0
So i will look like this

 Spoiler

1,
0,
0,
0,
@im_SkillPoint,
@im_SkillLv,
@im_SkillExp
-- Ver 15
, '$'
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0

Now if you still dont get it. Then its out of my control. Its the easiest thing to do.

And btw Your error is already saying what there is wrong with it.
There are more columns then values.

Can you make it on script? to quick add..

[raventh1984]

i can't cause its possible you are using an other CHARACTER_STR procedure then i am.
So make it your self. it takes 5 mins of your time.

[DarkFlyffTeam]

Originally Posted by tangia1426

Who Know HOw to fix this one

query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".

Add a linked server for that database.

[emanuelmatias]

Thx im use :

1,
0,
0,
0
, '$'
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
)

[macboyem07]

Originally Posted by raventh1984

i can't cause its possible you are using an other CHARACTER_STR procedure then i am.
So make it your self. it takes 5 mins of your time.

how to fix this:

[W.o.F]

Originally Posted by macboyem07

how to fix this:

Recode make sure you finish the step. before executing
read carefully

[Kindergarten]

Originally Posted by macboyem07

how to fix this:

Blame me if I'm wrong but isnt the correct Query command "INSERT INTO" ?