|
You last visited: Today at 01:52
Advertisement
Website USER ONLINE
Discussion on Website USER ONLINE within the Flyff Private Server forum part of the Flyff category.
11/16/2013, 13:09
|
#1
|
elite*gold: 0 
Join Date: Jul 2013
Posts: 56
Received Thanks: 2
|
Website USER ONLINE
How to fix User Online @ website?
|
|
|
|
11/17/2013, 16:15
|
#2
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Can you post us your Quellcode which are not working?
|
|
|
|
|
11/17/2013, 19:44
|
#3
|
|
TBM Head Mod
elite*gold: 0
Join Date: Oct 2012
Posts: 23,927
Received Thanks: 2,045
|
So the first error variation would be:
- You have not the world-server started and so the script cant read a value. (Which I do not think...)
and the second variation:
- You mean that this function outputs a wrong value.
But these are only two variations... The best way is you show us the error or tell us what disturb you at the script.
Regards,
Icetea'
|
|
|
|
|
11/18/2013, 04:49
|
#4
|
elite*gold: 0
Join Date: Jul 2013
Posts: 56
Received Thanks: 2
|
Quote:
<?php
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
odbc_exec($mssql, 'USE [LOGGING_01_DBF]');
$peak = odbc_exec($mssql, 'SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC');
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
$accounts = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL]');
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$character = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL]');
$guilds = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [GUILD_TBL]');
odbc_exec($mssql, 'USE [LOGGING_01_DBF]');
$peak = odbc_exec($mssql, 'SELECT TOP 1 number FROM [LOG_USER_CNT_TBL] ORDER BY [number] DESC');
?>
<h1>Server Information</h1>
<div class="panel">
<table>
<tr>
<td>Server Time:</td>
<td id="srvtime"></td>
</tr>
<tr>
<td>Server Date:</td>
<td><?php echo date('d.m.Y'); ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Server Status:</td>
<td><div id="srvworld"><img src="./img/load.gif" alt="" /></div></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<br><tr><td>Accounts:</td><td><?php echo odbc_result($accounts, 'count'); ?></td></tr>
<tr><td>Character:</td><td><?php echo odbc_result($character, 'count'); ?></td></tr>
<tr><td>Guild:</td><td><?php echo odbc_result($guilds, 'count'); ?></td></tr>
<tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<td>Server Peak:</td>
<td><?php echo odbc_result($peak, 'number'); ?></td>
</tr>
<tr>
<td>Online User:</td>
<td><?php echo odbc_result($online, 'count'); ?></td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>EXP Rate:</td>
<td>3000x</td>
</tr>
<tr>
<td>Drop Rate:</td>
<td>3000x</td>
</tr>
<tr>
<td>Penya Rate:</td>
<td>3000x</td>
</tr>
<tr>
<td colspan="2"><br /></td>
</tr>
<tr>
<td>Teamspeak IP:</td>
<td>12.34.567.89</td>
</tr>
<tr>
<td>Teamspeak Port:</td>
<td>1234</td>
</tr>
</table>
</div>
|
that 1 :/
|
|
|
|
|
11/18/2013, 07:49
|
#5
|
|
TBM Head Mod
elite*gold: 0
Join Date: Oct 2012
Posts: 23,927
Received Thanks: 2,045
|
Quote:
Originally Posted by h4rvswagg
that 1 :/
|
Thats only the HTML and PHP script. You have to tell us what you do not like at the script or where the fault lies. So we do not get on... 
Leave us the following information: - What bothers you the script?
- Is it a real error?
- Which homepage do you use?
Regards,
Icetea'
|
|
|
|
|
11/18/2013, 08:32
|
#6
|
elite*gold: 0
Join Date: Oct 2012
Posts: 948
Received Thanks: 157
|
@iceTea
He already have told that the online user count is not good
Change this line
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
To this
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
#online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE multiServer > 0);
|
|
|
|
|
11/18/2013, 16:34
|
#7
|
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Quote:
Originally Posted by raventh1984
@iceTea
He already have told that the online user count is not good
Change this line
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
To this
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
#online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE multiServer > 0);
|
He didn't told us that the online user count is not good. He told us how to fix them.
Well, the script which raventh already posted should works.
|
|
|
|
|
11/20/2013, 05:13
|
#8
|
elite*gold: 0
Join Date: Jul 2013
Posts: 56
Received Thanks: 2
|
Quote:
Originally Posted by raventh1984
@iceTea
He already have told that the online user count is not good
Change this line
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
To this
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
#online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE multiServer > 0);
|
It gives me more error sir
|
|
|
|
|
11/20/2013, 08:34
|
#9
|
elite*gold: 0
Join Date: Oct 2012
Posts: 948
Received Thanks: 157
|
What error do you have.
I think because you just copied and paste. If thats the case have you changed # to an $
|
|
|
|
|
11/21/2013, 14:34
|
#10
|
elite*gold: 0
Join Date: Jul 2013
Posts: 56
Received Thanks: 2
|
Quote:
Originally Posted by raventh1984
What error do you have.
I think because you just copied and paste. If thats the case have you changed # to an $
|
i change but still .. do you have any website template that has user online sir?
|
|
|
|
|
11/21/2013, 17:55
|
#11
|
elite*gold: 0
Join Date: Dec 2010
Posts: 164
Received Thanks: 54
|
Quote:
Originally Posted by raventh1984
@iceTea
He already have told that the online user count is not good
Change this line
odbc_exec($mssql, 'USE [ACCOUNT_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [ACCOUNT_TBL] WHERE isuse = \'J\'');
To this
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$online = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM [CHARACTER_TBL] WHERE multiServer > 0');
|
Did u miss the ' ?
|
|
|
|
|
11/21/2013, 20:05
|
#12
|
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,377
Received Thanks: 3,429
|
Maybe you tell us your error?
|
|
|
|
|
11/22/2013, 18:16
|
#13
|
|
TBM Head Mod
elite*gold: 0
Join Date: Oct 2012
Posts: 23,927
Received Thanks: 2,045
|
So, this function should be work. Credits goes of course to raventh. I have only tested this variable and corrected typographical errors.
Code:
odbc_exec($mssql, 'USE[CHARACTER_01_DBF]');
$online_function = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM[CHARACTER_TBL] WHERE multiServer > 0');
But in this code we see the variable $mssql. That means the SQL-Server Connection, it wont work when this function isn't declared. So, when in you use a Stefan Pfeifer Page it should be declared in the config.php.
So when you use a Stefan Pfeifer Homepage, is that the right script to output your number X of User Online Count:
Code:
<?php echo odbc_result($online_function, 'count'); ?>
If you still have questions, let me know. (via PN)
I think the problem is now solved.
I think the problem is solved now.
Therefore I send a #closerquest
Kind Regards,
Icetea'
|
|
|
|
|
11/24/2013, 00:24
|
#14
|
elite*gold: 0
Join Date: Jul 2013
Posts: 56
Received Thanks: 2
|
Quote:
Originally Posted by Icetea'
So, this function should be work. Credits goes of course to raventh. I have only tested this variable and corrected typographical errors.
Code:
odbc_exec($mssql, 'USE[CHARACTER_01_DBF]');
$online_function = odbc_exec($mssql, 'SELECT COUNT(*) as count FROM[CHARACTER_TBL] WHERE multiServer > 0');
But in this code we see the variable $mssql. That means the SQL-Server Connection, it wont work when this function isn't declared. So, when in you use a Stefan Pfeifer Page it should be declared in the config.php.
So when you use a Stefan Pfeifer Homepage, is that the right script to output your number X of User Online Count:
Code:
<?php echo odbc_result($online_function, 'count'); ?>
If you still have questions, let me know. (via PN)
I think the problem is now solved.
I think the problem is solved now.
Therefore I send a #closerquest
Kind Regards,
Icetea' |
Thanks sir and now it works 
Quote:
Originally Posted by Lumi
Maybe you tell us your error?
|
Done thanks hehe 
|
|
|
|
 |
Similar Threads
|
[Coming Soon ] Website DEMO Version BRG-1.2 [ Website Silkroad Online ]
06/14/2013 - Silkroad Online Trading - 6 Replies
Hello Guys Coming Soon ( Release DEMO ) New Website Design ( Unique )
http://imageshack.us/a/img844/5517/73762549.png
I'm looking for a nice background image. :)
Version Demo:( Buy Full Version Click HERE )
Info:
|
[S] User für Website [B] 5e*G
01/05/2013 - elite*gold Trading - 19 Replies
Ich suche Leute die sich auf einer Website anmelden. Das Einzige was ihr machen müsst, ist euch per meinen Link anzumelden und die erhaltene Email zu bestätigen.
Beachtet bitte das nur eine Anmeldung möglich ist und ihr das 18. Lebensjahr erreicht haben müsst, um bei der Aktion teilzunehmen.
Nach der Anmeldung dauert es ca. 10 Minuten, wegen der Bestätigung.
FÜr eine vollständige und legitime Anmeldung gibt es 5 e*G von mir.
Einfach posten und ich werde euch den Link zur Anmeldung...
|
How to add User Panel to Flyff Website
06/16/2010 - Flyff Private Server - 1 Replies
Hello i got a flyff webiste running with wamp and i was wondering on how to add the User Panel to the Website can someone post on how please i really need this Panel.
|
All times are GMT +2. The time now is 01:52.
|
|
