StreamingSoundtracks.com
Search

 

VIP
Subscribe to become a VIP member of SST!

· Request More Often
· Unshared Requests
· Request Countdown Timer
· Request Ready Indicator
· Your Request History
· Access To The VIP Forum
· Add More Favorites

:: Click Here To Upgrade ::

:: Give VIP as a Gift ::

Click Here To Listen

Follow Us


Donation Meter


Make donations with PayPal!
Monthly Goal:
$500.00

Need:
$325.00

17 Donations:
$175.00

StreamingSoundtracks.com (Oct-22) Hart $25.00
StreamingSoundtracks.com (Oct-21) Bryophyte $10.00
StreamingSoundtracks.com (Oct-20) CaptainKidd $5.00
Death.FM (Oct-17) 6pence $10.00
StreamingSoundtracks.com (Oct-16) Borg124 $5.00
Death.FM (Oct-13) postmasterdclxvi $15.16
Death.FM (Oct-11) deathfish $5.00
StreamingSoundtracks.com (Oct-10) Ruelf $10.00
StreamingSoundtracks.com (Oct-6) Corsica1er $5.00
StreamingSoundtracks.com (Oct-6) crowndelorean $5.00
Death.FM (Oct-4) tabh666 $19.84
Death.FM (Oct-3) Windsor $10.00
StreamingSoundtracks.com (Oct-2) The1toBtrue $10.00
StreamingSoundtracks.com (Oct-2) Reevex $10.00


 


Last Month's Donors
Death.FM (Sep-30) lawless $5.00
StreamingSoundtracks.com (Sep-30) voda $20.00
StreamingSoundtracks.com (Sep-30) Bryophyte $10.00
StreamingSoundtracks.com (Sep-30) BiRhar $10.00
StreamingSoundtracks.com (Sep-30) molossus $10.00
StreamingSoundtracks.com (Sep-30) martino $5.00




Windows Phone App

Android App

SSTore



:: SSTore ::


Windows Media

Partners


:: Link To Us ::
:: Add Your Link ::


Main tiltes, etc
Goto page 1, 2  Next
 
Post new topic   Reply to topic    StreamingSoundtracks.com Forum Index -> Ideas
View previous topic :: View next topic 
Author Message
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Mon Aug 29, 2005 11:51 am   Post subject: Main tiltes, etc Reply with quote


Has anybody given any thought to renaming all the "Main Titles" etc. tracks to be something like Main Titles - $MOVIE_NAME so that they can be played again?

This might be a big job (based on the playlist we got on SSTs birthday) but it could probably be automated in MySQL and/or broken up and done in chunks.

Maybe it'll be fixed upstream as well, though.

jeff
sdg
Denmark Armand
Lieutenant Commander
Lieutenant Commander

aw

Joined: Jul 19, 2004
Member#: 7352
Posts: 490
Location: CPH

Armand is offline View user's profile Send private message Armand's Favorites are Private
PostPosted: Mon Aug 29, 2005 12:19 pm   Post subject: Reply with quote


Sounds like a good idea....
_________________
Our umbrellas are colliding and I can't walk straightly.
Seeing me like that made you laugh.

- Ninomiya Kazunari
(from the song Niji/Rainbow)
genericdragon
Commander
Commander



Joined: Jul 29, 2004
Member#: 7493
Posts: 706
Location: Over Hill and Under Wood

genericdragon is offline View user's profile Send private message genericdragon's Favorites are Private
AIM Address Yahoo Messenger MSN Messenger ICQ Number
PostPosted: Mon Aug 29, 2005 5:53 pm   Post subject: Reply with quote


Unfortunately this is a big job that only Jeric can do, as far as I know.

but it is a solution to the problem.
_________________
"It does not do to leave a live dragon out of your calculations, if you live near him." ~ J.R.R. Tolkien

"The thing that impresses me the most about America is the way parents obey their children." ~ King Edward VIII (1894 - 1972)
Netherlands Caliburn VIP (subscribed member)
Admiral (Administrator)
Admiral (Administrator)



Joined: Apr 03, 2002
Member#: 43
Posts: 3623
Location: The Netherlands

Caliburn is offline View user's profile Send private message Send e-mail Visit poster's website View Caliburn's Favorites
PostPosted: Tue Aug 30, 2005 2:03 am   Post subject: Reply with quote


The other admins can probably help. JERIC was curious and looked op the number of "Main Title" trakcs. This appears to be 594 tracks alone. Dont think it is feasible to implement this.

For the record. JERIC is patiently poking the SAM creators to fix this very amateuristic bug.
_________________
"Believe it or not, I do try to do some good in the community." -Alonzo Harris

http://www.last.fm/user/caliburn77

Do not PM me. Use email
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Tue Aug 30, 2005 6:31 am   Post subject: Reply with quote


I thought that me might be looking for an upstream fix from the SAM folks. I also knew that it might be a big job. However, I also thought that the task might be able to be automated. I've got just a small amount of experience in MySQL and have done simpler automated tasks in the past (usually just updates, though). If I get a chance to do some research I'll report back. I don't expect it's worth the trouble to do it by hand. However, if it can be automated (and even done in such a way that allows it to be easily undone once SAM is fixed) then maybe it's something JERIC will consider.

jeff
sdg
USA JERIC VIP (subscribed member)
Fleet Admiral (Proprietor)
Fleet Admiral (Proprietor)



Joined: Feb 12, 2002
Member#: 1
Posts: 4939
Location: Richmond, VA

JERIC is offline View user's profile Send private message Send e-mail Visit poster's website View JERIC's Favorites
AIM Address Yahoo Messenger MSN Messenger ICQ Number Skype Name
PostPosted: Tue Aug 30, 2005 11:19 am   Post subject: Reply with quote


I'm open to a automated solution. If people wouldn't select songs that are already in queue this wouldn't be much of an issue.
_________________
"Are you not entertained? Are you not entertained? Is this not why you are here?." -Maximus

Please do not PM me. Use email, Feedback or Contact Us links.
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Tue Aug 30, 2005 1:01 pm   Post subject: Reply with quote


JERIC wrote:
If people wouldn't select songs that are already in queue this wouldn't be much of an issue.


I thought the issue was that once a "Main Titles" was played then no other "Main Titles" could be played until the 8 day limit on the first one ran out. What does that have to do with something already in the queue? Is there another problem I'm not aware of or am I confused on the issue?

Also, some info on the MySQL box might be helpful so I can be sure that any solution that I find will work (OS, MySQL version, etc.). Don't post details here, though. Do it via PM or somewhere that the whole world won't see.

jeff
sdg
USA JERIC VIP (subscribed member)
Fleet Admiral (Proprietor)
Fleet Admiral (Proprietor)



Joined: Feb 12, 2002
Member#: 1
Posts: 4939
Location: Richmond, VA

JERIC is offline View user's profile Send private message Send e-mail Visit poster's website View JERIC's Favorites
AIM Address Yahoo Messenger MSN Messenger ICQ Number Skype Name
PostPosted: Tue Aug 30, 2005 2:00 pm   Post subject: Reply with quote


The problem is if the song name rules ARE enforced then for example, we cannot request "Main Titles" for 6 months.

The problem is of the song name rules are NOT enforced then people can request the same song over and over until it has played. That means 1 song can be repeated in the queue many times because it hasn't officially played yet.
_________________
"Are you not entertained? Are you not entertained? Is this not why you are here?." -Maximus

Please do not PM me. Use email, Feedback or Contact Us links.
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Wed Aug 31, 2005 5:48 am   Post subject: Reply with quote


If I follow you right, what you're saying is that SAM marks a song as played when it hits the queue, not when it is actually played. That makes sense to me. Is that related to the "Main Titles" issue, though? Maybe that's where I'm confused.

jeff
sdg
USA JERIC VIP (subscribed member)
Fleet Admiral (Proprietor)
Fleet Admiral (Proprietor)



Joined: Feb 12, 2002
Member#: 1
Posts: 4939
Location: Richmond, VA

JERIC is offline View user's profile Send private message Send e-mail Visit poster's website View JERIC's Favorites
AIM Address Yahoo Messenger MSN Messenger ICQ Number Skype Name
PostPosted: Wed Aug 31, 2005 7:29 am   Post subject: Reply with quote


Nope, SAM marks it as played once it hits the history list. The problem is if the rules aren't enforced people can keep requesting stuff that is already in the queue because the song hasn't been officially played.

We have the rules enforced now which causes our current problem of having the song names not requestable in 8 days. We need it to look at the song ID not song name. SAM is lacking this feature and will hopefully be added soon.

Thanks for posting on the SA forums. Smile
_________________
"Are you not entertained? Are you not entertained? Is this not why you are here?." -Maximus

Please do not PM me. Use email, Feedback or Contact Us links.
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Wed Aug 31, 2005 8:40 am   Post subject: Reply with quote


Which rule is being enforced that keeps people from requesting something already in the queue? How is that related to the "Main Titles" issue? Argh. I'm so confused. (Nothing new here.) Oh well. It's not important that I understand, really. I'm just curious like that (and I suspect that I'm just missing a simple thing).

If I get any time (maybe toward the end of Sept) I'll still give a shot at automating the song title changes in MySQL.

No problem about the SA post. I hope it helps.

jeff
sdg
Netherlands Caliburn VIP (subscribed member)
Admiral (Administrator)
Admiral (Administrator)



Joined: Apr 03, 2002
Member#: 43
Posts: 3623
Location: The Netherlands

Caliburn is offline View user's profile Send private message Send e-mail Visit poster's website View Caliburn's Favorites
PostPosted: Wed Aug 31, 2005 3:41 pm   Post subject: Reply with quote


I dont think it is an SQL thing. I think sql extracts its info from the ID3 tags. dunno what the behaviour will be.
_________________
"Believe it or not, I do try to do some good in the community." -Alonzo Harris

http://www.last.fm/user/caliburn77

Do not PM me. Use email
USA j2brown
Commodore
Commodore

aw

Joined: Feb 22, 2002
Member#: 9
Posts: 3176
Location: Sterling, VA

j2brown is offline View user's profile Send private message Send e-mail View j2brown's Favorites
AIM Address Yahoo Messenger MSN Messenger
PostPosted: Thu Sep 01, 2005 4:43 am   Post subject: Reply with quote


Now I think I've confused Cal. I know the problem isn't an SQL thing, but the temorary fix might be.

jeff
sdg
NathanDahlin
Cadet 1
Cadet 1



Joined: Aug 20, 2005
Member#: 11314
Posts: 2


NathanDahlin is offline View user's profile Send private message NathanDahlin's Favorites are Private
PostPosted: Thu Sep 01, 2005 10:12 pm   Post subject: Reply with quote


I actually had the exact same idea (changing the "Main Titles" track names to include the movie title). Perhaps I still don't understand the situation, either, but is there no way for us to help JERIC manually edit all the tracks? Granted, there are nearly 600 of them, but how long does it take to edit a track? Surely one could do the whole job with just a few hours of work.

Forgive my impatience, but I use to administrate a discussion forum whose tech admin was basically AWOL, so I hate having to wait for someone who may or may not eventually get around to fixing something. My impatience could be unfounded; I just don't know how good the SAM folks are about checking in regularly. How long have you guys been waiting for them to get to this fix?
Netherlands Caliburn VIP (subscribed member)
Admiral (Administrator)
Admiral (Administrator)



Joined: Apr 03, 2002
Member#: 43
Posts: 3623
Location: The Netherlands

Caliburn is offline View user's profile Send private message Send e-mail Visit poster's website View Caliburn's Favorites
PostPosted: Fri Sep 02, 2005 4:18 am   Post subject: Reply with quote


The issue has been brought up to them on March 9th. The only response I have seen is
Quote:
I'll see what I can do, but cant promise implementation.
This would have significant effects on core parts of the code.


I still think changing all those track names is not a good idea. I am not into SAM like JERIC so this is just a guess. Changing ID3 tags will probably result in reloading the album in SAM which would mess up our statistics. And hacking in the SQL database should be done as less as possible. JERIC will prolly agree on that with me ;-)
_________________
"Believe it or not, I do try to do some good in the community." -Alonzo Harris

http://www.last.fm/user/caliburn77

Do not PM me. Use email
Display posts from previous:
Post new topic   Reply to topic    StreamingSoundtracks.com Forum Index -> Ideas All times are GMT - 5 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Forums ©


Copyright © 2001-2014 24seven.FM, LLC All rights reserved.
Comments, images, and trademarks are property of their respective owners.
You can syndicate our news using the file backend.php or ultramode.txt. Robots may follow the Sitemap.