[Help Thread] Please post your questions here.

[ninex]

Ok one more thing is there a console for Captnhook or Auth windows so i can see who is on the server ?? and thanks again Thndr

[Queeni]

Hallo Zusammen.

Eine Frage wo kann ich einstellen das,dass loot schneller verschwindet?

[Strange2010]

Originally Posted by ninex

Ok one more thing is there a console for Captnhook or Auth windows so i can see who is on the server ?? and thanks again Thndr

You can see how many players are online by clicking F2 while in Captain Herlock window . Example :

game.user_count   :  13

To see the account in your server [SQL Query]:

USE Auth
SELECT * FROM Account

To see the characters you have in your server [SQL Query]:

USE Telecaster
SELECT * FROM Character

To see the characters ONLINE [SQL Query]:

USE Telecaster
SELECT * FROM Character
WHERE login_time > logout_time

Originally Posted by Kuchen31

You are using raskim's database manager . Try inserting into sql manualy :

 Spoiler

USE [testarc]
GO

INSERT INTO [dbo].[MonsterResource]
([id]
,[monster_group]
,[name_id]
,[location_id]
,[model]
,[motion_file_id]
,[transform_level]
,[walk_type]
,[slant_type]
,[size]
,[scale]
,[target_fx_size]
,[camera_x]
,[camera_y]
,[camera_z]
,[target_x]
,[target_y]
,[target_z]
,[level]
,[grp]
,[magic_type]
,[race]
,[visible_range]
,[chase_range]
,[f_fisrt_attack]
,[f_group_first_attack]
,[f_response_casting]
,[f_response_race]
,[f_response_battle]
,[monster_type]
,[stat_id]
,[fight_type]
,[monster_skill_link_id]
,[material]
,[weapon_type]
,[attack_motion_speed]
,[ability]
,[standard_walk_spped]
,[standard_run_spped]
,[walk_speed]
,[run_speed]
,[attack_range]
,[hidesense_range]
,[hp]
,[mp]
,[attack_point]
,[magic_point]
,[defence]
,[magic_defence]
,[attack_speed]
,[magic_speed]
,[accuracy]
,[avoid]
,[magic_accuracy]
,[magic_avoid]
,[taming_id]
,[taming_percentage]
,[taming_exp_mod]
,[exp]
,[jp]
,[gold_drop_percentage]
,[gold_min]
,[gold_max]
,[chaos_drop_percentage]
,[chaos_min]
,[chaos_max]
,[exp_2]
,[jp_2]
,[gold_min_2]
,[gold_max_2]
,[chaos_min_2]
,[chaos_max_2]
,[drop_table_link_id]
,[texture_group]
,[local_flag]
,[script_on_dead])
VALUES
(<id, int,>
,<monster_group, int,>
,<name_id, int,>
,<location_id, int,>
,<model, varchar(256),>
,<motion_file_id, int,>
,<transform_level, int,>
,<walk_type, tinyint,>
,<slant_type, tinyint,>
,<size, decimal(10,2),>
,<scale, decimal(10,2),>
,<target_fx_size, decimal(10,2),>
,<camera_x, int,>
,<camera_y, int,>
,<camera_z, int,>
,<target_x, decimal(10,2),>
,<target_y, decimal(10,2),>
,<target_z, decimal(10,2),>
,<level, int,>
,<grp, int,>
,<magic_type, int,>
,<race, int,>
,<visible_range, int,>
,<chase_range, int,>
,<f_fisrt_attack, tinyint,>
,<f_group_first_attack, tinyint,>
,<f_response_casting, tinyint,>
,<f_response_race, tinyint,>
,<f_response_battle, tinyint,>
,<monster_type, tinyint,>
,<stat_id, int,>
,<fight_type, int,>
,<monster_skill_link_id, int,>
,<material, int,>
,<weapon_type, int,>
,<attack_motion_speed, int,>
,<ability, int,>
,<standard_walk_spped, int,>
,<standard_run_spped, int,>
,<walk_speed, int,>
,<run_speed, int,>
,<attack_range, decimal(10,2),>
,<hidesense_range, decimal(10,2),>
,<hp, int,>
,<mp, int,>
,<attack_point, int,>
,<magic_point, int,>
,<defence, int,>
,<magic_defence, int,>
,<attack_speed, int,>
,<magic_speed, int,>
,<accuracy, int,>
,<avoid, int,>
,<magic_accuracy, int,>
,<magic_avoid, int,>
,<taming_id, int,>
,<taming_percentage, decimal(12,4),>
,<taming_exp_mod, decimal(10,2),>
,<exp, int,>
,<jp, int,>
,<gold_drop_percentage, int,>
,<gold_min, int,>
,<gold_max, int,>
,<chaos_drop_percentage, int,>
,<chaos_min, int,>
,<chaos_max, int,>
,<exp_2, int,>
,<jp_2, int,>
,<gold_min_2, int,>
,<gold_max_2, int,>
,<chaos_min_2, int,>
,<chaos_max_2, int,>
,<drop_table_link_id, int,>
,<texture_group, int,>
,<local_flag, int,>
,<script_on_dead, varchar(256),>)
GO

[tokesbowls]

Hello,
How do i change the lvl cap for pets? where would it be located at?

[Strange2010]

Originally Posted by tokesbowls

Hello,
How do i change the lvl cap for pets? where would it be located at?

Never tried it but it's the SummonLevelResource table .

[c1ph3r]

Originally Posted by tokesbowls

Hello,
How do i change the lvl cap for pets? where would it be located at?

The Pets Level Cap is hardcoded in the GS. IT'S IMPOSSIBLE TO CHANGE THE LVLCAP OF PETS SINCE 7.4

[Serarisha]

Hallo ihr Lieben,

ich habe bereits google und die SuFu hier gequält, allerdings bin ich zu keiner Lösung gekommen, auch das lesen von Threads die nicht zu meinem Problem gehören habe ich gelesen und nicht einfach nur überflogen wie einige das vllt tun.^^
Folgendes Problem:

Die Serverfiles und der Client sind beide auf 8.1, kann auch connecten, solang der Server auf meinem Rechner liegt. Sobald ich ihn dann auf den Root "schmeiße" klappt der log in entweder nicht, oder NPC's reden nur halbe Sätze oder sind gar nicht vorhanden und wenn man versucht einen Mob zu finden, sucht man vergebens. Kann mir einer sagen, wodran das liegen könnte? Die Datenbanken sind vorhanden.

Selbst bei Hamachii klappt das nicht.

Und bitte keine Klischees von wegen Frauen und Technik, danke. :P

[tokesbowls]

Originally Posted by c1ph3r

The Pets Level Cap is hardcoded in the GS. IT'S IMPOSSIBLE TO CHANGE THE LVLCAP OF PETS SINCE 7.4

So then i cant get pets past 170?, Ive added the script to db and so forth, Just deosnt work. could you help me please and thank you


Ill just be straight up, Im having issues converting these .lua to english. Its basic stuff that should work but it tells me error ingame. issuse are such as custom shop intro's, (its in german). when i change to the german text to english it doent work. im realy confused as to why. Id be willing to offer retail gold for some help, or even cash through paypall, western union. or hey if you just wanna help for nothing, thats always welcome to :-)

Thank you again

[Order99]

Originally Posted by thndr

It sounds like you may have the wrong sframe or client for your server files.

that's right !
i fixed the .bat launcher and the sframe.exe
thanks dude ,

one other thing the traders in show's me problem in the shops it's like no picture's for the stuff and a price of too many nmbrzz nut you still can buy them :\

also i'm locked in the prison :O
how can i fix it

[ThunderNikk]

Originally Posted by Order99

one other thing the traders in show's me problem in the shops it's like no picture's for the stuff and a price of too many nmbrzz nut you still can buy them :\

Still sounds like you do not have the correct sframe for your server files.

Originally Posted by Order99

also i'm locked in the prison :O
how can i fix it

USE [Telecaster]
GO

UPDATE [dbo].[Character]

SET [auto_used] = 0

[Amaady]

Hi guys ..

I need a function that works when target death. A function like "on_player_dead" but i need it to work on the killer ..

*This function must be work just on the players not monsters .

Thank you in advance ..

[Queeni]

Hallo zusammen mein server schmiert zu zeit öfter ab da steht dann immer
CaptianHerlockServer.exe funktioniert nicht mehr und muss beendet werden kann mir einer sagen woran das liegt?

----------------

Hi my server clog more often from time since then is always
CaptianHerlockServer.exe no longer works and must be completed one tell me why this is?

[xyoyx]

Hi all,
I want to do a server but I have a problem.
I do all Like the new tut, for installation of sql 2012, and all good.
The error is auth dB init error ...

I Know for the search Button etc ... But I have do all the other post say so ...
Ps : I have sql 2012, windows 8 64 bit and the 7.4-8.1 files ( Like the tutorial )
Maybe a problem With my .opt ?

Screen of the bug:

 Spoiler

I have :



(The same as the new guide)

My Auth opt files :

 Spoiler

S db.auth.server:127.0.0.1
S db.auth.name:Auth
S db.auth.account:sa
S db.auth._password:
S app.name:Auth Server
S log.ip:127.0.0.1
S db.auth.port:1433
S io.auth.port:8841
N db.auth.use_webauth:0
N db.auth.use_md5:0
N db.auth.debug_md5:0
N db.auth.md5_key:2011

I use the search button on this tread and on the forum but i do and don't work, please help me :3

Bye all and ty

ps : sorry for my bad english :$

[ThunderNikk]

Originally Posted by xyoyx

I use the search button on this tread and on the forum but i do and don't work, please help me :3

You didn't search very hard.

This was my reply to this exact issue on page 224 of this thread.

Originally Posted by thndr

You did something wrong while configuring your database ownership to sa

Setting sa password

Configuring the .opt files with sa password

Compressing the .opt files

or Have a port error in the .opt files

[xyoyx]

You didn't search very hard.

This was my reply to this exact issue on page 224 of this thread.

Quote:
Originally Posted by thndr View Post
You did something wrong while configuring your database ownership to sa

Setting sa password

Configuring the .opt files with sa password

Compressing the .opt files

or Have a port error in the .opt files

I already attempt that.
I have open sql 2012 management, then go in security, login and right clic on "sa" then i clic properties.
Here i have change the password by "123"
clic "ok"
after i go on opt and add to the line password : 123
I compress but still the same error :x

I do something wrong or forget ?

For the port error how can I know ?