[Help Thread] Please post your questions here.

07/17/2013 22:44 iBreedPetZ#2116
Do you have the same client e.g. 6.2 and they same auth and herlock 6.2 ? itīs have to be similar.
07/18/2013 00:56 TRTeta#2117
Fragmentation is problematic. Items tear apart the server shuts down.

How can i fixed
07/18/2013 02:47 Excalibur-Rappelz#2118
A little more information Teta...
07/18/2013 05:27 ThunderNikk#2119
Quote:
Originally Posted by TRTeta View Post
Fragmentation is problematic. Items tear apart the server shuts down.

How can i fixed
Add the following to your dbo.DropGroupResource table...

Code:
-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
07/18/2013 11:32 TRTeta#2120
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

[Only registered and activated users can see links. Click Here To Register...]
07/18/2013 12:17 c1ph3r#2121
Quote:
Originally Posted by TRTeta View Post
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

[Only registered and activated users can see links. Click Here To Register...]
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.
Code:
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')
07/18/2013 12:28 TRTeta#2122
I do not know, I've added. Did not improve.

[Only registered and activated users can see links. Click Here To Register...]
07/18/2013 12:33 c1ph3r#2123
Quote:
Originally Posted by TRTeta View Post
I do not know, I've added. Did not improve.

[Only registered and activated users can see links. Click Here To Register...]
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

Code:
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!
07/18/2013 12:36 TRTeta#2124
yes , i did restart.. and try, but server shutdowns :(
07/18/2013 12:52 c1ph3r#2125
Quote:
Originally Posted by c1ph3r View Post
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

Code:
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!
^
07/18/2013 12:56 TRTeta#2126
Are you using Team Viewer? I give my team id password. Take a look.
07/18/2013 12:58 c1ph3r#2127
Quote:
Originally Posted by TRTeta View Post
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.
07/18/2013 13:03 TRTeta#2128
How will ? When you're finished, I give team id password.

Decompose Resource ;

[Only registered and activated users can see links. Click Here To Register...]
07/18/2013 16:19 TheSuperKiller#2129
Quote:
Originally Posted by c1ph3r View Post
^
Ive added a simple fix before how to edit dropgroupresource without problems in decompose :D

Quote:
Originally Posted by TheSuperKiller View Post
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 :D
07/18/2013 16:43 c1ph3r#2130
Quote:
Originally Posted by TheSuperKiller View Post
Ive added a simple fix before how to edit dropgroupresource without problems in decompose :D
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: