<?php
$webdb = new mysqli("hidden", "hidden", "hidden", "hidden");
$gamedb = new mysqli("hidden", "hidden", "hidden", "hidden");
if (mysqli_connect_error()) {
    printf("we died boiii: %s\n", mysqli_connect_error());
	die($webdb->connect_error);
    exit();
}

$gamequery = "SELECT uid,usergroup FROM mybb_users WHERE loginname REGEXP '^7' ";
$gameresult = $gamedb->query($gamequery) or die(mysqli_error());

while($row = $gameresult->fetch_array())
{
	$rows[] = $row;
}
$statement = $webdb->prepare("UPDATE mybb_users SET usergroup = ? WHERE uid = ?");
foreach($rows as $row)
{
	$statement->bind_param("i",$row[usergroup],$row[uid]);
	$statement->execute();
}
$gameresult->close();
$webdb->close();
$gamedb->close();
?>