Don't forget to copy <root/> with each update

********************************
* PRS Version 0.3.14 => 0.4.0 *
********************************

The message below was copiedat 8 june 2008 from
http://prs.kruijff.org/forum/viewtopic.php?f=3&t=46

I abbreviated the mod name everywhere. A update requires you to walk though the all installation files again. i.e. install.xml contrib/user.xml contrib/moderator.xml

Step 0. Before installing the new version, make a copy of you mod settings.

Step 1. Disable the use of the board.

Step 2. Open includes/constants.php and append the following lines:

define('PRS_VOTES_TABLE', $table_prefix . 'posts_ratings_votes');
define('PRS_VOTES_CHI_TABLE', $table_prefix . 'posts_ratings_votes_chi');
define('PRS_PENALTY_TABLE', $table_prefix . 'posts_ratings_penalty');
define('PRS_MODPOINTS_TABLE', $table_prefix . 'posts_ratings_modpoints');

This prevents you from losing your entries
or having to copy them to the new tables.

Remember to skip this file when you come across this in the install.xml file.

Step 2. Copy the files as indicated in install.xml.

Step 3. Open http://example.com/forum/install/upgrad ... 0_3_14.php (instead of install/index.php)

Step 4. Go to the ACP and enter the old settings.

Step 5. Enable the board for your users while you continue the update

Step 6. Execute this SQL:

ALTER TABLE phpbb3_posts
CHANGE `posts_ratings_score` `prs_score` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0',
CHANGE `posts_ratings_standard_diviation` `prs_standard_diviation` SMALLINT( 5 ) UNSIGNED NOT NULL DEFAULT '0',
CHANGE `posts_ratings_shadowed` `prs_shadowed` TINYINT( 1 ) NOT NULL DEFAULT '0',
CHANGE `posts_ratings_penaltized` `prs_penaltized` TINYINT( 1 ) NOT NULL DEFAULT '0';

DELETE FROM CONFIG_TABLE
WHERE config_name REGEXP 'posts_ratings_.*'

Step 7. The update requires that you walk through install.xml, contrib/user.xml and contrib/moderator.xml or copy the premodded files. You can skip the edits in the file includes/constants.php

Step 8. Do the following if you have trouble running the install scripts. Don't forget to change it back.

[OPEN includes/acp/acp_prs.php]
[FIND]
# Uncomment this if the error troubles you.
# $db->sql_return_on_error(TRUE);
[REPLACE-WITH]
# Uncomment this if the error troubles you.
$db->sql_return_on_error(TRUE);
[CLOSE FIlE]

Step 9. You will find that a category is created and a couple of PRS pages are added to it. You will also have your old entries. This might be a good reason to remove the old entries.

********************************
* PRS Version 0.3.13 => 0.3.14 *
********************************

OPEN includes/mcp/mcp_topic.php
FIND array_keys($rowset), $posts_ratings_arr
REPLACE WITH array_keys($posts_ratings_arr), $posts_ratings_arr
CLOSE FILE

