Search:

it won't :), it just marks that quest id 1 and 2 are finished.

It's related to default quest.

Open your SHARD's [_AddNewChar] SP, find these lines:


-----------------------------------------------------------------------------
-- ±âº» Äù½ºÆ®...

Try creating the guild manually from database by executing Guild create SP:


USE [SRO_VT_SHARD]
EXEC [_Guild_Create] 'GuildNameHere', CharIDHere

see if you encounter some errors there

For "normal" equip, change probability value in [_RefDropClassSel_Equip] table
For "rare" equip, change probability value in [_RefDropClassSel_RareEquip] table

Fields are ProbGroup32 to...

SELECT a.*, b.CodeName128 FROM [_RefDropItemAssign] a WITH (NOLOCK) INNER JOIN [_RefObjCommon] b ON a.RefItemID = b.ID WHERE b.CodeName128 LIKE 'ITEM_%12%'

good luck ;)

You need to make your own "delivery" system for it. I removed the query for automatic scroll delivery on level up because it might spike your server resources (say, 100+ players level up at same...

Hello,

Here I'll share simple SQL query to check and update "Max Plus" (with and without Adv. Elixir) of items in 2 different methods: (doesn't matter which, both has same effect)

Method 1:...

Try by executing the SP directly from your SQL and teleport the char, see if it works.


EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] 'CharacterName', 7

good luck

Agreed on ID thingy.

Moreover, that screenshot showed shop item IDs, which even more worse I might say :P, numbers are too big and yet only less than 2500 records in the table. [_RefPackageItems]...

see if the item available in _RefObjCommon

SELECT a.CodeName128 FROM _RefObjCommon a INNER JOIN _RefScrapOfPackageItem b
ON a.CodeName128 = b.RefItemCodeName WHERE a.[Service] = 1 AND...

creative, nice one ;)

yep, effect should be for area attack if i don't misunderstand you. You can try adding these Params in front (must go first before the attack/debuff effects) of skill column that you want:


...

added ;) have fun

Safest way is to do this when character login/logout, since changing item plus from database trigger or _AddLogItem query without refreshing the client will cause misinformation between client and...

Hello, here I'll share simple query to find tables containing "JID", "UserJID", or "CharID", for cleanup purposes. Well actually, it'll be easier to cleanup the whole thing if you wanna start fresh,...

Yes perhaps, perhaps you can enlighten us about what you were trying to say or explain. A little example perhaps?, so I won't misunderstood your meaning again ;)

Easier and safer to use what the game already provide :)


Flag the char as "Deleted" in _Char table
Insert the char to _DeletedChar table, set the DeletedDate to (GETDATE() - 8) (Some systems...

One more thing, your tools is using .NET 4.0 or 4.5 (whichever it was), perhaps you could compile in "standard unicode" format because it won't work with some Windows which has minimal unicode sets...

If you make Expendable or Time Service type of scroll, you won't get buggy on PK removal whatsover, except you cannot avoid the fact that you have to DC your client afterwards (unless it's a pure...

Ah, character change, well I was aiming to scroll with TID: 3, 3, 13, 14 (Time Service)

Anyhow, I'm testing with TID 3, 3, 13, 9 now. See if we get no "character change skin" dialog appearing in...

table updated, added a little explanation ;)

Actually you can use "Expendable" type of scroll. (TID: 3, 3, 13, 14). And that's the only scroll we can use while in PK mode, nothing else. Thus you need to relog your character afterwards. or...

Hello

Today i'll share some commonly used skill params. This prolly very old and useless to you, but feel free to play with 'em as you like ;)



DESC
PARAM
VALUE 1
VALUE 2

actually i don't care where you took the source from or if you wrote it from the scratch, thus i don't require any prove about anything. it's your right to do so and to release it anywhere you...

it's C# and it's taken from AIO, good stuff, but just be sure about one thing... "Account Delete" feature, be sure you have all related tables cleaned up on that one, i had personal messed experience...

As referred here, seems you desperately wanna sell your stuff in immediate time. yet you haven't posted how reliable your proxies against attacks. So, please do :)

The thing is, before you (@thread starter), wish to release something or even worse, SELL something, be sure you tested you stuff under attack. Yeah, people might buy your proxies and all but if...

nice one for collection, and files are clean, no unnecessary junk. Thank you

i might. and u don't have to use it if you don't need it.

In addition to @RenePunik's query about cleaning inventory, this one is to see inventory and storage items :)

now the boring part:

USE [SRO_VT_SHARD]
GO
SET NOCOUNT ON;

/*
* Check items...

hey ;)

Here I'll share simple query about how to count total monster spawn categorized by their level, this should match total monster spawn you get when using gm command /worldstatus

This...

Like i mentioned, my changes are in red. so, remove the red part

Hey :)

well this is old stuff but i recently made it for my server so i'll share. This prolly useless to you but you may use it if you like. By the way, I use original SP from vSRO 1.188, just...

In my experience, nah it won't, I've been dealing with huge production databases with over 30GB filesize using same technique, nothing to worry, just don't do that all the time though, it's supposed...

Oh well sometimes we wonder if our SRO database really "that" big, I mean over 500MB or maybe 1GB and so...

Turns out they aren't. Some ppl released database with size more than 500MB, uhm well,...

This prolly an old problem, but not sure if there's any fixes around :)

Problem is sometimes when we reached lvl 7 job at 100%, the client still adding exp despite if you set NULL or -1 in...

isn't honor rank page updated by '[_TRAINING_CAMP_UPDATEHONORRANK]' procedure? which the last time i remember is placed on [_Schedule] table or SMC schedule and not real time?

Yeah my bad sorry, it should be this:


/* Check if Camp exist */
DECLARE @CampID INT
SELECT @CampID = CampID FROM [SRO_VT_SHARD].[dbo].[_TrainingCampMember] WHERE CharID = @KillerCharID AND...

you did pretty nice mods fulfilling your needs though, no need to change anything if they already works.

The _AddLogChar thingy is completely different thing, I just tried to add an example for...

Hello,

Oh, is the idea to update honor rank not by academy system but from job kills? and the "Graduates" should be the kill point?

Perhaps you could do that by calling...

which posts approve?

And anyway, whatever I posted is simply an alternative, I don't have problems with it, it simply worked fine in my box. After all, I never said this solution is bad or that...

-nevermind, problem solved-

please close the thread :)

Hello Syloxx

Yep!, exactly, CURSOR is always bad for many repeated sequences, but, this will run only 1 time on each bandit scroll use :). (Can't imagine 100 users using bandit scroll at the same...

Thanks blacksheep25, it's good to be back ;)

Hi there, it's been a while ;)

I'd like to share an alternative Trijob Anti Cheat (simple query in SP) based on Syloxx's idea in this thread.

The difference is, his procedure based on "item...

@Chern0byl, as usual, coder that you are, the best one always is. I remember I used one your your gameserver binary release for my server, and hell I haven't bought a license for the SQLAPI++ :P, can...

I did every single thing directly using T-SQL, but overall what you're doing is great, liked it ;)

By the way, don't forget to do LTRIM(RTRIM()) when getting value from "_RefObjItem.Desc2_128",...

no no... don't paste your SP, i said "ATTACH", not "PASTE", RageZone has weird feature translating words began with "@" as link to user profile, which is annoying, it'll mess up some codes.. so...

Then you put wrong variables at declaration statement lines. Those error were simply SQL errors in general which can happen in any SP at anytime. So take your time to review your own statements in...

SQL 2005 i presume?

http://forum.ragezone.com/f722/simplified-job-freepvp-kill-fetching-972433/index9.html#post7922535