V14 Files and Database

**Johnatan28** · 17-11-09

god bless you lettus xD

and mohanddo I'm trying to "fix" the char creation bug :S

and this xd
Mens 208, Level 16, State 1, Procedure viw_Item_Info, Line 3
The object name 'CHARACTER_TBL' is invalid.

That error has to be with the char creation?

**lettus** · 17-11-09

Originally Posted by gil1323

OK I fixed the errors in CHARACTER_01_DBF
but Im trying to create character, im writing the name and chosing apearance, and then im clicking Create and no character =\
and i dont get any error in the server files =\

my suggestion is:

delete ACCOUNT_DBF
CHARACTER_01_DBF
ITEM_DBF
LOG_01_DBF
LOGGING_01_DBF and
RANKING_DBF

than start creating again...

ACCOUNT_DBF
CHARACTER_01_DBF by using the script
ITEM_DBF
LOG_01_DBF
LOGGING_01_DBF and
RANKING_DBF

ok. now start put the SQL files in reverse, begin with RANKING_DBF, LOGGING_01_DBF, LOG_01_DBF, ITEM_DBF, ACCOUNT_DBF and last one CHARACTER_01_DBF

**gil1323** · 17-11-09

"Mens 208, Level 16, State 1, Procedure viw_Item_Info, Line 3
The object name 'CHARACTER_TBL' is invalid."
I have this error too!

**Johnatan28** · 17-11-09

hey lettus

the char creation still bugged but I can create a char, but I cant conect to the server, flaris etc

CQuery-LogFile

2009/11/17 13:53:49
query: MAIL_STR_REALTIME 'S1', '01 '
SQLSTATE: 22007 Error: [Microsoft] [SQL Native Client] [SQL Server] The
conversion of char data type to datetime produced a datetime value
out of range.
2009/11/17 13:54:16
query: CHARACTER_STR
'I1', @ im_idPlayer = '0000000 ', @ iserverindex = '01', @ iaccount = 'Enoch', @ im_szNa
me = 'Enoch', @ iplayerslot = 1, @ idwWorldID = 1, @ im_dwIndex = 11, @ im_vPos_x = 0.00000
0, @ im_vPos_y = 0.000000, @ im_vPos_z = 0.000000, @ im_szCharacterKey = '(null)', @ im
_dwSkinSet = 0, @ im_dwHairMesh = 4, @ im_dwHairColor =-
10192011, @ im_dwHeadMesh = 2, @ im_dwSex = 0, @ im_vScale_x = 0.000000, @ im_dwMotion =
0, @ im_fAngle = 0.000000, @ im_nHitPoint = 0, @ im_nManaPoint = 0, @ im_nFatiguePoint =
0, @ im_dwRideItemIdx = 0, @ im_dwGold = 0, @ im_nJob = 0, @ im_pActMover = '(null)', @ im_
NST = 0, @ im_nSta = 0, @ im_nDex = 0, @ im_nInt = 0, @ im_nLevel = 0, @ im_nExp1 = 0, @ im_nExp
2 = 0, @ im_aJobSkill = '(null)', @ im_aLicenseSkill = '(null)', @ im_aJobLv = '(null)'
, @ im_dwExpertLv = 0, @ im_idMarkingWorld = 0, @ im_vMarkingPos_x = 0.000000, @ im_vMa
rkingPos_y = 0.000000, @ im_vMarkingPos_z = 0.000000, @ im_nRemainGP = 0, @ im_nRemai
NLP = 0, @ im_nFlightLv = 0, @ im_nFxp = 0, @ im_nTxp = 0, @ im_lpQuestCntArray = '(null)',
@ im_chAuthority = 'F', @ im_dwMode = 0, @ im_idparty = 0, @ im_idMuerderer = 0, @ im_nFam
e = 0, @ im_nDeathExp = 0, @ im_nDeathLevel = 0, @ im_dwFlyTime = 0, @ im_nMessengerState
= 0, @ iTotalPlayTime = 0, @ im_Card = '(null)', @ im_Index_Card = '(null)', @ im_ObjInd
ex_Card = '(null)', @ im_Cube = '(null)', @ im_Index_Cube = '(null)', @ im_ObjIndex_C
ube = '(null)', @ im_Inventory = '(null)', @ im_apIndex = '(null)', @ im_adwEquipment
= '(null)', @ im_dwObjIndex = '(null)', @ im_aSlotApplet = '(null)', @ im_aSlotItem =
'(null)', @ im_aSlotQueue = '(null)', @ im_SkillBar = 0, @ im_Bank = '(null)', @ im_apI
ndex_Bank = '(null)', @ im_dwObjIndex_Bank = '(null)', @ im_dwGoldBank = 0, @ im_nFue
l = 0, @ im_tmAccFuel = 0, @ im_dwSMTime = '(null)', @ iSkillInfluence = '(null)', @ im_a
CompleteQuest = '(null)', @ im_extInventory = '(null)', @ im_InventoryPiercing = '(
null) ', @ im_extBank =' (null) ', @ im_BankPiercing
= '(null)', @ im_dwReturnWorldID = 0, @ im_vReturnPos_x = 0.000000, @ im_vReturnPos_
y = 0.000000, @ im_vReturnPos_z = 0.000000, @ im_nPKValue = 0, @ im_dwPKPropensity = 0,
@ im_dwPKExp = 0, @ im_nAngelExp = 0, @ im_nAngelLevel = 0, @ iszInventoryPet = '(null)'
, @ iszBankPet = '(null)', @ im_dwPetId = 0, @ im_nExpLog = 0,
@ im_nAngelExpLog = 0, @ im_nCoupon = 0, @ im_nHonor =- 1, @ im_nLayer = 0
SQLSTATE: 22007 Error: [Microsoft] [SQL Native Client] [SQL Server] The
conversion of char data type to datetime produced a datetime value
out of range.
2009/11/17 13:54:24
query: CHARACTER_STR
'S4', @ im_idPlayer = '0000001 ', @ iserverindex = '01', @ iaccount = '(null)', @ im_szN
ame = '(null)', @ iplayerslot = 0, @ idwWorldID = 0, @ im_dwIndex = 0, @ im_vPos_x = 0.0000
00, @ im_vPos_y = 0.000000, @ im_vPos_z = 0.000000, @ im_szCharacterKey = '(null)', @ i
m_dwSkinSet = 0, @ im_dwHairMesh = 0, @ im_dwHairColor = 0, @ im_dwHeadMesh = 0, @ im_dwS
ex = 0, @ im_vScale_x = 0.000000, @ im_dwMotion = 0, @ im_fAngle = 0.000000, @ im_nHitPoi
nt = 0, @ im_nManaPoint = 0, @ im_nFatiguePoint = 0, @ im_dwRideItemIdx = 0, @ im_dwGold =
0, @ im_nJob = 0, @ im_pActMover = '(null)', @ im_nStr = 0, @ im_nSta = 0, @ im_nDex = 0, @ im_
nInt = 0, @ im_nLevel = 0, @ im_nExp1 = 0, @ im_nExp2 = 0, @ im_aJobSkill = '(null)', @ im_aL
icenseSkill = '(null)', @ im_aJobLv = '(null)', @ im_dwExpertLv = 0, @ im_idMarkingWo
rld = 0, @ im_vMarkingPos_x = 0.000000, @ im_vMarkingPos_y = 0.000000, @ im_vMarkingP
os_z = 0.000000, @ im_nRemainGP = 0, @ im_nRemainLP = 0, @ im_nFlightLv = 0, @ im_nFxp = 0,
@ im_nTxp = 0, @ im_lpQuestCntArray = '(null)', @ im_chAuthority = 'F', @ im_dwMode = 0,
@ im_idparty = 0, @ im_idMuerderer = 0, @ im_nFame = 0, @ im_nDeathExp = 0, @ im_nDeathLev
el = 0, @ im_dwFlyTime = 0, @ im_nMessengerState = 0, @ iTotalPlayTime = 0, @ im_Card = '(n
ull) ', @ im_Index_Card =' (null) ', @ im_ObjIndex_Card =' (null) ', @ im_Cube =' (null)
', @ im_Index_Cube =' (null) ', @ im_ObjIndex_Cube =' (null) ', @ im_Inventory =' (null
) ', @ im_apIndex =' (null) ', @ im_adwEquipment =' (null) ', @ im_dwObjIndex =' (null) '
, @ im_aSlotApplet = '(null)', @ im_aSlotItem = '(null)', @ im_aSlotQueue = '(null)',
@ im_SkillBar = 0, @ im_Bank = '(null)', @ im_apIndex_Bank = '(null)', @ im_dwObjIndex
_Bank = '(Null)', @ im_dwGoldBank = 0, @ im_nFuel = 0, @ im_tmAccFuel = 0, @ im_dwSMTime =
'(null)', @ iSkillInfluence = '(null)', @ im_aCompleteQuest = '(null)', @ im_extInv
entory = '(null)', @ im_InventoryPiercing = '(null)', @ im_extBank = '(null)', @ im_B
ankPiercing
= '(null)', @ im_dwReturnWorldID = 0, @ im_vReturnPos_x = 0.000000, @ im_vReturnPos_
y = 0.000000, @ im_vReturnPos_z = 0.000000, @ im_nPKValue = 0, @ im_dwPKPropensity = 0,
@ im_dwPKExp = 0, @ im_nAngelExp = 0, @ im_nAngelLevel = 0, @ iszInventoryPet = '(null)'
, @ iszBankPet = '(null)', @ im_dwPetId = 0, @ im_nExpLog = 0,
@ im_nAngelExpLog = 0, @ im_nCoupon = 0, @ im_nHonor =- 1, @ im_nLayer = 0
SQLSTATE: 22007 Error: [Microsoft] [SQL Native Client] [SQL Server] The
conversion of char data type to datetime produced a datetime value
out of range.
2009/11/17 13:54:24
query: CHARACTER_STR
'S6', @ im_idPlayer = '0000001 ', @ iserverindex = '01', @ iaccount = '(null)', @ im_szN
ame = '(null)', @ iplayerslot = 0, @ idwWorldID = 0, @ im_dwIndex = 0, @ im_vPos_x = 0.0000
00, @ im_vPos_y = 0.000000, @ im_vPos_z = 0.000000, @ im_szCharacterKey = '(null)', @ i
m_dwSkinSet = 0, @ im_dwHairMesh = 0, @ im_dwHairColor = 0, @ im_dwHeadMesh = 0, @ im_dwS
ex = 0, @ im_vScale_x = 0.000000, @ im_dwMotion = 0, @ im_fAngle = 0.000000, @ im_nHitPoi
nt = 0, @ im_nManaPoint = 0, @ im_nFatiguePoint = 0, @ im_dwRideItemIdx = 0, @ im_dwGold =
0, @ im_nJob = 0, @ im_pActMover = '(null)', @ im_nStr = 0, @ im_nSta = 0, @ im_nDex = 0, @ im_
nInt = 0, @ im_nLevel = 0, @ im_nExp1 = 0, @ im_nExp2 = 0, @ im_aJobSkill = '(null)', @ im_aL
icenseSkill = '(null)', @ im_aJobLv = '(null)', @ im_dwExpertLv = 0, @ im_idMarkingWo
rld = 0, @ im_vMarkingPos_x = 0.000000, @ im_vMarkingPos_y = 0.000000, @ im_vMarkingP
os_z = 0.000000, @ im_nRemainGP = 0, @ im_nRemainLP = 0, @ im_nFlightLv = 0, @ im_nFxp = 0,
@ im_nTxp = 0, @ im_lpQuestCntArray = '(null)', @ im_chAuthority = 'F', @ im_dwMode = 0,
@ im_idparty = 0, @ im_idMuerderer = 0, @ im_nFame = 0, @ im_nDeathExp = 0, @ im_nDeathLev
el = 0, @ im_dwFlyTime = 0, @ im_nMessengerState = 0, @ iTotalPlayTime = 0, @ im_Card = '(n
ull) ', @ im_Index_Card =' (null) ', @ im_ObjIndex_Card =' (null) ', @ im_Cube =' (null)
', @ im_Index_Cube =' (null) ', @ im_ObjIndex_Cube =' (null) ', @ im_Inventory =' (null
) ', @ im_apIndex =' (null) ', @ im_adwEquipment =' (null) ', @ im_dwObjIndex =' (null) '
, @ im_aSlotApplet = '(null)', @ im_aSlotItem = '(null)', @ im_aSlotQueue = '(null)',
@ im_SkillBar = 0, @ im_Bank = '(null)', @ im_apIndex_Bank = '(null)', @ im_dwObjIndex
_Bank = '(Null)', @ im_dwGoldBank = 0, @ im_nFuel = 0, @ im_tmAccFuel = 0, @ im_dwSMTime =
'(null)', @ iSkillInfluence = '(null)', @ im_aCompleteQuest = '(null)', @ im_extInv
entory = '(null)', @ im_InventoryPiercing = '(null)', @ im_extBank = '(null)', @ im_B
ankPiercing
= '(null)', @ im_dwReturnWorldID = 0, @ im_vReturnPos_x = 0.000000, @ im_vReturnPos_
y = 0.000000, @ im_vReturnPos_z = 0.000000, @ im_nPKValue = 0, @ im_dwPKPropensity = 0,
@ im_dwPKExp = 0, @ im_nAngelExp = 0, @ im_nAngelLevel = 0, @ iszInventoryPet = '(null)'
, @ iszBankPet = '(null)', @ im_dwPetId = 0, @ im_nExpLog = 0,
@ im_nAngelExpLog = 0, @ im_nCoupon = 0, @ im_nHonor =- 1, @ im_nLayer = 0
SQLSTATE: 24000 Error: [Microsoft] [SQL Native Client] cursor state
valid
2009/11/17 13:54:49
query: MAIL_STR_REALTIME 'S1', '01 '
SQLSTATE: 24000 Error: [Microsoft] [SQL Native Client] cursor state
valid

eh

2009/11/17 13:52:59
CWorld::AddObj world id:202 x:1343.000000 y:94.000000 z:1215.000000
2009/11/17 13:52:59
CWorld::AddObj world id:202 x:1288.000000 y:98.000000 z:1356.000000
2009/11/17 13:53:00
CWorld::AddObj world id:1 x:4609.000000 y:60.000000 z:4409.000000
2009/11/17 13:53:00
CWorld::AddObj world id:1 x:2587.000000 y:52.000000 z:3603.000000
2009/11/17 13:53:00
CWorld::AddObj world id:1 x:2805.000000 y:109.000000 z:2336.000000
2009/11/17 13:53:00
CWorld::AddObj world id:203 x:1498.000000 y:88.000000 z:1524.000000

Error log1:

2009/11/17 13:54:24
D:\ÇØ¿Ü\neurospace\Program\_database\DbManager.cpp, 1136 CHARACTER_STR 'S4',@im_idPlayer='0000001',@iserverindex='01',@iaccount='(null)',@im_szName='(null)',@iplayerslot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=0,@im_dwHairColor=0,@im_dwHeadMesh=0,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0
2009/11/17 13:54:24
OnJoin(): Henoc, 5

**outlawbr** · 17-11-09

Originally Posted by gil1323

"Mens 208, Level 16, State 1, Procedure viw_Item_Info, Line 3
The object name 'CHARACTER_TBL' is invalid."
I have this error too!

you get this error because you trying to create a view or stored procedure before you create the table

try to put all your "CREATE TABLE" scripts at the start of file, then you put the "CREATE VIEW" or "CREATE PROCEDURE"

if still not working, try to use the "MSSql books online"

**Mohanddo** · 17-11-09

Originally Posted by lettus

knowledge is good for all

But no one will know what it does :( they will just copy and paste it to fix the error without knowing what is happening.

And there you go outlaw told you second fix lol.

**Johnatan28** · 17-11-09

mohanddo with that fix can somebody how its works for example whit the script of the character I learn something xd

**despiteous** · 17-11-09

Originally Posted by lettus

my suggestion is:

delete ACCOUNT_DBF
CHARACTER_01_DBF
ITEM_DBF
LOG_01_DBF
LOGGING_01_DBF and
RANKING_DBF

than start creating again...

ACCOUNT_DBF
CHARACTER_01_DBF by using the script
ITEM_DBF
LOG_01_DBF
LOGGING_01_DBF and
RANKING_DBF

ok. now start put the SQL files in reverse, begin with RANKING_DBF, LOGGING_01_DBF, LOG_01_DBF, ITEM_DBF, ACCOUNT_DBF and last one CHARACTER_01_DBF

Well you don´t really need the logging_01_dbf because it´s just an older database of log_01_dbf i think...
It works good without and the certifier is easy to fix...

**gil1323** · 17-11-09

Originally Posted by outlawbr

you get this error because you trying to create a view or stored procedure before you create the table

try to put all your "CREATE TABLE" scripts at the start of file, then you put the "CREATE VIEW" or "CREATE PROCEDURE"

if still not working, try to use the "MSSql books online"

if I will deleate the "CREATE VIEW" from the script?

**haddel** · 17-11-09

May I can get a Tip ?
I batched all the Database like Lettus said .
In the same Order .
I haven't got an error .
I put jFlyff (V14 Client [No Res Files] ) Model , World and SFX Folder to Resource Folder of V14 Serverfiles .
I could only create a Char , else I get an Error :

Code:

2009/11/17	19:35:16
query:CHARACTER_STR 'I1',@im_idPlayer='0000000',@iserverindex='01',@iaccount='mazexd',@im_szName='Testing',@iplayerslot=1,@idwWorldID=1,@im_dwIndex=11,@im_vPos_x=0.000000,@im_vPos_y=0.000000,@im_vPos_z=-1.#QNAN0,@im_szCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairMesh=2,@im_dwHairColor=-6391955,@im_dwHeadMesh=2,@im_dwSex=0,@im_vScale_x=0.000000,@im_dwMotion=0,@im_fAngle=0.000000,@im_nHitPoint=0,@im_nManaPoint=0,@im_nFatiguePoint=0,@im_dwRideItemIdx=0,@im_dwGold=0,@im_nJob=0,@im_pActMover='(null)',@im_nStr=0,@im_nSta=0,@im_nDex=0,@im_nInt=0,@im_nLevel=0,@im_nExp1=0,@im_nExp2=0,@im_aJobSkill='(null)',@im_aLicenseSkill='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@im_idMarkingWorld=0,@im_vMarkingPos_x=0.000000,@im_vMarkingPos_y=0.000000,@im_vMarkingPos_z=0.000000,@im_nRemainGP=0,@im_nRemainLP=0,@im_nFlightLv=0,@im_nFxp=0,@im_nTxp=0,@im_lpQuestCntArray='(null)',@im_chAuthority='F',@im_dwMode=0,@im_idparty=0,@im_idMuerderer=0,@im_nFame=0,@im_nDeathExp=0,@im_nDeathLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0,@iTotalPlayTime=0,@im_Card='(null)',@im_Index_Card='(null)',@im_ObjIndex_Card='(null)',@im_Cube='(null)',@im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)',@im_Inventory='(null)',@im_apIndex='(null)',@im_adwEquipment='(null)',@im_dwObjIndex='(null)',@im_aSlotApplet='(null)',@im_aSlotItem='(null)',@im_aSlotQueue='(null)',@im_SkillBar=0,@im_Bank='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex_Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tmAccFuel=0,@im_dwSMTime='(null)',@iSkillInfluence='(null)',@im_aCompleteQuest='(null)',@im_extInventory='(null)',@im_InventoryPiercing='(null)',@im_extBank='(null)',@im_BankPiercing ='(null)',@im_dwReturnWorldID=0,@im_vReturnPos_x=0.000000,@im_vReturnPos_y=0.000000,@im_vReturnPos_z=0.000000,@im_nPKValue=0,@im_dwPKPropensity=0,@im_dwPKExp=0,@im_nAngelExp=0,@im_nAngelLevel=0,@iszInventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0
SQLSTATE:42000 error:[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '#QNAN0'.

When I try to login to the World I get a Message : "Please Checkt The Network , ..."

Thanks for your Upcoming Tip or Help

**Mohanddo** · 17-11-09

Originally Posted by despiteous

Well you don´t really need the logging_01_dbf because it´s just an older database of log_01_dbf i think...
It works good without and the certifier is easy to fix...

This is true :)

**gil1323** · 17-11-09

Can you tell me why i cant see the character that I created?

**theunreal** · 17-11-09

Connecton..Please wait after choosing channel

**haddel** · 17-11-09

For what does #QNANO stay for ?

**melcat** · 17-11-09

Not a number

V14 Files and Database

Thread Tools

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Re: V14 Files and Database

Advertisement