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

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.
There is a dedicated section for commercial extensions.
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by Patrik iden »

DBTS Admin MySql.
I'm using MySql.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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 ?
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by Patrik iden »

The table was created automaticly whit your extention.
How do i grant ALL permission to the databas?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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".
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by Patrik iden »

OK, i'l try that.

In youe extention, what is this?

latin1_german1_ci
latin1
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Re: DBTS Admin Object/WB Login System ***UPDATED June 19,201

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

brassnugget wrote: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
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

brassnugget wrote: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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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 ?
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

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

Post by 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?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

Do the other features of the Admin area work ?
In example, Create user ?
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

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

Post by Patrik iden »

No, only to delete user seem to work.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Patrik iden
 
 
Posts: 479
Joined: Wed Mar 24, 2010 9:07 pm
Location: Sweden

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

Post by Patrik iden »

it's strange.The original WB Admin login works.
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Using DBTS Login Extension: I did not see a redirect field name on the extension.
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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
www.dbtechnosystems.com
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Navaldesign wrote: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?
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Navaldesign wrote: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?

Image
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

Yes. The standard WWB can't redirect each user to his own page.
www.dbtechnosystems.com
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Navaldesign wrote: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?
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

Correct. It is PHP code so it must be published.
www.dbtechnosystems.com
User avatar
Rob
 
 
Posts: 179
Joined: Sun Jan 29, 2012 2:54 pm
Location: MN
Contact:

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

Post by 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.
The Website Guy - MN
Small Business Web Design
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
maxime
 
 
Posts: 117
Joined: Sat Apr 02, 2011 6:15 pm
Contact:

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

Post by 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 ?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Rob
 
 
Posts: 179
Joined: Sun Jan 29, 2012 2:54 pm
Location: MN
Contact:

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

Post by 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.
The Website Guy - MN
Small Business Web Design
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by 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.
www.dbtechnosystems.com
User avatar
Rob
 
 
Posts: 179
Joined: Sun Jan 29, 2012 2:54 pm
Location: MN
Contact:

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

Post by 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.
The Website Guy - MN
Small Business Web Design
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

IeMS wrote: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.
www.dbtechnosystems.com
User avatar
roygore
 
 
Posts: 140
Joined: Wed Mar 25, 2020 6:34 pm
Location: United Kingdom

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

Post by 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
User avatar
BaconFries
 
 
Posts: 5328
Joined: Thu Aug 16, 2007 7:32 pm

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

Post by 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
 
 
Posts: 1255
Joined: Fri Aug 21, 2020 8:27 am

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

Post by wwonderfull »

roygore wrote: Tue Aug 09, 2022 9:58 am 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 :D

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.
User avatar
roygore
 
 
Posts: 140
Joined: Wed Mar 25, 2020 6:34 pm
Location: United Kingdom

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

Post by 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
 
 
Posts: 1255
Joined: Fri Aug 21, 2020 8:27 am

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

Post by wwonderfull »

roygore wrote: Tue Aug 09, 2022 1:02 pm 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
User avatar
roygore
 
 
Posts: 140
Joined: Wed Mar 25, 2020 6:34 pm
Location: United Kingdom

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

Post by roygore »

wwonderful,

Thanks again for your help.

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

Appreciate your help.
Roy
Post Reply