mysql query into NATS4 database - link change - adult site

Closed

Hi......

I need a mysql query for my adult website....and NATS4....

here are instructions...

----

I will move all forum users to NATS as NCR users...."free"

member into nats as "active"

----

mysql query that exist now:

1.

when user login into blog page....

the query check if his username exist into forum db only

if yes... create username into blog and tube db.....

and make sync

2.

when user login into blog

the query check if he is into blog already (means that he is included into forum and tube)

if yes , check his blog membership package.......

and modify permissions into forum and tube

free or member

mysql query that we need to create

1. when user login into blog page

the query check if username exist into NATS db only

if yes, create username into blog-forum-tube db

and make sync works into my site (is already active)

2. when user login into blog page, if he already exist into blog......

the query check if membership package into NATS db

if NCR or active member, or no active

if NCR...assign "free" package into YM

if no-active...ex-member.......assign "free" package into YM

if active....assign "member" package.

---nats table------------------------------------------------------------------

When querying the NATS db for authentication, you will first need to query the member table with a query similar to this.

select memberid, status from member where username = 'some username' and siteid = 'X';

Where X is the id of the site the member is trying to login into. If you want to add a concept of network

(join one site have access to all) you can remove siteid from that query all together or provide a list of site ids.

You will end up with something like this.

select memberid, status from member where username = 'some username';

Or something like this.

select memberid, status from member where username = 'some username' and siteid in ('X', 'Y', 'Z');

If you are going with a network concept, I strongly suggest making sure that member usernames are unique across all sites.

You can do this by setting UNIQUE_MEMBER_NAMES value to 'For all sites' on the NATS config admin -> surfer page.

Otherwise the last 2 queries might return multiple records.

Once you have the member record, you can examine the status field.

0 = Never joined - just filled out the NATS join form for a paid join option but did not get approved by a biller

1 = Active (NCR or paid)

2 = Expired

To distinguish between NCR or paid, you will need to do an additional query against the member_subscription table.

select optionid from member_subscription where memberid = 'memberid from the member query above' where active = 1;

You will then need to look at the optionid value for each result row that you get. If the value of the optionid field corresponds

to the NCR join option for all rows, then this is an NCR member. If optionid value corresponds to a paid join option for any

of the records, then this is a paid member. You can get the option id value from NATS site admin -> options.

It is in the first column (labeled ID).

------------------------------------------------------------------

change links into all site.. join and upgrade....

also into video redirection

normal join page

[url removed, login to view]<?=$_REQUEST['nats']?$_REQUEST['nats']:'MC4wLjEuMS4wLjAuMC4wLjA'?>&step=2

upgrade link for NCR (or ex-members) to active member

[url removed, login to view][username]=<username>&signup[email]=<email>

link must be dinamic....and take username and email of the user that is logged IN

into join page...username and email must be hidden...in this way the user cannot change them during upgrade

lost password link

my site: [url removed, login to view]~1~

----------------------------------------

delivery to me the doc about mysql query into nats.....with all variables.....

Skills: MySQL, PHP

See more: nats link username, where did you get that blog, mysql database for free, make a tube site, link create free blog, db surfer, create a tube site, query table, NCR, mysql query, make adult website, db query, change username, together mysql, php mysql join table, create admin login php mysql, mysql join table, mysql table join, php add record mysql table, mysql add record, access query table, http adult video, adult email ids list, create database members, change column

Project ID: #5147608

4 freelancers are bidding on average $195 for this job

AndrewSmith22

Hi, http://vaptechnology.in/magento/adultpleasureplus/(Under Construction) We have gone through the detailed requirements and based on the specifications as has been provided by you we will prefer to work on your proj More

$249 USD in 15 days
(28 Reviews)
6.1
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks

$195 USD in 5 days
(9 Reviews)
4.0
techmorning

Hello Sir, We are very much positive for your project. We are eager to share our work process for your project. So, please reply us once. We also have some questions but due to word limitation we unable to ask. So, ple More

$144 USD in 3 days
(2 Reviews)
1.2
brightray

Hello Sir, I have read you requirements and would say the project requirements completely falls under our domain and where this project exactly matches with our technical strengths and our abilities to deliver the wo More

$240 USD in 7 days
(0 Reviews)
0.0
Mathew2013

Hi there………..Hope you are doing well out there. Please enable the private mail so that we would be equipped enough to drop a private mail which portrait our strategy and work plan to accomplish the project of yours. Ou More

$200 USD in 10 days
(0 Reviews)
0.0