Custom php/mysql script wanted
Posted: Thu Aug 24, 2006 5:32 am
feyd | Please use
I do appreciate that something like this would cost a small fortune, but I dont have a small fortune.
The phpbb2 Intergration would be fantastic, but is not essential.
any help would be greatly appreciated.
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]
Hi Guys
I need a custom php/mysql script, I am willing to pay a small amount say around £100 for the right script.
I have designed the look I need in a web page, so if you view the following code in a web browser, you will get the idea.
[syntax="html"]
<style type="text/css">
<!--
.style1 {
color: #33CCFF;
font-weight: bold;
}
.style3 {color: #FF9900; font-weight: bold; }
.style7 {color: #0033FF; font-weight: bold; }
-->
</style>
<table width="100%" border="1">
<tr>
<td><div align="center" class="style1">Search # A B C D E F G H I J K L M N O P Q R S T U V W X Y Z </div></td>
</tr>
</table>
<table width="100%" border="1">
<tr>
<td width="23%"><div align="center" class="style3">Artist</div></td>
<td width="10%"><div align="center" class="style3"># Albums </div></td>
<td width="10%"><div align="center" class="style3"># Tracks </div></td>
<td><div align="center" class="style3">Comments</div></td>
</tr>
<tr>
<td><span class="style3">[D]</span> <span class="style1">Elvis Presley</span> </td>
<td><div align="center">30</div></td>
<td><div align="center">600</div></td>
<td><div align="center" class="style3">blah blah blah blah </div></td>
</tr>
<tr>
<td><span class="style3">[D]</span> <span class="style1">Abba</span></td>
<td><div align="center">12</div></td>
<td><div align="center">130</div></td>
<td><div align="center" class="style3">blah blah blah blah </div></td>
</tr>
</table>
<p>Intergrate with phpbb2</p>
<p>add admin panel in phpbb2 CPC, to select drives to scan folders from (i.e folders from the root dir of each specified drive.)</p>
<p>these folders will then appear as in the table above (the default list will be folders beginning with a number) this can be altered from the ABCD SEARCH Links. the [D] will be replaced with a folder or other icon. the artist/folder name will become a link for the files inside that folder, which when clicked will display as in the table below. the #Albums cell will display the number of folders inside the artists folder and the #Tracks will display the total number of mp3 files in all dir/folders inside the main folder.</p>
<table width="100%" border="1">
<tr>
<td colspan="4"><div align="center" class="style1">Elvis Presley </div></td>
</tr>
<tr>
<td width="44%"><div align="center" class="style1">Album Name </div></td>
<td width="19%"><div align="center" class="style1"># CDs</div></td>
<td width="18%"><div align="center" class="style1"># Tracks</div></td>
<td width="19%"><div align="center" class="style1">Download</div></td>
</tr>
<tr>
<td><span class="style3">G.I. Blues </span></td>
<td><div align="center">1</div></td>
<td><div align="center">13</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><span class="style3">Roustabout</span></td>
<td><div align="center">1</div></td>
<td><div align="center">12</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
</table>
<p>The album names will be links to the specified folder. # cds will display the number of folders inside this folder (i.e. if GI Blues is a double cd, the GI Blues folder will have 2 folders inside named CD1 & CD2 etc. the download links will zip the selected folder and download it. the download links will only be visible to phpbb2 forum members depending on their access level which will be set from the admin panel in the phpbb2 CPC. On clicking the Album name links, the results will display as in the table below.</p>
<table width="100%" border="1">
<tr>
<td colspan="7"><div align="center" class="style1">Elvis Presley - G.I. Blues </div></td>
</tr>
<tr>
<td width="9%"><div align="center" class="style1">Track # </div></td>
<td width="38%"><div align="center" class="style1">Title</div></td>
<td width="9%"><div align="center" class="style1">Bitrate</div></td>
<td width="11%"><div align="center" class="style1">Sample </div></td>
<td width="11%"><div align="center" class="style1">Length</div></td>
<td width="9%"><div align="center" class="style1">Size</div></td>
<td width="13%"><div align="center" class="style1">Download</div></td>
</tr>
<tr>
<td><div align="center">1</div></td>
<td>Frankfurt Special </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">2</div></td>
<td>Rainbow</td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">3</div></td>
<td>G.I. Blues </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
</table>
<p>All information will be collected from the mp3 tags. the download links will zip and download the selected file and will only be available to phpbb2 forum members with the access level set in the phpbb2 admin panel CPC. If there is more than 1 cd for the selected album, it should display as in the table below. </p>
<table width="100%" border="1">
<tr>
<td><div align="center" class="style7">CD1</div></td>
<td colspan="6"><div align="center"><span class="style1">Elvis Presley - G.I. Blues </span></div></td>
</tr>
<tr>
<td width="9%"><div align="center" class="style1">Track # </div></td>
<td width="38%"><div align="center" class="style1">Title</div></td>
<td width="9%"><div align="center" class="style1">Bitrate</div></td>
<td width="11%"><div align="center" class="style1">Sample </div></td>
<td width="11%"><div align="center" class="style1">Length</div></td>
<td width="9%"><div align="center" class="style1">Size</div></td>
<td width="13%"><div align="center" class="style1">Download</div></td>
</tr>
<tr>
<td><div align="center">1</div></td>
<td>Frankfurt Special </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">2</div></td>
<td>Rainbow</td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">3</div></td>
<td>G.I. Blues </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center"><span class="style7">CD2</span></div></td>
<td colspan="6"><div align="center"><span class="style1">Elvis Presley - G.I. Blues </span></div></td>
</tr>
<tr>
<td><div align="center" class="style1">Track # </div></td>
<td><div align="center" class="style1">Title</div></td>
<td><div align="center" class="style1">Bitrate</div></td>
<td><div align="center" class="style1">Sample </div></td>
<td><div align="center" class="style1">Length</div></td>
<td><div align="center" class="style1">Size</div></td>
<td><div align="center" class="style1">Download</div></td>
</tr>
<tr>
<td><div align="center">1</div></td>
<td>Frankfurt Special </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">2</div></td>
<td>Rainbow</td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
<tr>
<td><div align="center">3</div></td>
<td>G.I. Blues </td>
<td><div align="center">128kbs</div></td>
<td><div align="center">44KHz</div></td>
<td><div align="center">00:03:13</div></td>
<td><div align="center">4.4mb</div></td>
<td><div align="center">icon/pic</div></td>
</tr>
</table>
<p>After selecting the drives/folders to scan from the phpbb2 admin CPC, the information should be placed in a msql database, the information for the dynamic pages will then come from the database rather than from scanning drives/folders everytime. the database should be updated whenever drives are removed/added or updated from the phpbb2 admin |CPC. All phpbb2 session data must be retained while viewing these pages from phpbb2. the script should take into account that there maybe many more than 2 cds per album as in box sets etc. </p>
<p>The file structure will be as follows</p>
<table width="100%" border="1">
<tr>
<td width="15%">[Drive] Name </td>
<td width="21%"> </td>
<td width="14%"> </td>
<td width="28%"> </td>
</tr>
<tr>
<td> </td>
<td>[Folder] Artist Name </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>[Pic] front.jpg </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>[Pic] back.jpg </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>[Pic] insert.jpg </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>[Folder] CD1 </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Pic] CD1.jpg </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 1-Track Name </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 2-Track Name </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 3-Track Name </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td>[Folder] CD2</td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Pic] CD2.jpg </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 1-Track Name </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 2-Track Name </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>[Track] 3-Track Name </td>
</tr>
</table>
The phpbb2 Intergration would be fantastic, but is not essential.
any help would be greatly appreciated.
feyd | Please use[/syntax]
Code: Select all
,Code: Select all
and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color]