Glow Problem

09/05/2014 21:21 gross128#1
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
09/05/2014 22:01 Lumi#2
Soweit ich weiß wird es in der Datenbank eingespeichert. :o
09/06/2014 02:28 xTwiLightx#3
Am besten in der CHARACTER_STR (U1) mit abspeichern lassen.
09/06/2014 13:49 TrøublêMakêr#4
Pumaaa's glow wird in der neuz.ini gespeichert.

Jopsi's in Db.
09/06/2014 14:02 - DK#5
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

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.
09/09/2014 17:12 Ecrypter#6
Quote:
Originally Posted by Armageddon' View Post
DB for Jopsis Glowchange:

hi i got this error

PHP Code:
Msg 109Level 15State 1Procedure CHARACTER_STRLine 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
09/10/2014 00:45 - DK#7
Quote:
Originally Posted by Ecrypter View Post
hi i got this error

PHP Code:
Msg 109Level 15State 1Procedure CHARACTER_STRLine 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 ^^
09/10/2014 13:30 Lumi#8
Quote:
Originally Posted by Ecrypter View Post
hi i got this error

PHP Code:
Msg 109Level 15State 1Procedure CHARACTER_STRLine 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)
09/10/2014 14:19 xTwiLightx#9
Quote:
Originally Posted by ​Lumi View Post
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?
09/14/2014 08:48 Ecrypter#10
Quote:
Originally Posted by Armageddon' View Post
add me in skype i help you ^^

i dont have skype., facebook if you want