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

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

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

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

PHP Code:

---

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/

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

PHP Code:

---

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 


---

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

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 :)

aah okay .. that makes sense =D thanks again

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?

Quote:

---

Originally Posted by 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?

---

u get the notice that the unique spawn?