Player Status in DB - Page 4

bbq407 · *Last edited by bbq407; 04-25-2008 at 08:55.*

Why always [PSD] Error No.2003: Can't connect: Can't connect to MySQL server on "ip"(port) anyone can help me?

+ARUKARI- · 04-25-2008 , 09:15 Re: Player Status in DB (sqlstats Lite)

Quote:

Originally Posted by bbq407

Why always [PSD] Error No.2003: Can't connect: Can't connect to MySQL server on "ip"(port) anyone can help me?

1.Which do you use, Windows and Linux?
2.Where is your MySQL Server?(on the hlds-pc? or rental server?)

bbq407 · 04-25-2008 , 12:04 Re: Player Status in DB (sqlstats Lite)

1.Windows
2 Hlds-pc

DeuX · 04-25-2008 , 17:14 Re: Player Status in DB (sqlstats Lite)

Heh, Niceg!
But you need MySql Server, this plugin work only Mysql DB.
If you have a Windows paltform, download "psd_005_windows.sma"
But still i have problem, and i not understand why him always run errors

+ARUKARI- · 04-25-2008 , 18:29 Re: Player Status in DB (sqlstats Lite)

bbq407 and DeuX

1.80 SqlX modules seem to have malfunction.
try nightly build 1.81

Geri094 · 05-25-2008 , 05:01 Re: Player Status in DB (sqlstats Lite)

Hello!

I get this error, when i try to see the status:

TOP15 Játékos HelyezésNévFregekHalálokPontokTalálatokLövése kHeadshotokeff.acc.acc. hs
Notice: mysql_query(): MySQL error: Table 'zombiehun.statustable' doesn't exist in /nfs/extra/z/zo/zombiehun/wwwroot/rank.php: mysql_query on line 38
in /nfs/extra/prepend/prepend.php(159) : system created function on line 36

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /nfs/extra/prepend/prepend.php(120) : system created function on line 36

+ARUKARI- · *Last edited by +ARUKARI-; 05-25-2008 at 07:26.*

Geri094;
you get error.
Table 'zombiehun.statustable' doesn't exist

There is not a table of 'zombiehun.statustable' in your database.

It is necessary for you to confirm the following.
in server.cfg or sql.cfg or plugin source.
psd_tbname　"zombiehun.statustable"(default psd_tbname "statustable")

dekken · 05-25-2008 , 07:56 Re: Player Status in DB (sqlstats Lite)

may i ask if there's also in-game stats?
like saying /top15 will get you the Page from the hosted web?
or it just a web-front

+ARUKARI- · 05-25-2008 , 08:20 Re: Player Status in DB (sqlstats Lite)

Quote:

Originally Posted by dekken

may i ask if there's also in-game stats?
like saying /top15 will get you the Page from the hosted web?
or it just a web-front

this plugin has only the statistics which can read it from a csstats.dat.

dekken · *Last edited by dekken; 05-25-2008 at 12:56.*

PHP Code:


			
Warning:  mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/dekken/public_html/ranking_sample.php on line 39
 Player Ranking TOP15    rank  name kills deaths score hits shots hs eff. acc. acc. hs

also:

PHP Code:


			
[PSD] Error No.2003: Can't connect: Can't connect to MySQL server on '127.0.0.1' (111)

even tho i changed the HOST.