View Full Version : [HTL] Now Playing Hack v.1.3
Now Playing Hack
Version: 1.5
vB-version: 3.0.1
Developer: Dan
Install difficulty: Easy
File edits: 3
Template edits: 5
Description of the Hack:
This hack lets your users specify what they are listening to at the time of posting.
HACK INSTALLATION DETAILS:
Files modified for this Hack:
includes/functions_newpost.php
newthread.php
newreply.php
Templates modified for this Hack:
postbit_legacy
postbit
newreply
newthread
showthread_quickreply
Changes:
Added a new HTML install file. (Not automatic)
Updated to 3.0.1
Changed postbit look
Moved to HTL
Fixed double step in installer
Fixed the not allow html/censored words in the now playing field
Added Quick Reply functionality
ALWAYS remember to backup before installing anything.
Comments always welcome.
Add-Ons:
Last 10 songs on Forumhome (http://www.vbulletin.org/forum/showpost.php?p=455585&postcount=17) by yabba (http://www.vbulletin.org/forum/member.php?u=20728)
SCREENSHOT BELOW:
MindTrix
03 Jan 2004, 03:16
Ohh no not the now playing hack :)
Thanks mate this will come in handy on my forum, Thank you
Chris Gwynne
03 Jan 2004, 03:18
Great job Dan, I'll be using this when the time comes round! :D
Koutaru
03 Jan 2004, 03:49
Pfft, and you didn't know what to hack? This is great :) will look into tonight
Technically I already hacked this. I just upgraded it to vB3.
Koutaru
03 Jan 2004, 03:58
I figured that would be your first vb3 hack here (seeing it at vbulletin.nl)
Would have been nice to have been told about this, since I created the original one ;)
It would be cool if you hack could read my:
1) winamp playlist
2) Windows media player playlist
and copy info from them - maybe you should ask some help at the winamp board?
Sorry Man, I thought you had disappeared or something and I had already hacked it in for vB3 a couple months ago. If you want credit or something I can give it to you. But I really didn't know you even created the original one.
flamingpeach
03 Jan 2004, 19:46
This is a great hack, and I can't wait to install it.
The only thing is, I'm new to this, and at the risk of looking stupid, what do you mean when you say
"-----------
|Run Query|
-----------
ALTER TABLE post ADD nowplaying VARCHAR(40) NOT NULL"
:ermm:
I'm not sure where to do this, and its probably very simple and obvious, but like I said, I'm new. :disappointed:
Thanks
MindTrix
03 Jan 2004, 19:49
Everyone starts somewhere mate ;)
A query is basically a piece of code that needs to be run on your MYSQL database, Usualy in PHPMYADMIN that your host should have linked you too, or you will find in your hosts Control Panel.
In phpMyAdmin select the database then click on query and just past the code from above and click submit query. If you don't have access to phpmyadmin or something similar just email your webhosts asking them to do it for you :)
flamingpeach
03 Jan 2004, 19:54
Thanks guys, I appreciate it :D
Everyone starts somewhere mate ;)
A query is basically a piece of code that needs to be run on your MYSQL database, Usualy in PHPMYADMIN that your host should have linked you too, or you will find in your hosts Control Panel.
thanks mindtrix for reply i was mid-typing when I recieved a message saying you replied with the answer.
Thanks everyone so far that has installed this hack!
MindTrix
03 Jan 2004, 19:57
I know the feeling Dan, your half way writting a response then someoen else posts it :)
I may actually use this mod. It'll be easier than having it done via Profile Field.
A little Add-on for Dans Now Playing Hack.
This little bit of Code display the last 10 Songs at your Forumhome.
A little Add-on for Dans Now Playing Hack.
This little bit of Code display the last 10 Songs at your Forumhome.
thanks for the add-on yabba I'll add a link to the first post.
SiXXGuNNZ
04 Jan 2004, 04:45
here is the way I modded the postbits, regular and legacy, this puts the nowplaying box under the attachments in a box like the attachments use
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
attached are examples :)
thanks for doing that I just put it in a place i could easily find a spot to put it. If you wouldn't mind I would like to add this to the install file.
SiXXGuNNZ
04 Jan 2004, 06:05
thanks for doing that I just put it in a place i could easily find a spot to put it. If you wouldn't mind I would like to add this to the install file.
go for it, my members loved this for vb2, so I am grateful you did this for vb3, if you need the rockin' out mullet smilie, I will attach it just in case :)
flamingpeach
04 Jan 2004, 08:56
I installed this and my members are using and loving it. The only thing they have mentioned is that sometimes they forget to fill in the form, and would like to go back and edit thier song in or correct their spelling mistakes in the song title etc.
Would there be a way to modify a template or one of the php pages in order to show the "now playing" field after a member clicks his or her edit button?
Just curious :o
It is not hard to add that to the modification but I dont have time to document the changes atm, ill post them later on today when I find the time.
NuclioN
04 Jan 2004, 11:25
It's nice Sixxgunzz but the fieldset/legend lines are always white and on a dark style it looks terrible. Is there a way to color the lines in these fieldset blocks?
MindTrix
04 Jan 2004, 14:05
Hey Dan, you might want to add in the instructions when editin the postbit template, to edit the postbit_legacy one aswell ;)
I will when i get home... not home at this current time... it is simple to do though.
SiXXGuNNZ
04 Jan 2004, 21:49
It's nice Sixxgunzz but the fieldset/legend lines are always white and on a dark style it looks terrible. Is there a way to color the lines in these fieldset blocks?
I was looking thru the templates and couldn't find the info that tells vb what the legend is supposed to look like, all we have to do is find where that is and then it should be easy as pie.
SiXXGuNNZ
04 Jan 2004, 21:58
it is easy, in the style's css
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
NuclioN
04 Jan 2004, 22:00
in the extra css box i've added this as a replacement for the default fieldset:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
were the colorcode can be altered :)
proxyMX
05 Jan 2004, 03:10
hey got a problem
I want to
1. Limit the characters that can be input in this field because it can squish the postbit up.
2. When posting with a new thread, i get one of the de-notations as used in the code as in <--- Now Playing then it goes to the box
3. I want to write above the input "Song now playing: (Not Required)
4. I want to be able to have this input box BELLOW the post where you can add attachments etc.
4. I want to be able to have this input box BELLOW the post where you can add attachments etc.
4. I did this on my board.
instead of adding the <!-- nowplaying field --> section after the <!-- /subject field --> as instructed in the orignal instructions, replace it after this instead:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
what can i add to the code to not allow html?
Ky Kiske
05 Jan 2004, 08:21
A sweet addon would be to have the last time nowplaying in your Profile.
proxyMX
05 Jan 2004, 23:06
4. I did this on my board.
instead of adding the <!-- nowplaying field --> section after the <!-- /subject field --> as instructed in the orignal instructions, replace it after this instead:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
thanks, that helped! Its now bellow the message and i fixed the html now all i need is character limitations
thanks, that helped! Its now bellow the message and i fixed the html now all i need is character limitations
Anyone works on Now Playing in Quick Reply Box ?
Greets yabba
Sorry... at this time my computer is down and I'm unable to help support my hack currently. Hopefully I'll be up and running again in the next few weeks. I am sorry to anyone this may trouble.
Anyone works on Now Playing in Quick Reply Box ?
Greets yabba
Yeah, i also got it in the quick reply box, although it doesn't look very pretty.
i put the same <!--Now Playing --> block of code in the "showthread_quickreply" template
after this:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
I dunno if that was the best place to put it, but i have it centered under the text input field, and it works, so it's good for me :)
Yeah, i also got it in the quick reply box, although it doesn't look very pretty.
i put the same <!--Now Playing --> block of code in the "showthread_quickreply" template
after this:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
I dunno if that was the best place to put it, but i have it centered under the text input field, and it works, so it's good for me :)
Many thanks .
It works perfect :-)
Greets from germany
yabba
restless
08 Jan 2004, 23:25
It would be cool if you hack could read my:
1) winamp playlist
2) Windows media player playlist
and copy info from them - maybe you should ask some help at the winamp board?that would be AWESOME.
Zachery
08 Jan 2004, 23:28
that would be AWESOME.
almost impossible, not with out a plugin to ie
Sorry Man, I thought you had disappeared or something and I had already hacked it in for vB3 a couple months ago. If you want credit or something I can give it to you. But I really didn't know you even created the original one.
I was only messing about - it's a simple hack. And yours is probably better than my slap-dash vB3 effort anyway LOL
Good on yer matey!
... very nice hack, thanks for posting!
One question:
how do I get the text inserted to my new field (e.g. nowplaying) into the searchindex? If I'm now searching for that inputs, it's not working. Would be great to get a help;
regards,
adusei
amseven
20 Jan 2004, 08:48
is this hack compatible with RC2?
jepp. it works perfectly with RC 2
Ky Kiske
20 Jan 2004, 16:31
jepp. it works perfectly with RC 2Mine isn't working...I can't get it to post the Test
EDITTED IN:
My custom code had some missing variables.
amseven
20 Jan 2004, 20:47
thanks for the reply. Im somewhat of a newbie when it comes to adding hacks so I have just one question, how would I go about doing this..
-----------
|Run Query|
-----------
ALTER TABLE post ADD nowplaying VARCHAR(40) NOT NULL
any help would be much appreciated.
[QUOTE]
Just run SQL-Query in your admincp and add
ALTER TABLE post ADD nowplaying VARCHAR(40) NOT NULL
in the editorfield.
Then follow the rest of the install-steps.
Regards,
adusei
amseven
21 Jan 2004, 21:35
excellent, thanks for the reply.
amseven
22 Jan 2004, 02:35
installed a running great on RC3. Great hack, the work is very appreciated.
Updated the hack to version 1.2
KuraFire
26 Jan 2004, 00:43
Updated the hack to version 1.2
Yay, a HTL hack ^_^
Zachery
26 Jan 2004, 02:55
Yay, a HTL hack ^_^Dan you have one too many steps in the install FYI you tell us to do the same step twice in a sorta
for the template mods you ask us to change somthing twice
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
you should fix that :)
should also be ADD UNDER not REPLACE WITH
also for the postbit templates your missing the end of an if condition
Dan you have one too many steps in the install FYI you tell us to do the same step twice in a sorta
for the template mods you ask us to change somthing twice
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
you should fix that :)
should also be ADD UNDER not REPLACE WITH
also for the postbit templates your missing the end of an if condition
opps.... I'll go fix that now
Zachery
26 Jan 2004, 12:25
opps.... I'll go fix that now
just a suggest might want to tie it into the quick reply as well, i didnt find it that hard my self
wrongful
26 Jan 2004, 19:16
what can i add to the code to not allow html?Yes could somebody look into this as it seems that it could be a big security risk
eXtremeTim
26 Jan 2004, 19:42
okay heres the fix i just did for my hacks and this one. This fix will also apply you swear filtering to the now playing text.
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Add below:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
TheComputerGuy
28 Jan 2004, 14:35
okay heres the fix i just did for my hacks and this one. This fix will also apply you swear filtering to the now playing text.
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Add below:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Installed!
Much appreciated.
eXtremeTim
28 Jan 2004, 15:20
No problem. Dan you might want to build that into your release.
TheComputerGuy
28 Jan 2004, 15:59
just a suggest might want to tie it into the quick reply as well, i didnt find it that hard my self
Is there anyway to connect it to the quick reply...most my users love the quick reply.
Is there anyway to connect it to the quick reply...most my users love the quick reply.
I'll add that in a few and make it version 1.3
nhochochack
29 Jan 2004, 01:51
what is HTL file .. how do i use this file in this hack ... because in intruction file i don't see step for use it ...PLZ help me ..
Link14716
29 Jan 2004, 02:25
http://www.vbulletin.org/forum/showthread.php?t=60735
Dan
nice work
thanks
alwafi :tired:
... very nice hack, thanks for posting!
One question:
how do I get the text inserted to my new field (e.g. nowplaying) into the searchindex? If I'm now searching for that inputs, it's not working. Would be great to get a help;
Ok, again:
I changed the nice hack for my board. The input will now be added to the title of the thread. But two things I can`t fix:
1.) The input only appears on showthread.php, not at forumdsplay.php, where I like to get it too!
2.) The input isn't accessable for the search. How is that to be changed?
Any ideas?
Best regards,
adusei
Ok, again:
I changed the nice hack for my board. The input will now be added to the title of the thread. But two things I can`t fix:
1.) The input only appears on showthread.php, not at forumdsplay.php, where I like to get it too!
2.) The input isn't accessable for the search. How is that to be changed?
Any ideas?
Best regards,
adusei
Why would you want to show it on the forumdisplay.php page?
Also what is the reason for searching this? I can do both of them but it will take time. I'd just like to know the reason why you would need these features as I don't really see them as much of a use.
Hi Dan,
thx for your reply!
Of course, it sems to be somehow senseless, but I ty to explain.
I need more than the one input in the editor, because I want (somehow) "force" the user to give special information. And for those who are not so used to www, PC & Co. it is more easy, when there appears this input-fields.
The board - it's not ready yet - will be for cars and spareparts; so it will be fine, if I get the users to input:
e.g. i.)brand of car / ii.)type / iii.)year /iv.) price ... and so on--------> to let it appear in the threads SUBJECT or TITLE ROW above the message.
The "Nowplayig-Hack" helped me to change my db, to insert the additional fields etc. I must say that I'm an absolute beginner and that this hack took me a lot of steps forward - although I don't need, what the hack is for originally! So I appreciate the hack and the work the author did!!!
Everything is working with it - but only my "connected" thread-title appears, when showthread.php is opened - I want it to be seen also, when forumdisplay.php is opened.
And being searchable should this "puzzled" title too - I gess now it is clear why.
I hope now it is understandable, what I mean.
Maybe through this it can be possible to add to the "Nowplaying-Hack" something like a "Boost-Your-editor-Hack"...?
Thanks for your attention,
best regards from
adusei
btw: sorry for my poor English...! :disappointed:
Just a note to everyone this does work on RC4
Fi_InCogNiTo
04 Mar 2004, 23:24
I changed a lil code in the postbit to make the posters name appear. I'll attach a screen shot.
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Replace with:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Nuthin big. I just think it looks nice =D
Great hack, my users will love it.
when I post a reply it doesnt show...
Oopsie forgot I was using the legacy postbit.
Is there anyway to show the top now playing poster on forumhome?
when I post a reply it doesnt show...
Oopsie forgot I was using the legacy postbit.
Is there anyway to show the top now playing poster on forumhome?Um... I don't know what you mean... but yabba did make a mod Last 10 songs on Forumhome (http://www.vbulletin.org/forum/showpost.php?p=455585&postcount=17) by yabba (http://www.vbulletin.org/forum/member.php?u=20728)
What I mean is to show the user that has posted the most songs with the now playing function.
example: if john makes 10 posts with now playing and mike make 15 with now playing Mike is the top song poster.
Hmm, thats a good Idea, but not released now.
A script must count the nowplaying field and get an output of the most counted User.
Another and I thing better feature where a chart script for the "Most played Songs" I think that was a truley fine feature too.
Greets from a snowy germany
Yabba
That would be very cool. Like a [insert forum name] Top 50 Hitlist
How come my users can use html in their now playing thing? I was able to post an image and other html good in the now playing thing. It actually worked :S
SlackerAPM
24 Mar 2004, 15:00
I have a quick question. I had this hack installed before it went to htl, when it was first released so my nowplaying table already exitsts. Upon upgrading vb I installed the htl and now want to use this hack via the htl, however, it won't get past step 1, running the query, as the table already exists. What should I do to skip that step?
Many thanks.
Nice hack. Might come in useful, but yeah, I'd like to see it read:
-Winamp playlists
-Windows MEdia Playlists
-iTunes playlists
Not sure how to read all those (Are they in plaintext and what are they called?). Of course if I knew that info, I could add that functionality myself. Ah, shoot...lemme go look. :D
Nice hack. Might come in useful, but yeah, I'd like to see it read:
-Winamp playlists
-Windows MEdia Playlists
-iTunes playlists
Not sure how to read all those (Are they in plaintext and what are they called?). Of course if I knew that info, I could add that functionality myself. Ah, shoot...lemme go look. :D
I can't do that unless I knew how to code plug-ins for those, but i don't know how to code plug-ins for them so it is unlikely I'll ever do that.
msimplay
29 Apr 2004, 01:20
can u release a text file version :o
please of 1.3
can u release a text file version :o
please of 1.3
There is one check it out in the first post.
msimplay
29 Apr 2004, 01:47
thats not version 1.3 text file thats only htl
thats not version 1.3 text file thats only htl
Right now I have very tight time restraints. I shall try to make time to make one but you might have to wait till Sunday as I'm unlikely going to be on till then.
msimplay
29 Apr 2004, 10:09
Right now I have very tight time restraints. I shall try to make time to make one but you might have to wait till Sunday as I'm unlikely going to be on till then.
its ok take your time as i do appreciate your efforts :)
sunday will do nicely :D
msimplay
29 Apr 2004, 12:39
ok i converted the htl file into normal text instructions
hmm the htl file was a bit messed up since it asked me to do some file modifications twice for the same ones so was a bit annoying
anyway check the attachment for version 1.3 in normal text format
this should work fine as its a direct copy of the instructions plus i also have it working on my forums
msimplay
29 Apr 2004, 12:44
A little Add-on for Dans Now Playing Hack.
This little bit of Code display the last 10 Songs at your Forumhome. is there anyway we could make this a vbadvanced block ?
ok made the vbadvanced block myself based on yabba's last ten on forumhome
located [here] (http://www.vbulletin.org/forum/showpost.php?p=455585&postcount=17)
if anyone has any problems please post here
it has been tested on vb3 gold
LOD-squa
29 Apr 2004, 22:30
Hm, sorry if this has been asked before. But, how can I add the option on quick reply?
:: £²
msimplay
29 Apr 2004, 22:34
use this to add to quick reply
Find in Template showthread_quickreply
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Add BELOW that:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
LOD-squa
29 Apr 2004, 22:37
Thanks, i'll go test it now.
:: £²
msimplay
29 Apr 2004, 22:38
I have it, I just downloaded the .txt file and theres nothing regarding the quickreply.
:: £²
in this post the one i added
http://www.vbulletin.org/forum/showpost.php?p=506777&postcount=83
LOD-squa
29 Apr 2004, 22:42
Works perfectly, thank you very much.
:: £²
msimplay
29 Apr 2004, 22:44
Works perfectly, thank you very much.
:: £²
glad to be of help :)
msimplay
30 Apr 2004, 10:57
was wondering if i could get the now playing field on editpost ? @ Dan
Updated the hack and the first post.
Can someone change the title since it seems not to do it :(
/me pouts
msimplay
20 May 2004, 17:15
nice hack but on the step for the quick reply instead of using the code in the hack
i think it would be better to use
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
because it doesn't conflict with another hack
a java script one that i use for smilie popup
i think the tables disrupt some of the harmony of the quick reply
as when i use the tables version it also seems to check both the signature and the quote message checkbox's at once
nice hack but on the step for the quick reply instead of using the code in the hack
i think it would be better to use
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
because it doesn't conflict with another hack
a java script one that i use for smilie popup
i think the tables disrupt some of the harmony of the quick reply
as when i use the tables version it also seems to check both the signature and the quote message checkbox's at once
Weird I never had any trouble with that... I'll look at it and maybe change it later as I'm rather tired of looking at the code atm.
msimplay
20 May 2004, 17:36
well the main benefit is that its tableless so it should be faster
was wondering if i could get the now playing field on editpost ? @ Dan
i've managed to make it appear but if you edit a post it doesnt show up so i'm looking for whatever i have to add/ edit now:ninja:
i've managed to make it appear but if you edit a post it doesnt show up so i'm looking for whatever i have to add/ edit now:ninja:
I'll try to add it in the next few days I've been rather busy recently.
I'll try to add it in the next few days I've been rather busy recently.
Im confused, does this hack allow the playing of the song or just adds the text of what someone was listening to at the time they posted?
It would be nice if this played the song one was listening too.
Goober
Im confused, does this hack allow the playing of the song or just adds the text of what someone was listening to at the time they posted?
It would be nice if this played the song one was listening too.
Goober
That would require coding of the software they use and I'm unable to code that. It allows for the user to specify what they are listening to if they choose to say so.
That would require coding of the software they use and I'm unable to code that. It allows for the user to specify what they are listening to if they choose to say so.
Thanks Dan, I was confused over it because it sounded like a nice hack that allowed someone to actually hear a song being played.
I take it there is nothing like this out there then....
Goober
Thanks Dan, I was confused over it because it sounded like a nice hack that allowed someone to actually hear a song being played.
I take it there is nothing like this out there then....
Goober
No there isn't anything like that available that I know of.
msimplay
10 Jun 2004, 00:48
i've managed to make it appear but if you edit a post it doesnt show up so i'm looking for whatever i have to add/ edit now:ninja:
i realised theres no point to have it on editpost coz it could interfear with the now playing thats already in the post
and it makes sense that u actually have a now playing at the time u made the post
the only way it could work is if the now playing only appeared in editpost if the post didn't have a now playing already
PalmNut
16 Jun 2004, 01:23
Nice piece of work.
I'd also modify the quick reply HTML and JavaScript so that the input field is disabled if threading messages until a message is selected. Like so:
Edit the showthread_quickreply template by adding a new attribute to the text input field.
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Replace with:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Edit clientscript/vbulletin_quickreply.js as follows:
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Below that, add:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Find:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
Below that, add:
Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------
:( i hoped that this will be a hack ho will automaticly take your winamp song. There are some programs ho can do this.
:( i hoped that this will be a hack ho will automaticly take your winamp song. There are some programs ho can do this.
Programs? this isn't a program sorry its a php hack which has no actual tie in to the actual software of the user besides IE.
turbidblue
04 Jul 2004, 05:15
Wow! This hack is sooo cool! Thanks to all of you who help bring this one about!!
*trys to click install more than once! :)
nando415
23 Aug 2004, 00:19
How can i change the maximum limit of characters that can be entered???
Noiz Pollution
25 Aug 2004, 01:11
A little Add-on for Dans Now Playing Hack.
This little bit of Code display the last 10 Songs at your Forumhome.
Somebody on your board likes their EBM ;) [/approval]
Cheers,
Robert
y2krazy
30 Aug 2004, 03:12
/me clicks install!
Dan,
I am losing my mind! Heh. I have installed your hack and there were no problems during installation. I then installed the Yabba hack "last 10" and have got it working, unless you decide to log out and try to access the page. Then you get a message:There seems to have been a slight problem with the Ashkins' Family Web Site database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
The error message I get is this:
<!--
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT
post.postid, post.nowplaying AS post_nowplaying,
thread.threadid, thread.title AS thread_title,
user.userid, user.username
FROM
post AS post,
thread AS thread,
user AS user
LEFT JOIN deletionlog AS dlog_t ON (dlog_t.primaryid = thread.threadid AND dlog_t.type = 'thread')
LEFT JOIN deletionlog AS dlog_p ON (dlog_p.primaryid = post.postid AND dlog_p.type = 'post')
WHERE
thread.threadid = post.threadid AND
thread.forumid IN() AND
thread.visible = 1 AND
dlog_t.primaryid IS NULL AND
dlog_p.primaryid IS NULL AND
post.visible = 1 AND
thread.open <> 10 AND
user.userid = post.userid AND
post.nowplaying != ''
ORDER BY post.postid DESC LIMIT 10
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 ') AND
thread.visible = 1
mysql error number: 1064
Date: Sunday 19th of September 2004 07:52:28 PM
Script: http://ashkins.net/forum/index.php
Referer: http://www.ashkins.net/forum/login.php?do=logout
Username: Unregistered
IP Address: xx.xx.xx.xx
-->
My site uses "Vbindex" and I am using Vbulletin 3.03. It does this on my forum index page as well when I try it. I have been working on this for a while now and can't seem to get it to work. Whenever I insert the code into my index.php and save it, I am able to see the last ten displayed properly, but if I log out of the page, it will not let me back in. Web page is http://ashkins.net/forum
djjeffa
17 Oct 2004, 18:57
I suck with this stuff but I installed a new style that had this hack build it and now I cant remove it I removed it from the postbit and the postbit_legacy but it still shows the box in reply and quick reply ... anyadvice guys?
did you remove it from the quick reply template and the new post and new thread ones?
djjeffa
19 Oct 2004, 04:00
did you remove it from the quick reply template and the new post and new thread ones?
did now thank you
mixx941
20 Oct 2004, 01:27
This looks like a great hack, I'm eager to install it.
Although I'm wondering if it's just me, or does having the "Now Playing" look like somewhat like a quote or code tag look a little wierd? Is there an easy way to maybe put this somewhere else like on the left where the "Style: Dark Blue" thing is now on these forums, or maybe somewhere else more organized?
Thanks! :D
-Mark
SlackerAPM
27 Dec 2004, 13:54
How can i change the maximum limit of characters that can be entered???When you run the query to add the nowplaying bit to the post table change the VARCHAR(40) to VARCHAR(whatever limit you want). If you've already ran the query just make sure to alter the VARCHAR bit with phpmyadmin or something.
Well, that's what I did and I'm a moron. Should be easy for anyone else.
plattopus
03 Jan 2005, 12:54
Or you can just change the maxchars attribute of the input field and not have to screw around with your DB. :)
It is not hard to add that to the modification but I dont have time to document the changes atm, ill post them later on today when I find the time.
Has any one come up with a solution to edit? I am using this hack as thumb caption and I badly need the edit. I have to go in database to make a change.
is there any solution for vb 3.5 ??
Ky Kiske
22 Nov 2005, 20:01
That my friend is a very good question.
Tada http://www.vbulletin.org/forum/showthread.php?s=&threadid=82779
Tada http://www.vbulletin.org/forum/showthread.php?s=&threadid=82779
that´s not the same hack like yours :ermm:
it shows the last played songs from winamp. not a bad idea but not the kind of hack i need...
pete_brady
23 Feb 2006, 22:21
any chance of a 3.5.x version?
please?
daddygrim
26 Mar 2007, 13:02
3.6.5?????
http://www.vbulletin.org/forum/showthread.php?t=117934
vBulletin® v3.6.12, Copyright ©2000-2012, Jelsoft Enterprises Ltd.