[billyrene]

this is not an android specific question but since i am running android i guess i post it in here.

is there any way, maybe in the database, to replace the season numbers with roman numerals, ie: "season 6" with "season VI", other than right click,manage, edit title?

[Klojum]

Seasons can have 'names', so you could have roman numerals instead. Creating all such entries for your season would be quite a manual task. I don't see it as impossible to do things via script, but you'll have your work cut out for you.

This would be a quick&dirty solution:

sql:


UPDATE seasons set name="Season I"     WHERE season=1  AND name="";

UPDATE seasons set name="Season II"    WHERE season=2  AND name="";

UPDATE seasons SET name="Season III"   WHERE season=3  AND name="";

UPDATE seasons SET name="Season IV"    WHERE season=4  AND name="";

UPDATE seasons SET name="Season V"     WHERE season=5  AND name="";

UPDATE seasons SET name="Season VI"    WHERE season=6  AND name="";

UPDATE seasons SET name="Season VII"   WHERE season=7  AND name="";

UPDATE seasons SET name="Season VIII"  WHERE season=8  AND name="";

UPDATE seasons SET name="Season IX"    WHERE season=9  AND name="";

UPDATE seasons SET name="Season X"     WHERE season=10 AND name="";

UPDATE seasons SET name="Season XI"    WHERE season=11 AND name="";

UPDATE seasons SET name="Season XII"   WHERE season=12 AND name="";

UPDATE seasons SET name="Season XIII"  WHERE season=13 AND name="";

UPDATE seasons SET name="Season XIV"   WHERE season=14 AND name="";

UPDATE seasons SET name="Season XV"    WHERE season=15 AND name="";

UPDATE seasons SET name="Season XVI"   WHERE season=16 AND name="";

UPDATE seasons SET name="Season XVII"  WHERE season=17 AND name="";

UPDATE seasons SET name="Season XVIII" WHERE season=18 AND name="";

UPDATE seasons SET name="Season XIX"   WHERE season=19 AND name="";

UPDATE seasons SET name="Season XX"    WHERE season=20 AND name="";

[billyrene]

perfect solution. for me at least. thank you so very much

but why would you call this quick & dirty?

[Klojum]

but why would you call this quick & dirty?

Because you are basically manually 'hacking' directly into your video database as there is no official option or an add-on to do it for you.

[billyrene]

i understand. thank you very much for the help

[Klojum]

Thread marked solved.