(Database) Lost column, how to fix? rep++

[Ezak]

I got my new noobwar ot going but the sql file i had for that ot had disabled the frag system and deaths, so deaths and frags doesnt show up or count on the homepage. After some thinking i wanted to enable it, but how shall i know what column is "dropped".
You can see on the homepage that the frags and deaths doesnt count. Is it a command for this or something? REP++

Homepage: Noobmania.gzh.nu

 

[Super Nova]

I got my new noobwar ot going but the sql file i had for that ot had disabled the frag system and deaths, so deaths and frags doesnt show up or count on the homepage. After some thinking i wanted to enable it, but how shall i know what column is "dropped".
You can see on the homepage that the frags and deaths doesnt count. Is it a command for this or something? REP++

Homepage: Noobmania.gzh.nu

If you deleted the columns, try downloading the same .sql file and putting it back, if the server in the config.lua is set to pvp-enforced, then frags will not count. Hope this helps =)

 

[Ezak]

If i put it back i will loose all player accounts and stuff, isnt it a way to just import deaths and frags. Hmm the server is not Pvp-e

 

[Strasxni]

I think i can help you. Give me just link, of original .sql file to download.

 

[Super Nova]

If i put it back i will loose all player accounts and stuff, isnt it a way to just import deaths and frags. Hmm the server is not Pvp-e

You can create another database with another .sql file, and right click on the table(s) that you want. Then click Export table, then select that database that your using for your ot =)

 

[Ezak]

MEGAUPLOAD - The leading online storage and file delivery service

Here it is, its like 11 mb


Edit : Or w8, ill upload the one im using, its smaller

Thanks nova ill try it

 

[Ezak]

or well, it was the only i found

 

[Strasxni]

This is original one? No edited?
I'm reinstalling xampp atm...

 

[Ezak]

This is the one im using, download it : MEGAUPLOAD - The leading online storage and file delivery service

The real one u can just download from a tfs version. Mysql.sql

I think its player_deaths and killers that have been dropped

 

[stian]

CREATE TABLE IF NOT EXISTS `player_deaths` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `player_id` int(11) NOT NULL,
  `date` bigint(20) unsigned NOT NULL,
  `level` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `player_killers` (
  `kill_id` int(11) NOT NULL,
  `player_id` int(11) NOT NULL,
  KEY `kill_id` (`kill_id`),
  KEY `player_id` (`player_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;