[Help Thread] Please post your questions here.

Page 97 of 586

04/15/2013 04:00 ThunderNikk#1441

Did you start the upload server?

(Just FYI you only need the upload server for guild icons, the rest will work without it.)

04/15/2013 04:12 Topez#1442

Quote:

Originally Posted by thndr

Did you start the upload server?

(Just FYI you only need the upload server for guild icons, the rest will work without it.)

how would i remove it then? because i cannot login without it crashing and telling me what i said. and yes i ran upload.

04/15/2013 04:15 ThunderNikk#1443

Not connecting to the upload would not cause it to crash. You dont even need the upload running to log into the game.

Something else is wrong

Are you sure it does not say cannot connect to the login server?

04/15/2013 04:17 Topez#1444

Quote:

Originally Posted by thndr

Not connecting to the upload would not cause it to crash. You dont even need the upload running to log into the game.

Something else is wrong

Are you sure it does not say cannot connect to the login server?

Well yes it says that when the game crashes, sorry haha i thought the error in the console was the issue.

04/15/2013 04:28 ThunderNikk#1445

So what are you using for the start .bat or launcher arguments for your client?

Should be something like...

"C:\Rappelz Private Server\Clients\Rappelz 8_1\Rappelz\SFrame.exe" /auth_ip:xxx.xxx.xxx.xxx /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash

04/15/2013 04:46 Topez#1446

Quote:

Originally Posted by thndr

So what are you using for the start .bat or launcher arguments for your client?

Should be something like...

"C:\Rappelz Private Server\Clients\Rappelz 8_1\Rappelz\SFrame.exe" /auth_ip:xxx.xxx.xxx.xxx /auth_port:8841 /locale:ASCII /country:US /commercial_shop /cash

im using pserver connector to try and connect to it.
do you have a skype or something faster than this?
i want to fix this and get to coding. never thought setting up ports etc would be so annoying.

04/15/2013 06:31 opie1225#1447

is it possible to change the port that needs to be used? im trying the game server runs on port 80 and i need it free for something else?

04/15/2013 09:11 Makenci#1448

habe ein prooblem, ich komme in mein server nicht rein zur Serverauswahl.
Es kommt auch keine fehlermeldung nichts.

ich denke an der IP kann es nicht liegen da wenn ich die ge�ndert habe auch der fehler da war das keine verbindung zum zertif........... ist.

Habe alles nach liste gemacht aber irgendwie gehts nicht -.-

kann mir da jemand vielelicht helfen ?

04/15/2013 09:28 Xijezu#1449

Quote:

Originally Posted by opie1225

is it possible to change the port that needs to be used? im trying the game server runs on port 80 and i need it free for something else?

Port 80? Why? o0
Yep, it is possible, just change the .opt-file: S io.port: 80

Quote:

Originally Posted by Topez

im using pserver connector to try and connect to it.
do you have a skype or something faster than this?
i want to fix this and get to coding. never thought setting up ports etc would be so annoying.

The PServer-Connector is using the standard-parameter, so it could be that it is trying to connect to a different port. Try using a .bat-File instead.

Quote:

Originally Posted by Makenci

habe ein prooblem, ich komme in mein server nicht rein zur Serverauswahl.
Es kommt auch keine fehlermeldung nichts.

ich denke an der IP kann es nicht liegen da wenn ich die ge�ndert habe auch der fehler da war das keine verbindung zum zertif........... ist.

Habe alles nach liste gemacht aber irgendwie gehts nicht -.-

kann mir da jemand vielelicht helfen ?

Wie w�r's wenn du die .opt-Dateien mal postest? Andernfalls k�nnen wir nur raten.

04/15/2013 09:42 Makenci#1450

auth

Spoiler

game

Spoiler

04/15/2013 09:53 Xijezu#1451

Quote:

Originally Posted by Makenci

auth

Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:auth
S db.auth.account:RappelzHome
S db.auth._password:
S db.auth.port:1433
S app.name:auth

N game.user_limit:3000
N auth.max_client_per_ip:30000

S log.ip:127.0.0.1
N _auth.version:200604290
N auth.version:200701120
N auth.max_daily_client_per_ip:50000

S db.auth.md5_key:1234
N db.auth.use_md5:1
N db.auth.use_md5_for_security_no:0

N billing.user_keep_alive_interval:30000

game

Spoiler

S app.name:game001
S auth.server_idx:1
S auth.server_name:Home

S db.user.work_total:nbr
S db.user.work_pending:nbr
S db.user.work_active:nbr
S db.user.thread_active:nbr
S db.user.thread_total:nbr

S console.port:4502
S console._password:

S db.game.ip:127.0.0.1

S db.c.name:arcadia
S db.c.server:127.0.0.1
S db.c.account:RappelzHome
S db.c._password:

S db.user.name:telecaster
S db.user.server:127.0.0.1
S db.user.account:RappelzHome
S db.user._password:

S io.auth.ip:127.0.0.1
S io.ip_address:25.102.98.147
S io.port:7888

S game.server_screenshot_url:url_of_your_screen_sele ction_html

S io.upload.port:4617
S io.upload.ip:127.0.0.1
S game.guild_icon_base_url:[Only registered and activated users can see links. Click Here To Register...]
S game.url_list:guild_icon_upload.ip|your_website/external_ip|guild_icon_upload.port|4615

S game.use_auto_jail:0
S game.pvp_damage_rate_for_summon:.03
S game.pvp_damage_rate_for_player:.03
S game.use_storage_security:0
S game.check_storage_security_always:0
S game.use_delete_security:0
S game.mem_usage_info_save_interval:6000
S game.base_ethereal_durability_consumption:.35
S game.play_point_accumulate_term:6000
S game.play_point_accumulate_amount:10
S game.premium_pcbang_play_point_bonus_rate:2.5
S game.exp_rate:10
S game.item_drop_rate:12
S game.gold_drop_rate:12
S game.chaos_drop_rate:12
S game.party_drop_rate:2.5
S game.party_exp_rate:1.25
S game.apply_stamina_bonus_in_premium_pcb:.50
S game.premium_pcbang_bonus_rate:1.25
S game.premium_pcbang_chaos_bonus_rate:2
S game.premium_pcbang_gold_bonus_drop_rate:2.5
S game.premium_pcbang_item_bonus_drop_rate:2.5
S game.premium_pcbang_chaos_bonus_drop_rate:2.5
S game.ally_pcbang_bonus_rate:1.75
S game.ally_pcbang_chaos_bonus_rate:1.75

T game.pcbang_bonus_server:1
T game.use_play_point:0
T game.use_guild_donation_point:1
T game.use_login_logout_debug:1
T game.max_level:180
T game.use_auto_trap:0
T game.cash_usable_server:1
T game.no_collision_check:0
T game.no_skill_cooltime:0
T game.disable_huntaholic:0
S game.disable_huntaholic_timer:0
S game.huntaholic_timer:1
T game.disable_dungeon_raid_siege:0
N game.UseHackShield:0
N game.UseGameGuard:0
N game.skip_loading_attribute:1
N game.logout_timer:1
S log.disable:1
S log.working:0
S game.AdultServer:0
S game.PKServer:0
S game.disable_pk_on:0
S game.auction_process_request_min_interval:100
S game.auction_search_request_min_interval:100
S game.force_unregister_account_on_kick_fail:1
S game.min_global_chat_usable_level:20
S game.item_hold_time:11000

S memory.player_heap_size:1000
T game.max_storage_item_count:1000
T set_user_limit:50

Spoiler

Oder ganz simpel: S io.ip_address: 127.0.0.1

04/15/2013 10:56 Makenci#1452

gleiches problem geht nach dem login nicht weiter ohne fehlermeldung nichts

vielleicht liegt es ja an der bat datei ??

Spoiler

04/15/2013 11:09 Xijezu#1453

Quote:

Originally Posted by Makenci

Spoiler

@ECHO OFF
START SFRAME /auth_ip:127.0.0.1 /auth_port:7888 /locale:Windows-1252 /country: DE /commercial_shop /help_url_w:620 /help_url_h:633 /ghelp_url:"http://game.gpotato.eu/rappelz/help/ /guild.url:"http://%guildLink%" /web_download:"DownloadLink" /guild_download.url:"upload/client/guild/" /shop.url:"http://%shop_url%" /rend

Ah, sorry, n�chstes mal sollte ich erst nach dem Kaffee antworten..
Nimm' einfach das /auth_port:7888 raus, und es d�rfte gehen. Der Standard-Port ist 4500, und da du keinen in der opt angegeben hast, wird auch der verwendet.

04/15/2013 11:17 Makenci#1454

ok hat geklappt :) viellen viellen dank :)

next problem

im gs steht nun

DB COM ERROR(thread 1, HRESULT:80040E37, GUID 0c733a63-2a1c usw....
DB_GetCommerciaStorageinfo(dbo.smp_check_purchase_ item : ung�ltiger objektname . billing.dob.paidtem

04/15/2013 11:36 c1ph3r#1455

Einfacher Weg:

F�ge die Billing Datenbank hinzu (Iwo im 7.4 Release)

Etwas komplizierterer Weg:

Schreibe die Billing SMPs in der Telecaster um.

smp_check_purchased_item:

Spoiler

Code:

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_check_purchased_item]    Script Date: 15.04.2013 11:38:40 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[smp_check_purchased_item]

@IN_ACCOUNT_ID INT,
@IN_SID 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_NEW_ITEM_COUNT = 10 
SET @OUT_STAMINA_REGEN_TIME = 20 

SET @OUT_PREMIUM_TICKET = 0
SET @OUT_PREMIUM_REST_TIME = 0

SELECT @OUT_PREMIUM_TICKET = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and item_code = 910000 and valid_time > GETDATE()

IF @OUT_PREMIUM_TICKET > 0
BEGIN

UPDATE PaidItem set valid_time = DATEADD(s, DATEDIFF(s, bought_time, GETDATE()), valid_time), taken_time = GETDATE() where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND taken_time IS NULL

DECLARE @VALID_PASS_COUNT INT
SET @VALID_PASS_COUNT = 0

DECLARE @COMBINED_TIME INT
SET @COMBINED_TIME = 0

DECLARE @NEWEST_PASS INT
SET @NEWEST_PASS = -1

SELECT @VALID_PASS_COUNT = COUNT(*) FROM PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()

IF @VALID_PASS_COUNT > 1
	BEGIN
		SELECT @COMBINED_TIME = SUM(DATEDIFF(s, GETDATE(), valid_time)) from PaidItem where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()
		
		SELECT TOP (1) @NEWEST_PASS = sid from PaidItem where taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() ORDER BY bought_time DESC
		
		SET ROWCOUNT 1
		WHILE 1=1
		BEGIN
			UPDATE PaidItem set valid_time = GETDATE(), rest_item_count=0 WHERE sid IN ( SELECT TOP 1 sid FROM PaidItem WITH (NOLOCK) WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE() AND sid <> @NEWEST_PASS )
			IF @@ROWCOUNT = 0 BREAK
		END
		SET ROWCOUNT 0

		UPDATE PaidItem set valid_time = DATEADD(s, @COMBINED_TIME, GETDATE()), rest_item_count=0 WHERE taken_account_id = @IN_ACCOUNT_ID AND item_code = 910000 AND valid_time > GETDATE()AND sid = @NEWEST_PASS
	END

	
SELECT @OUT_PREMIUM_REST_TIME = MAX(DATEDIFF(s, GETDATE(), valid_time)) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and item_code = 910000 and valid_time > GETDATE()

SELECT @OUT_TOTAL_ITEM_COUNT = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0;
SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from PaidItem WITH (NOLOCK) where taken_account_id = @IN_ACCOUNT_ID and rest_item_count > 0 and confirmed = 0;

END

RETURN @@ERROR

smp_read_purchased_item_list:

Spoiler

smp_takeout_commercial_item:

Spoiler

Code:

USE [telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_takeout_commercial_item]    Script Date: 15.04.2013 11:42:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[smp_takeout_commercial_item]

@OUT_ITEM_CODE          INT OUTPUT,
@IN_SID                 INT,
@IN_COUNT               INT,
@IN_ACCOUNT_ID          INT,
@IN_AVATAR_ID           INT,
@IN_AVATAR_NAME         VARCHAR(61),
@IN_SERVER_NAME         VARCHAR(30),
@IN_TRANSACTION_CODE	INT,
@IN_IDX					INT
 
AS
SET NOCOUNT ON

SET @OUT_ITEM_CODE = 0

DECLARE @RET INT
SET @RET = -1

DECLARE @REST_ITEM_COUNT INT
SET @REST_ITEM_COUNT = -1


IF @IN_COUNT < 1
BEGIN
    GOTO ON_END
END

BEGIN TRANSACTION

	SELECT @REST_ITEM_COUNT = rest_item_count FROM dbo.PaidItem WHERE sid = @IN_SID;

	IF @REST_ITEM_COUNT < @IN_COUNT
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END


	UPDATE dbo.PaidItem SET

        rest_item_count = ( @REST_ITEM_COUNT - @IN_COUNT ),
        taken_avatar_id = @IN_AVATAR_ID,
        taken_avatar_name = @IN_AVATAR_NAME,
        taken_server_name = @IN_SERVER_NAME,
        taken_time = GETDATE()
        
    WHERE sid = @IN_SID and taken_account_id = @IN_ACCOUNT_ID;
    SET @RET = 0

	DECLARE @ACCOUNT_ID INT
	SET @ACCOUNT_ID = -1

	SELECT @OUT_ITEM_CODE = item_code, @ACCOUNT_ID = taken_account_id from dbo.PaidItem where sid = @IN_SID;

	IF @ACCOUNT_ID <> @IN_ACCOUNT_ID
		BEGIN
			SET @OUT_ITEM_CODE = 0
			ROLLBACK TRANSACTION
			GOTO ON_END
		END

	-- Add the item(s) to the character
	INSERT INTO dbo.Item (

		sid,							-- 0
		owner_id,						-- 1
		account_id,						-- 2
		summon_id,						-- 3
		auction_id,						-- 4
		keeping_id,						-- 5
		idx,							-- 6
		code,							-- 7
		flag,							-- 8
		cnt,							-- 9
		[level],						-- 10
		enhance,
		ethereal_durability,						-- 11
		endurance,						-- 12
		gcode,							-- 13
		create_time,						-- 14
		wear_info,						-- 15
		socket_0,						-- 16
		socket_1,						-- 17
		socket_2,						-- 18
		socket_3,						-- 19
		remain_time,						-- 20
		elemental_effect_type,					-- 21
		elemental_effect_expire_time,				-- 22
		elemental_effect_attack_point,				-- 23
		elemental_effect_magic_point,				-- 24
		update_time						-- 25

	)
	VALUES (
	
		@IN_TRANSACTION_CODE,					-- 0
		@IN_AVATAR_ID,						-- 1
		@IN_ACCOUNT_ID,						-- 2
		0,							-- 3
		0,							-- 4
		0,							-- 5
		@IN_IDX,						-- 6
		@OUT_ITEM_CODE,						-- 7
		0,							-- 8
		@IN_COUNT,						-- 9
		0,							-- 10
		0,
		0,							-- 11
		0,							-- 12
		0,							-- 13
		GETDATE(),						-- 14	
		-1,							-- 15
		0,							-- 16
		0,							-- 17
		0,							-- 18
		0,							-- 19
		0,							-- 20
		0,							-- 21
		0,							-- 22
		0,							-- 23
		0,							-- 24
		GETDATE()						-- 25
	);

	SET @RET = @@ERROR

	IF @RET <> 0
	BEGIN
		ROLLBACK TRANSACTION
        GOTO ON_END
	END

COMMIT TRANSACTION

ON_END:
RETURN @RET

Da ist immer der Verweis auf die Billing Datenbank. Hier einfach auf die Telecaster verweisen und die dbo.PaidItem mit dem folgenden Skript anlegen:

PaidItem:

Spoiler

Page 97 of 586