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

From VideoLAN Wiki
Jump to navigation Jump to search
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>;
+
  % 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>;