Difference between revisions of "VideoLAN Wiki:Add a skin"
Jump to navigation
Jump to search
(suppress unwanted category transclusion with {{Howto}}) |
|||
| (10 intermediate revisions by 6 users not shown) | |||
| Line 1: | Line 1: | ||
| + | {{howto|Upload skins to the VideoLAN website|nocat=y}} | ||
| + | {{Historical|Use the interface at http://www.videolan.org/vlc/skins.php}} | ||
| + | |||
| + | <div class="widebox" style="border-color: red;"> This page is designed for those with access to videolan@ganesh.videolan.org. </div> | ||
| + | |||
Skins are on ganesh. Log on ganesh as videolan. | Skins are on ganesh. Log on ganesh as videolan. | ||
== Add a skin == | == 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/ | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Connect to the postgresql database: | Connect to the postgresql database: | ||
| Line 14: | Line 13: | ||
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 20: | Line 19: | ||
(ratings can be 1, 2, 3, 4 or 5, 5 being the best rating) | (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). | We need to rate the skin at least once or it won't appear on the webpage (unless someone fixes the SQL query). | ||
| + | |||
| + | Add a thumbnail for the skin, add it to the skin pack and update the skins size in the database: | ||
| + | % skins-update | ||
== Update a skin == | == 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. | Download the new skin and its new image in ~videolan/www/vlc/skins2/. Be sure the image and the skin have the same name. | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Connect to the postgresql database: | Connect to the postgresql database: | ||
| Line 35: | Line 31: | ||
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>%'; | ||
| + | Check that you only got ONE id. :D | ||
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>; | ||
| + | |||
| + | Update the thumbnail and size for the skin, update the skin pack: | ||
| + | % skins-update | ||
| + | |||
| + | |||
| + | |||
| + | [[Category:Roots]] | ||
| + | [[Category:Proposed deletion]] | ||
Latest revision as of 04:56, 30 October 2016
| This page describes how to upload skins to the VideoLAN website. | Other "how to" pages |
|
This page is obsolete and kept only for historical interest. It may document features that are obsolete, superseded, or irrelevant. Do not rely on the information here being up-to-date. Additional information: Use the interface at http://www.videolan.org/vlc/skins.php |
This page is designed for those with access to videolan@ganesh.videolan.org.
Skins are on ganesh. Log on ganesh as videolan.
Add a skin
Download the skin and its image in ~videolan/www/vlc/skins2/
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).
Add a thumbnail for the skin, add it to the skin pack and update the skins size in the database:
% skins-update
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.
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>;
Update the thumbnail and size for the skin, update the skin pack:
% skins-update
