Online table from database

[CULOBG]

So guys i am messing around with the database and been looking for the file that works with the online table ( the one that says who is online)
if anyone knows which file updates that table every time would be really handy
tnx for any reply :)

[MentaL]

[nofxpunkerbrian]

Its the binary files that updates the point database

Just do this query:

SELECT * FROM point WHERE zoneid > -1;

This will show all accounts online, for actual characters that you want to view this will have to done by a jsp servlet call distributing the results from using the above query and which character of the account that appears is online at the time. This can be dangerous if you have a big db and also a big community online.

[CULOBG]

thanks i will look into that i think i saw that into the role.jsp :)

[tbnanubis]

SELECT * FROM point WHERE zoneid > -1;

This will show all accounts online, for actual characters that you want to view this will have to done by a jsp servlet call distributing the results from using the above query and which character of the account that appears is online at the time. This can be dangerous if you have a big db and also a big community online.

I tried this once, noticing that the online status is the same for every char on the same acc, so there is no way that i know of to be sure which character is online.

[das7002]

Its the binary files that updates the point database

Just do this query:

SELECT * FROM point WHERE zoneid > -1;

This will show all accounts online, for actual characters that you want to view this will have to done by a jsp servlet call distributing the results from using the above query and which character of the account that appears is online at the time. This can be dangerous if you have a big db and also a big community online.

You don't need JSP to get the actual character names. I've done it in pure PHP by replicating what the JSP sends to gamedbd

csharp.php - pw-chat - Perfect World Chat - Google Project Hosting

[nofxpunkerbrian]

You don't need JSP to get the actual character names. I've done it in pure PHP by replicating what the JSP sends to gamedbd

csharp.php - pw-chat - Perfect World Chat - Google Project Hosting

JSP is its original way, yeah you found a work around which is good but again the original process is via Java so I stuck with that technique instead of yours.

[softsoldier]

couldnt you compare the id with the roles table? or what ever pwadmin imports to.

like this

$result2 = mysql_query("SELECT * FROM roles WHERE roleid = '$ID'");
			while($row = mysql_fetch_array($result2)){
			echo "<br>";
			echo "<font color=red>&nbsp&nbsp&nbsp" . $row['rolename'] . "</font>";
			echo "<font color=red>&nbsp&nbsp&nbsp" . $row['rolelevel'] . "</font>";
			$Class = $row['roleprof']=$row['roleprof'];
switch ($Class){
	case "0":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Blademaster . "</font>";
		break;
	case "1":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Wizard . "</font>";
		break;
	case "3":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Venomancer . "</font>";
		break;	
	case "4":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Barbarian . "</font>";
		break;	
	case "6":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Archer . "</font>";
		break; 	
	case "7":
		echo "<font color=red>&nbsp&nbsp&nbsp" . $row['roleprof']=Cleric . "</font>";
		break;
}

i made this to change the returned number from the roleprof column into the actual class.