[Help Thread] Please post your questions here.

[iBreedPetZ]

Do you have the same client e.g. 6.2 and they same auth and herlock 6.2 ? it´s have to be similar.

[TRTeta]

Fragmentation is problematic. Items tear apart the server shuts down.

How can i fixed

[Excalibur-Rappelz]

A little more information Teta...

[ThunderNikk]

Originally Posted by TRTeta

Fragmentation is problematic. Items tear apart the server shuts down.

How can i fixed

Add the following to your dbo.DropGroupResource table...

-3002001	705001	1	1	0.25	705001	2	2	0.5	705001	3	3	0.25	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
-3002002	705001	2	2	0.25	705001	3	3	0.5	705001	4	4	0.25	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
-3002003	705001	3	3	0.25	705001	4	4	0.5	705001	5	5	0.25	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
-3002004	705001	6	6	0.25	705001	7	7	0.5	705001	8	8	0.25	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
-3002005	705001	24	24	0.25	705001	25	25	0.5	705001	26	26	0.25	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

[TRTeta]

Bro I've added it now. Still did not improve. Items smash,come is one of rupees, and the server shuts down. shred item is problematic.

Has a bug

[c1ph3r]

Originally Posted by TRTeta

Bro I've added it now. Still did not improve. Items smash,come is one of rupees, and the server shuts down. shred item is problematic.

Has a bug

Can you tell me how did you add these lines? If they are in the dropgroupresource it must give you something else than a rupee at least...

This is the complete SQL Script.

INSERT INTO dbo.DropGroupResource VALUES ('-3002001','705001','1','1','0.25','705001','2','2','0.5','705001','3','3','0.25','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')
INSERT INTO dbo.DropGroupResource VALUES ('-3002002','705001','2','2','0.25','705001','3','3','0.5','705001','4','4','0.25','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')
INSERT INTO dbo.DropGroupResource VALUES ('-3002003','705001','3','3','0.25','705001','4','4','0.5','705001','5','5','0.25','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')
INSERT INTO dbo.DropGroupResource VALUES ('-3002004','705001','6','6','0.25','705001','7','7','0.5','705001','8','8','0.25','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')
INSERT INTO dbo.DropGroupResource VALUES ('-3002005','705001','24','24','0.25','705001','25','25','0.5','705001','26','26','0.25','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')

[TRTeta]

I do not know, I've added. Did not improve.

[c1ph3r]

Originally Posted by TRTeta

I do not know, I've added. Did not improve.

Did you restart the server?

The Server crashes if one of the needed dropgroups from the decomposeresource is missing...so there are only 12 possibilities...

do something like this

SELECT distinct(DROPG.id) from dbo.DropGroupResource as DROPG
JOIN dbo.DecomposeResource as DECOMPOSE
ON DECOMPOSE.type_value_02 = DROPG.id

this should return you 12 lines. If these 12 lines are returned there is a wrong database in your .opt files or something like this...since your ip and domain is changing every two hours i think there is messed up a lot in your files...

sorry but in my opinion it's impossible to help somebody who is providing a lot of wrong data all the time...looking at your other thread about the guildicons...how often do you provide the wrong ip for "the show"?

I want to see the databaseconfiguration of your gameserver (without database user and passwordhash) but orininal no bullshit for the show.

I want to see a screenshot of the result of the sql select statement.

I want to see a screenshot of you decomposeresource!

Otherwise it's impossible to help you!

[TRTeta]

yes , i did restart.. and try, but server shutdowns

[c1ph3r]

Originally Posted by c1ph3r

Did you restart the server?

The Server crashes if one of the needed dropgroups from the decomposeresource is missing...so there are only 12 possibilities...

do something like this

SELECT distinct(DROPG.id) from dbo.DropGroupResource as DROPG
JOIN dbo.DecomposeResource as DECOMPOSE
ON DECOMPOSE.type_value_02 = DROPG.id

this should return you 12 lines. If these 12 lines are returned there is a wrong database in your .opt files or something like this...since your ip and domain is changing every two hours i think there is messed up a lot in your files...

sorry but in my opinion it's impossible to help somebody who is providing a lot of wrong data all the time...looking at your other thread about the guildicons...how often do you provide the wrong ip for "the show"?

I want to see the databaseconfiguration of your gameserver (without database user and passwordhash) but orininal no bullshit for the show.

I want to see a screenshot of the result of the sql select statement.

I want to see a screenshot of you decomposeresource!

Otherwise it's impossible to help you!

^

[TRTeta]

Are you using Team Viewer? I give my team id password. Take a look.

[c1ph3r]

Originally Posted by TRTeta

Are you using Team Viewer? If you want to give team id password. Take a look.

I'm at work at the moment it's impossible to check via TeamViewer for me at the moment.

[TRTeta]

How will ? When you're finished, I give team id password.

Decompose Resource ;

[TheSuperKiller]

Originally Posted by c1ph3r

^

Ive added a simple fix before how to edit dropgroupresource without problems in decompose

Originally Posted by TheSuperKiller

Firstly edit your dropgroupresource as you wish ... ( FIRSTLY ... order is important here )
secondly you should make 14 dropgroupresource values by your own self ,,, that 14 values you can take it by ( use arcadia select * from dropgroupresource where id in ( select type_value_02 from decomposeresource ) ) .... just make a copy of them with another ID's

and edit the decomposeresource and change type_value_02 to your values ....

then the server will run without any problem at all

[c1ph3r]

Originally Posted by TheSuperKiller

Ive added a simple fix before how to edit dropgroupresource without problems in decompose

I never get your tutorial because it's possible to change the dropgroups of the decompose resource directly...only important thing is that there are no 0% values with items and every line will result 100%...that's all...the order you are doing your steps is totally unimportant since the gs will never realize if you edited the id's in the decompose resource at first or modified the dropgroupresource at first...the database do not share these things with the gameserver...

@Teta

use this script it should solve your problem:

 Spoiler

DELETE FROM dbo.DropGroupResource where id=-3002005
or id=-3002004
or id=-3002003
or id=-3002002
or id=-3002001
or id=-3001048
or id=-3001027
or id=-3001006
or id=-3000985
or id=-3000964
or id=-3000942
or id=-3000391
INSERT INTO dbo.DropGroupResource VALUES ('-3002005','705001','24','24','0.25000000','705001','25','25','0.50000000','705001','26','26','0.25000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3002004','705001','6','6','0.25000000','705001','7','7','0.50000000','705001','8','8','0.25000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3002003','705001','3','3','0.25000000','705001','4','4','0.50000000','705001','5','5','0.25000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3002002','705001','2','2','0.25000000','705001','3','3','0.50000000','705001','4','4','0.25000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3002001','705001','1','1','0.25000000','705001','2','2','0.50000000','705001','3','3','0.25000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3001048','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','20','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3001027','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','16','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3001006','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','13','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3000985','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','10','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3000964','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','7','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3000942','701001','3','8','0.06250000','701002','2','7','0.06250000','701003','1','6','0.06250000','702001','3','8','0.06250000','702002','2','7','0.06250000','702003','1','6','0.06250000','1100101','10','100','0.31230000','1100102','4','8','0.31190000','1100114','1','4','0.00080000','0','0','0','0.00000000')
INSERT INTO dbo.DropGroupResource VALUES ('-3000391','-3000395','1','1','0.99500000','-3000396','1','1','0.00500000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000','0','0','0','0.00000000')