This infusion allows you to enter on the website points system. Points can be obtained for the creation topics, posting on the forum and shoutbox.
This infusion is compatible with PHP-Fusion v7.02.03 and was tested on this version.
This infusion comes from Revelation v0.7.00 and was adapted for PHP-Fusion.

Version 1.61
* Fix Revelation Bank

Version 1.60
* Revelation Bank - Users can transfer the points.

Version 1.50
* Panel "Top Users".
* User field displays the number of points the user.
* Possibility to add or take a user points via admin panel.

Upload all files from directory files on server
Go to your website and sign in as administrator. Go to the Admin Panel -> System Admin -> Infusions, select from list of "Revelation Point System" and install it.
Go to the file rps_db.php. Example - www.website.com/rps_db.php (You must be logged in as administrator)
If the update process has been completed delete the file rps_db.php.
Modify files by following instructions:

Open the file maincore.php and find:
// Fetch the settings from the database $settings = array(); $result = dbquery("SELECT * FROM ".DB_SETTINGS); if (dbrows($result)) { while ($data = dbarray($result)) { $settings[$data['settings_name']] = $data['settings_value']; } } else { die("Settings do not exist, please check your config.php file or run setup.php again."); }
Below add:
// Revelation Point System Settings require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $rps = array(); $result = dbquery("SELECT * FROM ".DB_RPS_SETTINGS); while ($data = dbarray($result)) { $rps[$data['rpss_name']] = $data['rpss_value']; }

Open the file forum/options.php and find the line:
$result2 = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts-".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points-".$rps['reply']." WHERE user_id='".$userdata['user_id']."'"); // Revelation Point System End

Open the file forum/postedit.php and find the line:
$result = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts-1 WHERE user_id='".$data['post_author']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points-".$rps['reply']." WHERE user_id='".$userdata['user_id']."'"); // Revelation Point System End

Open the file forum/postnewthread.php and find the line:
$result = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts+1 WHERE user_id='".$userdata['user_id']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points+".$rps['newthread']." WHERE user_id='".$userdata['user_id']."'"); // Revelation Point System End

Open the file forum/postreply.php and find the line:
$result = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts+1 WHERE user_id='".$userdata['user_id']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points+".$rps['reply']." WHERE user_id='".$userdata['user_id']."'"); // Revelation Point System End

Open the file forum/viewforum.php and find the line:
$result2 = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts-".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points-".$rps['reply']."*".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'"); // Revelation Point System End

Open the file forum/viewthread.php and find the line:
$result = dbquery( "SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_showsig, p.post_smileys, p.post_author, p.post_datestamp, p.post_ip, p.post_ip_type, p.post_edituser, p.post_edittime, p.post_editreason, u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_posts, u.user_groups, u.user_joined, ".($user_field['user_sig'] ? " u.user_sig," : "").($user_field['user_web'] ? " u.user_web," : "")." u2.user_name AS edit_name, u2.user_status AS edit_status FROM ".DB_POSTS." p LEFT JOIN ".DB_USERS." u ON p.post_author = u.user_id LEFT JOIN ".DB_USERS." u2 ON p.post_edituser = u2.user_id AND post_edituser > '0' WHERE p.thread_id='".$_GET['thread_id']."' AND post_hidden='0' ORDER BY post_datestamp LIMIT ".$_GET['rowstart'].",$posts_per_page" );
Change it to:
$result = dbquery( "SELECT p.forum_id, p.thread_id, p.post_id, p.post_message, p.post_showsig, p.post_smileys, p.post_author, p.post_datestamp, p.post_ip, p.post_ip_type, p.post_edituser, p.post_edittime, p.post_editreason, u.user_id, u.user_name, u.user_status, u.user_avatar, u.user_level, u.user_posts, u.user_points, u.user_groups, u.user_joined, ".($user_field['user_sig'] ? " u.user_sig," : "").($user_field['user_web'] ? " u.user_web," : "")." u2.user_name AS edit_name, u2.user_status AS edit_status FROM ".DB_POSTS." p LEFT JOIN ".DB_USERS." u ON p.post_author = u.user_id LEFT JOIN ".DB_USERS." u2 ON p.post_edituser = u2.user_id AND post_edituser > '0' WHERE p.thread_id='".$_GET['thread_id']."' AND post_hidden='0' ORDER BY post_datestamp LIMIT ".$_GET['rowstart'].",$posts_per_page" );
In the same file find:
echo "<!--forum_thread_user_info--><span class='small'><strong>".$locale['502']."</strong> ".$data['user_posts']."</span><br />\n";
Below add:
if (file_exists(INFUSIONS."revelation_point_system/locale/".$settings['locale'].".php")) { include INFUSIONS."revelation_point_system/locale/".$settings['locale'].".php"; } else { include INFUSIONS."revelation_point_system/locale/Polish.php"; } echo "<!--forum_thread_user_info--><span class='small'><strong>".$locale['rps_012']."</strong> ".$data['user_points']."</span><br />\n";

Open the file forum/viewthread_options.php and find the line:
$result2 = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts-".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points-".$rps['reply']."*".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'"); // Revelation Point System End

Open the file infusions/shoutbox_panel/shoutbox_panel.php and find the line:
$result = dbquery("DELETE FROM ".DB_SHOUTBOX." WHERE shout_id='".$_GET['shout_id']."'".(iADMIN ? "" : " AND shout_name='".$userdata['user_id']."'"));
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points-".$rps['shoutbox']." WHERE user_id='".$_GET['user_id']."'"); // Revelation Point System End
In the same file find:
$result = dbquery("INSERT INTO ".DB_SHOUTBOX." (shout_name, shout_message, shout_datestamp, shout_ip, shout_ip_type, shout_hidden) VALUES ('$shout_name', '$shout_message', '".time()."', '".USER_IP."', '".USER_IP_TYPE."', '0')");
Below add:
// Revelation Point System Start require_once BASEDIR."infusions/revelation_point_system/infusion_db.php"; $result = dbquery("UPDATE ".DB_USERS." SET user_points=user_points+".$rps['shoutbox']." WHERE user_id='".$userdata['user_id']."'"); // Revelation Point System End
In the same file find:
echo "[<a href='".$link.$sep."s_action=delete&shout_id=".$data['shout_id']."' class='side'>".$locale['SB_delete']."</a>]<br />\n";
Change it to:
echo "[<a href='".$link.$sep."s_action=delete&shout_id=".$data['shout_id']."&user_id=".$data['user_id']."' class='side'>".$locale['SB_delete']."</a>]\n";