vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBindex v3.0.0 RC5 (https://vborg.vbsupport.ru/showthread.php?t=59524)

JMPZ 04-08-2005 09:55 PM

I believe I found a bug in the uninstallation script


When I went to uninstall this hack, I got the following error message:

Code:

Database error in vBulletin 3.0.7:

Invalid SQL:
                SELECT phrasetypeid
                FROM phrasetype
                WHERE fieldname IN('vbindex', 'vbindex_cp')
       
mysql error: Table 'forum.phrasetype' doesn't exist

As it turns out, that query is missing the ".TABLE_PREFIX."

In vbiupdate.php
This code
PHP Code:

    echo "<p>Deleting Phrases...</p>";
    
$types $DB_site->query("
        SELECT phrasetypeid
        FROM phrasetype
        WHERE fieldname IN('vbindex', 'vbindex_cp')
    "
); 

Should look like this
PHP Code:

    echo "<p>Deleting Phrases...</p>";
    
$types $DB_site->query("
        SELECT phrasetypeid
        FROM "
.TABLE_PREFIX."phrasetype
        WHERE fieldname IN('vbindex', 'vbindex_cp')
    "
); 

Hope this helps.

khaleel 04-09-2005 05:45 PM

Quote:

Well... My problem is, that it doesn't import the phrases
Dont know about that sorry

Quote:

It Works fine with 3.0.7 , what error you have ??
Code:

Warning: chdir(): No such file or directory (errno 2) in /home/deathea/public_html/forum/vbindex.php on line 144
Is ANYONE going to give me some support?!

ZacUSNYR 04-10-2005 10:49 AM

Quote:

Originally Posted by khaleel
Dont know about that sorry



Code:

Warning: chdir(): No such file or directory (errno 2) in /home/deathea/public_html/forum/vbindex.php on line 144
Is ANYONE going to give me some support?!

You did set your forum path correctly in vbiconfig.php right?

khaleel 04-10-2005 05:38 PM

Yes :tired:

Delphy 04-11-2005 11:37 AM

If all else fails, you can try commenting out the chdir() line.

Also, check your unix permissions - you need the executable bit set on all paths down to root from the public_html folder for the group. For example on mine I have:

Code:

drwxr-xr-x    9 forums  forums      4096 Apr 11 06:48 forums/
and

Code:

drwxr-x---  27 forums  nobody      4096 Apr 11 07:39 public_html/
and obviously on /home too.

Hope this helps,
Delphy

Delphy 04-11-2005 11:43 AM

Quote:

Originally Posted by Club3G
I run this on three sites and I love it - by far the best portal software of ANY forum sw out there.

I use a standard post for my front page to show the news, in a hidden forum. I assume a lot of people do it this way. On http://www.club3g.com I have a 'Car of the Month' feature that's pretty static - I just edit the post once a month and I'm golden.

However on http://www.sevenstring.org, I use it for Artist Interviews and Album Reviews. I have a hidden Forum that contains one sticky post that I use for the news. Thing is, I have almost ten reviews/interviews and they're all pretty relevant. I'd LOVE a way to randomize which post gets shown on the front page, so it cycles between, say, all of the posts in a specified forum.

Is this something doable? Thanks!

Quite easy:
Code:

select * from thread where forumid=X order by rand() limit 1;
You'd obviously have to incoporate the users table and the post table and so on - but if you look at the "Get News" section in vBindex you could clone it, modify the SQL to ORDER BY RAND() LIMIT 1 and you're all set to go :)

You could even add a new template specifically for this section and just change the fetch_template('vbindex_newsbit') to whatever the new one is.

Hope this helps,
Delphy

Club3G 04-11-2005 05:22 PM

:D The only part of that I understood was "quite easy".

Delphy 04-11-2005 11:16 PM

I could probably hack vbIndex to do that and add a template. I'm really busy with stuff on my site, so it'll be a little while. :)

Q-v-n-s-Q 04-12-2005 03:25 PM

whats the points of use this hack?? its useless you know?

Marco van Herwaarden 04-12-2005 06:27 PM

Quote:

Originally Posted by Q-v-n-s-Q
whats the points of use this hack?? its useless you know?

Thank you for the well argumented positive feedback.


All times are GMT. The time now is 05:18 PM.

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.03655 seconds
  • Memory Usage 1,754KB
  • 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
  • (6)bbcode_code_printable
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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