Skip to Content
It is currently December 7th, 2019, 4:08 pm

All times are UTC - 6 hours [ DST ]




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: see who is requesting
PostPosted: June 1st, 2014, 9:27 am 
Offline
Junior User
Junior User

Joined: May 31st, 2014, 8:18 am
Posts: 61
Hi gang, does anybody know a way to see who is putting in requests in sam broadcaster. Even just their Ip would help. at one point during the night I was the only one listening, but request were still put in???


Top
 Profile  
Reply with quote  
PostPosted: June 1st, 2014, 12:31 pm 
Offline
SVS Member
SVS Member

Joined: May 8th, 2004, 9:00 am
Posts: 10451
Location: Denver, CO
The IP of the requester is in the requestlist table of your database listed as host, use mysql workbench if you using mysql to query that table. If using Firebird you would need something like Freebird or other FB query tools.

_________________
- Rob Oyler, SVS
Image


Top
 Profile  
Reply with quote  
PostPosted: June 1st, 2014, 1:04 pm 
Offline
Experienced User
Experienced User

Joined: September 28th, 2004, 10:22 pm
Posts: 257
Location: Seattle, WA
If you're using MySQL, here's a command line that will output an HTML file showing ALL of the requests you've ever gotten, ordered by their time stamp from earliest to latest, showing the IP address of the person who requested it:

Code:
mysql SAMDB -H -e"select sl.artist, sl.title, rl.host, rl.t_stamp from songlist sl, requestlist rl where sl.ID=rl.songID and rl.status != 'ignored' ORDER BY rl.t_stamp ASC;" > <ENTER A PATH HERE>\requests.html


Make sure you change the <ENTER A PATH HERE> to a path on your system where you want the requests.html file to end up.

The HTML file will have one line for each request that looks like this:

(artist title host t_stamp) <= only at the top of the file

Queensryche Some People Fly 24.16.37.187 2004-09-13 19:30:00

(that was the first request we ever got on HCR ... that seems like a million years ago as opposed to 10. ^_^ )

_________________
DJ Meatwad
former Owner/Webmaster, Head Case Radio
(13 September 2004 - 2 July 2016)


Top
 Profile  
Reply with quote  
PostPosted: June 1st, 2014, 9:15 pm 
Offline
SVS Member
SVS Member

Joined: October 15th, 2003, 11:59 pm
Posts: 4735
Location: Los Angeles - A Little West Of Nashville
I have a PHP script that will show you the IP of the requester and any dedication:
http://www.lahotcountry.com/upcoming.php

If you can use PHP on your site, I can give you the code. I have already, if you search for it.

_________________
- DJ Dee
- Spacial Volunteer Support (SVS)
- Custom PAL services: www.palscripts.com
- http://www.AlternativeHD.com
- http://www.lahotcountry.com


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

All times are UTC - 6 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 5 guests


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:  
Powered by phpBB® Forum Software © phpBB Group