Jump to content

Recommended Posts

Posted (edited)

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

tSfGRS8.jpg

n7t5.jpg
 

Screenshot_1.png

Edited by xeL
Update
Posted

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

keep going!

 

Thx. I will in new update.

Posted

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

 

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 

Posted

Version 1.3 - NET Framework 3.5 Win 2k3 x64

 

Does`t even start

Thx for report. I will look over it.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • fixed the flickering , if you noticed to an other specific page please let me know
    • And Discord: https://discord.gg/3aYqWNqb
    • Ofc: https://discord.gg/3aYqWNqb
    • You can find some H5 skins shared in old L2 modding Discords, but most of the higher‑quality ones are either paid or come bundled with full client edits. I usually mix in commissioned work and whatever I can patch myself. On a side note, I fund a lot of these commissions by selling off game items through instant sell cs2 skins, which has been a quick way for me to get some cash for projects.
    • There is no need for gRPC in this case, even tho originally it was gRPC based but since we don't need it to be bi-directional, we switched to simple http requests for the web calls and SSEs for the data streamed from the server. There are distributed locks in place to precent race conditions between actions that can happen between multiple web instances and the server.   Local models can also be slow depending on the model, and most external models can actually be faster than local ones if you use Flash 2.5 or something along those lines. I am running on 512GB of Unified Memory on my Mac Studio M3 Ultra so the speed of the local model for a small model is pretty good but I tested it with Gemini too and it works equally as fast and in some cases faster. The way it works is that I'm using pgvector (one of the benefits of moving to Postgres) to search the data and see what the player can see etc and there is some batching of the next few actions for 2-4 seconds for the user until the next LLM request fires. The batching also includes branching on logic so if they for example fall under some HP they will move to kiting instead of attacking or maybe they heal etc.   Everything is authed and permission-based. The server and the backend of the frontend have secure communication between them, either with a symmetric key (not recommended for production) or a certificate (the recommended way), so there is no worry. It's all tied to the account's access level, etc., so nobody can make an action that they normally wouldn't be allowed to do. Even the MCP is token-based, and there are prompt injection protections in place. The MCP is audited, and every mutation needs confirmation. The admin area is only accessible to the admin account anyway so normal users can't access it.  
  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..