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

From VideoLAN Wiki
Jump to navigation Jump to search
Line 11: Line 11:
 
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>
 
<pre>INSERT INTO skins (name,author,image,url) VALUES ('<name>','<author>','<image name>','<vlt name>');</pre>
 +
 +
And rate the skin:
 +
<pre>INSERT INTO "skins-rating" (skin_id,rating) VALUES ((SELECT LAST_VALUE FROM skins_id_seq), '5');</pre>
 +
(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).

Revision as of 15:43, 16 April 2006

Login on ganesh

Download the skin and its image in ~videolan/www/vlc/skins2/

Add a thumbnail for the skin: 

% skins-thumbs

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

Retrieved from "https://wiki.videolan.org/index.php?title=VideoLAN_Wiki:Add_a_skin&oldid=4200"