[Help Thread] Please post your questions here.

Sherock · 05/19/2015, 10:08

Quote:

Originally Posted by thndr

Did you read the table you posted earlier???

Spoiler

USE [Telecaster]
GO

/****** Object: Table [dbo].[Character] Script Date: 17/05/2015 04:51:49 م ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Character](
[sid] [int] IDENTITY(1,1) NOT NULL,
[name] [nvarchar](61) NOT NULL,
[account] [varchar](60) NOT NULL,
[account_id] [int] NOT NULL,
[slot] [int] NOT NULL,
[x] [int] NOT NULL,
[y] [int] NOT NULL,
[z] [int] NOT NULL,
[layer] [int] NOT NULL,
[race] [int] NOT NULL,
[sex] [int] NOT NULL,
[exp] [bigint] NULL,
[last_decreased_exp] [bigint] NULL,
[lv] [int] NOT NULL,
[max_reached_level] [int] NOT NULL,
[hp] [int] NOT NULL,
[mp] [int] NOT NULL,
[stamina] [int] NOT NULL,
[havoc] [int] NOT NULL,
[jlv] [int] NOT NULL,
[jp] [int] NOT NULL,
[total_jp] [int] NOT NULL,
[job_0] [int] NOT NULL,
[job_1] [int] NOT NULL,
[job_2] [int] NOT NULL,
[jlv_0] [int] NOT NULL,
[jlv_1] [int] NOT NULL,
[jlv_2] [int] NOT NULL,
[immoral_point] [int] NOT NULL,
[cha] [int] NOT NULL,
[pkc] [int] NOT NULL,
[dkc] [int] NOT NULL,
[huntaholic_point] [int] NOT NULL,
[create_time] [datetime] NOT NULL,
[delete_time] [datetime] NOT NULL,
[login_time] [datetime] NOT NULL,
[logout_time] [datetime] NOT NULL,
[login_count] [int] NOT NULL,
[play_time] [int] NOT NULL,
[belt_00] [bigint] NOT NULL,
[belt_01] [bigint] NOT NULL,
[belt_02] [bigint] NOT NULL,
[belt_03] [bigint] NOT NULL,
[belt_04] [bigint] NOT NULL,
[belt_05] [bigint] NOT NULL,
[permission] [int] NOT NULL,
[skin_color] [int] NOT NULL,
[model_00] [int] NOT NULL,
[model_01] [int] NOT NULL,
[model_02] [int] NOT NULL,
[model_03] [int] NOT NULL,
[model_04] [int] NOT NULL,
[job] [int] NOT NULL,
[gold] [bigint] NOT NULL,
[party_id] [int] NOT NULL,
[guild_id] [int] NOT NULL,
[prev_guild_id] [int] NOT NULL,
[flag_list] [varchar](4000) NOT NULL,
[client_info] [varchar](4096) NOT NULL,
[job_depth] [int] NOT NULL,
[summon_0] [int] NOT NULL,
[summon_1] [int] NOT NULL,
[summon_2] [int] NOT NULL,
[summon_3] [int] NOT NULL,
[summon_4] [int] NOT NULL,
[summon_5] [int] NOT NULL,
[main_summon] [int] NOT NULL,
[sub_summon] [int] NOT NULL,
[remain_summon_time] [int] NOT NULL,
[pet] [int] NOT NULL,
[chaos] [int] NOT NULL,
[adv_chat_count] [int] NOT NULL,
[name_changed] [int] NULL,
[auto_used] [int] NOT NULL,
[guild_block_time] [bigint] NOT NULL,
[pkmode] [tinyint] NOT NULL,
[otp_value] [int] NOT NULL,
[otp_date] [datetime] NOT NULL,
[chat_block_time] [int] NOT NULL,
[GUILD_SID] [int] NULL,
[PREV_GUILD_SID] [int] NULL,
[DEFAULT_WEAPON_SID] [bigint] NOT NULL,
[DEFAULT_WEAPON_CODE] [int] NOT NULL,
[DEFAULT_ARMOR_SID] [bigint] NOT NULL,
[DEFAULT_ARMOR_CODE] [int] NOT NULL,
[DEFAULT_BAG_SID] [bigint] NOT NULL,
[DEFAULT_BAG_CODE] [int] NOT NULL,
[IP] [real] NOT NULL,
[HUNTAHOLIC] [int] NOT NULL,
[REMAIN_CHAT_BLOCK_TIME] [int] NOT NULL,
[LOGOUT_DURATION] [int] NOT NULL,
[OUT_NAME_CHANGED] [int] NOT NULL,
CONSTRAINT [PK_IDX_Avatar] PRIMARY KEY NONCLUSTERED
(
[sid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],
CONSTRAINT [UQ__Characte__72E12F1B18B6AB08] UNIQUE NONCLUSTERED
(
[name] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_jp] DEFAULT ((100000000)) FOR [jp]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_gold] DEFAULT ((100000000)) FOR [gold]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_GUILD_SID] DEFAULT ((0)) FOR [GUILD_SID]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_PREV_GUILD_SID] DEFAULT ((0)) FOR [PREV_GUILD_SID]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_WEAPON_SID] DEFAULT ((0)) FOR [DEFAULT_WEAPON_SID]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_WEAPON_CODE] DEFAULT ((0)) FOR [DEFAULT_WEAPON_CODE]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_ARMOR_SID] DEFAULT ((0)) FOR [DEFAULT_ARMOR_SID]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_ARMOR_CODE] DEFAULT ((0)) FOR [DEFAULT_ARMOR_CODE]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_BAG_SID] DEFAULT ((0)) FOR [DEFAULT_BAG_SID]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_DEFAULT_BAG_CODE] DEFAULT ((0)) FOR [DEFAULT_BAG_CODE]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_IP] DEFAULT ((0)) FOR [IP]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_HUNTAHOLIC] DEFAULT ((0)) FOR [HUNTAHOLIC]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_REMAIN_CHAT_BLOCK_TIME] DEFAULT ((0)) FOR [REMAIN_CHAT_BLOCK_TIME]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_LOGOUT_DURATION] DEFAULT ((0)) FOR [LOGOUT_DURATION]
GO

ALTER TABLE [dbo].[Character] ADD CONSTRAINT [DF_Character_OUT_NAME_CHANGED] DEFAULT ((0)) FOR [OUT_NAME_CHANGED]
GO

What is this part for if there is no such place to add permission???

[permission] [int] NOT NULL,

I think you need to look at your character table more carefully.

oh shit ... thanks dear @@
what about guilds in 6.2 you know any thing about it ?
when i put guild info ( alt + g ... in 6.2 ) it gives me error page !

another thing i have 7.3 server files , if i want to hide the MP + HP as it was in 7.2 - 6.2 ... ect
what i have to do ?
is it hard ?

ThunderNikk · 05/19/2015, 13:02

1.

From ismokedrow's signature

2. I am not really sure.

Sherock · 05/20/2015, 05:31

Quote:

Originally Posted by thndr

1.

From ismokedrow's signature

2. I am not really sure.

thanks

-----------

when i made second server in the same IP - host -
9.1
and
7.2

i want to make PrincessAuroraServer support both , if it possible ?

ThunderNikk · 05/20/2015, 12:48

Quote:

Originally Posted by Sherock

i want to make PrincessAuroraServer support both , if it possible ?

Yeah I am pretty sure you can, especially if you are running the Auth emulator by glandu2

Sherock · 05/20/2015, 14:29

Quote:

Originally Posted by thndr

Yeah I am pretty sure you can, especially if you are running the Auth emulator by glandu2

thanks i'll try to understand how to run glandu2's Auth emulator

pprfds · 05/21/2015, 12:08

Hello

in epic 5.1 patch notes it was said "Pets will gain stat points with every level now."

so my question is

how was it before epic 5? gain stats but every 5 / 10 levels? or doesn't gain any stats and stats be the same as written in Statresource ?

thanks in advance

Kuchen31 · 05/21/2015, 13:11

Hello several questions:
1. How do use ä ü etc in String Resource? When i look for some others npcs in there that
have on of these in their names there is nothing special but when i use them and create
a new one its getting replaced with a "?". I already tried ä Didnt work
2. How do i create a new data.000 i wana use new models etc? Do i just have to create a new winrar archieve and rename it as data.000?
3. Changing the color of a name of a monster ? I mean i know that i can change the colours of text etc by using hex codes like this <#002929> but i cant write that in the string resource , so how is that done? Same question with the characters name.

ThunderNikk · 05/21/2015, 14:48

1. I am not sure I have never had to use those characters for my English US launch arguments. I assume they are being replaced with ? because of a translation issue were the game does not know how to decode them.

2. It is much more complicated than that. Data.000 is just an index file for all the other data.*** files which contain all of the clients resources. All of the important files are in the rest of the data.*** files. You would need to write your own program that understands the data.*** file structure.

Models are linked to some of those resources. You need a few different topics to research.

Since you can also use resourcing I will link that topic for reference as well...

The tools specified in that topic are older and have been replaced with better ones so do not concern your self with the tools of doing anything there. I have linked the topic only for reference of learning how the concept works.

Some explanations on working with the data files...

Some explanations on working with models...

And the most important model release...

3. I believe those are hard coded into the game server captain herlock.

sergeu1988 · 05/21/2015, 18:26

Tell me if you can, where the mistake here? to top guilds displayed

Spoiler

pprfds · 05/21/2015, 18:38

Quote:

Originally Posted by sergeu1988

Tell me if you can, where the mistake here? to top guilds displayed

Spoiler

$Query="SELECT Top 100 name , icon, dungeron_id, alliance_id, permission_name_1, name_changed, permission_set_1,pkc from Guild . dbo.Guild
where permission ='0' and name not like '@%' order by exp desc";

guild doesn't have a 'permission' column

sergeu1988 · 05/22/2015, 06:14

Where is the mistake? I do not understand

Spoiler

smoegsmoeg · 05/22/2015, 08:04

Hello Guys,

i have three questions. Since i've looked on the google already and could not find it - maybe you can help.

Server is Revolution 9.1

1) ID for Growth Potion Supreme / Superior (150+ & 170+)
2) ID for Soul Creature re-Training Potion (the one where you can reset the skills and try to get the skills you want)
3) What is the best way to buff myself and my pet?

thank you guys

cheers

beecloven · 05/22/2015, 13:25

Hi. I have a question.
What is that mean? "Caution: It is advised to not only firewall lock 1433 but if you MUST have external use to use a custom port and change it often couple with strict permission based database accounts."
I must block port 1433 in Windows Firewall or something like that?

ThunderNikk · 05/22/2015, 15:31

Quote:

Originally Posted by beecloven

Hi. I have a question.
What is that mean? "Caution: It is advised to not only firewall lock 1433 but if you MUST have external use to use a custom port and change it often couple with strict permission based database accounts."
I must block port 1433 in Windows Firewall or something like that?

Just don't open your database port in the firewall. That simple database access will be restricted to the computer that the databases are running on.

It is saying if you do open your database port so you can access it externally then use a custom port something that is not port 1433 that everyone else uses and also change your port often like a password.

Quote:

Originally Posted by smoegsmoeg

Hello Guys,

i have three questions. Since i've looked on the google already and could not find it - maybe you can help.

Server is Revolution 9.1

1) ID for Growth Potion Supreme / Superior (150+ & 170+)
2) ID for Soul Creature re-Training Potion (the one where you can reset the skills and try to get the skills you want)
3) What is the best way to buff myself and my pet?

thank you guys

cheers

Learn to fish.

1) select * from arcadia.dbo.ItemResource where icon_file_name like '%retraining%'

920013

2) select * from arcadia.dbo.ItemResource where icon_file_name like '%growth%'

900014
900015
900016
900017
900018

3) Hidden village buffs, Master class buffs, GM buffs. Make your hidden village buffer buff all three and you are set. Strange you would ask a "How to play the game" question though.

Saltaya · 05/22/2015, 15:36

Quote:

Originally Posted by sergeu1988

Where is the mistake? I do not understand

Spoiler

$Query="SELECT Top 100 name , icon, dungeron_id, alliance_id, permission_name_1, name_changed, permission_set_1, Guild from Guild. dbo.Guild";

$Result = mssql_query($Query);
?>
<table class="tabclass" >
<div id="spc_cont" style="color:#8D847C">
<div class="change_wrap">
<div class="list">
<center>

its called dungeon_id , NOT dungeron_id