Nuke Forum
Log in, or register! We only allow guests to view forums.


RPG Gaming, Habbo Hotel, Minecraft and more games you will find suitable for your needs.
 
HomeCalendarFAQSearchMemberlistUsergroupsRegisterLog in
Top posters
berurbi (169)
 
Joey (22)
 
Snicker (7)
 
Enrique (7)
 
kielexin (4)
 
MeowLulz (1)
 
Latest topics

Share | 
 

 Various RevCMS Fixes

View previous topic View next topic Go down 
AuthorMessage
Joey
Founder
Founder
avatar

Posts : 22
Points : 53
Reputation 12
Join date : 2012-07-19
Location : Behind You.

PostSubject: Various RevCMS Fixes   Wed Jul 25, 2012 3:54 am

These are various RevCMS fixes, most of these are Tested, keep that in mind, if something goes wrong, you're doing something wrong, all of these work perfectly.

1.
Users cannot register "'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 ( Also found in Enrique's tutorial )
Code:
hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100

4.
Client pop-up
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)

Replace the 1 with 2,3,4,5,6,7,8, whatever number you would like.

7.
Unban fix:
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']; ?>

Use notepad ++ for this;
News Fix (HTML phrasing):
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());

_________________
'Til I Die
Back to top Go down
View user profile http://nukeforum.forumotion.com
 
Various RevCMS Fixes
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» Skyrim Mod - *IMPORTANT MUST HAVE* - SSME - Skyrim Startup Memory Editor (Fixes Most/All CTDs)
» Fix for Patch Update: Tuesday March 01
» New MW3 update out today - great fixes
» ET Lag Fixes
» Useful links list

Permissions in this forum:You cannot reply to topics in this forum
Nuke Forum :: MMORPG Developments :: Habbo Hotel :: Habbo Tutorials :: Habbo Quality Tutorials-
Jump to: