Asunto: SK NT Database Extension

Added some languages and databases.

Sokker NT Database Extension V.06

Available databases:

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

Available languages:

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

Take here the complete zip pack including all php pages and database. Just host it and it's done. This version takes the current skin and show database form inside the sokker iframe.

ATTENTION:
Nederland: there's an error when getting variables... they are null... check your code.
Italian: did you request $tid? this information wasn't loaded in the form.. check variables names.
Italian and Français: language sent is the user language... so, if the $lang variable isn't it or fr, you should set $lang=en. If you don't do this, we see page in Italian and French.
(editado)

Something wrong with these codes? I've adjusted a typo, so maybe it's correct now?

if(country==12) url="http://www.deelstar.nl/sokker/content.php?id=7〈=en";

//English
if(theSkill=="tragic") return 0;
if(theSkill=="hopeless") return 1;
if(theSkill=="unsatisfactory") return 2;
if(theSkill=="poor") return 3;
if(theSkill=="weak") return 4;
if(theSkill=="average") return 5;
if(theSkill=="adequate") return 6;
if(theSkill=="good") return 7;
if(theSkill=="solid") return 8;
if(theSkill=="very good") return 9;
if(theSkill=="excellent") return 10;
if(theSkill=="formidable") return 11;
if(theSkill=="outstanding") return 12;
if(theSkill=="incredible") return 13;
if(theSkill=="brilliant") return 14;
if(theSkill=="magical") return 15;
if(theSkill=="unearthly") return 16;
if(theSkill=="divine") return 17;




if(country==12) url="http://www.deelstar.nl/sokker/content.php?id=7〈=nl";

//Nederlands
if(theSkill=="tragisch") return 0;
if(theSkill=="hopeloos") return 1;
if(theSkill=="waardeloos") return 2;
if(theSkill=="slecht") return 3;
if(theSkill=="zwak") return 4;
if(theSkill=="matig") return 5;
if(theSkill=="redelijk") return 6;
if(theSkill=="goed") return 7;
if(theSkill=="solide") return 8;
if(theSkill=="zeer goed") return 9;
if(theSkill=="uitstekend") return 10;
if(theSkill=="formidabel") return 11;
if(theSkill=="uitmuntend") return 12;
if(theSkill=="wonderbaarlijk") return 13;
if(theSkill=="briljant") return 14;
if(theSkill=="magisch") return 15;
if(theSkill=="buitenaards") return 16;
if(theSkill=="goddelijk") return 17;
(editado)

I'm pleased to announce that Cymru (Wales) now have their own database site, NTDB Cymru, all thanks to the huge work of Manda_Chuva and dark that created this feature.

Please download the firefox extension Download Here , with this feature is really easy to send welsh players to our NT, or to other countries too.
(editado)

I think I see what´s the problem... extension don´t send skills as text...

Redirection is good and I send also a variable called lang equal to nl or en, according to the language used by the user.

Your code should request skills and convert numbers to text... for example:

Player
formidable stamina
weak pace

Varibles sent:
sta=11
pac=4

Your request should be:
$sta=$_POST['sta']
$pac=$_POST['pac']

Create the skills translation:
skills=["stamina","pace"]
if lang=nl skills=["bla","bla"]

And convert it:
sta=skills[sta]
pac=skills[pac]

Look in your other topic. Language doesn't matter. Your extension should send the form with English skill names and numbers as skill levels to http://www.deelstar.nl/sokker/content.php?lang=nl&id=7 or http://www.deelstar.nl/sokker/content.php?lang=en&id=7

I´ve just aswered there. The extension send skills numbers... you need to translate it to text before filling the form.

Almost all NT pages works like that. Could you adapt your code.

I'm not controlling the code;)

I will try to modify your script;)

edit: contact me by e-mail/msn. I will send you my e-mail adress.
(editado)

---

I´m a little busy now but I'll contact you after this weekend.

It's not only a problem with Brazilian code. The problem is that we have more or less 10 pages working like that. I think it would be easy to change the Dutch one and not all these 10.

Take a look at the zip pack that I posted in the Download NT Database topic. There you will find all pages I use and also see how I do the variables request and translation.

I can´t send variables as text with the extension because if I do that, I would need to do the same for every language and it´s become quickly a hard work. We have still problems when encodind text data.

Italian: did you request $tid? this information wasn't loaded in the form.. check variables names.

We worked on past version, where $tid was not present :)))
Now I'm working to include it, and I'm working to fix also the default language.

:)

thx

I use the tid field in order to know who updated players using the extension. I consider these information are truster than others.

Mate, we have to improve italian part, there are some word used in twice form that mean the same value:

//Italian
if(theSkill=="tragico") return 0;
if(theSkill=="tragica") return 0;
if(theSkill=="tremendo") return 1;
if(theSkill=="tremenda") return 1;
if(theSkill=="insoddisfacente") return 2;
if(theSkill=="scarso") return 3;
if(theSkill=="scarsa") return 3;
if(theSkill=="debole") return 4;
if(theSkill=="medio") return 5;
if(theSkill=="media") return 5;
if(theSkill=="accettabile") return 6;
if(theSkill=="buono") return 7;
if(theSkill=="buona") return 7;
if(theSkill=="solido") return 8;
if(theSkill=="solida") return 8;
if(theSkill=="ottimo") return 9;
if(theSkill=="ottima") return 9;
if(theSkill=="eccellente") return 10;
if(theSkill=="formidabile") return 11;
if(theSkill=="straordinario") return 12;
if(theSkill=="straordinaria") return 12;
if(theSkill=="incredibile") return 13;
if(theSkill=="splendido") return 14;
if(theSkill=="splendida") return 14;
if(theSkill=="magico") return 15;
if(theSkill=="magica") return 15;
if(theSkill=="sovrumano") return 16;
if(theSkill=="sovrumana") return 16;
if(theSkill=="divino") return 17;
if(theSkill=="divina") return 17;

I note a bug, now I understand the reason :)))

P.S. What does it mean "$train = $_REQUEST['train'];" field...??
(editado)

please add
if(country==39) url="http://24.182.128.62/sksrbija/dbin.cgi"; //Serbia

This site send an error message.