I cant ban player :(

[kret]

I cant ban any1 .... i type RULE VIOLATION and BANISHMENT player is kicked and can login again .. in console i have this error

mysql_real_query(): INSERT INTO `bans` (`type`, `value`, `expires`, `added`, `ad
minid`, `comment`, `reason`, `action`) VALUES (3, 240892, 1213387843, 1212783043
, 21, 'fds', 3, 2);: MYSQL ERROR: Unknown column 'adminid' in 'field list'

i using tfs 0.3 rev 853 and i change bans dB to new

 

[Clary]

delete adminid column?

 

[kret]

dont work :{

 

[rockseller]

tell me what distro you are using, and if you can, export the table 'bans' and post the text here with code tags.

 

[kret]

Distro ? XD

I use XAMPP 1.6.6a and TheForgottenServer 0.3 revision 853

This is my BANS database

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Czas wygenerowania: 06 Cze 2008, 23:20
-- Wersja serwera: 5.0.51
-- Wersja PHP: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Baza danych: `siup`
--

-- --------------------------------------------------------

--
-- Struktura tabeli dla  `bans`
--

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `type` tinyint(1) NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
  `value` int(10) unsigned NOT NULL COMMENT 'ip, player guid, account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'mask',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(10) unsigned NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL default '0',
  `action` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Zrzut danych tabeli `bans`
--

INSERT INTO `bans` (`id`, `type`, `value`, `param`, `active`, `expires`, `added`, `comment`, `reason`, `action`) VALUES
(1, 0, 0, 4294967295, 0, 0, 0, '', 0, 0);

 

[rockseller]

In TFS you should use /b Charname to ban someone (as far as i know). But if you want to do it that way, delete the table BANS, and execute this from SQL:

-- Struktura tabeli dla  `bans`
--

CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(10) unsigned NOT NULL auto_increment,
`adminid` int(10) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban',
  `value` int(10) unsigned NOT NULL COMMENT 'ip, player guid, account number',
  `param` int(10) unsigned NOT NULL default '4294967295' COMMENT 'mask',
  `active` tinyint(1) NOT NULL default '1',
  `expires` int(10) unsigned NOT NULL,
  `added` int(10) unsigned NOT NULL,
  `comment` text NOT NULL,
  `reason` int(10) unsigned NOT NULL default '0',
  `action` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `type` (`type`,`value`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Zrzut danych tabeli `bans`
--

 

[kret]

omfg it works ! I <3 U :**

 

[rockseller]

You are welcome :>