Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 05:21

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #2641
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
Quote:
Originally Posted by loolie51 View Post
I'm going to try with an over client, just a question (stupid or not) how I can know my windows port ?
You can check your active ports by typing netstat at a command prompt.

Quote:
Originally Posted by loolie51 View Post
And, are there some files in the download folder , i should copy/paste on the client folder ?
If you are asking if there are client files that come with the server files the answer is no.



ThunderNikk is offline  
Old   #2642
 
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 ?


loolie51 is offline  
Old   #2643
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
Quote:
Originally Posted by loolie51 View Post
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.
ThunderNikk is offline  
Old   #2644
 
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


Nada92 is offline  
Old   #2645
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
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.
ThunderNikk is offline  
Old   #2646
 
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.
Nada92 is offline  
Old   #2647
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
Quote:
Originally Posted by Nada92 View Post
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.
ThunderNikk is offline  
Thanks
1 User
Old   #2648
 
elite*gold: 70
Join Date: Dec 2012
Posts: 277
Received Thanks: 155
Quote:
Originally Posted by Nada92 View Post
540077 ID is already exist in the Item table but, its not in the drops table.
this is weird.


It's on MonsterDropTableResource .
.BlackCat. is offline  
Thanks
1 User
Old   #2649
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
Doesn't MonsterDropTableResource just link to drop group IDs in DropGroupResource?
ThunderNikk is offline  
Old   #2650
 
elite*gold: 0
Join Date: Dec 2012
Posts: 68
Received Thanks: 2
Quote:
Originally Posted by thndr View Post
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. View Post
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 ^^
Nada92 is offline  
Old   #2651
 
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
kodiaktommy616 is offline  
Old   #2652
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
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.
ThunderNikk is offline  
Old   #2653
 
elite*gold: 0
Join Date: Oct 2013
Posts: 36
Received Thanks: 1
i am useing 8.2 server files from royal repack
kodiaktommy616 is offline  
Old   #2654
 
elite*gold: 0
Join Date: Jan 2013
Posts: 72
Received Thanks: 5
Quote:
Originally Posted by kodiaktommy616 View Post
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
cece1812 is offline  
Old   #2655
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,137
Received Thanks: 1,025
Quote:
Originally Posted by kodiaktommy616 View Post
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.


ThunderNikk is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
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...
31 Replies - EO PServer Hosting



All times are GMT +1. The time now is 05:21.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.