|
You last visited: Today at 10:12
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.
10/21/2013, 16:15
|
#2641
|
elite*gold: 0 
Join Date: Sep 2013
Posts: 6
Received Thanks: 0
|
i've checked my ports, all the ports indicated in the tuto are opened, i've tried with an over client, i've got the same error of diconnection from the server .. I don't know from where is the problem .. have you got an other idea ?
|
|
|
|
10/21/2013, 17:36
|
#2642
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
Quote:
Originally Posted by loolie51
i've checked my ports, all the ports indicated in the tuto are opened, i've tried with an over client, i've got the same error of diconnection from the server .. I don't know from where is the problem .. have you got an other idea ?
|
You could try re-compressing your .opt files. Everything in them is correct and I really don't have any other ideas as to why you are getting this error.
|
|
|
|
|
10/22/2013, 18:00
|
#2643
|
elite*gold: 0
Join Date: Dec 2012
Posts: 68
Received Thanks: 2
|
Hello epvpers
today i was trying to remove the ice maiden recharge card from drops table and i use this sql code :
Code:
------ Ice Madien Recharge card.
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
and the result is :
Code:
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
(0 row(s) affected)
but, the cards still dropping.
Please help
|
|
|
|
|
10/22/2013, 18:37
|
#2644
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
First off you have 20 lines of code doing the same thing...
Code:
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
When it can be done with just 9 that all do different lines in the drop group resource.
Code:
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_00 = 0 , drop_max_count_00 = 0 , drop_percentage_00 = .00000000 WHERE drop_item_id_00 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_01 = 0 , drop_max_count_01 = 0 , drop_percentage_01 = .00000000 WHERE drop_item_id_01 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_02 = 0 , drop_max_count_02 = 0 , drop_percentage_02 = .00000000 WHERE drop_item_id_02 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_03 = 0 , drop_max_count_03 = 0 , drop_percentage_03 = .00000000 WHERE drop_item_id_03 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_04 = 0 , drop_max_count_04 = 0 , drop_percentage_04 = .00000000 WHERE drop_item_id_04 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_05 = 0 , drop_max_count_05 = 0 , drop_percentage_05 = .00000000 WHERE drop_item_id_05 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_06 = 0 , drop_max_count_06 = 0 , drop_percentage_06 = .00000000 WHERE drop_item_id_06 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_07 = 0 , drop_max_count_07 = 0 , drop_percentage_07 = .00000000 WHERE drop_item_id_07 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_08 = 0 , drop_max_count_08 = 0 , drop_percentage_08 = .00000000 WHERE drop_item_id_08 = 540077
UPDATE Arcadia.dbo.DropGroupResource SET drop_min_count_09 = 0 , drop_max_count_09 = 0 , drop_percentage_09 = .00000000 WHERE drop_item_id_09 = 540077
Other than that I would check your item ID, your SQL results clearly said that 0 rows were affected which means it did not change anything.
That probably means that 540077 was not found as a drop item located in drop group resource in any of that code.
|
|
|
|
|
10/22/2013, 20:35
|
#2645
|
elite*gold: 0
Join Date: Dec 2012
Posts: 68
Received Thanks: 2
|
540077 ID is already exist in the Item table but, its not in the drops table.
this is weird.
|
|
|
|
|
10/22/2013, 20:43
|
#2646
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
Quote:
Originally Posted by Nada92
540077 ID is already exist in the Item table but, its not in the drops table.
this is weird.
|
Check if there is more than one item resource entry for the ice maiden recharge card.
Then check if the other ID entries are in the drop group resource.
I can't check now because I am not in front of my databases computer, but I can check for you in a couple of hours.
|
|
|
|
|
10/22/2013, 20:51
|
#2647
|
elite*gold: 70
Join Date: Dec 2012
Posts: 278
Received Thanks: 156
|
Quote:
Originally Posted by Nada92
540077 ID is already exist in the Item table but, its not in the drops table.
this is weird.
|
It's on MonsterDropTableResource .
|
|
|
|
|
10/22/2013, 21:40
|
#2648
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
Doesn't MonsterDropTableResource just link to drop group IDs in DropGroupResource?
|
|
|
|
|
10/22/2013, 21:45
|
#2649
|
elite*gold: 0
Join Date: Dec 2012
Posts: 68
Received Thanks: 2
|
Quote:
Originally Posted by thndr
Check if there is more than one item resource entry for the ice maiden recharge card.
Then check if the other ID entries are in the drop group resource.
I can't check now because I am not in front of my databases computer, but I can check for you in a couple of hours.
|
Thanks for your help.
Quote:
Originally Posted by .BlackCat.
It's on MonsterDropTableResource .
|
Thank you very much, you are awesome!
now it gave me this :
Code:
(81 row(s) affected)
Appreciate it 
I need your help again please..
i couldn't know why i can't use any of these items..
it says "You do not meet the necessary condition to equip that item."
Code:
3630704 : Nano Mask
3630705 : Nano Boots
3630706 : Nano Gloves
3630707 : Nanosuit
3630708 : Biker Helmet
3630709 : Biker Boots
3630710 : Biker Gloves
3630711 : Biker Suit
3630712 : Samauri Crown
3630713 : Samauri Boots
3630714 : Samauri Gauntlet
3630715 : Samauri Armor
3630716 : Joker Mask
3630717 : Joker Boots
3630718 : Joker Gloves
3630719 : Joker Suit
3630720 : Cowboy Hat
3630721 : Cowboy Boots
3630722 : Cowboy Gloves
3630723 : Cowboy Suit
3630724 : Pharoah Crown
3630725 : Pharoah Boots
3630726 : Pharoah Gloves
3630727 : Pharoah Suit
im using the 8.1 server files by al7rob123
thank you so much and i really appreciate what you guys doing for us ^^
|
|
|
|
|
10/23/2013, 17:02
|
#2650
|
elite*gold: 0
Join Date: Oct 2013
Posts: 36
Received Thanks: 1
|
questions for devs
wondering
1/ would it be possible to set taming rates in server config
2/ are the new mob cards in the db is what r ids
Medusa Card
Black Widow Card
Microraptor Card
Bone Dragon Card
3/ how do i get in the new dungeons by warping
Dungeon in Palmir Remains
Dungeon in Relics of Arid Moonlight
Dungeon in Crystal Valley
Dungeon in Valmore Mine
|
|
|
|
|
10/23/2013, 17:28
|
#2651
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
1. I am pretty sure you need to set taming rates with SQL script, I don't think you can do it in the server .opt files like drop rates, and experience rates.
2. and 3. are not in the 8.1 server files.
I have the taming SQL script at home I can PM it to you later. It is also posted in these forums and I am pretty sure in this help thread, if you want to do some searching on your own.
|
|
|
|
|
10/23/2013, 18:17
|
#2652
|
elite*gold: 0
Join Date: Oct 2013
Posts: 36
Received Thanks: 1
|
i am useing 8.2 server files from royal repack
|
|
|
|
|
10/23/2013, 19:11
|
#2653
|
elite*gold: 0
Join Date: Jan 2013
Posts: 72
Received Thanks: 5
|
Quote:
Originally Posted by kodiaktommy616
wondering
1/ would it be possible to set taming rates in server config
2/ are the new mob cards in the db is what r ids
Medusa Card
Black Widow Card
Microraptor Card
Bone Dragon Card
3/ how do i get in the new dungeons by warping
Dungeon in Palmir Remains
Dungeon in Relics of Arid Moonlight
Dungeon in Crystal Valley
Dungeon in Valmore Mine
|
For the third point, you should go in the InstanceDungeonResource you will find them.
For the new cards, i don't search them yet but if i find i will update my post 
|
|
|
|
|
10/23/2013, 19:53
|
#2654
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,913
Received Thanks: 1,491
|
Quote:
Originally Posted by kodiaktommy616
i am useing 8.2 server files from royal repack
|
Then you are using 8.1 server files with some 8.2 content, there are no 8.2 server files.
For points 2 and 3 then you could ask in Strange's / Royal's thread. They or other people using the repack would know the most about it.
|
|
|
|
|
10/23/2013, 20:22
|
#2655
|
elite*gold: 0
Join Date: Jan 2013
Posts: 72
Received Thanks: 5
|
Hi i have two questions plz
First : when i summon buta he is invisible, if someone can tell me wich ressource must i add in my game folder to correct this bug plz
Secondly : I would like to modify monster's name. After add them in the StringResource and StringResource_FR (i'm a french player) how may i do to make this visible in game plz ?
Thanks
|
|
|
|
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 10:14.
|
|
![[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}
