Tool L2Off Gm Panel V4.7.1

[xeL]

Hello,
Here is a tool created by me witch I want to share with you to get a more easy work on your l2off database management and player control. Here are the option from it:

Eidt: Modify settings.ini with you MSSQL info and CacheD_IP.ini, CacheD_Port,ini with your cached info and run aplication.
 

ALWAYS MAKE A BACK UP OF YOUR DATABASE FIRST

 

Change Log:

 

Option v4.7.1

-Fixed log read error at app start in Server Controler.

Option v4.7

- Added to 'Server Controler' following options:
. Option to create daily log file in log folder ( format: yyyyMMdd.txt) 
. Option to save in log files: starting/killing/restarting all applications with current date and time
. Option to open log files by name and log folder
- added excel header view to 'inventory view' excel export

Option v4.6

-added to 'Settings Button' option to add firewall rules (block/allow local ports)
-added to 'Iventory view' option to export to excel
-fixed at 'Server Creator' the update option

Option v4.5

-Fixed "Save NASC" option in GF AI Editor to correct format
-Fixed PCH Maker for GF (click 'C4 Format' for c4 ai (interlude) and leave blank for GF)
-Added Option to export in EXCEL at following at following viewrs:
+ Item Management> Search Item by unique id
+ Item Management> View Items Highes Amount By Item ID
+ Item Management> Top Item List> View Weapons/Armor Highest Enchant By item ID
-Aranged by categories main form button:
+Server Management Editor
+Account/Character SQL Options
+Char Iitem-Skills/Siege/Olympiad SQL edit and Client
 
Option v4.4.1

-Fixed odbc buttons. Was inverted.

Option v4.4

- added button 'Account Create GF' in Account Creator for Gracia final retail lin2db
- added options to AI seletion to close after AI editor is opened

Option v4.3

- added option to update account password from Account Creator
- added file ac_update.sql(This is for fix lin_createaccount error. Vanganth files has this included.)
- added option to Settings Editor to open odbc  x32 and 64
- Added to Cached the button 'Check Online Status' for verify if a character is offline or online
- added the AIEditorUI tool for Gracia final ai.obj Advext Compiler/decompiler  at button AI Editors with followint options:
1 load/save ai
2 read decompiled ai
3 read/save nasc file
4 compile nasc
5 search the code
REMEMBER: ADVEXT FILES ARE NOT SHARED WITH THIS . FOR THE FILES YOU NEED TO CONTACT THEM.
- updated settins.ini for new Gracia Final ai editor
- added highlighted buttons when started to Server Controler 
- fixed alot of crash bugs on some forms

Option v4.2

- Fixed at server controler the l2npc killer button. (When accessed returned on "Start" status the l2auth and not l2npc.) 
- Added L2 File Edit by Be3geBJIa3 with chronicle support from c4 to H5 (Was request by a friend.)
- Added to 'Server Creator' Option to updated a curent server by id.
- Fxied some minor gliches on some forms.
- Diasbled 'C1 Smeli section' till future tests on cached options.

Option v4.1

- Renamed button "CharNameEdit" to "Character Manager" and added the following options
1. View character PK/PVP points by name (requires server reboot)
2. Edit character PK/PVP points by name (requires server reboot)
- Added to button "Server Controler" the following options
1. Two more custom application console with killer by application name(for any kind of application). 
2. Added to settings.ini the new applications line
-Fixed in Ai editor:
1. File>New Class -  now works correct
2. Insert New Class - now closes after insert 

Option v4.0

-Renamed button "Process Killer" to "Server Controler" and added the following options:
1. Option to run sevrer files(hauthd, cached, l2logd, l2server, l2npc, l2com, petition)
You can set the folder path in the settings.ini for every file in part for auto load in application.
2. Option to self run server files if one or more files crashes . 
You can set time(in milliseconds) for auto restart if one or more files crash and save it in settings.ini
INFO: If you want to stop the auto restart just use the buttons up for process kill.

Option v3.9

-fixed pch issue for skilldata and npcdata for GF (I added manual_pch in DB folder so
 now you can copy skilldata/itemdata/npcdata in same forlder with the panel and settings )
-fixed AI crash issue (tested copy/inject/decompile/compile etc by me and works)

Option v3.8

-added at 'CharNameEdt' Option to view character name by char ID
-added to 'Item Managemet' option to view item enchant, amount , type by uniquie item_id (located in user_item)

Option v3.7

-added to button 'Account Create' following options:
1.Update exsiting account builder.

Option v3.6

-added option to upload the BanChar.html renamed:
. after you edit BanChar.html you can rename it and add it in settings.ini at HtmlName
. html editor still works on standard name: BanChar.html (don't modify inner structure)
-added status informer after every new char added in html (so you know if html is eddited without opening)
-added message informer after upload with filename you uploaded and ftp server (so you know if file is uploaded)

Option v3.5

-added in settins.ini FTP options
-added in CacheD->Character Ban option to make html with baned chars:
1. After ban fill the textboxes with your info.
2. Click button Save to be added in the BanChar.Html 
(INFO: do NOT edit the lines in the html , only the one you added)
3. Fill FTP info and click to upload in your FTP server

Option v3.4

-added button 'l2server.ini' with following options:
1.edit Conection settings (ip and port of: cached, auth,petition, logd, l2comm)
2.edit Rates (adena amount, item, spoil, exp, party exp)

Option v3.3

-fixed Cached option 'Add item to char' parameters (now should be displayed ok)
-Renamed 'Script Viewer' to 'Script Manager' and added following option:
1. Recipe maker with HTML maker for recipes

Option v3.2

-added viwer for itemdata.txt Freya/H5
-info: skilldata.txt and npcdata.txt viewer for Gracia Final works for Freya/H5 too (seems to be same script)

Option v3.1.1

-fixed siege time convertor
-added to 'Cached Option' - delete item from character
-fixed errors on skilldata viewer (interlude/gracia final)

Option v3.1

- added L2NPC killer at Process Killer section (was not in  v3.0 becasue some code issue that is fixed now)
- added at section 'Script View' the option:
1. view Interlude Npcdata.txt
2. view Gracia Fianl Npcdata.txt
1. view Interlude Skilldata.txt
2. view Gracia Fianl Skillata.txt
- added back at 'Account Creator' Builder Level 0 (for create normal chars)

Option v3.0
- added L2NPC killer at Process Killer section
- added siege time make in Siege Section
- added button 'Script View' with follwoing options:
1. view Interlude Itemdata.txt
2. view Gracia Fianl itemdata.txt
-added PCH maker for Item/Skill/Npcdata.txt (Interlude/Gracia Final)

Option V2.9

-fixed antivirus detection (is no virus but some of them detect some conection strings as virus)
-removed all ini files and added just one for all options "settings.ini"
-renamed "MSSQL Connection" button to "Settings Editor" with following options:
1. View/Modify MSSQL Connection options in ini file
2. View/Modify CacheD Connection options in ini file
-added Ai Editor (recoded by me) with following options:
1. Search Ai
2. View/Edit AI
3. Compile/DeCompile AI
4. Inject
5. Split
6. Find And Replace

Option v2.8

-fixed SA on item search
-added SuperPoint.bin Editor

Option v2.7

- Added new section " Npc/Skill/Item ID search" with option to search npc/skill/item id by name(updated from H5 retail)
- Added to "CacheD Options" follwoning proprieties:
1.Change Clan Level ( added to window option to view Clan Info by Clan name)
2. Move item to other Character( added to window option to view Account Name/ID and Chard ID by char name)
3. Character Punishment ( added to window option to view Account Name/ID and Chard ID by char name and all punised chars by name/type punish)

Option v2.6

-Removed Char Ban from "Ban Manager" section (is added to cached option)
-Renamed "Ban Manager" to "Ban Account"
-Added to "CacheD Options" the following options:
.Character Ban with following optons:
1. View all baned chars
2. View all eternal ban chars
3. Window option to view Account Name/ID and Chard ID by char name
4. Char Ban by hours (add 0 Hours for unban)
.Add Item to Character ( added to window option to view Account Name/ID and Chard ID by char name)
.Move Character to other Account ( added to window option to view Account Name/ID and Chard ID by char name)

Option v2.5
-Fixed char ban at " Ban Manager " section (now char gets ban correctly)
-Added to "Clan Manager" section option to view clan info for Gracia final servers and edit clan points.
-Added to "CacheD Options" the following options:
.Disable Character ( added to window option to view Account Name/ID and Chard ID by char name)
.Enable Character ( added to window option to view Account Name/ID and Chard ID by char name)
.Set Account Builder ( added to window option to view Account Name/ID and Chard ID by char name)
.Sell All Skills on Character ( added to window option to view Account Name/ID and Chard ID by char name)
.Add Skill on character ( added to window option to view Account Name/ID and Chard ID by char name)
.Delete skill from character ( added to window option to view Account Name/ID and Chard ID by char name)
.Eternal Character BAN ( added to window option to view Account Name/ID and Chard ID by char name)
.Delete Quest From Char ( added to window option to view Account Name/ID and Chard ID by char name and Quest view)

Option v2.4 
1. Added Button "CacheD Options" with following options:
- Announcement
- Kick Online Player
- Change Character Name (character must be offline)
- Send Home Character
- Delete Character (character must be offline)

Option V2.3.1

-Fixed clan hall owner change (now you can add clan hall to a clan by clan name and clan hall id)
-Added option to view/edit clan ruler
-Added option to view castle id (in Siege Manager Section)
-Added option to add castle to a clan by castle ID


Option v2.3

- At Siege Manager added option to view Castle ID too.

*Added button "Clan Manager" with following options:
-View/Edit Clan: Name/ID(view only)/Points/Castle(view only)/Level 
-View/Edit Clan Hall owner by clan ID.

Option v2.2
-Added button "Siege Manager" with following options:
1. View Next time siege
3. Castel owner
4. Tax rate 
5. Shop Income
6. Change Next siege time by castle name
- Changed "About" form
- Added "Lineaege II" logo for more friendly design

Option v2.1

-Added option to manage olympiad (added button "Olympiad Manager")
1. Option to view current heroes
2. Option to edit points and matches for current olympiad players

- Added button "Top List Items" with following options:

1. Option to view by item id the bigest amount in server
2. Option to view bigest enchant in server by item id

Option v2.0

- button "Item Search By ID" is renamed to " Item Management" and added folowing options:
1. Delete Item from character by char ID
2. Delete Item from World by item id

- Added butto " Delete Character"
1. Option to delete character data from lin2world DB by table where data is saved

Option v1.9

- removed MSSQL connection test from Ban Manager ( is already a option for that in app)
- optimised forms for a better look and a easeyer way to work

Option v1.8

1. Added button " Procees Killer"
-option that kills following proces to avoid looking for it in Task Manager:
* L2Server
* CacheD
* L2Comm
* PetitionD
* L2Log


Option v1.7

1.Added button "Account Creator"
- option to create account with builder status (value between: 0-9)

Option v1.6:

1.Added button "Server Creator"
- option to create server in lin2db ('server' table)
- option to view all created servers in lin2db ('server' table)

Option v1.5:

1.added to button "Account Manager" the options:
-view Email by account name
-change Email by account name

Option v1.4:

-removed MSSQL connection test from main window
-added button for MSSQL Connection Test
-added character name view in "Character Name Change" option
-upgraded to NET Framework 4.0 ( Works with win 2003/ too. I upgraded to have more options to add at compilation for you :) ) 

Options v1.3.1:

-fixed NET Framework 3.5 run compatibility

Options v1.3:

- button "Character search by account name" renamed to "Account Manager"
- added to button "Account Manager" : delete accounts by last login 
(it deletes the characters with last login less then you seted on calented in application)
- Changed NET Framework to 3.5 (for win2k3 users)

Options v1.2:

-added Character search by account name
-fixed language mistakes
-optimised some forms

Options v1.1:

-added last login by ip at: find ip otions
-added options for Item search on a char by amount or just Item ID

Options v1:

- MSSQL concetion test
- char ban
- account ban
- item enchanter
- skill enchanter
- item amount change
- iventory view by char name
- find ip by account
- find char id
- change builder (GM power)
- change char name

 

 

Donators till now  (and Thank you very much) are: xryskom, ericvini, PARADISE, kelviow2, Vagrancy™, Sighed, Justice.Anarchy, tatwizard

 

Testers(thank you): , PARADISE

 

INFO:  Donators please PM/Mail me with your paypal email/name and mxc nick after donation to be added at list. Thank you!

Contact:

Skype: xel121

Mail: l2xguard@live.com

 

Thank you!

Best Regards

Hope you like it and is useful for you.
Thank you!

 

Download: https://mega.nz/#!zopQkaoa!T51fo1XgmRTqN1MnnMBFxMmzZVeo7QId1gbdk70XqmA

 

 

Need for run: Net Framework 4.0

Screen




 

Edited December 4, 2018 by xeL
Update

[mjst]

one more good Share dude..

+1 karma for your work...

[Vagrancy™]

very nice share i like !you can add more feautures !

keep going!

[xeL]

one more good Share dude..

+1 karma for your work...

 

Thank you!:)

[xeL]

very nice share i like !you can add more feautures !

keep going!

 

Thx. I will in new update.

[xeL]

New update released. Read first post.

[Phantasmo]

Nice one dude,keep it up.

 

[SsoviCc]

very good job!

[xeL]

New update released , v1.2. Read first post.

[xeL]

New update released , v1.3. 

(since I can't edit my post i post here)

Download: http://www.4shared.com/zip/VTl15ewu/L2OFFGMPanel_v13.html?

 

Change log:

 

 

Options v1.3:

 

- button "Character search by account name" renamed to "Account Manager"

- added to button "Account Manager" : delete characters by last login 

(it deletes the characters with last login less then you seted on calented in application)

 

- Changed NET Framework to 3.5 (for win2k3 users)

[xeL]

 

New update released , v1.3. 

(since I can't edit my post i post here)

Download: http://www.4shared.com/zip/VTl15ewu/L2OFFGMPanel_v13.html?

 

Change log:

 

 

Options v1.3:

 

- button "Character search by account name" renamed to "Account Manager"

- added to button "Account Manager" : delete characters by last login 

(it deletes the characters with last login less then you seted on calented in application)

 

- Changed NET Framework to 3.5 (for win2k3 users)

 

- added to button "Account Manager" : delete accounts by last login 

[xeL]

New release 1.3 in first post.

[Tavo22]

Great! I'm testing it right now and seems very usefull !

[TouchOfFlames]

Version 1.3 - NET Framework 3.5 Win 2k3 x64

 

Does`t even start

[xeL]

Version 1.3 - NET Framework 3.5 Win 2k3 x64

 

Does`t even start

Thx for report. I will look over it.