Largest Collection Of Queries For PSRO Development [[ Updated ]]

Quote:

Originally Posted by blapanda Nice queries. I am most intrested into the _Memo Limit removal. Just the case about "_Memo" won't record any kind of conversation, neither save anything. Do you have a hint about that one? How to activate it? Is it Module or Database related?

Go to your shard. Expand it, click on Stored Procedures, scroll down until _Memo_Add. Right click on it, press modify procedure.

you'll see something like:
@MAX_MEMO_COUNT INT
AS


Find that place afterwards make a new line. Add this: SET @MAX_MEMO_COUNT = 999999


Not hard is it?

thxxx :)

#Updated
#Added: Query to add an item to all characters.

Hey khaledlollol thanks for these useful queries!
Although I didn't read too well and I tried to change spawn rate (but I only have 1 GS).
So everytime I try to spawn something it immediatly disappears now, how can I fix this?
Edit: fixed it, changed the ratio to 0.80

Quote:

Originally Posted by goddefied Hey khaledlollol thanks for these useful queries! Although I didn't read too well and I tried to change spawn rate (but I only have 1 GS). So everytime I try to spawn something it immediatly disappears now, how can I fix this?

The one used to increase the spawn rate, just change the value to what you want..

Add new drop for mob, unique etc
Easy

Quote:

USE/**/[SRO_VT_SHARD]/**/ -- GO DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT -------------------------------------------------------------------------- SET @Mob = 'MOB_SD_KEISAS_BERSERK'/*Monster Codigo*/ SET @Item = 'ITEM_ETC_ARCHEMY_ATTRSTONE_PD_14'/*Item Codigo*/ SET @DropAmountMin = 1 /*Drop Minimo*/ SET @DropAmountMax = 2 /*Drop Maximo*/ SET @DropRatio = 0.000389 /*0.5 = '50%' */ -------------------------------------------------------------------------- SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/ SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/ INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/ (RefMonsterID,RefItemID,DropGroupType,OptLevel,Dro pAmountMin,DropAmountMax,DropRatio,RefMagicOptionI D1,CustomValue1,RefMagicOptionID2,CustomValue2,Ref MagicOptionID3,CustomValue3,RefMagicOptionID4,Cust omValue4,RefMagicOptionID5,CustomValue5,RefMagicOp tionID6,CustomValue6,RefMagicOptionID7,CustomValue 7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9 ,CustomValue9,RentCodeName)/**/ VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@Drop AmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/

GG and thanks.

Quote:

Originally Posted by oXo™ GG and thanks.

URW

Quote:

Originally Posted by zebot Add new drop for mob, unique etc Easy

So You skipped the ID Part and used the code...to get the id
I didn't know that finding the id is so hard but its your choice you're free to modify it the way that makes it easier for you.

#

good

thanks for sharing