Creating a page with a fillable sheet [SOLVED]

[Omar G.]

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/pl...e-methods/

[enrolmudas]

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/pl...e-methods/

That's it! I just did it. It works perfectly, thank you so much for your help!

[Zaqre]

Can anyone publish this as a plugin?

[enrolmudas]

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.

[Zaqre]

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.

If you need help testing, let me know, I am currently trying to start an RP system with my friend. I am currently based on Google Docs with custom formulas I made, but it's really tacky and just static to the specific RP that it was made for.

[enrolmudas]

Sure! I'll let you know as soon as possible!

[MusicMaker]

Any progress with this enrolmudas?

I run a local musicians jam group and am just now beginning to run a forum for the community. I want members to be able to view a table that has song titled down the side and instrument headings for 6 columns to the right and then simply enter their name into the spot they wish to fill.

I was hoping a simple plugin already existed but it seems not to and my coding skills are close to zero

Thanks