miniBB ® miniBB®
miniBB Support Forums
 | Forums | Register | Reply | Search | Statistics | Manual |
Master Class miniBB Support Forums / Master Class /   

External Post Insert

Author Guest
#1 | Posted: 23 Mar 2011 09:23 
Hi,

I have a script completely independent from miniBB that does its own insertions into the database through some form. What I want to do is give the user the option to select a check box in the form and have what the user submitted using this form posted to miniBB automatically.

I found this topic, which helped a bit but it's very old.

What I want to know is how miniBB does its MySQL insertions. In which file is the Insert statement written? and whether it is using triggers since MySQL has triggers now? :)

any one got an idea...


Thanks

Mahmoud

Author Paul
Lead Developer
#2 | Posted: 23 Mar 2011 13:08 
I can only promise that miniBB never will use triggers, or something which is not required for running such a simple program as forum program. So there are no triggers.

miniBB completes mySQL insertions through the function called "insertArray". Searching files for that word you will find all scripts which do that.

However for your script, you don't need such function included. Just analyze the structure of miniBB topics and posts table. It's very simple. You need to force your script just to insert all fields in those tables properly, via your own insertion mechanism, which doesn't matter in this case a lot.

Author Guest
#3 | Posted: 24 Mar 2011 04:56 
Hi Paul,

thanks for the reply...will take a look at the tables structure as well as the insertArray function just to get a full picture

Hopefully I'm gonna be able to make this work properly :)


Best Wishes,
Mahmoud

Author Paul
Lead Developer
#4 | Posted: 24 Mar 2011 11:08 
Once again: you don't have to investigate insertArray function for this. Just use your own very regular mySQL's INSERT command.

Author Mahmoud
Guest
#5 | Posted: 9 May 2011 01:06 
Done!

and yes insertArray investigation is not necessary...I just used own INSERT like you described.


Thanks a lot Paul

Best Regards,
Mahmoud

Author Jerome78
Registered
#6 | Posted: 9 Jun 2011 07:51 
Yup..!
Thanks Paul for guiding...Thanks once again...

Master Class miniBB Support Forums / Master Class / External Post Insert Top

Your Reply Click this icon to move up to the quoted message

 Short link for this topic:

 ?
Only registered users are allowed to post here. Please, enter your username/password details upon posting a message, or register first.


Before posting, make sure your message is compliant with our forum posting rules. If not, it may be locked or deleted with no explanation.
 
miniBB Support Forums Powered by Forum Software miniBB ® Features  Requirements  Demo  Download  Showcase  Gallery of Arts
Compiler  Premium Extensions  Premium Support  License  Contacts
Install the Captcha add-on: protect your miniBB-forums from the automated spam and flood.
Captcha Addon for miniBB