<?xml version="1.0" encoding="UTF-8"?>
 		<rss version="2.0"><channel>
 		<title><![CDATA[sNews]]></title>
 		<description><![CDATA[Articles]]></description>
 		<link>http://snews.engcivil.net/</link>
 		<copyright><![CDATA[Copyright sNews]]></copyright>
 		<generator>sNews CMS</generator><item>
			<title><![CDATA[Problems starting sNews]]></title>
			<description>
				<![CDATA[
				<p>After change your configurations, and sNews is not working:</p>
<ul>
 <li>Download php and appache testing <a href="http://snews.engcivil.net/downloads/test.zip" title="testing php and appache 'mod_rewrite' enabled">here</a></li>

</ul>
				]]>
			</description>
			<pubDate>Wed, 16 Sep 2009 12:20:03 +0000</pubDate>
			<link>http://snews.engcivil.net/help/problems-starting-snews/</link>
			<guid>http://snews.engcivil.net/help/problems-starting-snews/</guid>
			</item><item>
			<title><![CDATA[Super DB Backup]]></title>
			<description>
				<![CDATA[
				<p><strong>Note:</strong><br />
First I want to Thank you to Frederic Cloquell (Bramsyur) - <a href="http://snewscms.com/forum/index.php?topic=4598.msg30863#msg30863" title="backup your snews DB from within the admin section ">sNews1.6 mod</a>.</p>

<p><strong>With this mod you can do:</strong>
<br />
- Backup your database and will be sent a copy to your e-mail<br />
- Restore your database when it was damage<br />
- Apply a cron job to save database everytime you want</p>


<h2><strong>Instructions:</strong></h2><br />
<h3>1-Back up your files and snews.php</h3><br />
<h3>2-Add this lines to your lang file (EN.php)</h3>[php]#BACKUP
 $l['t_dir_backup'] = 'Folder to backup files';
 $l['t_dbbackup'] = 'Database Backup';
 $l['t_dbbackup_info'] = 'Please, verify or moddify the e-mail that your want to be used to get the database backup file.<br />';
 $l['t_dbbackup_name'] = 'Database name';
 $l['t_dbbackup_email'] = 'E-mail to send your created backup';
 $l['t_backup'] = 'Backup now';
 $l['t_system_mail'] = 'System DB-Backup';
 $l['t_dbb_subject'] = 'MySQL Backup';
 $l['t_dbb_message'] = 'MySQL Backup created successfully.';
 $l['db_backup_directory'] = 'Currently Backup Files';
 $l['db_no_files_found'] = 'No files found!';
 $l['dbbackup'] = 'Admin MySQL Backup';
[/php]<br />

<h3>3-Edit configuration on "dbbackup.php" </h3>
First edit with correct information to work perfectly[php]
#DATABASE CONFIGURATION
function db2($variable) {
	$db = array(
		'dbhost' 	=> 'localhost', // MySQL host
		'dbname' 	=> 'database',
		'dbuname' 	=> 'username', // Database Username
		'dbpass' 	=> 'password', // Database password
		'prefix' 	=> '' // Table prefix
	); return $db[$variable];
}[/php]<br />
Next edit constants
[php]// CONSTANTS
define('SECURE_ID','12345');
define('USERNAME', 'admin');
define('PASSWORD',md5('test').date('d-m-YH'));
define('_PRE',db2('prefix'));
define('pw','password'); // plain password to auto backup
[/php]

<p>After this save file and copy to your root domain or where you have snews.php</p><br />

<h3>4-Create backups folder</h3>
<p>Change permitions to chmod 777
<br />If you use coreftp make a right click on backups folder and choose properties, like this pictures</p>

<a href="http://snews.engcivil.net/imagens/c01.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c01.jpg" alt="coreftp" width="50px" /></a>
<a href="http://snews.engcivil.net/imagens/c02.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c02.jpg" alt="coreftp" height="70px" /></a>

<br /><br />

<h3>5-Update your database with phpMyAdmin</h3>
On your CPanel or other, choose phpMyAdmin:<br />
<a href="http://snews.engcivil.net/imagens/c04.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c04.jpg" alt="cpanel" height="70px" /></a><br />
Next copy this code to sql box and submit<br />
[php]INSERT INTO `settings` (name, value) VALUES ('dir_db', '');[/php]
<br />
<a href="http://snews.engcivil.net/imagens/c05.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c05.jpg" alt="cpanel" height="70px" /></a><br />
<br />
<h3>6-Open your snews.php</h3>
<strong>a) In line cat_listSEF add red text at end</strong>
<br />
if (_ADMIN) {$l['cat_listSEF'] .= ',administration...,admin_groupings,dbbackup';}
<br /><br />
<strong>b) After this line add this line</strong>

[php]include_once('dbbackup.php');[/php]
<br />
<strong>c) Find first line and add 2nd line</strong>
on center function[php]case 'snews_settings': settings(); return; break;
 case 'dbbackup': dbbackup(); return; break;[/php]
<br />
<strong>d) In Administration function find first line and add 2nd line</strong>

[php]echo '<p><a href="snews_settings/">'.l('settings').'</a></p>
	<p><a href="dbbackup/" title="'.l('t_dbbackup').'">'.l('t_dbbackup').'</a></p>
	<p><a href="snews_files/">'.l('files').'</a></p>[/php]
<br />
<strong>e) In processing function</strong><br />
Add first line before "case 'hide'
[php]case 'dbbackup_start': case_dbbackup();	break;
 case 'hide':
 case 'show':[/php]
<br />
<strong>f) Save snews.php</strong><br /><br /><br />

<h3>7-For who wants to add cron job</h3><br />
<strong>a) First you need to know the correct command to add cron job</strong><br />
To help you I add function that tells everything you need.<br />
<br />
Upload your files to the server and put this on your browser<br />
<strong>http://www.your_domain.com/dbbackup.php?task=cron</strong>
<br /><br />
<strong>b) After know cron command</strong><br />You need to open dbbackup.php and erase this line<br />
[php]# AFTER TO GET THIS INFORMATION COMMENT OUT OR ERASE NEXT LINES
// START CRON INFO
if ($_GET['task']=='cron'){
	$path = $_ENV['DOCUMENT_ROOT'].$_SERVER['SCRIPT_NAME'];
	$path = str_replace('dbbackup.php','',$path);
	$cron = 'cd ''.$path.'' ; php -q 'dbbackup.php' '?' 'task=auto' 'pw='.pw.'' ; > /dev/null ;';
	echo $cron;
} 
// END CRON INFO[/php]<br />
Save and upload dbbackup.php again<br /><br />

<strong>c) Goto CPanel and open Cron Jobs</strong><br />
Add cron command on 3rd picture
<br />
<a href="http://snews.engcivil.net/imagens/c06.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c06.jpg" alt="cpanel" height="70px" /></a>

<a href="http://snews.engcivil.net/imagens/c07.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c07.jpg" alt="cpanel" height="70px" /></a>

<a href="http://snews.engcivil.net/imagens/c08.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c08.jpg" alt="cpanel" height="70px" /></a><br />
In last picture you can define what hour you want backup database<br /><br />

<h3>8-You can make a database manually, ignoring last step</h3><br />
<a href="http://snews.engcivil.net/imagens/c09.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c09.jpg" alt="cpanel" height="170px" /></a>

<a href="http://snews.engcivil.net/imagens/c10.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c10.jpg" alt="cpanel" height="170px" /></a><br /><br />

<h3>9-Recover a damage database</h3><br />
To recover you need to know your_password (constant pw), on dbbackup.php<br />
<strong>http://www.your_domain.com/dbbackup.php?task=recover&pw=your_password</strong><br />

<a href="http://snews.engcivil.net/imagens/c11.jpg" target="_blank"><img src="http://snews.engcivil.net/imagens/c11.jpg" alt="cpanel" height="170px" /></a><br />

<br />
<h3>10-Download </h3><br />
You can download dbbackup.zip <a href="http://snews.engcivil.net/downloads/dbbackup.zip" title="Download file">here</a>
				]]>
			</description>
			<pubDate>Tue, 07 Jul 2009 01:38:32 +0000</pubDate>
			<link>http://snews.engcivil.net/mods/super-db-backup/</link>
			<guid>http://snews.engcivil.net/mods/super-db-backup/</guid>
			</item><item>
			<title><![CDATA[sNews 1.6 Revolutions]]></title>
			<description>
				<![CDATA[
				<p>I want to share with you this "sNews 1.6 Revolutions" optimized (with some functions from sNews1.7).</p>


<p><a href="http://snews.engcivil.net/works/snews16_rev01.zip" title="Download">Download here V1.01</a><br />
<a href="http://snews.engcivil.net/works/snews16_rev02.zip" title="Download">Download here V1.02</a></p>

<p>I change almost all functions to reduce sql calls, and keep sNews 1.6 as simple as possible.</p>


<strong>This version I use:</strong><br />
- Some functions from sNews1.7<br />
- Global variables<br />
- Global queries (see startup and title function)<br />
- get_id was removed<br />
- Add Ghassem Tofighi's timing mod<br />
- Add new mod for comments to avoid spam<br />
<br />
Joost, thank you for the tips.<br /><br />

Fun use this package with some modifications, please see this <a href="http://snewscms.com/forum/index.php?topic=8014.msg57045#msg57045" title="Revolutions from Fun65">post</a><br /><br />
				]]>
			</description>
			<pubDate>Tue, 02 Dec 2008 14:23:28 +0000</pubDate>
			<link>http://snews.engcivil.net/packs/snews16/snews-16-revolutions/</link>
			<guid>http://snews.engcivil.net/packs/snews16/snews-16-revolutions/</guid>
			</item><item>
			<title><![CDATA[List]]></title>
			<description>
				<![CDATA[
				<h2>LEARN</h2>

<p><a href="http://snews.engcivil.net/snews/getting-started/" title="Getting Started">Getting Started</a> (pre-installation considerations)<br />

Installing sNews (steps required to get sNews running)<br />
 
Troubleshooting/FAQ (common problems, fixes to error messages)<br />
 
Editor/Administrator's Guide (how to use the Admin panel) <br />

Designer's Guide (how to design sNews sites) <br />

Developer's Guide (how to create sNews mods or mod the existing code)<br />
 
Glossary of Terms (the meanings of some terms and phrases)<br /></p>




<h4><a href="http://snews.engcivil.net/snews/getting-started/" title="Getting Started">GET STARTED</a></h4><br />
<p>sNews requires PHP, MySQL and mod rewrite. If your server meets those requirements, get started and learn how to install sNews on your website in 3 easy steps.</p>



<h4><a href="http://snews.engcivil.net/learn/list/" title="LEARN">LEARN</a></h4><br />
<p>Browse through our help center and learn about template tags and how to simply create your own theme. Dig into sNews and customize it to behave the way you want.</p>


<br />
<p class="clearer"></p>


<h4><a href="http://snewscms.com/extend/" title="EXTEND">EXTEND</a></h4><br />
<p>sNews can be a simple blog tool and a full blown CMS. Customize it with addons, mods or play with different themes.</p>



<h4><a href="http://snewscms.com/forum/" title="DISCUSS">DISCUSS</a></h4><br />
<p>Talk about sNews on our Forum and share your expirience.</p>



				]]>
			</description>
			<pubDate>Tue, 21 Oct 2008 12:03:16 +0000</pubDate>
			<link>http://snews.engcivil.net/learn/list/</link>
			<guid>http://snews.engcivil.net/learn/list/</guid>
			</item><item>
			<title><![CDATA[Getting Started]]></title>
			<description>
				<![CDATA[
				<p>Before installing sNews on any server, there are a few important points to consider. Please take a few minutes and read over the pages listed in the Learn Basics box to the right. These will give you an overview of how the sNews CMS works, what the System Requirements are, and how you can enjoy the convenience of setting up and running sNews on your computer before uploading it to a host server.</p>


<p><strong>Installing sNews</strong><br /> 
Once you've decided whether you will start with a host server or local (on your computer) installation, it's time to head over to installing sNews!</p>


				]]>
			</description>
			<pubDate>Mon, 20 Oct 2008 21:33:37 +0000</pubDate>
			<link>http://snews.engcivil.net/snews/getting-started/</link>
			<guid>http://snews.engcivil.net/snews/getting-started/</guid>
			</item></channel></rss>