Clan ingame ranking

[BG-Nero]

Hey,

i`ve created few weeks ago a thread like this one but i thought it is fixed but it isn`t.
I still can`t find a solution already searched so i am posting this thread now.
I am requesting the code to execute it for my database that i see ingame the clan rank.

I would appreciate that if someone would post the code down below i have to execute at mssql.

Thanks.

[MentaL]

[Vusion]

Try this, just written it.

<?php
$con = mssql_connect("OMAR-PC\SQLEXPRESS", "sa", "mazemania1");
mssql_select_db("GunzDB", $con);

$q = mssql_query("SELECT CLID FROM Clan WHERE DeleteFlag != 1 AND ((Wins != 0) OR (Losses != 0)) ORDER BY Point DESC, Wins DESC, Losses ASC");
$rank = 1;

while($fetch = mssql_fetch_array($q))
{
	$q = mssql_query("UPDATE Clan SET Ranking = ".$rank." WHERE CLID = ".$fetch['CLID']."");
	$rank++;
}
?>

[BG-Nero]

Try this, just written it.

<?php
$con = mssql_connect("OMAR-PC\SQLEXPRESS", "sa", "mazemania1");
mssql_select_db("GunzDB", $con);

$q = mssql_query("SELECT CLID FROM Clan WHERE DeleteFlag != 1 AND ((Wins != 0) OR (Losses != 0)) ORDER BY Point DESC, Wins DESC, Losses ASC");
$rank = 1;

while($fetch = mssql_fetch_array($q))
{
	$q = mssql_query("UPDATE Clan SET Ranking = ".$rank." WHERE CLID = ".$fetch['CLID']."");
	$rank++;
}
?>

This is a php code o.o.
Or can i just execute this one too :O?

[ThunderZ]

This is a php code o.o.
Or can i just execute this one too :O?

yes..just execute it.

he just gave you a script that will order by points,wins etc and will rank them by the top ones.

[BG-Nero]

yes..just execute it.

he just gave you a script that will order by points,wins etc and will rank them by the top ones.

But this is a php code and this code is trying to connect to the database but if you execute something you already got a connection to the db but i will try it and reply back.

---

Edit : Executed in mssql but got ton of errors..
Probally because this is php not a mssql query.

[Vusion]

It's a php code, obviously.

[Secured]

But this is a php code and this code is trying to connect to the database but if you execute something you already got a connection to the db but i will try it and reply back.

---

Edit : Executed in mssql but got ton of errors..
Probally because this is php not a mssql query.

are you looking for a query for for a script for a website?

SELECT CLID FROM Clan WHERE DeleteFlag != 1 AND ((Wins != 0) OR (Losses != 0)) ORDER BY Point DESC, Wins DESC, Losses ASC

Because thats the query -_-

[BG-Nero]

are you looking for a query for for a script for a website?

SELECT CLID FROM Clan WHERE DeleteFlag != 1 AND ((Wins != 0) OR (Losses != 0)) ORDER BY Point DESC, Wins DESC, Losses ASC

Because thats the query -_-

Yeah i meant a query for the database not a php script well on which table i have to execute this?

[ThunderZ]

Yeah i meant a query for the database not a php script well on which table i have to execute this?

it already selects the table..

its ran from GunzDB database.

[BG-Nero]

it already selects the table..

its ran from GunzDB database.

Executed the query..
Still i don´t see the rank of my ingame.
I am using the 08 files.

[Vusion]

Dear god, I'm looping a query which selects the best clans ordering them by point, wins, loses and inserting to it ranking 1, then increasing that rank and going on to the second best clan and adding ranking 2, and so on.

Please, for the love of god, this is a PHP script.............

[BG-Nero]

Dear god, I'm looping a query which selects the best clans ordering them by point, wins, loses and inserting to it ranking 1, then increasing that rank and going on to the second best clan and adding ranking 2, and so on.

Please, for the love of god, this is a PHP script.............

I know that this is a PHP script i am in need of the query for the database not the PHP script and the query i`ve used of ThunderZ did nothing changed i even restarted the server

[Coldfx]

Take an look to this.

http://forum.ragezone.com/f245/tutor...showup-271019/

[BG-Nero]

Take an look to this.

http://forum.ragezone.com/f245/tutor...showup-271019/

Thank you will try it later and post back.

[Vusion]

How hard is it to open a .php file and paste the code in it?

then go to yourweb.com/the.phpfile.

[BG-Nero]

Because i dont want to use this extra pages.

Btw the query worked thanks to both of you maybe i will be using later this php script but for now my rank ingame works!