Problem Country System database

[WooTheFck]

Good day guys. Im done putting country system on my source
the only problem that i encounter is the database for it. Here's below
database that show's an error :


This is on my database structure
0, --m_dwSkillPoint
1,
0,
0,
0,
@im_SkillPoint,
@im_SkillLv,
@im_SkillExp
-- Ver 15
, '$'
, 0
, 0
)




This is the database for the country system
0, --m_dwSkillPoint
1,
0,
0,
0
-- Ver 15
, '$'
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
, 0
-- ,'$'
, 0
)


See the difference?

so how can i insert the database for it im getting error when put it

 Spoiler

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

by the way im done putting other database for country system,
also im inserted this on my character_tbl m_nCountry.


-Thanks, I hope there's someone help me.

[raventh1984]

Originally Posted by WooTheFck

Msg 110, Level 15, State 1, Procedure CHARACTER_STR, Line 1178
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.
[/Spoiler]

its already saying the answer.

Let me explain it in an simple way

INSERT INTO (test,test1,test2) VALUES (hi,hi1,hi2,hi3)

This will result in the above error cause you have specified to much values according to the insert columns. They should contain the same ammount of collumns vs values

[WooTheFck]

this my character_tbl insert

INSERT CHARACTER_TBL
(
m_idPlayer,
serverindex,
account,
m_szName,
playerslot,
dwWorldID,
m_dwIndex,
m_vScale_x,
m_dwMotion,
m_vPos_x,
m_vPos_y,
m_vPos_z,
m_fAngle,
m_szCharacterKey,
m_nHitPoint,
m_nManaPoint,
m_nFatiguePoint,
m_nFuel,
m_dwSkinSet,
m_dwHairMesh,
m_dwHairColor,
m_dwHeadMesh,
m_dwSex,
m_dwRideItemIdx,
m_dwGold,
m_nJob,
m_pActMover,
m_nStr,
m_nSta,
m_nDex,
m_nInt,
m_nLevel,
m_nMaximumLevel,
m_nExp1,
m_nExp2,
m_aJobSkill,
m_aLicenseSkill,
m_aJobLv,
m_dwExpertLv,
m_idMarkingWorld,
m_vMarkingPos_x,
m_vMarkingPos_y,
m_vMarkingPos_z,
m_nRemainGP,
m_nRemainLP,
m_nFlightLv,
m_nFxp,
m_nTxp,
m_lpQuestCntArray,
m_aCompleteQuest,
m_chAuthority,
m_dwMode,
m_idparty,
m_idCompany,
m_idMuerderer,
m_nFame,
m_nDeathExp,
m_nDeathLevel,
m_dwFlyTime,
m_nMessengerState,
blockby,
TotalPlayTime,
isblock,
End_Time,
BlockTime,
CreateTime,
m_tmAccFuel,
m_tGuildMember,
m_dwSkillPoint,
m_dwReturnWorldID,
m_vReturnPos_x,
m_vReturnPos_y,
m_vReturnPos_z,
m_SkillPoint,
m_SkillLv,
m_SkillExp
---------- Ver 15
, m_aCheckedQuest
, m_nCampusPoint
, idCampus
, m_nCountry

[Deadline.]

Use this

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

Or just add one ,0 because it's only one more value.