[Release] JetWeb - A simple Aion 4.6 (retail) website

[AKllX]

Hello Guys,

Since I have no use for this anymore I would like to share this files as some may find them useful.

It's a basic website implementation with login, password recovery system, rankings and e-mail confirmation. Nothing too fancy, just the basics for a server operation.


To compile this you will need:

1. Visual Studio Community 2019
2. .NET Core 5.0

To run it properly you will need:

1. Microsoft IIS configured to use Razor Pages (see here: https://docs.microsoft.com/en-us/asp...=visual-studio)

2. Edit the connected services on Visual Studio to match your MSSQL Connection Strings (see Connected Services.png inside the files)

3. Edit AionAccountFactory.cs to match your MSSQL Server connection String

4. Edit RedeemHelper.cs to match your MSSQL Server connection String

5. Edit the appsettings.json to match your SMTP server



Please notice:

The website is on Portuguese. Fell free to translate it.
The website doesn't work with JAVA Emulated Servers.
The website is far from fully optimized code-wise but it is totally stable as it is.
The website uses .NET Core 5.0 Razor Pages and the latest .NET EF Core Entity Framework to handle all queries, making it very fast for MSSQL usage. Anyway, for larger servers you should consider caching the rankings.


I will not provide any documentation or guide on how to use or install it.

Previews:

https://ibb.co/jbKSt2r
https://ibb.co/Qd4CGYH

Download: https://1drv.ms/u/s!ApYgV1mh5159i6kqjvLJ_7_59MM1sQ?e=sJgSrG

[MentaL]

[vitala]

Connected server =all configurated , but have this erorr:

[AKllX]

To make it work, at Visual Studio you must do the following:

Go to the menu Project -> Add Connected Service

You must add 4 MSSQL Server Services as the following:


Website connection and DefaultConnection are connected to the 'website' database
AionWorldConnection is connected to the 'AionWorld_110' database
AionAccountsConnection is connected to the 'AionAccounts' database

If you don't want to use the Connected Services, you can also use the appsettings.json as this:

{
  "ConnectionStrings": {
    "AccountConnection": "Data Source=AVELL;Initial Catalog=AionAccounts;Integrated Security=True",
    "AccountsConnection": "Data Source=AVELL;Initial Catalog=AionAccounts;Integrated Security=True",
    "AionAccounts": "Data Source=AVELL;Initial Catalog=AionAccounts;Integrated Security=True",
    "AionAccountsConnection": "Data Source=AVELL;Initial Catalog=AionAccounts;Integrated Security=True",
    "AionWorldConnection": "Data Source=AVELL;Initial Catalog=AionWorld_110;Integrated Security=True",
    "DefaultConnection": "Data Source=AVELL;Initial Catalog=website;Integrated Security=True",
    "WebsiteConnection": "Data Source=AVELL;Initial Catalog=website;Integrated Security=True"
  },
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft": "Warning",
      "Microsoft.Hosting.Lifetime": "Information"
    }
  },
  "EmailSettings": {
    "PrimaryDomain": "smtp.gmail.com",
    "PrimaryPort": "587",
    "UsernameEmail": "your_mail",
    "UsernamePassword": "your_pass"
  },
  "AllowedHosts": "*"
}  

Make sure to fix the datasources to your MSSQL server. I highly recommend to use Integrated Security if you are running the website at the same machine as the IIS Server.

At last, you must change the 'Siel' server name on the following piece of code to match your server name (as it is in the worldstatus table at AionAccounts table:

[vitala]

thx man all working

[gondracorn]

Do I need .net Core sdk and is it console or application version?

Also, there is no .net CORE 5.0. Latest is 3.0

[Kreeate]

Do I need .net Core sdk and is it console or application version?

Also, there is no .net CORE 5.0. Latest is 3.0

You sure you understand how the internet works?

.NET Core 5.0.0

[gondracorn]

Which one? There's tons of them.

[Kreeate]

Which one? There's tons of them.

Assuming you're on Windows 64 bit... this one.

[gondracorn]

@Kreeate

Ah, ok, the SDK version. I didn't know it was supposed to be SDK.

Also, I need help in starting this up. I don't know what I am doing, I looked at the guide page here: https://docs.microsoft.com/en-us/asp...=visual-studio

But it says something about having IIS server manager. I cannot find the app on my Windows 10 system (server manager) to install IIS. Do I need an actual Windows Server operating system? If so, I am out of luck unless someone else wants to build this site for me (I don't even know if that is possible?!)

[AKllX]

@Kreeate

Ah, ok, the SDK version. I didn't know it was supposed to be SDK.

Also, I need help in starting this up. I don't know what I am doing, I looked at the guide page here: https://docs.microsoft.com/en-us/asp...=visual-studio

But it says something about having IIS server manager. I cannot find the app on my Windows 10 system (server manager) to install IIS. Do I need an actual Windows Server operating system? If so, I am out of luck unless someone else wants to build this site for me (I don't even know if that is possible?!)

The Windows IIS Server is necessary only for production servers. If you want to test and customize the files the best aproach is to run it using the Visual Studio embedded Web Server or IIS Express. Both are available on Visual Studio Community default installation. You should do the minimum configuration I explained here before using the Debug function.

[gondracorn]

It says I'm missing dependancies, like ASPnet Core, even after I download and install .Net SDK

- - - Updated - - -

I'm trying to add connected services.

It looks like it's all set up, but for some reason, when I click "Edit Dependency", the server name has an empty list...

[gondracorn]

3. Edit AionAccountFactory.cs to match your MSSQL Server connection String

4. Edit RedeemHelper.cs to match your MSSQL Server connection String

5. Edit the appsettings.json to match your SMTP server

So, with these three steps, could you show a picture and a text describing what I need to change in order to make it work for my machine? Cause just saying "match your MSSQL Server Connection String" doesn't tell me much, cause I'm not sure what to change or where to change it in those files.

Also, how would I run this? When I go to 127.0.0.1, I enter the IIS main page, but there's nothing for my website

[gondracorn]

Ok, I think I was smart enough to figure it out. I had to change the username and password.

But the last part is tricky, how do I go about retrieving the actual web page.

[AKllX]

Ok, I think I was smart enough to figure it out. I had to change the username and password.

But the last part is tricky, how do I go about retrieving the actual web page.

Hit 'Run' (F5) in Visual Studio. A console window should open up and thats your webserver for testes. Any other erros that my occur during runtime should show there or on Visual Studio itself if you are running a 'Debug' compilation.

[gondracorn]

Yeah, I received an error when running, same old problem, cannot connect to AionAccounts.