View source for VideoLAN Wiki:Add a skin

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>;