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:
Quote:
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:
Quote:
<!--
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
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
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?
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?
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.
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.
[HTL] Now Playing Hack v.1.3 Details »»
About Developer
Visit Web Site
No support by the author.
09-20-2004, 12:08 AM
