Various RevCMS Fixes

[Muffmuncher]

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.

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:

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

4. Client popup:
In me.php, replace

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

with

<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

<?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.

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

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

<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

<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

if($k == 'balist')

with

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

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

change

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

to

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

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

    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());"

 

[presto5]

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.....

While searching around I found the popup code in phoenixphp that works for rev for making the client popup.

Simple Replace:

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

With:

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

If this tutorial is unneeded in this section moderators feel free to move this.

 

[Bullethotel]

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

 

[Kryptos]

I think this is pretty useful, excellent work!

 

[geneocide]

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

 

[presto5]

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

 

[simone netten]

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

 

[Navigation]

If you're using ASE;

{url}/ASE/login

Example;

habbo.com/ASE/login

 

[simone netten]

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

 

[Muffmuncher]

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.

 

[Adidas]

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

 

[Flint]

The Unban Thing Doesnt Work D;