0

On my site I have a page that uses a flash button to play an mp3. I want to keep track of how many times this button is pushed for plays (it also stops the song - dual use button). I have a field in the table for the individual mp3s called 'music_plays' it is an INT(11).

This is the code in the page where some mods would have to take place:

<div class='music_browse_item' style='width: 415px; float: left;'>
      <table cellpadding='0' cellspacing='0'>
      <tr>
      <td style='vertical-align: middle;padding-right: 3px;'>
        <div class='music_button'>
          <object width="17" height="17" data="./images/music_button.swf?song_url={$media_path}" type="application/x-shockwave-flash">
            <param value="./images/music_button.swf?song_url={$media_path}" name="movie" />
            <img width="17" height="17" alt="" src="noflash.gif" />
          </object>
        </div>
      </td>
      <td style='vertical-align: top; padding-left: 10px;'>
        <div style='font-weight: bold; font-size: 13px;'><a href='{$url->url_create("profile", $browse_music_list[browse_music_list_loop].user_username)}'>{$browse_music_list[browse_music_list_loop].music_title|truncate:45:"...":true}</a></div>
        <div class='music_browse_date'>
          {assign var='music_date' value=$datetime->time_since($browse_music_list[browse_music_list_loop].music_date)}{capture assign="updated"}{lang_sprintf id=$music_date[0] 1=$music_date[1]}{/capture}
          {lang_sprintf id=4000103 1=$updated 2=$url->url_create("profile", $browse_music_list[browse_music_list_loop].user_username) 3=$browse_music_list[browse_music_list_loop].music_uploader->user_displayname}
        </div>
        {if $user->user_exists && $user->level_info.level_music_allow_downloads}
        <div style='margin-top: 4px;'>
          <a type="application/force-download" href="{$media_path}">{lang_print id=4000095}</a>
        </div>
        {/if}
      </td>
      </tr>
      </table>
    </div>

I am not sure how to go about this.

The database table for this is:

CREATE TABLE IF NOT EXISTS `se_music` (
  `music_id` int(10) unsigned NOT NULL auto_increment,
  `music_user_id` int(10) unsigned NOT NULL default '0',
  `music_track_num` int(10) unsigned NOT NULL default '0',
  `music_date` int(11) NOT NULL default '0',
  `music_title` varchar(64) collate utf8_unicode_ci NOT NULL default '',
  `music_ext` varchar(8) collate utf8_unicode_ci NOT NULL default '',
  `music_filesize` bigint(20) unsigned NOT NULL default '0',
  `music_plays` int(10) NOT NULL,
  PRIMARY KEY  (`music_id`)

Somehow I need to track song plays, either using php... or most likely some AJAX. I am not sure so I hope someone has an idea.

Thanks in advance.

1
Contributor
1
Reply
2
Views
7 Years
Discussion Span
Last Post by WickidGRAFX
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.