Search found 10 matches

by jingshaochen
Mar 11, 2019 11:12 am
Forum: General Discussion
Topic: mysql read write split?
Replies: 2
Views: 1293

Re: mysql read write split?

no immediate solution :( probably need to add a proxy
by jingshaochen
Mar 11, 2019 10:52 am
Forum: General Discussion
Topic: Authentication through ADFS?
Replies: 4
Views: 5156

Re: Authentication through ADFS?

I just added saml authentication for our mantisbt. It is not hard. But I do need to modify the login page to redirect to the saml login page.

Here is the library I am using: https://github.com/onelogin/php-saml

It supports ADFS.

Thanks
by jingshaochen
Mar 11, 2019 10:48 am
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 1184

Re: question on db_query_bound an array

Saw a new db query that works:

Code: Select all

$query = new DbQuery('select id from {bug} where id in :id_list');
$query->bind('id_list', array(123,234,345));
Nice!
by jingshaochen
Mar 11, 2019 10:45 am
Forum: General Discussion
Topic: bug view page display list of bugs
Replies: 1
Views: 390

bug view page display list of bugs

Hi,

Is there a bug view page that can take a list of bug ids in GET parameter and display the list?

such as:

Code: Select all

/bug_list_view.php?bugs[]=123&bugs[]=345&bugs=456
Thanks!
by jingshaochen
Aug 17, 2018 10:46 pm
Forum: General Discussion
Topic: mysql read write split?
Replies: 2
Views: 1293

mysql read write split?

Does mantis support mysql cluster with a master for read and write, but multiple slaves for read only?
by jingshaochen
Jul 26, 2018 12:55 pm
Forum: General Discussion
Topic: email_send() multiple to, cc, and bcc ?
Replies: 0
Views: 736

email_send() multiple to, cc, and bcc ?

Hi, In one of my plugins, I need to send an email to multiple To, Cc, and Bcc email addresses. email_store() or email_send() does not support that. It only support up to one each. I added a patch that can enhance email_send() to take multiple email addresses separated by ','. Can anyone review it an...
by jingshaochen
Jul 26, 2018 12:43 pm
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 1184

Re: question on db_query_bound an array

I tried to put the array directly in db_query(), it did not work. So the following code does not work: $reporter_id_array = array(1,2,3); $query = "select id from mantis_bug_table where repoerter_id in " . db_param(); $result = db_query($query, array($reporter_id_array)); The error is a sql error co...
by jingshaochen
Jul 25, 2018 6:58 pm
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 1184

Re: question on db_query_bound an array

Ok. I see it in the code. query_bound is deprecated. I should use db_query() only.

I will test how to supply an array to the query, and update this thread later.
by jingshaochen
Jul 25, 2018 10:56 am
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 1184

Re: question on db_query_bound an array

db_query_bound is deprecated, you should use db_query I thought it is the other way around. Can you point me to the document? My understanding is that db_query_bound() together with db_param() is to avoid SQL injection. I don't need results to be in an array, I wanted to PASS and array as parameter...
by jingshaochen
Jul 20, 2018 9:45 pm
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 1184

question on db_query_bound an array

Hi,

When I have this query:

Code: Select all

$reporter_id_array = array(1,2,3);
$query = "select id from mantis_bug_table where repoerter_id in " . db_param();
$result = db_query_bound($query, array($reporter_id_array));
Does it work?

Thanks,
Jingshao