Add-On Releases - Name That Tune

************************************************** ****
What is Name That Tune
************************************************** ****

Well name that tune is a sinple game for your members to play.
You view a tune you want to play and click the play button,
listen to the tune and then see if you know what the song is.
If you get the song right you win the jackpot, but if you get
it wrong the cost of play is added to the jackpot.

This is a simple but fun add-on to your vbulletin site.


************************************************** ****

NO CASH NAME THAT TUNE SYSTEM

I have added a zip file that does not use a cash system.
It has a multiplyer and a timer for playing.
You set the timer for the game and set how much will be won by
some thing like this

Multiplyer*timeleft ( 25*15 )
this would be the users score.

If they answer wrong it will add what is set in the settings for that game like

Multiplyer+If Wrong ( 25+10)

So in afect if a player gets it wrong it makes the multiplyer go up, and makes it better for the player who gets it right as the multiplyer will be higher.

All support for this script will be at

www.vb-hacks.com

As i dont have the time to keep looking here.

NEW NAME THAT TUNE INFO
There is a new download for the name that tune.

New install

INSTALLING
**********

Unzip the zip file mmnamett.zip
Upload the content of the UPLOAD folder to your forums root.
Loggin to your admincp
and goto Manage Products
click on [Add/Import Product]
and browse for the product-mmnamethattune.xml file
Allow Overwrite ( NO )
click import

You have completed the install.

UPGRADING

If you are using the Cash Version upgrading is simple

Unzip the zip file mmnamett.zip
Upload the content of the UPLOAD folder to your forums root.
Loggin to your admincp
and goto Manage Products
click on [Add/Import Product]
and browse for the product-mmnamethattune.xml file
Allow Overwrite ( YES )
click import

UPGRADING NO CASH SYSTEM

To upgrade the no cash system you will have to uninstall the version you have now,
and do a new install of this script.


SETTING UP
**********
Now that you have installed your new name that tune script,
you will have to update the settings to suit your needs.

Active the name that tune for your members to be able to view the script.
Choose the cach system you are going to use.

Settings finished.
************************************************** ****

USERGROUPS
***********
Now that you have updated your settings for name that tune,
you will need to set the settings for each usergroup.
click on Usergroup Manager
edit all usergroups and find
Name That Tune Permissions
and set who can view and who can play the games.

Usergroup settings finished.
************************************************** ****

CHANGES MADE

The changes made from the old version to this one is

Cash version and no cash version in one not two different zip files there is only one that does both mods.

If you use the no cash version if a players score has been beaten it will PM the person that there score has been beaten.

VERSION 1.2

Added a import system for importing more mp3's
This is a upgrade

VERSION 1.3

In this version i have stopped members from sending in more scores to one tune as this version will check to see if they have a score already and will show them a error message if they have.

VERSION 1.5

In this version i have added an inline modcp where you will be able to let sertain members mod your past winners and mod the tunes.
Also in the admincp for inporting mp3s it automaticly creates the categories for you.
If you try to put in the same category it will install the mp3s to that cat and will not make a new category.

VERSION 1.6

Hi all

Version 1.6 is now released.
Updates included

Display order of categories in admincp.
Added hit counter to tunes.
Added modcp upload tunes,
This is a java upload system when you have choosen your mp3 to upload the upload will begin,
Letting you put in the info for the rest of the tune like tune title description category cost jackpot and the count down timer.

Then you click on save file and it will add your tune to the database.


PLEASE MARK AS INSTALLED CLICK HERE

CLICK TO Nominate for MOTM

If you find any problems please post here i will lookin from time to time

MP3 Packs

Intro's pack made by bazzup
Click here to view post

Tune Pack From Alibass
Click to download Pack
Click to download country western Pack

Tune pack from xxxsaint
Click here to download pack

Christmas Pack Added

MP3 Players

Black Ipod mp3 players click here

[TTG]

Originally Posted by micheal332001

New Mp3 Player for name that tune

Let me know what you think before i carry on with the others.

Looks great .. I'll certainly use that one :up:

Anyone got any more tunes to share ?

[micheal332001]

Originally Posted by TTG

Looks great .. I'll certainly use that one :up:

Anyone got any more tunes to share ?

The new version will be ready soon with its new mp3 player.
I will also be adding more tune packs for you soon.

The new version will be version 1.5 as there is a few template changes and there is a new inline mod system for in the main script,
saving you going to admincp all the time to import or update things.

[Alibass]

Really looking forward to 1.5 release

[blue6995]

I have installed 1.4 and tested it; everything appears to be working for me. However, I have just had a user play and it generated the following error:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO vb3_mmnamett_prizes_won (id, mmnamettid, userid, answer, nttname, won) values ('','4','543', 'left outside alone', 'she's hot', '250');

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's hot', '250')' at line 1 Error Number : 1064
Date : Saturday, December 1st 2007 @ 06:54:24 PM
Script : http://www.rwf-forum.co.uk/vBulletin...d=4&timeover=0
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vb_database

[micheal332001]

Originally Posted by blue6995

I have installed 1.4 and tested it; everything appears to be working for me. However, I have just had a user play and it generated the following error:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO vb3_mmnamett_prizes_won (id, mmnamettid, userid, answer, nttname, won) values ('','4','543', 'left outside alone', 'she's hot', '250');

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's hot', '250')' at line 1 Error Number : 1064
Date : Saturday, December 1st 2007 @ 06:54:24 PM
Script : http://www.rwf-forum.co.uk/vBulletin...d=4&timeover=0
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vb_database

Hi there

I see what the problem is and will sort out a quick fix for this tomorrow.
As you see in the sql error

PHP Code:

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's hot', '250')' at line 1 Error Number : 1064 


This is why you see the name of the tune you have put in

PHP Code:

she's hot 


It has a ' in it this is why you are getting this error,
I will make the fix for this tomorrow and send out a update E-mail letting you all know when i have updated the zip file here.

Or you could edit the tune title and take out the ' for now so that it will work till i bring out version 1.5 witch will have all the fixes and mew MP3 players.

[micheal332001]

Originally Posted by blue6995

I have installed 1.4 and tested it; everything appears to be working for me. However, I have just had a user play and it generated the following error:

Database error in vBulletin 3.6.0:

Invalid SQL:
INSERT INTO vb3_mmnamett_prizes_won (id, mmnamettid, userid, answer, nttname, won) values ('','4','543', 'left outside alone', 'she's hot', '250');

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 's hot', '250')' at line 1 Error Number : 1064
Date : Saturday, December 1st 2007 @ 06:54:24 PM
Script : http://www.rwf-forum.co.uk/vBulletin...d=4&timeover=0
Referrer :
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vb_database

Hi there

This is now fixed in version 1.5 that will be ready for download here within the next day or 2 with the new MP3 players.
I will also be making different skined MP3 players for different skins that would be installed on some sites.

This new MP3 player is blue the next one will be black and so on.

[micheal332001]

Hi all

Just a little progress report for you.

I am about 50% to 60% done on the modcp for editing/deleting past winners and edit/delete of tunes.
Hope to have this finished tomorrow ready to give you the new version 1.5 with the new MP3 players as well as the inline modcp.

here are a few screen shots

[Alibass]

Thanks Mike for the progress report. Cant wait for the new release, from the looks of pics 1.5 has a lot of goodies.

[Alibass]

Here are 8 tunes with import .xml files if anyone needs tunes.

Sorry I was unable to upload file here as it is slightly over the 2mb limit, but you can download from the link I have given in the code box.

http://imgbolt.com/files/51/Zip%20Vids/More%20Tunes.zip

[micheal332001]

Originally Posted by Alibass

Here are 8 tunes with import .xml files if anyone needs tunes.

Sorry I was unable to upload file here as it is slightly over the 2mb limit, but you can download from the link I have given in the code box.

http://imgbolt.com/files/51/Zip%20Vids/More%20Tunes.zip

Thanks for that m8 i have added it to the main description at top so everyone will find it easyly.
I have been working on more tune packs as well and will be released when i finish version 1.5.

Hope to have 3 more tune packs with 20 tunes in each and im also hoping to change they way we import the tunes.
At the moment you have to make a categorie before you import but this change will make the categorie for you when you import and will also see if that categorie is there and will not remake that categorie.

At the start of the import .xml file we have this

<words q_name="Southern Rock Bands"><![CDATA[]]></words>

This will be used for making the categories.