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

Peter Lane Posted in Technical Support 11 months 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 11 months 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 11 months ago

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

Its okay now

gb Peter Lane Replied 11 months ago

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

gb Peter Lane Replied 11 months 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 11 months ago

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