[Miko000000]

Originally Posted by Lightokun First start the plugin. Then check if tables exists: There are must be only "uq_jumps" "uq_players" "uq_block_tops" tables. If they doesn't exists, check your config and version of the plugin.

Plugin doesn´t show lj top and it said :
[unique-kz] Web Mod doesnt work without Sql Module. Set cvar kz_uq_sql to "1" but mysql sqlite modules are active and kz_uq_sql is too on 1

[Lightokun]

You need only mysql module.
Check cvar by entering amx_cvar kz_uq_sql ingame (if you are admin) or kz_uq_sql in server console. You need to restart a map after cvars are changed. Also don't forget to change cvars in config file.

Here is the sql structure of the tables.

CREATE TABLE IF NOT EXISTS `uq_block_tops` (
  `pid` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `distance` int(10) NOT NULL,
  `jumpoff` int(10) NOT NULL,
  `block` varchar(5) NOT NULL,
  `pspeed` int(3) NOT NULL,
  `wpn` varchar(32) NOT NULL,
  KEY `pid` (`pid`,`type`,`distance`,`jumpoff`,`pspeed`,`wpn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `uq_jumps` (
  `pid` int(11) NOT NULL,
  `type` varchar(32) NOT NULL,
  `distance` int(10) NOT NULL,
  `maxspeed` int(10) NOT NULL,
  `prestrafe` int(10) NOT NULL,
  `strafes` int(2) NOT NULL,
  `sync` int(3) NOT NULL,
  `ddbh` int(3) NOT NULL DEFAULT '0',
  `pspeed` int(3) NOT NULL,
  `wpn` varchar(32) NOT NULL,
  KEY `pid` (`pid`,`type`,`distance`,`maxspeed`,`prestrafe`,`strafes`,`sync`,`ddbh`,`pspeed`,`wpn`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `uq_players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `ip` varchar(39) NOT NULL,
  `authid` varchar(35) NOT NULL,
  `lastseen` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`,`authid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

[Miko000000]

if i set kz_uq_sql to 1 plugins will paused. Whyy ?

[Miko000000]

Could not connect to SQL database; Error #2003: Can't connect to MySQL server on 'mysql.webzdarma.cz' (111)
L 04/22/2011 - 20:47:03: [uq_jumpstats_tops.amxx] uq_jumpstats: Could not connect to SQL database; Error #2003: Can't connect to MySQL server on 'mysql.webzdarma.cz' (111). But this is mail of my host :

Server mysql.webzdarma.cz Database face Name of database:
face

[Ex3cuTioN]

I'm confused.

In config.cfg i have:

PHP Code:

// Options for Sql Module
kz_uq_host "46.102.253.130" //IP of my site (what should be here?)
kz_uq_user "lafelro_train"
kz_uq_pass "******"
kz_uq_db "lafelro_uq_jumpstats" 


And in config.php i have:

PHP Code:

$mysql['host'] = 'localhost'; // mysql db host
$mysql['user'] = 'lafelro_train'; // mysql db user
$mysql['pass'] = '******'; // mysql db user pass
$mysql['port'] = 3306; // mysql port; default - 3306
$mysql['db'] = 'lafelro_uq_jumpstats'; // mysql database name 


1.The server is crashing if i put that IP there.If i put localhost, it will say:

PHP Code:

L 05/22/2011 - 14:06:42: [uq_jumpstats.amxx] uq_jumpstats: Could not connect to SQL database; Error #2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
L 05/22/2011 - 14:06:42: [uq_jumpstats_tops.amxx] uq_jumpstats: Could not connect to SQL database; Error #2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
) 


If i leave it default it says:

PHP Code:

L 05/22/2011 - 14:09:59: -------- Mapchange to kz_longjumps2 --------
L 05/22/2011 - 14:09:59: [uq_jumpstats.amxx] uq_jumpstats: Could not connect to SQL database; Error #2003: Can't connect to MySQL server on '127.0.0.1' (111)
L 05/22/2011 - 14:09:59: [uq_jumpstats_tops.amxx] uq_jumpstats: Could not connect to SQL database; Error #2003: Can't connect to MySQL server on '127.0.0.1' (111) 


2.On the webhost it says there are no tables (that's true).

http://www.lafel.ro/uq_jumpstats/index.php

What i'm doing wrong?

[borjomi]

did you try to google you error?

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

but i think we need wait ligh for sql consultations

[Gam3ronE]

Thanks epic plugin good job.

[Morten1510]

Thanks for a really nice jump plugin!

But some of the players on the servers sometimes gets this msg in chat :


[Xtreme-Surfs] Player Probably use CountJump Script!!!
[Xtreme-Surfs] Player Probably use CountJump Script!!!
[Xtreme-Surfs] Player Probably use CountJump Script!!!

When they get 1 100% sync

in the uq_jumpstats logs i get this :

---------------------------------------------------
05/29/11 21:15:13 |Player |STEAM_0:1:540722 |85.226.144.9 |Script |Stats Blocked

Type: CountJump ::: Weapon: weapon_usp
Distance: 260.136 Maxspeed: 338.786 Prestrafe: 294.991 Strafes: 8 Sync: 70

Total Frames: 104
Cheated Frames: 68

1 11.711 0.000 7.6% 100%
2 12.984 0.000 16.4% 66%
3 11.821 0.413 14.0% 78%
4 6.690 4.293 14.4% 81%
5 0.586 5.852 13.4% 53%
6 0.000 7.595 12.6% 70%
7 0.000 17.670 12.3% 45%
8 0.000 6.507 8.8% 80%
---------------------------------------------------

Our server uses 100aa mostly players uses 131 fps, since we are a surf server.

Should i worry that some of them might uses scripts or what?

[borjomi]

mm realy dont know how script detector work with not standart settings, but you can easy turn off it (turn off notify message with cvar)

[Morten1510]

Originally Posted by borjomi mm realy dont know how script detector work with not standart settings, but you can easy turn off it (turn off notify message with cvar)

Ye i just turned it off then ;)

2 more question, how do i turn these info off in the chat?

[Xtreme-Surfs] player is now 9 in dcj top with 260.539733
[Xtreme-Surfs] player is now 12 in lj blocktop with 216 block

They should count in the tops, but not show in the chat.

Also you should make so you can see peoples stats when you spec them