Printable View
Hello, I did a GM's Status script... yeah, I know that there's a lot of it here, but this one is easier to use, it's very effective, have clean codes, and doesn't have bugs.
I got nothing to do some time a go, then I created it xD
The instructions are in the script.
This is the script:
Spoiler:
And this is the database configuration file:
Spoiler:
Don't forget to change the database's access information in config.php
Enjoy xD
no tutorial how to use?
:?: :?:
reading the code, i guess you just put it on some page and you can see there which gm is online at the moment.
No need for a tutorial on such simple script.
the source kinda explain it all, thats nicely put together i like it, great work.
Just read the codes, there are comments that explain how to use :):Quote:
Originally Posted by rudisans
Also, there was a small error in the script... I forgot that I wrote the database connection in the config.php file... so it would try to connect twice, but it's fixed now =)
:lol: verry nice renan good job:thumbup:
I rewrote your code so that it only uses one query and retrieves the GMs name as well as having robust query handling. Well, I don't know if I can call checking the query for validity, robust...but I digress.
PHP Code:<?php
define('DB_HOST', 'localhost'); // Database Location
define('DB_USERNAME', 'root'); // Database Username
define('DB_PASSWORD', ''); // Database Password
define('DB_NAME', ''); // Database Name
$mysql_connection = @mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD) or die('MySQL connection failed!');
$mysql_db = @mysql_select_db(DB_NAME, $mysql_connection) or die('MySQL failed to select database!');
$query; // null
$query_str;
$output_info = array();
$output = '';
$array_gms = array(
32 => 'Rank',
96 => 'Rank2',
144 => 'Rank3',
);
if ( count($array_gms) )
{
// Starting Query
$query_str = "SELECT point.uid, point.zoneid, roles.role_name FROM point INNER JOIN roles ON point.uid = roles.role_id WHERE ";
// Retrieve GM IDs
$gmIDs = array_keys($array_gms);
// Build Query
for($i = 0; $i < count($gmIDs); $i++)
{
$query_str .= "point.uid = '" . $gmIDs[$i] . "'";
if ( $i + 1 < count($gmIDs) )
{
$query_str .= ' OR ';
}
}
$query = @mysql_query($query_str);
// echo '<pre>' . $query_str . '</pre>'; // You can view the generated query with this
if ( $query )
{
if ( mysql_num_rows($query) )
{
while ( $current_row = mysql_fetch_array($query) )
{
$output_info[] = $current_row;
}
}
}
else
{
echo 'MySQL query failed!';
}
}
else
{
// No GMs to speak of...
echo "No GMs to speak of...<br />";
}
// Output Area
if ( count($output_info) )
{
// echo '<pre>' . print_r($output_info, 1) . '</pre>'; // You can view the data obtained from the database with this
$html_online = '<font color="#006600">Online</font>';
$html_offline = '<font color="red">Offline</font>';
foreach ( $output_info as $gm => $data )
{
$output .= '[' . $array_gms[$data['uid']] . ']' . htmlentities($data['role_name']) . ' ';
if ( $data['zoneid'] )
{
$output .= $html_online;
}
else
{
$output .= $html_offline;
}
$output .= '<br />';
}
echo $output;
}
?>
I really don't think it's necessary to do queries to check GMs nicknames since you, as an admin, will know their nicknames xD
But anyway... nice code, thanks. =)
...lol, hrace009 is becoming a password example :rofl:
with that query you get all online gms without even knowing any name or id of them, just by help of the auth table:
Code:$query_str = "SELECT point.uid, point.zoneid, roles.role_name FROM point INNER JOIN roles ON point.uid = roles.role_id WHERE point.zoneid<>'null' and point.uid in (SELECT DISTINCT auth.userid FROM auth )";
Yeah... but he still used my gms array D=Quote:
Originally Posted by tbnanubis
hrace009 is the password on my local test server. It was originally based on his release and is now extremely modified and half his, half 343's release...I meant to take that info out of the code, but who cares. I made better new code below.Quote:
Originally Posted by renan7899
Hmm? I see what this does, but I'm not sure what the auth table data is. Does it only contain the user IDs of the GMs? If so, alright, but what's rid for, if you know?Quote:
Originally Posted by tbnanubis
Also, this query isn't quite right, I fixed it in the below code. You only grabbed the user if they were online, which is going to skip those who are offline.
----------
This is heavily modified even from my earlier one and better documented.
------------PHP Code:<?php
define('DB_HOST', 'localhost'); // Database Location
define('DB_USERNAME', 'root'); // Database Username
define('DB_PASSWORD', 'mypws'); // Database Password
define('DB_NAME', 'pws'); // Database Name
define('GM_ONLINE', '<font color="#006600">Online</font>'); // GM online message
define('GM_OFFLINE', '<font color="red">Offline</font>'); // GM offline message
$mysql_connection = @mysql_connect(DB_HOST, DB_USERNAME, DB_PASSWORD) or die('MySQL connection failed!');
$mysql_db = @mysql_select_db(DB_NAME, $mysql_connection) or die('MySQL failed to select database!');
$query; // null
$query_str;
$output_info = array();
$output = '';
// Optional Ranks for GMs
$gm_ranks = array(
// 'GM Name' => 'Rank'
'MyCharacter' => 'Rank',
'Rank2 GM' => 'Rank2',
'SomeGuy' => 'Rank3',
);
// 'GM Name' => true | This will filter their name out
// 'GM Name' => false| This will NOT filter their name out
// Leaving it empty will also NOT filter out GMs names
$gm_filter = array( // Any GMs you don't want to show...
'GM Name' => true,
);
// Query
$query_str = "SELECT point.zoneid, roles.role_name FROM point INNER JOIN roles ON point.uid = roles.role_id WHERE point.uid IN (SELECT DISTINCT auth.userid FROM auth)";
// Execute Query
$query = @mysql_query($query_str);
// echo '<pre>' . $query_str . '</pre>'; // You can view the generated query with this
// If query is successful
if ( $query )
{
// if query is not empty, fetch all information
if ( mysql_num_rows($query) )
{
while ( $current_row = mysql_fetch_array($query) )
{
$output_info[] = $current_row;
}
}
}
else
{
echo 'MySQL query failed!';
}
// Output Area
if ( count($output_info) )
{
// echo '<pre>' . print_r($output_info, 1) . '</pre>'; // You can view the data obtained from the database with this
// Iterate through output query data
foreach ( $output_info as $gm => $data )
{
// If GM isn't filtered out
if ( !$gm_filter[$data['role_name']] )
{
// Apply title if user has title
if ( $gm_ranks[$data['role_name']] )
{
$output .= '[' . $gm_ranks[$data['role_name']] . ']';
}
// Output GM name
$output .= htmlentities($data['role_name']) . ' ';
// Output status
if ( $data['zoneid'] )
{
$output .= GM_ONLINE;
}
else
{
$output .= GM_OFFLINE;
}
// Output line break
$output .= '<br />';
}
}
// Print out generated output
echo $output;
}
?>
Renan, I'm going to be adding this (my code) to my php PerfectWorldAPI class. Thank you for getting it started though.
it was supposed to show only online gms ^^,
if you want to show all gms, just remove the point.zoneid check.
Of course all this does not work when the gm's char is not the first one one the acc. It will not show the gm when he/she deleted the first char and uses the 2nd. You have to use roles.account_id instead of roles.roleid to get around that.
this will select the first available character on every gm account and order them by zoneid and roleidCode:SELECT roles.role_name, point.zoneid FROM point INNER JOIN roles ON point.uid = roles.account_id where point.uid IN (SELECT DISTINCT auth.userid FROM auth) group by roles.account_id order by point.zoneid,roles.role_id asc
Yes the auth table controls gm powers. rid is the gm power that he/she has.
Example:
check gmopgen.xml for the full list.Code:<operation description="Force to be offline" name="Force_Offline" type="100"/>
<operation description="Forbid talking" name="Forbid_Talk" type="101"/>
<operation description="Forbid trades among players, and between player and NPC" name="Forbid_Trade" type="102"/>
<operation description="Forbid selling" name="Forbid_Sell" type="103"/>
<operation description="System broadcast" name="Broadcast" type="104"/>
Be aware that if you remove all but one right, the gm may not be even able to talk or attack.
If at least one flag is set, the player with that accountid will show up as gm ingame, and you have to add some additional flags so he/she is able to do the same things as a player, because the default is to deny everything you don't allow as soon as he/she is gm.