Yggdrasil Radio Discussion

Rockin' the World With Jpop and Your Requests
It is currently Thu Jun 21, 2018 8:22 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
PostPosted: Sat Nov 24, 2012 3:21 pm 
Offline
Yggdrasil DJ
User avatar

Joined: Wed Jul 11, 2007 6:42 pm
Posts: 231
It turns out what I used to do to arrange for requests to play in the proper order involved stupid SQL tricks with the key of the requests table, altering the key of newly created records by setting them to the lowest existing key value minus one.

Well, that's pretty dodgy, not to mention risky, so I worked out a better method.

The scheduling script (written in PAL, a scripting language similar to Delphi) has no way to put requests in the proper order -- there is no command to do that for some reason -- so I developed a subroutine that does the proper scheduling using pure SQL calls.

Anyway, it all seems to work now.

_________________
Image


Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Sat Dec 08, 2012 3:28 pm 
Offline
User avatar

Joined: Mon Oct 15, 2007 4:26 am
Posts: 314
cheers :D
glad to hear it ^^

_________________
Do you Believe in your Dreams?


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


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 post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group