GC - Admin not in ranking ?

Newbie Spellweaver
Joined
Sep 27, 2008
Messages
26
Reaction score
0
Hello,
I would like to see the ranking/statistics without Admin's in list.
I can delete the admins in mysql but when I'm update the statistics are the admins in list.
(It is silly when the admins must manually delete from list after each statistic update.)

Can any one help me, please ?
 
I have an idea

i have change this in "admin/statbuilder.php"

PHP:
	$GameUsers  = doquery("SELECT * FROM {{table}}", 'users');

to

PHP:
	$GameUsers  = doquery("SELECT * FROM {{table}} WHERE `authlevel` = '0';" , 'users');

THIS WORKING , but if i klick this are this on top:
Warning: Cannot modify header information - headers already sent by (output started at /users/horus/www/gc_game/admin/statbuilder.php:1) in /users/horus/www/gc_game/includes/functions/CheckCookies.php on line 55

who knows more
 
Hello
her's a link to xnova download of ver.



hope this is what you are looking for :8:

PS: the Data file from the Rage Online will work with this one .
if you can't find it here i'll setup a link from my sever for it a little later
just PM me if need ...
 
Last edited:
i need a optimal database for this version


EDIT: in overview are the list with colonies , two in each line - how i can change it , instead of two, four ?
 
Last edited:
well hears a good DB that work's on xnova
and i did see just on the overview a erro at line 41
so i put a fixed overview.php in the zip as well



hope it help you out.
not to shur as to what you mean on the 2 to 4
need to know more of you are asking ...
:thumbup1:
 
thanks,
but options still not working / i klick options , he changes to option site but i can see nothing there (only left menu and backround)

-

from 2 to 4 i mean:
HorusEye - GC - Admin not in ranking ? - RaGEZONE Forums

to
HorusEye - GC - Admin not in ranking ? - RaGEZONE Forums
 
ok i see humm
aa
in the overview.php
find like this
PHP:
// Show Planet Lists
		$planets_query = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user['id']}'", "planets");
		$Colone  = 1;
		$AllPlanets = "<tr>";
		while ($UserPlanet = mysql_fetch_array($planets_query)) {
			if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
				$AllPlanets .= "<th>". $UserPlanet['name'] ."<br>";
				$AllPlanets .= "<a href=\"?cp=". $UserPlanet['id'] ."&re=0\" title=\"". $UserPlanet['name'] ."\"><img src=\"". $dpath ."planeten/small/s_". $UserPlanet['image'] .".jpg\" height=\"50\" width=\"50\"></a><br>";
				$AllPlanets .= "<center>";
then change it to this just the $Colone
PHP:
// Show Planet Lists
		$planets_query = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user['id']}'", "planets");
		$Colone  = 0;
		$AllPlanets = "<tr>";
		while ($UserPlanet = mysql_fetch_array($planets_query)) {
			if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
				$AllPlanets .= "<th>". $UserPlanet['name'] ."<br>";
				$AllPlanets .= "<a href=\"?cp=". $UserPlanet['id'] ."&re=0\" title=\"". $UserPlanet['name'] ."\"><img src=\"". $dpath ."planeten/small/s_". $UserPlanet['image'] .".jpg\" height=\"50\" width=\"50\"></a><br>";
				$AllPlanets .= "<center>";
this will make it to 3 but to 4 i think pic size or it may be in the tmlp file
capture #41 - GC - Admin not in ranking ? - RaGEZONE Forums
 
nice thanks
but this change only the first line, the other lines are 2


and was are with the options ? in xnova-0.8.SP1

options still not working / i klick options , he changes to option site but i can see nothing there (only left menu and backround)
 
ok oOo
yes
ok we strated like this
PHP:
// Show Planet Lists
		$planets_query = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user['id']}'", "planets");
		$Colone  = 1;
		$AllPlanets = "<tr>";
		while ($UserPlanet = mysql_fetch_array($planets_query)) {
			if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
				$AllPlanets .= "<th>". $UserPlanet['name'] ."<br>";
				$AllPlanets .= "<a href=\"?cp=". $UserPlanet['id'] ."&re=0\" title=\"". $UserPlanet['name'] ."\"><img src=\"". $dpath ."planeten/small/s_". $UserPlanet['image'] .".jpg\" height=\"50\" width=\"50\"></a><br>";
				$AllPlanets .= "<center>";

			// Check Building Queue
				if ($UserPlanet['b_building'] != 0) {
					UpdatePlanetBatimentQueueList ( $UserPlanet, $user );
					if ( $UserPlanet['b_building'] != 0 ) {
						$BuildQueue      = $UserPlanet['b_building_id'];
						$QueueArray      = explode ( ";", $BuildQueue );
						$CurrentBuild    = explode ( ",", $QueueArray[0] );
						$BuildElement    = $CurrentBuild[0];
						$BuildLevel      = $CurrentBuild[1];
						$BuildRestTime   = pretty_time( $CurrentBuild[3] - time() );
						$AllPlanets     .= '' . $lang['tech'][$BuildElement] . ' (' . $BuildLevel . ')';
						$AllPlanets     .= "<br><font color=\"#7f7f7f\">(". $BuildRestTime .")</font>";
					} else {
						CheckPlanetUsedFields ($UserPlanet);
						$AllPlanets     .= $lang['Free'];
					}
				} else {
					$AllPlanets    .= $lang['Free'];
				}

				$AllPlanets .= "</center></th>";
				if ($Colone <= 1) {
					$Colone++;
				} else {
					$AllPlanets .= "</tr><tr>";
					$Colone      = 1;
				}
			}
		} // End While

top $colone and the end $colone to change i'm still playing around with it but this will fix it plus the one about that to 2
will give you the 4

PHP:
// Show Planet Lists
		$planets_query = doquery("SELECT * FROM {{table}} WHERE id_owner='{$user['id']}'", "planets");
		$Colone  = 0;
		$AllPlanets = "<tr>";
		while ($UserPlanet = mysql_fetch_array($planets_query)) {
			if ($UserPlanet["id"] != $user["current_planet"] && $UserPlanet['planet_type'] != 3) {
				$AllPlanets .= "<th>". $UserPlanet['name'] ."<br>";
				$AllPlanets .= "<a href=\"?cp=". $UserPlanet['id'] ."&re=0\" title=\"". $UserPlanet['name'] ."\"><img src=\"". $dpath ."planeten/small/s_". $UserPlanet['image'] .".jpg\" height=\"50\" width=\"50\"></a><br>";
				$AllPlanets .= "<center>";

			// Check Building Queue
				if ($UserPlanet['b_building'] != 0) {
					UpdatePlanetBatimentQueueList ( $UserPlanet, $user );
					if ( $UserPlanet['b_building'] != 0 ) {
						$BuildQueue      = $UserPlanet['b_building_id'];
						$QueueArray      = explode ( ";", $BuildQueue );
						$CurrentBuild    = explode ( ",", $QueueArray[0] );
						$BuildElement    = $CurrentBuild[0];
						$BuildLevel      = $CurrentBuild[1];
						$BuildRestTime   = pretty_time( $CurrentBuild[3] - time() );
						$AllPlanets     .= '' . $lang['tech'][$BuildElement] . ' (' . $BuildLevel . ')';
						$AllPlanets     .= "<br><font color=\"#7f7f7f\">(". $BuildRestTime .")</font>";
					} else {
						CheckPlanetUsedFields ($UserPlanet);
						$AllPlanets     .= $lang['Free'];
					}
				} else {
					$AllPlanets    .= $lang['Free'];
				}

				$AllPlanets .= "</center></th>";
				if ($Colone <= 2) {
					$Colone++;
				} else {
					$AllPlanets .= "</tr><tr>";
					$Colone      = 0;
				}
			}
		} // End While
 
Last edited:
ok this working perfect
...

and the option problem ?
if you can help me - you are the best :D:
 
Last edited:
aaa cool on getting your option problem fix ....

not at this time on that login screen ya it is cool but will need to make changes so
ogame ppl don't set a cr ap on us but i try working on it a little later and see how much is to do for it.
 
hm ok, my new files have statbuilder bug , nxova9 with dark matter

when i klick update points on admin than i get error
Erreur, merci de contacter l'admin. Erreur n�: 1041

on "game errors" :
1041 SQL Error
Unknown column 'points' in 'field list'
UPDATE game_users SET `points` = '3154.69145' WHERE `id` = '1' LIMIT 1;


at the moment i use statbuilder.php from my old version, but I do not 100% know if this works
 
Back