Creating a page with a fillable sheet [SOLVED]
#11
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/
Reply
#12
(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/pl...e-methods/

That's it! I just did it. It works perfectly, thank you so much for your help!
Reply
#13
Can anyone publish this as a plugin?
www.volvl.com | Get your first month of hosting for $0.01 USD with Promo Code: Hexeus
[Image: 12946833.gif]


Reply
#14
(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.
Reply
#15
(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.

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.
www.volvl.com | Get your first month of hosting for $0.01 USD with Promo Code: Hexeus
[Image: 12946833.gif]


Reply
#16
Sure! I'll let you know as soon as possible!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)