|
You last visited: Today at 08:02
Advertisement
Drops
Discussion on Drops within the SRO Private Server forum part of the Silkroad Online category.
07/04/2018, 14:33
|
#1
|
elite*gold: 80 
Join Date: May 2015
Posts: 375
Received Thanks: 118
|
Drops
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
|
#2
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
|
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
|
#3
|
elite*gold: 80
Join Date: May 2015
Posts: 375
Received Thanks: 118
|
Quote:
Originally Posted by blapanda
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
|
#4
|
elite*gold: 0
Join Date: Jul 2009
Posts: 1,860
Received Thanks: 760
|
Quote:
Originally Posted by dieseljava
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
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! |
|
|
|
|
 |
Similar Threads
|
[Frage] wegen den Drops, bzw Drops einstellen!
10/25/2012 - Metin2 Private Server - 6 Replies
Hallo,
ich hab lange probiert die Alternativdrops perfekt einzufügen bzw. einzustellen.
Aber leider nur gescheitert. Nun meine Frage:
- Wie kann ich die Drops wie auf .de einstellen, sprich:
Schwarzer Ork
Ich möchte es nicht so haben, sondern so in der Art.
Muss ich dazu das komplett in der Mob_Drop_Item.txt einstellen, oder geht
das einfacher bzw. schneller?
|
WTB rare drops Mid Uth (dragon,worm,glacier giant , taj drops)
09/08/2011 - Trading - 0 Replies
as title says PM me what you have got and how much u want for it. Ta .
Paying Paypal or Plats in game.
|
Wat Drops Before Its Drops
04/17/2008 - Conquer Online 2 - 5 Replies
Is There A Way To C Wat Drops Before It Drops Ive Heard Some Talk Of An Fps Hack But Cant Find One An SpeedHack Isnt Good Enuff Please Help Me Out And Any Tips On An Fast Way To Make Some Money Hunting Sucks An I Dont Order Dbs :mad:
|
trades/drops nachvollziehen
07/28/2006 - Ragnarok Online - 10 Replies
heißt ja immer "wir können alles nachvollziehen, auch gedroppte items" bla blub.
vor einiger zeit ist einem freund von mir folgendes passiert: er hatte seinen stealclip auf einem char, den er löschen wollte. hat, laut seiner aussage, den clip ins lager getan, den char gelöscht und auf dem gleichen slot einen neuen char, mit identischem namen erstellt.
am abend hat er dann gemerkt, daß der clip weg war
der gm meinte dann nhach einigem hin und her, daß er aufgrund der tatsache, daß der char...
|
All times are GMT +1. The time now is 08:03.
|
|
