What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Messenger Plus! for Live Messenger » Scripting » Plug-Ins » import name from mysql database

import name from mysql database
Author: Message:
rvec
New Member
*


Posts: 1
Joined: Jan 2007
O.P. import name from mysql database
I use sam to stream my Internet radio. This program exports the song playing to a mysql database. I want to show the current playing song with some own text as my screen name.

example:
song playing: Yellow Submarine - The Beatles
my screenname: Now on my radio: Yellow Submarine - The Beatles

the things the script should do:
log into mysql
goto a database (samdb is the standard)
browse table historylist
find the input with the highest ID
echo artist and title in screenname

The Fieldnames are "ID" "artist" and "title"
ID is the primary key

If any more information is needed don't hesitate asking.
I can also give a sample database.



Edit: The thing above gives the last played song if none is playing. So you also need to do "total playtime last song + last played > time now"

Flieldname last played="date_played"
date_played in this format:"2007-01-15 14:28:17"
Fieldname total playtime= "duration"
duration in this format: "164284" (time in seconds)

This post was edited on 01-15-2007 at 02:41 PM by rvec.
01-14-2007 09:34 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
import name from mysql database - by rvec on 01-14-2007 at 09:34 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On