GoH Files Problem

06/03/2013 14:03 Ankis59#1
Hey, i have problem in GoH files

One problem : I restart server and the server rollback however the time rollback is 10 sec ...

Two problem : In game the skill K crash ...

Possible help me pliz thanks :')
06/03/2013 14:54 Velmore#2
For Problem one: log your char out if you restart the server
06/03/2013 15:24 raventh1984#3
Also check your Cquery log. Some players are having troubles with huge rollbacks. When they opend the Cquery log there was an error that prevends from saving the player.
06/03/2013 23:02 Ankis59#4
I have error in Cquery log : query:{call CHARACTER_STR('U1','0000033','01','',?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?, 0, 0, 0,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?, ?,?)}
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Procedure or function CHARACTER_STR has too many arguments specified.
06/04/2013 02:37 Atheni#5
Your character saves when it's logged out, so that's how you solve the first problem, as for the second problem, you'll have to do some query work.
06/04/2013 07:57 WooTheFck#6
try to delete linked server ranking then use the v15 linked server and execute
06/04/2013 10:02 raventh1984#7
@ Atheni Look at his Query its not saving the char even when he logs out its not saving it.

@ WooTheFck This has nothing to do with linked servers.

@all please give the correct information instead of just guessing.

@Ankis

Open up your database CHARACTER_01_DBF
Then go to stored procedures and right click CHARACTER_STR
Then choose modify

Then search for U1
There you have it

There are more Values then there are fields thats way it cant save it correctly
So what you have to do is compare the list inside the U1 with the fields inside CHARACTER_TBL then you will see that its missing an bunch of fields.

And my guess(Yes now i am guessing) Is that you are missing the fields for the Jobs glow change.
06/04/2013 10:23 Ankis59#8
I have search U1 it's :
IF @iGu = 'U1' -- ??? ??
BEGIN
UPDATE CHARACTER_TBL
SET dwWorldID = @idwWorldID,
m_dwIndex = @im_dwIndex,
m_dwSex = @im_dwSex,
m_vScale_x = @im_vScale_x,
m_dwMotion = @im_dwMotion,
m_vPos_x = @im_vPos_x,
m_vPos_y = @im_vPos_y,
m_vPos_z = @im_vPos_z,
m_dwHairMesh = @im_dwHairMesh,
m_dwHairColor = @im_dwHairColor,
m_dwHeadMesh = @im_dwHeadMesh, -- 2004/11/08 ??
m_fAngle = 0, --@im_fAngle,
m_szCharacterKey = @im_szCharacterKey,

m_nHitPoint = @im_nHitPoint,
m_nManaPoint = @im_nManaPoint,
m_nFatiguePoint = @im_nFatiguePoint,
m_nFuel = @im_nFuel,
m_dwRideItemIdx = @im_dwRideItemIdx,
m_dwGold = @im_dwGold,
m_nJob = @im_nJob,
m_pActMover = @im_pActMover,
m_nStr = @im_nStr,
m_nSta = @im_nSta,
m_nDex = @im_nDex,
m_nInt = @im_nInt,
m_nLevel = @im_nLevel,
m_nMaximumLevel = CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
m_nExp1 = @im_nExp1,
m_nExp2 = @im_nExp2,
m_aJobSkill = @im_aJobSkill,
m_aLicenseSkill = @im_aLicenseSkill,
m_aJobLv = @im_aJobLv,
m_dwExpertLv = @im_dwExpertLv,
m_idMarkingWorld = @im_idMarkingWorld,
m_vMarkingPos_x = @im_vMarkingPos_x,
m_vMarkingPos_y = @im_vMarkingPos_y,
m_vMarkingPos_z = @im_vMarkingPos_z,
m_nRemainGP = @im_nRemainGP,
m_nRemainLP = @im_nRemainLP,
m_nFlightLv = @im_nFlightLv,
m_nFxp = @im_nFxp,
m_nTxp = @im_nTxp,
m_lpQuestCntArray = @im_lpQuestCntArray,
m_aCompleteQuest = @im_aCompleteQuest,
m_dwMode = @im_dwMode,
m_idparty = @im_idparty,
--m_nNumKill = @im_nNumKill,
m_idMuerderer = @im_idMuerderer,
--m_nSlaughter = @im_nSlaughter ,

m_nFame = @im_nFame,
m_nDeathExp = @im_nDeathExp,
m_nDeathLevel = @im_nDeathLevel,

m_dwFlyTime = m_dwFlyTime + @im_dwFlyTime,
m_nMessengerState = @im_nMessengerState,
TotalPlayTime = TotalPlayTime + @iTotalPlayTime,
m_tmAccFuel = @im_tmAccFuel,
m_dwSkillPoint = @im_dwSkillPoint,
m_dwReturnWorldID= @im_dwReturnWorldID,
m_vReturnPos_x = @im_vReturnPos_x,
m_vReturnPos_y = @im_vReturnPos_y,
m_vReturnPos_z = @im_vReturnPos_z
-------------- (ADD: Version7-SkillSystem)
, SkillPoint = @im_SkillPoint
, SkillLv = @im_SkillLv
, SkillExp = @im_SkillExp
-------------- (?? ??)
, dwEventFlag =@idwEventFlag,
dwEventTime =@idwEventTime,
dwEventElapsed =@idwEventElapsed
-------------- (?? ??)
----------?? ?? ----------
, PKValue = @im_nPKValue,
PKPropensity = @im_dwPKPropensity,
PKExp = @im_dwPKExp
----------?? ? ----------
----------?? ?? ----------
, AngelExp= @im_nAngelExp
, AngelLevel= @im_nAngelLevel
----------?? ? ----------
--------------------- Version9 Pet
, m_dwPetId = @im_dwPetId
, m_nExpLog = @im_nExpLog
, m_nAngelExpLog = @im_nAngelExpLog
---------- Ver.11 Coupon
, m_nCoupon = @im_nCoupon
---------- Ver.14
, m_nLayer = @im_nLayer --Housing
, m_nHonor = @im_nHonor --Master
---------- Ver 15
, m_aCheckedQuest = @im_aCheckedQuest
, m_nCampusPoint = @im_nCampusPoint
, idCampus = @im_idCampus
WHERE m_idPlayer = @im_idPlayer
AND serverindex = @iserverindex

-- if object_id('QUEST_TBL') is not null
06/04/2013 17:06 raventh1984#9
Did you even read what i was saying?

You must compare those values and your fields in CHARACTER_TBL.

Cause you have to many values and to little fields to put the values in.

For example

Lets say you have an query with 5 values
a,b,c,d,e
And you have an table with 3 fields
1,2,3

Then the query will fail cause its missing 2 fields to insert an value.

Its basic knowledge if you are working with databases.

And if you still dont get it here is an much simpler explination
If you have 5 candys and 3 mounts you will have 2 candys left that aint going no where.
So the values must correspondent with the fields.
06/05/2013 21:50 Ankis59#10
Raventh it's possible help me via skype or teamviewer ?
06/06/2013 11:31 raventh1984#11
#closeRequest

Solved with Teamviewer.

TS was using AIO database from sedrika and the source From GOH.

The GoH source has Jopsi glow changer in it and this was not added into CHARACTER_TBL.
06/05/2014 15:58 jeklordzxc#12
HOW YOU THEY SOLVE THE PROBLEM DUDE.,POST SOME ANSWER.,
07/27/2014 10:19 chadd12#13
guys i have problem in GOH files.. I add item, but when i Create it in game nothing happend..