[Help Thread] Please post your questions here.

[M>M]

hi guys iam looking for a command that evo pets

[ghost_h]

need heip
when i use 7.4PH sframe.exe and summon Looppets it will come a bug,SFrame.exe Runtime error..but 7.3 dot have this bug,why and how to fix it ?
thx...

[RedX13]

Okay Guys I seen a lot of Help-me posts about this Error:

"""start db initializing...ERROR: AUTH DB INIT ERROR : [DBNETLIB][ConnectionOpen (Connect()).]SQLServer does not exist or access denied."""

I get this error when i run the "Auth" Server and also when i run the "Captain's" one too plus the "Captain" crashes...

Still didn't find a fix for it so i want to understand the possible cause behind the error... and were are the files or settings related to it.. so i can go fix-it-myself..or make it totally unfixable!

-so if someone knows the issue can u be so kind as to point me to the problem?
-Also after i get done with this...."which by the way is just so my nephew can have a good dueling ground to play with me ...."

-believe me this is history repeating itself for me.... cux i always go around learnig new stuff..... and I have never touched a "SQLServer" or had any idea what it was used for until 2 days ago... lol and i been doing all of these while playing Rappelz at same time (Ahem!:thas why is not working); O.o


"By the way Dots (...) equals me thinking!... the more ......(dots) the more thinking... ... . . . . ."

[trev1]

@redx13 first on the sql you have to set it up like the guide said. Then in the game server file you have to put your ip address in it. sounds like to me you dont have that set up or you dont have sql configed right.


Now my ? is i am using this to try and find items in sql
USE Arcadia74
GO

SELECT ITEM.id, STRING.value
FROM dbo.ItemResource as ITEM
LEFT JOIN dbo.StringResource as STRING
on STRING.code=ITEM.name_id
WHERE STRING.value like '%Item name%'

ORDER BY rank

Every time i use that it complete's but only brings column name id and value so what do i have wrong here?

[Musta²]

Originally Posted by M>M

hi guys iam looking for a command that evo pets

/run creature_evolution(get_creature_handle(0)) -- add your handle number.

But you'll need to make it's code manually, this won't evo it's codes.

[RedX13]

Everything is to the dot like the guide said exept for my SQLServer is set for "user-pc" as my User ID if that's the problem then i know how to fix it....I just don't wanna


Um.. I also had error trying to connect to the SQLServer using "SQLServer Authentication" so instead i used "Windows Authentication" to connect to the server which changed my login from "SA" back to "user-pc" if that makes any difference..??? well that the only way it would connect to the host...


what?.. did i mess up too much? come on it was Kakashi aproved!

[trev1]

@redx13 well in that case make sure that the auth file and gameserver file are set up for user-pc instead of sa. I dont know which ones you downloaded but i bet they will say sa, just change that to user-pc and what ever password you put in if you have one.

[Opening]

Nobody tells a request to reduce the chance of sharpening skill cards and things? Please

[creative1984]

Ich habe hier ein problem mit dem Authserver...

2012-08-22 16:25:56 Duplicated game session detected. [Account: midoudali24 / CurIP: 197.7.69.88 / PrevIP: 81.220.228.129]
2012-08-22 16:25:57 AUTH DEBUG : KICK SUCCESSED [midoudali24]

Habe aber bis jetzt nichts darüber gefunden, wäre nett wenn mir da jemand weiter helfen kann.
danke

[Claph]

How to increase the exp the pets get?
It seems to be capped...

[robberpi]

can anyone share "clean db+client" for 7.4 download files (link); i searched a bit but there is nothing.

thanks.

[babybestboy]

Hello, I decided to create my own private server. I downloaded 7.4 client/server files. Restored databases with SQL server 2012. But CaptainHerlocServer.exe suddenly closes after some time. I tried to replace telecaster.bak with 7.3 files still closes without any error. Then i replaced telecaster.bak with 6.2 file .. yeah, problem seems fixed but cant create char now.

1st Question will be : How can i fix the problem?
2nd Question : what telecaster.bak i have to use to get 7.4 server working ...?

[creative1984]

Originally Posted by babybestboy

Hello, I decided to create my own private server. I downloaded 7.4 client/server files. Restored databases with SQL server 2012. But CaptainHerlocServer.exe suddenly closes after some time. I tried to replace telecaster.bak with 7.3 files still closes without any error. Then i replaced telecaster.bak with 6.2 file .. yeah, problem seems fixed but cant create char now.

1st Question will be : How can i fix the problem?
2nd Question : what telecaster.bak i have to use to get 7.4 server working ...?

-----
DB COM ERROR(Thread:0, HRESULT:80040E57, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_Login(dbo.smp_login_character) : Arithmetischer Überlauffehler beim Konvertieren von expression in den int-Datentyp.

Help me pls.

-- start of smp_login_character
ALTER PROCEDURE [dbo].[smp_login_character]

@OUT_SID						INT OUTPUT,
@OUT_ACCOUNT					VARCHAR(60) OUTPUT,
@OUT_PERMISSION					INT	OUTPUT,
@OUT_PARTY_SID					INT OUTPUT,
@OUT_GUILD_SID					INT OUTPUT,
@OUT_PREV_GUILD_SID				INT OUTPUT,
@OUT_GUILD_PERMISSION			TINYINT OUTPUT,
@OUT_X							INT OUTPUT,
@OUT_Y							INT OUTPUT,
@OUT_Z							INT OUTPUT,
@OUT_LAYER						INT OUTPUT,
@OUT_RACE						INT OUTPUT,
@OUT_SEX						INT OUTPUT,
@OUT_LV							INT OUTPUT,
@OUT_MAX_REACHED_LEVEL			INT OUTPUT,
@OUT_EXP						BIGINT OUTPUT,
@OUT_LAST_DECREASED_EXP			BIGINT OUTPUT,
@OUT_HP							INT OUTPUT,
@OUT_MP							INT OUTPUT,
@OUT_STAMINA					INT OUTPUT,
@OUT_HAVOC						INT OUTPUT,
@OUT_JOB						INT OUTPUT,
@OUT_JOB_DEPTH					INT OUTPUT,
@OUT_JLV						INT OUTPUT,
@OUT_JP							INT OUTPUT,
@OUT_TOTAL_JP					INT OUTPUT,
@OUT_TALENT_POINT				INT OUTPUT,
@OUT_JOB_0						INT OUTPUT,
@OUT_JOB_1						INT OUTPUT,
@OUT_JOB_2						INT OUTPUT,
@OUT_JLV_0						INT OUTPUT,
@OUT_JLV_1						INT OUTPUT,
@OUT_JLV_2						INT OUTPUT,
@OUT_IP							DECIMAL(18,4) OUTPUT,
@OUT_CHA						INT OUTPUT,
@OUT_PKC						INT OUTPUT,
@OUT_DKC						INT OUTPUT,
@OUT_HUNTAHOLIC_POINT			INT OUTPUT,
@OUT_HUNTAHOLIC_ENTER_COUNT		INT OUTPUT,
@OUT_ETHEREAL_STONE_DURABILITY	INT OUTPUT,
@OUT_SUMMON_0					INT OUTPUT,
@OUT_SUMMON_1					INT OUTPUT,
@OUT_SUMMON_2					INT OUTPUT,
@OUT_SUMMON_3					INT OUTPUT,
@OUT_SUMMON_4					INT OUTPUT,
@OUT_SUMMON_5					INT OUTPUT,
@OUT_SKIN_COLOR					INT	OUTPUT,
@OUT_MODEL_00					INT OUTPUT,
@OUT_MODEL_01					INT OUTPUT,
@OUT_MODEL_02					INT OUTPUT,
@OUT_MODEL_03					INT OUTPUT,
@OUT_MODEL_04					INT OUTPUT,
@OUT_HAIR_COLOR_INDEX			INT OUTPUT,
@OUT_HAIR_COLOR_RGB				INT OUTPUT,
@OUT_HIDE_EQUIP_FLAG			INT OUTPUT,
@OUT_TEXTURE_ID					INT OUTPUT,
@OUT_BELT_0						BIGINT OUTPUT,
@OUT_BELT_1						BIGINT OUTPUT,
@OUT_BELT_2						BIGINT OUTPUT,
@OUT_BELT_3						BIGINT OUTPUT,
@OUT_BELT_4						BIGINT OUTPUT,
@OUT_BELT_5						BIGINT OUTPUT,
@OUT_GOLD						BIGINT OUTPUT,
@OUT_CHAOS						INT OUTPUT,
@OUT_FLAG_LIST					VARCHAR(1000) OUTPUT,
@OUT_CLIENT_INFO				VARCHAR(4096) OUTPUT,
@OUT_LOGIN_COUNT				INT OUTPUT,
@OUT_MAIN_SUMMON				INT	OUTPUT,
@OUT_SUB_SUMMON					INT	OUTPUT,
@OUT_REMAIN_SUMMON_TIME			INT	OUTPUT,
@OUT_PET						INT OUTPUT,
@OUT_REMAIN_CHAT_BLOCK_TIME		INT OUTPUT,
@ADV_CHAT_COUNT					INT OUTPUT,
@OUT_LOGOUT_DURATION			INT OUTPUT,
@OUT_NAME_CHANGED				INT OUTPUT,
@OUT_AUTO_USED					INT OUTPUT,
@OUT_GUILD_BLOCK_TIME			DATETIME OUTPUT,
@OUT_PKMODE						TINYINT OUTPUT,
@IN_NAME						NVARCHAR(31),
@IN_ACCOUNT_ID					INT
AS
SET NOCOUNT ON

BEGIN TRANSACTION

DECLARE @DELETE_TIME DATETIME;
DECLARE @ITEM_COOL_TIME_CNT INT;
DECLARE @LOGOUT_TIME	DATETIME;

SELECT @DELETE_TIME = delete_time FROM dbo.Character WITH (NOLOCK) WHERE name = @IN_NAME AND account_id = @IN_ACCOUNT_ID;

IF @DELETE_TIME IS NOT NULL AND DATEPART( year, @DELETE_TIME ) > 9000
BEGIN

	UPDATE dbo.Character WITH (XLOCK) SET login_count = login_count + 1, login_time = GETDATE() WHERE name = @IN_NAME AND account_id = @IN_ACCOUNT_ID;

	SELECT 

		@OUT_SID						= sid,
		@OUT_ACCOUNT					= account,
		@OUT_PERMISSION					= permission,
		@OUT_PARTY_SID					= party_id,
		@OUT_X							= x,
		@OUT_Y							= y,
		@OUT_Z							= z,
		@OUT_LAYER						= layer,
		@OUT_RACE						= race,
		@OUT_SEX						= sex,
		@OUT_LV							= lv,
		@OUT_MAX_REACHED_LEVEL			= max_reached_level,
		@OUT_EXP						= exp,
		@OUT_LAST_DECREASED_EXP			= last_decreased_exp,
		@OUT_HP							= hp,
		@OUT_MP							= mp,
		@OUT_STAMINA					= stamina,
		@OUT_HAVOC						= havoc,
		@OUT_JOB						= job,
		@OUT_JOB_DEPTH					= job_depth,
		@OUT_JLV						= jlv,
		@OUT_JP							= jp,
		@OUT_TOTAL_JP					= total_jp,
		@OUT_TALENT_POINT				= talent_point,
		@OUT_JOB_0						= job_0,
		@OUT_JOB_1						= job_1,
		@OUT_JOB_2						= job_2,
		@OUT_JLV_0						= jlv_0,
		@OUT_JLV_1						= jlv_1,
		@OUT_JLV_2						= jlv_2,
		@OUT_IP							= immoral_point,
		@OUT_CHA						= cha,
		@OUT_PKC						= pkc,
		@OUT_DKC						= dkc,
		@OUT_HUNTAHOLIC_POINT			= huntaholic_point,
		@OUT_HUNTAHOLIC_ENTER_COUNT		= huntaholic_enter_count,
		@OUT_ETHEREAL_STONE_DURABILITY	= ethereal_stone_durability,
		
		@OUT_SUMMON_0					= summon_0,
		@OUT_SUMMON_1					= summon_1,
		@OUT_SUMMON_2					= summon_2,
		@OUT_SUMMON_3					= summon_3,
		@OUT_SUMMON_4					= summon_4,
		@OUT_SUMMON_5					= summon_5,
		@OUT_SKIN_COLOR					= skin_color,
		@OUT_MODEL_00					= model_00,
		@OUT_MODEL_01					= model_01,
		@OUT_MODEL_02					= model_02,
		@OUT_MODEL_03					= model_03,
		@OUT_MODEL_04					= model_04,
		@OUT_HAIR_COLOR_INDEX			= hair_color_index,
		@OUT_HAIR_COLOR_RGB				= hair_color_rgb,
		@OUT_HIDE_EQUIP_FLAG			= hide_equip_flag,
		@OUT_TEXTURE_ID					= texture_id,
		@OUT_BELT_0						= belt_00,
		@OUT_BELT_1						= belt_01,
		@OUT_BELT_2						= belt_02,
		@OUT_BELT_3						= belt_03,
		@OUT_BELT_4						= belt_04,
		@OUT_BELT_5						= belt_05,
		@OUT_GOLD						= gold,
		@OUT_CHAOS						= chaos,
		@OUT_FLAG_LIST					= flag_list,
		@OUT_CLIENT_INFO				= client_info,
		@OUT_LOGIN_COUNT				= login_count,
		@OUT_MAIN_SUMMON				= main_summon,
		@OUT_SUB_SUMMON					= sub_summon,
		@OUT_REMAIN_SUMMON_TIME			= remain_summon_time,
		@OUT_PET						= pet,
		@OUT_REMAIN_CHAT_BLOCK_TIME		= chat_block_time,
		@ADV_CHAT_COUNT					= adv_chat_count,
		@LOGOUT_TIME					= logout_time,
		@OUT_LOGOUT_DURATION			= DATEDIFF( minute, logout_time, GETDATE() ),
		@OUT_NAME_CHANGED				= name_changed,
		@OUT_AUTO_USED					= auto_used,
		@OUT_PKMODE						= pkmode
		
	FROM dbo.Character WITH (NOLOCK) WHERE name = @IN_NAME AND account_id = @IN_ACCOUNT_ID;

	IF EXISTS ( SELECT * FROM dbo.GuildMember WITH (NOLOCK) WHERE player_id = @OUT_SID )
	BEGIN
		SELECT
			@OUT_GUILD_SID	= guild_id,
			@OUT_PREV_GUILD_SID = prev_guild_id,
			@OUT_GUILD_PERMISSION = permission,
			@OUT_GUILD_BLOCK_TIME = guild_block_time
		FROM dbo.GuildMember WITH (NOLOCK) WHERE player_id = @OUT_SID
	END
	ELSE
	BEGIN
		SET @OUT_GUILD_SID = 0
		SET @OUT_PREV_GUILD_SID = 0
		SET @OUT_GUILD_PERMISSION = 0
		SET @OUT_GUILD_BLOCK_TIME = '2000-1-1'
	END

	IF @OUT_SID IS NOT NULL
	BEGIN
		SELECT @ITEM_COOL_TIME_CNT = count(*) FROM dbo.ItemCoolTime WITH (NOLOCK) WHERE owner_id = @OUT_SID;

		IF @ITEM_COOL_TIME_CNT < 1
		BEGIN
			INSERT INTO dbo.ItemCoolTime (
			owner_id,
			cool_time_00, cool_time_01, cool_time_02, cool_time_03, cool_time_04,
			cool_time_05, cool_time_06, cool_time_07, cool_time_08, cool_time_09,
			cool_time_10, cool_time_11, cool_time_12, cool_time_13, cool_time_14,
			cool_time_15, cool_time_16, cool_time_17, cool_time_18, cool_time_19,
			cool_time_20, cool_time_21, cool_time_22, cool_time_23, cool_time_24,
			cool_time_25, cool_time_26, cool_time_27, cool_time_28, cool_time_29,
			cool_time_30, cool_time_31, cool_time_32, cool_time_33, cool_time_34,
			cool_time_35, cool_time_36, cool_time_37, cool_time_38, cool_time_39
			)
			VALUES
			(
			@OUT_SID,
			0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
			0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
			0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
			0, 0, 0, 0, 0, 0, 0, 0, 0, 0
			);
		END

		IF @ADV_CHAT_COUNT > 0
		BEGIN
			DECLARE @current_t DATETIME 
			DECLARE @renew_t DATETIME
			set @current_t = GETDATE()
			set @renew_t = CONVERT( DATETIME, LTRIM(STR(YEAR( @current_t ) )) + '-' + LTRIM(STR( MONTH( @current_t ) ) )+ '-' + LTRIM(STR(DAY( @current_t ) ) ) + ' 06:00:00', 120 )


			IF @current_t < @renew_t
			BEGIN
				SET @renew_t = DATEADD( day, -1, @renew_t )
			END

			IF @renew_t > @LOGOUT_TIME
			BEGIN
				SET @ADV_CHAT_COUNT = 0
			END
		END
	END

END


DECLARE @ERR INT
SET @ERR = @@ERROR

COMMIT TRANSACTION

RETURN @ERR

-- end of smp_login_character

[pprfds]

hi
need a fix for enhache bug
the bug is when the enhache fail if the weapon is +9 it returns to +5 so i want to know what is the fix or what is the smp that has the bug

thanks i know where is the problem

the problem was in item code ~~

the not buggy item is 950070 not 950021

[pprfds]

hi i think that no one will help me but i want the player notice code

i mean a notice only for player not all the players