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

From VideoLAN Wiki
Jump to navigation Jump to search
(Update instructions to add new skins in the skin pack.)
Line 4: Line 4:
  
 
Add a thumbnail for the skin:
 
Add a thumbnail for the skin:
<pre>% skins-thumbs</pre>
+
% skins-thumbs
 +
 
 +
Add the skin to the skin pack:
 +
% skins-pack
  
 
Connect to the postgresql database:
 
Connect to the postgresql database:
<pre>psql -d www-videolan</pre>
+
% psql -d www-videolan
  
 
Add the skin to the skins table:
 
Add the skin to the skins table:
<pre>INSERT INTO skins (name,author,image,url) VALUES ('<name>','<author>','<image name>','<vlt name>');</pre>
+
INSERT INTO skins (name,author,image,url) VALUES ('<name>','<author>','<image name>','<vlt name>');
  
 
And rate the skin:
 
And rate the skin:
<pre>INSERT INTO "skins-rating" (skin_id,rating) VALUES ((SELECT LAST_VALUE FROM skins_id_seq), '5');</pre>
+
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)
 
(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).

Revision as of 18:46, 20 January 2007

Login on ganesh

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).