vb.org Archive
Page 12 of 13 « First 21011 12 13
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [HTL] Now Playing Hack v.1.3 (https://vborg.vbsupport.ru/showthread.php?t=59538)

Brahm 09-20-2004 12:08 AM
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 &lt;&gt; 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 10-17-2004 04:57 PM
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?

Dan 10-17-2004 04:59 PM
did you remove it from the quick reply template and the new post and new thread ones?

djjeffa 10-19-2004 02:00 AM
Quote:
Originally Posted by Dan
did you remove it from the quick reply template and the new post and new thread ones?
did now thank you

mixx941 10-19-2004 11:27 PM
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 12-27-2004 11:54 AM
Quote:
Originally Posted by nando415
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 01-03-2005 10:54 AM
Or you can just change the maxchars attribute of the input field and not have to screw around with your DB. :)

Lionel 04-14-2005 07:03 AM
Quote:
Originally Posted by Brad.loo
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.

darkon 11-22-2005 05:54 PM
is there any solution for vb 3.5 ??

Ky Kiske 11-22-2005 06:01 PM
That my friend is a very good question.


All times are GMT. The time now is 09:40 PM.
Page 12 of 13 « First 21011 12 13
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01900 seconds
  • Memory Usage 1,745KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete