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:
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
Well I will admit you did do what I asked and what other epvpers members asked so... I suppose I owe you a thanks for that
smoke got a question well i changed my gameserver.opt accordingly i belive and still cant get it to connect now here is the question does the 7.3 GS not call on the gameserver.eop cuz it seems to me like its not reading it at all cuz i cant get it to connect to the database to even try starting up idk this is just me tho
Your databases must be local, you must have the names set as Arcadia and Telecaster and you must have their owners set as 'SA' and sa must NOT have a password. As I said in the original post the CaptainHerlock does not read from the gameserver.eop so any changes in that regard must be hex'd in for the moment.
2012-03-12 22:44:22 Starting IOCP thread pool... ok
2012-03-12 22:44:22 LUA initialize... ok
2012-03-12 22:44:23 Launching ARCADIA... ok
2012-03-12 22:44:23 Start loading...
2012-03-12 22:44:23 Loading max Item index... (1) ok
2012-03-12 22:44:23 Loading Complete.
2012-03-12 22:44:23 Total 106738 String loaded...
2012-03-12 22:44:23 Total 119 String(local) info loaded...
2012-03-12 22:44:23 Total 0 Monster skill/trigger info loaded...
2012-03-12 22:44:23 Total 0 Monster item drop info loaded...
2012-03-12 22:44:24 Total 0 Event Area info loaded...
2012-03-12 22:44:24 Total 0 ItemEffect loaded...
2012-03-12 22:44:24 Total 38/38 AuctionCategoryResource loaded.
2012-03-12 22:45:01 Total 6640 Monster info loaded...
2012-03-12 22:45:01 Total 138 Summon info loaded...
2012-03-12 22:45:01 Total 87 Summon Level Bonus info loaded...
2012-03-12 22:45:01 Total 4265 DropGroup info loaded...
2012-03-12 22:45:01 Total 0 DropGroup(local) info loaded...
2012-03-12 22:45:01 Total 119 Summon Default Name loaded...
2012-03-12 22:45:01 Total 0 Summon Unique Name loaded...
crash sorunu varsa işletim sistemini değiştir.
sql server 2008 ve 2012 artık windows 2008 sistemini desteklemiyor
windows xp kur sorun kalmaz
çözüm aramak içinde oyunu dondurmaz.
girişlerdede hesap şuan oyunda gibisinden hata vermz,
en sağlam işletim sistemi xp
The installation did not say type a password, and now ask the name + password, what type?
this SQL Server 2012 RC0
computername\SQLSERVER or SQLEXPRESS
Quote:
Originally Posted by OyunPozitifRappelz
crash sorunu varsa işletim sistemini değiştir.
sql server 2008 ve 2012 artık windows 2008 sistemini desteklemiyor
windows xp kur sorun kalmaz
çözüm aramak içinde oyunu dondurmaz.
girişlerdede hesap şuan oyunda gibisinden hata vermz,
en sağlam işletim sistemi xp
Komik misin arkadaşım , sql server sistemidir , nerede görülmüş 2003 ve 2008 desteğinin olmadığı ?
Hem benim o kodları yazma amacım nedir ? konu nedir onu anlamamışsın daha gelip burda windows xp kur diyorsun güleyim mi ağlayayım mı..
We have tested and think that everything up to SummonUniqueNameResource is loading and we believe it is loading correctly as-well. Our next logical task is to figure out what is supposed to be loaded next and why it is failing to load it, if you have an idea or thought on the matter please feel free to share your thoughts or information. As more information becomes available to my staff and the crews I work with I will be posting it here.
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.