Hello

September 10, 2010, 09:51:03 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?
Login with username, password and session length
What sNews Is: - sNews is a simple, basic, customizable CMS tool suitable for developers with beginner-to-advanced PHP skills. It is also useful to have a good working knowledge of how to work with, set up and manage MySQL databases. sNews is not - geared towards the end-user who knows little or nothing about building and developing PHP-MySQL based websites.
News: Try sNews 1.7 DEMO
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: sNews 1.7 for SQLite  (Read 210 times)
rugby
Newbie
*

Karma: 1
Posts: 1


« on: July 08, 2010, 01:36:13 PM »

You can download sNews 1.7 rewritten using PDO for SQLite here:

http://rapidshare.com/files/405690663/snews17-sqlite.rar
Logged
skian
Jr. Member
**

Karma: 6
Posts: 69


« Reply #1 on: July 08, 2010, 02:39:31 PM »

GREAT

Just two questions
  • why is the connect_to_db function disabled ? it should be something like
Code:
// CONNECT TO DATABASE
function connect_to_db() {
global $db;
$db = new PDO('sqlite:database/snews.db');
vacuum();
}
  • have you tested it back with pdo + mysql


EDIT : I don't think the vacuum function does anything. the condition $dif_time > 86400 is never met due to the other function (update_articles) reseting the counter every 10 sec.
« Last Edit: July 08, 2010, 05:04:07 PM by skian » Logged
Sven
ULTIMATE member
******

Karma: 76
Posts: 1861


Chasing MY bugs!


WWW
« Reply #2 on: July 09, 2010, 01:23:16 PM »

Oh oh...
Who will maintain this?
Logged

Pages: [1]
  Print  
 
Jump to:  

English Steel 1.6 © Saxon North Technologies
Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!