I'm trying to install UserSpice and am having problems with the database part of the install - namely, I already have a table called settings. Is there an easy way to add a prefix to all the tables?

Hi guys,

I'm trying to implement User Spice for a webpage that is using MS SQL to store data. I'm wondering if it is possible to use User Spice with MS SQL?

Thanks!

Installs fine using XAMPP, but I get the following error with IIS Express:

Quote:PHP Parse error: syntax error, unexpected end of file, expecting ')' in \users\init.php on line 26

I'm not sure if this is actually a bug or something I caused. My top bar (containing my logo and menus) is hiding the content of my page at certain widths of screen as I test responsive design.

Please see http://www.imdoingok.today to see what it looks like...

Just ran into a problem, by trying to login a user, which is not email_verified (Require User to Verify Their Email? is turned on in my case).
I was redirected to $us_url_root.'verify.php'. This site does not exist. verify.php is located in $us_url_root.'users/verify.php'

The reason in my case for this wrong redirection is that I changed the custom_login_script.php and instead of redirecting the user to $us_url_root.'users/account.php' I redirected the user to $us_url_root.'index.php'. Now this index.php calls

Hi
Frist of all , I want to thank you for creating this wonderful programme. I'm beginner to this and I have watched your videos but those described the features in the earlier version. Can you tell me how can find a manual for 4.1???
I want to create pages with limited access, Navigation menu and also charts as describe in the video
Thank you

I was having difficulty figuring out what was wrong with my email configuration. Everything seemed fine, but I kept getting the (someone unhelpful) "Email ERROR" message whenever I tried to test my email setup.

I modified the email setup test to allow for setting a debug level and then modified the helpers.php so that it would respond to the presence of $_POST['SMTPDebug'] to turn on debugging.

NOTE: This should *not* be turned on in a development environment! It opens significant security holes. But if you are struggling with an email configuration problem it can be invaluable for you...

(The checkbox to turn on the exceptions looks kind of gross - I'm still trying to figure out how to style things nicely within this framework...)

Here's the patch file:

diff -bcr ../UserSpice41/users/email_test.php ./users/email_test.php
*** ../UserSpice41/users/email_test.php 2016-08-15 15:51:50.062520500 +0200
--- ./users/email_test.php 2016-08-23 18:35:35.767763900 +0200
***************
*** 27,46 ****
Redirect::to('account.php');
}
?>
- <?php
- //PHP Goes Here!
-
- $query = $db->query("SELECT * FROM email");
- $results = $query->first();
-
- if(!empty($_POST)){
- $to = $_POST['test_acct'];
- $subject = 'Testing Your Email Settings!';
- $body = 'This is the body of your test email';
- $mail_result=email($to,$subject,$body);
- }
-
- ?>
<div id="page-wrapper">

<div class="container-fluid">
--- 27,32 ----
***************
*** 61,79 ****
It's a good idea to test to make sure you can actually receive system emails before forcing your users to verify theirs. <br><br>
<?php
if (!empty($_POST)){
if($mail_result){
echo 'Mail sent successfully<br/>';
}else{
echo 'Mail ERROR<br/>';
}
-
}
-
?>

<form class="" name="test_email" action="email_test.php" method="post">
<label>Send test to (Ideally different than your from address):
<input required size='50' class='form-control' type='text' name='test_acct' value='' /></label>

<label> </label>
<input class='btn btn-primary' type='submit' value='Send A Test Email' class='submit' />
--- 47,85 ----
It's a good idea to test to make sure you can actually receive system emails before forcing your users to verify theirs. <br><br>
<?php
if (!empty($_POST)){
+ /* these appear to be unused
+ $query = $db->query("SELECT * FROM email");
+ $results = $query->first();
+ */
+
+ $to = $_POST['test_acct'];
+ $subject = 'Testing Your Email Settings!';
+ $body = 'This is the body of your test email';
+ $mail_result=email($to,$subject,$body);
+
+ if (isset($_POST['SMTPDebug']))
+ echo "<br />\n";
if($mail_result){
echo 'Mail sent successfully<br/>';
}else{
echo 'Mail ERROR<br/>';
}
}
?>

<form class="" name="test_email" action="email_test.php" method="post">
<label>Send test to (Ideally different than your from address):
<input required size='50' class='form-control' type='text' name='test_acct' value='' /></label>
+ <label><input class='form-control' type="checkbox" name="PHPMailerExceptions" />Report Exceptions</label>
+ <label>Debug Level:
+ <select class='form-control' name="SMTPDebug">
+ <option value=0 selected="selected">Debugging OFF</option>
+ <option value=1>Client</option>
+ <option value=2>Client + Server</option>
+ <option value=3>Client + Server + Connection</option>
+ <option value=4>All messages</option>
+ </select>
+ </label>

<label> </label>
<input class='btn btn-primary' type='submit' value='Send A Test Email' class='submit' />
diff -bcr ../UserSpice41/users/helpers/helpers.php ./users/helpers/helpers.php
*** ../UserSpice41/users/helpers/helpers.php 2016-08-15 15:51:52.583452900 +0200
--- ./users/helpers/helpers.php 2016-08-23 18:14:53.755615900 +0200
***************
*** 108,116 ****
$smtp_password=$results->email_pass;
$smtp_transport=$results->transport;

! $mail = new PHPMailer;

//$mail->SMTPDebug = 3; // Enable verbose debug output

$mail->isSMTP(); // Set mailer to use SMTP
$mail->Host = $smtp_server; // Specify main and backup SMTP servers
--- 108,119 ----
$smtp_password=$results->email_pass;
$smtp_transport=$results->transport;

! $exceptions = (isset($_POST['PHPMailerExceptions']) ? $_POST['PHPMailerExceptions'] : false);
! $mail = new PHPMailer($exceptions);

//$mail->SMTPDebug = 3; // Enable verbose debug output
+ if (isset($_POST['SMTPDebug']))
+ $mail->SMTPDebug = $_POST['SMTPDebug'];

$mail->isSMTP(); // Set mailer to use SMTP
$mail->Host = $smtp_server; // Specify main and backup SMTP servers

I got tired of starting every project by going through a whole raft of coding just to get the users and groups and registration setup done. I stumbled across UserSpice when I was trying to put together a system to let people who live in dangerous parts of the world check in on a regular basis so their team leaders know they are OK. So far it's been a fun journey - sure saved me a lot of hassle and made a nicer-looking web-site than I would have done had I been doing it from scratch...

Thanks!

I'd like to attach patch files in the "Modifications and Hackery" forum rather than pasting it as text and making someone else figure out how to make the patch file.

Any way of doing attachments in the forums?

Hi,

I've added some Permission Levels and wanted to use these permissions to allow or disallow users access to sites/functions etc. I found that the permissions are saved in the database in the table "user_permission_matches".
So, is it the way to have access to the permissions to query this table, like