MODS.DB9.DK

[Niels]

I did found that the shout_id needed a DB change, please run this SQL

Code: Select all

ALTER TABLE prefix_shout CHANGE shout_id shout_id SMALLINT(5) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT

the next upgrade will require this !

[Niels]

the shoutbox mod have now been updated, most of the included files have changed, please update these

the mod now REQUIRE my EXTRA PERMISSION MOD, this is so you may control witch users may post, censor and moderate the shoutbox, fully support user/usergroups

sadly I haven't the time for writing a complete upgrade info, but I have
also made changes into these files:
lang_main.php
subsilver.cfg
viewonline.php
+ made new included files

this upgrade is considered as importen, since the old did have some bugs, please update your files

[Niels]

I have now released a new version, this will move the shoutbox above the who-is online.
new version is 0.9.7.

you may now deside how may see this, by granting special permission to AUTH_VIEW, this enables you to remove the shoutbox from the index page for some users, (witch can speed up load since the shoutbox takes some litle time to load)

here is how to upgrade:
do the page_header.php, as described in the new how-to
replace the template file shoutbox_body.tpl with the new included

in file constants.php

Code: Select all

[FIND]
define('PAGE_SHOUTBOX_MAX',-101);

[AFTER ADD]
define('PAGE_SHOUTBOX',-101);

in file page_header.php

Code: Select all

[FIND]
$view_pages_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata);

[AFTER ADD]
if ($view_pages_ary[''.PAGE_SHOUTBOX]['auth_view'])
{
   $template->assign_block_vars('switch_shoutbox_on', array());
}

in file index_body.tpl

Code: Select all

[FIND - AND REMOVE]
<table width="100%" cellpadding="0" cellspacing="0" border="0" class="cattitle">
<tr>
   <td class="cattitle" width="170" valign="top">
<!-- Shoutbox -->
      <table cellpadding="0" cellspacing="0" border="0" class="forumline" width="100%">
           <tr>
         <td align="center" nowrap="nowrap" class="catHead"><span class="cattitle"><a href="{U_SHOUTBOX_MAX}">{L_SHOUTBOX}</a></span></td>
      </tr>
      <tr>
         <td>
          <iframe src="{U_SHOUTBOX}" scrolling="NO" width="100%" height="280" frameborder="0" marginheight="0" marginwidth="0"></iframe>
         </td>
      </tr>
          </table>
<!-- Shoutbox -->
<br/>
</td>
<td class="cattitle" valign="top" >&nbsp;</td>
<td class="cattitle" valign="top" >

[FIND - AND REMOVE]
</td>
</tr>
</table>

[FIND]
<td align="right"><span class="gensmall">{S_TIMEZONE}</span></td>
</tr>
</table>

[AFTER ADD]
<!-- BEGIN switch_shoutbox_on -->
<table width="100%" cellspacing="0" border="0" align="center" cellpadding="2" class="forumline">
  <tr>
           <tr>
         <td align="center" nowrap="nowrap" class="catHead"><span class="cattitle"><a href="{U_SHOUTBOX_MAX}">{L_SHOUTBOX}</a></span></td>
      </tr>

         <td>
          <iframe src="{U_SHOUTBOX}" scrolling="NO" width="100%" height="180" frameborder="0" marginheight="0" marginwidth="0"></iframe>
         </td>
  </tr>
</table>
<br/>
<!-- END switch_shoutbox_on -->

[Niels]

ver 0.9.8. is now uploaded

this improve the permission control, witch now support
auth VIEW
auth READ
auth POST
auth DELETE
auth MOD

if a user is granted auth DELETE, he may delete own posts - not other users posts, witch will require auth MOD

to upgrade copy the included files, both php and template files !

[Niels]

a previous released db_update.php did have bug, witch made it add a entry in the DB witch should not be there....the entry is by it self NOT a problem, but to clean up please

1. open a exisiting db_update.php (any)
2. replace this below posted code
3. run this newly created db_update.php file

alternativly you may delete the entry manually, in this case, simply delete any "shoutbox" inside the forums table, witch does not have a forum_id=-101

This section of code, should be used

Code: Select all

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(

"DELETE FROM ".FORUMS_TABLE." WHERE forum_id<>'-101' AND forum_desc='Shoutbox Page Control'"
);

$mods = array (
'repair fully integrated shoutbox'
);


############################################### Do not change anything below this line #######################################

instead of this section of code

Code: Select all

###################################################################################################
##
## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
.
.
. some other SQL
.
.



############################################### Do not change anything below this line #######################################

this will clean up the DB

[Niels]

there was a bug in the how-to, new version is 0.9.9.

to update please replace this in file index.php

Code: Select all

[FIND]
'U_SHOUTBOX_MAX' => append_sid("shoutbox.$phpEx?max=400"),

[REPLACE WITH]
'U_SHOUTBOX_MAX' => append_sid("shoutbox_max.$phpEx"),

[Niels]

the shoutbox delete/censor function did not work proper on users sites, this was due to a typo in the how-to, witch did say how to create the shout table in the DB - since this was wrong you need to correct this

NEW VERSION IS 0.9.9.

in order to correct this, you need to make the "shout_id" auto increment, depending on the behaivier of your DB it wil most likly also be needed to delete all shouts made so far...sorry, but all curren shouts have same id, so in order to correct this you might need to do so.

if you are uncomfortable with doing manually DB changes, you can open the existin db_update.php and modify it like this:
FIND]

Code: Select all

## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(

"CREATE TABLE ".SHOUTBOX_TABLE." (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL,
shout_username VARCHAR(25) NOT NULL,
shout_user_id MEDIUMINT(8) NOT NULL,
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL,
shout_ip CHAR(8) NOT NULL,
shout_text TEXT NOT NULL,
shout_active MEDIUMINT(8) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id)
)",
"INSERT IGNORE INTO ".FORUMS_TABLE." (forum_id ,cat_id, forum_name, forum_desc, forum_status )
VALUES ('-101', '0', 'SHOUTBOX PAGE', 'Shoutbox Page Control', 1 )"
);

$mods = array (
'fully integrated shoutbox','fully integrated shoutbox'
);

############################################### Do not change anything below this line #######################################

[REPLACE WITH]

Code: Select all

## put the SQL commands below here, the SQL commands listed below are only exampels, substitude them with the one you need ##
##
###################################################################################################
$sql=array(
"DROP TABLE ".SHOUTBOX_TABLE,
"CREATE TABLE ".SHOUTBOX_TABLE." (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
shout_username VARCHAR(25) NOT NULL,
shout_user_id MEDIUMINT(8) NOT NULL,
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL,
shout_ip CHAR(8) NOT NULL,
shout_text TEXT NOT NULL,
shout_active MEDIUMINT(8) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id)
)"
);

$mods = array (
'fully integrated shoutbox','fully integrated shoutbox'
);


############################################### Do not change anything below this line #######################################

THEN YOU NEED TO RUN THIS AGAIN

[Niels]

the above [REPLACE WITH] code are updated, there was a ." to mutch