PDA

View Full Version : Online editing



siread
11-14-2009, 04: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, 04:49 PM
Good idea Si :)

Cookie Monster
11-14-2009, 05: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 :lol: As far as I can see there's no player data changing included now?

lulospawn
11-14-2009, 06:44 PM
I like it. Kinda... Slow for serious work, but excellent for bits of it.

Cookie Monster
11-14-2009, 07: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, 07: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, 08: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-15-2009, 12:07 AM
nice idea si. i'm interested in becoming one of these registered editors.

felipe1337
11-15-2009, 01:04 AM
i think we'll need a lot more to cover the whole world ;)

lulospawn
11-15-2009, 05: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, 10: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, 02:43 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.

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

Nando
11-15-2009, 04:55 PM
Awesome job, Si! It will certainly help a lot with the future databases and any updates.

siread
11-15-2009, 05:29 PM
Ok, I'm still ironing out a few issues but hopefully I have it up and running this week.

Conway1992
11-15-2009, 07:01 PM
Ok, I'm still ironing out a few issues but hopefully I have it up and running this week.

Good Si :)

lulospawn
11-16-2009, 12:17 PM
Dudes, I was thinking that in order to keep the database balanced all players should have their abilities auto-assigned based on World Status (a value we could be able to edit, anyways).

The distribution of abilities should be based on the position they play in.

That's old news, but here's the kicker:

In order to make players more diverse (and not ending up with a bunch of strangely Drogbas that are faster than stronger), we could be able to pick from a bunch of madlib-like drop down menus that "define" the player.

For instance... Is the player fast, strong, resistant or well rounded? We can tell the Owens apart from the Berbatovs and the Crouches. The Tottis from the Tonis.

Is he offensive, defensive (regardless of position) or "average"? We can separate the Xavis from the Xabi Alonsos from the Makeleles. The Roberto Carlos from the Del Hornos. The Ferdinands from the Vidices.

We could also say if the player has a physical, tactical or skillful approach to the game. Ronaldinho, Gerrard and Lampard are worlds apart for being all the playmakers.

All this choices will affect the distribution of abilities (of an average set by -but not equal to- World Status).

We have a total of 16 abilities, so let's say that each percent of World Status (WS) means 13 ability points. That means that if we give the guy a WS of 100, he'd average 81,25 points per ability.

Now we'll start auto-distributing the points. The first filter is the Primary Position. Then we could start applying these drop downs I suggest, in the following order:

- Approach to the game (Physical, Tactical, Skillful)
- Then his offensive/defensive balance (offensive, defensive, moderated)
- Finally his physical characteristics (Fast, Strong, Resistant, Well-Rounded)



I still have to break this down and I don't have the time right now, but I'll edit this later if the idea seems usable.

Conway1992
11-16-2009, 12:37 PM
This is a great idea lulospawn but I cant see this happening in NSS2010, more on the lines of NSS5 if it is to happen I think.

west_ham_ 4_life
11-19-2009, 07:02 AM
yeah, agree with conway. some good ideas tho

felipe1337
01-29-2010, 12:43 AM
will this be back for any new nss4 update?

west_ham_ 4_life
01-29-2010, 09:11 AM
given that it hasnt been talked about in a couple of months, i highly doubt it in NSS2010... but u never know, it could be incorporated in NSS5

Cookie Monster
01-29-2010, 03:47 PM
I think it's pointless to make it ready now, I think it's better to wait for the end of the transfer window (which this season will not happen on the 31st of January, it will happen on the 1st of February because the first date is a Sunday)

felipe1337
01-30-2010, 12:07 AM
It won't take long, anyway, i doubt of many flash transfers on monday...

Cookie Monster
01-30-2010, 11:25 AM
Portugal's going mad on the market though, I've never seen the Big Three this active. I think you'd know that because Benfica got 3 players from Brazil and Porto got 1. /offtopic

PepesuperSCP47
01-30-2010, 12:24 PM
And Sporting: Sinama-Pongolle, Joćo Pereira e Pedro Mendes!!!!!!!!!!!!!!!!!!!!!!!!!!!
They're really spending alot of money!!!!!!!!!!!!/offtopic

Octy
04-08-2010, 09:56 AM
No posts since the 30th of January, transfers deadline close the 31th? I wonder what happened?

Anyway, I'm new here and already addicted to the New Star Games, especially NSS10. I brought all the mac games that where available, pure fun!

If anyone needs help, I can help out with the Belgian leagues. I'm also a game developer. I've made www.acemasters.org, an online game. I program in PHP, so I could even help out with this online database. It's a great idea to have a selected group help out with the data.

The only thing I would like to see improved in the game, is the database. A lot of inaccurate players and managers data (my favorite team, Anderlecht has a new manager since two years but in-game it's still the old one, who's now manager at Genk). I understand there are licensing issues but why not have some kind of 'unfake' patch available to download on a 3rd party site (just like FM does)?

felipe1337
04-08-2010, 03:51 PM
Somewhere in the forum you'll find it, check nss2010 sub forums

west_ham_ 4_life
04-09-2010, 06:24 AM
have a search around here (http://www.nssworld.smfnew.com/). the site has been spammed, so watch out for that, but all the graphics and database downloads are safe.