DK ACE V21 Testing Files

[EvilDead3]

Originally Posted by - DK ACE

Ich habe mir das angeschaut und ich vermute das an der Item Eintragung liegt. Wenn ich es wie im Screen über Wiki mache, geht es reibungslos:

Ich schaue mir trotzdem das /ce an. Das Update wird sich im übrigen verschieben ^^

P.S: Über Wiki muss du Shift + Linksglick drücken.

Über Wiki geht es bei mir auch

[- DK]

Originally Posted by EvilDead3

Über Wiki geht es bei mir auch

Gut Ich schaue mir das andere noch an.


At sunday 10.17. i will upload my next version of this files. Thanks for everyone they test this files

[EvilDead3]

Wann gibts das Update �� bin mega gespannt ! Hab aus deinen Files mir was zusammengestellt ��

[LookAtTheFlower]

Originally Posted by - DK ACE

Gut Ich schaue mir das andere noch an.


At sunday 10.17. i will upload my next version of this files. Thanks for everyone they test this files

Can't wait! .

[- DK]

Originally Posted by EvilDead3

Wann gibts das Update �� bin mega gespannt ! Hab aus deinen Files mir was zusammengestellt ��

Originally Posted by LookAtTheFlower

Can't wait! .

Patch 1.0.2:

- Added Capslock Text to Login:
If you start the client and your capslock is activated you will show a text.
- Added Teleport with Drop Information.
- Reworked Item Wiki
- Added Glow Change (Alpha Version 1.0.0 based on Jops Glow)
- Add a AIO Database Beta Version
- Added a new folder for Hotkeychange and Petfilterlist
- Remove Hotkeychange temporary.
- Fix some Bugs.
- I added some Shops.
- Added Hide Coat
- Inventory Trans key is back


Download:


P.S: I am sorry for removing Hotkey Change, i add all system in Menu System. I will fix this system early.

[LookAtTheFlower]

Originally Posted by - DK ACE

Patch 1.0.2:

- Added Capslock Text to Login:
If you start the client and your capslock is activated you will show a text.
- Added Teleport with Drop Information.
- Reworked Item Wiki
- Added Glow Change (Alpha Version 1.0.0)
- Add a AIO Database Beta Version
- Added a new folder for Hotkeychange and Petfilterlist
- Remove Hotkeychange temporary.
- Fix some Bugs

Download:
Coming Soon!

Thanks /sro command on fashion parts fixed too?
There is hide coat?

[- DK]

Originally Posted by LookAtTheFlower

Thanks /sro command on fashion parts fixed too?
There is hide coat?

Yes its fixed.
Yes Hide Coat added.
Sorry i forgot to post some things. I am so busy the last month and the follow months.

[LookAtTheFlower]

Originally Posted by - DK ACE

Yes its fixed.
Yes Hide Coat added.
Sorry i forgot to post some things. I am so busy the last month and the follow months.

There is anything different i should do to set up the database? Because "DatabaseServer.exe" not opening.

[- DK]

Originally Posted by LookAtTheFlower

There is anything different i should do to set up the database? Because "DatabaseServer.exe" not opening.

No.. Nothing.. I think its a resource error on your side

[LookAtTheFlower]

Originally Posted by - DK ACE

No.. Nothing.. I think its a resource error on your side

I think this is the problem.

 Spoiler

Step 1: Clearing backup history
Step 2: Dropping logins if exists
Step 3: Deleting if databases if exists
Step 4: Create [CHARACTER_01_DBF
Step 5: Create [ACCOUNT_DBF
Step 6: Create [RANKING_DBF]
Step 7: Create [LOGGING_01_DBF]
Step 8: Create logins
Msg 15025, Level 16, State 1, Line 257
The server principal 'account' already exists.
Msg 15025, Level 16, State 1, Line 261
The server principal 'eocrm' already exists.
Msg 15025, Level 16, State 1, Line 265
The server principal 'log01' already exists.
Msg 15025, Level 16, State 1, Line 269
The server principal 'character01' already exists.
Step 9: Create users
Step 10: Create connection servers
Step 11: Configure [ACCOUNT_DBF]
OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "CHR01" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 2, Level 16, State 1, Line 767
Named Pipes Provider: Could not open a connection to SQL Server [2].
Step 12: Configure [CHARACTER_01_DBF]

(1 row(s) affected)

(1 row(s) affected)
OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "RANKING" returned message "A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
Msg 2, Level 16, State 1, Line 7377
Named Pipes Provider: Could not open a connection to SQL Server [2].
Msg 208, Level 16, State 6, Procedure CHARACTER_STR, Line 9593
Invalid object name 'dbo.CHARACTER_STR'.
Step 13: Configure [LOGGING_01_DBF]
Step 14: Configure [RANKING_DBF]
Msg 208, Level 16, State 1, Procedure view_last_3_month, Line 18756
Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'.
Msg 208, Level 16, State 1, Procedure view_last_1_month, Line 18775
Invalid object name 'LOGGING_01_DBF.dbo.VIEW_LOG_LOGIN_TBL'.
Step 15: Installation Systems
Msg 154, Level 15, State 1, Procedure uspVendorNpcGet, Line 18955
a USE database statement is not allowed in a procedure, function or trigger.
Msg 154, Level 15, State 1, Procedure uspVendorNpcUpdate, Line 19159
a USE database statement is not allowed in a procedure, function or trigger.
Msg 154, Level 15, State 1, Procedure ConsignmentInsertItem, Line 19222
a USE database statement is not allowed in a procedure, function or trigger.
Msg 5133, Level 16, State 1, Line 19296
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\DATA\BACKEND_DBF.m df" failed with the operating system error 3(‏‏למערכת אין אפשרות לאתר את הנתיב שצוין.).
Msg 1802, Level 16, State 1, Line 19296
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5011, Level 14, State 5, Line 19310
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19310
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19313
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19313
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19316
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19316
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19319
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19319
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19322
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19322
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19325
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19325
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19328
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19328
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19331
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19331
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19334
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19334
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19337
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19337
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19340
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19340
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19343
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19343
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19346
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19346
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19349
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19349
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19352
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19352
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19355
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19355
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19358
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19358
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19361
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19361
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19364
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19364
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19367
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19367
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19370
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19370
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19373
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19373
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19376
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19376
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19379
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19379
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19382
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19382
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19385
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19385
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19388
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19388
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19391
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19391
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 19394
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19394
ALTER DATABASE statement failed.
Msg 102, Level 15, State 29, Line 19397
Incorrect syntax near 'QUERY_STORE'.
Msg 5011, Level 14, State 5, Line 19400
User does not have permission to alter database 'BACKEND_DBF', the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 19400
ALTER DATABASE statement failed.
Msg 1801, Level 16, State 3, Line 19472
Database 'WEBSITE_DBF' already exists. Choose a different database name.
Msg 102, Level 15, State 29, Line 19573
Incorrect syntax near 'QUERY_STORE'.
Msg 2714, Level 16, State 6, Line 19690
There is already an object named 'LOG_SENDITEM' in the database.
Step 16: Installation AiO Database SQL 2017 complete
******************************************
* Thanks for using AiO Database SQL 2014 *
* by Ace *
******************************************

Any chance to upload the database as DBF file like the previous version?

[- DK]

Originally Posted by LookAtTheFlower

I think this is the problem.

 Spoiler

Any chance to upload the database as DBF file like the previous version?

Check first post. i add BAK of Character_DBF

I forget some patches lol

- I add biger Backpack

[LookAtTheFlower]

Originally Posted by - DK ACE

Check first post. i add BAK of Character_DBF

I forget some patches lol

- I add biger Backpack

Yeah i saw it , But i am not able to restore this DBF.
Your files are not running on SQL 2014 anymore?

[- DK]

Originally Posted by LookAtTheFlower

Yeah i saw it , But i am not able to restore this DBF.
Your files are not running on SQL 2014 anymore?

i use 2017 oh **** .. sorry i need to edit this.

['P!nkBeatzz']

I have this error. after channel selection:
2019/11/22 12:38:52
C:\Users\Armag\Desktop\Server\Source\_database\DbM anager.cpp, 487 CHARACTER_STR 'S2',@im_idPlayer='0000000' @rindex='01',@iaccount='duscansi',@im_szName='6600b d04fa9c1e14d0fd3bd835f41e8c' @slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.00 0000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_s zCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairM esh=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_nFa tiguePoint=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_aLicenseSkil l='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@i m_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,@i m_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_nDea thLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0 @alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @Piercing ='(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,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'

Ich kann auch die Wiederherstellung von CHARACTER_01 nicht machen weil sie eine höhere Version hat als mein sql server obwohl ich das 17er verwende

[- DK]

Originally Posted by 'P!nkBeatzz'

I have this error. after channel selection:
2019/11/22 12:38:52
C:\Users\Armag\Desktop\Server\Source\_database\DbM anager.cpp, 487 CHARACTER_STR 'S2',@im_idPlayer='0000000' @rindex='01',@iaccount='duscansi',@im_szName='6600b d04fa9c1e14d0fd3bd835f41e8c' @slot=0,@idwWorldID=0,@im_dwIndex=0,@im_vPos_x=0.00 0000,@im_vPos_y=0.000000,@im_vPos_z=0.000000,@im_s zCharacterKey='(null)',@im_dwSkinSet=0,@im_dwHairM esh=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_nFa tiguePoint=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_aLicenseSkil l='(null)',@im_aJobLv='(null)',@im_dwExpertLv=0,@i m_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,@i m_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_nDea thLevel=0,@im_dwFlyTime=0,@im_nMessengerState=0 @alPlayTime=0,@im_Card='(null)',@im_Index_Card='(nu ll)',@im_ObjIndex_Card='(null)',@im_Cube='(null)', @im_Index_Cube='(null)',@im_ObjIndex_Cube='(null)' ,@im_Inventory='(null)',@im_apIndex='(null)',@im_a dwEquipment='(null)',@im_dwObjIndex='(null)',@im_a SlotApplet='(null)',@im_aSlotItem='(null)',@im_aSl otQueue='(null)',@im_SkillBar=0 @='(null)',@im_apIndex_Bank='(null)',@im_dwObjIndex _Bank='(null)',@im_dwGoldBank=0,@im_nFuel=0,@im_tm AccFuel=0,@im_dwSMTime='(null)' @Influence='(null)',@im_aCompleteQuest='(null)',@im _extInventory='(null)',@im_InventoryPiercing='(nul l)',@im_extBank='(null)' @Piercing ='(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,@iszIn ventoryPet='(null)',@iszBankPet='(null)', @im_dwPetId=0,@im_nExpLog=0, @im_nAngelExpLog=0,@im_nCoupon=0,@im_nHonor=-1,@im_nLayer=0,@im_nCampusPoint=0,@im_idCampus=0,@ im_aCheckedQuest='(null)'

Hast du die BAK genutzt oder die AIO ? Ich sollte mal den Download später neu machen