ok, i have taken a look into the lin2db.sql and i cant find the command create lin_GetUserDataByCharId ...so i think its simply missing..
can some1 send me working sql files?
edit: i saw its in lin2world.sql, but i cant get it running anyway :(
edit: here is a error message from lin2world.sql (translated with google :) )
Message 207, level 16, status 1, procedure dp_adena_rank, line 5305
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByAccount, line 5320
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByPledge, line 5331
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure dp_GetItemListByUserID, line 5342
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure give_lotto_price, line 5408
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AdenaChange, line 5907
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AdenaChange, line 5918
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AmountChange, line 5992
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_AmountChange, line 5994
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_BetaAddItem, line 6114
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CopyChar, line 7169
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CopyChar, line 7168
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_CreateItem, line 7848
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DepositBank, line 9432
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DepositBank, line 9435
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DropItem, line 9597
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_DropItem, line 9604
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure Lin_EnchantItem, line 9723
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItem, line 10802
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItem, line 10816
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetItemType, line 10906
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetPledgeAdena, line 11573
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12108
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12109
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12110
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12111
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12112
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12113
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12114
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12115
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12116
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12117
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12118
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12119
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12120
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12121
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_GetWearingItemList, line 12122
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadItemByItemId, line 13075
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadItems, line 13120
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_LoadPetItems, line 13474
Invalid column name 'amount'.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPJoinSSQMember'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSSQSealSelection'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapSSQData'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapSSQJoinData'. The module is still created. However, it can only be executed successfully if the object exists.
The module 'lin_MakeDailyWorldSnap' depends on the missing object 'lin2report.dbo.lin_RPSnapTimeAttackRecord'. The module is still created. However, it can only be executed successfully if the object exists.
Message 207, level 16, state 1, procedure LIN_MakeNewBlankItem, line 14005
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewAll, line 18693
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewAll, line 18717
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18768
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18787
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18789
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_TrasferWarehouseNewPartial, line 18801
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_UpdateUserItem, line 19512
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure lin_UpdateWarehouseItem, line 19567
Invalid column name 'amount'.
Message 207, level 16, state 1, procedure STAT_ITEM_ACC, line 19928
Invalid column name 'AMOUNT'.