<html>
<head>
<title>CashMod SQL Install v 0.1.0</title>
</head>
<body>
<?php
$file_name = 'CashMod_sql_install_v0_1_0.php';
$mod_name = "CashMod v 0.1.0";
if(!isset($_GET['lock']) && !isset($_GET['fin'])){
echo 'Would you like to close your forum whilst you update it? (will have option to unlock at the end)<br/>';
echo '<a href="' . $file_name . '?lock=1">Yes</a><br/>';
echo '<a href="' . $file_name . '?lock=0">No</a><br/>';
exit();
}
require "./global.php";
if(isset($_GET['fin']) && $_GET['fin'] == "1"){
$sql_lock = "UPDATE `" . TABLE_PREFIX . "settings` SET value='no' WHERE name = 'boardclosed'";
if($result = $db->query($sql_lock)){
echo "<em>Opened forums</em>";
}
else{
echo "<em>Could not open forums</em>";
}
echo '<p> </p>';
echo "Thank you for installing " . $mod_name . "!<br/>";
exit();
}
if($_GET['lock'] == "1"){
$sql_lock = "UPDATE `" . TABLE_PREFIX . "settings` SET value='yes' WHERE name = 'boardclosed'";
if($result = $db->query($sql_lock)){
echo "<em>Closed forums</em>";
}
else{
echo "<em>Could not close forums</em>";
}
echo '<p> </p>';
}
////////////////
$sql = "ALTER TABLE `" . TABLE_PREFIX . "adminoptions` ADD `canmanagecashmod` VARCHAR(3) DEFAULT 'yes' NOT NULL";
if($result = $db->query($sql, 1)){
echo "Altered table " . TABLE_PREFIX . "adminoptions<br>";
}
else{
echo "Could not alter table " . TABLE_PREFIX . "adminoptions<br>";
$error = TRUE;
}
////////////////
$sql = "ALTER TABLE `" . TABLE_PREFIX . "forums` ADD `cash_value` DECIMAL( 9, 2 ) DEFAULT '-1.00' NOT NULL";
if($result = $db->query($sql, 1)){
echo "Altered table " . TABLE_PREFIX . "forums<br>";
}
else{
echo "Could not alter table " . TABLE_PREFIX . "forums<br>";
$error = TRUE;
}
////////////////
$sql = "ALTER TABLE `" . TABLE_PREFIX . "users` ADD `cash` DECIMAL( 9, 2 ) DEFAULT '0.00' NOT NULL";
if($result = $db->query($sql, 1)){
echo "Altered table " . TABLE_PREFIX . "users<br>";
}
else{
echo "Could not alter table " . TABLE_PREFIX . "users<br>";
$error = TRUE;
}
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settinggroups` (gid, name, description, disporder) VALUES(NULL, 'Cash Mod', 'You can control the settings for the cash mod here', 1)";
if($result = $db->query($sql, 1)){
echo "Inserted cash mod setting category<br>";
$sql = "SELECT gid FROM " . TABLE_PREFIX . "settinggroups WHERE name = 'Cash Mod'";
$query = $db->query($sql);
$result = $db->fetch_array($query);
$setting_id = $result['gid'];
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settings` (sid, name, title, description, optionscode, value, disporder, gid) VALUES(NULL, 'cash_mod_active', 'Cash mod active?', 'If you turn the cash mod off, noone will get cash when they post', 'yesno', 'no', 1, " . $setting_id . ");";
if($result = $db->query($sql, 1)){
echo "Inserted setting: Cash active<br>";
}
else{
echo "Could not insert setting: Cash active<br>";
$error = TRUE;
}
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settings` (sid, name, title, description, optionscode, value, disporder, gid) VALUES(NULL, 'cash_mod_character', 'Cash per character (default)', 'This setting is used as a global default for your forums. You can assign each forum a different cash value if you so wish', 'text', '1.00', 2, " . $setting_id . ");";
if($result = $db->query($sql, 1)){
echo "Inserted setting: Value/character<br>";
}
else{
echo "Could not insert setting: Value/character<br>";
$error = TRUE;
}
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settings` (sid, name, title, description, optionscode, value, disporder, gid) VALUES(NULL, 'cash_mod_round', 'Round currency?', 'This will round any decimal values. Useful if you just want currency in whole numbers', 'yesno', 'no', 3, " . $setting_id . ");";
if($result = $db->query($sql, 1)){
echo "Inserted setting: Round value<br>";
}
else{
echo "Could not insert setting: Round value<br>";
$error = TRUE;
}
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settings` (sid, name, title, description, optionscode, value, disporder, gid) VALUES(NULL, 'cash_mod_name', 'Cash name', 'Name of currency/cash', 'text', 'Gold:', 4, " . $setting_id . ");";
if($result = $db->query($sql, 1)){
echo "Inserted setting: Cash name<br>";
}
else{
echo "Could not insert setting: Cash name<br>";
$error = TRUE;
}
////////////////
$sql = "INSERT INTO `" . TABLE_PREFIX . "settings` (sid, name, title, description, optionscode, value, disporder, gid) VALUES(NULL, 'cash_mod_finished', 'Posted message', 'This is the string that will appear when you have posted a message.<br/>(%s is used to signify the number)', 'text', 'You have received %s gold', 5, " . $setting_id . ");";
if($result = $db->query($sql, 1)){
echo "Inserted setting: Reply string<br>";
}
else{
echo "Could not insert setting: Reply string<br>";
$error = TRUE;
}
}
else{
echo "Could not insert cash mod setting category<br>";
$error = TRUE;
}
////////////////
$sql = "SELECT template FROM `" . TABLE_PREFIX . "templates` WHERE title = 'postbit'";
if($result = $db->query($sql, 1)){
echo "Found postbit template in " . TABLE_PREFIX . "templates table<br>";
$row = $db->fetch_array($result);
$template = $row['template'];
$before_string = '$lang->postbit_posts $post[postnum]<br />';
$replace_string = "\n" . '$settings[cash_mod_name] $post[cash]<br />';
$str_pos = strpos($template, $before_string);
if($str_pos){
$template_finish = str_replace($before_string, $before_string . $replace_string, $template);
if($template_finish){
echo "Was able to find and insert cash mod value in postbit<br/>";
$sql_template = "UPDATE `" . TABLE_PREFIX . "templates` SET template='" . $template_finish . "' WHERE title = 'postbit'";
if($result = $db->query($sql_template, 1)){
echo "Updated " . TABLE_PREFIX . "templates table.<br/>";
}
else{
echo "Could not update " . TABLE_PREFIX . "templates table.<br/>";
$error = TRUE;
}
}
else{
echo "Was unable to find or insert cash mod name in postbit<br/>";
$error = TRUE;
}
}
else{
echo "Could not locate right place to insert currency<br/>";
$error = TRUE;
}
}
else{
echo "Could not find postbit template in " . TABLE_PREFIX . "templates table<br>";
$error = TRUE;
}
////////////////
////////////////
if(!$error){
echo '<strong><font size="+2">The database has been successfully changed.</font></strong>';
}
else{
echo "<em>You have encountered errors whilst trying to update the database.</em>";
}
if($_GET['lock'] == 1){
echo '<p> </p>';
echo '<p> </p>';
echo "Would you like to open your forums again?<br/>";
echo '<a href="' . $file_name . '?fin=1">Yes</a><br/>';
echo '<a href="' . $file_name . '?fin=0">No</a><br/>';
}
else{
echo '<p> </p>';
echo "Thank you for installing " . $mod_name . "!<br/>";
exit();
}
?>
</body>
</html>
I had it in the wrong directory. But now I'm getting the errors I just posted >>;
