open All Channels
seplocked EVE Technology Lab
blankseplocked [EVEOTS] Eve Online Teamspeak 3 API Registration with PHP5 v1.5
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: 1 2 3 4 5 [6]

Author Topic

MillerUk
Caldari
Knights Of Divinity
Unforgiving.
Posted - 2011.08.30 08:53:00 - [151]
 

Edited by: MillerUk on 30/08/2011 09:02:54
Originally by: Mediek Ordos

Nice, and usefull, are you going to share your adjustments ?
Ill drop you admin link later MJ, we alterd the templates again :-) worked sweet as a nut again nice one m8ty :-)


Ill Show You how to add the members listing firstly... bear in mind this is not the final way i want it to look as it does not show pagination so if you have loads registered it will show one big list.

Look For the following line.

break;
case "add_admin";


then add above


case "auditmembers":
// Authorised to access this area?
// Connect to server and select database.
SQLconnect(open);
$query = mysql_query("SELECT securityLevel FROM admins WHERE username = \"".$_SESSION['character']."\";");
while ($row = mysql_fetch_array($query)) {
$securityLevel = "$row[securityLevel]";
}
SQLconnect(close);
// Audit Members List

?>

<?php
// Connect to server and select database.
SQLconnect(open);
// Set query
$query = mysql_query("SELECT * FROM users ORDER BY tsName;");
// Build admin table
echo "<table width=\"100%\" border=\"0\">";
echo "<tr><td width=\"32px\"></td><td>Teamspeak Name</td><td align=\"center\">Corp</td><td width=\"100px\">Databse Id</td><td width=\"40px\"></td></tr>";
// Populate admin table
while ($row = mysql_fetch_array($query)) {
$id = "$row[entryID]";
$tsID = "$row[tsUniqueID]";
$characterID = "$row[characterID]";
$username = "$row[tsName]";
$databseid = "$row[tsDatabaseID]";
// Get the characters current corporation
if ($characterID !== "") {
try {
$fetch = $pheal->eveScope->CharacterInfo(array('characterID' => $characterID));
$fetchCorporation = $fetch->corporation;
$fetchAlliance = $fetch->alliance;
} catch (PhealException $e) {
die("An error occured: ".$e->getMessage()." [A".__LINE__."]");
}
}
if ($id == $c->adminID) {
echo "<tr class=\"listRootAdmin\">";
} else {
echo "<tr>";
}
echo "<td width=\"32px\">";
if ($characterID !== "") {
echo "<img src=\"http://image.eveonline.com/Character/".$characterID."_32.jpg\" border=\"0\">";
} else {
echo "<img src=\"images/admin.png\" border=\"0\">";
}
echo "</td><td>".$username."<br><font size=1>".$tsID."</font></td><td align=\"center\">".$fetchCorporation."<br /><font size=\"2\">".$fetchAlliance."</font></td><td align=\"center\">".$databaseid."</td>";
if ($id == $c->adminID && $id == $_SESSION["EVEOTSid"]) {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a></td></tr>";
} else if ($id == $c->adminID) {
echo "<td></td></tr>";
} else {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a> <a href=\"?menu=delete_member&id=".$id."\" onclick=\"return confirm('Are you sure you want to delete ".$username."?')\"><img src=\"images/delete.png\" border=\"0\" title=\"Delete\"></a></td></tr>";
}
}
echo "</table>";
SQLconnect(close);

break;




Then you need to add the new page to the navagation links which should look something similar to below:


<a href="admin_panel.php?menu=main">Main</a><br />
<a href="admin_panel.php?menu=logs">Logs</a><br />
<a href="admin_panel.php?menu=audit">Audit</a><br />
<a href="admin_panel.php?menu=auditmembers">Audit Members</a><br /><br />
<a href="admin_panel.php?menu=whitelist">Edit Whitelist</a><br />

which in the end should loook somthing similar to
http://img20.imageshack.us/img20/926/teamspeaklist.png

Balani
Posted - 2011.08.30 10:55:00 - [152]
 

Edited by: Balani on 30/08/2011 11:08:15
I missing an option to disable Alliance /Corp ticker in the Usernick the reason is i use TS groups that add tag automaticly after registration.


The second thing i find nice was if i can add more then 1 corp that checked

add corp 1 in grp x
add corp 2 in grp xx and so on

all other corps in grp xx


if possible same with alliance



I see that the funktion to edit the user is missing in the last post

C'Thul
Posted - 2011.08.30 16:51:00 - [153]
 

what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything Question

MillerUk
Caldari
Knights Of Divinity
Unforgiving.
Posted - 2011.08.30 17:25:00 - [154]
 

Originally by: C'Thul
what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything Question


If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question

C'Thul
Posted - 2011.08.30 18:19:00 - [155]
 

Originally by: MillerUk
Originally by: C'Thul
what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything Question


If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question


in fact, as a professional software-developer and gamer who uses TS3 a lot i know a bit about TS3, i already wrote SQuery-software, kiddo ... now : shut and and let the adults talk, mkay? Troll elsewhere please.

Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
Posted - 2011.08.30 18:39:00 - [156]
 

Originally by: C'Thul
Originally by: MillerUk
Originally by: C'Thul
what does this system even do? TS3 has no user-registration anymore, instead unique IDs are used ... so judging from your description this system doesnt do anything Question


If you knew anything about the Teamspeak user groups and IDs you would t bother asking that question


in fact, as a professional software-developer and gamer who uses TS3 a lot i know a bit about TS3, i already wrote SQuery-software, kiddo ... now : shut and and let the adults talk, mkay? Troll elsewhere please.

It is nice that proffesional software developers get involved with these projects, C'Thul take a look at the scripting MJ has written in its entirety then you will see what it is actually doing by assigning server groups with id keys Wink

MJ Maverick
IronPig
Sev3rance
Posted - 2011.08.30 18:40:00 - [157]
 

Edited by: MJ Maverick on 30/08/2011 18:45:25

Alright C'Thul calm down dude, no one asked for your CV. I don't really want any rioting in my thread.

What it does is:
Registrations are based on your UniqueID right?
Permissions are tied to that right?
Well, presuming you have your TS setup so only certain groups can access/view your channels with the exception of the default channel. EVEOTS will automatically assign people those permissions if they meet the white list criteria.


I do have plans to make it more friendly for those with large numbers of groups like Balani and many others have asked. But it's a fair chunk of work so I'm leaving it until after the new API system comes out... If I can ever work that mystery out. I'm also going to be adding a member edit list in there, but more really wanted to get it out before the new API system came along to strap C4 to all my work.

@MillerUK, your chunk of code doesn't check if they are authorised that I can see :/ it only seems to prepare to check, log into a SL2 account and check that out. Also remember to mention you changed ".$_SESSION['character']" or people using it could break their panel.

Mediek Ordos
Caldari
Association of Commonwealth Enterprises
Imperial 0rder
Posted - 2011.08.30 20:15:00 - [158]
 

nice one MillierUK
i couldnt get the database id working so i changed it a bit
from line 377 to line 439 admin_panel.php
break;
case "auditmembers":
// Authorised to access this area?
// Connect to server and select database.
SQLconnect(open);
$query = mysql_query("SELECT securityLevel FROM admins WHERE username = \"".$_SESSION['character']."\";");
while ($row = mysql_fetch_array($query)) {
$securityLevel = "$row[securityLevel]";
}
SQLconnect(close);
// Audit Members List

?>

<?php
// Connect to server and select database.
SQLconnect(open);
// Set query
$query = mysql_query("SELECT * FROM users ORDER BY tsName;");
// Build admin table
echo "<table width=\"100%\" border=\"0\">";
echo "<tr><td width=\"32px\"></td><td>Teamspeak Name</td><td align=\"center\">Corp</td><td width=\"100px\">Database Id</td><td width=\"40px\"></td></tr>";
// Populate admin table
while ($row = mysql_fetch_array($query)) {
$id = "$row[entryID]";
$tsID = "$row[tsUniqueID]";
$characterID = "$row[characterID]";
$username = "$row[tsName]";
$tsDatabaseID = "$row[tsDatabaseID]";
// Get the characters current corporation
if ($characterID !== "") {
try {
$fetch = $pheal->eveScope->CharacterInfo(array('characterID' => $characterID));
$fetchCorporation = $fetch->corporation;
$fetchAlliance = $fetch->alliance;
} catch (PhealException $e) {
die("An error occured: ".$e->getMessage()." [A".__LINE__."]");
}
}
if ($id == $c->adminID) {
echo "<tr class=\"listRootAdmin\">";
} else {
echo "<tr>";
}
echo "<td width=\"32px\">";
if ($characterID !== "") {
echo "<img src=\"http://image.eveonline.com/Character/".$characterID."_32.jpg\" border=\"0\">";
} else {
echo "<img src=\"images/admin.png\" border=\"0\">";
}
echo "</td><td>".$username."<br><font size=1>".$tsID."</font></td><td align=\"center\">".$fetchCorporation."<br /><font size=\"2\">".$fetchAlliance."</font></td><td align=\"center\">".$tsDatabaseID."</td>";
if ($id == $c->adminID && $id == $_SESSION["EVEOTSid"]) {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a></td></tr>";
} else if ($id == $c->adminID) {
echo "<td></td></tr>";
} else {
echo "<td><a href=\"?menu=member_edit&id=".$id."\"><img src=\"images/edit.png\" border=\"0\" title=\"Edit\"></a> <a href=\"?menu=delete_member&id=".$id."\" onclick=\"return confirm('Are you sure you want to delete ".$username."?')\"><img src=\"images/delete.png\" border=\"0\" title=\"Delete\"></a></td></tr>";
}
}
echo "</table>";
SQLconnect(close);
break;
case "add_admin";
now it works, edit and delete function need some attention nice one m8ty

king curt
Caldari
The Maverick Navy
Against ALL Authorities
Posted - 2011.09.01 23:46:00 - [159]
 

Edited by: king curt on 02/09/2011 17:40:45
MJ,

Got a question for you. I got everything working well, but I think there is a problem with the cron job for the admin portion and am getting the following error on the cron output:

<br /> <b>Warning</b>: require_once(functions.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br /> <br /> <b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'functions.php' (include_path='.:/usr/lib64/php:/usr/lib/php') in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br />

This is from your cron php:

require_once("../pheal/Pheal.php"); require_once("../config.php"); require_once("../functions.php"); require_once("functions.php");

Is the last require_once('functions.php") correct? Should it be there?


Cpt Sc4rlet
Posted - 2011.09.04 12:52:00 - [160]
 

Edited by: Cpt Sc4rlet on 04/09/2011 18:00:19
This may be a stupid question but how is the Cron managed?

What happens when a member leaves the corp, how do I ensure there permissions are removed?

MJ Maverick
IronPig
Sev3rance
Posted - 2011.09.04 22:21:00 - [161]
 

Originally by: king curt
Edited by: king curt on 02/09/2011 17:40:45
MJ,

Got a question for you. I got everything working well, but I think there is a problem with the cron job for the admin portion and am getting the following error on the cron output:

<br /> <b>Warning</b>: require_once(functions.php) [<a href='function.require-once'>function.require-once</a>]: failed to open stream: No such file or directory in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br /> <br /> <b>Fatal error</b>: require_once() [<a href='function.require'>function.require</a>]: Failed opening required 'functions.php' (include_path='.:/usr/lib64/php:/usr/lib/php') in <b>/home5/xxxxxxx/public_html/eveots/admin/cron.php</b> on line <b>9</b><br />

This is from your cron php:

require_once("../pheal/Pheal.php"); require_once("../config.php"); require_once("../functions.php"); require_once("functions.php");

Is the last require_once('functions.php") correct? Should it be there?




Ahhh, sorry about that, last minute change. Fixed now. Redownload and just replace that file.

@Cpt Sc4rlet Run eveots/cron.php, done.

sniperhawk1
Posted - 2011.09.07 02:55:00 - [162]
 

Error message:

Attempting to grant access to: NUKKA sniperhawk1...

An error occured: Connection refused [F10]

I have my login info entered in the config.php file, and can log in to the TS server using PuTTY & the same info. Advice?


Pages: 1 2 3 4 5 [6]

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only