TB DEV SZ разработка движка

I used backup database function in admin control panel to backup database, and now i want to restore but it say

Код: Выделить всё

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[TB Dev SZ Edition Debug] PHP Notice: in file /admin/admin_db_utilitie' at line 1 [1064]

SQL

<b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> INSERT INTO banlist (, , , , ) VALUES(NULL, NULL, NULL, NULL, NULL)

BACKTRACE

FILE: include/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: admin/admin_db_utilities.php
LINE: 933
CALL: dbal_mysql->sql_query()

plz help me

Do the following update http://svn.tbdevsz.ru/changeset/154/#file0 to admin/admin_db_utilities.php (or replace file with this http://svn.tbdevsz.ru/export/154/admin/ ... lities.php). Then backup database through acp and restore it.

I replace it with your file and now it say

Код: Выделить всё

Fatal error: Call to undefined function request_var() in /home/expressg/public_html/hdvnbits/admin/admin_db_utilities.php on line 573

Oh shit, i forgot that this function not present in 0.3.3.
Add following code at the top of global.php (after line

Код: Выделить всё

<?php

)

Код: Выделить всё

/**
* set_var
*
* Set variable, used by {@link request_var the request_var function}
*
* @access private
*/
function set_var(&$result, $var, $type, $multibyte = false)
{
   settype($var, $type);
   $result = $var;

   if ($type == 'string')
   {
      $result = trim(htmlspecialchars(str_replace(array("\r\n", "\r"), array("\n", "\n"), $result)));

      if (!empty($result))
      {
         // Make sure multibyte characters are wellformed
         if ($multibyte)
         {
            if (!preg_match('/^./u', $result))
            {
               $result = '';
            }
         }
      }

      $result = (STRIP) ? stripslashes($result) : $result;
   }
}

/**
* request_var
*
* Used to get passed variable
*/
function request_var($var_name, $default, $multibyte = false, $cookie = false)
{
   if (!$cookie && isset($_COOKIE[$var_name]))
   {
      if (!isset($_GET[$var_name]) && !isset($_POST[$var_name]))
      {
         return (is_array($default)) ? array() : $default;
      }
      $_REQUEST[$var_name] = isset($_POST[$var_name]) ? $_POST[$var_name] : $_GET[$var_name];
   }

   if (!isset($_REQUEST[$var_name]) || (is_array($_REQUEST[$var_name]) && !is_array($default)) || (is_array($default) && !is_array($_REQUEST[$var_name])))
   {
      return (is_array($default)) ? array() : $default;
   }

   $var = $_REQUEST[$var_name];
   if (!is_array($default))
   {
      $type = gettype($default);
   }
   else
   {
      list($key_type, $type) = each($default);
      $type = gettype($type);
      $key_type = gettype($key_type);
      if ($type == 'array')
      {
         reset($default);
         $default = current($default);
         list($sub_key_type, $sub_type) = each($default);
         $sub_type = gettype($sub_type);
         $sub_type = ($sub_type == 'array') ? 'NULL' : $sub_type;
         $sub_key_type = gettype($sub_key_type);
      }
   }

   if (is_array($var))
   {
      $_var = $var;
      $var = array();

      foreach ($_var as $k => $v)
      {
         set_var($k, $k, $key_type);
         if ($type == 'array' && is_array($v))
         {
            foreach ($v as $_k => $_v)
            {
               if (is_array($_v))
               {
                  $_v = null;
               }
               set_var($_k, $_k, $sub_key_type);
               set_var($var[$k][$_k], $_v, $sub_type, $multibyte);
            }
         }
         else
         {
            if ($type == 'array' || is_array($v))
            {
               $v = null;
            }
            set_var($var[$k], $v, $type, $multibyte);
         }
      }
   }
   else
   {
      set_var($var, $var, $type, $multibyte);
   }

   return $var;
}

Still have this error

Код: Выделить всё

General Error
SQL ERROR [ mysql4 ]

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[TB Dev SZ Edition Debug] PHP Notice: in file /admin/admin_db_utilitie' at line 1 [1064]

SQL

<b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> <b>[TB Dev SZ Edition Debug] PHP Notice</b>: in file <b>/admin/admin_db_utilities.php</b> on line <b>552</b>: <b>mysql_fetch_field(): supplied argument is not a valid MySQL result resource</b><br /> INSERT INTO banlist (, , , , ) VALUES(NULL, NULL, NULL, NULL, NULL)

BACKTRACE

FILE: include/db/mysql.php
LINE: 133
CALL: dbal->sql_error()

FILE: admin/admin_db_utilities.php
LINE: 894
CALL: dbal_mysql->sql_query()

You must backup database with new file. Your's old backup will not work cause it's backuped with file which contains errors.

Since I can't restore my database, I move my tracker to another server and create a fresh database but it's get an error

Код: Выделить всё

SQL ERROR [ mysql4 ]

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

My server use MySQL5 , is that the problem?

Your's mysql server not running or incorrect socket in my.cnf writed or... There is many reasons for this error, and tracker source does not connected with this error

Thanks, fixed

But now some of my users get this error

What type and version of webserver running on your hosting?
Does magic quotes enabled in your php.ini?

thanks, fixed it!
Some more question:

1. Can I install a shoutbox? How?
2. How to allow html in torrent's description ? I want to add youtube video in the description.

How can I create a "free torrents" filter? So when user click on it , they will show only free torrents ?

it filter already exists in browse.php

Thank man. Found it

In bit-hdtv theme, how can I change the text on the menu? Like from "FAQ" to "Wiki" ..etc

All language variables store in lang files in "languages" folder

Thanks !

Can I ban some of torrent clients? I go to ACP but it just have IP and email banning

only manually through announce.php

How can I change the text color of user class? Like from Red(Sysop) to Blue, or Orange(Admin) to Yellow?

in global.php

Код: Выделить всё

function get_user_class_color($class, $username) {

Thanks

Question: How to add more detail to userbar? Like uploaded, downloaded..etc

Also how to get rid of this

Following errors occured:
Invalid filename
Only english letters, numbers and symbols _~!@$^()&',.-, and space are allowed in filename
Your z-d+d@ filename is invalid

I believe other trackers allow symbols and unicode chars, and since my users use unicode chars as well so this error is the pain in the ass(when you have to rename 100+ files)