Raised This Month: $248 Target: $400
 62% 

TFC skills rank with speed run timer


Post New Thread Reply   
 
Thread Tools Display Modes
foamy11
New Member
Join Date: Aug 2007
Old 03-07-2009 , 14:10   Re: TFC skills rank with speed run timer
Reply With Quote #61

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
foamy11 is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 08-30-2009 , 07:33   Re: TFC skills rank with speed run timer
Reply With Quote #62

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.

Last edited by White Bishop; 08-30-2009 at 07:53.
White Bishop is offline
Lt Llama
Senior Member
Join Date: Aug 2004
Old 08-30-2009 , 18:44   Re: TFC skills rank with speed run timer
Reply With Quote #63

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.
__________________
A dodo: Used to describe someone without common sense and who always has the pathetic confused look on their face when a question is asked.
Lt Llama is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 08-31-2009 , 03:05   Re: TFC skills rank with speed run timer
Reply With Quote #64

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:

Code:
<?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!

Last edited by White Bishop; 08-31-2009 at 03:11.
White Bishop is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 08-31-2009 , 04:03   Re: TFC skills rank with speed run timer
Reply With Quote #65

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


Code:
session_start();
$steamid = $_GET["steamid"];
$nickname = $_GET["nickname"];
$nfinished = $_GET["nfinished"];
$totalrank = $_GET["totalrank"];
$primaryrank = $_GET["primaryrank"];
$_SESSION['steamid'] = $steamid;
White Bishop is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 08-31-2009 , 08:10   Re: TFC skills rank with speed run timer
Reply With Quote #66

If you like to see the plugin in action, goto

http://ChurchOfConc.servehalflife.com


and click on
'Statisitcs'
White Bishop is offline
Lt Llama
Senior Member
Join Date: Aug 2004
Old 09-01-2009 , 04:30   Re: TFC skills rank with speed run timer
Reply With Quote #67

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?
__________________
A dodo: Used to describe someone without common sense and who always has the pathetic confused look on their face when a question is asked.
Lt Llama is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 09-02-2009 , 22:58   Re: TFC skills rank with speed run timer
Reply With Quote #68

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?
__________________

Last edited by White Bishop; 09-03-2009 at 01:35.
White Bishop is offline
Lt Llama
Senior Member
Join Date: Aug 2004
Old 09-03-2009 , 02:20   Re: TFC skills rank with speed run timer
Reply With Quote #69

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.
__________________
A dodo: Used to describe someone without common sense and who always has the pathetic confused look on their face when a question is asked.
Lt Llama is offline
White Bishop
Junior Member
Join Date: Apr 2008
Old 09-03-2009 , 20:24   Re: TFC skills rank with speed run timer
Reply With Quote #70

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

Last edited by White Bishop; 09-07-2009 at 00:39.
White Bishop is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:11.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode