For the email verification, see the Tutorial on the Data Bridge support page for Creating a double opt in registration system:
For user level authentication, there is a tutorial in the Archived Documentation section of the Security Assist Support page. It was written For Security Assist v1, but the concept is exactly the same in data Bridge / Security Assist v2.
"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'l= '-1' AND users.UserRandomString <> '0'' at line 1"
seems to indicate that the where clause uses "!=" for a not equals condition where it should be "<>" for mysql.
Fatal error: Call to a member function GetContent() on a non-object in D:\hosting\9062558\html\v2\products_results.php on line 6
will happen on pages that use eCart where the GetContent() function is before the require_once() line to include the cart object.
for dynamic images, makes sure you include the path to the image folder in the img tag:
<img src="path/to/images/<?php echo $row_recordsetName['columnName'] ?>" />