trickyloki3

It is very easy with Python.
 
1. Create an email account
2. Select a SMTP server (Microsoft or Google)
3. Create MySQL user account with select privileges on last login column in login table.
4. Connect to MySQL server using limited privilege MySQL user account with SqlAlchemy (http://www.sqlalchemy.org)
5. Query database and calculate the datetime difference to get timedelta, which gives number of days, hours, and seconds. (https://docs.python.org/2/library/datetime.html)
6. Send email via SMTP server for all user's last login > 20 days. (https://docs.python.org/2/library/smtplib.html)
7. Create separate user account on system. (https://pypi.python.org/pypi/python-crontab)
8. Schedule script on crontab to run on some interval using new user account.
 
Can be done in less than 100 lines. (Unless you want to use the ORM to map all the tables.)
 
Deploy on some cloud instance
1. Buy a cloud instance for $5 per month or less.
2. Setup SSL certificates for MySQL server master and slave. (Self-signed root CA is ok)
3. Setup Iptables to allow cloud instance to connect on MySQL port.
4. Setup MySQL slave replication.
5. Write automation script that use slave replication server. (Which also double as backup)

Todo
 * Create Visual Studio project for compilation on Windows.  * Create Autotools for compilation on Unix and Linux.  * Write guides on how to use the stupid program.

a few suggestions:
 
Trade: {                      (defaults to no restrictions) override: GroupID             (int, defaults to 100) nodrop: true/false            (boolean, defaults to false) notrade: true/false           (boolean, defaults to false) partneroverride: true/false   (boolean, defaults to false) noselltonpc: true/false       (boolean, defaults to false) nocart: true/false            (boolean, defaults to false) nostorage: true/false         (boolean, defaults to false) nogstorage: true/false        (boolean, defaults to false) nomail: true/false            (boolean, defaults to false) noauction: true/false         (boolean, defaults to false) }  1 - to tell the item restrictions (in red)
 
2 - Jobs that can use
3 - Loc: Equip location
4 - EquipLv: Equip required level (EquipLv: [min, max] too)
5 - Refine: if is refineable
6 - Atk and Def
7 - Item Weight
 
and what about instead of:
 
Gain 600000 ~ 1200000 (based on random 600000 ~ 1200000) 
 
just say this:
 
Gain between 600000 and 1200000 guild experience.
 
and there is a typo on "enemy"
 
Add +1% chance of casting Fire Bolt[Lv.3] on enemey and random skill level when receiving physical damage. Add +1% chance of casting Cold Bolt[Lv.3] on enemey and random skill level when receiving physical damage. Add +1% chance of casting Lightning Bolt[Lv.3] on enemey and random skill level when receiving physical damage.       great tool you got there I'll use it for sure in my custom items after you add the above suggested xD keep up the good work!

ItemDB Script Translation Project
Project License: MIT
Project Site: https://github.com/trickyloki3/eAdb.Compiler3
Language: C
Project Alt Link: http://forum.ratemyserver.net/ro-graphic-coding-media/itemdb-translation-project/
Project Alt Link: http://rathena.org/board/topic/99684-itemdb-script-translation-project/
 
dbro: an item database that uses eadb.compiler http://devilishro.net/ (currently in development)

Hi everyone,
 
I've developed a complete program that can translate item scripts (consisting of a subset of the scripting language) into English translations.

The program is developed to streamline item development and couple the item database with item client tables.
 
Please let me know how to improve the project.
 
Thank you!
 
Project Update  * Support pet script and pet loyal script.  * Support item combo bonus.  * Support bonus minimization.  * Simplified packages and boxes.  * Support project integration; exit-free and memory-leak free.  * Support for-loop (limited) w/ iterable set blocks.  * Simplify complex expressions.  * Support pre-renewal and renewal eAthena, rAthena, and Hercules databases.  * Support flavour text and item attribute in final translation.  * Support eAthena, rAthena, Hercules idnum2itemdesctable.txt format generation.  * Support Hercules' bindonequip, buyingstore, delay, stack, and trade settings.  * Support eAthena, rAthena, Hercules itemInfo.lua format generation.   Testing  * Generated itemInfo.lua tested on client 20130807a.   Todo  * Create Visual Studio project for compilation on Windows.  * Create Autotools for compilation on Unix and Linux.  * Write guides on how to use the stupid program.   You can get the latest item description translation over on my project page on GitHub.   I've added both the idnum2itemdesctable.txt and itemInfo.lua formats for eAthena, rAthena, and Hercules, including pre-renewal and renewal.   https://github.com/trickyloki3/eAdb.Compiler3

Currently working on make this project accessible to everyone.
 
Since Hercules uses a modified grammar for libconfig to support <" "> multiline scripts, I can't maintain my current license if I package the modified libconfig library or code with my project.
 
My new plan of action is to write database converters for eAthena, rAthena, and Hercules and dump everything into a sqlite3 database file that comes bundle with the project.
 
This means that if you want the project to work with your custom databases, then you need to run the database converters for your emulator.
This is more difficult with Hercules because you need to build and link the modified libconfig library under 3rdparty/libconfig. (As the standard libconfig-devel does not support <" ">)
 
More soon.

Update.
 
New project repository: https://github.com/trickyloki3/eAdb.Compiler3
 
The project is almost finished.
 
Currently supports eAthena, rAthena, and Hercules databases.
 
Still need to fixed some bugs with porting.
 
Goal: Server Item Database -> Item Script -> [eAdb.Compiler] -> Item Script Description-> Client Tables
 
Dumps all databases into a sqlite3 database (~3MB)
./conv [eathena, rathena, hercules, all]
 
Dumps Hercules databases into sqlite3 database (~1MB)
[separate compilation 'make hitem' requires compiling and linking Hercules' Libconfig (See 3rdparty/libconfig in Hercules' git repository)]
./hitem
 
Uses athena.db database to generate English translation for item database
./item [eathena, rathena, hercules]

Update.
 
New project repository: https://github.com/trickyloki3/eAdb.Compiler3
 
The project is almost finished.
 
Currently supports eAthena, rAthena, and Hercules databases.
 
Still need to fixed some bugs with porting.
 
Goal: Server Item Database -> Item Script -> [eAdb.Compiler] -> Item Script Description-> Client Tables
 
Dumps all databases into a sqlite3 database (~3MB)
./conv [eathena, rathena, hercules, all]
 
Dumps Hercules databases into sqlite3 database (~1MB)
[separate compilation 'make hitem' requires compiling and linking Hercules' Libconfig (See 3rdparty/libconfig in Hercules' git repository)]
./hitem
 
Uses athena.db database to generate English translation for item database
./item [eathena, rathena, hercules]

Hey everyone, the project has reached a point where it can compile a subset of the scripting language.   I've attach with the this post a sample of a translation of an rAthena item_db.txt to idnum2itemdesctable.txt. (Support for Hercules coming soon or if some program exist to convert Hercules' databases to rAthena databases.)   Warning: (for-loop is not implemented so comment out that one item; official database may contain about ~5 errors) and (pow() handling produces awkward results) and some integer-post processing may be off by one digit.   For example,  Item ID: 13110  Item Name: Glorious Pistol Item Script: bonus2 bAddRace,RC_DemiHuman,55; bonus2 bAddRace,RC_Player,55; bonus2 bIgnoreDefRaceRate,RC_DemiHuman,20; bonus2 bIgnoreDefRaceRate,RC_Player,20; bonus bUnbreakableWeapon,0;if(getrefine()>5) {  bonus2 bAddRace,RC_DemiHuman,pow(((getrefine()>14)?14:getrefine())-4,2);  bonus2 bAddRace,RC_Player,pow(((getrefine()>14)?14:getrefine())-4,2);  bonus2 bIgnoreDefRaceRate,RC_DemiHuman,5;  bonus2 bIgnoreDefRaceRate,RC_Player,5; } if(getrefine()>8) {  bonus4 bAutoSpellOnSkill,"GS_RAPIDSHOWER","GS_GLITTERING",1,1000;  bonus2 bSkillAtk,"GS_RAPIDSHOWER",getrefine()*2;}   Item Translation: Add +55% physical damage against demi-human monsters.Add +55% physical damage against mvp monsters.Pierce +20% physical defense for demi-human monsters.Pierce +20% physical defense for mvp monsters.Weapon is indestructible.Condition [Refine Rate 6 ~ 15] -> Add -121% ~ +121% physical damage against demi-human monsters. -> Add -121% ~ +121% physical damage against mvp monsters. -> Pierce +5% physical defense for demi-human monsters. -> Pierce +5% physical defense for mvp monsters.Condition [Refine Rate 9 ~ 15] -> Add 100% chance of auto-casting Rapid Shower[Lv.1] when using Flip the Coin. -> Increase +18% ~ +30% Rapid Shower damage. idnum2itemdesctable.txt

ItemDB Script Translation Project
Project License: MIT
Project Site: https://github.com/trickyloki3/eAdb.Compiler3
Language: C
Project Alt Link: http://forum.ratemyserver.net/ro-graphic-coding-media/itemdb-translation-project/
Project Alt Link: http://rathena.org/board/topic/99684-itemdb-script-translation-project/
 
dbro: an item database that uses eadb.compiler http://devilishro.net/ (currently in development)

Hi everyone,
 
I've developed a complete program that can translate item scripts (consisting of a subset of the scripting language) into English translations.

The program is developed to streamline item development and couple the item database with item client tables.
 
Please let me know how to improve the project.
 
Thank you!
 
Project Update  * Support pet script and pet loyal script.  * Support item combo bonus.  * Support bonus minimization.  * Simplified packages and boxes.  * Support project integration; exit-free and memory-leak free.  * Support for-loop (limited) w/ iterable set blocks.  * Simplify complex expressions.  * Support pre-renewal and renewal eAthena, rAthena, and Hercules databases.  * Support flavour text and item attribute in final translation.  * Support eAthena, rAthena, Hercules idnum2itemdesctable.txt format generation.  * Support Hercules' bindonequip, buyingstore, delay, stack, and trade settings.  * Support eAthena, rAthena, Hercules itemInfo.lua format generation.   Testing  * Generated itemInfo.lua tested on client 20130807a.   Todo  * Create Visual Studio project for compilation on Windows.  * Create Autotools for compilation on Unix and Linux.  * Write guides on how to use the stupid program.   You can get the latest item description translation over on my project page on GitHub.   I've added both the idnum2itemdesctable.txt and itemInfo.lua formats for eAthena, rAthena, and Hercules, including pre-renewal and renewal.   https://github.com/trickyloki3/eAdb.Compiler3