[Help Thread] Please post your questions here.

[thefear511]

Originally Posted by 3lloosh

Anyone could help me?

please include your client & files versions ..

[Exterminator-[Fury]]

I'm not sure why the iplog give this message. But a quick fix for this is. let the account_id field in iplog enable null value. Normally it's doesn't allow null value. Database tries to enter data ... fails to search for correct account_id.. makes the server freeze and crash. not the great methode but yeah it works for me. good luck

Originally Posted by 3lloosh

Anyone could help me?

[3lloosh]

Originally Posted by thefear511

please include your client & files versions ..

9.1 official revo files and I developed it to 9.4

Originally Posted by exter16

I'm not sure why the iplog give this message. But a quick fix for this is. let the account_id field in iplog enable null value. Normally it's doesn't allow null value. Database tries to enter data ... fails to search for correct account_id.. makes the server freeze and crash. not the great methode but yeah it works for me. good luck

Thank you, but I really don't understand you very well ..

Do you mean the account_id field of players in the account table in the Auth database (like this photo)? Or what?

Thank you again for help

[ThunderNikk]

He means auth.dbo.IPLog

USE [Auth]
GO

/****** Object:  Table [dbo].[IPLog]    Script Date: 9/4/2017 9:58:33 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[IPLog](
	[account_id] [int] NULL,
	[account_name] [nvarchar](32) NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[login_date] [date] NOT NULL,
	[login_time] [time](7) NOT NULL
) ON [PRIMARY]

GO

[3lloosh]

Originally Posted by thndr

He means auth.dbo.IPLog

USE [Auth]
GO

/****** Object:  Table [dbo].[IPLog]    Script Date: 9/4/2017 9:58:33 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[IPLog](
	[account_id] [int] NULL,
	[account_name] [nvarchar](32) NOT NULL,
	[ip] [nvarchar](50) NOT NULL,
	[login_date] [date] NOT NULL,
	[login_time] [time](7) NOT NULL
) ON [PRIMARY]

GO

Ah! now I got it ..

Actually I don't have [IPLog table] in my Auth, but I will created with your script ..

I hope this way fix my problem

Thank you very much

[Charliefoxtrott]

Originally Posted by アルカード

So as i see alot of people wana 6.2 server.Where i can find good files,all i can see it is vanilla pyrok 6.2 and ismokedrow edited 6.2 files?

You will find the answer soon.

[アルカード]

Originally Posted by Charliefoxtrott

You will find the answer soon.

I already got a private stable 6.2 files with stable gs.I drop that idea for now,i just rather make 9.1 striped to full and rebuilding it back to 6.2

[Charliefoxtrott]

Oh, ok. I am working on classic 6.2 at the moment. Maybe we can exchange info and knowledge later?

[Exterminator-[Fury]]

Anyone who might give me some directions to fix the following problems.

Awakend accessories bought from auction after been reloged the awakend is dissapeard from accessories.
Power of change and blessed version used at pw (distored) gear causes server freeze after some enchantment gears .

[アルカード]

Originally Posted by Charliefoxtrott

Oh, ok. I am working on classic 6.2 at the moment. Maybe we can exchange info and knowledge later?

once i find a free time sure.

Originally Posted by exter16

Anyone who might give me some directions to fix the following problems.

Awakend accessories bought from auction after been reloged the awakend is dissapeard from accessories.
Power of change and blessed version used at pw (distored) gear causes server freeze after some enchantment gears .

Umm i already told you where to checke error.I already offer you a few tips how to make fixes....

[LenartP]

Hello lads,

When starting
the Launcher.bat
RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:windows-1256 /countryE /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

literally nothing but the admin request from rappelzcmdlauncher.exe happens.
tried with starting as admin as well.

Common.opt

 Spoiler

#Write trace log messages to file and show only info log messages on console
core.log.level:trace
core.log.consolelevel:info

#Enable traffic dump, will be in traffic_log folder (default off)
#trafficdump.enable:true

#The password is in plain text if you have one
auth.db.password:
auth.db.salt:2011
#You can make auth.dbo.Accounts.[password] by visiting:
# (KEY+PASSWORD = hashed password)[No spaces between KEY and PASSWORD]
# Copy the resulting md5 into the password field of your account entry


#Where clients will connect (this is default values)
auth.clients.ip:127.0.0.1
auth.clients.port:58422
auth.clients.des_key:MERONG

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

#Upload configuration, use "upload" directory for guild icons
upload.dir=upload
upload.clients.ip=127.0.0.1
upload.clients.port=32214
#
Where the client will connect to download guild icons
upload.iconserver.ip=0.0.0.0
#Use port 5000 for the guild icon mini webserver
upload.iconserver.port:5000




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

#Only for SQL Server: speed up selects with NOLOCK
sql.db_account.query:SELECT * FROM Accounts WITH(NOLOCK) WHERE login_name = ? AND password = ?;

GameServer.opt

 Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:RappelzFamily

S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:sa

S:db.c._password:
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:sa

S:db.user._password:

N:io.port:15574
S:io.auth.ip:127.0.0.1
S:io.ip_address:127.0.0.1

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1

N:console.port:44554
S:console.allow_ip:127.0.0.1

S:console._password:

S io.upload.port:4616
S io.upload.ip:127.0.0.1

T:game.update.version:24
T:game.max_level:180
T:game.PKServer:0
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:8
T:game.min_global_chat_usable_level:10
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0

T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500
T:db.user.thread:4

S game.guild_icon_base_url:
S:game.url_list:guild.url|

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment

S:game.mem_usage_info_save_interval:9999999
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
S game.exp_rate:5
S game.item_drop_rate:1
S game.gold_drop_rate:2
S game.chaos_drop_rate:2
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30

Auth.opt

 Spoiler

#Database configuration
auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:sa


auth.clients.maxpublicserveridx:10

#Server Index Offset Column Name
sql.db_account.column.serveridxoffset:server_list_ mask

#include config in common.opt
%include:common.opt

When Starting the Sherlock Game Server it already loads 48 items , is that normal?



Note the GameContent Is blocked, might that be the problem?`
I think that it is weird, that literally nothing happens when starting the launcher.

What I did:
I downloaded the 9.1 client provided in the list of clients (the german one, but changed country etc to DE so that should not be a problem), I did not replace the Sframe even tho that doesn't change anything (have already tried it).
Starting the official Launcher would just patch my client to 9.4 right?

[Exterminator-[Fury]]

Been using your tables you mentioned randomitemoption and mixresource. As i told before it works but after you enchant multiply armors rapidly it freezes the server. There are more tables linked to this.

Originally Posted by アルカード

once i find a free time sure.




Umm i already told you where to checke error.I already offer you a few tips how to make fixes....

[ThunderNikk]

@

Your security software could be keeping the game from starting.

[thefear511]

Hello, so I've been messing with map editing, by any chance, someone has the Katan NFMV
it's m_006_004, yes "NFMV" not "NFM",
if you're still questioning, I'm trying to delete a part of Katan so I need that file if there's any x.x I tried dumping didn't find it.

[ThunderNikk]

Haven't ever seen an NFMV file extension in any client I have dumped yet.

Why do you think there is one?