Difference between revisions of "VideoLAN Wiki:Add a skin"
Line 14: | Line 14: | ||
Add the skin to the skins table: | Add the skin to the skins table: | ||
− | INSERT INTO skins (name,author,image,url) VALUES ('<name>','<author>','<image name>','<vlt name>'); | + | INSERT INTO skins (name,min_version,author,image,url) VALUES ('<name>','<VLC version number>','<author>','<image name>','<vlt name>'); |
And rate the skin: | And rate the skin: | ||
Line 38: | Line 38: | ||
And update the time | And update the time | ||
− | % | + | % UPDATE skins SET date_modified = date(now()) WHERE id = <id>; |
+ | |||
+ | If needed, update the minimum VLC version requirement too | ||
+ | % UPDATE skins SET min_version = '<the version>' WHERE id = <id>; |
Revision as of 17:21, 28 January 2007
Skins are on ganesh. Log on ganesh as videolan.
Add a skin
Download the skin and its image in ~videolan/www/vlc/skins2/
Add a thumbnail for the skin:
% skins-thumbs
Add the skin to the skin pack:
% skins-pack
Connect to the postgresql database:
% psql -d www-videolan
Add the skin to the skins table:
INSERT INTO skins (name,min_version,author,image,url) VALUES ('<name>','<VLC version number>','<author>','<image name>','<vlt name>');
And rate the skin:
INSERT INTO "skins-rating" (skin_id,rating) VALUES ((SELECT LAST_VALUE FROM skins_id_seq), '5');
(ratings can be 1, 2, 3, 4 or 5, 5 being the best rating) We need to rate the skin at least once or it won't appear on the webpage (unless someone fixes the SQL query).
Update a skin
Download the new skin and its new image in ~videolan/www/vlc/skins2/. Be sure the image and the skin have the same name.
Update the thumbnail for the skin:
% skins-thumbs
Update the skin pack:
% skins-pack
Connect to the postgresql database:
% psql -d www-videolan
When connected, find the id of the skins like that
% SELECT Id FROM skins WHERE name LIKE '<name>%';
Check that you only got ONE id. :D
And update the time
% UPDATE skins SET date_modified = date(now()) WHERE id = <id>;
If needed, update the minimum VLC version requirement too
% UPDATE skins SET min_version = '<the version>' WHERE id = <id>;