MySQL rows

Smilie · **MySQL rows -** 08-30-2008, 06:59 AM

Hi all!
I'm at the moment testing iono (license system).
I think it seems great, especially for the things im going to use it for.
So im very noob at this, but i would it be possible if a visitor visits a page eg: download.php
then he should enter the license number he purchased at the iono.
Can any one help/guiding me through this? It would be very great

Dangys · 01:41 PM

Quote:

Originally Posted by Smilie

Hi all!
I'm at the moment testing iono (license system).
I think it seems great, especially for the things im going to use it for.
So im very noob at this, but i would it be possible if a visitor visits a page eg: download.php
then he should enter the license number he purchased at the iono.
Can any one help/guiding me through this? It would be very great

It's possible but it would involve a lot of work. Just attach the license to your scripts.

Krish · 09-01-2008, 02:00 PM

Quote:

Originally Posted by Smilie

Hi all!
I'm at the moment testing iono (license system).
I think it seems great, especially for the things im going to use it for.
So im very noob at this, but i would it be possible if a visitor visits a page eg: download.php
then he should enter the license number he purchased at the iono.
Can any one help/guiding me through this? It would be very great

Since I have phpaudit, and the same company now owns iono, it should be having a member/client area, from where they can down the license and software you upload. It should be there by default, otherwise its a kind of useless system. Just check out the member area of iono.

Smilie · 09-02-2008, 10:41 AM

Yes i know this, but what i'm going to place on the page aint downloads, its some information, that i only want licensed people to enter.. eg: support forum or so..

Krish · 09-02-2008, 11:27 AM

Quote:

Originally Posted by Smilie

Yes i know this, but what i'm going to place on the page aint downloads, its some information, that i only want licensed people to enter.. eg: support forum or so..

You better consult their API docs or developer docs for session/login sharing info..if thats allowed.

Otherwise...

1. create a login form and collect data and get it posted say authenticate.php

2. In authenticate.php filter posted values, then compare them with user database like :

PHP Code:

  $user_result = mysql_query("SELECT * FROM `user_table` WHERE username='".mysql_real_escape_string($_POST['username'])."' AND password='".mysql_real_escape_string($_POST[password'])."' LIMIT 1");

if(mysql_num_rows($user_result) == 1){

...grant access
}
else{

...redirect to login form

}

But you need to know how they are storing password..is it md5 encrypted or sha1 or is it just plain password. Accordingly the above code will change to match the password.

Smilie · 09-02-2008, 02:12 PM

ah yea.. get it, thanks for the info