|
You last visited: Today at 17:18
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
07/17/2013, 22:44
|
#2116
|
elite*gold: 0 
Join Date: Dec 2011
Posts: 67
Received Thanks: 5
|
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
|
#2117
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
Fragmentation is problematic. Items tear apart the server shuts down.
How can i fixed
|
|
|
|
|
07/18/2013, 02:47
|
#2118
|
elite*gold: 0
Join Date: Jul 2013
Posts: 20
Received Thanks: 1
|
A little more information Teta...
|
|
|
|
|
07/18/2013, 05:27
|
#2119
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Quote:
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...
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
|
#2120
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
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
|
|
|
|
|
07/18/2013, 12:17
|
#2121
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
Quote:
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.
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
|
#2122
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
I do not know, I've added. Did not improve.
|
|
|
|
|
07/18/2013, 12:33
|
#2123
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
Quote:
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
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
|
#2124
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
yes , i did restart.. and try, but server shutdowns 
|
|
|
|
|
07/18/2013, 12:52
|
#2125
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
Quote:
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
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
|
#2126
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
Are you using Team Viewer? I give my team id password. Take a look.
|
|
|
|
|
07/18/2013, 12:58
|
#2127
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
Quote:
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.
|
|
|
|
|
07/18/2013, 13:03
|
#2128
|
elite*gold: 0
Join Date: Apr 2013
Posts: 136
Received Thanks: 16
|
How will ? When you're finished, I give team id password.
Decompose Resource ;
|
|
|
|
|
07/18/2013, 16:19
|
#2129
|
elite*gold: 0
Join Date: Apr 2011
Posts: 278
Received Thanks: 73
|
Quote:
Originally Posted by c1ph3r
^
|
Ive added a simple fix before how to edit dropgroupresource without problems in decompose 
Quote:
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 |
|
|
|
|
|
07/18/2013, 16:43
|
#2130
|
elite*gold: 0
Join Date: Sep 2008
Posts: 1,606
Received Thanks: 1,210
|
Quote:
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:
Code:
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')
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 17:19.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
