Oh, im not that good with guides :( You should look for a more experienced with mssql if you need one.
Printable View
Oh, im not that good with guides :( You should look for a more experienced with mssql if you need one.
ok so i found one of your guides hereQuote:
Originally Posted by PanKJ
http://forum.ragezone.com/f614/guide...logins-717947/
but it still not working, shows the same thing
Take a look here for a complete guide:
http://forum.ragezone.com/f614/guide-ace-online-697147/
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.
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 :)
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.
Copy and Paste works?
Well I already setup an EP2 and one with EP3 Items :)
I will try ;)
Thank you :)
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.
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 :)
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.
nice ,thanks to do so much.
i cant download the Server Pack EP2 With all tools and setup guides
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?
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?
Quote:
Originally Posted by maxxxeee
Code: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')
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:tongue:Quote:
Originally Posted by maxxxeee
[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
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.
Database Download MEGAUPLOAD - The leading online storage and file delivery service
thx nice release but it dont go correctly with ep3
@zeyden:it's not working (my database (made by myself):http://www8.pic-upload.de/20.03.11/ndyf1oaczxq5.png)
:(
Help! :?::?::?:
leave servergroupID on 0 and it needs to work and 1 = 100%
so set exp spi etc on lower rates
@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
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"...
1. for front base war set up add some entry in your databaseQuote:
Originally Posted by maxxxeee
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 :tongue:
All xored data in the tools needs this xor key: ~8xANs(^fP{)34$(fcbTN$(C-=x.
@34ns%<<fdsa(Tflsd!sndsa^#)fndsla$nvsa$fndsla&nfdsJak(fnldsa!#F is to xor the uid and pwd for db in the global.cfg.
some one can help me?
reupload this files please.Code:SubaGames Database Truncated EP3 [December 2009]
Code:
fileserve.com
http://www.fileserve.com/file/Ghv7UvH
rapidshare.com
http://rapidshare.com/files/411073096/DB.7z.html
Password: }8sHk&)vI_n0c)1ppV
Can not download files from the new upload EP3
broken link not worck the file was deleted
FileServe can only be used to download and retrieve files that you have uploaded personally.
SubaGames Database Truncated EP3 [December 2009]
Code:
fileserve.com
http://www.fileserve.com/file/Ghv7UvH
rapidshare.com
http://rapidshare.com/files/411073096/DB.7z.html
Password: }8sHk&)vI_n0c)1ppV
Quote:
Originally Posted by gaby001
NOt Working...
yeah not working :S
Links are down.
Could you please re-upload the server and db files (or send me a PM and I'll give you an FTP account to put them there)?
Manny thanks!
Forget about it. He will not lose his time by doing that...Again.
I know you do have a working one WARonline. I have also posted on your release thread regarding some issues. Would it be possible to help me there?
Thank you!
There where? o.O.. PM me with your issues. When I will have time I will send to you the answers.