Program : Vsro Multi Tool

07/07/2015 14:12 ramy_11_1#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 :


Here is the inserting queries :
Code:
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 :


Version 1.0
Links :
Scan [Only registered and activated users can see links. Click Here To Register...]
Download [Only registered and activated users can see links. Click Here To Register...]

Version 1.1

Scan [Only registered and activated users can see links. Click Here To Register...]
Download [Only registered and activated users can see links. Click Here To Register...]

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

#Regards
07/07/2015 14:14 Zargrin#2
Thanks ramy :D
07/07/2015 14:22 ramy_11_1#3
Quote:
Originally Posted by #BourBon View Post
Thanks ramy :D
you are welcome :awesome:
07/07/2015 14:33 XxGhostSpiriTxX#4
very Good thx bro *--*
07/07/2015 16:20 Gummieֆ'#5
Good Job ,
07/07/2015 16:38 ramy_11_1#6
Quote:
Originally Posted by esteve458 View Post
very Good thx bro *--*
i hope it's useful for you

Quote:
Originally Posted by Aleჯco* View Post
Good Job ,
thanks :D
07/07/2015 17:33 denise456#7
ramy i need db sql
07/07/2015 17:41 blapanda#8
Seems to be clean.
[Only registered and activated users can see links. Click Here To Register...]

Good job.
07/07/2015 18:00 XxGhostSpiriTxX#9
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

[Only registered and activated users can see links. Click Here To Register...]
07/07/2015 18:07 blapanda#10
Quote:
Originally Posted by esteve458 View Post
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

[Only registered and activated users can see links. Click Here To Register...]
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:


Quote:
Originally Posted by Crue* View Post
you deserve a cookie
Is this somehow related to the topic?
07/07/2015 19:07 Bizzyyyyy#11
Just drag and drop this .exe in ILSpy or whatever.
Its not protected.
07/07/2015 19:18 .Network#12
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.
07/07/2015 19:35 ramy_11_1#13
Quote:
Originally Posted by denise456 View Post
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..

Quote:
Originally Posted by blapanda View Post
Seems to be clean.
[Only registered and activated users can see links. Click Here To Register...]

Good job.
Thanks.

Quote:
Originally Posted by esteve458 View Post
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

[Only registered and activated users can see links. Click Here To Register...]
Use ILSpy to get the source files

Quote:
Originally Posted by blapanda View Post
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

Quote:
Originally Posted by .Network View Post
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.
07/07/2015 20:30 ​Exo#14
Quote:
Originally Posted by esteve458 View Post
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

[Only registered and activated users can see links. Click Here To Register...]
VS 2013 Community, dark theme.
07/07/2015 20:49 .Network#15
Quote:
Originally Posted by ramy_11_1 View Post
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.