[Fast3] Plugin.Localdatabasefile (2008-06-08)

[pa6fou]

many thanks mcm

but as been said just before, I encounter the same issue, the customisation is not loaded after Fast restart

edit: solved since I uptated with your most recent version.

onece again many thanks

[Viok Tof]

Ok, I found the bug in fr file
The script can't read "é" and "è" " à" etc.. !!!
If there are these caracteres in "locale.localdbf.fr.xml.txt", the script stop read the file
it's boring

pending, I make a file whithout these caracteres for frenchy

Code: Select all

<?xml version="1.0" encoding="UTF-8" ?>

<!-- Do not customize this file ! instead make a 'locale.localdbf.xx.xml.txt' file, -->
<!-- where xx stands for the language cz,de,en,es,fr,hu,it,jp,kr,nl,pl,pt,ru,sk,zh -->
<!-- also posible srb = serbian or srbl = serbian latin but users will have to set it manualy with /lang srb -->
<!-- or just make a locale.localdbf.custom.xml.txt for default language and express yourself -->
<!-- so updates will not modify your changes !  ;)  -->

<fast>
	<locale>
		<fr>
			<!-- The menu -->
			<localdbf.menumain>Plugins ...</localdbf.menumain>
			<localdbf.menurecords>Records locaux ...</localdbf.menurecords>
			<localdbf.menumaintain>Reglages ...</localdbf.menumaintain>
			<localdbf.menushowrecson>Voir les recs (marche)</localdbf.menushowrecson>
			<localdbf.menushowrecsoff>Voir les recs (arret)</localdbf.menushowrecsoff>
			<localdbf.menujoinmsgon>Messages de connection (marche)</localdbf.menujoinmsgon>
			<localdbf.menujoinmsgoff>Messages de connection (arret)</localdbf.menujoinmsgoff>
			<localdbf.menushowinfoall>Voir tous les recs dans le chat</localdbf.menushowinfoall>
			<localdbf.menushowinfopb>Voir uniquement les recs PB ans le chat</localdbf.menushowinfopb>
			<localdbf.menumaxtop>Maxtop : </localdbf.menumaxtop>
			<localdbf.menudefshowrecs>Voir les Records : </localdbf.menudefshowrecs>
			<localdbf.menusaveconfig>Sauver la conf !</localdbf.menusaveconfig>
			<localdbf.menulanguage>Language...</localdbf.menulanguage>
			
			<!-- The labels -->
			<localdbf.mainlabel>Records locaux</localdbf.mainlabel>
			<localdbf.mainlabel.ladder>$fffClassement serveur</localdbf.mainlabel.ladder>
			<localdbf.mainlabel.trackrecs>$fffRecords circuits</localdbf.mainlabel.trackrecs>
			<localdbf.label_rank>Rang : </localdbf.label_rank>
			<localdbf.label_norank>Pas classe !</localdbf.label_norank>
			<localdbf.label_norecord>Aucun record</localdbf.label_norecord>
			<localdbf.label_norecordforyou>Vous n'avez pas encore de record !</localdbf.label_norecordforyou>
			<localdbf.label_score>Score : </localdbf.label_score>
			<localdbf.label_pb>PB </localdbf.label_pb>
			<localdbf.label_top>Haut </localdbf.label_top>
			<localdbf.list_rank>$fff Rang</localdbf.list_rank>
			<localdbf.list_nick>$fff Nick</localdbf.list_nick>
			<localdbf.list_wins>$fff Gagnant</localdbf.list_wins>
			<localdbf.list_score>$fff Score</localdbf.list_score>
			<localdbf.list_gap>$fff Gap</localdbf.list_gap>
			<localdbf.list_position>$fff Position</localdbf.list_position>
			<localdbf.list_finished>$fff Finish</localdbf.list_finished>
			<localdbf.list_time>$fff Temps</localdbf.list_time>
			<localdbf.confirm>$fff Sauver la config actuelle ??</localdbf.confirm>
			<localdbf.confirm.yes>$f00 OK</localdbf.confirm.yes>
			<localdbf.confirm.no>$000 Annuler</localdbf.confirm.no>
			
			<!-- Some colors -->
			<localdbf.record>$z$s$i$9f6</localdbf.record>
			<localdbf.highlight>$z$s$i$fff</localdbf.highlight>
			<localdbf.interact>$z$s$i$dcf</localdbf.interact>
			
			<!-- Chat outputs -->
			<localdbf.record.top_prefix>$z$i$s$ccc$nLocal $cc0> $fff$z</localdbf.record.top_prefix>
			<localdbf.record.top.foryou>$i $z$i$s$ddd$n a fait le $fff$mTOP $ee0%d$ddd$n : $fff$m%s</localdbf.record.top.foryou>
			<!-- args: player_rank:int,	player_time:string -->
			<localdbf.record.top.forall>%s$z$i$s$ddd$n a fait le $fff$mTOP $ee0%d$ddd$n : $fff$m%s</localdbf.record.top.forall>
			<!-- args: player_name:sting, player_rank:int,	player_time:string -->
			<localdbf.winner>$z$i$3ffFelicitations ! Tu gagne le $z$i$f3c%d.$z$i$3ff Time !</localdbf.winner>
			<!-- args: wins:int -->
			<localdbf.joinmsg_norank>$z$s$i$dcfBienvenue : %s $z$s$i$ff0Pas encore classe...$z</localdbf.joinmsg_norank>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked>$z$s$i$dcfBienvenue : %s \n$z$s$i$dcf Rang serveur : $z$s$i$ff0%d / %d$z$s$i$dcf Score : $z$s$i$ff0%d $z$s$i$dcf victoires : %d$z</localdbf.joinmsg_ranked>
			<!-- args: player_name:string, player_rank:int, all_ranks:int player_score:int, player_wins:int -->
			<localdbf.joinmsg_norank.leave>$z$s$i$dcfAu revoir : %s $z$s$i$ff0Toujours aucun classement...$z</localdbf.joinmsg_norank.leave>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked.leave>$z$s$i$dcfAu revoir : %s \n$z$s$i$dcf Rang serveur : $z$s$i$ff0%d %s(%d) $z$s$i$dcf Score : $z$s$i$ff0%d %s(%d) $z$s$i$dcf victoires : %d %s(%d)$z</localdbf.joinmsg_ranked.leave>
			<!-- args: nick:string, rank:int, rank_change_color:string, rank_change:int, score:int, score_change_color:string, score_change:int, wins:int, wins_change_color:string, wins_change:int -->
		</fr>
	</locale>
</fast>

<!-- note: the strings will use args like in a sprintf() call, -->
<!--       and you so can specify the used arg. For example -->
<!--       %3$s will be replace by the 3rd arg, supposed to be a string -->

for french :
copiez le code ci-dessus dans un fichier texte, appelez le "locale.localdbf.fr.xml.txt" et mettez le dans le dossier plugin; redemarrez fast
(manque encore quelques mots a traduire mais j'attend la version debuggé des accents pour finir)

[Generator]

Hi mcm... Just wondering if you have any plans of doing a sql version of this great plugin.

Thanx alot. keep up the good work.

[AstroGlider]

Hi mcm,

After trying your plugin I have to say it's a great addition, and it looks very nice. You've done some good work here. The only thing I would change is when you open the "Server Ranking", to close the "Track Records" (and vice versa). I know it's minor, but people are lazy and it's more convenient than having to click again to close one before opening the other
By the way, very nice confirmation box when saving the settings

Since you integrated the menu so nicely, you might like to know for the next version of GPP I've moved all the log/cfg files to a subdir in the data directory so that it's easier to start with a clean slate.

Keep on keeping on ^^

Glider

[mcm]

@glider : nice one glider and thx for the tips, will change that p.s. yes the confirmation box was very quick and easy to implement due to an excellent template so i just had to use the C&P method

@viok tof : can you pas me or post the french text with those frenchy characters, so i can fix it to work...thx.

@generator : well its in the roadmap to do so, the syntax of the database operations are quite compatible so when all is finished to the f (file) version, it's not much work to make a s (sql) version

@GLUK : where can i download the russian translation ?

[simplysimple]

Je me suis permis de modifié ton texte viok. J'ai corrigé des erreurs ici et là et tout fonctionne (même les accents)

MCM, this is the french file, I think everything is good.

Code: Select all

<?xml version="1.0" encoding="UTF-8" ?>

<!-- Do not customize this file ! instead make a 'locale.localdbf.xx.xml.txt' file, -->
<!-- where xx stands for the language cz,de,en,es,fr,hu,it,jp,kr,nl,pl,pt,ru,sk,zh -->
<!-- also posible srb = serbian or srbl = serbian latin but users will have to set it manualy with /lang srb -->
<!-- or just make a locale.localdbf.custom.xml.txt for default language and express yourself -->
<!-- so updates will not modify your changes !  ;)  -->

<fast>
	<locale>
		<fr>
			<!-- The menu -->
			<localdbf.menumain>Modifications</localdbf.menumain>
			<localdbf.menurecords>Records Locaux ...</localdbf.menurecords>
			<localdbf.menumaintain>Réglages ...</localdbf.menumaintain>
			<localdbf.menushowrecson>Activé: Records locaux</localdbf.menushowrecson>
			<localdbf.menushowrecsoff>Désactivé: Records locaux</localdbf.menushowrecsoff>
			<localdbf.menujoinmsgon>Activé: Messages de connexion</localdbf.menujoinmsgon>
			<localdbf.menujoinmsgoff>Désactivé: Messages de connexion</localdbf.menujoinmsgoff>
			<localdbf.menushowinfoall>Messagerie: Tout les records</localdbf.menushowinfoall>
			<localdbf.menushowinfopb>Messagerie: Seulement vos records</localdbf.menushowinfopb>
			<localdbf.menumaxtop># Records enregistrés: </localdbf.menumaxtop>
			<localdbf.menudefshowrecs># Records visibles: </localdbf.menudefshowrecs>
			<localdbf.menusaveconfig>Enregistrer!</localdbf.menusaveconfig>
			<localdbf.menulanguage>Langage ...</localdbf.menulanguage>
			
			<!-- The labels -->
			<localdbf.mainlabel>Records Locaux</localdbf.mainlabel>
			<localdbf.mainlabel.ladder>$fffRang du serveur</localdbf.mainlabel.ladder>
			<localdbf.mainlabel.trackrecs>$fffRecords de la piste</localdbf.mainlabel.trackrecs>
			<localdbf.label_rank>Rang: </localdbf.label_rank>
			<localdbf.label_norank>Aucun rang</localdbf.label_norank>
			<localdbf.label_norecord>Aucun record</localdbf.label_norecord>
			<localdbf.label_norecordforyou>Vous n'avez aucun record!</localdbf.label_norecordforyou>
			<localdbf.label_score>Score: </localdbf.label_score>
			<localdbf.label_pb>PB </localdbf.label_pb>
			<localdbf.label_top># </localdbf.label_top>
			<localdbf.list_rank>$fff Rang</localdbf.list_rank>
			<localdbf.list_nick>$fff Pseudo</localdbf.list_nick>
			<localdbf.list_wins>$fff Victoires</localdbf.list_wins>
			<localdbf.list_score>$fff Score</localdbf.list_score>
			<localdbf.list_gap>$fff Différence</localdbf.list_gap>
			<localdbf.list_position>$fff Position</localdbf.list_position>
			<localdbf.list_finished>$fff A fini</localdbf.list_finished>
			<localdbf.list_time>$fff Temps</localdbf.list_time>
			<localdbf.confirm>$fff Enregistrer cette configuration?</localdbf.confirm>
			<localdbf.confirm.yes>$f00 Ok</localdbf.confirm.yes>
			<localdbf.confirm.no>$000 Annuler</localdbf.confirm.no>
			
			<!-- Some colors -->
			<localdbf.record>$z$s$i$9f6</localdbf.record>
			<localdbf.highlight>$z$s$i$fff</localdbf.highlight>
			<localdbf.interact>$z$s$i$dcf</localdbf.interact>
			
			<!-- Chat outputs -->
			<localdbf.record.top_prefix>$z$i$s$ccc$nLocal $cc0> $fff$z</localdbf.record.top_prefix>
			<localdbf.record.top.foryou>$i Vous$z$i$s$ddd$n avez conduit le temps $fff$m# $ee0%d$ddd$n: $fff$m%s</localdbf.record.top.foryou>
			<!-- args: player_rank:int,	player_time:string -->
			<localdbf.record.top.forall>%s$z$i$s$ddd$n a conduit le temps $fff$m# $ee0%d$ddd$n: $fff$m%s</localdbf.record.top.forall>
			<!-- args: player_name:sting, player_rank:int,	player_time:string -->
			<localdbf.winner>$z$i$3ffVous avez maintenant $z$i$f3c%d$z$i$3ff victoires!</localdbf.winner>
			<!-- args: wins:int -->
			<localdbf.joinmsg_norank>$z$s$i$dcfBienvenue: %s $z$s$i$ff0Aucun rang.$z</localdbf.joinmsg_norank>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked>$z$s$i$dcfBienvenue: %s \n$z$s$i$dcf Rang: $z$s$i$ff0%d / %d$z$s$i$dcf Score: $z$s$i$ff0%d $z$s$i$dcf Victoires: %d$z</localdbf.joinmsg_ranked>
			<!-- args: player_name:string, player_rank:int, all_ranks:int player_score:int, player_wins:int -->
			<localdbf.joinmsg_norank.leave>$z$s$i$dcfAurevoir: %s $z$s$i$ff0Aucun rang.$z</localdbf.joinmsg_norank.leave>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked.leave>$z$s$i$dcfAurevoir: %s \n$z$s$i$dcf Rang: $z$s$i$ff0%d %s(%d) $z$s$i$dcf Score: $z$s$i$ff0%d %s(%d) $z$s$i$dcf Victoires: %d %s(%d)$z</localdbf.joinmsg_ranked.leave>
			<!-- args: nick:string, rank:int, rank_change_color:string, rank_change:int, score:int, score_change_color:string, score_change:int, wins:int, wins_change_color:string, wins_change:int -->
		</fr>
	</locale>
</fast>

<!-- note: the strings will use args like in a sprintf() call, -->
<!--       and you so can specify the used arg. For example -->
<!--       %3$s will be replace by the 3rd arg, supposed to be a string -->

Edited and fixed some language mistakes <June 5th 2008>

[firecom]

It would be great that admin could globaly set if all recs are shown in chat or not for all players. Even better would be if you could show only top 100 records for all, the rest just to the player as PB.

[w1lla]

Code: Select all

<?xml version="1.0" encoding="UTF-8" ?>

<!-- Do not customize this file ! instead make a 'locale.localdbf.xx.xml.txt' file, -->
<!-- where xx stands for the language cz,de,en,es,fr,hu,it,jp,kr,nl,pl,pt,ru,sk,zh -->
<!-- also posible srb = serbian or srbl = serbian latin but users will have to set it manualy with /lang srb -->
<!-- or just make a locale.localdbf.custom.xml.txt for default language and express yourself -->
<!-- so updates will not modify your changes !  ;)  -->

<fast>
	<locale>
		<nl>
			<!-- The menu -->
			<localdbf.menumain>Plugins ...</localdbf.menumain>
			<localdbf.menurecords>Lokale Records ...</localdbf.menurecords>
			<localdbf.menumaintain>Onderhoud ...</localdbf.menumaintain>
			<localdbf.menushowrecson>Showrecs is aan</localdbf.menushowrecson>
			<localdbf.menushowrecsoff>Showrecs is uit</localdbf.menushowrecsoff>
			<localdbf.menujoinmsgon>Joinbericht is aan</localdbf.menujoinmsgon>
			<localdbf.menujoinmsgoff>Joinbericht is uit</localdbf.menujoinmsgoff>
			<localdbf.menushowinfoall>Toon alle recs in chat is aan</localdbf.menushowinfoall>
			<localdbf.menushowinfopb>Toon alle PB in chat is aan</localdbf.menushowinfopb>
			<localdbf.menumaxtop>Maxtop : </localdbf.menumaxtop>
			<localdbf.menudefshowrecs>Def.Records laten zien : </localdbf.menudefshowrecs>
			<localdbf.menusaveconfig>Sla Settings op !</localdbf.menusaveconfig>
			<localdbf.menulanguage>Language...</localdbf.menulanguage>
			
			<!-- The labels -->
			<localdbf.mainlabel>Lokale Records</localdbf.mainlabel>
			<localdbf.mainlabel.ladder>$fffServer Ranking</localdbf.mainlabel.ladder>
			<localdbf.mainlabel.trackrecs>$fffBaan Records</localdbf.mainlabel.trackrecs>
			<localdbf.label_rank>Rank : </localdbf.label_rank>
			<localdbf.label_norank>Geen Rank !</localdbf.label_norank>
			<localdbf.label_norecord>Geen Records</localdbf.label_norecord>
			<localdbf.label_norecordforyou>Je hebt geen Records !</localdbf.label_norecordforyou>
			<localdbf.label_score>Punten : </localdbf.label_score>
			<localdbf.label_pb>PB </localdbf.label_pb>
			<localdbf.label_top>Top </localdbf.label_top>
			<localdbf.list_rank>$fff Rank</localdbf.list_rank>
			<localdbf.list_nick>$fff Nick</localdbf.list_nick>
			<localdbf.list_wins>$fff Wins</localdbf.list_wins>
			<localdbf.list_score>$fff Punten</localdbf.list_score>
			<localdbf.list_gap>$fff Verschil</localdbf.list_gap>
			<localdbf.list_position>$fff Positie</localdbf.list_position>
			<localdbf.list_finished>$fff Gefinished</localdbf.list_finished>
			<localdbf.list_time>$fff Tijd</localdbf.list_time>
			<localdbf.confirm>$fff Sla huidige instellingen op ??</localdbf.confirm>
			<localdbf.confirm.yes>$f00 OK</localdbf.confirm.yes>
			<localdbf.confirm.no>$000 Annuleer</localdbf.confirm.no>
			
			<!-- Some colors -->
			<localdbf.record>$z$s$i$9f6</localdbf.record>
			<localdbf.highlight>$z$s$i$fff</localdbf.highlight>
			<localdbf.interact>$z$s$i$dcf</localdbf.interact>
			
			<!-- Chat outputs -->
			<localdbf.record.top_prefix>$z$i$s$ccc$nLokaal $cc0> $fff$z</localdbf.record.top_prefix>
			<localdbf.record.top.foryou>$i Je$z$i$s$ddd$n reed $fff$mTOP $ee0%d$ddd$n record : $fff$m%s</localdbf.record.top.foryou>
			<!-- args: player_rank:int,	player_time:string -->
			<localdbf.record.top.forall>%s$z$i$s$ddd$n reed $fff$mTOP $ee0%d$ddd$n record : $fff$m%s</localdbf.record.top.forall>
			<!-- args: player_name:sting, player_rank:int,	player_time:string -->
			<localdbf.winner>$z$i$3ffGood Game ! Je won de $z$i$f3c%d.$z$i$3ff Tijd !</localdbf.winner>
			<!-- args: wins:int -->
			<localdbf.joinmsg_norank>$z$s$i$dcfWelkom : %s $z$s$i$ff0Geen Rank...$z</localdbf.joinmsg_norank>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked>$z$s$i$dcfWelkom : %s \n$z$s$i$dcf SrvRank : $z$s$i$ff0%d / %d$z$s$i$dcf Score : $z$s$i$ff0%d $z$s$i$dcf Wins : %d$z</localdbf.joinmsg_ranked>
			<!-- args: player_name:string, player_rank:int, all_ranks:int player_score:int, player_wins:int -->
			<localdbf.joinmsg_norank.leave>$z$s$i$dcfGoodbye : %s $z$s$i$ff0Nog Steeds geen Rank...$z</localdbf.joinmsg_norank.leave>
			<!-- args: player_name:string -->
			<localdbf.joinmsg_ranked.leave>$z$s$i$dcfGoodbye : %s \n$z$s$i$dcf SrvRank : $z$s$i$ff0%d %s(%d) $z$s$i$dcf Score : $z$s$i$ff0%d %s(%d) $z$s$i$dcf Wins : %d %s(%d)$z</localdbf.joinmsg_ranked.leave>
			<!-- args: nick:string, rank:int, rank_change_color:string, rank_change:int, score:int, score_change_color:string, score_change:int, wins:int, wins_change_color:string, wins_change:int -->
		</nl>
	</locale>
</fast>

<!-- note: the strings will use args like in a sprintf() call, -->
<!--       and you so can specify the used arg. For example -->
<!--       %3$s will be replace by the 3rd arg, supposed to be a string -->

this is the dutch translation atm chaged it so it works multiple times tested so have fun

[mcm]

thx simply and w1lla 4 the translations, will include them in next update
@firecom : i will add some forcing options too.

[simplysimple]

@mcm : Copy my code into a notepad editor and save it as UTF-8, not ANSI. Otherwise, the é and è won't appear correctly. :p

[AstroGlider]

hey mcm,

I was deleting some maps from my server and it made me wonder: are the records purged from the database when the associated map is removed from the playlist? Maybe the info could be retained in case the map is later added back in the playlist, but just not included in the calculation of local scores/ranks? And speaking of ranks, how exactly is this calculated? I read your previous answer to this question (1st place=100pts,...100th place=1pt) but this doesn't make sense since I currently have 372 points on my server

And by the way, no need to strip characters from nicks, just add htmlspecialchars() to the nickname in the xml string.. it really does wonders to avoid crashing manialinks ^^

[mcm]

hey mcm,

I was deleting some maps from my server and it made me wonder: are the records purged from the database when the associated map is removed from the playlist? Maybe the info could be retained in case the map is later added back in the playlist, but just not included in the calculation of local scores/ranks? And speaking of ranks, how exactly is this calculated? I read your previous answer to this question (1st place=100pts,...100th place=1pt) but this doesn't make sense since I currently have 372 points on my server

And by the way, no need to strip characters from nicks, just add htmlspecialchars() to the nickname in the xml string.. it really does wonders to avoid crashing manialinks ^^

thx for the tip...
if you delete a map, the records are still there, and the track is still part of the calculation....but it gets recalculated only at end of the race so until the map is not played the points for this track are kinda feezed... now you could boost your points by deleting the recordfile for a track, on next play you would get fresh points for the track with the deleted record

and here is your sense if there are only 10 records on a track the 1. will get only 10 points
and if there are 38 records the 1. will get 38 points and so on... i can't remember anymore if there is a minimum record ammount for a track to start counting (like no scores before there are 5 records on the track) or did i just planed to do so btw. with the latest update u can check your score and rank diffs
i think after a few updates we should be able to choose between at least overall ranking and ranking by current tracklist

so cheers there

[utal]

heys!

with more than 4000 ranks Fast started lagging very much

it takes more than 5s-10s to report a new rec, to accept any command, menus, everything

any tip on how to improve the performance?

[mcm]

i have 5k ranked at 7k players still no slowdown for me,
but hold on a few days and there will be s

[Generator]

w00t! Cant wait for the S version!

any nearer mcm matey?