[foamy11]

1) yes
2)Not sure, ill check

I've read most about the sql

All I can say is WOW, Confuzing. Anychance that I give you Ftp://
access (giving pw ect.) do it for me? If not that walking me through it your self. Or giving me links to tutorials

Let me know whats best for you.

~foamy

[White Bishop]

Great plugin. Got the mysql database running and the plugin is working great. I am having trouble with the php files which dont display any results. For a different plugin I got php files to connect with my database so you would think I could get the php files for this plugin to work. However, I am unfamiliar with php and sql so debugging the files has proven fruitless. Any ideas?

Btw, I have php 5.3.0 and mysql essentials 5.1.37 and the database is running on the same host as the server.

[Lt Llama]

Hi and wow, someone is using the plugin . Doesnt it show any stats at all? Have you checked the readme for the php files, where it talks about the register globals fix? I'm no php guru either but try and find a way to get debug messages from the php pages. The pages works so it must be an access problem.

[White Bishop]

Well I figured out the problem by comparing the syntax of these php files to the php files for another plugin. I made the following changes:

1) Change each
<?
to
<?php

2) Save the return of the mysql_connect and pass it as the last argument to mysql_select_db, mysql_query, and mysql_close.

So for the index.php, the first part becomes:

<?php
include("dbinfo.inc.php");
$sql=mysql_connect($host,$username,$password);
@mysql_select_db($database, $sql) or die( "Unable to select database");

$query="SELECT `steamId`, `nickNames`, `nFinnished`, `rankTotal`, `primaryRank` FROM `skillrank` ORDER BY `nickNames` ASC";
$result=mysql_query($query, $sql);

$num=mysql_numrows($result); 

mysql_close($sql);

Also I moved the dbinfo.inc.php to a subdirectory (had to update the include statements in the php) so I can limit its access.
This is very important because it has your database root password!


Works like a champ now!

[White Bishop]

Also for the php with stats in the name add the following at the begining
after <?php

session_start();
$steamid = $_GET["steamid"];
$nickname = $_GET["nickname"];
$nfinished = $_GET["nfinished"];
$totalrank = $_GET["totalrank"];
$primaryrank = $_GET["primaryrank"];
$_SESSION['steamid'] = $steamid;

[White Bishop]

If you like to see the plugin in action, goto

http://ChurchOfConc.servehalflife.com


and click on
'Statisitcs'

[Lt Llama]

Very nice looking page Bishop and thx for these tweeks. I'll test them on my webby and see if it works. For me the previous pages worked but if this works for me to I will update the php pages here.

Nice to know who runs Church of Conc . You got a steam group page?

[White Bishop]

I haven't created a steam group. Do you find those worthwhile? If you'd like, you can idle on the irc channel #Church_of_Conc on <irc.gamesurge.net>. I am usually logged on there.

For the rankskills plugin, I've noticed the show_hudmessages do not appear for the proper duration and often just flash on the screen and then disappear. I tried changing the channel from 4 to the auto select (-1) which did not help and also changing to the command ShowSyncHudMsg, but there was no noticeable difference. Next I need to look through other plugins to see if maybe they are overwriting the hud channel, but I don't see any new hud messages. Any ideas?

[Lt Llama]

The Steam group have been great for us. Not everybody reads forums, idle in irc or are very active, but they do have Steam started. And I have used it for announcing events like map release partys and other events. And then people joins and the servers gets a little boost.

I think you must have some other plugin, like rtv that show up hud messages at the same time? At least thats what I thought when these things happen.

[White Bishop]

I made a Steam Group - The Church of Conc. You can join at http://steamcommunity.com/groups/ChurchOfConc.