Support Ticket System (STS) v2.0
An advanced way of providing support to your players
Creator: [GM]Xeon
Version: 2.0
Features:
Players can post new support tickets, reply to them, and close them if it's self-resolved
*Players get a message when they log in about unread support tickets
*Players get a message if they're online and one of their tickets were replied to
*Players can attach URL's for files uploaded to speed up the support process and provide proof (Mostly based for PHP version yet to come)
*GM's can view tickets by their department, then status, then priority or date
*GM's can reply to, change status, priority or transfer department and also delete tickets
GM's can search tickets by using Title, Body, Ticket ID, Character Name, or Character ID
GM's can whisper anything to the npc to start conversation
The basic ticket status': Open, Closed, Waiting, On Hold
*Ticket priority rankings: Irrelevant, Minor, moderate, Urgent, Critical
*Department system, categories for where to post tickets
*Per-staff-based moderating permissions for each department
*Player and staff (<99 GM level) account ID, character ID, and IP address banning available
SQL injection protection
*=Indicates new to v2.x
Future Features:
A nice little php page to integrate the support ticket system to your web server as well (Perhaps a CeresCP patch)
Downloads: Engine, SQL script and 1.x->2.0 converter
Installation:
Step 1 (Optional): Run the MySQL script on your database using your favorite MySQL tool (I Recommend MySQL query browser) or MyPHPAdmin.
Step 2: Place the main engine (ST+.txt) it in your "./npc/custom/" folder.
Step 3: Add this line to your "./npc/scripts_custom.conf" file:
CODE
npc: npc/custom/ST+.txt
If you want to upgrade an old ST version, run the migrate script inside the rar with eA after the ST 2.0 MySQL db has been installed.
Change Log:
v1.0...v1.3: original outdated version.
v2.0: Complete remake, now supports tons of new features!
Note this is a work in progress, it hasn't been optimized yet and is sorta bare, probably has quite a few bugs. I'm not sure if I fully tested the GM search function, but I quick skimmed the script over and it seems to be there, so it might work? And for the converter, it has no syntax errors but has never been run a single time, so it might just blow up in your face...
Monday, December 1, 2008
War Of Emperium Setter 3
Ultimate WoE 3
Created by: [GM]Xeon
Global Version: 3.4.2
Features:
Players can view a detailed listing [Is it active now? What towns it applies to, what castles it applies to, the start/end day, hour, minute] of all WoE times that are set and it it sorted by which WoE is next.
GM's can add, modify and delete WoE times
WoE times can be set to any town, and multiple at the same time!
WoE times can be set to any castles within the selected town(s) at the same time!
WoE times can be set for all the classic towns and castles, as well as the new second edition ones!
WoE time starts/ends can be randomized by a specified amount of seconds. This only works to an extent.. See known bugs.
WoE can be manually started/ended.
WoE may resume in the event of a server crash.
Mob spawns in empty castles can be disabled.
Script automatically creates the SQL tables for you on the first load!
See plug-ins for extended features.
Plug-ins:
Player - Castle Ownership View
GM - Change/Release Castle Ownership
GM - Edit Castle Investments
GM - Guild Information Query Tool
GM - Guild Manager Jump-to
Player - Guild Recruiter
GM - Treasure Spawner
GM - Enable/Disable Treasure Spawns
Player - Secured Guild Storage
Player - Guild Mailbox
GM - Castle/Emperium Warp-to
Player - Secure Guild Bank
Known Bugs:
WoE time randomization is only set when the time is added or modified. NOT when the script automatically updates the tick columns in the SQL table. I'll fix this in a future version.
When a server crashes or is shut down, WoE times *may* not resume when it's back up. Test this thoroughly for me please =).
Disabling mob spawns in empty castles will not kill them if they already spawned, restarting the server or killing them manually solves this problem.
Modifying a WoE time while it is active to a time frame where WoE should not be active currently (Is NOT smart) does NOT automatically stop the WoE, so you should stop it beforehand! (This does not apply to extended active WoE times, that works perfect.)
Future Features:
Available upon request
Changes: (Bug fixes and optimizations not recorded here, check the change log inside the rar)
v1.x: The original WoE Setter script by Fredzilla. The foundation and guideline of the WoE Setter series by me.
v2.x: What I consider my old school highly unoptimized WoE setter
v3.0: The new generation of WoE management created! (This script )
v3.1: NPC now has a WoE start/end time message above its head (Very useful for testing!), can manually start WoE through the NPC GM menu, players can view a list of what guilds own what castles.
v3.2: Castle ownership can now be changed through the NPC.
v3.3: Added treasure spawn function and Emperium breaker announce.
v3.4: Added plug-in mod
If you see...:
[Error]AgitStart2; Expect command, missing function name or calling undeclared function when the script loads - Update your SVN (It has to be the LATEST, not "Oh, it's close enough. 3 weeks old.")! Please guys, DO NOT REPLY SAYING YOU GET A RUNTIME ERROR BECAUSE YOUR SVN IS OUTDATED!
[SQL]DB error - Table 'woe_times' doesn't exist, displayed on the map server when the script loads or you try to use it - You must either @reloadscript or restart your server so the OnInit in the main script executes. You cannot @loadnpc this for the first time! If the problem persists, read the next error about not being able to create the table and use that solution.
[SQL]You don't have permission to create the table in MySQL, displayed on the map server when the script loads - Open the .sql file included in the rar and highlight the code, paste it into your favorite SQL client (query browser, myphpadmin, etc.). Also, if the error keeps happening (Which it will if your server SQL account doesn't have table creation privs) on every server OnInit, simply comment the line starting with 'query_sql("CREATE'.
[Error]Your PC constantly beeps and gives you hundreds of "unmatch )" messages when the script loads - Your SVN is way outdated and doesn't support agistart/end2; and agitcheck2(); update your SVN!
[In-game]I set a WoE time and it won't start when it's supposed to! - Verify you updated your scripts_guild.conf/guild folder/guild2 folder with the rar, then verify that the time you set was not set to a time that was in the past to present/future, because then it'll just default to starting next week. Also, make sure you set the time in MILITARY TIME, i.e. a 24-hour clock. Not AM/PM, 0:00-23:59, 0=12 AM, 23=11 PM. Easy trick to know military time: If the current time is AM that is the hour to enter (12AM=00 though), if it is PM add 12 (Unless it is 12 PM).
[Debug]You receive "Map "" doesn't exist" debug messages while changing castle ownership - Ignore these, it's a temporary bug I'll fix later. There is no adverse side effects.
[In-game]Your plug-in didn't show up in the NPC's menu - You need to load the plug-in by restarting the map server, not using @loadnpc or @reloadscript.
You're using TXT - This is SQL only; why on earth are you still using TXT?
You're using stable - Use trunk, like the huge red letters below state.
Your server MUST be TRUNK SQL and at LEAST SVN 13202 to properly work, and there are some reported cases that SVN 13202 doesn't work, so I recommend an even higher SVN. It is also highly recommended your server SQL account has table creation privileges for the first time the script is run.
Install instructions: First off make sure you HAVE THE LATEST SVN! Now onto the real part, unrar the downloaded file to a new folder, CUT the guild folder, guild2 folder, scripts_guild.conf file, and the scripts_woe.conf file and PASTE them IN your server's NPC FOLDER, overwrite everything. Now in the custom folder from the rar cut the woe_setter_3.txt and Plugins folder and paste them in your npc/custom folder. Add this to your scripts_main.conf in your npc folder; "import: npc/scripts_woe.conf". Now open scripts_woe.conf with notepad, uncomment and plugin lines you wish to load with the script. You're done, start the server and have fun (You must either @reloadscript or restart the entire server)! Report bugs!
Download-Updated When Changed.
To the pro scripters out there: If you find optimizations to the script, send em in a PM to me! And yes, I know the tick count function is severely...dilapidated... But it seems to work, so i'm fine with it
Reporting ANY bugs is very appreciated, even minor spelling bugs I'd like to fix. I have not tested this script much, so your replies are very appreciated. Note: WoE (In specific, agit and agit2) for both normal and second edition are ALWAYS ON, do NOT use @agistart{2} and @agitend{2} because it may have serious side effects with automatic WoE times. Though they are always on, emperium should not spawn unless this script has a WoE time active! And remember, have fun!!
@L0ne_Wolf/Anyone who is going to officially optimize the WoE SE script: Give me a heads up to the structure of the new script, so i can update this script so it'll work with the new WoE SE'!
Mirrors are welcome!
Created by: [GM]Xeon
Global Version: 3.4.2
Features:
Players can view a detailed listing [Is it active now? What towns it applies to, what castles it applies to, the start/end day, hour, minute] of all WoE times that are set and it it sorted by which WoE is next.
GM's can add, modify and delete WoE times
WoE times can be set to any town, and multiple at the same time!
WoE times can be set to any castles within the selected town(s) at the same time!
WoE times can be set for all the classic towns and castles, as well as the new second edition ones!
WoE time starts/ends can be randomized by a specified amount of seconds. This only works to an extent.. See known bugs.
WoE can be manually started/ended.
WoE may resume in the event of a server crash.
Mob spawns in empty castles can be disabled.
Script automatically creates the SQL tables for you on the first load!
See plug-ins for extended features.
Plug-ins:
Player - Castle Ownership View
GM - Change/Release Castle Ownership
GM - Edit Castle Investments
GM - Guild Information Query Tool
GM - Guild Manager Jump-to
Player - Guild Recruiter
GM - Treasure Spawner
GM - Enable/Disable Treasure Spawns
Player - Secured Guild Storage
Player - Guild Mailbox
GM - Castle/Emperium Warp-to
Player - Secure Guild Bank
Known Bugs:
WoE time randomization is only set when the time is added or modified. NOT when the script automatically updates the tick columns in the SQL table. I'll fix this in a future version.
When a server crashes or is shut down, WoE times *may* not resume when it's back up. Test this thoroughly for me please =).
Disabling mob spawns in empty castles will not kill them if they already spawned, restarting the server or killing them manually solves this problem.
Modifying a WoE time while it is active to a time frame where WoE should not be active currently (Is NOT smart) does NOT automatically stop the WoE, so you should stop it beforehand! (This does not apply to extended active WoE times, that works perfect.)
Future Features:
Available upon request
Changes: (Bug fixes and optimizations not recorded here, check the change log inside the rar)
v1.x: The original WoE Setter script by Fredzilla. The foundation and guideline of the WoE Setter series by me.
v2.x: What I consider my old school highly unoptimized WoE setter
v3.0: The new generation of WoE management created! (This script )
v3.1: NPC now has a WoE start/end time message above its head (Very useful for testing!), can manually start WoE through the NPC GM menu, players can view a list of what guilds own what castles.
v3.2: Castle ownership can now be changed through the NPC.
v3.3: Added treasure spawn function and Emperium breaker announce.
v3.4: Added plug-in mod
If you see...:
[Error]AgitStart2; Expect command, missing function name or calling undeclared function when the script loads - Update your SVN (It has to be the LATEST, not "Oh, it's close enough. 3 weeks old.")! Please guys, DO NOT REPLY SAYING YOU GET A RUNTIME ERROR BECAUSE YOUR SVN IS OUTDATED!
[SQL]DB error - Table 'woe_times' doesn't exist, displayed on the map server when the script loads or you try to use it - You must either @reloadscript or restart your server so the OnInit in the main script executes. You cannot @loadnpc this for the first time! If the problem persists, read the next error about not being able to create the table and use that solution.
[SQL]You don't have permission to create the table in MySQL, displayed on the map server when the script loads - Open the .sql file included in the rar and highlight the code, paste it into your favorite SQL client (query browser, myphpadmin, etc.). Also, if the error keeps happening (Which it will if your server SQL account doesn't have table creation privs) on every server OnInit, simply comment the line starting with 'query_sql("CREATE'.
[Error]Your PC constantly beeps and gives you hundreds of "unmatch )" messages when the script loads - Your SVN is way outdated and doesn't support agistart/end2; and agitcheck2(); update your SVN!
[In-game]I set a WoE time and it won't start when it's supposed to! - Verify you updated your scripts_guild.conf/guild folder/guild2 folder with the rar, then verify that the time you set was not set to a time that was in the past to present/future, because then it'll just default to starting next week. Also, make sure you set the time in MILITARY TIME, i.e. a 24-hour clock. Not AM/PM, 0:00-23:59, 0=12 AM, 23=11 PM. Easy trick to know military time: If the current time is AM that is the hour to enter (12AM=00 though), if it is PM add 12 (Unless it is 12 PM).
[Debug]You receive "Map "" doesn't exist" debug messages while changing castle ownership - Ignore these, it's a temporary bug I'll fix later. There is no adverse side effects.
[In-game]Your plug-in didn't show up in the NPC's menu - You need to load the plug-in by restarting the map server, not using @loadnpc or @reloadscript.
You're using TXT - This is SQL only; why on earth are you still using TXT?
You're using stable - Use trunk, like the huge red letters below state.
Your server MUST be TRUNK SQL and at LEAST SVN 13202 to properly work, and there are some reported cases that SVN 13202 doesn't work, so I recommend an even higher SVN. It is also highly recommended your server SQL account has table creation privileges for the first time the script is run.
Install instructions: First off make sure you HAVE THE LATEST SVN! Now onto the real part, unrar the downloaded file to a new folder, CUT the guild folder, guild2 folder, scripts_guild.conf file, and the scripts_woe.conf file and PASTE them IN your server's NPC FOLDER, overwrite everything. Now in the custom folder from the rar cut the woe_setter_3.txt and Plugins folder and paste them in your npc/custom folder. Add this to your scripts_main.conf in your npc folder; "import: npc/scripts_woe.conf". Now open scripts_woe.conf with notepad, uncomment and plugin lines you wish to load with the script. You're done, start the server and have fun (You must either @reloadscript or restart the entire server)! Report bugs!
Download-Updated When Changed.
To the pro scripters out there: If you find optimizations to the script, send em in a PM to me! And yes, I know the tick count function is severely...dilapidated... But it seems to work, so i'm fine with it
Reporting ANY bugs is very appreciated, even minor spelling bugs I'd like to fix. I have not tested this script much, so your replies are very appreciated. Note: WoE (In specific, agit and agit2) for both normal and second edition are ALWAYS ON, do NOT use @agistart{2} and @agitend{2} because it may have serious side effects with automatic WoE times. Though they are always on, emperium should not spawn unless this script has a WoE time active! And remember, have fun!!
@L0ne_Wolf/Anyone who is going to officially optimize the WoE SE script: Give me a heads up to the structure of the new script, so i can update this script so it'll work with the new WoE SE'!
Mirrors are welcome!
Event Consol Operator
Heres a little me and my other scripter made during our time. Its basically a npc that keeps track of all your events your game masters do. When a lv 99 admin accesses it , The npc has more options such as change the amount of events a game master can do. There might be some bugs if any please report. You can fully see what other features this npc has.
Script Here
Change this set of arrays to your game masters account ID.
Note- Its probably a little bugged since i pulled it outta my files because i barely use it any more. I will update it though if there is any bugs.
Script Here
//------GM Account Numbers----
setarray $GMs[0], 2000000, 2000001, 2000022, 2000059, 2000060, 2000076, 2000079;
Change this set of arrays to your game masters account ID.
Note- Its probably a little bugged since i pulled it outta my files because i barely use it any more. I will update it though if there is any bugs.
Item Database Creator
This is a new standardized program which allows you to not only easily create items but allows you to automatically insert into your sql stream. This will update your sql database for you so you do not need any sql injection code. Simple fill out the form and press the add item button. From there go into your sql database and it should simply be there.
Installation
1. Download From Here http://deciccoro.com/database%20maker.rar
2. Extract to where you want.
3. Open the connection txt file. Fill in the right requirements. Such as database name and password and the ragnarok database.
4. Open the program it self and its easy to use. Self explanitory.
Changing The Database Structure.
Easy as 1,2,3 all you will have to do is open up the item database script txt file and change the structure of how the table is set.
Features
1. Allows you to import a view ids through txt file in your data folder.
2. Automatically inserts db injection into the database it self.
3. Hack protect system.
4. DDOS Attack prevention
Installation
1. Download From Here http://deciccoro.com/database%20maker.rar
2. Extract to where you want.
3. Open the connection txt file. Fill in the right requirements. Such as database name and password and the ragnarok database.
4. Open the program it self and its easy to use. Self explanitory.
Changing The Database Structure.
Easy as 1,2,3 all you will have to do is open up the item database script txt file and change the structure of how the table is set.
Features
1. Allows you to import a view ids through txt file in your data folder.
2. Automatically inserts db injection into the database it self.
3. Hack protect system.
4. DDOS Attack prevention
Welcome
Welcome to the eA pro blog. Our goal is a new revolution of eAthena. As we expected eAthena members are getting lazy. Well were hear to pick up on things. Though to you this might look like a simple blog. We are hear to offer you knowledge and download's that will not be offered on eAthena support board.
Current Leaders of this blog are Kaosin,GM Xeon.
You may think hey look a simple blog its nothing compared to the eAthena support board. We will prove thoughs who think that wrong. When you see the scripts stop being made you will wonder what the hell happened. Well heres where you can find them now.
Current Leaders of this blog are Kaosin,GM Xeon.
You may think hey look a simple blog its nothing compared to the eAthena support board. We will prove thoughs who think that wrong. When you see the scripts stop being made you will wonder what the hell happened. Well heres where you can find them now.
Subscribe to:
Posts (Atom)
Posts
