Windows Mysql Problem :S

[Muciz]

I got this errors in mysql can anyone help me please?


mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'hellfire.z_ots_comunication' doesn't exist (1146)


mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)

+

A Database Error Occurred
Error Number: 1054

Unknown column 'nickname' in 'where clause'

SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Dont work'

 

[Cronox]

1. mysql_real_query(): SELECT * FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR: Table 'hellfire.z_ots_comunication' doesn't exist (1146)
You need execute query:

CREATE TABLE `z_ots_comunication` (
  `id` INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NOT NULL,
  `type` VARCHAR(255) NOT NULL,
  `action` VARCHAR(255) NOT NULL,
  `param1` VARCHAR(255) NOT NULL,
  `param2` VARCHAR(255) NOT NULL,
  `param3` VARCHAR(255) NOT NULL,
  `param4` VARCHAR(255) NOT NULL,
  `param5` VARCHAR(255) NOT NULL,
  `param6` VARCHAR(255) NOT NULL,
  `param7` VARCHAR(255) NOT NULL,
  `delete_it` INT(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

2. mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
you don't have added table onlinetimetoday, you error is in import database? use this:
http://otland.net/f118/gesior-acc-maker-forgotten-server-0-3-5-powergamers-online-time-stats-44762/

3. SELECT `id` FROM (`accounts`) WHERE `nickname` = 'Dont work'
try this

ALTER TABLE `accounts` ADD `nickname` VARCHAR(255) NOT NULL DEFAULT '';

 

[Muciz]

nickname code didnt work it maked bigger problem