You last visited: Today at 00:24
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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: 251
Join Date: Dec 2012
Posts: 4,949
Received Thanks: 1,506
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 +2. The time now is 00:24 .