Difference between revisions of "VideoLAN Wiki:Add a skin"

From VideoLAN Wiki
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 ===
+
== 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>;