A little mod i was trying to make....

[ignite]

It was worth a try

[N00b]

Re: A little mod i was trying to make....

LMFAO! :mrgreen:

[hamster01]

Re: A little mod i was trying to make....

Havn't tested this yet but the logical is there..

 

<?php
session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
$qw = mysql_query("SELECT ip FROM users");
echo '<table>';
while($q = mysql_fetch_array($qw){
$ss = mysql_query("SELECT * FROM users WHERE ip='{$q['ip']}'");
$s = mysql_fetch_array($ss);
echo '<tr>' . $s['userid'] . '</tr><tr>' . $s['username'] . '</tr>';
}
echo '</table>';
$h->endpage();
?>

[03laceys]

Re: A little mod i was trying to make....

Parse error: syntax error, unexpected '{' in /home/game/public_html/multi.php on line 21

i tried turning it into } you then get Parse error: syntax error, unexpected '}' in /home/game/public_html/multi.php on line 21

so i tried deleting it you then get this Parse error: syntax error, unexpected T_VARIABLE in /home/game/public_html/multi.php on line 22

any help?

[hamster01]

Re: A little mod i was trying to make....

what script?

Mine is wrote perfectly, except for the mysql bug.

[03laceys]

Re: A little mod i was trying to make....

yours mate i added it and as said i get what i said lol

[hamster01]

Re: A little mod i was trying to make....

try this:

<?php
session_start();
require "global_func.php";
if($_SESSION['loggedin']==0) { header("Location: login.php");exit; }
$userid=$_SESSION['userid'];
require "header.php";
$h = new headers;
$h->startheaders();
include "mysql.php";
global $c;
$is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error());
$ir=mysql_fetch_array($is);
check_level();
$fm=money_formatter($ir['money']);
$cm=money_formatter($ir['crystals'],'');
$lv=date('F j, Y, g:i a',$ir['laston']);
$h->userdata($ir,$lv,$fm,$cm);
$h->menuarea();
$qw = mysql_query("SELECT ip FROM users");
echo '<table>';
while($q = mysql_fetch_array($qw)){
$ss = mysql_query("SELECT * FROM users WHERE ip='{$q['ip']}'");
$s = mysql_fetch_array($ss);
echo '<tr>' . $s['userid'] . '</tr><tr>' . $s['username'] . '</tr>';
}
echo '</table>';
$h->endpage();
?>

[03laceys]

Re: A little mod i was trying to make....

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/game/public_html/multi.php on line 21

[hamster01]

Re: A little mod i was trying to make....

then you have no multi;s

[03laceys]

Re: A little mod i was trying to make....

ok then mate lol

[03laceys]

Re: A little mod i was trying to make....

is there much point me aving this because i have the multi block in register

although i made a new account using proxie and signed in on that so they both come up on last ip as the same anyway for it to check that?

[KyleCrispy]

Re: A little mod i was trying to make....

it says all my users are multis :lol:

[Decepti0n]

Re: A little mod i was trying to make....

Also you'll have one query per user, and completely own your mysql server

[hamster01]

Re: A little mod i was trying to make....

havn't thought of that one, im used to reaching my 8meg limit :D