[Release]Simple Query How to add Drops in Mobs,Uniques

[tk69ok]

work thanks master

[Alexiuns]

good

[Zetson]

SR GAME SREVER CRASH

[Qynchou]

Using queries off the internet, next thing you know your gameserver doesnt boot. lel.

[Empire-Sro]

Nice Keep It UP

[FantasticBoy1]

GoodJop

Good

[Tommy.]

Originally Posted by FantasticBoy1

GoodJop

Good

Thanks

[Syloxx]

cmon its a simple insert command it isnt worth for a release

[RELEASE] Delete SRO_VT_SHARD Database

DROP DATABASE SRO_VT_SHARD

pff

[Zodiao]

It ain't worth to rate a release from 2012 too, is it?

[鳳凰城]

Originally Posted by Syloxx

cmon its a simple insert command it isnt worth for a release

[RELEASE] Delete SRO_VT_SHARD Database

DROP DATABASE SRO_VT_SHARD

pff

sro community != syloxx != king

syloxx ◕‿◕ < king

[Syloxx]

Originally Posted by Zodiao

It ain't worth to rate a release from 2012 too, is it?

so you wanna tell me that all the sql clauses are from 2012++ ?

[​Exo]

Originally Posted by Syloxx

so you wanna tell me that all the sql clauses are from 2012++ ?

You hit the nerve

[Zodiao]

Originally Posted by Syloxx

so you wanna tell me that all the sql clauses are from 2012++ ?

I wanna tell you that you don't have to say your precious opinion about something from 2012
Because it's too late, maybe?

[Toby Crackit]

Thanks

[BerlinSROTeam]

Yes... it´s not that worth to release it but anyway you can use them too

 Spoiler

PHP Code:

//Search ^ delete query by Buhao

---To remove the Item from every Mob
Select * from __RefMonster_AssignedItemDrop WHERE RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'ITEM_.....%')
--DELETE FROM _RefMonster_AssignedItemDrop WHERE RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'ITEM_.....%')



---To remove all Drop from single monsters only... Examle is using Remove all drops from MOB_SD_SETH

Select * from __RefMonster_AssignedItemDrop WHERE RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_SD_SETH')
--DELETE FROM _RefMonster_AssignedItemDrop WHERE RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_SD_SETH%')

Cheching Monster + Items Drops or Remove  one Item from one Monster...
Select * FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%') and RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_%')
--DELETE FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%') and RefMonsterID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like 'MOB_%')




Select Direct CodeName128 from Item Drops
what mob drops 'ITEMCODENAME' item..
Select CodeName128 from _RefObjCommon where ID IN (Select RefMonsterID FROM _RefMonster_AssignedItemDrop where RefItemID IN (SELECT ID FROM _RefObjCommon WHERE CodeName128 like '%TOKEN%'))

What Items are getting droped by ...'MOBCODENAME'
Select CodeName128 from _RefObjCommon where ID IN (Select RefItemID FROM _RefMonster_AssignedItemDrop where RefMonsterID in (Select ID from _RefObjCommon where CodeName128 like '%LAUNA%')) 


Good Luck!