Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 15:40

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #5311
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,004
Received Thanks: 958
Quote:
Originally Posted by Space() View Post
- Can we change the ports in the ".opt" file ?
Yes

Quote:
Originally Posted by Space() View Post
- What ports to open for the firewall ? (inbound/outbound)
All of them except 1433 or whatever you set as database port.

You should read the guide on server security linked in the tools thread if you are opening the database port for remote management.



ThunderNikk is offline  
Thanks
1 User
Old   #5312
 
elite*gold: 0
Join Date: Nov 2015
Posts: 18
Received Thanks: 1
Quote:
Originally Posted by thndr View Post
Yes



All of them except 1433 or whatever you set as database port.

You should read the guide on server security linked in the tools thread if you are opening the database port for remote management.
Thank man but (inbound/outbound) ?


Space() is offline  
Old   #5313
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,004
Received Thanks: 958
Well actually anything that is just gameserver to auth shouldn't need to go through firewall just client to auth and client to gameserver and yes you will need inbound and outbound rules for both as traffic will be bidirectional.

auth.clients.port:
upload.clients.port:
upload.gameserver.port:
S io.port:

Should all be opened although I am not positive if you need the upload.gameserver.port: in firewall rules or not.

auth.gameserver.port:

This one and the database port can be left out of the firewall rules if both auth and gameserver are going to be run on the same server and you will not be doing remote management.
ThunderNikk is offline  
Thanks
1 User
Old   #5314

 
elite*gold: 140
Join Date: Mar 2012
Posts: 613
Received Thanks: 140
Ok so i added new wings to my server,this are steps i done

Made sql query and execute it in sql.
Made new resources for rdb.itemresources and rdb.stringresources
I hash my nx3,dds and icon file.
i added icons to 02_item.spr,then hash 02.item.spr

then i took all hashed files and place in my rappelz resource folder.

Here is my query

Once i log in,i try to spawn this wings,I can see them for 2-3 seccond and they get removed.


Can anybody point my mistake?


アルカード is offline  
Old   #5315
 
elite*gold: 65
Join Date: Sep 2015
Posts: 261
Received Thanks: 367
Quote:
I've marked the point where I think the mistake could be.
isn't that value for decrease_type?
Not sure if that's the reason, but you could try if it's still happening when you set it to '0'
LamiaCore is offline  
Thanks
1 User
Old   #5316
 
elite*gold: 0
Join Date: Apr 2010
Posts: 11
Received Thanks: 0
Exclamation Problem With 9.1 Server

hello guys, today I write for help since I have made my own server with files rappelz 9.1 revolution.

Everything works fine, you can logging, create character, leveling etc ... the problem is that:

From one moment to another, without warning, trying to re-enter to rappelz, the account is crashed, all accounts, mine and all that are created, then inside the game i give an error message:

--- Notice: ??????? ??????? ?????. ??????? ??? ???????? ??? ????. (1) ---

And I can not use the keyboard, the bar of skills not charged and I can only move with the mouse.
attached a screenshot.
hopefully prompt help, thanks.

IMAGE ---> You must register and activate your account in order to view images.

gresk3k is offline  
Old   #5317
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by gresk3k View Post
hello guys, today I write for help since I have made my own server with files rappelz 9.1 revolution.

Everything works fine, you can logging, create character, leveling etc ... the problem is that:

From one moment to another, without warning, trying to re-enter to rappelz, the account is crashed, all accounts, mine and all that are created, then inside the game i give an error message:

--- Notice: ??????? ??????? ?????. ??????? ??? ???????? ??? ????. (1) ---

And I can not use the keyboard, the bar of skills not charged and I can only move with the mouse.
attached a screenshot.
hopefully prompt help, thanks.

IMAGE ---> You must register and activate your account in order to view images.

Edit: i guess you followed all steps from the 9.1 guide of smoke.

But in the smps for the shopbox there was a huge mistake of declaration.

@NO_Total_JP was declared as INT but it has to be BIGINT, because of the amount wich this value can reach

execute this script

Code:
USE [Telecaster]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID			INT,
@IN_CHARACTER_ID		INT,
@OUT_TOTAL_ITEM_COUNT	INT		OUTPUT,
@OUT_NEW_ITEM_COUNT		INT		OUTPUT,
@OUT_PREMIUM_TICKET		INT		OUTPUT,
@OUT_PREMIUM_REST_TIME	INT		OUTPUT,
@OUT_STAMINA_REGEN_TIME	INT		OUTPUT

 
AS
SET NOCOUNT ON

	SET @OUT_PREMIUM_TICKET  = 0
	SET @OUT_PREMIUM_REST_TIME = 0
	SET @OUT_STAMINA_REGEN_TIME = 0

	SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0

	IF @OUT_PREMIUM_TICKET < 1
	BEGIN
		SET @OUT_PREMIUM_REST_TIME = 0

		DECLARE @LOGOUT_TIME		DATETIME
		SET @LOGOUT_TIME = GETDATE()

		SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
		SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0

		IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
		BEGIN
			SET @OUT_STAMINA_REGEN_TIME = 0
		END

	DECLARE @NO_LV INT
	DECLARE @NO_Total_JP BIGINT
	SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

	IF  @NO_LV < 30 AND @NO_Total_JP < 100000
	BEGIN
	SET @OUT_PREMIUM_TICKET  = 1
	SET @OUT_PREMIUM_REST_TIME = 3600 * 5
	END

END

	SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND valid_time > GETDATE() AND isCancel = 0
	SELECT @OUT_NEW_ITEM_COUNT   = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0

RETURN @@ERROR
TheOnlyOneRaskim is offline  
Thanks
3 Users
Old   #5318
 
elite*gold: 0
Join Date: May 2011
Posts: 1
Received Thanks: 0
This Script worked correctly, thank you dude..

I am the Server 9.1 Installer it's a pleasure to have your help and make it possible. another big question is make go on the "Icon Guild Upload".

I tried to configured .. this line from smoke guide also.

Is Auth- Common

#Upload configuration, use "upload" directory for guild icons
upload.dir=D:\SERVERFILES\upload\guild\
upload.clients.ip=EXTERNAL IP --Original is 0.0.0.0
upload.clients.port=32214
#Use port 5000 for the guild icon mini webserver (the listen ip is also upload.clients.ip)
upload.clients.webport:5000

#Where the gameserver will connect (this is default values)
upload.gameserver.ip:127.0.0.1
upload.gameserver.port:4616


In GameServer

S:io.upload.ip:127.0.0.1
S:io.upload.port:4616
S:game.guild_icon_base_url:
S:game.url_list:guild.url| IP|web_download_port|0|shop.url| IP|guild_icon_upload.port|4617

Aparently this isn't correct I tried to do it in several ways... but weren't correct.. Already I had IIS service installed .. and I can't find in any place the corrects parameters , could you dude help me.

Thank Before hands

Quote:
Originally Posted by TheOnlyOneRaskim View Post
Edit: i guess you followed all steps from the 9.1 guide of smoke.

But in the smps for the shopbox there was a huge mistake of declaration.

@NO_Total_JP was declared as INT but it has to be BIGINT, because of the amount wich this value can reach

execute this script

Code:
USE [Telecaster]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[smp_check_purchased_item]
@IN_ACCOUNT_ID			INT,
@IN_CHARACTER_ID		INT,
@OUT_TOTAL_ITEM_COUNT	INT		OUTPUT,
@OUT_NEW_ITEM_COUNT		INT		OUTPUT,
@OUT_PREMIUM_TICKET		INT		OUTPUT,
@OUT_PREMIUM_REST_TIME	INT		OUTPUT,
@OUT_STAMINA_REGEN_TIME	INT		OUTPUT

 
AS
SET NOCOUNT ON

	SET @OUT_PREMIUM_TICKET  = 0
	SET @OUT_PREMIUM_REST_TIME = 0
	SET @OUT_STAMINA_REGEN_TIME = 0

	SELECT @OUT_PREMIUM_TICKET = COUNT(*), @OUT_PREMIUM_REST_TIME = DATEDIFF( second, GETDATE(), MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND isCancel = 0

	IF @OUT_PREMIUM_TICKET < 1
	BEGIN
		SET @OUT_PREMIUM_REST_TIME = 0

		DECLARE @LOGOUT_TIME		DATETIME
		SET @LOGOUT_TIME = GETDATE()

		SELECT @LOGOUT_TIME = logout_time FROM Character WITH (NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND sid = @IN_CHARACTER_ID
		SELECT @OUT_STAMINA_REGEN_TIME = DATEDIFF( minute, @LOGOUT_TIME, MAX( valid_time ) ) FROM dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > @LOGOUT_TIME AND isCancel = 0

		IF @OUT_STAMINA_REGEN_TIME < 1 OR @OUT_STAMINA_REGEN_TIME IS NULL
		BEGIN
			SET @OUT_STAMINA_REGEN_TIME = 0
		END

	DECLARE @NO_LV INT
	DECLARE @NO_Total_JP BIGINT
	SELECT @NO_LV = MAX(lv), @NO_Total_JP = MAX(total_jp) from character WITH(NOLOCK) WHERE account_id = @IN_ACCOUNT_ID AND Name not like '@%'

	IF  @NO_LV < 30 AND @NO_Total_JP < 100000
	BEGIN
	SET @OUT_PREMIUM_TICKET  = 1
	SET @OUT_PREMIUM_REST_TIME = 3600 * 5
	END

END

	SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND valid_time > GETDATE() AND isCancel = 0
	SELECT @OUT_NEW_ITEM_COUNT   = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code <> 910000 AND rest_item_count > 0  AND confirmed = 0 AND valid_time > GETDATE() AND isCancel = 0

RETURN @@ERROR
darkjorg is offline  
Old   #5319
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,004
Received Thanks: 958
Icons have to be run from a website or from the mini webserver built into the auth emulator.

I am not sure those addresses are ones that you have set up for a website, or at least the clients will not be able to find your site at local host 127.0.0.1

You still have lines in there that direct you what to put and you have not changed them...

upload.clients.ip=EXTERNAL IP --Original is 0.0.0.0

should be edited to

upload.clients.ip=0.0.0.0

#Upload configuration, use "upload" directory for guild icons
upload.dir=D:\SERVERFILES\upload\guild\

and again I am not sure D:\serverfiles\ is a link to your website.

You are forcing them to a sub directory and not using "upload"

There are a couple of places in your game server file that still say

"EXTERNAL IP"

You are supposed to put the IP there not leave it alone.

There is some very helpful information about the icon web server in the auth emulator release thread but you may need to check the new one and not just the older auth emulator thread linked from the guide.
ThunderNikk is offline  
Old   #5320
 
elite*gold: 0
Join Date: Oct 2013
Posts: 382
Received Thanks: 25
what is the problem and how to solve it ??

Code:
2015/12/04 08:01:25 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateGlobalVariable(dbo.smp_set_global_variable) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.


Code:
USE [TelecasterH]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_global_variable]    Script Date: 12/4/2015 10:43:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[smp_set_global_variable]
@IN_KEY NVARCHAR(128),
@IN_VALUE NVARCHAR(1024)

AS
SET NOCOUNT ON

update GlobalVariable set value = @IN_VALUE where name = @IN_KEY

if @IN_KEY like '%_query'
begin
exec (@IN_VALUE)
end
Sherock is offline  
Old   #5321
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by Sherock View Post
what is the problem and how to solve it ??

Code:
2015/12/04 08:01:25 DB COM ERROR(Thread:0, HRESULT:80004005, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_UpdateGlobalVariable(dbo.smp_set_global_variable) : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.


Code:
USE [TelecasterH]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_global_variable]    Script Date: 12/4/2015 10:43:00 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[smp_set_global_variable]
@IN_KEY NVARCHAR(128),
@IN_VALUE NVARCHAR(1024)

AS
SET NOCOUNT ON

update GlobalVariable set value = @IN_VALUE where name = @IN_KEY

if @IN_KEY like '%_query'
begin
exec (@IN_VALUE)
end
just read the message you get...

It tells you, that the value of this variable returns more than one line.

But however your query is build, it allows only 1 (ONE) return.

Let me show you an example

Code:
Select * from Arcadia.dbo.ItemResource
This will return all lines of your Itemresource

Code:
Select * from Arcadia.dbo.ItemResource where id = 910000
this will return only 1 row

So to fix your Issue, rewrite your query so only 1 row can be returned.
TheOnlyOneRaskim is offline  
Thanks
1 User
Old   #5322
 
elite*gold: 0
Join Date: Nov 2015
Posts: 18
Received Thanks: 1
Hi, I have two small requests for information.

- How to open shops in town players ? (I saw a message, but I did not understand)
- I wanted to know how to remove the enchantment fail (break) ?

Thank you.
Space() is offline  
Old   #5323
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
Quote:
Originally Posted by Space() View Post
Hi, I have two small requests for information.

- How to open shops in town players ? (I saw a message, but I did not understand)
- I wanted to know how to remove the enchantment fail (break) ?

Thank you.
Let me Quote SilentWisdom

Quote:
Originally Posted by SilentWisdom View Post
From 6.2

Code:
enum LOCATION_TYPE
{
  LOCATION_ETC = 0,
  LOCATION_TOWN = 1,
  LOCATION_FIELD = 2,
  LOCATION_NON_PK_FIELD = 3,
  LOCATION_DUNGEON = 4,
  LOCATION_BATTLE_FIELD = 5,
  LOCATION_EVENTMAP = 7,
  LOCATION_HUNTAHOLIC_LOBBY = 8,
  LOCATION_HUNTAHOLIC_DUNGEON = 9,
  LOCATION_MARICAT_MARKET = 10,
  LOCATION_DEATHMATCH = 11,
  LOCATION_SECRET_DUNGEON = 12,
};
All Options to PK / Enable Shops / Fight Mobs etc are stored in the Worldlocation. You only need to update the right colum at the right ID.

To the Enchantment ....

game.enhance_fail_type is what youre searching for
TheOnlyOneRaskim is offline  
Old   #5324
 
elite*gold: 0
Join Date: Nov 2015
Posts: 18
Received Thanks: 1
Quote:
Originally Posted by TheOnlyOneRaskim View Post
Let me Quote SilentWisdom



All Options to PK / Enable Shops / Fight Mobs etc are stored in the Worldlocation. You only need to update the right colum at the right ID.

To the Enchantment ....

game.enhance_fail_type is what youre searching for
Thank you to you for this information
Space() is offline  
Old   #5325
 
elite*gold: 0
Join Date: Nov 2015
Posts: 18
Received Thanks: 1
I would like a launcher for my server, I encountered a problem during launch.
I used the source code by
But I have an error, and it does not launch sframe.

The code :
Code:
Process.Start("SFrame.exe /auth_ip:<IP_SERVER> /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:windows-1252 /country:US /use_nprotect:0 /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631");
            this.Close();
I want to know what's wrong with my code.
Thank :c


Space() is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 15:40.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.