Reply to thread

Message

<blockquote data-quote="Muffmuncher" data-source="post: 73654" data-attributes="member: 11381">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.&nbsp;1. &quot;Unknown column 'seckey' in 'field list'&quot; registration error fix:Execute SQL in phpMyAdmin or Navicat.[code]ALTER TABLE `users` ADD `seckey` VARCHAR(999)[/code]&nbsp;2. Fix for &quot;Incorrect integer value: '' for column 'author' at row 1&quot; news posting error:Select cms_news table&gt; Design Table in Navicat&gt; Change type of &quot;author&quot; field to varchar.&nbsp;3. Default figure code:[code]hd-180-1.ch-210-66.lg-270-82.sh-290-91.hr-100[/code]&nbsp;4. Client popup:In me.php, replace [code]&lt;center&gt;&lt;a href=&quot;api.php&quot; onclick=&quot;mango.client.popup(); return false;&quot;&gt;Enter {hotelName} Hotel&lt;/a&gt;&lt;/center&gt;[/code] with [code]&lt;center&gt;&lt;a href=&quot;api.php&quot; target=&quot;ClientWndw&quot; onclick=&quot;window.open('api.php','ClientWndw','width=980,height=597');return false;&quot;&gt;Enter {hotelName} Hotel&lt;/a&gt;&lt;/center&gt;[/code]&nbsp;5. Get bans fix (untested):In hk\banlist.php, replace get bans code with[code]&lt;?php$getBans = mysql_query(&quot;SELECT * FROM bans&quot;);&nbsp;while(($ban = mysql_fetch_array($getBans))) {echo &quot;&lt;tr&gt;&lt;td&gt;&quot; . $ban['value'] .&quot;&lt;/td&gt;&lt;td&gt;&quot; . $ban['reason'] . &quot;&lt;/td&gt;&lt;td&gt;&quot; . $ban['added_by'] . &quot;&lt;/td&gt;&lt;td&gt;&lt;a href='?url=banlist&amp;unban=&quot; . $ban['id'] . &quot;'&gt;&lt;b&gt;Unban&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;}?&gt;[/code]&nbsp;6. Account per IP:In /app/class.users, change value 1 in the following code to desired number of accounts.[code]if($engine-&gt;num_rows(&quot;SELECT * FROM users WHERE ip_reg = '&quot; . $_SERVER['REMOTE_ADDR'] . &quot;'&quot;) == 1)[/code]&nbsp;7. Unban fix (untested):In hk/banlist.php, replace [code]&lt;table width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Username&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Reason&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Banned by&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Value&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;?phpwhile($two = mysql_fetch_array(mysql_query(&quot;SELECT * FROM bans&quot;), MYSQL_ASSOC)){echo &quot;&lt;tr&gt;&lt;td&gt;&quot; . $two['value'] .&quot;&lt;/td&gt;&lt;td&gt;&quot; . $two['reason'] . &quot;&lt;/td&gt;&lt;td&gt;&quot; . $two['added_by'] . &quot;&lt;/td&gt;&lt;td&gt;&lt;a href='?url=banlist&amp;unban=&quot; . $two['id'] . &quot;'&gt;&lt;b&gt;Unban&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;}&nbsp;?&gt;[/code] with [code]&lt;table width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td&gt;&lt;b&gt;Username&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Reason&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Banned by&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Expires&lt;/b&gt;&lt;/td&gt;&lt;td&gt;&lt;b&gt;Value&lt;/b&gt;&lt;/td&gt;&lt;/tr&gt;&lt;?php$getBans = mysql_query(&quot;SELECT * FROM bans&quot;);&nbsp;while(($ban = mysql_fetch_array($getBans))){echo &quot;&lt;tr&gt;&lt;td&gt;&quot; . $ban['value'] .&quot;&lt;/td&gt;&lt;td&gt;&quot; . $ban['reason'] . &quot;&lt;/td&gt;&lt;td&gt;&quot; . $ban['added_by'] . &quot;&lt;/td&gt;&lt;td&gt;&quot; . @date(&quot;d-m-Y H:i&quot;, $ban['expire']) . &quot;&lt;/td&gt;&lt;td&gt;&lt;a href='?url=banlist&amp;unban=&quot; . $ban['id'] . &quot;'&gt;&lt;b&gt;Unban&lt;/b&gt;&lt;/a&gt;&lt;/td&gt;&lt;/tr&gt;&quot;;}?&gt;[/code]&nbsp;ASE should be working fine at this point. Now in app/class.core.php, replace [code]if($k == 'balist') [/code] with [code]if($k == 'banlist') [/code]&nbsp;Lastly perform a :update_bans command in hotel to take effect.&nbsp;8. Edit User Account Script Name Case Fix (untested):In hk/edit.php, find [code]&lt;input type=&quot;username&quot; value=&quot;&lt;?php echo $_POST['l_username']; ?&gt;&quot; style=&quot;width: 95%;&quot; /&gt;[/code] change [code]&lt;?php echo $_POST['l_username']; ?&gt;[/code] to [code]&lt;?php echo $two['username']; ?&gt;[/code]&nbsp;9. News Fix:In hk/news2.php, replace line 66 with [code]&nbsp; &nbsp; mysql_query(&quot;INSERT INTO cms_news (title,shortstory,longstory,published,image,author, campaign, campaignimg) VALUES ('&quot; . filter($_SESSION[&quot;title&quot;]) . &quot;', '&quot; . filter($_SESSION[&quot;shortstory&quot;]) . &quot;', '&quot; . ($_SESSION[&quot;longstory&quot;]) . &quot;', '&quot; . time() . &quot;', '&quot; . filter($_POST[&quot;topstory&quot;]) . &quot;', '&quot; . filter($author) . &quot;', 0, 'default')&quot;) or die(mysql_error());&quot;[/code]</blockquote>

[QUOTE="Muffmuncher, post: 73654, member: 11381"] 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)[/code] 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[/code] 4. Client popup: In me.php, replace [code]<center><a href="api.php" onclick="mango.client.popup(); return false;">Enter {hotelName} Hotel</a></center>[/code] 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>[/code] 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'] . "'>Unban</a></td></tr>"; } ?>[/code] 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)[/code] 7. Unban fix (untested): In hk/banlist.php, replace [code]<table width="100%"> <tr><td>Username</td><td>Reason</td><td>Banned by</td><td>Value</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'] . "'>Unban</a></td></tr>"; } ?>[/code] with [code]<table width="100%"> <tr><td>Username</td><td>Reason</td><td>Banned by</td><td>Expires</td><td>Value</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'] . "'>Unban</a></td></tr>"; } ?>[/code] ASE should be working fine at this point. Now in app/class.core.php, replace [code]if($k == 'balist') [/code] with [code]if($k == 'banlist') [/code] 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%;" />[/code] change [code]<?php echo $_POST['l_username']; ?>[/code] to [code]<?php echo $two['username']; ?>[/code] 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());"[/code] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members