Webwereld

Online

Gestart doorOne2xs10 reacties32 weergaven
Log in om mee te praten

11 berichten · pagina 1 van 1

One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"inc/functies.php"[/COLOR][COLOR= #007700]);[/COLOR]
boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Online leden[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS onlinecount FROM member_online WHERE uLast, INTERVAL 150 SECOND > NOW()"[/COLOR][COLOR= #007700]))[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Er [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]is [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] gebruiker[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]zijn [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]geen[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$rows[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000] gebruikers[/COLOR][COLOR= #007700]) .[/COLOR]  [COLOR= #DD0000] actief.<br />[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$online_query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `member_online` WHERE uLast, INTERVAL 150 SECOND > NOW() ORDER BY `uLast` DESC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<table><tr><td><strong>Gebruikersnaam</strong></td><td><strong>Laatst gezien:</strong></td><td><strong>Waar:</strong></td></tr>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td style="width: 150px;"><a href="index.php?p=profiel&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000];font-weight: bold;width: 150px;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</span></a></td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uLast[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</table>[/COLOR][COLOR= #007700];
    }[/COLOR]
onder[COLOR= #007700]();[/COLOR]
?>


das me code
me error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/fmgroup/public_html/linspin.nl/v1/online.php on line 4

Notice: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near INTERVAL 150 SECOND > NOW() at line 1 in /home/fmgroup/public_html/linspin.nl/v1/online.php on line 4
Er zijn geen gebruikers actief.

Notice: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near INTERVAL 150 SECOND > NOW() ORDER BY `uLast` DESC at line 1 in /home/fmgroup/public_html/linspin.nl/v1/online.php on line 7

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fmgroup/public_html/linspin.nl/v1/online.php on line 8

wat is er fout?
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
[COLOR= #0000BB]<?php[/COLOR]
[URL="http://www.php.net/include"]include[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"inc/functies.php"[/COLOR][COLOR= #007700]);[/COLOR]
boven[COLOR= #007700]([/COLOR][COLOR= #DD0000]Online leden[/COLOR][COLOR= #007700]);[/COLOR]
    [COLOR= #0000BB]$q[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT COUNT(1) AS onlinecount FROM member_online WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW()"[/COLOR][COLOR= #007700]))[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]=[/COLOR] [COLOR= #0000BB]$q[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]onlinecount[/COLOR][COLOR= #007700]];[/COLOR]
    [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]Er [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]1[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]is [/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700].[/COLOR] [COLOR= #DD0000] gebruiker[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #DD0000]zijn [/COLOR] [COLOR= #007700]. ([/COLOR][COLOR= #0000BB]$rows[/COLOR] [COLOR= #007700]==[/COLOR] [COLOR= #0000BB]0[/COLOR] [COLOR= #007700]?[/COLOR] [COLOR= #DD0000]geen[/COLOR] [COLOR= #007700]:[/COLOR] [COLOR= #0000BB]$rows[/COLOR][COLOR= #007700]) .[/COLOR] [COLOR= #DD0000] gebruikers[/COLOR][COLOR= #007700]) .[/COLOR]  [COLOR= #DD0000] actief.<br />[/COLOR][COLOR= #007700];[/COLOR]
    [COLOR= #0000BB]$online_query[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_query"]mysql_query[/URL][COLOR= #007700]([/COLOR][COLOR= #DD0000]"SELECT * FROM `member_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC"[/COLOR][COLOR= #007700])[/COLOR] or [URL="http://www.php.net/trigger_error"]trigger_error[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_error"]mysql_error[/URL][COLOR= #007700]());[/COLOR]
    [URL="http://www.php.net/if"]if[/URL][COLOR= #007700]([/COLOR][URL="http://www.php.net/mysql_num_rows"]mysql_num_rows[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]) >[/COLOR] [COLOR= #0000BB]0[/COLOR][COLOR= #007700])
    {[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<table><tr><td><strong>Gebruikersnaam</strong></td><td><strong>Laatst gezien:</strong></td><td><strong>Waar:</strong></td></tr>[/COLOR][COLOR= #007700];[/COLOR]
        [URL="http://www.php.net/while"]while[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR] [COLOR= #007700]=[/COLOR] [URL="http://www.php.net/mysql_fetch_assoc"]mysql_fetch_assoc[/URL][COLOR= #007700]([/COLOR][COLOR= #0000BB]$online_query[/COLOR][COLOR= #007700]))
        {[/COLOR]
            [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]<tr><td style="width: 150px;"><a href="index.php?p=profiel&amp;id=[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uId[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]"><span style="color:[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uCol[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000];font-weight: bold;width: 150px;">[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uName[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</span></a></td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uLast[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td><td>[/COLOR] [COLOR= #007700].[/COLOR] htmlentities[COLOR= #007700]([/COLOR][COLOR= #0000BB]$online[/COLOR][COLOR= #007700][[/COLOR][COLOR= #DD0000]uPage[/COLOR][COLOR= #007700]]) .[/COLOR] [COLOR= #DD0000]</td></tr>[/COLOR][COLOR= #007700];
        }[/COLOR]
        [URL="http://www.php.net/echo"]echo[/URL] [COLOR= #DD0000]</table>[/COLOR][COLOR= #007700];
    }[/COLOR]
onder[COLOR= #007700]();[/COLOR]
?>
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
@luuk
hij ziet me nu niet als online
PS: in header heb ik ook dit:

if(isset($_SESSION[uId]))
{
$f55 = mysql_query("SELECT * FROM `member_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC") or trigger_error(mysql_error());
    if(mysql_num_rows($f55) == 0)
    {
mysql_query("INSERT INTO member_online (uLast, uPage, uId) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". $_SESSION[uId] .")") or die(mysql_error());
    }else{
mysql_query("UPDATE member_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
mysql_query("UPDATE member_accounts SET uLast = NOW() WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
}
}


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near /v1/online,13) at line 1
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
if(isset($_SESSION[uId]))
{
$f55 = mysql_query("SELECT * FROM `member_online` WHERE DATE_ADD(uLast, INTERVAL 150 SECOND) > NOW() ORDER BY `uLast` DESC") or trigger_error(mysql_error());
    if(mysql_num_rows($f55) == 0)
    {
mysql_query("INSERT INTO member_online (uLast, uPage, uId) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". $_SESSION[uId] .")") or die(mysql_error());
    }else{
mysql_query("UPDATE member_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
mysql_query("UPDATE member_accounts SET uLast = NOW() WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
}
}
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
TNX
werkt biggrin
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Nice =D
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
nu nog iets voor gasten maken om die te laten zien biggrinalleen dan weet ik helemaal niet hoe moet emo
nu krijg ik steeds:
Duplicate entry 13 for key 1

PS: 13 is mijn ID
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
komt het misschien door de sql?

CREATE TABLE IF NOT EXISTS `member_online` (
  `uId` int(11) NOT NULL,
  `uLast` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `uPage` varchar(255) NOT NULL,
  PRIMARY KEY  (`uId`),
  KEY `uId` (`uId`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;


EDIT:
sorry voor dubelpost + bumb veel te snel
0
Luukvdo

Lid

Berichten
18.482
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
if(isset($_SESSION[uId]))
{
$f55 = mysql_query("SELECT * FROM `member_online` WHERE uId = " . $_SESSION[uId]) or trigger_error(mysql_error());
if(mysql_num_rows($f55) == 0)
{
mysql_query("INSERT INTO member_online (uLast, uPage, uId) VALUES (NOW(), ".$_SERVER[REQUEST_URI].",". $_SESSION[uId] .")") or die(mysql_error());
}else{
mysql_query("UPDATE member_online SET uLast = NOW(), uPage = ".$_SERVER[REQUEST_URI]." WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
mysql_query("UPDATE member_accounts SET uLast = NOW() WHERE uId = " . $_SESSION[uId]) or die(mysql_error());
}
}
0
Shahiem

Lid

Berichten
20.364
Reputatie
0
Punten
0,00
Lid sinds
Laatst gezien
Hoe kan ik gasten weergeven?
0
One2xs

Bot · Topicstarter

Berichten
93.699
Reputatie
0
Punten
1,27
Lid sinds
Laatst gezien
@shahiem
dat vraag ik me ook af
ik denk een gasten table maken
0

Jouw reactie

Deel je idee, stel een vraag of help een ander verder.

Editor laden…

Praat mee met de One2xs-community.

Inloggen om te reageren