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

[Wordplay]

anybody tried this on 3.0.3?

[TTG]

Originally Posted by Wordplay

anybody tried this on 3.0.3?

Did you read the above post ?

[akirauk]

Is there a fix for the background problem or a way to change the colour of the text?

[Harley D]

Originally Posted by xTerMn8R

I had a lot of these types of problems with my hacks after upgrading from 3.01 to 3.03. How i fixed it was looked at the error and went into phpmyadmin and dropped and entries that continued to come up.(ie. in ur case here the "Usergroup" table 'shoutboxpermissions' entry

After finally getting rid of all the Table Modifications associated with the hack was I able to do fresh installs of the hacks... Its a time consuming process, but it works and can turn out to be less time consuming then other methods.

***Note*** Here's a tip .. If ya drop a table entry error and try and install the hack and it errors at a new point further along then the previous error spot then you'll probably need to drop BOTH table Mods again and so on and so forth for as many as there are. SO I just Copy and pasted them into a txt file and then I had the Hack Table Mods on file.

Good luck

Thanks, This did help alot, However the table additions that the install script errored on still have to be installed manually in order for the hack to work.
So If someone that is MYSQL talented could help us add these frases manually in th ADMINCP by properly wording and formatting the SQL table additions, this would be all that is left to get my clients Shout Box working.

Evething is showing on the page, but the Shot Box iss empty, I believe its due to PERMISSIONS, I cannot edit them in the ADMINPC because there is nothing under USERGROUPS, and it just happens that this is where the install script errored. I removed 2 table edits from the install script to get it to complete the install as instructed above.

Here is the installs table edits that I had to remove in order for the install script to complete.


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

and

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

I need these typed so I can cut and paste it into the ADMINCP's Execute SQL Query box.
This should add the Shout Box in my user groups, so I may change the permissions, so It can be viewed.

Am I making sense?? LOL

[TTG]

Originally Posted by Harley D

Evething is showing on the page, but the Shot Box iss empty, I believe its due to PERMISSIONS, I cannot edit them in the ADMINPC because there is nothing under USERGROUPS, and it just happens that this is where the install script errored. I removed 2 table edits from the install script to get it to complete the install as instructed above.

Did you complete the manual file edits, in particular the file edits for admincp/usergroup.php

[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.