✅ Database connection successful
✅ Users table exists
Array
(
[0] => Array
(
[Field] => id
[Type] => int(11)
[Null] => NO
[Key] => PRI
[Default] =>
[Extra] => auto_increment
)
[1] => Array
(
[Field] => username
[Type] => varchar(50)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[2] => Array
(
[Field] => email
[Type] => varchar(100)
[Null] => NO
[Key] => UNI
[Default] =>
[Extra] =>
)
[3] => Array
(
[Field] => password
[Type] => varchar(255)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[4] => Array
(
[Field] => first_name
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[5] => Array
(
[Field] => last_name
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[6] => Array
(
[Field] => role
[Type] => enum('admin','editor','author','subscriber')
[Null] => YES
[Key] => MUL
[Default] => subscriber
[Extra] =>
)
[7] => Array
(
[Field] => avatar
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[8] => Array
(
[Field] => role_id
[Type] => int(11)
[Null] => NO
[Key] =>
[Default] => 1
[Extra] =>
)
[9] => Array
(
[Field] => active
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 1
[Extra] =>
)
[10] => Array
(
[Field] => created_at
[Type] => timestamp
[Null] => NO
[Key] =>
[Default] => current_timestamp()
[Extra] =>
)
[11] => Array
(
[Field] => is_active
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 1
[Extra] =>
)
[12] => Array
(
[Field] => star_power
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[13] => Array
(
[Field] => prestige_positive
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[14] => Array
(
[Field] => prestige_negative
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[15] => Array
(
[Field] => social_links
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[16] => Array
(
[Field] => birthday
[Type] => date
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[17] => Array
(
[Field] => phone
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[18] => Array
(
[Field] => public_email
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[19] => Array
(
[Field] => public_phone
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[20] => Array
(
[Field] => public_birthday
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[21] => Array
(
[Field] => fb_user_id
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[22] => Array
(
[Field] => fb_access_token
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[23] => Array
(
[Field] => fb_page_id
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[24] => Array
(
[Field] => fb_page_access_token
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[25] => Array
(
[Field] => Bio
[Type] => varchar(50)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[26] => Array
(
[Field] => PointsEarned
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[27] => Array
(
[Field] => google_user_id
[Type] => varchar(255)
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[28] => Array
(
[Field] => google_access_token
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[29] => Array
(
[Field] => facebook_user_id
[Type] => varchar(255)
[Null] => YES
[Key] => MUL
[Default] =>
[Extra] =>
)
[30] => Array
(
[Field] => facebook_access_token
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[31] => Array
(
[Field] => password_hash
[Type] => varchar(255)
[Null] => NO
[Key] =>
[Default] =>
[Extra] =>
)
[32] => Array
(
[Field] => total_points
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[33] => Array
(
[Field] => weekly_points
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[34] => Array
(
[Field] => monthly_points
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[35] => Array
(
[Field] => pm_setting
[Type] => enum('open','friends_only','closed')
[Null] => YES
[Key] =>
[Default] => open
[Extra] =>
)
[36] => Array
(
[Field] => avg_buyer_rating
[Type] => decimal(3,2)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[37] => Array
(
[Field] => avg_seller_rating
[Type] => decimal(3,2)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[38] => Array
(
[Field] => total_reviews_received
[Type] => int(11)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[39] => Array
(
[Field] => cover_image
[Type] => varchar(500)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[40] => Array
(
[Field] => profile_banner
[Type] => varchar(500)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[41] => Array
(
[Field] => location
[Type] => varchar(100)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[42] => Array
(
[Field] => website
[Type] => varchar(200)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[43] => Array
(
[Field] => social_facebook
[Type] => varchar(200)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[44] => Array
(
[Field] => social_twitter
[Type] => varchar(200)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[45] => Array
(
[Field] => social_instagram
[Type] => varchar(200)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[46] => Array
(
[Field] => show_birth_day
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 1
[Extra] =>
)
[47] => Array
(
[Field] => show_birth_year
[Type] => tinyint(1)
[Null] => YES
[Key] =>
[Default] => 0
[Extra] =>
)
[48] => Array
(
[Field] => social_linkedin
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[49] => Array
(
[Field] => social_youtube
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[50] => Array
(
[Field] => social_tiktok
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[51] => Array
(
[Field] => social_discord
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[52] => Array
(
[Field] => social_twitch
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[53] => Array
(
[Field] => social_reddit
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[54] => Array
(
[Field] => social_threads
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[55] => Array
(
[Field] => social_bluesky
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[56] => Array
(
[Field] => social_mastodon
[Type] => varchar(255)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[57] => Array
(
[Field] => generated_banner
[Type] => varchar(500)
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[58] => Array
(
[Field] => banner_style
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[59] => Array
(
[Field] => api_key
[Type] => varchar(64)
[Null] => YES
[Key] => UNI
[Default] =>
[Extra] =>
)
[60] => Array
(
[Field] => api_key_created_at
[Type] => timestamp
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[61] => Array
(
[Field] => theme_preference
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] => dark
[Extra] =>
)
[62] => Array
(
[Field] => accent_color
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] => #9945ff
[Extra] =>
)
[63] => Array
(
[Field] => font_size
[Type] => varchar(20)
[Null] => YES
[Key] =>
[Default] => medium
[Extra] =>
)
[64] => Array
(
[Field] => preferred_language
[Type] => varchar(10)
[Null] => YES
[Key] =>
[Default] => en
[Extra] =>
)
[65] => Array
(
[Field] => preferred_categories
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[66] => Array
(
[Field] => notification_preferences
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
[67] => Array
(
[Field] => privacy_settings
[Type] => text
[Null] => YES
[Key] =>
[Default] =>
[Extra] =>
)
)
✅ Admin user exists
Array
(
[id] => 333
[username] => admin
[email] => admin@starnews.com
[role_id] => 4
[active] => 1
)
Using password_hash column
Password hash: $2y$10$E7L1rRxi17UAL...
✅ Password 'admin123' verifies correctly
✅ Authentication function works! User authenticated.
Array
(
[id] => 333
[username] => admin
[password] => $2y$10$tSkB5mjuJ50VJvanomrr1.nZySngAwUMaM5qe1MFZSz0694MzDXGe
[password_hash] => $2y$10$E7L1rRxi17UALHwsmfFj1.pCXhYOs3Mwq5dovMb3EjrviiroOM3Fq
[role_id] => 4
[email] => admin@starnews.com
[active] => 1
)
Session variables set:
Array
(
[user_id] => 333
[username] => admin
[role_id] => 4
[email] => admin@starnews.com
)
✅ Admin password reset to 'admin123'