[ASECO 2.x] Public Database

This forum is dedicated to the Aseco/Rasp 2 server records and control script by Flo and Assembler Maniac. Announcements and issues can be discussed in this forum.

Moderators: Flo, f*ckfish, Assembler Maniac, TM-Patrol

Post Reply
User avatar
w1lla
TM-Patrol
TM-Patrol
Posts: 1466
Joined: 23 May 2007 07:20
Owned TM-games: TMU, TMN, TMF
Manialink(s): intr
Location: Venray

[ASECO 2.x] Public Database

Post by w1lla » 31 May 2010 17:22

A few weeks ago i made the decision of making the public database alive again.

As Dedimania gets more and more servers connected to it, i thought of making this database a relief of the almost 30 servers that try to connect to dedimania through aseco.

So hereby comes: Public Database 2.0 with help from AM & Flo.

After getting the files from AM & Flo i started out redoing the plugin. On the way there were some troubles.
Troubles like:
my host doesn't like granting for sql.
SQL errors for logins & nicknames.
SQL errors for procedures.

At the moment these are fixed.

The public database of Aseco is back online.

The database is hosted on my own pc. Which means its not always online. Its online round 15.00 +1 GMT till 21.00 +1 GMT.

Notice 1:
I'm looking for a host that has full mysql support. Which means it doesnt user (user_username) but only user as database login. Also Grant and Revoke acces and full access like for example: USBwebserver.

Notice 2:
Make an account on : http://www.pubdb.w1lla.nl

Notice 3:
Add your details to the config called:
pubdb.xml

Add the following in the config:

Code: Select all

<?xml version="1.0" encoding="utf-8" ?>
<settings>
  <!-- Public Database Server Settings -->
  <!-- Create your account at www.pubdb.w1lla.nl -->
  <server_host>84.30.238.76:5228</server_host>
  <server_login>[b]Login you want tot use for a Server[/b]</server_login>
  <server_password>[b]Password you entered[/b]</server_password>
  <!-- Do you want Aseco to display the records? -->
  <display>True</display>
</settings>
Just leave the server_host as it uses a .txt file from the public database.


For more info or requests post or pm me:

For information about databases please contact me also by pm.

Downloadlink:
http://www.pubdb.w1lla.nl/pubdb.zip
http://www.pubdb.w1lla.nl/pubdb.rar

Code: Select all

tmnforever is nations and united makes it special. tmnforever has united. I need united!

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: [ASECO 2.x] Public Database

Post by nocturne » 01 Jun 2010 12:47

Is this a replacement for the local database plugin, as per the original, or a leaderboard like DM..?
Chief Janitorial Supervisor of the Let'sRock! TM community : www.LetsRock-TM.com

Assembler Maniac
Pit Crew
Pit Crew
Posts: 1493
Joined: 03 Jun 2006 13:24
Owned TM-games: TMU
Contact:

Re: [ASECO 2.x] Public Database

Post by Assembler Maniac » 01 Jun 2010 13:03

nocturne wrote:Is this a replacement for the local database plugin, as per the original, or a leaderboard like DM..?
I have still never figured out why people think the public database is a replacement for the original. It's purpose is to be for race record keeping only, it can never "replace" the local database (unless you want to lose all of the features related to the local db).

The PubDB that Willa is setting up should be functionally the same as the one that Flo and I were hosting. It's just being hosted in a different place, and Willa has had to make some minor code changes to the plugin to make it work right.

User avatar
w1lla
TM-Patrol
TM-Patrol
Posts: 1466
Joined: 23 May 2007 07:20
Owned TM-games: TMU, TMN, TMF
Manialink(s): intr
Location: Venray

Re: [ASECO 2.x] Public Database

Post by w1lla » 01 Jun 2010 13:42

as Assembler Maniac says its a leaderboard replacement for Dedimania.

Dedimania is getting alot of servers connected to it and only +- 30 servers are Aseco.

If Aseco has it own public database as a replacement dedimania can be used for "world records" but also the public database can be used for it.

Its just a way of seeing what is really the world leading leaderboard like world records.

In the future the site will show records by players.

Code: Select all

tmnforever is nations and united makes it special. tmnforever has united. I need united!

nocturne
solid chaser
solid chaser
Posts: 1390
Joined: 08 Jun 2007 18:48
Owned TM-games: all
Contact:

Re: [ASECO 2.x] Public Database

Post by nocturne » 01 Jun 2010 18:09

Sorry, my only reference to the old public_db was the old Aseco v.6 documentation.. Never used it, really.

So, what makes the public db so special? Is there any reason to use it over DM? Are checkpoints counted and validated?
Chief Janitorial Supervisor of the Let'sRock! TM community : www.LetsRock-TM.com

User avatar
w1lla
TM-Patrol
TM-Patrol
Posts: 1466
Joined: 23 May 2007 07:20
Owned TM-games: TMU, TMN, TMF
Manialink(s): intr
Location: Venray

Re: [ASECO 2.x] Public Database

Post by w1lla » 02 Jun 2010 08:08

its features are more or less the same as dedimania.

Only thing that might be different is that cheats can be deleted automaticaly by an admin of the database.

Code: Select all

tmnforever is nations and united makes it special. tmnforever has united. I need united!

Xymph
Pit Crew
Pit Crew
Posts: 5654
Joined: 19 Aug 2007 12:58
Owned TM-games: TMN, TMU, TMF, TM²
Contact:

Re: [ASECO 2.x] Public Database

Post by Xymph » 02 Jun 2010 17:00

w1lla wrote:Only thing that might be different is that cheats can be deleted automaticaly by an admin of the database.
"automatic" and "by an admin" is a contradiction. :P
Anyway, deletion is what I do for Dedimania too, so no difference there.
Developer of XASECO for TMF/TMN ESWC & XASECO2 for TM²: see XAseco.org
Find your way around the Mania community from the TMN ESWC hub, TMF hub, TM² hub, and SM hub

User avatar
w1lla
TM-Patrol
TM-Patrol
Posts: 1466
Joined: 23 May 2007 07:20
Owned TM-games: TMU, TMN, TMF
Manialink(s): intr
Location: Venray

Re: [ASECO 2.x] Public Database

Post by w1lla » 02 Jun 2010 17:11

well as the old database states @ http://www.flo-schnell.de/aseco/website/about.php

thats what the original database of aseco was.

Code: Select all

tmnforever is nations and united makes it special. tmnforever has united. I need united!

Post Reply