Program : Vsro Multi Tool

[ramy_11_1]

Hello elitepvpers members
i will share my own tool for vsro files

Tool name : vSro Multi tool
License : Free
Copyright : Dev. iLegend [Me]

What is the tool do ?
It has several uses , it contains an old functions and new functions too.
i choose to put old functions such as notice, pm, recall and totown in my tool to open just one tool in your VPS to do everything by it.

Now i will explain how to use it and new features that it contains :
- When you connect to your sql for first time, its check a required database exists or not, if not exists it will give u message box to press the create database button below.
- After that you can login to your server gateway by ip, port, locate and version.
- 3rd step is agent login, means character login by id, pw, captcha and character name.
- When character spawned the right groupbox named (System Service) will be enabled, now you can use this tool perfectly by inserting into database [iLegend_Tool] tables values by service = 1 to work.
- Each of these systems linked with a table inside the database.

Here is the list of the tool systems :

 Spoiler

- Send in-game notice
- Send in-game message (without re-log to show it , its look like you send it by client not by _Memo_Add)
- Send private, public and global chat
- Save incoming data like private chat, global chat and unique spawn - dead logs using a procedure execute to make it easy to do systems as u want inside it.
- Use GM Commands Like :
* /recalluser -- target character needed
* /movetouser -- target character needed
* /totown -- target character needed
* /ban -- target character needed
* /recallguild -- target guild needed
* /warp -- RegionID , PosX , PosY , PosZ , WorldID needed
* /loadmonster -- RefMonsterID , Spawn amount needed
* /makeitem -- RefItemID , Data , OptLevel needed
* /invincible -- nothing needed just service = 1
* /invisible -- nothing needed just service = 1
* /gmskill 0 -- nothing needed just service = 1
* /gotown -- nothing needed just service = 1

Caution :
Sending global system needs to set slot in the tool which contains global chatting , also you have to use this global codename to work ITEM_MALL_GLOBAL_CHATTING

Here is the inserting queries :

Use [iLegend_Tool] -- Common Command
-- Send notice
Insert Into _SendNotice Values (1,'Write here your notice',Getdate())
-- Send message
Insert Into _SendMessage Values (1,'target character name','write here your message',Getdate())
-- Send private chat
Insert Into _SendPrivateChat Values (1,'target character name','write here your chat',Getdate())
-- Send public chat
Insert Into _SendPublicChat Values (1,'write here your chat',Getdate())
-- Send global chat
Insert Into _SendGlobalChat Values (1,'write here your global chat',Getdate())
-- Move to user
Insert Into _MoveToUser Values (1,'target chatacter name',Getdate())
-- Recall user
Insert Into _RecallUser Values (1,'target chatacter name',Getdate())
-- Recall guild
Insert Into _RecallGuild Values (1,'target guild name',Getdate())
-- Totown user
Insert Into _ToTown Values (1,'target chatacter name',Getdate())
-- Disconnect user
Insert Into _DcUser Values (1,'target chatacter name',Getdate())
-- Warp region
Insert Into _WarpRegion Values (1,'RegionID','PosX','PosY','PosZ','WorldID',Getdate())
-- Load monster
Insert Into _LoadMonster Values (1,'RefMobID','Amount',Getdate())
-- Make item
Insert Into _MakeItem Values (1,'RefItemID','Amount','OptLevel',Getdate())
-- Invincible
Insert Into _Invincible Values (1,Getdate())
-- Invisible
Insert Into _Invisible Values (1,Getdate())
-- Go town
Insert Into _GoTown Values (1,Getdate())
-- Gm Skill use
Insert Into _GMSkill Values (1,Getdate())

Screen Shot :

 Spoiler

Version 1.0
Links :
Scan
Download

Version 1.1
Scan
Download

-----------------------------------------
File Password : Dev.iLegend

#Regards

[Zargrin]

Thanks ramy

[ramy_11_1]

Originally Posted by #BourBon

Thanks ramy

you are welcome

[XxGhostSpiriTxX]

very Good thx bro *--*

[Gummieֆ']

Good Job ,

[ramy_11_1]

Originally Posted by esteve458

very Good thx bro *--*

i hope it's useful for you

Originally Posted by Aleჯco*

Good Job ,

thanks

[denise456]

ramy i need db sql

[blapanda]

Seems to be clean.


Good job.

[XxGhostSpiriTxX]

Hello good morning friend that version of Visual Studio can edit the program please if I can post the link of the download of Visual Studio thanks

[blapanda]

Originally Posted by esteve458

Hello good morning friend that version of Visual Studio can edit the program please if I can post the link of the download of Visual Studio thanks

Use the internet. Google for "Visual Studio Decompiler Add-Ins".
I am not going to help people directly decompiling other people's stuff and using them for their advantage (selling, scamming, opening a backdoor, etc.). Use the program as it is meant to be, not less nor more.

Here is my version:

 Spoiler

Originally Posted by Crue*

you deserve a cookie

Is this somehow related to the topic?

[Bizzyyyyy]

Just drag and drop this .exe in ILSpy or whatever.
Its not protected.

[.Network]

i tested , can you add more delay for notice because it going so fast if you add more then 1 lines also check the date in table of notice it's random date.

[ramy_11_1]

Originally Posted by denise456

ramy i need db sql

just click connect to database if not exists the required db will show u a message box to click the active button blow , and wait when finish then connect ... etc..

Originally Posted by blapanda

Seems to be clean.


Good job.

Thanks.

Originally Posted by esteve458

Hello good morning friend that version of Visual Studio can edit the program please if I can post the link of the download of Visual Studio thanks

Use ILSpy to get the source files

Originally Posted by blapanda

Use the internet. Google for "Visual Studio Decompiler Add-Ins".
I am not going to help people directly decompiling other people's stuff and using them for their advantage (selling, scamming, opening a backdoor, etc.). Use the program as it is meant to be, not less nor more.

+1
#Respect

Originally Posted by .Network

i tested , can you add more delay for notice because it going so fast if you add more then 1 lines also check the date in table of notice it's random date.

your problem with column [Date] data type of table.
i make it varchar not datetime.
it means show time as this format 12:05:03

notice system timer interval is 100m sec. means 0.1 second
if it you have 10 rows service = 1 it will send all of them at 1 second.

your problem can be solved if it changed to 1 second interval
and query select top 1 ............... order by Date
to select the top 1 row contains service = 1 arranged by old date then new date by seconds.

try to alter table column data type to datetime.

[​Exo]

Originally Posted by esteve458

Hello good morning friend that version of Visual Studio can edit the program please if I can post the link of the download of Visual Studio thanks

VS 2013 Community, dark theme.

[.Network]

Originally Posted by ramy_11_1

your problem with column [Date] data type of table.
i make it varchar not datetime.
it means show time as this format 12:05:03

notice system timer interval is 100m sec. means 0.1 second
if it you have 10 rows service = 1 it will send all of them at 1 second.

your problem can be solved if it changed to 1 second interval
and query select top 1 ............... order by Date
to select the top 1 row contains service = 1 arranged by old date then new date by seconds.

try to alter table column data type to datetime.

i changed data type to datetime [sent it 3 lines faster + if you try to send more those 3 lines won't show anything.

i have seen this problem in Chat-Noticer coded by ahmed gendy

i think that problem in code because if you check all tables will see works prefect with type varchar(100) try to get the real code from soruce code of plus notice will sloved the problem.