SAVE HIGH SCORE EXISTING WORDPRESS USERS

To elaborate:, every wordpress (wp) site has an existing user base table (SQL). I want to save high scores for each and every user in the existing users table, rather than have Godot create a new separate table with a new users list. Having 2 separate lists would become confusing, redundant and inefficient.
Also, there may be multiple users logged into the site, playing the games.
So: steps should be:-

1. Retrieve the logged in wp-user (username) for scoring purposes (& display it in the game);
2. Save/ update each player's high score against their name/ id in the existing wp-users table;
3. Load this high score each time game is played.

Alternatively: incorporate this into Gamipress - no docs on incorporating Godot games found yet.
Thanks.

Thanks Toxe.
Thanks DaveTheCoder.
For suggesting SQLite, however as the name suggests it is designed for "light" work. The docs do not recommend it for client/server traffic - which may pull heavy at times, and to choose enterprise SQL instead. It also again would mean a duplicate, separate db and new table of users- or I would have to port over the existing wp db which may break wp server links/ configs, plugins, codec, third parties, etc- a possible nightmare.
However it is a good mention to keep in mind for future local application usage- thanks.

Thanks Toxe, DaveTheCoder., Tomcat.

It will be a web export on a WP site URL- running in a browser.
I will stick to MySQL to be fully compatible with existing WP default. (Avoiding porting too much over to MariaDB replacement- the Github demo video is hours of work for an expert- days for me), and because lots of other plugins I'm using are optimised for Mysql wp tables.
..
Yes HTTP is one way, mentioned on the WP API, however I would prefer direct PHP instruction, avoiding HTTP bottlenecks/ delays- it is like talking to yourself through a telephone- or using a car to return to where you are standing already, after navigating an entire city. The API states PHP as an option- (i'm still learning the wp API).

Toxe- what is your fear about using the same table, or connecting directly? (Which MariaDB extension does!)

Other options I'm Looking at are: Advanced Custom Fields plugin
My preference is to link game scores to Gamipress, because not all games will be Godot. Some will be quizzes and puzzle plugins.
However there is no Godot addon for Gamipress.

One script eg I've come across is: (althogh I would have to add security- sanitze it)"

1. eg user notes input

`function save_user_data_7231(){
global $current_user;
if is_user_logged_in{ //check if user is logged in.
if (isset($POST['Notes'])){
// get current user info
get_currentuserinfo();
$old_notes = get_user_meta($current_user->ID, 'user_notes', true);
if (isset($old_notes)&& is_array($old_notes)){
//if we saved already more the one notes
$old_notes[] = $POST['Notes'];
update_user_meta( $current_user->ID, 'user_notes', $old_notes);
}
if (isset($old_notes)&& !is_array($old_notes)){
//if we saved only one note before
$new_notes = array($old_notes,$POST['Notes']);
update_user_meta( $current_user->ID, 'user_notes', $new_notes)
}
if (!isset($old_notes)){
//first note we are saving fr this user
update_user_meta( $current_user->ID, 'user_notes', $POST['Notes'])
}
}
}
}

they to display there notes you can use get_user_meta

function get_user_notes_654(){
global $current_user;
if is_user_logged_in{ //check if user is logged in.
// get current user info
get_currentuserinfo();
$old_notes = get_user_meta($current_user->ID, 'user_notes', true);
if (!isset($old_notes)){
$re = 'No Notes YET!';
}
if (isset($old_notes)){//we have notes. Removed the extra ! here.
if (is_array($old_notes)){//more then one
foreach($old_notes as $note){
$re .= '<strong>note:</strong>' . $note . '<br />';
}
}else{//just one
$re = '<strong>note:</strong>' . $old_notes . '<br />';
}
}
re .='//add note form would come here';
return $re;
}
}
`

Another is inside wp syntax:

Hi Toxe,
HTTP is a protocol connecting to other nodes, whether internet, or within a local network of computers.--- ie: requests must leave the initiating node and connect outwards through physical modem or link switch. If you have multiple players on a heavy game, it can drain resources- "bottleneck". But direct PHP requests can remain internal within the same machine interacting with the API. No need to go the long route. It's an unnecessary trip if you can avoid it.

Right now, I'm trying a simple save script on local machine.
Can any one tell me why it's not saving/loading my high score?

Thanks kuligs2, Toxe, Dave:

Yes the file exists, and its time stamp modified/updated (per func _ready> save, as expected, -& not without it).

Dave, thanks for the code- I entered it under the FileAccess.open statement: I don't get any errors.
Toxe, that makes sense- I tried:- swapping lines 23 & 24, but still no luck.
Kuligs2 -you could be right about var mismatch: Does the underscore "_" cause problems in this DB?
Otherwise all lower case.
( Scoreboard is otherwise functioning correctly real time: score , high_score and life_score.)

Hey Guys,
I fixed it. It was actually saving to file - But saving "Zero" (0) instead.
I was following a You Tube tut, and had HUD on Canvas item.
FileAccess does not inherit this-so I Moved it to Control child node- it worked!