Ultimate Now Playing Hack - WA3 plugin / data stored in database

It's here! A real "Now Playing" hack. A WA3 plugin feeds data to the database. (Note: I did not write the plugin - credit for that goes to Brandon Martus of pubarso.com). Once loading a simple script, the plugin runs silently in the background without intervention.

Features:
+"Now Playing" information (at time of post, not currently) is shown next to posts.
+Currently Playing / All History / My History pages
+Dynamic downloading - user needn't edit any files once downloaded.
+Only last two weeks of songs are stored so database usage doesn't get too high.
+Password protected updating

Current Version: 1.0.1

Download: click here

Enjoy! Screenshots will follow.

[Jitway]

Ok everytime I try to post a newthread I get this error and it has to do with this hack that I installed. Posting a reply to thread is no problem but starting a newthread I get the same erro everytime........

Database error in vBulletin 2.2.8:

Invalid SQL: SELECT * FROM nowplaying WHERE userid = '1' AND dateline > ORDER BY dateline DESC LIMIT 1
mysql error: You have an error in your SQL syntax near 'ORDER BY dateline DESC LIMIT 1' at line 1

mysql error number: 1064

Date: Saturday 23rd of November 2002 11:15:55 PM
Script: http://www.jitway.com/forums/forums/newthread.php
Referer: http://www.jitway.com/forums/newthre...read&forumid=5
......and this would be that line of code in the newthread.php....

$npdateline=time()-600;
$currentsong=$DB_site->query_first("SELECT * FROM nowplaying WHERE userid = '".$bbuserinfo[userid]."' AND dateline > $npdateline ORDER BY dateline DESC LIMIT 1");

Any suggestions?

[SlaPPiE]

I recieved this error when I tried to view "All History":

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 1565905 bytes) in /home/btrend/www/forums/admin/functions.php on line 591

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 40 bytes) in Unknown on line 0

Forgive me if this has been solved somewhere earlier in this thread.

I'm not exactly sure how to clear out that list, and then lessen the length of days it keeps the history there, so if anyone could help me out, it'd be appreciated. Thanks in advance.

[GoTTi]

need some support here, i want this hack to work

[Jitway]

Same here how about some support for post #51

[Oblivion Knight]

I'm recieving the same error as Da_GoTTi.
It's really weird, I've tried re-downloading the zip several times and i get the same error..

Any ideas..? This sounds like a really good hack..

[RudeDog]

Whatever happened to working on the winamp 2 support?

If a board is still needed for test, I'll help....

[Issy_X]

Ok, I don't have a clue about what I'm doing wrong. I applied the hack but it's not working. The only thing that works is that the nowplaying stuff is showing up on the profile page. The postbit is not working and I also can't access the howto and stats pages. What do I have to do?

[Keta]

Originally posted by Da_GoTTi
When I follow the instructions on where to unzip the file to...then I goto the winamp preferences and install the skin or whatever...

the .xml file

I get this error after I click Open on the .xml file (file attached)

What is this and how do i get it fixed?

yup i get the same thing

[TheComputerGuy]

I get this error....

PHP Code:

<!-- Database error in vBulletin 2.2.9:

Invalid SQL: INSERT INTO post (postid,threadid,title,username,userid,dateline,attachmentid,pagetext,allowsmilie,showsignature,ipaddress,iconid,visible) VALUES (NULL,'271','','TheComputerGuy','1','1040530296','0','I agree

Who are you?','1','1','67.30.234.131','0','1,'','')
mysql error: You have an error in your SQL syntax near ''1,'','')' at line 1

mysql error number: 1064

Date: Saturday 21st of December 2002 08:11:36 PM
Script: [url]http://www.runaked.com/forums/forums/newreply.php[/url]
Referer: [url]http://www.runaked.com/forums/showthread.php?postid=3078#post3078[/url]
 --> 


[Xelation]

anyone get this to work? not working for me...