V14 Files and Database

lettus · Nov 17, 2009

gil1323 said:
can you give me your CHARACTER_01_BF please?

the problem is not heathj CHARACTER_01_DBF
the problem is the way how you build on your SQL server.

CREATE DATABASE [CHARACTER_01_DBF]
ON PRIMARY
( NAME = [CHARACTER_01_DBF_Data],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF.MDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG1]
( NAME = [CHARACTER_01_DBF_Data1],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_1.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG2]
( NAME = [CHARACTER_01_DBF_Data2],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_2.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 100 MB ),
FILEGROUP [CHARACTER_01_DBF_FG3]
( NAME = [CHARACTER_01_DBF_Data3],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_3.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 50 MB ),
FILEGROUP [CHARACTER_01_DBF_FGI]
( NAME = [CHARACTER_01_DBF_DataI],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_4.NDF',
SIZE = 100 MB,
MAXSIZE = UNLIMITED,
FILEGROWTH = 50 MB )
LOG ON
( NAME = [CHARACTER_01_DBF_Log],
FILENAME = N'C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data\CHARACTER_01_DBF_5.LDF',
SIZE = 100 MB,
MAXSIZE = 10000 MB,
FILEGROWTH = 10 MB )
COLLATE Latin1_General_BIN

first of all create your CHARACTER_DBF using this script, and take a look on your SQL date path if is differet change it.

if you all still with problem to setup the server my suggestion is to stop with. :thumbup:

rakter · Nov 17, 2009

lol this no repair anything -.-

Johnatan28 · Nov 17, 2009

:S That code is right but It doesnt repair All the setup problem

I created that database With a friend's code and I can create a char but It have errors when I try to create and When I try to connect to the world server "Check the network or something "

lettus · Nov 17, 2009

is not to repair is to begin...

Johnatan28 · Nov 17, 2009

hey anyone got this error?

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

rakter · Nov 17, 2009

Johnatan28 said:
hey anyone got this error?

me too

gil1323 · Nov 17, 2009

me too CHARACTER_STR

Mohanddo · Nov 17, 2009

lettus said:
the problem is not heathj CHARACTER_01_DBF
the problem is the way how you build on your SQL server.

first of all create your CHARACTER_DBF using this script, and take a look on your SQL date path if is differet change it.

if you all still with problem to setup the server my suggestion is to stop with.

The LOG filegroup isnt needed as mssql creates automatically. And damn why did you give everyone a copy paste solution :mmph:

Johnatan28 said:
hey anyone got this error?

rakter said:
me too

You need a little programming/coding experience to fix that one. All im saying is that its something to do with the way a computer handles instructions...

lettus · Nov 17, 2009

Mohanddo said:
The LOG filegroup isnt needed as mssql creates automatically. And damn why did you give everyone a copy paste solution :mmph:

knowledge is good for all

:

gil1323 · Nov 17, 2009

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 =\

Johnatan28 · Nov 17, 2009

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 · Nov 17, 2009

gil1323 said:
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 · Nov 17, 2009

"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 · Nov 17, 2009

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 · Nov 17, 2009

gil1323 said:
"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" :thumbup:

Mohanddo · Nov 17, 2009

lettus said:
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 · Nov 17, 2009

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

despiteous · Nov 17, 2009

lettus said:
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 · Nov 17, 2009

outlawbr said:
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 · Nov 17, 2009

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

V14 Files and Database

Socius Decennalis

Socius Decennalis

Experienced Elementalist

Socius Decennalis

Experienced Elementalist

Socius Decennalis

Experienced Elementalist

Junior Spellweaver

Socius Decennalis

Experienced Elementalist

Experienced Elementalist

Socius Decennalis

Experienced Elementalist

Experienced Elementalist

Newbie Spellweaver

Junior Spellweaver

Experienced Elementalist

Newbie Spellweaver

Experienced Elementalist

Newbie Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners