konflikt PseudoSubForums z Complete Messages System

 

Strona 1 z 1 [ 5 posty(ów) ]

Widok do druku | « Poprzedni temat | Następny temat »

Temat

• Wysłany: 14 Sie 2005, 12:13

  myhair

  

  
  Rejestracja: 28 Maj 2005, 11:51
  Posty: 75
  Pochwały: 4
  w pliku admin_forums.php nastepuje konflikt pomiędzy ww. modyfikacjami.
  
  instrukcja karze:
  
  [phpbb]---[ FIND ]---
  
  //
  // Default permissions of public ::
  //
  $field_sql = "";
  $value_sql = "";
  while( list($field, $value) = each($forum_auth_ary) )
  {
  $field_sql .= ", $field";
  $value_sql .= ", $value";
  
  }
  
  // There is no problem having duplicate forum names so we won't check for it.
  $list = explode(',', $HTTP_POST_VARS[POST_CAT_URL]);
  $new_cat = count($list) ? intval($list[0]) : intval($HTTP_POST_VARS[POST_CAT_URL]);
  $new_parent = isset($list[1]) ? intval($list[1]) : 0;
  
  $sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, forum_parent, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
  VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', '{$new_cat}', '{$new_parent}', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
  }
  
  ---[ REPLACE, WITH ]---
  //
  // Default permissions of public ::
  //
  /*Complete Messages System*/
  while( list($field, $value) = each($forum_auth_ary) )
  {
  $FielVal_sql .= $field .'='.$value.', ';
  }
  if(isset($_POST['message_posting']))
  {
  $sqlUpdate .= "message_posting = '";
  ForEach($_POST['message_posting'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewtopic']))
  {
  $sqlUpdate .= "message_viewtopic = '";
  ForEach($_POST['message_viewtopic'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewforum']))
  {
  $sqlUpdate .= "message_viewforum = '";
  ForEach($_POST['message_viewforum'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "',";
  }
  // There is no problem having duplicate forum names so we won't check for it.
  $sql = "INSERT INTO " . FORUMS_TABLE . "
  SET $sqlUpdate
  forum_id = '" . $next_id . "',
  forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "',
  cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ",
  forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "',
  forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ",
  forum_order = $next_order,
  $FielVal_sql
  prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "";
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
  }
  [/phpbb]
  
  Natomiast mój plik w tym miejscu wygląda inaczej:
  
  [phpbb] //
  // Default permissions of public ::
  //
  $field_sql = "";
  $value_sql = "";
  while( list($field, $value) = each($forum_auth_ary) )
  {
  $field_sql .= ", $field";
  $value_sql .= ", $value";
  
  }
  
  // There is no problem having duplicate forum names so we won't check for it.
  // Modified by Attached Forums MOD
  
  if (intval($HTTP_POST_VARS['old_cat_id']) != intval($HTTP_POST_VARS[POST_CAT_URL]))
  {
  $HTTP_POST_VARS['attached_forum_id']=-1;
  }
  
  $sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
  VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . intval($HTTP_POST_VARS['attached_forum_id']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
  // End Added by Attached Forums MOD
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
  }[/phpbb]
  
  
  Pomóżcie mi, proszę, zamienić to w taki sposób, żeby działało.

  

Odpowiedzi

• Wysłany: 16 Sie 2005, 16:31

  PACH

  

  

  
  Rejestracja: 18 Maj 2005, 17:43
  Posty: 181
  Pochwały: 23
  no dobra podaję rozwiazanie (przynajmniej u mnie dzała )
  zamień to
  

  Kod:

  //
  // Default permissions of public ::
  //
  $field_sql = "";
  $value_sql = "";
  while( list($field, $value) = each($forum_auth_ary) )
  {
  $field_sql .= ", $field";
  $value_sql .= ", $value";
  
  }
  
  // There is no problem having duplicate forum names so we won't check for it.
  // Modified by Attached Forums MOD
  
  if (intval($HTTP_POST_VARS['old_cat_id']) != intval($HTTP_POST_VARS[POST_CAT_URL]))
  {
  $HTTP_POST_VARS['attached_forum_id']=-1;
  }
  
  $sql = "INSERT INTO " . FORUMS_TABLE . " (forum_id, forum_name, cat_id, attached_forum_id, forum_desc, forum_order, forum_status, prune_enable" . $field_sql . ")
  VALUES ('" . $next_id . "', '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", " . intval($HTTP_POST_VARS['attached_forum_id']) . ", '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', $next_order, " . intval($HTTP_POST_VARS['forumstatus']) . ", " . intval($HTTP_POST_VARS['prune_enable']) . $value_sql . ")";
  // End Added by Attached Forums MOD
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
  }

  
  na
  

  Kod:

           //
           // Default permissions of public ::
           //
              /*Complete Messages System*/
                       while( list($field, $value) = each($forum_auth_ary) )
                       {
                              $FielVal_sql .= $field .'='.$value.', ';
                       }
                       if(isset($_POST['message_posting']))
                       {
                          $sqlUpdate .= "message_posting = '";
                          ForEach($_POST['message_posting'] as $IDMessage => $True)
                          {
                                  $sqlUpdate .= $IDMessage.';';
                          }
                          $sqlUpdate .= "', ";
                       }
                       if(isset($_POST['message_viewtopic']))
                       {
                          $sqlUpdate .= "message_viewtopic = '";
                          ForEach($_POST['message_viewtopic'] as $IDMessage => $True)
                          {
                                  $sqlUpdate .= $IDMessage.';';
                          }
                          $sqlUpdate .= "', ";
                       }
                       if(isset($_POST['message_viewforum']))
                       {
                          $sqlUpdate .= "message_viewforum = '";
                          ForEach($_POST['message_viewforum'] as $IDMessage => $True)
                          {
                                  $sqlUpdate .= $IDMessage.';';
                          }
                          $sqlUpdate .= "',";
                       }
           // There is no problem having duplicate forum names so we won't check for it.
           // Modified by Attached Forums MOD
     
           if (intval($HTTP_POST_VARS['old_cat_id']) != intval($HTTP_POST_VARS[POST_CAT_URL]))
           {
                 $HTTP_POST_VARS['attached_forum_id']=-1;
              }
  
        $sql = "INSERT INTO " . FORUMS_TABLE . "
                              SET $sqlUpdate
                                  forum_id = '" . $next_id . "',
                                  forum_name =  '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "',
                                   cat_id =  " . intval($HTTP_POST_VARS[POST_CAT_URL]) .  ",
                                  attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ",
                                  forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "',
                                  forum_order = $next_order,
                                  forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ",
                                  $FielVal_sql
                                  prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "";
     // End Added by Attached Forums MOD
           if( !$result = $db->sql_query($sql) )
           {
              message_die(GENERAL_ERROR, "Couldn't insert row in forums table", "", __LINE__, __FILE__, $sql);
           }

  
  
  wyciągnełem to z mojego forum (i lekko zmodyfikowałem bo u mnie jest trochę więcej modyfikacji). Powinno działać
  
  Pozdro
  PACH

  Autor postu otrzymał pochwałę

  

• Wysłany: 16 Sie 2005, 17:46

  myhair

  

  
  Rejestracja: 28 Maj 2005, 11:51
  Posty: 75
  Pochwały: 4
  Dzieki, sprawdze jak tylko znajde chwile czasu
  
  [ Dodano: 17 Sie 2005 15:49 ]
  W tym pliku jest jeszcze jeden fragment gdzie się gubię
  
  [phpbb]$sql = "UPDATE " . FORUMS_TABLE . "
  SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
  }
  [/phpbb]
  
  trzeba zamienić na
  
  [phpbb]/*Complete Messages System*/
  
  if(isset($_POST['message_posting']))
  {
  $sqlUpdate .= "message_posting = '";
  ForEach($_POST['message_posting'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewtopic']))
  {
  $sqlUpdate .= "message_viewtopic = '";
  ForEach($_POST['message_viewtopic'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewforum']))
  {
  $sqlUpdate .= "message_viewforum = '";
  ForEach($_POST['message_viewforum'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "',";
  }
  $sql = "UPDATE " . FORUMS_TABLE . "
  SET $sqlUpdate forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
  }[/phpbb]
  
  
  I znów tutaj mój kod wygląda inaczej:
  
  [phpbb]$sql = "UPDATE " . FORUMS_TABLE . "
  SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) .", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", enable_pluspoints = ". intval($_POST['enable_plus']).', enable_minuspoints = '.intval($_POST['enable_minus']) .", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
  // End Added by Attached Forums MOD
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
  }[/phpbb]
  
  
  W załączniku zamieszczam cały plik. Bardzo prosze o pomoc.

  Załączniki:

  Komentarz do pliku: admin_forums.php
  admin_forums.zip [7.41 KiB]
  Ściągnięto 113 razy
  

  

• Wysłany: 18 Sie 2005, 17:32

  PACH

  

  

  
  Rejestracja: 18 Maj 2005, 17:43
  Posty: 181
  Pochwały: 23
  dobra oto rozwiązanie
  zamiast
  

  Kod:

  $sql = "UPDATE " . FORUMS_TABLE . "
  SET forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) .", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", enable_pluspoints = ". intval($_POST['enable_plus']).', enable_minuspoints = '.intval($_POST['enable_minus']) .", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
  // End Added by Attached Forums MOD
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
  }

  
  wstaw to
  
  

  Kod:

  /*Complete Messages System*/
  
  if(isset($_POST['message_posting']))
  {
  $sqlUpdate .= "message_posting = '";
  ForEach($_POST['message_posting'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewtopic']))
  {
  $sqlUpdate .= "message_viewtopic = '";
  ForEach($_POST['message_viewtopic'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "', ";
  }
  if(isset($_POST['message_viewforum']))
  {
  $sqlUpdate .= "message_viewforum = '";
  ForEach($_POST['message_viewforum'] as $IDMessage => $True)
  {
  $sqlUpdate .= $IDMessage.';';
  }
  $sqlUpdate .= "',";
  }
  $sql = "UPDATE " . FORUMS_TABLE . "
  SET $sqlUpdate forum_name = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumname']) . "', cat_id = " . intval($HTTP_POST_VARS[POST_CAT_URL]) .", attached_forum_id = " . intval($HTTP_POST_VARS['attached_forum_id']) . ", forum_desc = '" . str_replace("\'", "''", $HTTP_POST_VARS['forumdesc']) . "', forum_status = " . intval($HTTP_POST_VARS['forumstatus']) . ", enable_pluspoints = ". intval($_POST['enable_plus']).', enable_minuspoints = '.intval($_POST['enable_minus']) .", prune_enable = " . intval($HTTP_POST_VARS['prune_enable']) . "
  WHERE forum_id = " . intval($HTTP_POST_VARS[POST_FORUM_URL]);
  // End Added by Attached Forums MOD
  if( !$result = $db->sql_query($sql) )
  {
  message_die(GENERAL_ERROR, "Couldn't update forum information", "", __LINE__, __FILE__, $sql);
  }
  
  

  
  
  sorry że tak długo czekałeś ale dopiero teraz miałem dostęp do wpełni działającego kompa. Myśle że powinni byc dobrze (zrobiłem to na szybko)

  Autor postu otrzymał pochwałę

  Uwagi moderatora PACH (dodane 15 Lis 2005, 17:34):

  Ostatnio edytowany przez PACH, 15 Lis 2005, 17:34, edytowano w sumie 1 raz

  

• Wysłany: 19 Sie 2005, 21:26

  myhair

  

  
  Rejestracja: 28 Maj 2005, 11:51
  Posty: 75
  Pochwały: 4
  Wielkie dzięki PACH, działa. Dwa plusiki za dwie pomoce

  

 

Strona 1 z 1 [ 5 posty(ów) ]