------------------------------------------------------------
revno: 887
committer: Roger Martin <[email protected]>
branch nick: aikiframework
timestamp: Tue 2011-07-19 22:24:25 +0200
message:
only active user can login
modified:
src/libs/membership.php
src/sql/CreateTables.sql
src/sql/InsertVariable-in.sql
--
lp:aikiframework
https://code.launchpad.net/~aikiframework-devel/aikiframework/trunk
Your team Aiki Framework Developers is subscribed to branch lp:aikiframework.
To unsubscribe from this branch go to
https://code.launchpad.net/~aikiframework-devel/aikiframework/trunk/+edit-subscription
=== modified file 'src/libs/membership.php'
--- src/libs/membership.php 2011-07-06 21:03:32 +0000
+++ src/libs/membership.php 2011-07-19 20:24:25 +0000
@@ -171,7 +171,12 @@
session_start();
}
- $get_user = $db->get_row("SELECT * FROM aiki_users WHERE username='$username' AND password='$password' LIMIT 1");
+ $get_user = $db->get_row(
+ "SELECT * FROM aiki_users".
+ " WHERE username='$username' ".
+ " AND password='$password' ".
+ " AND is_active=1" .
+ " LIMIT 1");
if($get_user){
$host_name = $_SERVER['HTTP_HOST'];
$user_ip = $this->get_ip();
=== modified file 'src/sql/CreateTables.sql'
--- src/sql/CreateTables.sql 2011-07-14 21:06:10 +0000
+++ src/sql/CreateTables.sql 2011-07-19 20:24:25 +0000
@@ -183,7 +183,7 @@
maillist int(1) NOT NULL,
logins_number int(11) NOT NULL,
randkey varchar(255) NOT NULL,
- is_active int(5) NOT NULL,
+ is_active int(5) NOT NULL default '1',
PRIMARY KEY (userid),
UNIQUE KEY username (username)
) ENGINE=MyISAM CHARSET=utf8;
=== modified file 'src/sql/InsertVariable-in.sql'
--- src/sql/InsertVariable-in.sql 2011-07-07 04:47:33 +0000
+++ src/sql/InsertVariable-in.sql 2011-07-19 20:24:25 +0000
@@ -35,8 +35,8 @@
-- ------------------------------------------------------
INSERT IGNORE INTO `aiki_users` (`userid`, `username`, `full_name`, `country`, `sex`, `job`, `password`, `usergroup`, `email`, `avatar`, `homepage`, `first_ip`, `first_login`, `last_login`, `last_ip`, `user_permissions`, `maillist`, `logins_number`, `randkey`, `is_active`) VALUES
-(1, 'guest', 'guest', '', '', '', '', 3, '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 0, 0, '', 0),
-(2, '@ADMIN_USER@', '@ADMIN_NAME@', '', '', '', '@ADMIN_PASS@', 1, '@ADMIN_MAIL@', '', '', '', '', '', '', '', 0, 0, '', 0);
+(1, 'guest', 'guest', '', '', '', '', 3, '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '', 0, 0, '', 1),
+(2, '@ADMIN_USER@', '@ADMIN_NAME@', '', '', '', '@ADMIN_PASS@', 1, '@ADMIN_MAIL@', '', '', '', '', '', '', '', 0, 0, '', 1);
-- ------------------------------------------------------
_______________________________________________
Mailing list: https://launchpad.net/~aikiframework-devel
Post to : [email protected]
Unsubscribe : https://launchpad.net/~aikiframework-devel
More help : https://help.launchpad.net/ListHelp
