The 2nd(?) ASP.NET website released

[Objected]

Hey guys.

If anyone remembers this thread, still located on the front page of the FlyFF discussion section, you would see that I said I would release an ASP.NET website.

It's been a while since I've said that, but since yesterday, I've been working on it.

I used the following template as my base: http://forum.ragezone.com/f457/flyff-template-692109/

If anyone remembers this, you would see that a long time ago, I made that same site into PHP. Terrible coding. Just awful. So I decided to just bring the template back and revamp it into ASP.NET.

By the way, this website is developed to have automatic SQL injection protection (CMD.Parameters.AddWithValue = Prepared Statements).


Now, let's get down to HOW to use this.

You need to edit your SQL configuration details, Vote Link, and your FULL website address in WEB.CONFIG

The following is what it looks like:

  <appSettings>
    <add key="Website" value="http://localhost:5933/FlyFFCP/"/>
    <add key="VoteLink" value="http://google.com/"/>
    
    <add key="ConnectionString" value="Data Source=COMPUTER-PC\SQLEXPRESS;User Id=sa;Password=PASSWORD;Initial Catalog=ACCOUNT_DBF"/>
  </appSettings>

What you need to edit is what's located in "Website", "VoteLink", and "ConnectionString".

The format for ConnectionString is the following:
Data Source=COMPUTER-PC\SQLEXPRESS;User Id=sa;Password=PASSWORD;Initial Catalog=ACCOUNT_DBF

Data Source = The SQL database instance name.
User Id = the username of the database.
Password = The SQL password.
Initial Catalog = The database automatically selected (DO NOT EDIT THIS).

Vote Link can pertain to anything such as GTOP, Xtreme, etc.



There is a feature disabled in the website.

The feature is the "Server Peak". Since the database I have is only the account and character databases, I didn't "activate" Server peak, because it was in beta. If you want to try it, just do the following:

Open Site.master.

Find this line:

Server status: <span id="status" runat="server"></span> | Users online: <span id="users_online" runat="server"></span><!--| Server Peak: <span id="user_peak" runat="server"></span>-->

Change it to:

Server status: <span id="status" runat="server"></span> | Users online: <span id="users_online" runat="server"></span> | Server Peak: <span id="user_peak" runat="server"></span>

Open Site.Master.cs

Go to line 47

Uncomment line numbers 48-54.

Recompile/Build. Try it out.


This is obviously coded in C# (VB sucks). The "Master" template is located in "Site.Master", and the code of "Site.Master", is located in "Site.Master.cs".

Every page name speaks for itself on what's located inside of it. All features located on the website are complete.

I believe the only features that may have bugs are the "Lord, MVP, and GS winners", and the "Server Peak".


This is the first ASP.NET website that I've done completely. Who knows how it'll go. But as far as I know, it works. And it works just fine.


The following was used to test the website:
Visual Studio 2010 Ultimate
Visual Studio 2010 Ultimate's Web Server Testing
Microsoft SQL Server 2008

THE FOLLOWING IS RECOMMENDED TO RUN THIS WEBSITE
IIS
Microsoft SQL Server 2008

If you are using WAMP, XAMPP, or any other shitty webserver, I suggest you not use this website. You will only complicate things. Just switch to IIS.



If you have any issues, report them here.

[MentaL]

[ShadowDragon]

Heh, funny. That site you mentioned at the top was the template I used for my first flyff server xD

This might just give me a reason to learn some C#... I haven't taken the time to do so yet. Do you think it's possible to run using a 2005 version of MSSQL?

[Objected]

Heh, funny. That site you mentioned at the top was the template I used for my first flyff server xD

This might just give me a reason to learn some C#... I haven't taken the time to do so yet. Do you think it's possible to run using a 2005 version of MSSQL?

It is, I'm positive. It shouldn't matter what SQL version you use, as long as it's up to date with the source, and is compatible with the website, which it should be

[ShadowDragon]

Ah, ok. Cool. I didn't think it would be a problem, it was merely a curiosity thing =P

Either way (and even though I haven't downloaded it yet xD), nice release.

[Matt Clarke]

Brilliant, thanks for this, hopefully I'll try and learn a few things from it.

[Objected]

Thanks.

I'm most likely going to be working on this as a "waste-of-time" project, since I need to practice ASP.NET.

Features possibly to come:

-Login
--Allowed "Locked" Accounts

-When logged in
--"Compare Stats" with friends.
--View Inventory?
--Location of Character
--Is Logged In?
--View Bounty
--Vote


-Admins
--View GM logs
--Remove/Choose GMs
--Execute Bans
--Execute Queries?
--View Vote Logs

[Max98]

Helped me on somethings, thanks for the release!

[Pumbaaa]

First, thanks for your contribution.

I was also wondering, why there's no private server using ASP.net instead of PHP, above all the giants like xor.net.

But there are some things I have to criticize after my first look at your script:
-Why don't you use some validators implemented by microsoft like RequiredFieldValidator?
-You could also embed your functions into a dll and "link" it to your project
-You could initialize your SQL Connections by starting the web application and check for lost connections

But all in all nice work, keep it up dude.

[Objected]

I was also wondering, why there's no private server using ASP.net instead of PHP, above all the giants like xor.net.

PHP seems to be a simple language to learn. Guilty myself; I spent my time with PHP for over 2-3 years. It's simple and it works, right?

-Why don't you use some validators implemented by microsoft like RequiredFieldValidator?

I haven't worked with the validators. Since this is one of my first ASP.NET projects, I'm kind of happy with the turn out. Thanks for that suggestion, though.

-You could also embed your functions into a dll and "link" it to your project

Like I said, first ASP.NET project. Haven't looked into DLLs, but I'm sure I will in the future.

-You could initialize your SQL Connections by starting the web application and check for lost connections

Elaborate?