[Questions] VSRO Auto Invisible GM, Unique HP/Drops, Schedule, Teleport and Titles

[lemoniscool]

Hi!
I have some questions i couldnt find an answere to or any solution on my own ..

1. i want to remove the Auto Invisible of GMs
Everytime a GM logs in, teleports or sth else he has to open GM console and type /invisible .. thats really annoying and i want to turn it off if a GM needs to be invisible he can type it into console, if not why make him invisible at all? xD
Anyone knows how to turn that off?

2. i want to add Seal of Nova D11 drops to all Uniques and increase HP of lower level Uniques
i didnt find anything in database to change that .. someone can point me in the right direction?

3. How can i add an Event in Schedule?
I want to add an event that spawns all uniques 5 times every 3 hours, where would i go to do so?

4. I want to add Teleport Options to Teleporter in Jangan and Const for Alexandria North and South. Also i want to add Teleports to Quin'Shi Tomb B2/3/4.
I found the _RefTeleLink table for that, i understand Service, OwnerTeleport, TargetTeleport and Fee but what are the other Fields for??

5. I want to add Yellow Titles for Staff Members (like Support, Admin, Event) how to do that or .. where to go for this??

Thanks in advance for any help
regards

[MentaL]

[lemoniscool]

bump .. still need help on those .. noone has any idea?

[Caipi]

1. I doubt that it's possible unless it's a skill
2. _RefDropItemGroup + _RefMonster_AssignedItemRndDrop
HP ->

SELECT ref.ID, ref.CodeName128, obj.ID, obj.Lvl, obj.MaxHP FROM _RefObjChar as obj
JOIN _RefObjCommon as ref on obj.ID = ref.Link
WHERE    ref.CodeName128 NOT LIKE '%ITEM%' AND
        ref.CodeName128 LIKE '%MOB%'
ORDER BY ref.ID 

UPDATE the ones you want to change.
3. You've got to set own Tab_RefHive / Tab_RefNest / Tab_RefTactics entries, belongs to whatever you wanna do
4. Use the search function, there are various threads about that
5. http://forum.ragezone.com/f631/lil-c...-query-799668/

[lemoniscool]

hey!
got another question now .. how are chars assigned to accounts? cant find anything that tells the server what characters are for what account like a table with JID -> CharID ..

[Caipi]

USE SRO_VT_ACCOUNT

SELECT chart.CharID, tbuser.JID, chart.CharName16
FROM TB_User as tbuser
JOIN SRO_VT_SHARD.dbo._AccountJID as accjid on tbuser.JID = accjid.JID
JOIN SRO_VT_SHARD.dbo._User as usert on accjid.JID = usert.UserJID
JOIN SRO_VT_SHARD.dbo._Char as chart on usert.CharID = chart.CharID
ORDER BY chart.CharID 

[lemoniscool]

Wow youre fast, and it works =) thanks i dont really understand why this works, but ill get that =)

[Caipi]

You simply SELECT the values you want from the tables.

the JOIN statement links the different tables with each others, using the equal e.g. ID from each table.
CharID from _Char is equal to the CharID from the _User table
the UserJID from the _User table is equal to the JID record of the _AccountJID
and so on :)

[lemoniscool]

aah okay .. that makes sense =D thanks again

[lemoniscool]

I got another question .. most of the time, when a player kills a unique its not announced, someone knows why or how to fix it?

[Demetraa]

I got another question .. most of the time, when a player kills a unique its not announced, someone knows why or how to fix it?

u get the notice that the unique spawn?