DBTS Admin Object/WB Login System **UPDATED June 19,2010***

[Patrik iden]

DBTS Admin MySql.
I'm using MySql.

[Navaldesign]

Then, most probably, the user you have created has no permissions to read / write in the database.

Check it, allow your Database user ALL permissions to the specific database, and test again.

Was the table automatically created ? or did you create it manually ?

[Patrik iden]

The table was created automaticly whit your extention.
How do i grant ALL permission to the databas?

[Navaldesign]

If th etable was created automatically, you probably have the correct permissions.

To check it, and see what permissions the user actually has, you need to go in your hosting account CPanel, Databases section, and ADD again the user to the database, the wizard should dislay the uer's permissions and there you can select "ALL".

[Patrik iden]

OK, i'l try that.

In youe extention, what is this?

latin1_german1_ci
latin1

[Navaldesign]

Yes, it is possible.

Please read this tutorial: http://www.wysiwygwebbuilder.com/customize_signup.html

In time, a DBTS Signup object will be available to make this task easier.

[Navaldesign]

Yes, the code is similar to that for editboxes-

MySQL Details: depends on your hosting account. Click on the Signup object properties
Usually:

Server = 'localhost'; (usually
Username = 'dbuser';
Password = 'dbpassword';
Database = 'dbname';
Table = 'users';

dbuser, dbpassword, dbname are the details of the MySQL database that you MUST create in your cpanel before this can work.

If you have converted the form, then the code is in the HTML box beside the form.
You will see the following code:


$mysql_server = 'localhost';
$mysql_username = 'dbuser';
$mysql_password = 'dbpassword';
$mysql_database = 'dbname';
$mysql_table = 'users';


Change the settings accordingto your real database details.

[Navaldesign]

Code: Select all

<?php
$error_message = "";
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
   $action = isset($_POST['action']) ? $_POST['action'] : '';
   $mysql_server = 'localhost';
   $mysql_username = 'removed';
   $mysql_password = 'removed';
   $mysql_database = 'removed';
   $mysql_table = 'removed';

   $success_page = './account_pending.php';

   if ($action == 'signup')
   {
      $newusername = $_POST['username'];
      $newemail = $_POST['email'];
      $newpassword = $_POST['password'];
      $confirmpassword = $_POST['confirmpassword'];
      $newfullname = $_POST['fullname'];
      $citytown = $_POST['citytown'];
      $gender = $_POST['gender'];
      $age_group = $_POST['age_group'];
      $colour_bow = $_POST['colour_bow'];
      if ($newpassword != $confirmpassword)
      {
         $error_message = 'Password and Confirm Password are not the same!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$]{1,50}$", $newusername))
      {
         $error_message = 'Username is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$]{1,50}$", $newpassword))
      {
         $error_message = 'Password is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$.' &]{1,50}$", $newfullname))
      {
         $error_message = 'Fullname is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$.' &]{1,50}$", $citytown))
      {
         $error_message = 'The entered City or Town name is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$.' &]{1,50}$", $gender))
      {
         $error_message = 'The selection is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$.' &]{1,50}$", $age_group))
      {
         $error_message = 'The selection is not valid, please check and try again!';
      }
      else
      if (!ereg("^[A-Za-z0-9_!@$.' &]{1,50}$", $colour_bow))
      {
         $error_message = 'The selection is not valid, please check and try again!';
      }
      if (!ereg("^.+@.+\..+$", $newemail))
      {
         $error_message = 'Email is not a valid email address. Please check and try again.';
      }
      if (empty($error_message))
      {
         $db = mysql_connect($mysql_server, $mysql_username, $mysql_password);
         mysql_select_db($mysql_database, $db);
         $sql = "SELECT username FROM ".$mysql_table." WHERE username = '".$newusername."'";
         $result = mysql_query($sql, $db);
         if ($data = mysql_fetch_array($result))
         {
            $error_message = 'Username already used. Please select another username.';
         }
      }
      if (empty($error_message))
      {
         $crypt_pass = md5($newpassword);
         $sql = "INSERT `".$mysql_table."` (`username`, `password`, `fullname`, `email`, `active`, `citytown`, `gender`, `age_group`, `colour_bow`) VALUES ('$newusername', '$crypt_pass', '$newfullname', '$newemail', 1, '$citytown', '$gender', '$age_group', '$colour_bow')";
         $result = mysql_query($sql, $db);
         mysql_close($db);
         $mailto = $newemail;
         $subject = 'New Account';
         $message = 'Account pending';
         $message .= "\r\nUsername: ";
         $message .= $newusername;
         $message .= "\r\nPassword: ";
         $message .= $newpassword;
         $message .= "\r\n";
         $header  = "From: removed for this example"."\r\n";
         $header .= "Reply-To: removed for this example"."\r\n";
         $header .= "MIME-Version: 1.0"."\r\n";
         $header .= "Content-Type: text/plain; charset=utf-8"."\r\n";
         $header .= "Content-Transfer-Encoding: 8bit"."\r\n";
         $header .= "X-Mailer: PHP v".phpversion();
         mail($mailto, $subject, $message, $header);
         mail('youremail@yourdomain.com', $subject, $message, $header);
         header('Location: '.$success_page);
         exit;
      }
   }
}
?>

I have replaced "s e x" with "gender" and lower cased all fields, you need to change accordingly your form.

Please note that this is not standard support, debugging user issues of this type requires too much time.

[Navaldesign]

Please note that the DBTS MySQL Admin object creates the database table by itself (you don't need to create it) and BY DESIGN it ads three standard fields apart the ones you might want to add yourself: creation_date, expiry_date, redirect.

So these columns already exist in the database table.

Now, regarding your question:

Add the following hidden fields / values in the form:

Field: creation_date

value: <?php echo date('Y-m-d');?>

Field: expiry date

value (all in one line or WB will truncate it):

<?php $time_period = "1 year"; $expiry = strtotime(date('Y-m-d')); $new_expiry = strtotime($time_period, $expiry); $expiry_date = date('Y-m-d', $new_expiry );echo $expiry_date;?>

You can replace "1 year" with any valid time period expression, like:

2 months
120 days
2 years
etc.

This will set the expiry to whatever period you set.

[Navaldesign]

You are right about the "creation_date"

The password becoming blank, instead, is not normal behavior.
In any case, displaying the password is meaningless, as it is encrypted, so what you would see has no sense and can't be used.
I will investigate this and apply necessary corrections to the code if necessary.

[Navaldesign]

I have checked the code and it should update the password details IF and ONLY IF the Admin submits a whatever value, if it remains empty it will not update the password.

This, on theoretical level.

I will check it in practical level (test the script) as soon as possible.

[Navaldesign]

I did find a bug in the code and I edited it as required.

You can download the zip and replace the DBTS Admin MySQL extension with the new one.

[Navaldesign]

There doesn't appear to be a 'recover forgotten password' (user not admin) extension for this new login system - would that be correct?

Is there a solution I can use to enable members to have their forgotten password emailed to them or reset and emailed at their request using the MySQL version of this login system?

Cheers.

You simply use the standard "Recover Password" tool of WB. Of course you need to set it up with the specific MySQL database details

[Navaldesign]

Trying to test user login using standard form and the MySQL login extension but getting this page error: .....................................

Had it working perfectly previously, don't remember making any changes to login (DBTS extension is moved to back). The MySQL admin area works fine as does the signup page, just can't login with user details.

This message can ONLY mean that somehow, the Login tool has lost the MySQL details. In fact the error message has no username.

Check the MySQL DB details in the Login tool properties, NySQL section. Save, Publish and check again.

[Navaldesign]

There is no SignupObject among the DBTS login tools extensions. I suppose that you are using the standard WB Signup form ?

Or did you customize the form yourself ?

Is the error message displayed in a Javascript alert popup or in the page itself ?

[Navaldesign]

As you understand, this has nothing to do with the extension. It has to do with how you have modified the code to customize it according to your enriched signup form.

To be able to give you any guidance I would need to see the code of the page (not in the browser, but in WB -> View -> Page HTML
In all cases this is about the extension but about your own amendments.

[Navaldesign]

Not yet, I'm afraid.

However, I will be releasing the DBTS Form Processor v 3 as soon as tests are completed, which will have the possibility to do this, and therefore can be used to read, display and allow to edit fields from the database, ncluded the Login system tables.

[Navaldesign]

The standard WB login system does have this integrated : Login Name tool. This is why I never added it in my own Login extension
I believe that there is also a user extension for this: viewtopic.php?t=18538

[Patrik iden]

Hi, i'm using DBTS Admin Mysql. When i try to change a user ex, to activate a user i just get (User details update failed)
How come?

[Navaldesign]

Do the other features of the Admin area work ?
In example, Create user ?

[Patrik iden]

No, only to delete user seem to work.

[Navaldesign]

I'm sorry but I don't see any reason why it shouldn't work for certain features whilst it works for others. I would need access to your account to check what might be wrong.

[Patrik iden]

it's strange.The original WB Admin login works.

[adex1]

Using DBTS Login Extension: I did not see a redirect field name on the extension.

[Navaldesign]

When you go in the Admin area, (only the DBTS Admin MySQl version) you will see that there is a field named "User Redirect URL".

http://www.dbtechnosystems.com/wb6/logi ... image1.gif

[adex1]

When you go in the Admin area, (only the DBTS Admin MySQl version) you will see that there is a field named "User Redirect URL".

http://www.dbtechnosystems.com/wb6/logi ... image1.gif

Reading the document l am not sure which one should come first between DBTS login and DBTS Admin MYSQL. Should l use Admin to create the user details and assign their folder levels or user get sign up and later l will assign them their level to have access to?

[Navaldesign]

Users signup using the standard WWB Signup tool.

After a user has signed up, you can assign usergroup and USer Redirect page. Of course, you will need to use the DBTS Login instead of the standard WWB login.

[adex1]

Users signup using the standard WWB Signup tool.

After a user has signed up, you can assign usergroup and USer Redirect page. Of course, you will need to use the DBTS Login instead of the standard WWB login.

Hi George,

Is it this you mean I should use?

[Navaldesign]

Yes. The standard WWB can't redirect each user to his own page.

[adex1]

Yes. The standard WWB can't redirect each user to his own page.

Alright thanks. It is seem like the extension fornt end can not be preview on the localhost, except when it is publish am I right?

[Navaldesign]

Correct. It is PHP code so it must be published.

[Rob]

Naval design,

I am working on a client project. They would like to have only certain pages password protected, depending on the user.

This is what I need - a login form and user redirect to a protected page depending on the user name entered in the login form. I don't need (I am struggeling with) a MySQL database, so I was hoping a simple txt database would work. I am struggeling with the simple WB9 login form to get it to connect to the txt database created within / edited within WB9.

I don't want a sign up form, I don't want an admin panel to edit users online. All I need is a contact page and a login page with a user redirect. A potential user will need to contact me to sign up for an account (after it's been paid for). Then I can add & edit users in the txt database from within WB9 and reupload each change to the server. Then send them their account info. Depending on the user name used, they will be redirected to their respective page.

It was my understanding this was possible via WB9 tools but still not working. So close yet so far.... Do you have any simple to use extensions to make this work?

If you like, feel free to contact me directly via my website. Thank you for your time.

[Navaldesign]

You can't have a script without EITHER a signup form or an Admin backend to allow you to edit users. Otherwise, creating and managing the users file would be rather complicated (you would need to create and modify it in Notepad, each time there is an amendement, and then load it on the server with FTP)
You can't edit this file from within WWB. You wrote "It was my understanding this was possible via WB9 tools but still not working." but this is not correct. WWB allows you to create the file on the server, but that is an empty file. You need the Admin part to add / edit / delete users.

However, please note that using my own extensions (the MySQL version) is quite simple, you don't need to do anything else than create the database on the server (using your control panel automated procedures), write down the database credentials, and use them in my Login and my MySQL Admin object.

However, if you still want to go the way you described, you simply need to:

Use the DBTS Login extension (which supports user redirect to a specific page after login)
Create the trext file (with the correct structure and columns, in the correct order) and upload it on the server.

[maxime]

However, if you still want to go the way you described, you simply need to:

Use the DBTS Login extension (which supports user redirect to a specific page after login)
Create the trext file (with the correct structure and columns, in the correct order) and upload it on the server.

very intersting, but i do not undesrstand

i tough the dbts login was working only with msql.

do we have to create a login form wit the wwb login object or we can create our own form.

and what is the correct structure and columns? an exemple ?

[Navaldesign]

@ maxime: if you read the thread related to the DBTS login tools, you will see that there are two versions (for some tools), one that works with a flat file, just as the WWB built in tools, and one that works with MySQL.

Login form: ( from the manual, please read it)
DBTS MySQL Login Extension:
This tool is NOT independent. In fact it should be used TOGETHER with WWB’s
Login tool, or with a standard WB form that allows the user to login. It adds Expiry
Date check and User Specific Redirect. It ONLY works with the DBTS MySQL
Admin Extension. Please see details in the related paragraph.

Correct columns and structure: again, depends on if you are using the standard fields or if you have added additional fields. Also you must have the columns in the correct order and use the correct separator.
To see what the correct order and structure is, you should download from the server and analyze the file created by the WWB Login tools.

[Rob]

For the time being I''m using a simple single page protect object for my project. Obviousely this is not the optimm solution. Should I go with your extension and use a MySQl database, do I need to create the table in PHPMyAdmin (part of GoDaddy's control panel) prior to adding users? This is where I got stuck with the MySQL.

[Navaldesign]

As I already mentioned, you need to create the database.
The script, if used as per manual instructions, will create the necessary tables itself. Unless GD has set restrictions in creating tables, which I don't believe.

[Rob]

I feel compelled to try this one more time...

Can I use your DBTS Admin extension to automatically create the txt database and tables neccessary (not mysql) and then use the WB9 login & user redirect extensions?
Something else I was struggeling with. The site is in a sub / sub-directory of my root folder (myroot / clients / clientsite) - I had the txt databse in a the root directory of the sub directory "clientsite" sub directory. The WB9 login extension allowed me to place it there and edit it from there however didn't seem to connect to it online. Why? Will I face the same issue with your admin extension.

This whole process for me hinges on being able to #1 - control the sign up process (I don't want to use a sign-up form / be able to "approve" accounts after pmt received) and #2 - I need to impliment a user redirect extension. Is this possible?

In all honesty, which is easier and more secure using your extensions properly - a txt database of MySQL? I was able to create the MySQL database, just not create the tables properly from within PHPMyAdmin.

Please advise. Thank you.

[Navaldesign]

I feel compelled to try this one more time...

Can I use your DBTS Admin extension to automatically create the txt database and tables neccessary (not mysql) and then use the WB9 login & user redirect extensions?

No, you need the MySQL version

Something else I was struggeling with. The site is in a sub / sub-directory of my root folder (myroot / clients / clientsite) - I had the txt databse in a the root directory of the sub directory "clientsite" sub directory. The WB9 login extension allowed me to place it there and edit it from there however didn't seem to connect to it online. Why? Will I face the same issue with your admin extension.

As I said, you need the MySQL version, so no files exist. Data is retrieved from the MySQL database.

This whole process for me hinges on being able to #1 - control the sign up process (I don't want to use a sign-up form / be able to "approve" accounts after pmt received) and #2 - I need to impliment a user redirect extension. Is this possible?

As I already answered, #1 is possible anyway, for #2 you need the MySQL version of my Login and Admin

In all honesty, which is easier and more secure using your extensions properly - a txt database of MySQL? I was able to create the MySQL database, just not create the tables properly from within PHPMyAdmin.

Please advise. Thank you.

MySQL is far easier and safer.
With my own DBTS MySQL Admin, you DON'T need to crete the tables, the script will create them for you.

[roygore]

Naval,

Just came across your post which is exactly what I am looking for.

I'm about to embark on a new project which will require a login facility for members to access members only pages. It's for a small club of around 30 members so a SQL database is a bit overkill.

Do you have a version which works using a flat file rather than a database for version 17 of WWB,

By the way - a great extension.

Roy

[BaconFries]

@roygore the last time Navaldesign was active (logged in) in the forum was back in January this year so he may not see this. Have you read the first post in this thread? it does mention a flat file can be used!. I cant speak for Navaldesign but the extension may not be supported anymore as it was first developed back in 2010 and last update was 24/09/2010. Hopefully he will see this and give you a answer.

[wwonderfull]

Naval,

Just came across your post which is exactly what I am looking for.

I'm about to embark on a new project which will require a login facility for members to access members only pages. It's for a small club of around 30 members so a SQL database is a bit overkill.

Do you have a version which works using a flat file rather than a database for version 17 of WWB,

By the way - a great extension.

Roy

Hey @roy_gore we meet again

WWB has login facility too which is amazing to use.
WWB also has login system which you can make guest administrator or members to access. You can do it using mysql more easily I think. If you need help with your project you can contact using the link below.

[roygore]

Thanks wwonderful,

Nice to hear from you again. Hope you are well.

I'll have a look at the wwb login extension. I don't have any experience with databases so am a little reluctant - would prefer to use a flat file if possible. However, it might be a good opportunity to learn how to setup and use databases.

Might take you up on the offer to help if I get stuck.

Roy

[wwonderfull]

Thanks wwonderful,

Nice to hear from you again. Hope you are well.

I'll have a look at the wwb login extension. I don't have any experience with databases so am a little reluctant - would prefer to use a flat file if possible. However, it might be a good opportunity to learn how to setup and use databases.

Might take you up on the offer to help if I get stuck.

Roy

According to @pablo

A login system with multiple users needs a database to store the data of the users (like name, email, password etc). So the first thing we need to do is setup the database. The login tools can use either a flat file database, where all data is stored in a text file (usersdb.php) on the server, OR a MySQL database.
The flat file database is probably the easiest to setup and this is the default option. However MySQL is more secure and recommended for advanced users. In this tutorial we use the text based database. If you want to use MySQL instead then please consult the help (Toolbox->Login tools->User Database) for detailed instructions.

So I think pablo has the flatfile database thing what you are wanting @roy
Here is the login tools basic tutorial by @pablo http://www.wysiwygwebbuilder.com/login_basics.html
And yes even I had no experience with database I always used flat files until I got the database thing later on. It is complex only when doing it for the 1st time and also understanding how it works.
But sure thing roy there is nothing like learning new things. If you need any help you know where to find me cheers

[roygore]

wwonderful,

Thanks again for your help.

I will have a look at Pablo's flat database.

Appreciate your help.
Roy