Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - olgaart

Pages: [1] 2 3
1
 if (!empty($additional_image_fields)) {
            $table_fields = $site_db->get_table_fields(IMAGES_TABLE);
            foreach ($additional_image_fields as $key2 => $val2) {
              if (isset($image_cache[$key][$key2]) && isset($image_cache[$key][$key2])) {
                $additional_field_sql .= ", $key2";
                $additional_value_sql .= ", '".addslashes($image_cache[$key][$key2])."'";
              }
            }
          }


Change IMAGES_TABLE to :    IMAGES_TEMP_TABLE

2
It is MySQL5.0
and it works exactly like described here
http://www.4homepages.de/forum/index.php?topic=24969.0

I beleave, it has something to do with function convert_special($text), because if I use search_utils.php from your file
http://www.4homepages.de/forum/index.php?topic=23095.0, it does not work at all.

3
still the same:

DB Error: Bad SQL Query: SELECT word_text, word_id FROM phpbb_wordlist WHERE word_text IN ('?вое', 'безомн??')
Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE) for operation ' IN '

DB Error: Bad SQL Query: INSERT INTO phpbb_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 424, word_id, 0, 1, 0 FROM phpbb_wordlist WHERE word_text = '?вое'
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

DB Error: Bad SQL Query: INSERT INTO phpbb_wordmatch (image_id, word_id, name_match, desc_match, keys_match) SELECT DISTINCT 424, word_id, 0, 1, 0 FROM phpbb_wordlist WHERE word_text = 'безомн??'
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Фотография была отредактирована.



The only difference is that the site title and category names look now like  ??????????? ??? ????? ? ??????
(in modified mysql_db.php  "@mysql_query('set character set utf8');" is included).


Like here: http://www.4homepages.de/forum/index.php?topic=24969.0

4
Hallo V@no,
now it produces following message:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation.

Regargs,
Olga

5
Discussion & Troubleshooting / Wordlist problem (russian language)
« on: June 16, 2009, 06:48:21 PM »
Hi everybody,

I have problems with search wordlist created in the database, with russian words. Some of them are OK, some are split to peaces, and some are not accepted at all.

Like here:
 http://www.fotoclub.robertmagel.de/details.php?image_id=390&l=russian

Что мне снег, что мне зной, что мне дождик проливной!..
"проливной" ist stored in the database, and "дождик" is not accepted.
(Incorrect string value: '\xD0\xD0\xBE\xD0\xB6\xD0...' for column 'word_text' at row 1)

My database is coded in UTF.

Does anybody have a solution?

Best regards, Olga

6
Modified [MOD] Language select (mod V@no, version B)
At the first look it works, but must be a better solution...

page_header.php:


$query_string = '';


if(!empty($HTTP_GET_VARS)) {
  foreach ($HTTP_GET_VARS as $key => $val) {
    if ($key != "l") {
      $query_string .= ($query_string != '' ? '&' : '?').$key."=".$val;
    }
  }
}


$lang_url = $site_sess->url($PHP_SELF.$query_string, '&');
$lang_url = preg_replace("'&(amp|#38);'i", "&", $lang_url);
$lang_url = preg_replace("/[?|&]l=[^?|&]*/", "", $lang_url);
$lang_url = str_replace("&", "&", $lang_url);
$handle = opendir(ROOT_PATH."lang");





if ($user_info['user_level'] == USER ){

if ($user_info['user_lang']== "de") {$config['language_dir'] = "deutsch";}
if ($user_info['user_lang']== "ru") {$config['language_dir'] = "russian";}
if ($user_info['user_lang']== "en") {$config['language_dir'] = "english";}
include_once(ROOT_PATH.'lang/'.$config['language_dir'].'/main.php');
}

 



elseif ($user_info['user_level'] == GUEST ){
$lang_select = "";

while ($folder = @readdir($handle)) {
  if (@is_dir(ROOT_PATH."lang/".$folder) && $folder != "." && $folder != "..") {
    if ($folder != $config['language_dir']) {
      $lang_select .= "<a class=\"lang\" href=\"".$lang_url.(preg_match("/\?/", $lang_url) ? "&" : "?")."l=".$folder."\" onMouseOver=\"(window.status='$folder'); return true\" onMouseOut=\"window.status=''; return true\"><img src=\"".TEMPLATE_PATH."/images/".$folder.".gif\" border=\"0\" alt=\"".$folder."\"></a>&nbsp;";
}else{
    $lang_select .= "<img src=\"".TEMPLATE_PATH."/images/".$folder."2.gif\" border=\"0\" alt=\"".$folder."\">&nbsp;";
    }
  }
}

$site_template->register_vars("lang_select", $lang_select);
}

7
User language preference, for registered user, stored in database,
that would be very usefull.

As an additional user field I have created  "user_lang" field in  table "users".
Based on $user_info['user_lang'] = "de" (for example), it should be possible to define a default user language directory "German",

if user not registered, the default language will stay as $config['language_dir']



8
Hallo Nicky,
thanks for the reply. There should be a mod in the forum to enable RSS, I can try it. It was just so easy in this topic, but it does not work with my vesion of phpbb.  :cry:

9
is it possible to update it for phpbb 3.0.2 ( it does not have templates/subSilver/recent_body.tpl)?

10
Discussion & Troubleshooting / Re: Radio buttons as rate menu
« on: January 03, 2009, 07:54:47 PM »
thank you very much!

11
Discussion & Troubleshooting / Re: Radio buttons as rate menu
« on: January 03, 2009, 07:25:57 PM »
yes, just by adding   <input type="radio" name="rating" value="0" > and <input type="radio" name="rating" value="-1" >
it does not work.  Probably somewhere in "functions" there is a voting range starting from 1?

Site www.fotoexperiment.robertmagel.de, login and passwort testuser.
                 

12
Discussion & Troubleshooting / Re: Radio buttons as rate menu
« on: January 03, 2009, 06:11:22 PM »
Hallo, is it possible to add to the rateform "-1" and "0" values?
Thank you...

13
many many thanks! it works!

14
Many thanks for the reply! I have the same login for as yours, but it never shows up, because anonimous is recognised as a USER. I can not find a problem. In my page_header.php there is a following script:

//-----------------------------------------------------
//--- User Box ----------------------------------------
//-----------------------------------------------------



if ($user_info['user_level'] >= USER) {
  $site_template->register_vars("lang_loggedin_msg", preg_replace("/".$site_template->start."loggedin_user_name".$site_template->end."/siU", format_text($user_info['user_name'], 2), $lang['lang_loggedin_msg']));
  $user_box = $site_template->parse_template("user_logininfo");
  $site_template->register_vars(array(
    "user_box" => $user_box,
    "user_loggedin" => 1,
    "user_loggedout" => 0,
    "is_admin" => ($user_info['user_level'] == ADMIN) ? 1 : 0
  ));
  $site_template->un_register_vars("user_logininfo");
  unset($user_box);
}

else {
  $user_box = $site_template->parse_template("user_loginform");
  $site_template->register_vars(array(
    "user_box" => $user_box,
    "user_loggedin" => 0,
    "user_loggedout" => 1,
    "is_admin" => 0
  ));
  $site_template->un_register_vars("user_loginform");
  unset($user_box);
}

And it never comes to user_loginform because guest is shown as a registered user named anonimous.
Can not find a solution...

15
Hallo Bernd,
your gallery looks perfect. Could you give me a tip, how to make it in that way, that when guest visits, it is not shown as "you are logged in as anonimous"? Instead I would like to have an empty login form, like on your site.
Thanks in advance.
My attempt: http://www.fotoexperiment.robertmagel.de/
Olga

Pages: [1] 2 3