Working great on mysql but now there is the need to build a website on a complete windows system. Windows server with PHP7 and MSSQL server.
Is there a posibility to change the DB connection from mysql into mssql.
mysqli_connect -> sqlsrv_connect, but since this the database connection is complete intergrated and difficult for a user to port to a new database.
It is not a great usergroup that uses PHP and MSSQL, but it would be nice if it would be possible with your tool.
Until my status of today this is the best package for management and usercontrol with greater users and different groups.
Waiting for your positive feedback and upgrade.

Hi,
transfer the websire to a new windows system, with php7 and Microsoft SQL server.
Is there already a configuration for UserSpice41 that can be used on this enviroment.
mysqli_connect must be changed into sqlsrv_connect.

Could you make it transparant for the database version.
We like your functionality for management and user, usergroups control.

I am in a situation where I have the same data which must be presented in various different ways.

Has there been discussion about the best way to structure US so as to implement a lite version of MVC or at least separating the "view" from the "data collection"?

Basically I want the same SQL queries to be used for 2 different views. I could implement the 2 different views in a single script with a lot of complicated and hard-to-read conditionals or I could "require" the query stuff from a separate script but both seem forced and awkward...

The current definition of

When I go to users/admin_user.php and mark a user to delete, I get an error message that $validate variable doesn't exist.

I have patched the code - here's a copy on pastebin:

http://pastebin.com/YQzNN58E

While I was in there I fixed some indentation issues just for presentation of the code - makes it more readable and standard with the rest of US.

(I'd like to put a little border around the "create new user" section, but I'm still working on what CSS from bootstrap looks best there - there may be a second version in a bit...)

Hi, I would like to say a big thank you for such a wonderful project! Very nicely thought out and saves me months if not weeks of work.
I've installed the latest version 4.1.4b and initial testing worked extremely well.
However when I changed the admin email address, the system breaks down and sends me to a not found page with the
message:
The requested URL /userManagement/users/users/verify.php was not found on this server.
(where userManagement is the userSpice installation.)

I can't even log in!

I searched the forum and notice others are having similar (if not the same) problem.

Anyway, after much digging around, I found the bug in the verify.php:

verify.php
if($user->isLoggedIn()){
$user->logout();
Redirect::to('users/verify.php');
}

Simply change it to:

if($user->isLoggedIn()){
$user->logout();
Redirect::to('verify.php');
}

and you should be good to go. Note that if error still exist, close browser and log in again.
Not sure if this is the proper fix, please advice.

I was getting ready to write a function to check if the current user had a given permission level and I came across this function on line 419 of us_helpers.php:

Please see this paste:

http://pastebin.com/hXtASj6S

If the value is not found in Config then we shouldn't get back the whole $_GLOBALS['config'] - instead we should get a false return value so we can handle that and provide an appropriate default.

Userspice 4.1
I'm doing local development using IIS7 Express. Installs fine using XAMPP, but I get the following error with IIS Express:
PHP Parse error: syntax error, unexpected end of file, expecting ‘)’ in \users\init.php on line 26
I have made sure users/init.php is writable.
Thanks!

Here's a patch:

http://pastebin.com/0rhnxLB7

This allows someone to add Config::get('mysql/options') and control the options used for the PDO driver.

Specifically I have set mine to this: