Onderwerp: SK NT Database Extension

This site send an error message.

can you add form and tactical discipline?
Serbian NT, supports these two values, also!!!

@everybody else complaining:
This is the most usable code for nt db's. provides some security and easy of use.
plus it WORKS, if it doesn't it's your db that has a problem :):)

Hello everybody,

I'm traveling these days. It´s because I have no answered post above. Sorry for that.

Tomorrow night I'll be at home and answer all requests. Danny and luut, I'll add you tomorrow too in order to discuss in MSN.

Sorry.

:)

Train is a number between 0 (nothing), 1 (stamina)...8 (striker).

Serbian and Wales, I'll add databases in the next version.

Italian: I'll correct gender skills too.

Thx to you all.

Please don't contact me during the week, otherwise I won't spend my important time on school:P

Updating... (also changing the first post)

Sokker NT Database Extension allows you to automatically fill NT Database forms in order to keep your players updated in a more friendly way. No more need look for databases adress in the NT Page or ask people.

This extension add a flag on your player page. Clicking on it, your player information is sent to the player subscription/update page. The others steps keep the same.

Download Here
Printscreen Here


Available databases:

Magyarország, Brasil, Hrvatska, Türkçe, Bosna i Hercegovina, Peru, Nederland, Italia, France, Albania, Portugal, Cymru and Serbia

Available languages:

Português, English, Español, Türkçe, Dutch, Romanian, Српски, Hungarian, Croatian, Bosanski, Italian (corrections), Français and German


I've also develloped a couple of pages in PHP + MySQL for NT coachs.

Just unzip [color=#FF6600 size=1 face=arial]THIS[/color] zip file, import [color=#FF6600 size=1 face=arial]THIS[/color] txt file using MyAdmin, configure your host database connexion in the "conectarBD.php" file and translate the local language in files: index.php, indexsk.php, send.php and sendsk.php.

After that, send me your database adress. I'll add it in [color=#FF6600 size=1 face=arial]THIS[/color] extension in order to allow people to send players in an easier way directly from the online player page.

NB: remember to change users in staff table. There are 3 levels of permissions: admin, coach and scout.
NB2: it would be nice if you keep credits where credits are due.



Complete Database Webpages and Extension Support
All these pages are 100% compatible with extension and have similar appearance, including actual sokker css. Take a look at the Portugal one, nice visual.

http://sokker.jateklap.hu/sk-db/index.php //Magyarország
http://sokker.ciumegul.com/index.php //România
http://himem.phpnet.us/ntpt/index.php //Portugal
http://www.sokker.domiciano.eng.br/ntdb/index.php //Brasil
http://ntdbcymru.awardspace.com/indexsk.php //Cymru
http://black_eagle.php0h.com/index.php //Shqipëria

Complete Extension Support
All these pages are 100% compatible with extension but not similar appearance or engine. Take a look at the Hrvatska one, players are directly sent without confirmation.

http://sokker.ilbello.com/index.php //Italia
http://gamsoft.org/main.php?page=requirements&ln=en"; //Hrvatska
http://htmasters.pandela.org/sokkerperu/datask.php"; //Peru
http://24.182.128.62/sksrbija/dbin.cgi //Serbia
http://gamsoft.org/sokker/requirebh.php"; //Bosna i Hercegovina

Database Redirection or Incomplete Extension Support
All these pages can be opened from the player page but have not similar appearance or engine. Turkye offer no extension support, Nederland need some corrections and Italian and French need language adjustments.

http://www.deelstar.nl/sokker/content.php?id=7 //Nederland
http://france.ilbello.com //France
http://www.sokkerturkiye.org/web/oyuncu_bil.php //Türkçe

Our database "manager"has/had some problems with his provider so we need to wait a bit longer.

Why $_REQUEST['train'] is not set for each request ???

And the other two value:
$_REQUEST['x'] and $_REQUEST['y'] what does it mean ??
(gewijzigd)

where is th guide to install this?
(gewijzigd)

if(country==71) url="http://www.onyar.net/sokkerandorra/";

//Portuguese
if(theSkill=="Tràgica") return 0;
if(theSkill=="Terrible") return 1;
if(theSkill=="Deficient") return 2;
if(theSkill=="Pobre") return 3;
if(theSkill=="Dèbil") return 4;
if(theSkill=="Regular") return 5;
if(theSkill=="Acceptable") return 6;
if(theSkill=="Bo") return 7;
if(theSkill=="Sòlid") return 8;
if(theSkill=="Molt bo") return 9;
if(theSkill=="Excel·lent") return 10;
if(theSkill=="Formidable") return 11;
if(theSkill=="Destacat") return 12;
if(theSkill=="Increïble") return 13;
if(theSkill=="Brillant") return 14;
if(theSkill=="Màgic") return 15;
if(theSkill=="Extraterrestre") return 16;
if(theSkill=="Diví") return 17;


It's translated to Catalan and with Andorra DB, how can I use it? Is it well done?

Hi we are going to add open database to our nt system and use your extension for it.

there could be problem because in polish we decline skill's levels

e.g.
dobra pace
dobry scrorer
etc

Do You have some solution for that ?

in spanish too

Muy buena rapidez
Muy bueno pases

How is to do that?

You have to do a new extension? or what? please explain me or give me a guide

I don't know exactly how does this extension work, I've only translated the habilities to Catalan and put the Andorra information :S

I think it's possible to remove the last letter in this case. 'bueno' is the same level as 'buena', so if the program knows that it only should pay attention to 'buen', then it shouldn't be a problem.

@The_Hunter: just ask me if you have a problem when he's came back.

@Dragster: 'train' is just the variable name... I'm taking it using _POST to all variables even if _REQUEST also works fine but you have less security like that. Take it as you've taken the other variables value.

@ViLLa7: no need a guide, you only need to put files in a PHP host. Ask me in MSN or to an other guy that know how to do that. The harder to do is to configure the database connexion. Someone with some knowledge in it can do all the work in less then 10 minutes.

@Fox-ska: Andorra database and Catalan added. But the form won't be automatically filled because you require login. You can keep this procedure including hidden fields in the main page with the variables value parsed inside the login form. When the user click Login, all values are sent to the next page and you only need to take values again. Level 10 is "Excel·lent"? Or "Excellent"? I've added the first one as you posted above. Do you decline other skills like tragica and tragico?
To use it, just require all variables doing: var x=$_POST['x'] where x is the variable name... look some posts above to see all variable names.

@rym3k: no problem with skills decline... you only need to add twice the value:
if(theSkill=="Tràgica") return 0;
if(theSkill=="Tràgico") return 0;

@ViLLa7: no problem with Spanish. I've already did that for Spanish. Italian is also ok.

@titocristo: we have only 1 extension... I can add any language or database to that. For now it supports 14 languages and 15 databases. Just ask me and I'll add more languages and databases.

@Fox-ska: just install it and try it with a player from Magyar, Italia, France, Romania, Portugal, Brasil, Hrvatska, Peru, Serbia, Cymru, Bosna i Hercegovina or Shqipëria. In bold are pages with complete extension support. No problem if your player don't fit requirements, the database automatically inform it.

@luuut: I used the following method to get skills values in order to take any value of any language.
if(theSkill=="BlaBlaBla") return BlaBlaBlaValue;
I call it WOP (Workaround oriented programming)... I hope two languages won't have the same skill name for different skill values. [;P]

no problem with skills decline... you only need to add twice the value:
if(theSkill=="Tràgica") return 0;
if(theSkill=="Tràgico") return 0;

this solution is too simple -_-'