Raised This Month: $ Target: $400
 0% 

CS:GO Rankme web help.


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
hardy4u
Senior Member
Join Date: Oct 2012
Location: Sydney,Australia
Old 09-28-2013 , 07:14   CS:GO Rankme web help.
Reply With Quote #1

Im trying to install rankme web interface
Plugin is working on server alright, but i cant get ranks to show on my web page.

Plugin link http://forums.alliedmods.net/showthread.php?p=1456869

My webpage that im working on http://fastdownloadcss.hostingsiteforfree.com/

Here's my databases.cfg
Code:
"Databases"
{
    "driver_default"        "mysql"
    
    // When specifying "host", you may use an IP address, a hostname, or a socket file path
    
    "default"
    {
        "driver"            "default"
        "host"                "localhost"
        "database"            "sourcemod"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
    
    "storage-local"
    {
        "driver"            "sqlite"
        "database"            "sourcemod-local"
    }

    "clientprefs"
    {
        "driver"            "sqlite"
        "host"                "localhost"
        "database"            "clientprefs-sqlite"
        "user"                "root"
        "pass"                ""
        //"timeout"            "0"
        //"port"            "0"
    }
   "thc_rpg"
   {
       "driver"    "sqlite"
       "database"  "thc_rpg"
   }
"rankme"
    {
        "driver"            "default"
        "host"                "http://fastdownloadcss.hostingsiteforfree.com/" //my website adress
        "database"            "u877031717_db1"  //database name
        "user"                "u877031717_un1"  //usernameof DB
        "pass"                "passwordofDB"  //pass of DB
        //"timeout"            "0"
        //"port"            ""
    }
}
rankme.cfg
Code:
// This file was auto-generated by SourceMod (v1.6.0-dev+3924)
// ConVars for plugin "rankme.smx"


// Auto-Purge inactive players? X = Days  0 = Off
// -
// Default: "0"
// Minimum: "0.000000"
rankme_autopurge "0"

// Show points changes on chat? 1 = true 0 = false
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_changes_chat "1"

// Enable (non-command) chat triggers. (e.g: rank, statsme, top) Recommended to be set to 0 when running with EventScripts for avoiding double responses. 1 = true 0 = false
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_chat_triggers "1"

// Days inactive to not be shown on rank? X = days 0 = off
// -
// Default: "0"
// Minimum: "0.000000"
rankme_days_to_not_show_on_rank "0"

// Dump the Database to SQL file? (required to be 1 if using the web interface and SQLite, case MySQL, it won't be dumped) 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_dump_db "0"

// Is RankMe enabled? 1 = true 0 = false
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_enabled "1"

// Free-For-All (FFA) mode? 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_ffa "0"

// Gather Statistics (a.k.a count points)? (turning this off won't disallow to see the stats already gathered) 1 = true 0 = false
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_gather_stats "1"

// Minimal kills for entering the rank
// -
// Default: "0"
// Minimum: "0.000000"
rankme_minimal_kills "0"

// Minimum players to start giving points
// -
// Default: "2"
// Minimum: "0.000000"
rankme_minimumplayers "2"

// Using MySQL? 1 = true 0 = false (SQLite)
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_mysql "0"

// Multiplier of losing points. (WARNING: MAKE SURE TO INPUT IT AS FLOAT) 1.0 equals lose same amount as won by the killer, 0.0 equals no lose
// -
// Default: "1.0"
// Minimum: "0.000000"
rankme_percent_points_lose "1.0"

// How many points the CT who defused got additional?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_defused_player "2"

// How many points CTs got for defusing the C4?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_defused_team "2"

// How many points a player loess for dropping the bomb?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_bomb_dropped "0"

// How many points the TR who planted got additional?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_exploded_player "2"

// How many points TRs got for exploding the C4?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_exploded_team "2"

// How many points a player gets for picking up the bomb?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_bomb_pickup "0"

// How many points the TR who planted got additional?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_planted_player "2"

// How many points TRs got for planting the C4?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_bomb_planted_team "2"

// How many points an alive CT got for winning the round?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_ct_round_win "0"

// How many points the CT who rescued got additional?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_hostage_rescued_player "2"

// How many points CTs got for rescuing the hostage?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_hostage_rescued_team "2"

// How many additional points a player got for a HeadShot?
// -
// Default: "1"
// Minimum: "0.000000"
rankme_points_hs "1"

// How many points a CT got for killing additional by the diffrence of points?
// -
// Default: "1"
// Minimum: "0.000000"
rankme_points_kill_bonus_ct "1"

// How many points of diffrence is needed for a CT to got the bonus?
// -
// Default: "100"
// Minimum: "0.000000"
rankme_points_kill_bonus_dif_ct "100"

// How many points of diffrence is needed for a TR to got the bonus?
// -
// Default: "100"
// Minimum: "0.000000"
rankme_points_kill_bonus_dif_tr "100"

// How many points a TR got for killing additional by the diffrence of points?
// -
// Default: "1"
// Minimum: "0.000000"
rankme_points_kill_bonus_tr "1"

// How many points a CT got for killing?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_kill_ct "2"

// How many points a TR got for killing?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_kill_tr "2"

// Multiplier of points by knife
// -
// Default: "2.0"
// Minimum: "0.000000"
rankme_points_knife_multiplier "2.0"

// If the points is f1oat, round it to next the highest or lowest? 1 = highest 0 = lowest
// -
// Default: "1"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_points_lose_round_ceil "1"

// How many points a player lose for Suiciding?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_lose_suicide "0"

// How many points a player lose for Team Killing?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_lose_tk "0"

// How many points a CT got for being the MVP?
// -
// Default: "1"
// Minimum: "0.000000"
rankme_points_mvp_ct "1"

// How many points a TR got for being the MVP?
// -
// Default: "1"
// Minimum: "0.000000"
rankme_points_mvp_tr "1"

// Starting points
// -
// Default: "1000"
// Minimum: "0.000000"
rankme_points_start "1000"

// Multiplier of points by taser
// -
// Default: "2.0"
// Minimum: "0.000000"
rankme_points_taser_multiplier "2.0"

// How many points an alive TR got for winning the round?
// -
// Default: "0"
// Minimum: "0.000000"
rankme_points_tr_round_win "0"

// How many points the VIP got for escaping?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_vip_escaped_player "2"

// How many points CTs got helping the VIP to escaping?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_vip_escaped_team "2"

// How many points the TR who killed the VIP got additional?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_vip_killed_player "2"

// How many points TRs got for killing the VIP?
// -
// Default: "2"
// Minimum: "0.000000"
rankme_points_vip_killed_team "2"

// Rank players by? 0 = STEAM:ID 1 = Name 2 = IP
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "2.000000"
rankme_rank_by "0"

// Rank by what? 1 = by points 2 = by KDR 
// -
// Default: "1"
// Minimum: "1.000000"
// Maximum: "2.000000"
rankme_rank_mode "1"

// Rank bots? 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_rankbots "0"

// Allow player to reset his own rank? 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_resetownrank "0"

// Show bots on rank/top/etc? 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_show_bots_on_rank "0"

// When rank command is used, show for all the rank of the player? 1 = true 0 = false
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_show_rank_all "0"

// The name of the table that will be used. (Max: 100)
// -
// Default: "rankme"
rankme_sql_table "rankme"

// Show AS_ maps statiscs (VIP mod) on statsme and session?
// -
// Default: "0"
// Minimum: "0.000000"
// Maximum: "1.000000"
rankme_vip_enabled "0"
config.php
PHP Code:
<?php
/* 
=====================================================
                MENSAGENS DE ERRO
=====================================================
*/
$msg[0] = "Conexão com o banco falhou!";
$msg[1] = "Não foi possível selecionar o banco de dados!";
/*
=====================================================
                    CONEXAO
=====================================================
*/

$sqlite_server true// ARE YOUR SERVER RUNNING THE PLUGIN AS SQLITE?

//(IF THE PLUGIN IS RUNNING AS MYSQL, PUT BELOW THE DATA FOR CONNECTING TO THE DATABASE THAT IS BEING USED BY THE PLUGIN)
$bd_user "u877031717_un1"// DATABASE USER 
$bd_password "passofDB";// DATABASE PASS
$bd "u877031717_db1";// DATABASE
$host "http://fastdownloadcss.hostingsiteforfree.com/";    // DATABASE HOST
$bd_table ""// DATABASE TABLE BEING USED AT THE PLUGIN. (rankme_sql_table cvar). Default: rankme.

$ftp_server ""//FTP HOST
$ftp_user_name ""// FTP USER NAME
$ftp_user_pass ""// FTP PASS
$ftpDIR ""// CSTRIKE FOLDER ON FTP

// Fazendo a conexão com o servidor MySQL
$conexao mysql_pconnect($host,$bd_user,$bd_password) or die($msg[0]);
mysql_select_db($bd,$conexao) or die($msg[1]);
?>
__________________


I fix/manage Servers of CS:S,CS:GO | Steam ID :- t1rath
Donations (CS:GO items) keeps me motivated.

Last edited by hardy4u; 09-28-2013 at 07:16.
hardy4u is offline
Maxximou5
AlliedModders Donor
Join Date: Feb 2013
Old 09-28-2013 , 17:07   Re: CS:GO Rankme web help.
Reply With Quote #2

I would suggest using your database IP and not a domain name.
Your URL resolves to 185.28.21.25 but I would suggest looking to see if you have a different DB one.
Maxximou5 is offline
xLiquidKillsx
New Member
Join Date: Sep 2013
Old 10-01-2013 , 15:32   Re: CS:GO Rankme web help.
Reply With Quote #3

I found this at the website of your database host
It doesn't allow remote access so you have to search for another host.
Try "db4free.net". Unfortunately you can only have 1 database there, but they allow remote access.
I hope this helps
Quote:
Can I connect to MySQL from my home computer?

No, remote MySQL connections are disabled for security and performance reasons. You can only connect to MySQL from your scripts hosted on our servers.
xLiquidKillsx is offline
hardy4u
Senior Member
Join Date: Oct 2012
Location: Sydney,Australia
Old 10-02-2013 , 03:47   Re: CS:GO Rankme web help.
Reply With Quote #4

Quote:
Originally Posted by xLiquidKillsx View Post
I found this at the website of your database host
It doesn't allow remote access so you have to search for another host.
Try "db4free.net". Unfortunately you can only have 1 database there, but they allow remote access.
I hope this helps
Many thax for ur initiative
But im unaware of several things
btw here are my details @the site u provides

Database: goindiadata90
Username: mypassword
Allowed IPs: %
Collation: utf8_general_ci


so now what info/commands goes where/which config file?
__________________


I fix/manage Servers of CS:S,CS:GO | Steam ID :- t1rath
Donations (CS:GO items) keeps me motivated.
hardy4u is offline
hardy4u
Senior Member
Join Date: Oct 2012
Location: Sydney,Australia
Old 10-11-2013 , 02:47   Re: CS:GO Rankme web help.
Reply With Quote #5

BUMP!

any tut to install rankme web interface?
anyone?
__________________


I fix/manage Servers of CS:S,CS:GO | Steam ID :- t1rath
Donations (CS:GO items) keeps me motivated.
hardy4u is offline
Hackmastr
Member
Join Date: Sep 2013
Old 11-12-2013 , 10:48   Re: CS:GO Rankme web help.
Reply With Quote #6

Quote:
Originally Posted by hardy4u View Post
BUMP!

any tut to install rankme web interface?
anyone?
Add me on steam, steamcommunity.com/id/killtmwt
Hackmastr is offline
tommie113
AlliedModders Donor
Join Date: Oct 2013
Old 11-12-2013 , 12:13   Re: CS:GO Rankme web help.
Reply With Quote #7

add your ftp details in the config
__________________
No longer taking requests due to lack of time and interrest.
Only helping out with minor things through forum.
tommie113 is offline
cREANy0
SourceMod Donor
Join Date: Jul 2012
Location: Germany
Old 11-14-2013 , 16:22   Re: CS:GO Rankme web help.
Reply With Quote #8

Quote:
Originally Posted by tommie113 View Post
add your ftp details in the config
............
Only a joke or are you really dumb?
__________________

Last edited by cREANy0; 11-14-2013 at 16:23.
cREANy0 is offline
Maxximou5
AlliedModders Donor
Join Date: Feb 2013
Old 11-14-2013 , 17:39   Re: CS:GO Rankme web help.
Reply With Quote #9

Quote:
Originally Posted by cREANy0 View Post
............
Only a joke or are you really dumb?
I don't see how that's dumb, giving out your legitimate access is dumb.
He's serious because its left blank. If he has filled it out it'd be false information (typically).
Maxximou5 is offline
skner
New Member
Join Date: Aug 2015
Old 08-30-2015 , 10:44   Re: CS:GO Rankme web help.
Reply With Quote #10

Hello all!

So i have a problem connecting the rankme plugin to the web interface. I'm getting this error. That's all i know.

Code:
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/phantoms/public_html/rank/index.php on line 19
I hope somebody can help me out!

Thanks and have a good day.
skner is offline
Reply



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 10:48.


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