[RELEASE]Custom GM commands

[zargon05]

I was only showing how to do it, if you want to add more you should do it yourself.

[AriezOMG]

Hmm seems this stopped my Chatlogs table from logging o.O

[Xx.LaMin.xX]

ariez i think you are having same issue with me.. Lilpro dont i need to change this?

SELECT @ChatData=ChatData,@UserUID=UserUID FROM inserted

[zargon05]

That command gets the row that was stored into the chatlog table

[HoaX.]

I have scripted some commands:
I will realease this script after some time.

Some commands work with Admin levels. Means you can only use a command if you have the needed Admin Level.

-- Report_player
For players to report others in Game.

-- setapall
sets all ap to %value%

Gives 1+ Admin Level:
-- Promote GM - Target must be GM And can't reach level 9+.
-- Demote GM - Target must be GM.

-- temp_Ban command for GM (can ban for minutes, hours,days)
-- PermBan Account (command for GM)
-- unBan (command for GMs)
-- Full ban (command for Admins. Bans all Accounts with same IP + Can't register new Accounts.)

-- Make [GSL] (GS-Leader) Adds GSL Tag and gives permissions to create new GS
-- Remove [GSL] (GS-Leader)

-- Make [GS] (GS Leader can only make new GS of his faction)
-- Remove [GS] (GS Leader can remove GS from both factions)

-- Make [GM] (Shows GM in [modified]web onlineList and adds [GM] Tag)
-- Remove [GM]

-- Make [PN] (PN Rank + Adds [PN] Tag)
-- Remove [PN]

-- Make [SA] (Server Admin Rank + Adds [SA] Tag)
-- Remove [SA]

-- Make [A] (Admin Rank + Adds [A] Tag)
-- Remove [A] (removes Admin Rank + removes [A] Tag)

-- Reschar (recovers a dead toon and sets start location to map 42)
-- delchar (ban/delete a toon)

-- disableacc (Account does not exist)
-- enableacc

-- getpoints (Gives points to current GM char) for GMs
-- givepoints %charname% (Gives points to any Character)


Got any Ideas for more commands?

More commands will be added.

Regards,
developer of Shaiya-Alliance

[Kaotic_Lord]

Originally Posted by HoaX.

I have scripted some commands:

*snippage of loooong post*

Got any Ideas for more commands?

More commands will be added.

Regards,
developer of Shaiya-Alliance

Holy ****. That must have taken some real doing.

[ShaiyaForever14]

Hmm so the /ban playername doesn't works ? I found it on the GM Command list by ZeroSignal . Idk about that since i am the only in the server but i tried to kick myself and it worked =p Or to mute/block from moving xD

BTW i got some more questions ... i am using the ep 4.5 client from Ariez and i used the EP 4 tutorial by Omega . Anyone knows the command for giving/getting ap and for making names with tag ? I don't know that and my char name is only Admin_Predator not [Admin]Predator =p

[viper4513]

done in the database with query's
Tags

 Spoiler

UPDATE [PS_GameData].[dbo].[Chars]

SET CharName= 'NewName'
WHERE CharName= 'OldName'

AP

 Spoiler

Look in PS_UserData > dbo.Users.Master
change "point" to whatever ammount of AP you want.

There is a script for it, but i cba to hunt my files for it, use the search here, Ariez has a list of them for your use.
Credits to Ariez

[mabe140]

Originally Posted by HoaX.

I have scripted some commands:
I will realease this script after some time.

Some commands work with Admin levels. Means you can only use a command if you have the needed Admin Level.

 Spoiler

-- Report_player
For players to report others in Game.

-- setapall
sets all ap to %value%

Gives 1+ Admin Level:
-- Promote GM - Target must be GM And can't reach level 9+.
-- Demote GM - Target must be GM.

-- temp_Ban command for GM (can ban for minutes, hours,days)
-- PermBan Account (command for GM)
-- unBan (command for GMs)
-- Full ban (command for Admins. Bans all Accounts with same IP + Can't register new Accounts.)

-- Make [GSL] (GS-Leader) Adds GSL Tag and gives permissions to create new GS
-- Remove [GSL] (GS-Leader)

-- Make [GS] (GS Leader can only make new GS of his faction)
-- Remove [GS] (GS Leader can remove GS from both factions)

-- Make [GM] (Shows GM in [modified]web onlineList and adds [GM] Tag)
-- Remove [GM]

-- Make [PN] (PN Rank + Adds [PN] Tag)
-- Remove [PN]

-- Make [SA] (Server Admin Rank + Adds [SA] Tag)
-- Remove [SA]

-- Make [A] (Admin Rank + Adds [A] Tag)
-- Remove [A] (removes Admin Rank + removes [A] Tag)

-- Reschar (recovers a dead toon and sets start location to map 42)
-- delchar (ban/delete a toon)

-- disableacc (Account does not exist)
-- enableacc

-- getpoints (Gives points to current GM char) for GMs
-- givepoints %charname% (Gives points to any Character)


Got any Ideas for more commands?

More commands will be added.

Regards,
developer of Shaiya-Alliance

Very inspiering! Did you use stored posedures, or triggers? I've been trying to make some new commands too, but to be honest, I suck at SQL. Would you be able to make a tutorial somewhere, or text me on here and give me a hint in the correct direction?
I've tried trough stored posedures, and had some success, but added more bugs on the way to success, lol. That's what's called "learning progress" right? I'm doing this project where we're a group of people trying to re-write the entire of Shaiya, so functions like this, would be very helpfull.