Ace Server Files - Utimate Release

[PanKJ]

Oh, im not that good with guides :( You should look for a more experienced with mssql if you need one.

[Vortex13377]

Oh, im not that good with guides :( You should look for a more experienced with mssql if you need a guide.

ok so i found one of your guides here
http://forum.ragezone.com/f614/guide...logins-717947/

but it still not working, shows the same thing

[orangek3nny]

Take a look here for a complete guide:
http://forum.ragezone.com/f614/guide-ace-online-697147/

[PanKJ]

This guide i wrote assumes the only error you have is with logins and users. It was written for a particular case and its not comlete. I thought this is obvious.

[Compix]

Hi all :)
Well it seems like I'm too stupid to do this.
When I add the backup to my Database, I get all its Tabels, but NO Content. ( I think this is ok that way, cause its truncated. )
But how to fill the Tables now? I can't backup my old files now.
All Settings of the config-Files are correct and Now I just need to find out how to fix my Problem.

If someone could explane this to me, it would be very nice.

PS: I'm sorry for my bad English, just learning it :)

[orangek3nny]

Well, your English is far better than average :) Don't do that many capitals though :p

You can setup either an EP2 server or an EP3 server.
Look at this thread for the first one and at this for the second one. Both threads contain pretty complete databases for a basic server.

If you still want to add rows by yourself, you can just copy&paste them into the right tables.

[Compix]

Copy and Paste works?
Well I already setup an EP2 and one with EP3 Items :)
I will try ;)
Thank you :)

[PanKJ]

You need to import the xls files mate. Better download the spoonfeed edition if you dont know what to do. Or if you want ep3 download my db.

[Compix]

I already tried to import the xls-Files, but there is no File for the Maps.
I just have .xls-Files for Monsters, Item but no Maps.
But I think I've got how to get it work :)

[PanKJ]

For anyone wondering, just read the "Question about ep3 config files". Everything is explained, what you need to do to make these files work is to import them from a working ep2 db. Or just use the db ive upload, where all this work is done.

[lhgh20]

nice ,thanks to do so much.

[epion]

i cant download the Server Pack EP2 With all tools and setup guides

[tathannibal]

pls help me.
02-06 01:02:16|NPC Server Start

02-06 01:02:16|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 20] PoolCnt[ 7577] CommitSize[ 151552] vectorSize[1] Address Range(0x7FF80000 ~ 0x7FFA5000)
02-06 01:02:16|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1508] PoolCnt[ 1002] CommitSize[ 1511424] vectorSize[1] Address Range(0x7FE00000 ~ 0x7FF71000)
02-06 01:02:16|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1528] PoolCnt[ 101] CommitSize[ 155648] vectorSize[1] Address Range(0x7FDD0000 ~ 0x7FDF6000)
02-06 01:02:16|CVMem::AllocVMem VirtualAlloc() success, TypeSize[ 1552] PoolCnt[13000] CommitSize[20176896] vectorSize[1] Address Range(0x7B4C0000 ~ 0x7C7FE000)
02-06 01:02:17|[Error] WndProc(), Can't connect to FieldServer[ 127.0.0.1:15103] Reconnect
02-06 01:02:23|[Error] NPCServer IOCPInit Error

NPCServer not work the more server is running no problem.
Help me what is the my problem?

[maxxxeee]

OK now with the help of mkey the Server is working well but the HappyHour doesn't wanna work(it works only for one day...)
The Admin-Tool doesn't want to work too...

Couldsomeone upload a working HappyHour database?

[lhgh20]

OK now with the help of mkey the Server is working well but the HappyHour doesn't wanna work(it works only for one day...)
The Admin-Tool doesn't want to work too...

Couldsomeone upload a working HappyHour database?

DELETE [atum2_db_account].[dbo].[ti_HappyHourEvent]
 WHERE [UniqueNumber]>=0
 GO
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','13','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','9','9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','14','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','15','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','16','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','17','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','18','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','19','2011-01-24 23:00:00.000','2015-08-09 23:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')
INSERT INTO [atum2_db_account].[dbo].[ti_HappyHourEvent]
           ([ServerGroupID]
           ,[DayOfWeek]
           ,[StartTime]
           ,[EndTime]
           ,[EXPRate]
           ,[SPIRate]
           ,[EXPRepairRate]
           ,[DropItemRate]
           ,[DropRareItemRate]
           ,[WarPointRate]
           ,[InfluenceType]
           ,[MinLevel]
           ,[MaxLevel])
     VALUES('10061','20','2011-01-24 23:00:00.000','2015-08-09 12:59:00.000','99.9','99.9','0','99.9','99.9','0','255','1','100')

[maxxxeee]

i think i'm to dumb to insert what you've posted...

when i've instert the command then the happy event databbase looks like this:

http://www8.pic-upload.de/07.03.11/7efiozz47sym.png

But i'm not the best with databases...

Could someone send me some pictures which explains what to do?


~ Maxxxeee

[zeyden]

i think i'm to dumb to insert what you've posted...

when i've instert the command then the happy event databbase looks like this:

http://www8.pic-upload.de/07.03.11/7efiozz47sym.png

But i'm not the best with databases...

Could someone send me some pictures which explains what to do?


~ Maxxxeee

Look yust open your database write values on hand from up in your database compile new omi.tex run server and test client and your hh needs to work then enjoy XD

[ServerGroupID] look in config for number
[DayOfWeek] days from 1-7 day of week
[StartTime] when the hh will start
[EndTime] when hh will stop
[EXPRate]how many % of hh i think 0.1 = 10% i am not sure look in masang files that have explain this
[SPIRate] spi % drop and so on and so on
[EXPRepairRate]
[DropItemRate]
[DropRareItemRate]
[WarPointRate]
[InfluenceType]
[MinLevel] 1-100 aka max [110] set minimal lvl that player of same lvl or higher will have hh
[MaxLevel] 1-100 aka max [110] set maximal lvl that player of same lvl or lower will have hh

now try to write your own hh yust test the values for % because i am not sure and i am not on mine computer now that i can look at them have fun

[PanKJ]

Omi does not contain information about hh. And the values you should try are in lhgh20 post. Tho idk if itll work, nor have i tested it.

[fdswesley]

Database Download MEGAUPLOAD - The leading online storage and file delivery service

[Angel19891]

thx nice release but it dont go correctly with ep3

[maxxxeee]

@zeyden:it's not working (my database (made by myself):http://www8.pic-upload.de/20.03.11/ndyf1oaczxq5.png)

:(

Help!

[zeyden]

leave servergroupID on 0 and it needs to work and 1 = 100%
so set exp spi etc on lower rates

[maxxxeee]

@zeyden now it's working very good :D

some more questions:

1.How can i start an front base war? (that is starts on it's own and that i can start it)

2.how can i set some one as nation leader?

3.could someone send me pictures how to configurate the admin-tool?

~ Maxxxeee

[mKeey]

maxxxeee
Newbie

That say all! Learn C# and MS SQL!

A lot of fucking noobs make an ace online p server and do not know "How to setup an Ace Server"...

[zeyden]

@zeyden now it's working very good :D

some more questions:

1.How can i start an front base war? (that is starts on it's own and that i can start it)

2.how can i set some one as nation leader?

3.could someone send me pictures how to configurate the admin-tool?

~ Maxxxeee

1. for front base war set up add some entry in your database
2. u can do it whit commands in game or in database
3. look for GA_tool aka admin tool u need to hex edit it
u need to replace IP and port + database account
xoring username and pass whit this xor @34ns%<<fdsa(Tflsd!sndsa^#)fndsla$nvsa$fndsla&nfdsJak(fnldsa!#F

and IP whit this xor ~8xANs(^fP{)34$(fcbTN$(C-=x
its kinda simple first its go like this
PORT
IP
username
password

i hope that this will help u abit