Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
0 votes
487 views
in Q2A Core by
I'm struggling with step # 7 on Installing Question2Answer with single sign-on
..
I'm new at this ,,., so if you just tell me what codes to write..

this is what I came up with ..
user_name VARCHAR(30) NOT NULL DEFAULT '',
    user_password VARCHAR(32) NOT NULL DEFAULT '',
    user_email VARCHAR(100) NOT NULL DEFAULT '',
    user_hide_email TINYINT(1) UNSIGNED NOT NULL DEFAULT '1',
    user_location VARCHAR(50) NOT NULL DEFAULT '',
    user_birthdate DATE NOT NULL DEFAULT '0000-00-00',
    userid VARCHAR(15) NOT NULL DEFAULT '',
    user_posts SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0',
    user_joined INT(10) UNSIGNED NOT NULL DEFAULT '0',
    user_lastvisit INT(10) UNSIGNED NOT NULL DEFAULT '0',
    user_ip VARCHAR(20) NOT NULL DEFAULT '0.0.0.0',
    user_status TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',

1 Answer

0 votes
by
Your qa_get_mysql_user_column_type() function should just return a single string indicating the column type, such as 'VARCHAR(15)'. But I'm not sure you're using the single sign-on appropriately, since it's for the situation where you already have a user database on your site. Also, it will require some PHP programming which is specific to your particular site. So perhaps you should use the installation process which lets Q2A manage users for you?
...