|
You last visited: Today at 11:45
Advertisement
Problem Country System database
Discussion on Problem Country System database within the Flyff Private Server forum part of the Flyff category.
11/17/2013, 07:22
|
#1
|
elite*gold: 0
Join Date: May 2013
Posts: 239
Received Thanks: 11
|
Problem Country System database
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
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.
|
|
|
11/17/2013, 08:53
|
#2
|
elite*gold: 0
Join Date: Oct 2012
Posts: 948
Received Thanks: 157
|
Quote:
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
|
|
|
11/17/2013, 09:33
|
#3
|
elite*gold: 0
Join Date: May 2013
Posts: 239
Received Thanks: 11
|
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
|
|
|
11/17/2013, 10:08
|
#4
|
elite*gold: 0
Join Date: Jan 2013
Posts: 22,407
Received Thanks: 8,227
|
Use this
Code:
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.
|
|
|
|
Similar Threads
|
HELP COUNTRY SYSTEM
08/14/2013 - Flyff Private Server - 10 Replies
Cant enter to world my neuz always crashing .. Thanks
|
help me about country icon system
07/29/2013 - Flyff Private Server - 14 Replies
when i reconnect to the game the country icon rollback.. help me plss..i need database or what??..
|
[Help] Country Icon System
03/27/2013 - Flyff Private Server - 1 Replies
Sir please help me..
How to insert Country Icon of my server....
what .cpp and .h files do I need to insert country icon on my server
please help
|
[Request] Country Flag Source code and Database
02/13/2013 - Flyff Private Server - 1 Replies
Any one can give the source codes and database of country flag?
|
[Help]Country System
11/13/2012 - Flyff Private Server - 2 Replies
Hallo Community..
Ich bin langsam am verzweifeln bei diesem System -.-
Ich hab in der DPLOGINCLIENT.H das eingetragen
#ifdef __COUNTRY_ICON
void SendCreatePlayer( BYTE nMode, BYTE nSlot, LPCSTR lpszPlayer/*, LPDWORD adwEquipment*/, BYTE nFace, BYTE nCostume, BYTE nSkinSet, BYTE nHairMesh, DWORD dwHairColor, BYTE nSex, BYTE nJob, BYTE nHeadMesh, int nBankPW = 0, int nCountry = 0 );
#else
|
All times are GMT +2. The time now is 11:45.
|
|