Bonjour, BS2000 (raina) Update

[dantro]

Hi,

I've seen the credits for my BS2000 skin series in Dragan Jakovljevic's XLXM skin comments and got aware of the new support site which currently shows a 5-star rating for my skin. This made me updating the BS2000 skin during last weekend. It now has the long requested minimode with advanced options, a library button and some other features Ian suggested last year.

Bonjour, BS2000 (raina)


I send out greetings to raina who inspired the minimode, Dragan for keepin' it real, Rah'Dick for running the support site and all other XMPlay users around.

Rah'Dick: Could you please update the support sites with all the skin versions and themes from my work folder over @ http://www.danny-und-stefanie.de/xmpskins/

Also I'd like to sort the skins by their rating. Can this be implemented?

This update uses my sakura colour sheme. For all the people that are not so pleased with it, I am using the skin together with this wallpaper: http://www.danny-und-stefanie.de/xmpskins/Overcast.bmp.bz2

I'd love to see people creating their own colour shemes and adding them to the support sites. It really just takes 15 minutes to change the colours to your personal likes.

Regards,
Dan

[Rah'Dick]

@Sorting by rating: I'm working on it - unfortunately it's not as easy as sorting by name or date.
Sorting by rating requires two database queries: one that selects all skins from the files table and one query for each file to give back the average of all ratings for that specific file, selected out of the comments table. It might be possible to accomplish this using JOINs, but I don't know how atm.

[Tombo]

SELECT Skins.name, avg(Ratings.rating) AS average_rating
FROM Ratings, Skins
GROUP BY Skins.ID
WHERE Skins.ID = Ratings.SkinID AND
SORT BY average_rating

Something like this?

[raina]

Hi Dan, glad you remembered my mockup. The minimode fits like a glowe on the window title bars (classic windows look). Did you forget your password or why aren't we seeing the alien-race-like sounding "sirdan" anywhere? And wtf are you listening to?!

[Rah'Dick]

Something like this?

Almost.

select files.*, avg(comments.rating) as avg_rating
from files, comments
where files.category_id=5
and files.id = comments.target_id
and comments.target_type='file'
group by files.id
order by avg_rating desc;

The only problem is, this query returns skins which have ratings only - skins without comments or ratings don't show up.
Have to play around with it a little more.

[Maserati]

can you include the other color schemes like you did with the source from the last version?

[dantro]

Hi,

raina: I didn't forget my password. My old user account was the name for my former domain. Since I don't maintain it anymore, I decided to go by my normal handle.

Maserati: You like a different colour sheme? Just change the updated version to your fav colours and send this version to Rah'Dick for inclusion on the support site.

Regards,
Dan

[Torkell]

Possible idea: store the average rating in files, and recalculate it whenever someone rates it. Unrated skins can either sit at 0, or have a special value like -1.

[Y@nek®]

I want more Plastic color variations especially black (inversion of this white), please Rah'Dick make this skin with more colors - like Bonjour skin. 

[Rah'Dick]

Ok, sorting by rating works now. This is how I solved it:

I added another row to the files table that stores the average rating (thanks for the idea, BoggyB!) and each time someone adds a comment, these values are updated.

@ Color schemes: Maybe I should release the sources for Plastic...

[Y@nek®]

That is a very good idea.

[Rah'Dick]

Then go for it, the files are up :-)
This is getting a bit off-topic, so I suggest to leave this thread alone, now that it's purpose is fulfilled.

[Y@nek®]

Then go for it, the files are up :-)
This is getting a bit off-topic, so I suggest to leave this thread alone, now that it's purpose is fulfilled.

Thank you.



 

[Aux]

Rah'Dick, to make Your SELECT ordered by rating efficient, You should add one more field to table with skin info which will hold rating and recalculate that value each time someone rate skin. That will greatly improve speed of SELECT query and also You will always know how every skin is rated.

P.S. dantro, which tool did You use to create TTFs? I would like to insert cyrilic script.

[Rah'Dick]

Rah'Dick, to make Your SELECT ordered by rating efficient, You should add one more field to table with skin info which will hold rating and recalculate that value each time someone rate skin. That will greatly improve speed of SELECT query and also You will always know how every skin is rated.

That's exactly what I actually did - and I wrote about it some posts earlier.

[dantro]

I just stumbled upon a desktop modding community and found it very interesting that people already use our skins to style their desktops. In my case a person from Sao Paulo redesigned my Bonjour, BS2000 series to make it fit to the rest of his background. Even though I am using internet for quite some time now, it still gives me a special feeling when my art reaches places of this earth I might never been able to travel to.

Link: http://www.winajuda.com/forum/viewtopic.php?t=26&start=720

Regards,
Dan

[Rah'Dick]

W00t, fun