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

[Royalblade*]

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?

[zebot]

thxxx

[khaledlollol]

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

[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?
Edit: fixed it, changed the ratio to 0.80

[khaledlollol]

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..

[zebot]

Add new drop for mob, unique etc
Easy

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,'***')/**/

[SkillsGoPewPew]

GG and thanks.

[khaledlollol]

Originally Posted by oXo™

GG and thanks.

URW

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.

[khaledlollol]

#

[where_love2003]

good

[zohanxd147]

thanks for sharing