Online editing

**siread** · 11-14-2009 03:18 PM

I've am experimenting with an online database so that everyone that wants to help with updating can do so from their internet browser. The benefits of this are enourmous as it means we are all working with the same data and any changes you make are immediately visible to the other editors.

At the moment this is still at a testing stage so feel free to have a play around but don't do any serious editing as any work you do now WILL BE LOST. For one thing the special characters are messed up so I will be deleting this database soon and creating a fresh one.

For now the editor will only allow you to change certain fields such a players club (for transfers) or a clubs division (for promoting/relegation). You cannot create or delete players or clubs.

I will definitely be making everything private before (if) it goes live so only registered editors will be given access but for now have a play and let me know what you think. If you have any questions just ask.

http://www.newstargames.com/dbedit/nation.php

Clubs and players can be edited with the little edit button on the left-hand side.
You can filter players by club if you know the club id. On the player screen click search then put the club id in the ClubID column and press enter.

**Conway1992** · 11-14-2009 03:49 PM

Good idea Si

**Cookie Monster** · 11-14-2009 04:40 PM

Looks very nice Si, but the first issue (and that you mentioned) that I noticed was the lack of é's and stuff looking at the Arsenal squad

As far as I can see there's no player data changing included now?

**lulospawn** · 11-14-2009 05:44 PM

I like it. Kinda... Slow for serious work, but excellent for bits of it.

**Cookie Monster** · 11-14-2009 06:07 PM

Just a small suggestion, I think it'd be better to do backups of the database to a folder in the server whenever any work is saved so that no people with bad intentions destroy our hard work.

**felipe1337** · 11-14-2009 06:55 PM

Nice idea Si, but some people would try to make invincible teams in minor leagues, i.e., transfer all good players in the league to a single club

**Cookie Monster** · 11-14-2009 07:08 PM

I think the data would be revised in the end. The NSS4 db was revised in the end.

**west_ham_ 4_life** · 11-14-2009 11:07 PM

nice idea si. i'm interested in becoming one of these registered editors.

**felipe1337** · 11-15-2009 12:04 AM

i think we'll need a lot more to cover the whole world

**lulospawn** · 11-15-2009 04:14 AM

I'll do Argentina. No problem. I know how I'll do it with this system.

I'll go team by team, checking player by player.

- If a player missing in my team exists in another team, I'll change the data accordingly.
- If said player doesn't exist in the db, I'll create him (if possible).
- The remaining players (those existing in the team in the current db, that no longer play for the team) will be either transferred to their corresponding team or deleted (if possible) in the case they've retired or sent to a team that hasn't been fully created yet.

First I gather the info of a whole team, then I do the changes.

**Cookie Monster** · 11-15-2009 09:21 AM

transfermarkt.de (something we used when editing the original NSS4 db) is very useful for info

edit: will we be able to change and/or make new competitions? Just noticed the Portuguese League Cup (Taça da Liga) is not included..

**Conway1992** · 11-15-2009 01:43 PM

Originally Posted by Cookie Monster

Just a small suggestion, I think it'd be better to do backups of the database to a folder in the server whenever any work is saved so that no people with bad intentions destroy our hard work.

I agree but I doubt anyone would mess it up but its better to be safe than sorry