[Development] Origin - Mu Online Website Engine

[KristiansJ]

What is Origin?

Origin is mu online website created using PHP 7.3 / Laravel 5.8 / jQuery / Boostrap 4. Website is created using Laravel project standarts like using built-in translations, blade templates, validations, request validations, etc...

Origins Goals?

Origin is planned to be multi function web site engine witch goal is to support most popular games. In short - one website, one registration, multiple games - use one account in all supported games.

Database

Origin will require separate connection to database, witch can be configured (By default MySQL). Origin use Laravel Eloquent driver and php pdo extension, so any databases that is Supported by them are supported in Origin. I'm limiting my self to use standart data types only, so they would be supported in all databases.

Currently development is slow since i don't host Mu Server personally, if someone would provide limited access to live server or at-least populated database with some characters(preferably 1 character for each class,etc), etc the development would happen much faster.

Currently i use IGCN x12 - Mu Emu server file database to create this website. If you have any ideas on what server database use as base, please feel free to share this information, since it's been a while since i created something for Mu.

Hosting

Origin will require vps hosting solution on same server (as mu online server) or separate server, it will use Laravel built-in task manager system witch requires additional scripts running in background (using terminal or command promp). Website will require some-kind of caching solution (there are many available built-in, from what you can choose) witch may require additional software installation.

Change Log

• Implemented basic Role, Game management,etc
• Started to work on Mu Online extensions
  
  • Account and Character edition
  • Implemented Reset system by user Role, Characters class
  
  
• I will make full change log when i have more time.
• Github will be updated soon.

Mu Online Plugin Descriptions

Mu Online Plugins
- Character Reset
    - Create resets based on User Role (example: VIP, Game Master, etc), Character class (example: Dark Wizard, Grand Master, etc) or combination of both.
        - If no Role or Class is selected Reset rules will apply for all Characters that do not have any Reset Rules defined.
    - Set amount of resets that character receive after performing one reset.
    - Possibility to reset Level, Stats, Money.
    - 3 Reset types to choose from Reset /
    - Possibility to set Reset types: Keep, Reset (to defined amount), Bonus (Keep and adds bonus amount).
    - Possibility to set multiply formulas, examples bellow
        - Reset Level
            - Type: Reset level
            - Level: 1 (Character resets to level 1)
            - Multiply level limit: 250 (Max amount of level, that character can receive after performing reset)
            - Multiply level formula: resets * level
                - This means after performing:
                    - 1 reset, character will start from level 1
                    - 2 reset, character will start from level 2
                    - and so on...
            - Multiply level formula: (resets * level) * 2
                - This means after performing:
                    - 1 reset, character will start from level 2
                    - 2 reset, character will start from level 4
                    - and so on...
            - Multiply level limit: 250 (This means character can't gain more level of 250 from reset)
    - Multiply formulas excepts all mathematical expression and special keywords
        - resets (current character reset count, before current reset)
        - money (current character money count)
        - points (current character level up point count)
        - etc...

Sample




Github: https://github.com/KristiansJaunzems/Origin

Any ideas are welcome, project will be released under MIT license.

Older Information

Video Preview #1: https://www.youtube.com/watch?v=Gwk9KHblfro
Video Preview #2: https://www.youtube.com/watch?v=DBB12CQnDxg

[MentaL]

[Saige]

Goo Job, I have Questions :D

1. it is required to use SQL Server connection 2017, or its possible to use lower version?
2. How About the Security Like Protection for SQL Inject?

Thanks Nice Web :)

[KristiansJ]

Goo Job, I have Questions :D

1. it is required to use SQL Server connection 2017, or its possible to use lower version?
2. How About the Security Like Protection for SQL Inject?

Thanks Nice Web :)

1. PHP PDO SQL Server v5.6 extension officially supports Microsoft SQL Server from 2008 till 2017.
https://docs.microsoft.com/en-us/sql...ql-server-2017
2. Laravel has sql injection protection built-in

Laravel's database query builder provides a convenient, fluent interface to creating and running database queries. It can be used to perform most database operations in your application and works on all supported database systems. The Laravel query builder uses PDO parameter binding to protect your application against SQL injection attacks. There is no need to clean strings being passed as bindings.

https://laravel.com/docs/5.6/queries#introduction

[Saige]

My Suggestion Either Use IGCN or MUEMU Database its better than others. or use MUEMU since that was famous since source is already release :D.


Change Value if you want to make it work to MU?

'default' => env('DB_CONNECTION', 'mysql'),
to
'default' => env('DB_CONNECTION', 'muonline'),

ill try this in vps then lets see....

[robiiiis]

Very nice, at last someone building MuOnline website on Laravel framework. Lot of things to work on, but i want to see progress on this web!

MySQL
I haven't decided yet, but i have idea to separate all website related functions to separate mysql database, like, news, profiles,pages,modules etc.

I mean, profiles, all info about chars, rankings and so on should come from SQL Server db, but news etc. on MySql db.

[nevS]

Why not put it all into the mssql database, just maybe into a separate schema? Installing a separate dbms just for some small additional tables seems odd to me. If it’s for performance, you can cache this web stuff in memory, too.

[KristiansJ]

My Suggestion Either Use IGCN or MUEMU Database its better than others. or use MUEMU since that was famous since source is already release :D.


Change Value if you want to make it work to MU?

'default' => env('DB_CONNECTION', 'mysql'),
to
'default' => env('DB_CONNECTION', 'muonline'),

ill try this in vps then lets see....

To configure website you must edit .env file located in main directory. I'm basing this project on MuEMU Season 12 database.

EDIT:

before running composer update column, open composer.json file and remove this line:

"laravel/nova": "~2.0"

after that open config/app.php file and remove

/*
* Package Service Providers...
*/
App\Providers\NovaServiceProvider::class,

[tangyi90]

Download link isn`t work

[hieptd]

it doesn't work anymore