Search in Image Gallery

[AirWarrior]

You can search in image gallery in 2 option:

*Title
*Discription

Can we made a third option so we can search on the username of the poster?

[AirWarrior]

Nobody know a solution ?

[aom]

Sorry, it was too hot for answering.

But it should be clear what to do.
in index.php at gallery module you have to modify this:

   

Code:

$sort = "
<select name=\"order\" size=\"1\" onchange=\"selChoc(this)\"  class=\"bgselect\">
  <option value=\"0\">{$mklib->lang['ga_orderby']}</option>\n
  <option value=\"1\">{$mklib->lang['ga_position']}</option>\n
  <option value=\"2\">{$mklib->lang['ga_namecat']}</option>\n
  <option value=\"3\">{$mklib->lang['ga_datecre']}</option>\n
      </select>

Also you have to modify this:

   

Code:

switch(intval($mkportals->input['order'])) {
case '2':
$order = "ORDER BY `evento`";
    break;
case '3':
$order = "ORDER BY `id` DESC";
    break;
default:
    $order = "ORDER BY `position`";
    break;
}

]

thats it.

[AirWarrior]

OK thx i go look to this.
It was very hot last days, you right to stay of the pc.  

I made this

Code:

switch(intval($mkportals->input['order'])) {
case '2':
$order = "ORDER BY `evento`";
    break;
case '3':
$order = "ORDER BY `id` DESC";
    break;
case '4':
$order = "ORDER BY `name`";
    break;
default:
    $order = "ORDER BY `position`";
    break;
}

and this

Code:

$sort = "
<select name=\"order\" size=\"1\" onchange=\"selChoc(this)\"  class=\"bgselect\">
  <option value=\"0\">{$mklib->lang['ga_orderby']}</option>\n
  <option value=\"1\">{$mklib->lang['ga_position']}</option>\n
  <option value=\"2\">{$mklib->lang['ga_namecat']}</option>\n
  <option value=\"3\">{$mklib->lang['ga_datecre']}</option>\n
  <option value=\"4\">{$mklib->lang['ga_name']}</option>\n
      </select>

And in lang_gallery.php

Code:

$langmk['ga_name'] = "Name";

The dutch lang_gallery.php

Code:

$langmk['ga_name'] = "Naam";

But i don't see any changes in Gallery search.

[aom]

Hi,
name is the wrong fieldname, you have to take "autore"

[AirWarrior]

I changed it in "autore"

Code:

switch(intval($mkportals->input['order'])) {
case '2':
$order = "ORDER BY `evento`";
    break;
case '3':
$order = "ORDER BY `id` DESC";
    break;
case '4':
$order = "ORDER BY `autore`";
    break;
default:
    $order = "ORDER BY `position`";
    break;
}

and this

Code:

$sort = "
<select name=\"order\" size=\"1\" onchange=\"selChoc(this)\"  class=\"bgselect\">
  <option value=\"0\">{$mklib->lang['ga_orderby']}</option>\n
  <option value=\"1\">{$mklib->lang['ga_position']}</option>\n
  <option value=\"2\">{$mklib->lang['ga_namecat']}</option>\n
  <option value=\"3\">{$mklib->lang['ga_datecre']}</option>\n
  <option value=\"4\">{$mklib->lang['ga_autore']}</option>\n
      </select>

And in lang_gallery.php

Code:

$langmk['ga_autore'] = "Name";

The dutch lang_gallery.php

Code:

$langmk['ga_autore'] = "Naam";

But i don't see any changes in Gallery search.

[AirWarrior]

I found it
Needed to change this section too

Code:

function search() {
global $mkportals, $DB, $mklib, $Skin, $mklib_board;
$maintit = "{$mklib->lang['ga_searchf']}";
$cselect.= "<option value='1'>{$mklib->lang['ga_title']}</option>\n";
$cselect.= "<option value='2'>{$mklib->lang['ga_des']}</option>\n";
$cselect.= "<option value='4'>{$mklib->lang['ga_autore']}</option>\n";

[AirWarrior]

MMM
No working good.
It gives the same results as search on title and not on user who send it.

[AirWarrior]

I changed lines between line 1612 and 1671

Code:

function search() {
global $mkportals, $DB, $mklib, $Skin, $mklib_board;
$maintit = "{$mklib->lang['ga_searchf']}";
$cselect.= "<option value='3'>{$mklib->lang['ga_autore']}</option>\n";
$cselect.= "<option value='1'>{$mklib->lang['ga_title']}</option>\n";
//$cselect.= "<option value='2'>{$mklib->lang['ga_des']}</option>\n";

$content .= "
    <tr>
      <td>
     
<form action=\"index.php?ind=gallery&amp;op=result_search\" name=\"search\" method=\"post\">
<table width=\"100%\" border=\"0\">
  <tr>
    <td>{$mklib->lang['ga_searchin']}</td>
    <td>
      <select class=\"bgselect\" name=\"campo\" size=\"1\">
      {$cselect}
      </select>
    </td>
  </tr>
  <tr>
    <td width=\"20%\">{$mklib->lang['ga_searchtext']}</td>
    <td width=\"80%\"><input type=\"text\" name=\"testo\" size=\"52\" class=\"bgselect\" /></td>
  </tr>
  <tr>
    <td colspan=\"2\"><input type=\"submit\" value=\"{$mklib->lang['ga_searchstart']}\" class=\"mkbutton\" /></td>
  </tr>
</table>
</form>

      </td>
    </tr>
";
// Link Navigation bar
$navbar = "<a href=\"index.php?ind=gallery\">{$mklib->lang['ga_mkpgal']}</a>{$mklib->lang['bc_sep']}<a href=\"#\">{$mklib->lang['ga_searchf']}</a>";
// Link Navigation bar
$stat = $this->retrieve_stat();
$toolbar = "";
$utonline = $mklib_board->get_active_users("gallery");
$output  = $this->tpl->gallery_show($navbar, $maintit, $content, $submit, $stat, $toolbar, $show_pages, $utonline);
$blocks = $Skin->view_block("{$mklib->lang['ga_imggal']}", $output);
$mklib->printpage("1", "1", $mklib->sitename.$mklib->lang['tt_sep'].$mklib->lang['ga_imggal'].$mklib->lang['tt_sep'].$mklib->lang['ga_searchstart'], $blocks);

}

function result_search() {
global $mkportals, $DB, $mklib, $Skin, $mklib_board;
//$campo = $mkportals->input['campo']; //deprecated
$testo = $mkportals->input['testo'];
$campo = "titolo"; //This is a database table row name - Do not translate!
if (intval($mkportals->input['campo']) == 3) {
$campo = "descrizione"; //This is a database table row name - Do not translate!
$campo = "autore"; //This is a database table row name - Do not translate!
}
if (!$testo) {
$message = "{$mklib->lang['ga_reqstring']}";
$mklib->error_page($message);
exit;
}

This is the search section.
I add this line

Code:

$cselect.= "<option value='3'>{$mklib->lang['ga_autore']}</option>\n";

and add this line

Code:

$campo = "autore"; //This is a database table row name - Do not translate!

Now i can can search on posters name ans search on title.
Search on discription is not working any more.