x10Hosting Forums

Corporate Free Hosting for the Masses.



Register

Reply
 
LinkBack Thread Tools Display Modes
themasterrocker
Guest

Posts: n/a
Credits: 0
[Check]
Quote  
09-28-2008, 03:59 AM
need someone to do me a mySQL table, for credits :D

Hey Guys,

I'm a DJ on X10 radio.
Can anyone design and send me a table i can put on my site to make my X10 radio playlist into a click playlist? So like you click a song you want to play and it requests it and sends me the request to SAM broadcaster.

Thanks in advance

--themasterrocker--aka--DJ SPOON--
Edit:
Anyone want to do it? Help a radio DJ out? Please!

Last edited by themasterrocker; 09-28-2008 at 03:59 AM. Reason: Automerged Doublepost
Reply With Quote
Report Post
x10Hosting Member

Join Date: Sep 2008
Posts: 66
Credits: 727
exemption is on a distinguished road
Quote  
09-28-2008, 04:13 AM
Re: need someone to do me a mySQL table, for credits :D

Well it depends on what you need..

Code:
CREATE TABLE `cashxferlogs` (
  `song` int(11) NOT NULL auto_increment,
  `which` int(11) NOT NULL default '0',
  `what` int(11) NOT NULL default '0',
  `cxVALUE` int(11) NOT NULL default '0',
  `cxTIME` int(11) NOT NULL default '0',
  `cxFROMIP` varchar(15) NOT NULL default '127.0.0.1',
  `cxTOIP` varchar(15) NOT NULL default '127.0.0.1',
  PRIMARY KEY  (`cxID`)
) ENGINE=MyISAM
Need more information..but that is a basic table for a song list to list..so lol yea lemme know
Reply With Quote
exemption is offlineReport Post
themasterrocker
Guest

Posts: n/a
Credits: 0
[Check]
Quote  
09-28-2008, 04:14 AM
Re: need someone to do me a mySQL table, for credits :D

Well this is how my playlist looks at the moment. If you click this link http://www.helprunescape.net/X10radioplaylist.xml
Reply With Quote
Report Post
x10Hosting Member

Join Date: Sep 2008
Posts: 66
Credits: 727
exemption is on a distinguished road
Quote  
09-28-2008, 04:20 AM
Re: need someone to do me a mySQL table, for credits :D

Well...you could write a script so that you can insert songs direct from your shoutcast or w/e you use..
Like a song upload..and then you create the custom playlist..
But I am not sure of what you want..
__________________


I program PHP..so if you need help lemme know!

Reply With Quote
exemption is offlineReport Post
themasterrocker
Guest

Posts: n/a
Credits: 0
[Check]
Quote  
09-28-2008, 04:22 AM
Re: need someone to do me a mySQL table, for credits :D

Basically when the someone goes on my playlist If they want a song, if they click it like a weblink it will tell them its been requested and send it to my broadcaster.
Reply With Quote
Report Post
x10Hosting Member

Join Date: Sep 2008
Posts: 66
Credits: 727
exemption is on a distinguished road
Quote  
09-28-2008, 04:34 AM
Re: need someone to do me a mySQL table, for credits :D

Well...
Then your broadcaster had better be able to play multiple songs...
Or you could do something like
Code:
<a href='listmotcrueone.php?listen=1'>Motley Crue~One</a>
But if you were to have that you would have to have something like a plugin for the 'listmotcrueone.php' file
Such as

Code:
<?php
include "headerfile.php";
print "<h3>Motley Crue~ONE</h3><br />
<script type="text/javascript">
Have the script for your plugin
</script>";
}
$h-endpage()
?>
Or you could just use a flash code..
The simplest thing would just to have simple plug ins for your player..
and when you wanted to broadcast..a pop up would occur..which is easy to program with javascript..
Edit:
If that is something you are looking for...
If not specify more please
__________________


I program PHP..so if you need help lemme know!


Last edited by exemption; 09-28-2008 at 04:34 AM. Reason: Automerged Doublepost
Reply With Quote
exemption is offlineReport Post
themasterrocker
Guest

Posts: n/a
Credits: 0
[Check]
Quote  
09-28-2008, 04:40 AM
Re: need someone to do me a mySQL table, for credits :D

Well, i got told mySQL is the key by Woiwky. (old friend) and he's gone somewhere because he hasn't been on X10 in a while and hasn't been on msn in a while because he was going to do it. And my broadcaster is: SAM Broadcaster
Attached Thumbnails
need-someone-do-me-mysql-table-credits-d-sam.jpg  

Last edited by themasterrocker; 09-28-2008 at 04:45 AM.
Reply With Quote
Report Post
x10 Sophmore

xmakina's Avatar

Join Date: May 2008
Posts: 239
Credits: 2,077
xmakina will become famous soon enough
Location: England

Send a message via MSN to xmakina
Quote  
09-28-2008, 07:03 AM
Re: need someone to do me a mySQL table, for credits :D

You'll have to fill in the blanks and rename fields where appropriate but I think this is what you're after.

PHP Code:
<?php
echo "<table>";
echo 
"<tr>";
echo 
"<th>Band</th><th>Song</th><th>etc...</th><th>Request</th>";

$sql "SELECT * FROM Songs";
$result mysql_query($sql);
while(
$row mysql_fetch_array($result){
echo 
"<tr>";
echo 
"<td>" $row['bandName'] . "</td>";
echo 
"<td>" $row['songName'] . "</td>";
echo 
"<td>etc</td>";
echo 
"<td><a href=\"request.php?songID=" $row['songID'] . "\">Request</a>";
}
?>
The request page takes songID in it's $_GET array so it can be used in a request.

Hope this helps
Reply With Quote
xmakina is offlineReport Post
themasterrocker
Guest

Posts: n/a
Credits: 0
[Check]
Quote  
09-28-2008, 09:52 AM
Re: need someone to do me a mySQL table, for credits :D

Ok, well... time to make a db however i still need the db created although i got someone working on it, need it done ASAP. I think hellsheep is going to help me when he comes back online. Also where does the PHP send the data of whats been requested?

Last edited by themasterrocker; 09-28-2008 at 10:17 AM.
Reply With Quote
Report Post
x10 Sophmore

xmakina's Avatar

Join Date: May 2008
Posts: 239
Credits: 2,077
xmakina will become famous soon enough
Location: England

Send a message via MSN to xmakina
Quote  
09-28-2008, 04:42 PM
Re: need someone to do me a mySQL table, for credits :D

To "request.php" as a GET rather than POST.
Reply With Quote
xmakina is offlineReport Post
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Im Getting A Mysql Error And I Challenge Anyone To Help Me Fix It dquigley Programming Help 14 09-29-2008 08:07 PM
New Site-Suggestions? mnoutside Review My Site 9 08-27-2008 08:01 AM
[PHP] MySQL and PHP Bryon Tutorials 23 08-17-2008 03:15 AM
MysQL Query for Master table & child table phpasks Programming Help 8 08-07-2008 09:07 AM
Table inside table wizeman Tutorials 4 07-11-2005 06:56 PM


All times are GMT -5. The time now is 07:05 PM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0 RC7
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios

Project Management Software | Web Advertising | Remortgages | Loans | Shares