Glow Problem

[gross128]

hallo leute ich habe eine Kleine frage

wir haben Glow Changer eingebaut und ich weis leider nicht wie ich es hinbekomme das der glow gespeichert wird

es wehre sehr nett wenn mit einer ein erklärung geben könnte damit ich endlich meinen glow speichern kann

Danke..

MfG Fuchs

[Lumi]

Soweit ich weiß wird es in der Datenbank eingespeichert.

[xTwiLightx]

Am besten in der CHARACTER_STR (U1) mit abspeichern lassen.

[TrøublêMakêr]

Pumaaa's glow wird in der neuz.ini gespeichert.

Jopsi's in Db.

[- Major]

DB for Jopsis Glowchange:

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.

[Ecrypter]

Originally Posted by Armageddon'

DB for Jopsis Glowchange:

hi i got this error

PHP Code:

Msg 109, Level 15, State 1, Procedure CHARACTER_STR, Line 1209
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. 


[- Major]

Originally Posted by Ecrypter

hi i got this error

PHP Code:

Msg 109, Level 15, State 1, Procedure CHARACTER_STR, Line 1209
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. 


add me in skype i help you ^^

[Lumi]

Originally Posted by Ecrypter

hi i got this error

PHP Code:

Msg 109, Level 15, State 1, Procedure CHARACTER_STR, Line 1209
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. 


It means you have to add more columns because there are more columns in the query to insert.
So be sure to add those in your character_tbl:

GlowArmRight (INT)
GlowArmLeft (INT)
GlowLegRight (INT)
GlowLegLeft (INT)
GlowBody (INT)
GlowHandLeft (INT)
GlowHandRight (INT)

[xTwiLightx]

Originally Posted by ​Lumi

It means you have to add more columns because there are more columns in the query to insert.
So be sure to add those in your character_tbl:

GlowArmRight (INT)
GlowArmLeft (INT)
GlowLegRight (INT)
GlowLegLeft (INT)
GlowBody (INT)
GlowHandLeft (INT)
GlowHandRight (INT)

Nein, er gibt in seiner Insert Query mehr Spalten als Values an.
Wenn die Spalten nicht existieren würden, würde diese Meldung kommen.

b2t:
can you show us your I1 block from that procedure?

[Ecrypter]

Originally Posted by Armageddon'

add me in skype i help you ^^

i dont have skype., facebook if you want