Profile Music Uploader

riderz replied

22.09.09, 22:39
well ive tried the embed code

Code:

echo "<embed name=\"$music\"src=\"/music/$musiclink\"loop=\"false\"hidden=\"true\"autostart=\"true\"></embed>";

but it show the music in the folder in every person profile
Leave a comment:
srecnica replied

22.09.09, 22:31
$musiclink = getmusic($who);
if ($musiclink=="")
{
echo "<br/><img src=\"images/music.jpg\" alt=\"music\"/>";
}else{
echo "<br/><img src=\"$musiclink\" alt=\"music\"/>";
}
echo"<br/>";

and this will be to hear music? without embed code?
Leave a comment:

riderz replied

22.09.09, 22:15

ive tried sumthing else now i just need the code to play music in the background

sql

--
-- Table structure for table `ibwf_music`
--

CREATE TABLE `ibwf_music` (
`id` int(10) NOT NULL auto_increment,
`musiclink` varchar(150) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `musiclink` (`musiclink`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

--
-- Dumping data for table `ibwf_music`

lists.php

Code:

//////////////////////////////////////////////////////Music

else if($action=="music")
{
    addonline(getuid_sid($sid),"Music List","");
    $pstyle = gettheme($sid);
      echo xhtmlhead("Music List",$pstyle);


    //////ALL LISTS SCRIPT <<

    if($page=="" || $page<=0)$page=1;
    $noi = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM ibwf_music"));
    $num_items = $noi[0]; //changable
    $items_per_page= 2;
    $num_pages = ceil($num_items/$items_per_page);
    if(($page>$num_pages)&&$page!=1)$page= $num_pages;
    $limit_start = ($page-1)*$items_per_page;

    //changable sql

        $sql = "SELECT id, musiclink FROM ibwf_music ORDER BY id DESC LIMIT $limit_start, $items_per_page";


    echo "<p>";
    $items = mysql_query($sql);
    echo mysql_error();
    if(mysql_num_rows($items)>0)
    {
    while ($item = mysql_fetch_array($items))
   {
        echo "<bgsound src=\"$item[1]\" alt=\"music\"/><br/>";
        echo "<a href=\"genproc.php?action=upmusic&amp;musicid=$item[0]\">SELECT</a><br/>";
        echo "<br/>";
    }
    }
    echo "</p>";
    echo "<p align=\"center\">";
    if($page>1)
    {
      $ppage = $page-1;
      echo "<a href=\"lists.php?action=music&amp;page=$ppage&amp;view=$view\">«Prev</a> ";
    }
    if($page<$num_pages)
    {
      $npage = $page+1;
      echo "<a href=\"lists.php?action=music&amp;page=$npage&amp;view=$view\">Next»</a>";
    }
    echo "<br/>$page/$num_pages<br/>";
    if($num_pages>2)
    {
      $rets = "<form action=\"lists.php\" method=\"get\">";
        $rets .= "Jump to page<input name=\"page\" format=\"*N\" size=\"3\"/><br/>";
        $rets .= "<input type=\"submit\" value=\"GO\"/>";
        $rets .= "<input type=\"hidden\" name=\"action\" value=\"$action\"/>";
        $rets .= "<input type=\"hidden\" name=\"sid\" value=\"$sid\"/>";

        $rets .= "</form>";

        echo $rets;
    }
    echo "</p>";
  ////// UNTILL HERE >>
    echo "<p align=\"center\">";
    echo "<a href=\"index.php?action=cpanel\">";
echo "CPanel</a><br/>";
    $thid = mysql_fetch_array(mysql_query("SELECT themeid FROM ibwf_users WHERE id='".$uid."'"));
    $themeimageset = mysql_fetch_array(mysql_query("SELECT themedir FROM ibwf_iconset WHERE id='".$thid[0]."'"));
    echo "<a href=\"index.php?action=main\"><img src=\"http://coding-talk.com/images/themes/$themeimageset[0]/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
    echo xhtmlfoot();
 exit();
    }

genproc.php

Code:

///////////////////////////////////////////////////////////////////Select music
else if($action=="upmusic")
{
    addonline(getuid_sid($sid),"Updating music","");
    $musicid = $_GET["musicid"];
$pstyle = gettheme($sid);
      echo xhtmlhead("$stitle",$pstyle);
  echo "<p align=\"center\">";
  //$uid = getuid_sid($sid);
  $musiclink = mysql_fetch_array(mysql_query("SELECT musiclink FROM ibwf_music WHERE id='".$musicid."'"));
  $res = mysql_query("UPDATE ibwf_users SET music='".$musiclink[0]."' WHERE id='".$uid."'");
  if($res)
        {
            echo "<img src=\"http://coding-talk.com/images/ok.gif\" alt=\"o\"/>music Selected<br/>";
        }else{
          echo "<img src=\"http://coding-talk.com/images/notok.gif\" alt=\"x\"/>Database Error!<br/>";
        }
        echo "<br/>";

         $thid = mysql_fetch_array(mysql_query("SELECT themeid FROM ibwf_users WHERE id='".$uid."'"));
    $themeimageset = mysql_fetch_array(mysql_query("SELECT themedir FROM ibwf_iconset WHERE id='".$thid[0]."'"));
    echo "<a href=\"index.php?action=main\"><img src=\"http://coding-talk.com/images/themes/$themeimageset[0]/home.gif\" alt=\"*\"/>";
echo "Home</a>";
  echo "</p>";
  echo xhtmlfoot();
 exit();
    }

ive tried this in viewuser

Code:

  $musiclink = getmusic($who);
  if ($musiclink=="")
  {
  echo "<br/><bgsound src=\"music/$musiclink\" alt=\"music\"/>";
  }else{
  echo "<br/><bgsound src=\"$musiclink\" alt=\"music\"/>";
  }
echo"<br/>";

core.php

Code:

/////////////////////////////////////////getmusic

function getmusic($uid)
{
  $music = mysql_fetch_array(mysql_query("SELECT music FROM ibwf_users WHERE id='".$uid."'"));
  return $music[0];
}

ok now i have a lil prob how can i make it to play the music in profile i tried to add the avatar code but did not work

Last edited by riderz; 22.09.09, 22:51.