Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Various RevCMS Fixes

Status
Not open for further replies.
Junior Spellweaver
Joined
Nov 28, 2011
Messages
111
Reaction score
17
Here are various fixes for RevCMS. Fixes noted untested are not tested, and therefore need verfication. Those tested are based on the Mango theme, but the process will 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 (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());


.. don't thank me just yet, this is just a compilation of works from several others, only phrased for easy understandings. So full credits to the respective contributors.
 
Last edited:

Jax

C# Programmer
Joined
Dec 11, 2009
Messages
881
Reaction score
431
Nice tutorial! The best for the newbs :thumbup:

OFFTOPIC: zMatty your not in the zTeam with me and zJordan are you lol.
 
Divine Celestial
Loyal Member
Joined
Oct 2, 2011
Messages
858
Reaction score
272
Nice, but is it me is the ase slow? I am using iis..
 
Junior Spellweaver
Joined
Nov 28, 2011
Messages
111
Reaction score
17
Nice, but is it me is the ase slow? I am using iis..
Site loads slow at first instant, but once went through the process of entering, it all becomes quick. I'm experiencing the same as well, which I don't know the cause nor how to solve.
 
Newbie Spellweaver
Joined
Dec 4, 2011
Messages
48
Reaction score
2
Will be taking effect in my retro tomorrow! :)
 
Experienced Elementalist
Joined
Feb 19, 2012
Messages
287
Reaction score
23
I Don't Get It About This Part

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.
 
Junior Spellweaver
Joined
Nov 28, 2011
Messages
111
Reaction score
17
I Don't Get It About This Part

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.

Can't believe my thread is still alive :p as far as I could remember, it means there is this error that when you try to post a news article via ASE, you'll get an error message reading: "Incorrect integer value: '' for column 'author' at row 1". To fix it, you then need to do as stated.
 
Experienced Elementalist
Joined
Jun 3, 2012
Messages
224
Reaction score
55
Fix for a white client? :$:
 
scream my name
Joined
Jun 3, 2012
Messages
312
Reaction score
61
Great fixes, Definitely helped me when I was having trouble with RevCMS. Welldone.
 
Initiate Mage
Joined
Jul 24, 2012
Messages
2
Reaction score
0
HEY I NEED HELP WHEN EVER I CLICK ENTER HOTEL IT SAYS Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\thehabbos_api\class.validate.php on line 33
 
Newbie Spellweaver
Joined
Apr 20, 2011
Messages
26
Reaction score
2
HEY I NEED HELP WHEN EVER I CLICK ENTER HOTEL IT SAYS Fatal error: Call to undefined function curl_init() in C:\xampp\htdocs\thehabbos_api\class.validate.php on line 33
Change on Every Page the link: /api.php to /client ''without .php''! :)
 
Web Developer
Loyal Member
Joined
Nov 5, 2009
Messages
1,229
Reaction score
309
Some great fixes here, Nice tutorial.
 
Initiate Mage
Joined
May 26, 2013
Messages
2
Reaction score
0
(Unread:
Notice: Trying to get property of non-object in C:\xampp\htdocs\engine\lightcms.php on line 285
)
 
Last edited:
Status
Not open for further replies.
Back
Top