Glow Problem

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

Soweit ich weiß wird es in der Datenbank eingespeichert. :o

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

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

Jopsi's in Db.

DB for Jopsis Glowchange:

Quote:

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.

Quote:

Originally Posted by Armageddon' DB for Jopsis Glowchange:

hi i got this error

Quote:

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 ^^

Quote:

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)

Quote:

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?

Quote:

Originally Posted by Armageddon' add me in skype i help you ^^

i dont have skype., facebook if you want