[Help Thread] Please post your questions here.

[bertie2008]

The 3 added npc's that came with the 7.4 files wont work with
T game.cash_usable_server:0 in gameserver.opt however if I change the 0 to a 1 they work but then I get an error cant connect to server try again later message, any help on how to get them to work with the setting on 0
Thanks

[trev1]

i am getting this message
2012/08/06 13:24:48 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_Login(dbo.smp_read_quest_cool_time_list) : Could not find stored procedure 'dbo.smp_read_quest_cool_time_list'.
I have looked in the old 7.3 files but i cannot find it so if someone would kindly point me in the right direction i would be thankful. I tried at rappelz center fix smp but i cant get video to load.

[prodx]

Can someone explain how it works dragonupacker 5?

Can someone explain how it works RappelzDataUnpack.zip?

please someone teach me steps to i can extract data client to rdb??

[trev1]

Edit i figured out last post.

Next question? How do i get the allowed commands to work i have 24 of them but most are the same and i can not get the learn all skill to work and that is not in my allowed command list is it suppose to be.
this is what my list looks like
1 100 announce
2 100 block_chat
3 100 kick
4 100 sv auto_user
5 100 warp
6 100 recall_player
7 100 invisible
8 100 notice
9 100 rebirth
10 100 block_chat
11 100 kick
12 100 sv auto_user
13 100 warp
14 100 recall_player
15 100 invisible
16 100 notice
17 100 rebirth
18 100 warp
19 100 recall_player
20 100 invisible
21 100 rebirth
23 100 block_chat
24 100 insert_item

[pprfds]

Originally Posted by trev1

i am getting this message
2012/08/06 13:24:48 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_Login(dbo.smp_read_quest_cool_time_list) : Could not find stored procedure 'dbo.smp_read_quest_cool_time_list'.
I have looked in the old 7.3 files but i cannot find it so if someone would kindly point me in the right direction i would be thankful. I tried at rappelz center fix smp but i cant get video to load.

use this



USE [telecaster]
GO

/****** Object: StoredProcedure [dbo].[smp_check_purchased_item] Script Date: 11/07/2012 12:21:42 ص ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


-- smp_read_purchased_item_list

-- start of smp_check_purchased_item 캐쉬템 창고에 아이템 있는지 여부 검사
CREATE 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 INT
--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

--IF @OUT_PREMIUM_REST_TIME < 3600 * 5
--BEGIN

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

--IF @LV < 30 AND @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 rest_item_count > 0 AND item_code <> 910000 AND isCancel = 0
SELECT @OUT_NEW_ITEM_COUNT = COUNT(*) from dbo.PaidItem WHERE taken_account_id = @IN_ACCOUNT_ID AND rest_item_count > 0 AND item_code <> 910000 AND confirmed = 0 AND isCancel = 0

RETURN @@ERROR

GO

[trev1]

can some one help me the syntax to change the name of items

[c1ph3r]

Itemnames are clientsided. You have to edit db_string.rdb.

[iPwnStar]

so i have this problems with the DE and Merc MC class when they attack mobs they get disconnected from the server , now c1ph3r told me that my stateresource is in-complete now im looking for a short totorial on how to fix it or just a link to the post where it was explained. i was trying to look for it but i could not find it.sorry for coming up with the same old problems but im still a noob in this

[c1ph3r]

Originally Posted by iPwnStar

so i have this problems with the DE and Merc MC class when they attack mobs they get disconnected from the server , now c1ph3r told me that my stateresource is in-complete now im looking for a short totorial on how to fix it or just a link to the post where it was explained. i was trying to look for it but i could not find it.sorry for coming up with the same old problems but im still a noob in this

[foxs17]

pls i need code deco 8.1 not wings or bags

[mucki87]

Hello everybody!

I have a problem with vulcanus dungeon.
Mainportal works, mobs are spawning, quests start too...
i finish the quest and the portal to next room appears.
But then, if i click on next room or floor, i'll get the message "...ETC_Dungeon_Prop.lua:1357: bad argument #2 to 'random' (interval is empty)"

After some tries to fix it, it seems that i figured out the issue.
In my opinion, the script can't get the variable 'floor_flag' correct.
If i set the 'room_count' manually to a fix value, he ports me to X0, Y0 because he has no value for 'floor_flag' and can't get the right cordinates.

i didn't find a solution for this.
hopefully somebody around here can help me to get the portals working...

Regards!

The part of my etc_dungeon_prop.lua:

function warp_indun( instance_dungeon, floor )

if instance_dungeon == 20000 then

local flag = 'Vul' .. tostring( floor )
local floor_flag = get_flag( flag )
local gate_num = 1
local room_list = {}
local room_count = 0

if floor_flag == 15 then
return
end

if floor == 4 then

warp_floor( floor, gate_num )

else

if floor_flag ~= nil and floor_flag ~= "" then
if floor_flag == 0 or floor_flag == 2 or floor_flag == 4 or floor_flag == 8 or floor_flag == 6 or floor_flag == 10 or floor_flag == 12 or floor_flag == 14 then
room_list[ room_count + 1 ] = 1
room_count = room_count + 1
end

if floor_flag == 0 or floor_flag == 1 or floor_flag == 4 or floor_flag == 8 or floor_flag == 5 or floor_flag == 9 or floor_flag == 12 or floor_flag == 13 then
room_list[ room_count + 1 ] = 2
room_count = room_count + 1
end

if floor_flag == 0 or floor_flag == 1 or floor_flag == 2 or floor_flag == 8 or floor_flag == 3 or floor_flag == 9 or floor_flag == 10 or floor_flag == 11 then
room_list[ room_count + 1 ] = 3
room_count = room_count + 1
end

if floor_flag == 0 or floor_flag == 1 or floor_flag == 2 or floor_flag == 4 or floor_flag == 3 or floor_flag == 5 or floor_flag == 6 or floor_flag == 7 then
room_list[ room_count + 1 ] = 4
room_count = room_count + 1
end
end
gate_num = math.random( 1, room_count )
warp_floor( floor, room_list[ gate_num ] )
end
end
end

[darky2525]

sry

[massuh11]

Guys I need some help in :

1-how can I let the players get there MC from the NPC in Horizon ?

2-in 7.4 all the DE (in official server) can use there skills with long bow , but try to change it from SQL skills >> doesn't work


note: i tried the search for the 2nd one i didn't find anything
and the 1st i didn't search cuz i don't know the name of in English

[c1ph3r]

1. Look into Gavsta's .lua Scripts!

2. You have to change it in SkillResource and perhaps you have to rebuild the dB_skill.rdb but the flags are in dbo.SkillResource

[rappelz4u]

Hey guys, I was trying to find a way of adding a new area with monsters respawning there, but didn't find any solution. I think that you need to edit monster_respawn.lua and random_respawn.lua (?) <- not sure

could anyone explain me how to works, or / and maybe bring up an example: if i want to spawn monster_id 1 and 2 at horizon field north?

i didnt get the script code, thats why im asking, and didnt find anything like this on the forum.