[wicho]

Thx for the info..

[t1m4444]

Originally Posted by yokomo Hi anyone success running this plugin with current beta hlds and current amx183? My server always crash when someone join the server.

This is problem:
not working

	format(g_Query,charsmax(g_Query),"SELECT `id`, `ammo`, `zclass`, `hclass`, `server` FROM `zp_players` \
			LEFT JOIN `zp_server_players` \
			ON `zp_server_players`.`id_player` = `zp_players`.`id`\
			WHERE `%s`='%s' %s", whereis, uniqid, condition)

working

	format(g_Query,charsmax(g_Query),"SELECT `id`, `ammo`, `zclass`, `hclass` FROM `zp_players` \
			WHERE `%s`='%s' %s", whereis, uniqid, condition)

[Kunka]

Hello guys,
I used this plugin for three years and I never had a problem with it. But now, when I copied all old files to my zombie server - plugin stopped working. I can connect with the database, but when I change map on the server - the start value of ammo pack is 5, always. Plugin doesn't save ammo packs. How to fix it?

[smoka]

Originally Posted by Kunka Hello guys, I used this plugin for three years and I never had a problem with it. But now, when I copied all old files to my zombie server - plugin stopped working. I can connect with the database, but when I change map on the server - the start value of ammo pack is 5, always. Plugin doesn't save ammo packs. How to fix it?

same problem here im aware this is old thread and none replied for really long time, but im having the same problem, but its just ammo packs problem, ammo packs just not loading even tho they are inside the DB, i assume that might be caused by the auth type bcuz im using just nick but im looking for any solution

[New and Clueless]

man it would be awesome if there was a video or something or a good guide on how to set this up.

[Kakarot47]

i want to set csstats SQL on webhost but when i try to creat table it giving me error

PHP Code:

SQL query:

INSERT INTO  `zp_weapons` (  `id` ,  `name` ) 
VALUES ( 1,  'P228' ) , ( 3,  'SCOUT' ) , ( 4,  'HEGRENADE' ) , ( 5,  'XM1014' ) , ( 6,  'C4' ) , ( 7,  'MAC10' ) , ( 8,  'AUG' ) , ( 9,  'SMOKEGRENADE' ) , ( 10,  'ELITE' ) , ( 11,  'FIVESEVEN' ) , ( 12,  'UMP45' ) , ( 13,  'SG550' ) , ( 14,  'GALIL' ) , ( 15,  'FAMAS' ) , ( 16,  'USP' ) , ( 17,  'GLOCK18' ) , ( 18,  'AWP' ) , ( 19,  'MP5NAVY' ) , ( 20,  'M249' ) , ( 21,  'M3' ) , ( 22,  'M4A1' ) , ( 23,  'TMP' ) , ( 24,  'G3SG1' ) , ( 25, 'FLASHBANG' ) , ( 26,  'DEAGLE' ) , ( 27,  'SG552' ) , ( 28,  'AK47' ) , ( 29,  'KNIFE' ) , ( 30,  'P90' ) ;


MySQL said: Documentation

#1062 - Duplicate entry '1' for key 'PRIMARY' 


SQL FULL CODE

Spoiler

CREATE TABLE IF NOT EXISTS `zp_classes` (
  `id` int(10) unsigned NOT NULL,
  `name` varchar(64) NOT NULL,
  `info` varchar(64) NOT NULL,
  `hp` int(10) unsigned NOT NULL,
  `speed` int(10) unsigned NOT NULL,
  `grav` decimal(5,2) NOT NULL,
  `kb` decimal(5,2) NOT NULL,
  UNIQUE KEY `id` (`id`)
)DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_class_stats` (
  `id` int(10) unsigned NOT NULL,
  `id_player` int(10) unsigned NOT NULL,
  `infect` int(10) unsigned NOT NULL default '0',
  `kills` int(10) unsigned NOT NULL default '0',
  `death` int(10) unsigned NOT NULL default '0',
  `games` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`,`id_player`)
)DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_graph` (
  `time` int(10) unsigned NOT NULL,
  `connections` int(2) unsigned NOT NULL,
  `kills` int(10) unsigned NOT NULL,
  `infects` int(10) unsigned NOT NULL,
  `damage` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`time`)
)DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_maps` (
  `id` int(11) NOT NULL auto_increment,
  `map` varchar(32) NOT NULL,
  `zombie_win` int(11) NOT NULL default '0',
  `human_win` int(11) NOT NULL default '0',
  `tie` int(11) NOT NULL default '0',
  `games` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `map` (`map`)
) DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_players` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `ammo` int(10) unsigned NOT NULL default '0',
  `total_ammo` int(10) unsigned NOT NULL default '0',
  `nick` varchar(32) character set utf8 NOT NULL,
  `ip` varchar(32) character set utf8 NOT NULL,
  `steam_id` varchar(32) character set utf8 NOT NULL,
  `total_damage` int(10) unsigned NOT NULL default '0',
  `last_join` int(10) unsigned NOT NULL default '0',
  `last_leave` int(10) unsigned NOT NULL default '0',
  `first_zombie` int(11) NOT NULL default '0',
  `infect` int(11) NOT NULL default '0',
  `zombiekills` int(11) NOT NULL default '0',
  `humankills` int(11) NOT NULL default '0',
  `nemkills` int(11) NOT NULL default '0',
  `survkills` int(11) NOT NULL default '0',
  `suicide` int(11) NOT NULL default '0',
  `death` int(11) NOT NULL default '0',
  `infected` int(11) NOT NULL default '0',
  `online` int(11) NOT NULL default '0',
  `class` int(10) unsigned NOT NULL default '0',
  `nemesis` int(10) unsigned NOT NULL default '0',
  `survivor` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `nick` (`nick`,`ip`,`steam_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_server_players` (
  `id_player` int(10) unsigned NOT NULL,
  `server` varchar(25) NOT NULL,
  UNIQUE KEY `id_player` (`id_player`)
)DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_shoots` (
  `id_weapon` int(10) unsigned NOT NULL,
  `id_player` int(10) unsigned NOT NULL,
  `shoot` int(10) default '0',
  `hit_head` int(11) default '0',
  `hit_chest` int(11) NOT NULL default '0',
  `hit_stomach` int(11) NOT NULL default '0',
  `hit_leftarm` int(11) NOT NULL default '0',
  `hit_rightarm` int(11) NOT NULL default '0',
  `hit_leftleg` int(11) NOT NULL default '0',
  `hit_rightleg` int(11) NOT NULL default '0',
  `hit_shield` int(11) NOT NULL default '0',
  `kills` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id_player`,`id_weapon`)
)DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `zp_weapons` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`)
) DEFAULT CHARSET=utf8;

INSERT INTO `zp_weapons` (`id`, `name`) VALUES
(1, 'P228'),
(3, 'SCOUT'),
(4, 'HEGRENADE'),
(5, 'XM1014'),
(6, 'C4'),
(7, 'MAC10'),
(8, 'AUG'),
(9, 'SMOKEGRENADE'),
(10, 'ELITE'),
(11, 'FIVESEVEN'),
(12, 'UMP45'),
(13, 'SG550'),
(14, 'GALIL'),
(15, 'FAMAS'),
(16, 'USP'),
(17, 'GLOCK18'),
(18, 'AWP'),
(19, 'MP5NAVY'),
(20, 'M249'),
(21, 'M3'),
(22, 'M4A1'),
(23, 'TMP'),
(24, 'G3SG1'),
(25, 'FLASHBANG'),
(26, 'DEAGLE'),
(27, 'SG552'),
(28, 'AK47'),
(29, 'KNIFE'),
(30, 'P90');

CREATE VIEW `zp_class_sum_stats` AS SELECT `zp_class_stats`.`id` AS `id`,SUM(`zp_class_stats`.`infect`) AS `infect`,SUM(`zp_class_stats`.`kills`) AS `kills`,SUM(`zp_class_stats`.`death`) AS `death`,SUM(`zp_class_stats`.`games`) AS `games` FROM `zp_class_stats` GROUP BY `zp_class_stats`.`id`;

CREATE VIEW `zp_weapon_stat` AS SELECT `zp_shoots`.`id_weapon` AS `id_weapon`,`zp_weapons`.`name` AS `name`,SUM(`zp_shoots`.`shoot`) AS `shoot`,SUM(`zp_shoots`.`hit_head`) AS `hit_head`,SUM(`zp_shoots`.`hit_chest`) AS `hit_chest`,SUM(`zp_shoots`.`hit_stomach`) AS `hit_stomach`,SUM(`zp_shoots`.`hit_leftarm`) AS `hit_leftarm`,SUM(`zp_shoots`.`hit_rightarm`) AS `hit_rightarm`,SUM(`zp_shoots`.`hit_leftleg`) AS `hit_leftleg`,SUM(`zp_shoots`.`hit_rightleg`) AS `hit_rightleg`,SUM(`zp_shoots`.`kills`) AS `kills` FROM (`zp_shoots` JOIN `zp_weapons`) WHERE (`zp_shoots`.`id_weapon` = `zp_weapons`.`id`) GROUP BY `zp_shoots`.`id_weapon`;

[gRfd]

zombie plague 50 version not load ammo :/ How to fix ?