vb.org Archive
Page 15 of 76 « First 51314 15 16172565 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Major Additions - QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=135297)

Cap'n Steve 01-16-2007 07:26 AM
Still looking at the language chooser and vBadvanced bugs.

yonglvnv - It's not reading the permissions for some reason. Did you still have includes/xml/bitfield_quoteit.xml on the server?

soulface - That's right. The date wasn't stored in earlier versions so it uses the date you installed it as the default date.

Alien - I was afraid of that. I have no idea what your problem is, but it's not modifying or adding columns. I'll keep searching for the reason behind that, but until then you have two options: Try and get your host to upgrade MySQL (I'm not sure if that will help) or modify the tables yourself through phpMyAdmin. Here's the structure for each table (column name is on the left, definition after the =>):

quotes
Code:
quoteid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
quote => MEDIUMTEXT NOT NULL
author => VARCHAR (100) DEFAULT NULL
userid => INT (10) UNSIGNED NOT NULL DEFAULT 0
approved => TINYINT (1) UNSIGNED NOT NULL DEFAULT 0
votes => INT (10) UNSIGNED NOT NULL DEFAULT 0
rating => INT (10) NOT NULL DEFAULT 0
average => FLOAT (3, 2) NOT NULL DEFAULT 0.00
context => VARCHAR (250) DEFAULT NULL
date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL
quoteratings
Code:
userid => INT (10) UNSIGNED NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
guestquoteratings
Code:
ip => VARCHAR (15) NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
date => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
quotecategories
Code:
categoryid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
title => VARCHAR (64) NOT NULL
description => VARCHAR (250) DEFAULT NULL
public => TINYINT (1) NOT NULL DEFAULT 1
displayorder => SMALLINT (5) SIGNED NOT NULL DEFAULT 0
Here are the keys (table name on the left, keys after the =>):
Code:
quotes => PRIMARY KEY (quoteid), KEY (approved), KEY (rating), KEY (average)
quoteratings => PRIMARY KEY (quoteid, userid)
guestquoteratings => PRIMARY KEY (quoteid, ip)
quotecategories => PRIMARY KEY (categoryid)
And finally, these columns need to be added to other tables:

user
Code:
quoteitoptions => INT(10) UNSIGNED NOT NULL DEFAULT 0
lastquotesvisit => INT(10) UNSIGNED NOT NULL DEFAULT 0
quotecount => INT(10) UNSIGNED NOT NULL DEFAULT 0
usergroup
Code:
quoteitpermissions => INT(10) UNSIGNED NOT NULL DEFAULT 2567

Calash 01-16-2007 05:12 PM
The latest download has resolved the issue with the edit button, it now does an AJAX edit.

I still have the language bar issue. Normally I only have 1 language (English) and the drop down selection is not visible. When I install QuoteIT the drop-down shows up and has a random selection (I have seen A, E, and blank). I will leave it up so you can take a look.

I am also having issues with the vBadvanced module. I set it up per the instructions but it does not show up. I have not had time to trouble shoot yet, but if you can give me some common problem areas to look at it would help :)

Thank you for making the mod...it is something I thought I was going to lose when I moved to vB.

Alien 01-17-2007 01:44 PM
Hey!

I went over the table structure carefully, and I have everything you showed above in your table structure EXCEPT for this in the quotes table:

date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL

Calash 01-17-2007 01:58 PM
The vBadvamced module problem seems to be related to permisisions. If I edit the get_random_quote() function and remove the "canviewquote" check it works fine. I need to fix the layout but that is a skin issue and not a QuoteIT issue.

May be off on the names, I am at work ATM.

Alien 01-17-2007 02:04 PM
Okay, added the entries above and so far so good without mysql errors in the admincp..

I'll also upgrade to the latest version you posted shortly.

zetetic 01-17-2007 02:08 PM
Sorry Cap'n, I haven't had a chance to work on this for the last couple days so I can't give any feedback about the current revision. However, would you mind updating the filename or OP with the current rev number when you release new revisions? I'd like to make sure I grab the latest.

Thanks again for all your work on this.

thepub 01-17-2007 03:04 PM
so I have to reinstall in order to get the edit button to look normal? I finally got it installed and showing, but it's very large on the forum index and the edit button looks like an edit button on the board.

thepub 01-17-2007 03:38 PM
this may be the dumbest question ever but where exactly is the modules/moderate.php at so I can edit the file according to the vbadvanced installation instructions?

zetetic 01-18-2007 12:30 AM
The modules directory should be in your forum root. So like yoursite.com/forum/modules/

Cap'n Steve 01-18-2007 04:58 AM
zetetic - It's at the top, right under the title, but the easiest way to check is to go to "Manage Products" in your admincp and then there'll be a "Check Version" option in the list next to QuoteIt!

thepub - That module and the directory itself come with vBadvanced. I'm not sure what you mean about the edit button. The actual image is too large? You'll have to edit the quote_listbit template to change the size.


All times are GMT. The time now is 12:19 AM.
Page 15 of 76 « First 51314 15 16172565 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.01789 seconds
  • Memory Usage 1,743KB
  • 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
  • (7)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)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