$mybb->user['uid'] = (int)$mybb->user['uid'];//(probably not necessary) (current user)
$query = $db->simple_select('YOUR_TABLE_NAME', '*', "uid='{$mybb->user['uid']}'");

if($db->num_rows($query))
{
	error("There is a row for you already in the database, regardless of its content you can't create a new one.");
}

(2019-01-03, 09:50 PM)Omar G. Wrote: Trying to guess your DB table structure, probably something of the sorts of the following should work:

$mybb->user['uid'] = (int)$mybb->user['uid'];//(probably not necessary) (current user)
$query = $db->simple_select('YOUR_TABLE_NAME', '*', "uid='{$mybb->user['uid']}'");

if($db->num_rows($query))
{
	error("There is a row for you already in the database, regardless of its content you can't create a new one.");
}

I would assume you are using $db->insert_query() to insert your data into the DB, and you can use $db->update_query() if you want to update data as well.

You can check the documentation regarding DB methods in the following link:
https://docs.mybb.com/1.8/development/plugins/database-methods/

(2019-01-05, 02:03 AM)Zaqre Wrote: Can anyone publish this as a plugin?

(2019-01-05, 07:09 PM)enrolmudas Wrote:

(2019-01-05, 02:03 AM)Zaqre Wrote: Can anyone publish this as a plugin?

Well, it is my goal to make this a functionality of a bigger plugin. It will a series of RP (Roleplay) functions like character sheets, leveling system, random encounter (items or mobs) and many more. Right now this "character sheet" thing works fine, but I want it to make it editable and but that I mean: Allowing the admin to add/remove fields from it so it won't be a static sheet.