|
You last visited: Today at 01:09
Advertisement
[REQUEST] GM ONLINE SCRIPT
Discussion on [REQUEST] GM ONLINE SCRIPT within the Flyff Private Server forum part of the Flyff category.
02/08/2014, 17:37
|
#1
|
elite*gold: 0
Join Date: Dec 2013
Posts: 245
Received Thanks: 28
|
[REQUEST] GM ONLINE SCRIPT
CAN ANYONE GIVE ME WEBSITE SCRIPT FOR GM ONLINE/OFFLINE STATUS AND THE SQL? THANKS
|
|
|
02/08/2014, 17:46
|
#2
|
elite*gold: 18
Join Date: Sep 2009
Posts: 20,177
Received Thanks: 14,471
|
Have you at least tried it make it yourself?
If yes -> We'll help you to fix your code
If no -> No support from my side
|
|
|
02/08/2014, 17:54
|
#3
|
elite*gold: 28
Join Date: Feb 2010
Posts: 463
Received Thanks: 277
|
Code:
<?php
$_CONFIG['Droits_Serveur'] = array('Administrateur' => 'U', 'Maître du jeu' => 'P', 'Guide' => 'M', 'MJ' => 'Q', 'Modérateur' => 'N'); // Configuration des lettres GM
foreach($_CONFIG['Droits_Serveur'] as $description => $authentification) {
echo '<table width="60%" align="center" cellspacing="0" cellpadding="2">';
$Equipe_1 = odbc_exec($mssql, 'SELECT A.[account], A.[m_chLoginAuthority], C.[m_szName], C.[MultiServer], C.[TotalPlayTime] FROM [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] AS A (READUNCOMMITTED) LEFT JOIN [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] AS C ON C.[account] = A.[account] WHERE A.[m_chLoginAuthority] = \''.$auth.'\' AND C.[isblock] != \'D\'');
while($Equipe_2 = odbc_fetch_array($Equipe_1)) {
if($Equipe_2['MultiServer'] != 0) {$Equipe_2['MultiServer'] = '<font class="lightblue"><b>En Ligne</b></font>';} else {$Equipe_2['MultiServer'] = '<font class="red">Hors Ligne</font>';}
echo ' <tr>
<td width="30%" align="center"><b>'.$Equipe_2['m_szName'].'</b></td>
<td width="30%" align="center">'.$Equipe_2['MultiServer'].'</td>
</tr>';
}
echo '</table></table></table></table>';
}
?>
|
|
|
02/08/2014, 17:54
|
#4
|
elite*gold: 0
Join Date: Jan 2012
Posts: 1,201
Received Thanks: 214
|
#Edit, sry men, i read only Gm online :x my default
|
|
|
02/08/2014, 17:57
|
#5
|
elite*gold: 0
Join Date: Dec 2013
Posts: 245
Received Thanks: 28
|
WEBSITE SCRIPT SIR.
|
|
|
02/08/2014, 18:33
|
#6
|
elite*gold: 28
Join Date: Feb 2010
Posts: 463
Received Thanks: 277
|
Look above my script is suitable for websites ..
|
|
|
02/08/2014, 18:53
|
#7
|
elite*gold: 0
Join Date: Dec 2013
Posts: 245
Received Thanks: 28
|
it gives me error
Quote:
Originally Posted by naruto66620
Look above my script is suitable for websites ..
|
ill send you my script sir can you please help me?
|
|
|
02/08/2014, 23:04
|
#8
|
ベトナム警察
elite*gold: 725
Join Date: Jan 2012
Posts: 16,378
Received Thanks: 3,429
|
Quote:
Originally Posted by Xxl3lubbs
Stimmt, mit </table></table></table></table> wird ganz ganz sicher der eine geöffnete table geschlossen. Viel hilft doch schließlich viel. Wenn die Franzosen auch nur einmal etwas richtig machen könnten...
Aber lieber schlecht geholfen als gar nicht geholfen. Es ist ja bloß das HTML, das unterirdisch gruselig ist - selbst, wenn man in Betracht zieht, was hier sonst noch herumfliegt.
|
Immerhin versucht er bzw. hat versucht zu helfen im Gegensatz irgendwelche Predigt zu halten. (Ops Fanboys unterwegs)
Da ziehe ich doch lieber die Variante in Erwägung, dass lieber schlecht geholfen besser wäre als gar nicht geholfen. oke
Ich meine, man kann auch simple auf Fehler hinweisen, aber so geht mal gar nicht.
Quote:
Originally Posted by Cloud'
it gives me error
ill send you my script sir can you please help me?
|
Send me your script. I will look over it.
|
|
|
02/08/2014, 23:19
|
#9
|
elite*gold: 0
Join Date: Oct 2012
Posts: 1,102
Received Thanks: 564
|
HTML Code:
<tr>
<td width="100%"><br />
<table width="90%" align="center" cellspacing="0" cellpadding="2">
<tr>
<td width="18%" align="left" valign="top"><h3>Name</h3></td>
<td width="22%" align="left" valign="top"><h3>Rankname</h3></td>
<td width="20%" align="center" valign="top"><h3>Onlinestatus</h3></td>
<td width="20%" align="center" valign="top"><h3>Onlinetime</h3></td>
</tr>
</table>
<?php
$_CONFIG['allg_svr_rights'] = array('Administrator' => 'P', 'Developer' => 'Z','Gamemaster' => 'N');
?>
<?php
foreach($_CONFIG['allg_svr_rights'] as $desc => $auth) {
if($auth != 'N') {$style = ' style="border-bottom:1px dotted #c0c0c0;"';} else {$style = '';}
echo ' <table width="90%" align="center" cellspacing="0" cellpadding="2"'.$style.'>';
$team_q = @odbc_exec($connection, 'SELECT A.[account], A.[m_chLoginAuthority], C.[m_szName], C.[MultiServer], C.[TotalPlayTime] FROM [ACCOUNT_DBF].[dbo].[ACCOUNT_TBL_DETAIL] AS A LEFT JOIN [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] AS C ON C.[account] = A.[account] WHERE A.[m_chLoginAuthority] = \''.$auth.'\' AND C.[isblock] != \'D\'');
while($team_a = @odbc_fetch_array($team_q)) {
if($team_a['MultiServer'] != 0) {$team_a['MultiServer'] = '<font class="lightblue"><b>Online</b></font>';} else {$team_a['MultiServer'] = '<font class="red">Offline</font>';}
echo ' <tr>
<td width="18%" align="left"><b>'.$team_a['m_szName'].'</b></td>
<td width="22%" align="left">'.$desc.'</td>
<td width="20%" align="center">'.$team_a['MultiServer'].'</td>
<td width="20%" align="center">'.sectohrs($team_a['TotalPlayTime']).'</td>
</tr>';
}
echo '</table>';
}
?>
</td>
</tr>
Edit the $connection in your DB connect
@Lumi: Ein Französisches Script bringt ihm aber auch nix xD
Besonders nicht bei so nem code xDDD
Sein Fehler ist, er bekommt keine DB verbindung ^^
|
|
|
02/09/2014, 11:30
|
#10
|
elite*gold: 0
Join Date: Oct 2012
Posts: 1,102
Received Thanks: 564
|
Timmy, beruhige dich, bevor Reavern die Gelbe Karte aus der epvp Box holt ^^
Ich habe ihm das Script von Sapphire geschickt und ihm erklärt was er ändern muss, damit es funktioniert, entweder er kann es oder hat pech.
|
|
|
02/09/2014, 12:56
|
#11
|
elite*gold: 0
Join Date: Dec 2013
Posts: 245
Received Thanks: 28
|
Quote:
<?php include('inc/config.inc.php'); ?>
<h1 id="Heading"> <center> FLYFF TEAM</h1>
<table style="width: 100%;">
<tr>
<td>Name</td>
<td>Gruppe</td>
<td>Status</td>
</tr>
<?php
odbc_exec($mssql, 'USE [CHARACTER_01_DBF]');
$query1 = odbc_exec($mssql, 'SELECT * FROM [CHARACTER_TBL] WHERE m_chAuthority != \'F\'');
while($result = odbc_fetch_array($query1)) {
if($result['MultiServer'] != '0'){
$result['status'] = '<font color="#00FF00">Online</font>';
}else{
$result['status'] = '<font color="#FF0000">Offline</font>';
}
if($result['m_chAuthority'] == 'Z')
{
$result['auth'] = 'Developer';
}
else if($result['m_chAuthority'] == 'P')
{
$result['auth'] = 'Owner';
}
else if($result['m_chAuthority'] == 'O')
{
$result['auth'] = 'Administrator';
}
else if($result['m_chAuthority'] == 'M')
{
$result['auth'] = 'Gamemaster';
}
else if($result['m_chAuthority'] == 'L')
{
$result['auth'] = 'Gamemaster';
}
echo '<tr>';
echo '<td>'.$result['m_szName'].'</td>';
echo '<td>'.$result['auth'].'</td>';
echo '<td>'.$result['status'].'</td>';
echo '</tr>';
}
?>
</table>
|
PLS. HELP ME, SHOWS OFFLINE EVEN THE STAFF IS ONLINE.
|
|
|
02/09/2014, 13:17
|
#12
|
elite*gold: 400
Join Date: May 2012
Posts: 156
Received Thanks: 37
|
Code:
if($result['MultiServer'] != '0'){
$result['status'] = '<font color="#00FF00">Online</font>';
}else{
$result['status'] = '<font color="#FF0000">Offline</font>';
}
Look at this if function..
|
|
|
02/09/2014, 16:08
|
#13
|
elite*gold: 0
Join Date: Jan 2014
Posts: 50
Received Thanks: 15
|
Sometimes you have to enable MultiServer first - Just run the uspInitMultiServer Procedure with Serverindex 01 and dwSys 0.
|
|
|
|
Similar Threads
|
[Help]PHP who's online script
05/07/2012 - Shaiya PServer Development - 3 Replies
Hi i was trying to make this script into a working who's onlinebut i keep getting Parse error: syntax error, unexpected T_STRING on line 12
was wondering if anyone could spot it i may be just having a blonde moment but you never know
<?php
$server = '127.0.0.1';
$dbuser = 'shaiya';
$dbpass = 'shaiya123';
$count=1;
$count2=1;
|
Online Script
11/02/2010 - Metin2 Private Server - 4 Replies
Whats the script for online players?
|
[REQUEST] Simple Online PhP Script
03/27/2010 - Shaiya - 0 Replies
Hi,
My php skills are horrible and I ask for someone to give me a simple php online script for shaiya.. The code for the one released is wrong in some spots because the php is not connecting to sql.
Here is what I look for.
Simple Script that displays the total number of Users;
If can do that for me I will really appreciate alot.
If can be more fancy and have time to add more things I will be more appreciate it. Thank you guys.
|
[REQUEST] online players script
10/30/2008 - EO PServer Hosting - 18 Replies
hi all ,
i think that the titel says enouf of what i want to aks , but to be shure i goin write a little more ^^
i aim looking for a script whit a few things
server offline
server online
players online
|
[REQUEST] Can i Request A Acc/Char PHP Script
09/27/2008 - CO2 Private Server - 6 Replies
hello i was wondering if anyone have made a acc/char creation page in one yet? is so can anyone release itplease?
|
All times are GMT +2. The time now is 01:09.
|
|