Re: [Tutorial] Local/Online setup
Currently things that don't work:
- Add Friend
- PVP Arena
- Invite Player to Party/Quest from Boat
Are you sure those not work because of LAN or WAN set up? But locally worked? Then somethings really wrong with the IP's on the config files. If not work between server files and client missed matches somehow then we should find the most closes client that really goes with this TW server files . Why I said all these? Because if you read Release- Vindictus section. They were trying to find the most suitable clients for this server. It's a recent server files from TW too. How could it didn't work with those features?
Good guide tho :-)
@WAMVN, we can't make a VMware from this server files. It uses MSSQL for its database. We can do an 1-click server set-up like this one herehttp://forum.ragezone.com/f478/developement-click-server-setup-989712/
You can ask that mods for help with the scripts of setting up :-) GL tho.
But set up Vindictus servers are too easy :-) I did it about 30 mins+
Re: [Tutorial] Local/Online setup
Im getting closer
Now my girlfriend see the Server name at the login screen, though still not able to connect
All i did is to change from wamp to appserv
firewall allowed for new APache Server
Re: [Tutorial] Local/Online setup
Thank you so much for guide mate, i love you so much :) i'am already open my own server with your help.. If someone can try to login i'am sharing my server See you soon in game ^^
oh i am getting some errors when i click to start game. I have succesfully created a character.
PlayerService Log:
Code:
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 > [/ERROR]
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][PlayerEntity] - Exception on entity closed event(Character.LogoutCharacter) : System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Cid".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
07-08 21:12:20 > at System.Data.SqlClient.SqlDataReader.get_MetaData()
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.BonusEffectDBDataContext.GetBonusEffect(Nullable`1 cID)
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.VIPBonus.SetVIPEffect()
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.VIPBonus.GetRemainTimeSec()
07-08 21:12:20 > at PlayerService.CharacterServiceCore.CharacterEntity.LogoutCharacter()
07-08 21:12:20 > at PlayerService.PlayerEntity.OnEntityClosed(Object sender, EventArgs e)
07-08 21:12:20 > ClientConnectionId:f8b83a36-80c5-491c-930d-5647482c9c48
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
Re: [Tutorial] Local/Online setup
I can not enter the village
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
DuB1986
Im getting closer
Now my girlfriend see the Server name at the login screen, though still not able to connect
All i did is to change from wamp to appserv
firewall allowed for new APache Server
Have you try to connect with LAN's IPs to the server? If you guys are using LAN all together and the PC or laptop that hosting using WAN's IP. This worked for all MMORPG games that I hosted before.
Re: [Tutorial] Local/Online setup
it seems to work now, executer.exe has to be allowed through firewall too
Re: [Tutorial] Local/Online setup
Someone can help me i post my problem 1 hour ago... Anyway i am using MSSQL Server 2008 R2
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
john007
Currently things that don't work:
- Add Friend
- PVP Arena
- Invite Player to Party/Quest from Boat
Are you sure those not work because of LAN or WAN set up? But locally worked? Then somethings really wrong with the IP's on the config files. If not work between server files and client missed matches somehow then we should find the most closes client that really goes with this TW server files . Why I said all these? Because if you read Release- Vindictus section. They were trying to find the most suitable clients for this server. It's a recent server files from TW too. How could it didn't work with those features?
Good guide tho :-)
@
WAMVN, we can't make a VMware from this server files. It uses MSSQL for its database. We can do an 1-click server set-up like this one herehttp://forum.ragezone.com/f478/developement-click-server-setup-989712/
You can ask that mods for help with the scripts of setting up :-) GL tho.
But set up Vindictus servers are too easy :-) I did it about 30 mins+
PVP Arena works according to SanGawku's screenshot you just have to set it up apparently im pretty sure those things that currently do not work is related to the configuration files i don't believe it has to do with anything related to my setup with lan/wan ip.
Quote:
Originally Posted by
DuB1986
it seems to work now, executer.exe has to be allowed through firewall too
yeah you need to allow all the server programs through firewall.
Quote:
Originally Posted by
s1010234
I can not enter the village
I need more information if i'm going to help you, on the previous post you mentioned something about CRConfig.xml? I believe it might be your configuration files take a look over it and make sure you entered everything correctly there are lan ip's that are hard to spot.
Quote:
Originally Posted by
djbadboys38
Thank you so much for guide mate, i love you so much :) i'am already open my own server with your help.. If someone can try to login i'am sharing my server ip: 37.75.9.252 See you soon in game ^^
oh i am getting some errors when i click to start game. I have succesfully created a character.
PlayerService Log:
Code:
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 > [/ERROR]
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][ItemOwner] - Error while Saving Logs.[JournalID 4427321]System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > Must declare the scalar variable "@CharacteriD".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.ItemServiceCore.LogDataContext.AddItemLedger(Nullable`1 journalID, Nullable`1 itemID, String itemClass, Nullable`1 characterID, Nullable`1 event, Nullable`1 num, Nullable`1 color1, Nullable`1 color2, Nullable`1 color3, Nullable`1 reducedDurability, Nullable`1 maxDurabilityBonus, Nullable`1 actionCategory, Nullable`1 bundleItemCount)
07-08 21:12:20 > at PlayerService.ItemServiceCore.ItemLog.AddItemLedger(Int64 journalID, Int64 cid, ItemLogType eventType, ActionType action, LogData data)
07-08 21:12:20 > ClientConnectionId:c00fb5ac-f2a3-4b9b-a250-e17505afdc38
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
07-08 21:12:20 > [PlayerService.PlayerService][PlayerService.PlayerService (1172)][PlayerEntity] - Exception on entity closed event(Character.LogoutCharacter) : System.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Cid".
07-08 21:12:20 > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
07-08 21:12:20 > at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
07-08 21:12:20 > at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
07-08 21:12:20 > at System.Data.SqlClient.SqlDataReader.get_MetaData()
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
07-08 21:12:20 > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)
07-08 21:12:20 > at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.BonusEffectDBDataContext.GetBonusEffect(Nullable`1 cID)
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.VIPBonus.SetVIPEffect()
07-08 21:12:20 > at PlayerService.CharacterServiceCore.BonusEffect.VIPBonus.GetRemainTimeSec()
07-08 21:12:20 > at PlayerService.CharacterServiceCore.CharacterEntity.LogoutCharacter()
07-08 21:12:20 > at PlayerService.PlayerEntity.OnEntityClosed(Object sender, EventArgs e)
07-08 21:12:20 > ClientConnectionId:f8b83a36-80c5-491c-930d-5647482c9c48
07-08 21:12:20 > Error Number:137,State:2,Class:15
07-08 21:12:20 >
Quickly skimming through the error message i notice that the error is for an item? did you by any chance played around with the items command and get a bugged item of some sort? could you expand on exactly what is going on like what kind of error you are getting where where and how?
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
Aznkidd235
PVP Arena works according to SanGawku's screenshot you just have to set it up apparently im pretty sure those things that currently do not work is related to the configuration files i don't believe it has to do with anything related to my setup with lan/wan ip.
yeah you need to allow all the server programs through firewall.
I need more information if i'm going to help you, on the previous post you mentioned something about CRConfig.xml? I believe it might be your configuration files take a look over it and make sure you entered everything correctly there are lan ip's that are hard to spot.
Quickly skimming through the error message i notice that the error is for an item? did you by any chance played around with the items command and get a bugged item of some sort? could you expand on exactly what is going on like what kind of error you are getting where where and how?
Thank you for reply i have expand error and i post a 2 error ss at here http://forum.ragezone.com/f946/help-...screen-1107906 i can login to game on my local pc ..... i cannot login to my vps server with same configs...
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
djbadboys38
So you were able to login & create a character, but then you get this error message is that right? If that is the case it sounds like maybe you missed an ip somewhere under Player Service i will take a look into once i get home.
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
Aznkidd235
So you were able to login & create a character, but then you get this error message is that right? If that is the case it sounds like maybe you missed an ip somewhere under Player Service i will take a look into once i get home.
Yes i can login and create a character there is no problem... I think required some configuration on mssql server...
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
djbadboys38
Someone can help me i post my problem 1 hour ago... Anyway i am using MSSQL Server 2008 R2
use 2012 express,it's free and lite weight can be downloaded from microsoft site
Re: [Tutorial] Local/Online setup
server/RCClient/RCConfig.xml
I dont know but the lan/wan ip in this file always change to 127.0.0.1 everytime i run the server.
Re: [Tutorial] Local/Online setup
Quote:
Originally Posted by
cloudslsw
use 2012 express,it's free and lite weight can be downloaded from microsoft site
not fixed i am already using same problem still running ^^
Re: [Tutorial] Local/Online setup
WAN seems to connect properly, I have issue how it doens't get the server. I'm using xampp and as the game is running on my pc it grabs the server connection data for me (name, ip)
http://puu.sh/pVFTW/650b91ac73.jpg
The server list for others isnt empty, it's as on the image 'live' I don't know what server that is
because it's not the name of the server I have. And yeah on local this all works.
When my friend is trying to connect the client doesn't seem to grab the EndPoint.txt from my xampp, yet when they try enter my ip on internet it shows xampp page so it seems the connection isn't blocked. I've been trying to fix this now 2 days can someone help me? I'm trying to go WAN and did everything as this guide said and replaced all LANIP to my WAN IP.
Directly the issue:
When someone else tried to load the client except me the client doesn't get the server ip and says Server Under Maintenance aka offline.
I have followed this guide and replaced everything in here on my WAN ip and EndPoint.txt aswell. Can someone help me?
- I got ports 0-65535 open all
-Firewall is off & internet firewall is off
-My public ip is on hosts file
Please help, very desperate & upset with this...
