Search found 10 matches

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

Re: mysql read write split?

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

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
11 Mar 2019, 15:48
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 4490

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
11 Mar 2019, 15:45
Forum: General Discussion
Topic: bug view page display list of bugs
Replies: 1
Views: 2172

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
18 Aug 2018, 03:46
Forum: General Discussion
Topic: mysql read write split?
Replies: 2
Views: 3655

mysql read write split?

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

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
26 Jul 2018, 17:43
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 4490

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 sq...
by jingshaochen
25 Jul 2018, 23:58
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 4490

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
25 Jul 2018, 15:56
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 4490

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
21 Jul 2018, 02:45
Forum: General Discussion
Topic: question on db_query_bound an array
Replies: 5
Views: 4490

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