[DEVELOPMENT] 7.3 Gameserver + Current Databases + Debug Info
THIS SERVER IS NOT CURRENTLY OPERATIONAL AND IS IN DEVELOPMENT!!!!
Against my better judgement, I am here to provide you the current work being done at Redemption / xSanadu and other Development Crews as a unified force. The work is going smooth, but we still must sniff out changes that the new Game Server expects to be present in the databases.
First we'll start off with the important information:
exec [Telecaster]..sp_procedure_params_rowset N'on_server_startup',1,NULL,NULL
go
declare @p1 int
set @p1=NULL
exec on_server_startup @p1 output
select @p1
go
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Item with (nolock) where sid < 0x3FFFFFFFFFFFFFFF'
select @p1
go
exec sp_unprepare 1
go
declare @p1 int
set @p1=2
exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Skill with (nolock) where sid < 0x3FFFFFFF'
select @p1
go
exec sp_unprepare 2
go
declare @p1 int
set @p1=3
exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Summon with (nolock)'
select @p1
go
exec sp_unprepare 3
go
declare @p1 int
set @p1=4
exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Pet with (nolock)'
select @p1
go
exec sp_unprepare 4
go
declare @p1 int
set @p1=5
exec sp_prepexec @p1 output,NULL,N'select MAX(sid) as max_id from Farm with (nolock)'
select @p1
go
exec sp_unprepare 5
go
declare @p1 int
set @p1=6
exec sp_prepexec @p1 output,NULL,N'UPDATE Character SET name = ''@'' + name WHERE delete_time <= GETDATE() and name not like ''@%'''
select @p1
go
select * from StringResource
go
select * from StringLocalResource
go
exec sp_reset_connection
go
select * from EventAreaResource
go
SELECT * FROM dbo.MonsterSkillResource ORDER BY id, sub_id
go
SELECT * FROM dbo.ItemEffectResource ORDER BY id, ordinal_id
go
SELECT * FROM dbo.MonsterDropTableResource ORDER BY id, sub_id
go
SELECT * FROM AuctionCategoryResource ORDER BY category_id, sub_category_id
go
select * from SetItemEffectResource
go
select * from MonsterResource
go
exec sp_reset_connection
go
select * from SummonResource
go
exec sp_reset_connection
go
select * from CreatureLevelBonus
go
exec sp_reset_connection
go
select * from DropGroupResource
go
select * from DropGroupLocalResource
go
exec sp_reset_connection
go
select * from SummonDefaultNameResource
go
select * from SummonUniqueNameResource
go
Game Server Startup Log:
This is as far as we've got the Game Server to load at this point:
*Any Load with a 1 or a 0 during load was a table reconfigured or added in by us.
2012-03-11 09:28:19 Network initialize... ok
2012-03-11 09:28:19 IOCP initialize... ok
2012-03-11 09:28:19 Starting IOCP thread pool... ok
2012-03-11 09:28:19 LUA initialize... ok
2012-03-11 09:28:19 Launching ARCADIA... ok
2012-03-11 09:28:19 Start loading...
2012-03-11 09:28:19 Loading max Item index... (1) ok [B]<-- ALREADY WORKED[/B]
2012-03-11 09:28:19 Loading Complete.
2012-03-11 09:28:20 Total 106738 String loaded...
2012-03-11 09:28:20 Total 119 String(local) info loaded...
2012-03-11 09:28:20 Total 38/38 AuctionCategoryResource loaded.
2012-03-11 09:28:20 Total 0 ItemEffect loaded... [B]<-- ADDED[/B]
2012-03-11 09:28:20 Total 0 Monster skill/trigger info loaded... [B]<-- ADDED[/B]
2012-03-11 09:28:20 Total 0 Event Area info loaded... [B]<-- ADDED[/B]
2012-03-11 09:28:20 Total 0 Monster item drop info loaded... [B]<-- ADDED[/B]
2012-03-11 09:28:25 Total 6640 Monster info loaded...
2012-03-11 09:28:25 Total 138 Summon info loaded...
2012-03-11 09:28:25 Total 87 Summon Level Bonus info loaded...
2012-03-11 09:28:25 Total 4265 DropGroup info loaded...
2012-03-11 09:28:25 Total 0 DropGroup(local) info loaded... [B]<-- ADDED[/B]
2012-03-11 09:28:25 Total 119 Summon Default Name loaded...
2012-03-11 09:28:25 Total 1 Summon Unique Name loaded... [B]<-- This one already worked[/B]
You can get the current databases from: Information Being Updated
You can get the gameserver from:
!!! WARNING !!!
This game server DOES NOT load from gameserver.eop (Any changes to connection info MUST BE HEX'D) The above gameserver is set to use 127.0.0.1 for all connections to the databases, it uses Arcadia and Telecaster as names and an SA with no password for the login.
-Disclaimer:
You all should know better than I, this is one of our last chances to become a community again, so lets keep the trolling, flaming out and the busting our asses in. Only a community makes marvelous things, individuals make great things. Which one do you want, Marvelous or Great?
-MENTION:
I have done all of the work on the databases with Microsoft SQL Server 2012 RC0, there is known issues when trying to restore database backup from 2012 with Microsoft SQL Server 2008 R2. I can only suggest that you use the Microsoft SQL Server 2012 RC0 available from Microsoft
1st is ban too made by Xijezu
2nd isnt working,it can't be download
3rd it is Arabic CaptainHerlockServer
1st = Corrected, thanks for letting me know. I used the wrong rar name :P
2nd = I just made sure it can download mate ^_^ It had a missing number in url
3rd = I can promise it's the real deal.
It's only natural that it is 64bit, considering as technology moves forward the 64bit architectural is MUCH better suited to tasks like running a game-server. (Multi-threaded processing ftw mate)
The database is not corrupted, it doesn't work yet. Which was said rather clearly on the first page. This is for Development, we are trying to REBUILD our current databases. If you aren't up to that task like I said in another thread, this thread will do you NO GOOD.
Hmn I thought I put up the one with the connection info already hex'd. Hmn, let me change the download to a CaptainHerlock.exe with pre-hex'd database connection info.
Forum.Zap-Hosting.com - kostenlose Gameserver - Das Gameserver-Communityboard 08/28/2011 - Counter-Strike - 11 Replies Forum.Zap-Hosting.com - Das Gameserver - Communityboard
http://zap-hosting.com/images/zapcommunity.png
Zum Board
Kostenlose Voice- und Gameserver! Wir sehen uns als das erste und einzige deutsche Forum in welchem die Communitymitglieder für das aktive Schreiben mit Voice- und Gameservern belohnt werden. Erarbeite dir deine ZAPs, werde reich und miete mit deinem Clan kostenlos einen Server.
Werde Admin von erfolgreichen oder geplanten Publicserverprojekten.
[Info] alaplaya's current server status 06/14/2010 - S4 League - 0 Replies http://s4.alaplaya.net/en/index.html
Please do not ask, comlain or create spam threads with this topic!
The servers will be back soon, just wait till then. It'll probably happen the 16th june.
Bitte erstellt keine Spamthreads, fragt oder beschwert euch über dieses Thema!
Die Server werden bald wieder verfügbar sein, bitte wartet einfach. Vermutlich wird dies am 16. Juni sein.
[Info] alaplaya's current server status 06/14/2010 - S4 League Hacks, Bots, Cheats & Exploits - 0 Replies http://s4.alaplaya.net/en/index.html
Please do not ask, comlain or create spam threads with this topic!
The servers will be back soon, just wait till then. It'll probably happen the 16th june.
Bitte erstellt keine Spamthreads, fragt oder beschwert euch über dieses Thema!
Die Server werden bald wieder verfügbar sein, bitte wartet einfach. Vermutlich wird dies am 16. Juni sein.
![[DEVELOPMENT] 7.3 Gameserver + Current Databases + Debug Info](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/development-7-3-gameserver-current-databases-debug-info_ltr.gif){kind=small}
