Joey Founder
Posts : 22 Points : 53 12 Join date : 2012-07-19 Location : Behind You.
| Subject: 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()); | |
|