I want to validate the call from when there is a First Login event.

Peter Lane Posted in Technical Support 3 years ago

I am trying to set up a script to do some things when a new user logins in for the first time. I want to validate that it is a valid user, but I don't seem to be able to connect to the ossn_users table.

My script resides in the same domain as OSSN.

Replies
French David Athome Replied 3 years ago

Why would it not be a valid user, to the point that they just signed up with the legit email they used, After that. goodness knows who they are. Do you mean addition info like passport, birth cert etc?

gb Peter Lane Replied 3 years ago

Apologies, bad hair day - found a novice error .... :(

Its okay now

gb Peter Lane Replied 3 years ago

I have connected with PDO first. OSSNuser value comes from $_GET etc

gb Peter Lane Replied 3 years ago

I get no rows found from:

    $query = "SELECT guid FROM ossn_users WHERE guid = $OSSNuser AND username = 'nam'";
$stmt = PDOexecute($ossn_sql_id, $query, '', '', __FILE__, __LINE__);
if($stmt->rowCount() == 0)
    kick($ossn_sql_id,"Please login on to and navigate from LocalApp.live site 1");
$row = $stmt->fetch(PDO::FETCH_ASSOC);
Indonesian Arsalan Shah Replied 3 years ago

Why you can not able to connect to ossn user table? what error do you get?