GetURL...

[spkka]

if ((PLAYER_STATS_ON= 1) and ( Text = '!stats' )) then
   begin
      Response:= GetURL(PLAYER_STATS_URL+'?name='+HTTPEncode(Name));
      ResponseLines:= xsplit(Response,chr(13));
      for i:=0 to ArrayHigh(ResponseLines) do       SayToPlayer(NametoID(Name),ResponseLines);   
   end;



//
Should work?

this is in const:
PLAYER_STATS_URL = 'http://localhost/Zitrostats/PlayerStats.php';
PLAYER_STATS_ON = 1

[EnEsCe]

It should, assuming you have a web server running on localhost with that same PHP script path.

[spkka]

yes i have...  I changed something in the script  of zitrostats  so it updates the logs to the index.php now, which works....

Only this line of code doesn't return anything from me

[EnEsCe]

Put in a WriteLn(Response); before you use xsplit and see if its returning stuff

[spkka]

returns this:
(02:29:08) Sorry could not find your stats

from this

<?php

define('INSTATS',true);
require('include/global.inc.php');

if (isset($_GET['name']) && trim($_GET['name']) != '')
{
   $name = $_GET['name'];
   if(!$player = $sql->fetcharray($sql->query("
      SELECT
         `points`,
         `kills`,
         `deaths`,
         `selfkills`,
         `last`
      FROM `$options[SQL_TABPREFIX]players`
      WHERE `player`='".addslashes($name)."'
      LIMIT 1
      "))) {
      die ('Sorry could not find your stats ');

[urraka]

the first script seems ok

The php script is like a pain in the ass, is it yours? I would suggest not coding everything in a single call like it does there so it's much easier to develop it. To make sure what's wrong I would first execute the query from some sql console or something, I guess you should have. Of course you should set the player name to the name you are testing. That way you make sure the problem isn't somewhere else. If it works fine I would rewrite that php code like this:

Code: [Select]

define('INSTATS',true);
require('include/global.inc.php');

if (isset($_GET['name']) && trim($_GET['name']) != '')
{
   $name = $_GET['name'];
   $query = $sql->query("SELECT
         `points`,
         `kills`,
         `deaths`,
         `selfkills`,
         `last`
      FROM `$options[SQL_TABPREFIX]players`
      WHERE `player`='".addslashes($name)."'
      LIMIT 1");

   $player = $sql->fetcharray($query);

   if(!$player) {
      die ('Sorry could not find your stats ');

It seems like the same, but I'm not really sure with the "if (!$player = $sql->fet......" part. I don't know if it's right the way it was writen.

[EnEsCe]

returns this:
(02:29:08) Sorry could not find your stats

Well then its not a problem with GetURL, its your script improperly coded.

[KeYDoN]

do
WriteLn('Name: ' + Name);

im quite sure its empty^^

[spkka]

indeed its empty

[KeYDoN]

well add the line at the begining of the function:
Name:=IdToName(ID);

and declare the var Name:string; if needed^^