{"id":47,"date":"2014-09-09T08:32:00","date_gmt":"2014-09-09T08:32:00","guid":{"rendered":"https:\/\/www.tech-and-dev.com\/blog\/2014\/09\/09\/phpbb-api-accessing-database-and-performing-sql-queries\/"},"modified":"2021-02-22T01:02:43","modified_gmt":"2021-02-22T01:02:43","slug":"phpbb-api-accessing-database-and-sql-queries","status":"publish","type":"post","link":"https:\/\/www.tech-and-dev.com\/blog\/2014\/09\/phpbb-api-accessing-database-and-sql-queries.html","title":{"rendered":"phpBB API – Accessing Database and Performing Sql Queries"},"content":{"rendered":"
\n
<\/div>\n
\"phpBB<\/a><\/div>\n

In my two previous posts, phpBB API – Logging In And Logging Out a User<\/a> and phpBB API – Auto Login a User Without a Password<\/a>, I used phpBB API to perform some API functionalities such as logging in a user without a password and logging out a user.<\/p>\n

In this post, I will use the phpBB API to perform some SQL queries on the phpBB database to change the user’s password and verify a user.<\/p>\n

Changing a User’s Password<\/h2>\n

<?php
\ndefine(‘IN_PHPBB’, true);\/\/Must be defined
\n$phpbb_root_path = ‘..\/phpBB3\/’;\/\/your forum directory location
\n$phpEx = substr(strrchr(__FILE__, ‘.’), 1);
\nrequire_once($phpbb_root_path . ‘common.’ . $phpEx); <\/span><\/p>\n

function phpbbChangePassword($username, $newPassword)
\n{
\nglobal $phpbb_root_path, $phpEx, $user, $db,$table_prefix;
\n$newPassword = phpbb_hash($newPassword);<\/p>\n

$sql = “UPDATE `” . $table_prefix . “users` SET user_password = ‘” . $password . “‘ WHERE username = ‘” . $username . “‘”;
\n$db->sql_query($sql);
\n$stmt->close();
\n}<\/p>\n

\/\/Changing Password for user “Test”
\n$username = “Test”;
\n$newPassword = “myNewPassword”;
\nphpbbChangePassword($username, $newPassword);<\/p>\n

?><\/p><\/blockquote>\n

 <\/p>\n

Changing user’s status to verified<\/h2>\n

<?php
\ndefine(‘IN_PHPBB’, true);\/\/Must be defined
\n$phpbb_root_path = ‘..\/phpBB3\/’;\/\/your forum directory location
\n$phpEx = substr(strrchr(__FILE__, ‘.’), 1);
\nrequire_once($phpbb_root_path . ‘common.’ . $phpEx);<\/span>
\n
\n<\/span>function phpbbVerifyUser($username)
\n{
\nglobal $phpbb_root_path, $phpEx, $user, $db, $table_prefix;
\n$userType = USER_NORMAL;
\n$sql = “UPDATE `” . $table_prefix . “users` SET user_type = ‘” . $userType . “‘ WHERE username = ‘” . $username . “‘”;
\n$db->sql_query($sql);
\n} <\/span><\/p>\n

\/\/Verifying User “Test”
\n$username = “Test”;
\nphpbbVerifyUser($username);<\/p>\n

?><\/p><\/blockquote>\n

Any questions, please let me know!<\/b><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

In my two previous posts, phpBB API – Logging In And Logging Out a User and phpBB API – Auto Login a User Without a Password, I used phpBB API to perform some API functionalities such as logging in a user without a password and logging out a user. In this post, I will use […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[63,45,22,62],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-api","category-mysql","category-php","category-phpbb3"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/comments?post=47"}],"version-history":[{"count":1,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":270,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/posts\/47\/revisions\/270"}],"wp:attachment":[{"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/media?parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/categories?post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tech-and-dev.com\/blog\/wp-json\/wp\/v2\/tags?post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}