Mini Mods - BFC-Quote

ALL MODS HAVE GONE BACK TO STEVE M AS I AM NOT MEANT TO CODE LIKE I CURRENTLY AM DOING.

[Excalibur82]

macc: Try installing using the product xml file I have attached to this post and tell me the results.

[odln018]

Originally Posted by Excalibur82

odln018: Permissions are controlled through the usergroups.

macc: Not to sure what is causing that error. I will check it out and get an update released.

I must be blind, because when I try to edit the usergroup, I'm not seeing a BFC Quote option.

[Excalibur82]

odln018: What version of vB are you using?

[Leica.Robbiani]

Hi,

Originally Posted by Excalibur82

Leica.Robbiani: The author box shouldn't have ' as no username has an ' but if its say Italian or something I'll see what I can do to fix the issue, otherwise for the time just avoid using ' when adding an author name.

Well, a username can be Georgia O'Keefe, and so there will be of course an ?'? in the username ...

So it will be great if you have a solution for the problem.

Thanks a lot, anyway it's a great mod.

Best regards

Leica.Robbiani

[Excalibur82]

Leica.Robbiani: Yeah you are correct, I don't know what I was thinking or doing when I said that. There is a solution but I won't be able to implement it till tomorrow once I've had some sleep.

[odln018]

Originally Posted by Excalibur82

Leica.Robbiani: Yeah you are correct, I don't know what I was thinking or doing when I said that. There is a solution but I won't be able to implement it till tomorrow once I've had some sleep.

I'm using 3.8.1 for both boards (test and production)

[macc]

Originally Posted by Excalibur82

macc: Try installing using the product xml file I have attached to this post and tell me the results.

i tried this file but when instal get error "eval code on line 6..." when tried to uninstall get this error

Database error in vBulletin 3.8.2:
Invalid SQL:
DROP TABLE `quotes`;
MySQL Error   : Unknown table 'quotes'
Error Number  : 1051
Request Date  : Wednesday, May 6th 2009 @ 10:23:05 AM
Error Date    : Wednesday, May 6th 2009 @ 10:23:05 AM
Script        : http://libar-libar.com/libar/vb/admi...do=productkill
Referrer      : http://libar-libar.com/libar/vb/admi...id=bfc_quote&s=
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

and in my admincp - when click on manage quotes get this database error

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM `quotes` ORDER BY username ASC;
MySQL Error   : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 6th 2009 @ 10:26:41 AM
Error Date    : Wednesday, May 6th 2009 @ 10:26:41 AM
Script        : http://libar-libar.com/libar/vb/admincp/quotes.php
Referrer      : http://libar-libar.com/libar/vb/admi...dex.php?do=nav
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

please some help -

regards

macc

[macc]

now my forum page works not - get this error

Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT * FROM quotes WHERE unapproved = 0 ORDER BY RAND() LIMIT 1;
MySQL Error   : Table 'belapla_libar.quotes' doesn't exist
Error Number  : 1146
Request Date  : Wednesday, May 6th 2009 @ 10:29:29 AM
Error Date    : Wednesday, May 6th 2009 @ 10:29:29 AM
Script        : http://libar-libar.com/libar/vb/index.php
Referrer      : http://libar-libar.com/libar/vb/admi...ex.php?do=head
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

some help?

macc

[EnIgMa1234]

Run the following query from the admincp->maintenance->execute sql query

[SQL]CREATE TABLE `quotes` (
`id` int(4) NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`username` varchar(255) NOT NULL default,
`unapproved` TINYINT( 1 ) NOT NULL",
PRIMARY KEY (`id`)
)[/sql]

Use this at your own risk.

[macc]

tried from phpmyadmin but get error -
my board and admincp - not accessible ...

some help ?

macc

edit - this error come up

ERROR: Oavslutat citat @ 174STR: "SQL: CREATE TABLE `quotes` (  `id` int(4) NOT NULL auto_increment,  `quote` mediumtext NOT NULL,  `username` varchar(255) NOT NULL default,  `unapproved` TINYINT( 1 ) NOT NULL",  PRIMARY KEY  (`id`))