Various RevCMS Fixes

Here're various fixes for RevCMS. Fixes noted untested are not tested, and therefore needs response from you to tell if they work or not. Those tested are based on the Mango theme, but the process would be similar or probably the same for other skins.

1. "Unknown column 'seckey' in 'field list'" registration error fix:
Execute SQL in phpMyAdmin or Navicat.

Code:

ALTER TABLE `users` ADD `seckey` VARCHAR(999)

2. Fix for "Incorrect integer value: '' for column 'author' at row 1" news posting error:
Select cms_news table> Design Table in Navicat> Change type of "author" field to varchar.

3. Default figure code:

Code:

hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100

4. Client popup:
In me.php, replace

Code:

<center><a href="api.php" onclick="mango.client.popup(); return false;">Enter {hotelName} Hotel</a></center>

with

Code:

<center><a href="api.php" target="ClientWndw" onclick="window.open('api.php','ClientWndw','width=980,height=597');return false;">Enter {hotelName} Hotel</a></center>

5. Get bans fix (untested):
In hk\banlist.php, replace get bans code with

Code:

<?php
$getBans = mysql_query("SELECT * FROM bans");
 
while(($ban = mysql_fetch_array($getBans))) 
{
echo "<tr><td>" . $ban['value'] ."</td><td>" . $ban['reason'] . "</td><td>" . $ban['added_by'] . "</td><td><a href='?url=banlist&unban=" . $ban['id'] . "'><b>Unban</b></a></td></tr>";
}
?>

6. Account per IP:
In /app/class.users, change value 1 in the following code to desired number of accounts.

Code:

if($engine->num_rows("SELECT * FROM users WHERE ip_reg = '" . $_SERVER['REMOTE_ADDR'] . "'") == 1)

7. Unban fix (untested):
In hk/banlist.php, replace

Code:

<table width="100%">
<tr><td><b>Username</b></td><td><b>Reason</b></td><td><b>Banned by</b></td><td><b>Value</b></td></tr>
<?php
while($two = mysql_fetch_array(mysql_query("SELECT * FROM bans"), MYSQL_ASSOC))
{
echo "<tr><td>" . $two['value'] ."</td><td>" . $two['reason'] . "</td><td>" . $two['added_by'] . "</td><td><a href='?url=banlist&unban=" . $two['id'] . "'><b>Unban</b></a></td></tr>";
}
 
?>

with

Code:

<table width="100%">
<tr><td><b>Username</b></td><td><b>Reason</b></td><td><b>Banned by</b></td><td><b>Expires</b></td><td><b>Value</b></td></tr>
<?php
$getBans = mysql_query("SELECT * FROM bans");
 
while(($ban = mysql_fetch_array($getBans)))
{
echo "<tr><td>" . $ban['value'] ."</td><td>" . $ban['reason'] . "</td><td>" . $ban['added_by'] . "</td><td>" . @date("d-m-Y H:i", $ban['expire']) . "</td><td><a href='?url=banlist&unban=" . $ban['id'] . "'><b>Unban</b></a></td></tr>";
}
?>

ASE should be working fine at this point. Now in app/class.core.php, replace

Code:

if($k == 'balist') 

with

Code:

if($k == 'banlist') 

Lastly perform a :update_bans command in hotel to take effect.

8. Edit User Account Script Name Case Fix (untested):
In hk/edit.php, find

Code:

<input type="username" value="<?php echo $_POST['l_username']; ?>" style="width: 95%;" />

change

Code:

<?php echo $_POST['l_username']; ?>

to

Code:

<?php echo $two['username']; ?>

9. News Fix:
In hk/news2.php, replace line 66 with

Code:

    mysql_query("INSERT INTO cms_news (title,shortstory,longstory,published,image,author, campaign, campaignimg) VALUES ('" . filter($_SESSION["title"]) . "', '" . filter($_SESSION["shortstory"]) . "', '" . ($_SESSION["longstory"]) . "', '" . time() . "', '" . filter($_POST["topstory"]) . "', '" . filter($author) . "', 0, 'default')") or die(mysql_error());"

This is pretty much everyone thread on here that has fixes for rev put into one.

Honestly I don't think this is needed plus give credits to the original post.

For example my post.....

Helps, But you should have added like a fix for giving users VIP, and such.

I think this is pretty useful, excellent work!

Thought I seen this on Rz. NO CREDITS AMG.
----
Thanks for bringing it here anyways.

I think its the same person on (forum name here)

can some one please tell me how to get housekeeping, my button is there, but it doesnt link to the housekeeping

If you're using ASE;

{url}/ASE/login

Example;

habbo.com/ASE/login

when i change the pop-up code in my me.php, my whole homepage gets messt up i use the mango theme ?

It shouldn't mess anything up. And yes, it's tested with Mango and worked.

Thank's. Good for noobs who can't figure it out themselves

The Unban Thing Doesnt Work D;