BVShoutbox FULLL

Features:

• Displays vBCodes and other post code allowances.
• Admins can edit & delete shouts from the Admin CP.
• Built-in /me code.
• Archive page and IFrame on forumhome for shouting and reading.
• Archive page has multiple pages.
• Stats on archive page.
• Uses phrases for the Admin CP and shoutbox.
• Users can edit and delete their own shouts.
• Usergroup & Administrator permissions.
• Find shouts by specific users (in the admin cp)
• Seperate options for vBCodes allowances and what to display

If there's any features anyone wants added, I'll try and add them. I think I added everything people asked for in the previous version, apart from the upgrader, which will be added to the ZIP file when i've setup another test forum and added the previous version to it

There shouldn't be any problems, because I've tested the installer three times.
And I haven't had any problems with the actual shoutbox, or shout manager.

I'll attach some screenshots of all the custom scripts, if anyone asks for screenshots of the add ons for the permissions and stuff ill take them, dunno why anyone would want them tho...

This has only been tested on vB 3.0.0 GOLD

[Harley D]

Yes, went through them at least 3 times.

I try running these commands in MYSQL and keep receiving errors

ALTER TABLE . TABLE_PREFIX . usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions

gives error

"An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '. "language DROP phrasegroup_shoutbox, DROP phrasegroup_shoutma"


and

"ALTER TABLE " . TABLE_PREFIX . "language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL, ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL",

gives error

"An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'language INSERT phrasegroup_shoutbox MEDIUMTEXT NOT NULL, INSER"

and its Shout Box Permissions that I'm have problems with "my best guess anyways"

I will go through the manual file edits once again tonight, never know might have missed something

[Harley D]

O.K. Went through each file mod again, still blank Shout Box, which I believe is due to, no permissions. Also get this error when I click on the SHOUT BOX link on top left of box its self.
"you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation."

Now I have set permissions in the Administrator Permissions Manager to YES, only after fixing the errors in the install in the file adminpermissions.php.

His install states to put
" 'canadmincron' => $vbphrase['can_administer_cron'],
'canadminshouts' => $vbphrase['can_administer_shouts']
'canadminmaintain' => $vbphrase['can_run_maintenance'],"

But it should look like
" 'canadmincron' => $vbphrase['can_administer_cron'],
'canadminshouts' => $vbphrase['can_administer_shouts'],
'canadminmaintain' => $vbphrase['can_run_maintenance'],"

Note the missing "," after the "]"

Now like I have been suggesting, I believe the lack of permissions and the ability to edit them in the user Group Manager "not showing anything that says Shout Box" is due to the Install Script erroring out at the 2 areas mentioned above. and If I could get somebody to write the edits with the proper SYNTAX so I can install them manually without errors, this should get "might" this darn thing working.

Thanks In advance.

[Harley D]

Maybe I'm off in left field, or just mis-understood, but could the TABLES that the install errors on, be keeping the ShoutBox fields from showing up in the Group Permissions?

anyone???

[blubber12]

ok part of your problem is that you can't manually add that query as written "table prefix" is catchall relating to whatever your table prefix is. Run this instead

ALTER TABLE usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions

and

ALTER TABLE language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL
ALTER TABLE language ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL

Now, if your tables DO have a prefix...you must add it to the table name ie prefix.language or whatever it is you use. Most probably don't have a specific prefix and just use the server default..so you should be ok to run the above

[Harley D]

First off, THANK YOU for responding. )

I ran the Queries, and it looks like they are already installed.

ALTER TABLE usergroup ADD shoutboxpermissions INT UNSIGNED NOT NULL DEFAULT '0' AFTER forumpermissions

An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'shoutboxpermissions'

ALTER TABLE language ADD phrasegroup_shoutbox MEDIUMTEXT NOT NULL

An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'phrasegroup_shoutbox'

ALTER TABLE language ADD phrasegroup_shoutmanager MEDIUMTEXT NOT NULL


An error occurred while attempting to execute your query. The following information was returned.
error number: 1060
error desc: Duplicate column name 'phrasegroup_shoutmanager'

I'm dumbfounded now, I have read, searched and still havn't been able to get this to work, or should I say, show in my AdminPC's Usergroup permissions.
From the above errors, I have to assume that the tables are correct, or should I remove and re-install them? I'm at a loss.

[N00BIE]

Originally Posted by cashpath

OK the permissions were set right in the cp but I had to go in set them to NO and then back to YES for it to work.. wierd...

Same Here very strange i also had to set permission to NO update then back to YES and it all works fine now :ermm: :ermm:

[TheComputerGuy]

I have this hack installed...and I do not see a place where it allows for Admins to see the shouts. This really sucks because they should be able to no problem

[Flow Fusion]

You need to edit your "index.php" to see the shoutbox shouts.

[TheComputerGuy]

I just made my Admins primary and then registered usergroup an extra it worked out !

[bspiller82]

How you go about uninstalling this?

[Harley D]

O.K. I know when to say enoughs enough, no help from the coder, I've removed this puppy!

[Fking]

wow
i guess i did wrong installing this hack, but i read the thread after i installed it...

well it works fine, and i'm going to keep it
but need to touch a thing or two

how i can set a font size of the time? [30-09-2004 03:32 AM]
i want to make it smaller

[TheComputerGuy]

Invalid SQL:
SELECT s.*, u.username
FROM shout s
LEFT JOIN user u ON (u.userid = s.userid)
ORDER BY dateline , shoutid LIMIT

What this mean?

[TheComputerGuy]

How do you uninstall this hack safely?

[Fking]

the IE started crashing, may this hack be the reason?
the weird is that it crashes only when i load the url with www. in front