anybody tried this on 3.0.3?

Did you read the above post ?

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

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

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

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 :)

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.

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???

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

First off, THANK YOU for responding. :o)

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

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.