vb.org Archive
Page 6 of 13 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Moderators Functions - vbAccessDenied (https://vborg.vbsupport.ru/showthread.php?t=111601)

hambil 03-30-2006 05:50 AM
LOL - I do that all the time. It's hard to keep track sometimes :)

Tyegurl 03-30-2006 05:51 AM
one last thing.... how do i get it to automatically add the forum title and user's name? i am not too quick on this stuff

and yes with the correct version i got the message. sorry about that.

hambil 03-30-2006 05:54 AM
Quote:
Originally Posted by Tyegurl
one last thing.... how do i get it to automatically add the forum title and user's name? i am not too quick on this stuff

and yes with the correct version i got the message. sorry about that.
One of the screen shots has some nice examples. Basically, any forum or user or usergroup data can be used. You put them in {} in the message.

Username would be {user.username}
and the forum would be {forum.title}

I'll put up a complete list of the standard vb ones tomorrow - but if you have installed hacks that add to the forum or user or usergroup table, you can also use those values too.

Delphiprogrammi 03-30-2006 11:03 AM
hi,

this doesn't work and throws an error every time you hit "messages" in the admincp navigation

Quote:

Invalid SQL:

SELECT accessdenied_message.*, usergroup.title AS usergroup, forum.title AS forum
FROM vb3_accessdenied_message
LEFT JOIN vb3_usergroup ON usergroup.usergroupid = accessdenied_message.usergroupid
LEFT JOIN vb3_forum ON forum.forumid = accessdenied_message.forumid;

MySQL Error : Unknown table 'accessdenied_message'
Error Number : 1051
Date : Thursday, March 30th 2006 @ 07:00:54 AM
Script : http://*******/testvb/admincp/access....php?do=modify
Referrer : http://*******/testvb/admincp/index.php?do=nav
IP Address : ******
Username : ******
Classname : vb_database

hambil 03-30-2006 11:07 AM
Quote:
Originally Posted by Delphiprogrammi
hi,

this doesn't work and throws an error every time you hit "messages" in the admincp navigation
Unknown table means it didn't install properly for some reason. I have no idea why. What version is your MySQL?

Delphiprogrammi 03-30-2006 11:12 AM
Quote:
Originally Posted by hambil
Unknown table means it didn't install properly for some reason. I have no idea why. What version is your MySQL?
MySQL 4.1.14-standard

hambil 03-30-2006 11:15 AM
Can you remove the line $db->hide_errors() from the product xml and try importing it again? Tell me what, if any error you see?

Delphiprogrammi 03-30-2006 11:24 AM
Quote:
Originally Posted by hambil
Can you remove the line $db->hide_errors() from the product xml and try importing it again? Tell me what, if any error you see?
verry strange here is no error message ......

PHP Code:
$msgs = $db->query_read("
        SELECT accessdenied_message.*, usergroup.title AS usergroup, forum.title AS forum
        FROM " . TABLE_PREFIX . "accessdenied_message
        LEFT JOIN " . TABLE_PREFIX . "usergroup ON usergroup.usergroupid = accessdenied_message.usergroupid
        LEFT JOIN " . TABLE_PREFIX . "forum ON forum.forumid = accessdenied_message.forumid
    "); 
that is causing the error i have no field called "accessdenied_message" within the table vb3_accessdenied_message that field is for some reason missing

hambil 03-30-2006 11:28 AM
Quote:
Originally Posted by Delphiprogrammi
verry strange here is no error message ......

PHP Code:
$msgs = $db->query_read("
        SELECT accessdenied_message.*, usergroup.title AS usergroup, forum.title AS forum
        FROM " . TABLE_PREFIX . "accessdenied_message
        LEFT JOIN " . TABLE_PREFIX . "usergroup ON usergroup.usergroupid = accessdenied_message.usergroupid
        LEFT JOIN " . TABLE_PREFIX . "forum ON forum.forumid = accessdenied_message.forumid
    "); 
that is causing the error i have no field called "accessdenied_message" within the table vb3_accessdenied_message that field is for some reason missing
There is no field call accessdenied_message - it's the table name.

hambil 03-30-2006 11:29 AM
Ah...
I may see the problem - though why it hasn't caused anyone else trouble I don't know. Let me try a quick fix.


All times are GMT. The time now is 02:46 PM.
Page 6 of 13 « First 45 6 78 Last »
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.01118 seconds
  • Memory Usage 1,751KB
  • 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
  • (2)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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