How do i fix this? Mysql Error.

[Dassnung]

Here , how do i fix this?

mysql_real_query<>: UPDATE 'players' SET 'onlinetimetoday'= Players.onlinetimemetod ay+60, 'onlinetimeall'=Players.onlinetimeall+60 WHERE 'online' = 1; - MYSQL ERROR: Unknown column 'Onlinetimetoday' in 'field list' [1054]

 

[Cykotitan]

Remove script from globalevents if you're not going to use Powergamers/Online time on website

Or execute this in phpMyAdmin:

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`;

 

[Dassnung]

remove script from globalevents if you're not going to use powergamers/online time on website

or execute this in phpmyadmin:

alter table `players` add `exphist_lastexp` bigint( 255 ) not null default '0',
add `exphist1` bigint( 255 ) not null default '0',
add `exphist2` bigint( 255 ) not null default '0',
add `exphist3` bigint( 255 ) not null default '0',
add `exphist4` bigint( 255 ) not null default '0',
add `exphist5` bigint( 255 ) not null default '0',
add `exphist6` bigint( 255 ) not null default '0',
add `exphist7` bigint( 255 ) not null default '0',
add `onlinetimetoday` bigint( 255 ) not null default '0',
add `onlinetime1` bigint( 255 ) not null default '0',
add `onlinetime2` bigint( 255 ) not null default '0',
add `onlinetime3` bigint( 255 ) not null default '0',
add `onlinetime4` bigint( 255 ) not null default '0',
add `onlinetime5` bigint( 255 ) not null default '0',
add `onlinetime6` bigint( 255 ) not null default '0',
add `onlinetime7` bigint( 255 ) not null default '0',
add `onlinetimeall` bigint( 255 ) not null default '0';
update `players` set `exphist_lastexp`=`players`.`experience`;

thanks so much cyko ! Rep++++++++++++++++++++++++++++++++++++++++++++++++