[Release] Admin Panel

[nubness]

Hello everyone,

As we all well know, there's a couple of web based admin panels flying around, which have all been used by a lot of people who want to make their life easier.

I was told these admin panels are vulnerable to SQL injection, which as I was also told, lead to the destruction of many servers.

After months of work, with a few little pauses, I have just recently finished working on the application I was mentioning earlier. I was initially going to sell it, but then I remembered I haven't made a free release in quite a long while, so here we are - a free, fully functional, and most important, secure admin panel.

It is divided into 6 compartiments

• Character Management
  • Full character management
• Account Management
  • Full account management
• Statistics
  • Character Statistics
    • by Kills
    • by Stats
    • ...
  • Account Statistics
    • by DP
  • Guild Statistics
    • by guild points
    • by amount of members
    • by creation date
• Logs
  • Chat Logs
  • Log Logs
  • Kill Logs
  • Death Logs
  • Transaction Logs
  • Illegal Links Logs
  • Illegal Transaction Logs
  • Boss Death Logs
  • Command Logs
• Item Management
  • Character's Inventory
  • Account's Warehouse
  • Item Editor
• Actions
  • Clear Logs
  • Send Item to Gift Box
  • Remove an Item from the game
  • Guild Rename
  • Guild Leader Change

I could explain everything in detail, but a picture is worth a thousand words.

The archive I attached below contains 3 files:

• Admin Panel.exe
• PS_GameLog.mdf
• PS_GameLog.ldf

For having a more functional log system, and decreasing log processing time, I have changed the PS_GameLog database, by spreading the information in multiple tables and not recording the so called junk logs, which are useless. From now on, your logs will only contain useful information.

For those who purchased my custom PS_GameLog, you don't need the PS_GameLog.mdf and PS_GameLog.ldf file, your database is already adjusted to working with this application. The PS_GameLog I have sold has more features than the one released here, which means if you bought it from me, you don't need the one in this release.

For those who haven't purchased the PS_GameLog from me, you will need the PS_GameLog database from this release.

Instructions to replace your PS_GameLog with this custom PS_GameLog

1. Shutdown your server services
2. Open SQL Server Management Studio
3. If you don't want to detach the PS_GameLog database, simply rename it to PS_GameLog2 and go directly to point 6
4. Right click on PS_GameLog -> Tasks -> Detach
5. Check both checkboxes in the window that pops up and press OK
6. Attach the PS_GameLog database from this release

Note : The PS_GameLog database was created on SQL Server 2008 R2, so it will only work on SQL Server 2008 R2 and above. As I stated in numerous other posts, I highly recommend SQL Server 2008 R2 over any other version, so if you're running anything lower than that, do yourself a favor and upgrade to 2008 R2.

The Admin Panel only works on localhost, which means it can only interact with databases from the same machine as the application. You may call this dumb, I call it secure, it cannot be accessed remotely, it cannot be injected, it cannot be DDOSed, nobody even knows if you're using it or not.

Requires .NET Framework 4.0 or above.

If you have anything to say or ask, don't hesitate to do so, as I might not be around for much longer.

For those who are interested in a version of this admin panel with more features and is ready to pay a small price for it, leave me a message and we can work something out.

Enjoy !

[[Admin]ßІί†ž]

[_Diavolino_]

Amazing !!! As all your Services and Releases ! Thank You !

[TeddyBear94]

rly good release chris. I highly appreciate that you shared it with everyone yet it would have been better just to sell it so new ppl still would have to learn there stuff.

Anyway Good Job

[Stureplan]

As teddy mentioned, really nice release.
#Added to Index

[nubness]

Originally Posted by TeddyBear94

rly good release chris. I highly appreciate that you shared it with everyone yet it would have been better just to sell it so new ppl still would have to learn there stuff.

Anyway Good Job

Thanks for the appreciation.

I agree with you, and as easier as this program makes an admin's job, I still recommend everyone to learn SQL. This program clearly doesn't do everything, whereas if you know SQL you can do everything. I've been encouraging everyone who ever asked me SQL questions to learn this language, as it's not difficult at all, and most of them don't even bother to do that, as they prefer making a new thread on elitepvpers to ask for help. At least now there'll be less threads with stupid questions, or so I hope.

[Stureplan]

Originally Posted by nubness

Thanks for the appreciation.

I agree with you, and as easier as this program makes an admin's job, I still recommend everyone to learn SQL. This program clearly doesn't do everything, whereas if you know SQL you can do everything. I've been encouraging everyone who ever asked me SQL questions to learn this language, as it's not difficult at all, and most of them don't even bother to do that, as they prefer making a new thread on elitepvpers to ask for help. At least now there'll be less threads with stupid questions, or so I hope.

That's nubness for you. Supporting Shaiya always, yes? I really, really appreciate you helping people who might have been asking you questions.

[Shànks♠]

Awesome release!!

[Cosmin6294]

Awesome release

[QQers19]

Thank a lot for this release, is very helpful But it is possible somehow change item for another item with that? I mean Item Management-->Inventory/WH legendary Adamas Helmet to Goddess?

[nubness]

Originally Posted by QQers19

Thank a lot for this release, is very helpful But it is possible somehow change item for another item with that? I mean Item Management-->Inventory/WH legendary Adamas Helmet to Goddess?

No, that's not possible.

[[DaE]Asew]

keep up the good work Best admin panel i've seen so far but lol i was testing your admin panel around and your thing scared the **** out of me, item management->item editor, i click apply changes and it opened a message box saying item deleted, but it hasn't (must be fixed or some people will get a heart attack xD)

Originally Posted by QQers19

Thank a lot for this release, is very helpful But it is possible somehow change item for another item with that? I mean Item Management-->Inventory/WH legendary Adamas Helmet to Goddess?

But what you can do in the admin panel is link 6 lapises in the gem boxes and then with that you have a legendary look like a goddess. You can do the same thing on any armor(6max ofc) even o a noble...

Guide:

[accuface35]

how to connect with the database for extern use?

[nubness]

Originally Posted by accuface35

how to connect with the database for extern use?

It's not possible, it can only be used from the same machine as the server.

[Mithrandir.]