vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Post Icons Forum Permissions (https://vborg.vbsupport.ru/showthread.php?t=110093)

vibe 06-26-2006 02:40 AM

Quote:

Originally Posted by zippokid
This doesn't work for me. I get a message of this

Code:

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE imagecategoryforums (
  imagecategoryid smallint(5) unsigned NOT NULL default '0',
  forumid smallint(5) unsigned NOT NULL default '0',
  KEY imagecategoryid (imagecategoryid,forumid)
);

MySQL Error  : Table 'imagecategoryforums' already exists
Error Number : 1050
Date        : Thursday, May 18th 2006 @ 12:06:02 AM
Script      : http://www.forum.net/bb/admincp/plugin.php
Referrer    : http://www.forum.net/bb/admincp/plugin.php?do=productadd
IP Address  : xxxxxxxxxxxxx
Username    : xxxxx
Classname    : vb_database

Any thoughts? I'd really like to implement this


Same here when trying to import

vibe 06-28-2006 03:56 PM

Okay, this is what I did:

I went ahead and delete "imagecategoryforums" table off from my SQL and re-imported the xml file and this is what I got.

Code:

Invalid SQL:

  ALTER TABLE imagecategoryforums ADD options TINYINT NOT NULL DEFAULT '0';;

MySQL Error  : You have an error in your SQL syntax near ';
' at line 2
Error Number : 1064

Can somebody advise me on this?
Thanks

zippokid 07-12-2006 01:29 PM

Same thing happened to me.

johnstires 11-11-2006 06:21 PM

Does this work for vb 3.6?

johnstires 11-12-2006 12:41 PM

Just tested, works great for 3.6

LBmtb 12-16-2006 11:16 PM

Quote:

Originally Posted by vibe (Post 1017663)
Okay, this is what I did:

I went ahead and delete "imagecategoryforums" table off from my SQL and re-imported the xml file and this is what I got.

Code:

Invalid SQL:

  ALTER TABLE imagecategoryforums ADD options TINYINT NOT NULL DEFAULT '0';;

MySQL Error  : You have an error in your SQL syntax near ';
' at line 2
Error Number : 1064

Can somebody advise me on this?
Thanks

It looks like there's an extra semi-colon.


Anyhoo . . . this mod sounds great. I'll be installing once I design my icons.

Mindwarp 01-26-2007 05:33 PM

anyways to keep it expanded so that the user did not have to?

DevinM 01-27-2007 06:55 AM

This hack works great for me on 3.6.4, by default it stays expanded for me. I didnt change anything.

RedGTiVR6 07-11-2007 08:54 PM

works great on 3.6.7PL1.

Just one question, I cannot for the life of me figure out where to set permissions based on user group for the post icons...

I checked the manual, all it says is that you change it at the usergroup level, but I cannot find that in the usergroups at all!

RedGTiVR6 07-13-2007 09:41 PM

welp, I've found an issue.

If I go into a thread that I have not created, and want to add in one of the new post icons that is assigned to a specific user group, it will show up fine from within the thread, however, if I go out to the thread litsings it does not show up.

But, if I edit a thread that I started and add in one of these icons, it will show up fine in the thread listings page.

Any ideas anyone?


All times are GMT. The time now is 10:15 AM.

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.01110 seconds
  • Memory Usage 1,739KB
  • 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
  • (3)bbcode_code_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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