|
You last visited: Today at 05:09
Advertisement
Add Drop Max mini With codename (Fixed )
Discussion on Add Drop Max mini With codename (Fixed ) within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
08/08/2012, 03:37
|
#1
|
elite*gold: 0 
Join Date: Aug 2012
Posts: 117
Received Thanks: 53
|
Add Drop Max mini With codename (Fixed )
i Edit fthis query to be esay and simple have fun :
PHP Code:
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
DECLARE @DropAmount real
DECLARE @DropAmount1 real
SET @MonsterID = (select ID from _RefObjCommon where CodeName128 like 'MOB_SD_SETH') -- You can find Monster ID's at RefObjCommon
SET @ItemID = (select ID from _RefObjCommon where CodeName128 like 'ITEM_ETC_AMMO_ARROW_01') -- You can find Item ID's at RefObjCommon
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course
SET @DropAmount = 3-- Chose ur amount Mini
SET @DropAmount1 = 5-- Chose ur amount Max
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, @DropAmount, @DropAmount1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
|
|
|
|
08/08/2012, 09:33
|
#2
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,514
Received Thanks: 891
|
a better version
PHP Code:
--##########################All credits goes to the orginal writer !####################################################################################################################################################
USE SRO_VT_SHARD --#
GO --#
DECLARE --#
@MonsterID int,@ItemID int,@DropRatio real,@DropAmount real,@DropAmount1 real,@CodeName_item VARCHAR (100) --#
,@CodeName_Monster VARCHAR (100) --#
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --#
SET @CodeName_item = 'ITEM_ETC_AMMO_ARROW_01' --@ --#
SET @CodeName_Monster = 'MOB_SD_SETH' --@ --#
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course --@ --#
SET @DropAmount = 3-- Chose ur amount Mini --@ --#
SET @DropAmount1 = 5-- Chose ur amount Max --@ --#
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --#
--#
SET @MonsterID = (select ID from _RefObjCommon where CodeName128 = @CodeName_Monster) --#
SET @ItemID = (select ID from _RefObjCommon where CodeName128 = @CodeName_item) --#
INSERT _RefMonster_AssignedItemDrop --#
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3, --#
RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName) --#
VALUES(@MonsterID ,@ItemID,0,0,@DropAmount,@DropAmount1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0, 0, 0, 0, 0, 0, 0 ,0 ,'xxx') --#
--######################################orginzed By ahmed4ever2u########################################################################################################################################################
|
|
|
|
|
08/08/2012, 11:01
|
#3
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
in my opinion the first one is actually clearer structured ;o
|
|
|
|
|
08/08/2012, 14:15
|
#4
|
elite*gold: 166
Join Date: Apr 2009
Posts: 2,339
Received Thanks: 2,661
|
Quote:
Originally Posted by ahmed4ever2u
a better version
PHP Code:
--##########################All credits goes to the orginal writer !####################################################################################################################################################
USE SRO_VT_SHARD --#
GO --#
DECLARE --#
@MonsterID int,@ItemID int,@DropRatio real,@DropAmount real,@DropAmount1 real,@CodeName_item VARCHAR (100) --#
,@CodeName_Monster VARCHAR (100) --#
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --#
SET @CodeName_item = 'ITEM_ETC_AMMO_ARROW_01' --@ --#
SET @CodeName_Monster = 'MOB_SD_SETH' --@ --#
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course --@ --#
SET @DropAmount = 3-- Chose ur amount Mini --@ --#
SET @DropAmount1 = 5-- Chose ur amount Max --@ --#
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ --#
--#
SET @MonsterID = (select ID from _RefObjCommon where CodeName128 = @CodeName_Monster) --#
SET @ItemID = (select ID from _RefObjCommon where CodeName128 = @CodeName_item) --#
INSERT _RefMonster_AssignedItemDrop --#
(RefMonsterID,RefItemID,DropGroupType,OptLevel,DropAmountMin,DropAmountMax,DropRatio,RefMagicOptionID1,CustomValue1,RefMagicOptionID2,CustomValue2,RefMagicOptionID3,CustomValue3, --#
RefMagicOptionID4,CustomValue4,RefMagicOptionID5,CustomValue5,RefMagicOptionID6,CustomValue6,RefMagicOptionID7,CustomValue7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9,CustomValue9,RentCodeName) --#
VALUES(@MonsterID ,@ItemID,0,0,@DropAmount,@DropAmount1,@DropRatio,0,0,0,0,0,0,0,0,0,0,0, 0, 0, 0, 0, 0, 0 ,0 ,'xxx') --#
--######################################orginzed By ahmed4ever2u########################################################################################################################################################
|
That '@' '#' comment lines actually doesn't make the code better.
|
|
|
|
|
08/08/2012, 14:44
|
#5
|
elite*gold: 130
Join Date: Mar 2008
Posts: 2,485
Received Thanks: 934
|
Quote:
|
All credits goes to the orginal writer!
|
I lol'd...
|
|
|
|
 |
Similar Threads
|
[Mini-tut]How to drop items using a GM char!
12/20/2010 - Dekaron Private Server - 49 Replies
Since I saw a loads of people asking how to drop an item with a GM char, and loads of responses that you can't do it (LIES!!!), I decided to make this mini-tutorial.
1. Empty ur GM char's inventory
2. Buy lots of 2*4 items like 2h axes (fill ur inventory with them)
3. Go to the database, user_bag table, then find your character, see how he has alot of the same IDs. Those are the IDs of the axes.
4. Change the IDs to the IDs of the item you want to have.
5. Log in, go ingame
6. Click on...
|
[Mini-Guide]How to make mobs drop certain items
07/30/2009 - CO2 PServer Guides & Releases - 18 Replies
Somebody asked me to make a mini-tutorial for making mobs drop certain stuff in LOTF.
Well first we go to Entities.cs,
when your done with that search for this
if (Name == "Guard")
There should be something under that somewhat like this:
{
if (Other.ChanceSuccess(100))
{
string Item = "721020-0-0-0-0-0";
|
All times are GMT +1. The time now is 05:11.
|
|
