Drops

07/04/2018 14:33 Mc-Diesel#1
Hello Guy's

I Was Searching For Query to Add multiply Drops [ Full Degree to Mobs ]
But i only Found Single Query's [add Only One item To One Mobs ]
Any Idea Or Help About Adding full Degree to Multiply Mobs ?
07/04/2018 20:36 blapanda#2
Seems like you are lacking some basic php skills.

Just go for the failsafe methode. If this is your code

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1337, 100) 
where "1, 1337, 100" are to read as "service, mob ID, item ID", then copy that snippet and paste it multiple times and adjust the item ID (from 100 counting forward) continuously like this:

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1337, 100)
INSERT INTO _Table_ABC
VALUES (1, 1337, 101)
INSERT INTO _Table_ABC
VALUES (1, 1337, 102)
INSERT INTO _Table_ABC
VALUES (1, 1337, 103)
... 
Want a different mob? Copy the cluster again and change the mob ID from 1337 to 1338 in this case:

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1338, 100)
INSERT INTO _Table_ABC
VALUES (1, 1338, 101)
INSERT INTO _Table_ABC
VALUES (1, 1338, 102)
INSERT INTO _Table_ABC
VALUES (1, 1338, 103)
... 
and so on ...

On the other hand, if you want a professional code, which handles this within few lines, either consult the internet or pay someone to do it for you. :)
Have fun!
07/04/2018 22:06 Mc-Diesel#3
Quote:
Originally Posted by blapanda View Post
Seems like you are lacking some basic php skills.

Just go for the failsafe methode. If this is your code

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1337, 100) 
where "1, 1337, 100" are to read as "service, mob ID, item ID", then copy that snippet and paste it multiple times and adjust the item ID (from 100 counting forward) continuously like this:

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1337, 100)
INSERT INTO _Table_ABC
VALUES (1, 1337, 101)
INSERT INTO _Table_ABC
VALUES (1, 1337, 102)
INSERT INTO _Table_ABC
VALUES (1, 1337, 103)
... 
Want a different mob? Copy the cluster again and change the mob ID from 1337 to 1338 in this case:

PHP Code:
USE Database_XYZ
INSERT INTO _Table_ABC
VALUES (1, 1338, 100)
INSERT INTO _Table_ABC
VALUES (1, 1338, 101)
INSERT INTO _Table_ABC
VALUES (1, 1338, 102)
INSERT INTO _Table_ABC
VALUES (1, 1338, 103)
... 
and so on ...

On the other hand, if you want a professional code, which handles this within few lines, either consult the internet or pay someone to do it for you. :)
Have fun!
Well At First Thanks
But There is no Different Between this way and single Query !
It Will Take A Long Time !
07/05/2018 00:29 blapanda#4
Quote:
Originally Posted by dieseljava View Post
Well At First Thanks
But There is no Different Between this way and single Query !
It Will Take A Long Time !
^
Quote:
Originally Posted by blapanda View Post
On the other hand, if you want a professional code, which handles this within few lines, either consult the internet or pay someone to do it for you. :)
Have fun!
:rolleyes: