Difference between revisions of "VideoLAN Wiki:Add a skin"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
Login on ganesh | Login on ganesh | ||
+ | == Add a skin == | ||
Download the skin and its image in ~videolan/www/vlc/skins2/ | Download the skin and its image in ~videolan/www/vlc/skins2/ | ||
Line 20: | Line 21: | ||
We need to rate the skin at least once or it won't appear on the webpage (unless someone fixes the SQL query). | 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. | ||
+ | |||
+ | Add a thumbnail for the new skin: | ||
+ | % skins-thumbs | ||
+ | |||
+ | Add the new skin to the skin pack: | ||
+ | % skins-pack | ||
+ | |||
+ | Connect to the postgresql database: | ||
+ | % psql -d www-videolan | ||
+ | |||
When connected, find the id of the skins like that | When connected, find the id of the skins like that | ||
− | % SELECT Id FROM skins WHERE name LIKE '<name>%' | + | % SELECT Id FROM skins WHERE name LIKE '<name>%'; |
And update the time | And update the time | ||
% UPDATE skins SET date_modified = date(now()) WHERE id = <id>; | % UPDATE skins SET date_modified = date(now()) WHERE id = <id>; |
Revision as of 20:03, 22 January 2007
Login on ganesh
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,author,image,url) VALUES ('<name>','<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.
Add a thumbnail for the new skin:
% skins-thumbs
Add the new skin to 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>%';
And update the time
% UPDATE skins SET date_modified = date(now()) WHERE id = <id>;