[REQUEST] legion member script

Page 1 of 2 1 2
10/05/2008 02:56 PowerChaos#1
ok guys , Thank you all for helping me so far but i got a other problem that i cant get fixed :S

i try to show the legion name of every member on my info page , but i cant get it to work becouse it says all the time that i got a error in the script :S

let me explain what i try to create ^^ that always helps

first i need to get a conection of 2 differend tables
so i use the Toplegion.php to start whit becouse then i got the legion table

then i need to get $row[id] and [$row[synt_id] (if they match) to the $row[NAME] as prefix $legionname

i tryed differend things out but becouse i dont know php that good so i need help :S

here is a previeuw of the code i got working so far whit 1 error in it (so it doesnt work :S )

PHP Code:
$legions = mysql_query("SELECT NAME,id,leader_name,money,amount FROM cq_syndicate ORDER by money desc limit 5"); //custom added 
    $legio = mysql_query("SELECT syn_id FROM cq_synattr ORDER by syn_id desc limit 5" ); //custom added             
    $rank = mysql_query("SELECT NAME,level,profession,emoney,money_saved FROM cq_user ORDER by emoney desc limit 100"); 
    //$row = mysql_fetch_array($rank); 
    $i=1;    
 while($row = mysql_fetch_array($rank)){ 
 while($row1 = mysql_fetch_array($legio)); //custom added
 while($row2 = mysql_fetch_array($legions)); // custom added
 $legion = ($row2[id] == $row1[syn_id] = $row2[NAME]); //custom added
{
    if($row['profession']==20)
 {
    $profession='warrior';
 }
    else if($row['profession']==30)
  {
    $profession='Paladin';
  }
    else{$profession='mage';
 
}
        echo ' 
    <td><font color="#FFFFFF"><div align="center">'.$i.'</td>
    <td><font color="#FFFFFF"><div align="center">'.$row['NAME'].'</td>
    <td><font color="#FFFFFF"><div align="center">'.$row['level'].'</td>
    <td><font color="#FFFFFF"><div align="center">'.$profession.'</td>
    <td><font color="#FFFFFF"><div align="center">'.$row['emoney'].'</td> 
    <td><font color="#FFFFFF"><div align="center">'.$row['money_saved'].'</td>
    <td><font color="#FFFFFF"><div align="center">'.$legion.'</td> //custom added 
  </tr> '; 
  $i=$i+1; 
    } 
and this is the error i get :S
Code:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in W:\www\test\moneybag.php on line 55
this error goes over the second
PHP Code:
while 
but its fixed now , it was a wrong table name

[Only registered and activated users can see links. Click Here To Register...]

*edit*
i got it fixed so far , but now it shows only the number 1 instead of the legion names :S
*end of edit*
Thank you and Grees From The Crasher
10/05/2008 20:30 PowerChaos#2
*bumping*

hmm , still no solution :S

do some1 know how to fix the problem , the problem is that it doesnt get the names of the legion from the matching numbers (so far i know) and i dont know what command i need to use for it to make it work :s

Greets from The Crasher
10/06/2008 06:42 funhacker#3
might help if you explained in your code what your trying to do, along with a highlight of what line 55 is since there isnt any more then around 20lines there

Code:
SELECT syn_id FROM cq_synattr ORDER by syn_id desc limit 5
you didnt put a where clause in there I honestly dont know what your trying to do with this bit of code but if say you want to display the leader name of the top 5 you could just use the field in cq_syndicate or
Code:
SELECT syn_id FROM cq_synattr using cq_synattr inner join cq_syndicate where cq_synattr.syn_id = cq_syndicate.id and cq_synattr.player_id = cq_syndicate.leader_id and cq_synattr.rank = 1000 ORDER by syn_id desc limit 5
I cant say for sure all the fields are right or even the syntax tbh I dont use select at all when doing sql queries, I suggest though you say exactly what each query is spose to do and explain what your trying to do what is messing up etc
10/06/2008 14:56 PowerChaos#4
i dont know mutch of coding so i try to edit the script whit the codes i got :S (maybe thats the problem)

ok here i goin explain what i try to do

on the legion script you can see the legion leaders , the thing i try is to show the legion members to

now the problem is that in that table are only numbers
so if the numbers match each othther then it need to show the name

row1 [id]= 1250
row2 [id]=1250
row2 [name] = Legion

this is the shortest way and probaly the most clean way of explaining :s what i try to do

and to explain it a little more of the goal i try to do :)
i try to make a huge info script page where you can see every rank on in 1 single page :)

the code work this far that it shows no errors anymore , exept that it doesnt check the data to each other :S

moneybag.php (original , exept where stand something of edit , thats my code)
PHP Code:
<?php 
$legions = mysql_query("SELECT NAME,id,leader_name,money,amount FROM cq_syndicate ORDER by id desc limit 10"); //edit 
$guilds = mysql_query("SELECT syn_id FROM cq_synattr ORDER by syn_id limit 10"); //edit
$rank = mysql_query("SELECT NAME,level,profession,emoney,money_saved FROM cq_user ORDER by emoney desc limit 10"); 
//$row = mysql_fetch_array($rank); 
$i=1; 
while($row = mysql_fetch_array($rank)){  // if i dete this { then it doesnt show anything anymore
while($row1 = mysql_fetch_array($guilds)); //edit this was line 55 but was wrong table , so its fixed
while($row2 = mysql_fetch_array($legions)); //edit 
//$legion = ($row2['id'] == $row1['syn_id'] = $row2['NAME']); // my edit 
$legion =($row2['id'] != $row1['syn_id']) ? $row2['NAME'] : 'no legion'; //last solution from some1 els
the last solution works but not like it need to be , it only shows 'no Legion' instead of the legion name

Greets From The Crasher

@funhacker , i tryed out your code , but it give the same emty solution (it doesnt show anything :S )
10/06/2008 17:15 funhacker#5
ok hope this helps it will select the legions and peoples names within that legion dependant by their gold, it will show you Deputys -> leaders only and is limited to 100 entries

Code:
SELECT cq_syndicate.NAME,cq_syndicate.money,cq_user.name FROM cq_syndicate,cq_synattr,cq_user WHERE cq_syndicate.id =  cq_synattr.syn_id AND cq_synattr.rank >=  900 AND cq_synattr.id =  cq_user.id ORDER BY cq_syndicate.money DESC LIMIT 100
10/12/2008 11:35 nooneatall#6
*edit* nvm :D
10/12/2008 19:29 PowerChaos#7
i gave up this script becouse it doesnt seems to work at all :S

its to difficult for me to figure the problem out , i got about 100 differend solutions and not even 1 works like it need to work :S

if some1 can bring out the script that show the legion members (name of player and legion of player and rank in legion ) on the top 10 page then i would be happy to have that script :)

Greets From The Crasher
10/12/2008 23:28 funhacker#8
mine should show Legion Name PLayer Name and Total Gold in Legion, to show ranks would be slightly more complex, you could make another table named legion_ranks, have id = rank number and then name = the name of that rank, example 1000 - Leader 990 - Leader's Spouse, etc
then you would just have it also select that table matching the names with the rank number<->id from legion_ranks
10/13/2008 16:18 PowerChaos#9
that kind is that way of how the tables of sync works :)

exept that it is splitted into 2 tables , 1 of your legion script (gold , members , name ) and 1 of the members only ( ranks , legion )

so i was thinking to get the 2 tables combined in 1 script but it seems to be verry hard to get that done

if i do it the other way like you say , putting it into 1 table then it doesnt automatic update itself and thats harder to manage (manuel updating )

so :S maybe thats a solution for it but it isnt the thing i wanted (it need a automatic update)

i dont know in what way it is posseble to do but it doesnt seems that it is easy to do (or maybe i just miss a few commands ^^ )

the last solution of you displayed something (i think it was numbers , or "$legion_name" , but not the thing it needed to do )

stil , Thank you for trying to help me and Greets From The Crasher
10/14/2008 00:25 funhacker#10
Well I dont think you fully understand or tried my query.

Code:
SELECT 
cq_syndicate.NAME,cq_syndicate.money,cq_user.name 
FROM 
cq_syndicate,cq_synattr,cq_user 
WHERE 
cq_syndicate.id =  cq_synattr.syn_id 
AND 
cq_synattr.rank >=  900 
AND 
cq_synattr.id =  cq_user.id 
ORDER BY 
cq_syndicate.money 
DESC LIMIT 100
The output for acme database is like so

Code:
Legion Name - Legion Gold - Player Name
----------------------------------------
Death_Knights-66614767114-DEMONKILLER6969
Death_Knights-66614767114-Joshua
Death_Knights-66614767114-Lord_Pain
Death_Knights-66614767114-DeathsMistress
Death_Knights-66614767114-Squeeky
Death_Knights-66614767114-death-to-all
Death_Knights-66614767114-Murder-Me-16
Gr34T_SouL-63355847661-~*Al-prince*~
Gr34T_SouL-63355847661-+_MAILED_+
Gr34T_SouL-63355847661-AdzorpTion
Gr34T_SouL-63355847661-_LorD_
Gr34T_SouL-63355847661-~kræM~
~*We*R*JustiCe*-61030391618-###zoom###
~*We*R*JustiCe*-61030391618-*~ELAMER~*
~*We*R*JustiCe*-61030391618-FalCon
~*We*R*JustiCe*-61030391618-*&Dark&Hell&*
~*We*R*JustiCe*-61030391618-BeBoo
~*We*R*JustiCe*-61030391618-Elcomanda
~*We*R*JustiCe*-61030391618-*MaTReX*
.:!All-$tars!:.-57994688979-mtirx
.:!All-$tars!:.-57994688979-elzaem
.:!All-$tars!:.-57994688979-H.....A...AHMED
.:!All-$tars!:.-57994688979-necroshear
.:!All-$tars!:.-57994688979-Motherm
.:!All-$tars!:.-57994688979-***JM***
.:!All-$tars!:.-57994688979-spiderman2008
The_Masters-48282621125-kate.
The_Masters-48282621125-asklepius
The_Masters-48282621125-ZARATOR
The_Masters-48282621125-Kushumai
The_Masters-48282621125-l_Un4GiveN_l
The_Masters-48282621125-MEGUMI
The_Masters-48282621125-#24marley#24
HeartlessAngels-45567097486-~DeaTh~ScorpIon
HeartlessAngels-45567097486-~Fire*Man~
HeartlessAngels-45567097486-#90Andy#90
HeartlessAngels-45567097486-Tsubasa.
HeartlessAngels-45567097486-RavensAngel
The|Al|Che|Mist-45338446403-SARAY_SOYOP
The|Al|Che|Mist-45338446403-cristina
The|Al|Che|Mist-45338446403-IchigoBL
The|Al|Che|Mist-45338446403-3565413.1897
JuSt`CaVaLLi-44472622720-JuSt`CaVaLLi
JuSt`CaVaLLi-44472622720-~NOVA~
JuSt`CaVaLLi-44472622720-Sat-Thu
JuSt`CaVaLLi-44472622720-NightWalKer
JuSt`CaVaLLi-44472622720-neoplanet
JuSt`CaVaLLi-44472622720-zhai
Dark*Empire-43977705029-WarStar
Dark*Empire-43977705029-NarutoOFTheLeaf
Dark*Empire-43977705029-daRk^KiNgpLar
Dark*Empire-43977705029-hazzer
Dark*Empire-43977705029-masterlink
Dark*Empire-43977705029-Hell_Enma#71
Dark*Empire-43977705029-Pro_Mage
AtrumDeus-42621409603-Cagney
AtrumDeus-42621409603-.Gunner.
AtrumDeus-42621409603-Br0KeN~HeArT
AtrumDeus-42621409603-JechT
AtrumDeus-42621409603-jay
AtrumDeus-42621409603-memaloca
AtrumDeus-42621409603-.:NeutraL:.
Smith|Warrior-41006617958-*°::.Lobão.::°*
Smith|Warrior-41006617958-Secret_Love
Smith|Warrior-41006617958-Duplex_s2
Smith|Warrior-41006617958-sakura
Smith|Warrior-41006617958-lucifer_S2
Smith|Warrior-41006617958-Witch<OF>Hill
~.:Steels:.~-39840251839-Jensen94
~.:Steels:.~-39840251839-Mcoy2x
~.:Steels:.~-39840251839-SAIFE
~.:Steels:.~-39840251839-aaron99
UnholY__KnightS-36960822825-~Joan*Of*Arc~
UnholY__KnightS-36960822825-.:|_Mordrid_|:.
UnholY__KnightS-36960822825-~MERLIN~
UnholY__KnightS-36960822825-Tapitsgabs
UnholY__KnightS-36960822825-tapit_420
Rebles_Of_Love~-36292197935-hoop
Rebles_Of_Love~-36292197935--SeRiNiTy-
Rebles_Of_Love~-36292197935-hellrazor
Rebles_Of_Love~-36292197935-N0T~CHiiLDiiSH
Rebles_Of_Love~-36292197935-hellboy
Rebles_Of_Love~-36292197935-Banana
~*SuPeRnOvA*~-34311225287-)~(FLaRe)~(
~*SuPeRnOvA*~-34311225287-Justinbebustin
~*SuPeRnOvA*~-34311225287-~*Rogeris*~
~*SuPeRnOvA*~-34311225287--|chio_ram|-
~*SuPeRnOvA*~-34311225287-~~Cloud~~
~*SuPeRnOvA*~-34311225287--|ScottBakula|-
Alchemist-33441116016-TyrionLannister
Alchemist-33441116016-sweethoney
Alchemist-33441116016-King_Dragon
Alchemist-33441116016-Mr.Andrew
Alchemist-33441116016-Brandivio
Nicafe_Idiots!-31555358530-gago_ka?
^-^SpartanI^-^-30087091970-~Dan~
^-^SpartanI^-^-30087091970-*Dany*SMK*
Ar|a_51-29098259413-Plagu3
Ar|a_51-29098259413-killer_girl
Ar|a_51-29098259413-MooM
Now if you wanted to display the ranks of these guys you would have another table

Name: legion_rank_name
Design:
Code:
rank_number  -  rank_name
---------------------------
1000  -  Leader
990  -  Deputy
980  -  HonorDeputy
920  -  Leader'sSpouse
900  -  6-star
890  -  General
880  -  HonorGeneral
850  -  Captain
840  -  HonorCaptain
690  -  Lieutenant
680  -  HonorLieut.
620  -  Deputy'sSpouse
611  -  Deputy'sAide
610  -  LeadSpouseAide
603  -  Secretary
602  -  LeaderSecretary
600  -  3-star
590  -  Sergeant
521  -  Captain'sSpouse
520  -  General'sSpouse
511  -  Captain'sAide
510  -  General'sAide
500  -  2-star
490  -  SeniorMember
420  -  Lieut.'sSpouse
400  -  1-star
240  -  Level1Member
230  -  Level2Member
220  -  Level3Member
201  -  JuniorMember
200  -  CommonMember
100  -  Reservist
then you would change the above sql query to look like this to display legion rank next to their name

Code:
SELECT
cq_syndicate.NAME,
cq_syndicate.money,
cq_user.name,
legion_rank_name.rank_name
FROM
cq_syndicate ,
cq_user ,
cq_synattr
Inner Join legion_rank_name ON cq_synattr.rank = legion_rank_name.rank_number
WHERE 
cq_syndicate.id =  cq_synattr.syn_id 
AND 
cq_synattr.rank >=  900 
AND 
cq_synattr.id =  cq_user.id
ORDER BY
cq_syndicate.money DESC,
cq_synattr.rank DESC
LIMIT 100
and if you don't feel like making the table run this SQL code to create the table needed, I can assure you this works fine

Code:
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `legion_rank_name`;
CREATE TABLE `legion_rank_name` (
  `rank_number` int(4) NOT NULL default '0',
  `rank_name` char(50) default NULL,
  PRIMARY KEY  (`rank_number`)
) TYPE=MyISAM;

INSERT INTO `legion_rank_name` VALUES ('1000', 'Leader'),
('990', 'Deputy'),
('980', 'HonorDeputy'),
('920', 'Leader\'sSpouse'),
('900', '6-star'),
('890', 'General'),
('880', 'HonorGeneral'),
('850', 'Captain'),
('840', 'HonorCaptain'),
('690', 'Lieutenant'),
('680', 'HonorLieut.'),
('620', 'Deputy\'sSpouse'),
('611', 'Deputy\'sAide'),
('610', 'LeadSpouseAide'),
('603', 'Secretary'),
('602', 'LeaderSecretary'),
('600', '3-star'),
('590', 'Sergeant'),
('521', 'Captain\'sSpouse'),
('520', 'General\'sSpouse'),
('511', 'Captain\'sAide'),
('510', 'General\'sAide'),
('500', '2-star'),
('490', 'SeniorMember'),
('420', 'Lieut.\'sSpouse'),
('400', '1-star'),
('240', 'Level1Member'),
('230', 'Level2Member'),
('220', 'Level3Member'),
('201', 'JuniorMember'),
('200', 'CommonMember'),
('100', 'Reservist'),
('4', '0-star'),
('3', '4-star'),
('2', '5-star'),
('1', '7-star');


finaly the result of the new query with the new table is as follows for acme

Code:
Legion Name		Total Gold		Member Name		Member Rank
===========================================================================
Death_Knights		66614767114		Murder-Me-16		Leader
Death_Knights		66614767114		death-to-all		Deputy
Death_Knights		66614767114		DEMONKILLER6969		Deputy
Death_Knights		66614767114		Joshua			Deputy
Death_Knights		66614767114		Squeeky			Deputy
Death_Knights		66614767114		Lord_Pain		HonorDeputy
Death_Knights		66614767114		DeathsMistress		HonorDeputy
Gr34T_SouL		63355847661		+_MAILED_+		Leader
Gr34T_SouL		63355847661		_LorD_			Deputy
Gr34T_SouL		63355847661		~kræM~			Deputy
Gr34T_SouL		63355847661		AdzorpTion		HonorDeputy
Gr34T_SouL		63355847661		~*Al-prince*~		HonorDeputy
~*We*R*JustiCe*		61030391618		FalCon			Leader
~*We*R*JustiCe*		61030391618		*MaTReX*		Deputy
~*We*R*JustiCe*		61030391618		###zoom###		Deputy
~*We*R*JustiCe*		61030391618		*&Dark&Hell&*		Deputy
~*We*R*JustiCe*		61030391618		*~ELAMER~*		Deputy
~*We*R*JustiCe*		61030391618		BeBoo			HonorDeputy
.:!All-$tars!:.		57994688979		elzaem			Leader
.:!All-$tars!:.		57994688979		H.....A...AHMED		Deputy
.:!All-$tars!:.		57994688979		***JM***		Deputy
.:!All-$tars!:.		57994688979		mtirx			Deputy
.:!All-$tars!:.		57994688979		necroshear		Deputy
.:!All-$tars!:.		57994688979		spiderman2008		HonorDeputy
.:!All-$tars!:.		57994688979		Motherm			HonorDeputy
The_Masters		48282611125		asklepius		Leader
The_Masters		48282611125		MEGUMI			Deputy
The_Masters		48282611125		kate.			Deputy
The_Masters		48282611125		Kushumai		Deputy
The_Masters		48282611125		#24marley#24		Deputy
The_Masters		48282611125		l_Un4GiveN_l		HonorDeputy
The_Masters		48282611125		ZARATOR			HonorDeputy
HeartlessAngels		45567097486		Tsubasa.		Leader
HeartlessAngels		45567097486		~Fire*Man~		Deputy
HeartlessAngels		45567097486		RavensAngel		Deputy
HeartlessAngels		45567097486		~DeaTh~ScorpIon		Deputy
HeartlessAngels		45567097486		#90Andy#90		HonorDeputy
The|Al|Che|Mist		45338446403		IchigoBL		Leader
The|Al|Che|Mist		45338446403		SARAY_SOYOP		Deputy
The|Al|Che|Mist		45338446403		3565413.1897		Deputy
The|Al|Che|Mist		45338446403		cristina		HonorDeputy
JuSt`CaVaLLi		44472622720		~NOVA~			Leader
JuSt`CaVaLLi		44472622720		NightWalKer		Deputy
JuSt`CaVaLLi		44472622720		neoplanet		Deputy
JuSt`CaVaLLi		44472622720		Sat-Thu			Deputy	
JuSt`CaVaLLi		44472622720		JuSt`CaVaLLi		Deputy
JuSt`CaVaLLi		44472622720		zhai			HonorDeputy
Dark*Empire		43977705029		masterlink		Leader
Dark*Empire		43977705029		daRk^KiNgpLar		Deputy
Dark*Empire		43977705029		hazzer			Deputy
Dark*Empire		43977705029		Pro_Mage		Deputy
Dark*Empire		43977705029		NarutoOFTheLeaf		Deputy
Dark*Empire		43977705029		Hell_Enma#71		HonorDeputy
Dark*Empire		43977705029		WarStar			HonorDeputy
AtrumDeus		42621409603		Cagney			Leader
AtrumDeus		42621409603		Br0KeN~HeArT		Deputy
AtrumDeus		42621409603		JechT			Deputy
AtrumDeus		42621409603		.:NeutraL:.		Deputy
AtrumDeus		42621409603		jay			Deputy
AtrumDeus		42621409603		memaloca		HonorDeputy
AtrumDeus		42621409603		.Gunner.		HonorDeputy
Smith|Warrior		41006617958		Secret_Love		Leader
Smith|Warrior		41006617958		*°::.Lobão.::°*		Deputy
Smith|Warrior		41006617958		sakura			Deputy
Smith|Warrior		41006617958		lucifer_S2		Deputy
Smith|Warrior		41006617958		Duplex_s2		HonorDeputy
Smith|Warrior		41006617958		Witch<OF>Hill		HonorDeputy
~.:Steels:.~		39840251839		Jensen94		Leader
~.:Steels:.~		39840251839		aaron99			Deputy
~.:Steels:.~		39840251839		Mcoy2x			Deputy
~.:Steels:.~		39840251839		SAIFE			HonorDeputy
UnholY__KnightS		36960822825		.:|_Mordrid_|:.		Leader
UnholY__KnightS		36960822825		~MERLIN~		Deputy
UnholY__KnightS		36960822825		~Joan*Of*Arc~		Deputy
UnholY__KnightS		36960822825		Tapitsgabs		Deputy
UnholY__KnightS		36960822825		tapit_420		HonorDeputy
Rebles_Of_Love~		36292197935		hoop			Leader
Rebles_Of_Love~		36292197935		hellboy			Deputy
Rebles_Of_Love~		36292197935		Banana			Deputy
Rebles_Of_Love~		36292197935		N0T~CHiiLDiiSH		Deputy
Rebles_Of_Love~		36292197935		-SeRiNiTy-		HonorDeputy
Rebles_Of_Love~		36292197935		hellrazor		HonorDeputy
~*SuPeRnOvA*~		34691175287		)~(FLaRe)~(		Leader
~*SuPeRnOvA*~		34691175287		Justinbebustin		Deputy
~*SuPeRnOvA*~		34691175287		~~Cloud~~		Deputy
~*SuPeRnOvA*~		34691175287		~*Rogeris*~		Deputy
~*SuPeRnOvA*~		34691175287		-|chio_ram|-		Deputy
~*SuPeRnOvA*~		34691175287		-|ScottBakula|-		HonorDeputy
Alchemist		33441116016		sweethoney		Leader
Alchemist		33441116016		Brandivio		Deputy
Alchemist		33441116016		King_Dragon		Deputy
Alchemist		33441116016		TyrionLannister		Deputy
Alchemist		33441116016		Mr.Andrew		HonorDeputy
Nicafe_Idiots!		31555358530		gago_ka?		Leader
^-^SpartanI^-^		30087091970		*Dany*SMK*		Leader
^-^SpartanI^-^		30087091970		~Dan~			Deputy
Ar|a_51			29098259413		D3athKn|ght		Leader
Ar|a_51			29098259413		Plagu3			Deputy
Ar|a_51			29098259413		killer_girl		Deputy
Ar|a_51			29098259413		DangeR			Deputy
10/14/2008 01:01 PowerChaos#11
wow , Thank you :)

i sure will try it out :)

-------
i tryed it out and i get this small error :S

[Only registered and activated users can see links. Click Here To Register...]

it shows Resource id #4
this is the code how i inplented them
[Only registered and activated users can see links. Click Here To Register...] in case it can help
Code:
Rank Player Name Level Profession EPs Money Saved Legion
 
1 DragonTear 101 mage 1430 79500000 Resource id #4 
2 |haticzzz| 86 mage 1197 2071116 Resource id #4 
3 HolySacrifice 50 warrior 1188 0 Resource id #4 
4 PowerChaos[PM] 80 Paladin 970 270000 Resource id #4 
5 Avantage 66 mage 762 0 Resource id #4 
6 ~DaRK*MaGiCaN~ 46 mage 570 0 Resource id #4 
7 Shu 9 warrior 536 0 Resource id #4 
8 chibiidude 82 warrior 284 5000000 Resource id #4 
9 GoLDKnighT 5 warrior 270 0 Resource id #4 
10 Iceheart 49 mage 270 3750000 Resource id #4 
11 slayernr1 84 warrior 138 19305315 Resource id #4 
12 krigel 79 Paladin 93 400000 Resource id #4 
13 SpankThat 35 warrior 38 0 Resource id #4 
14 NightGirL 45 warrior 28 0 Resource id #4 
15 IIxSLAYERxII 33 warrior 24 0 Resource id #4 
16 Ma-jutsu 36 warrior 17 0 Resource id #4 
17 LuLu 50 warrior 16 0 Resource id #4 
18 ifuckyouall 86 warrior 15 0 Resource id #4 
19 TrashMan 65 warrior 15 300000 Resource id #4 
20 SoulReaper 40 mage 9 0 Resource id #4 
21 ThunderDragon 70 mage 8 0 Resource id #4 
22 XxTopsyKrettxX 29 warrior 6 0 Resource id #4 
23 Darksoul 92 mage 5 3000000 Resource id #4 
24 ~Utah~ 66 mage 4 2032701 Resource id #4 
25 Ieyasu 60 warrior 3 1371412 Resource id #4 
26 PlayBoy_x3 55 warrior 2 0 Resource id #4 
27 iZabuza 84 warrior 0 0 Resource id #4 
28 Tom 85 warrior 0 14769000 Resource id #4 
29 ThunderTimo 70 mage 0 0 Resource id #4 
30 Tobbeliten 70 mage 0 0 Resource id #4 
31 Xtremejumper 84 warrior 0 1550000 Resource id #4 
32 dfrgdsfdfg 1 warrior 0 0 Resource id #4 
33 Ogrr 10 mage 0 0 Resource id #4 
34 Neos 39 warrior 0 0 Resource id #4 
35 Meteru 14 warrior 0 0 Resource id #4 
36 [PM] 255 warrior 0 0 Resource id #4 
37 Lovely 21 warrior 0 0 Resource id #4 
38 Xtreme 1 mage 0 0 Resource id #4 
39 G-star 73 warrior 0 0 Resource id #4 
40 Nuupcake 59 mage 0 0 Resource id #4 
41 davidut 2 mage 0 0 Resource id #4 
42 Star-Lite 8 warrior 0 0 Resource id #4 
43 *Thalia* 70 mage 0 3080000 Resource id #4 
44 Angel 6 warrior 0 0 Resource id #4 
45 JeSy 7 mage 0 0 Resource id #4 
46 Lu 2 mage 0 0 Resource id #4 
47 Jess 2 mage 0 0 Resource id #4 
48 Germany+dream 3 mage 0 0 Resource id #4 
49 Darkness 1 warrior 0 0 Resource id #4 
50 Wat3v4 6 mage 0 0 Resource id #4 
51 *J*A*C*K* 2 warrior 0 0 Resource id #4 
52 Necroblade 7 warrior 0 0 Resource id #4 
53 Necrofire 1 mage 0 0 Resource id #4 
54 innaus 2 warrior 0 0 Resource id #4 
55 Blaken 1 mage 0 0 Resource id #4 
56 [BANNED] 80 mage 0 0 Resource id #4 
57 Soul_Crazy 1 warrior 0 0 Resource id #4 
58 zeph 8 mage 0 0 Resource id #4 
59 hentas 3 warrior 0 0 Resource id #4 
60 Optimus 2 warrior 0 0 Resource id #4 
61 Blood_Doll 14 warrior 0 0 Resource id #4 
62 IIxLEONARDOxII 33 mage 0 0 Resource id #4 
63 haha 1 mage 0 0 Resource id #4 
64 RyanSheckler69 2 mage 0 0 Resource id #4 
65 Rowhenna 1 warrior 0 0 Resource id #4 
66 DarKAnGeL 2 warrior 0 0 Resource id #4 
67 Scarlet 5 warrior 0 0 Resource id #4 
68 Konan 2 warrior 0 0 Resource id #4 
69 KingOf#59Hearts 1 warrior 0 0 Resource id #4 
70 SomeGuy 1 warrior 0 0 Resource id #4
sorry for all the trouble , but i aint good at coding stuff :S (scripting)

Greets From The Crasher
10/14/2008 02:28 funhacker#12
now I see what you need use this as your ONLY query

Code:
SELECT
cq_user.name,
cq_user.level,
cq_user.profession,
cq_user.emoney,
cq_user.money_saved,
cq_syndicate.NAME,
cq_syndicate.money,
legion_rank_name.rank_name
FROM
cq_syndicate ,
cq_user ,
cq_synattr
Inner Join legion_rank_name ON cq_synattr.rank = legion_rank_name.rank_number
WHERE 
cq_syndicate.id =  cq_synattr.syn_id 
AND 
cq_synattr.id =  cq_user.id
ORDER BY
cq_user.emoney DESC
LIMIT 100



and here is the edited PHP

Code:
<body bgcolor="#202020">

 

<div align="center">

 

<font color="#202020">

<?php             

 

    $myhost="xxx";

    $mypass="xxx";

    $myuser="xxx";

    $mydb="xxx";

    mysql_connect($myhost,$myuser,$mypass);

    mysql_select_db($mydb);?></strong></font><b><font color="#FFFFFF" face="Andreas Pen MF" size="4"><marquee width="433" behavior="alternate">EPs Top 100 </marquee></font></b></p>

<p align="center">

 

                          <table width="50%" height="25" border="1" bgcolor="#800000" bordercolor="#FF00FF">

                            <tr>

                              <td width="57" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <p align="center">

                                                                <strong style="font-weight: 400">Rank</strong></font></td>

                              <td width="129" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">Player Name</strong></font></p></td>

                              <td width="57" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <p align="center">

                                                                <strong style="font-weight: 400">Level</strong></font></td>

                              <td width="108" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <p style="padding-left: 11px;" align="center">

                                                                <strong style="font-weight: 400">Profession</strong></span></font></td> 

                              <td width="108" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">EPs</strong></font></td>

                              <td width="114" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">Money Saved</strong></font></td>

<td width="114" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">Legion</strong></font></td> 


<td width="114" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">Legion Gold</strong></font></td> 


<td width="114" bgcolor="#FF0000" bordercolor="#FF00FF">

                                                                <p align="center">

                                                                <font color="#FFFFFF" face="Aniron" size="1">

                                                                <strong style="font-weight: 400">Legion Rank</strong></font></td> 


</tr>

 

                              <?php     

 

    $rank = mysql_query("SELECT cq_user.name,cq_user.level,cq_user.profession,cq_user.emoney,cq_user.money_saved,cq_syndicate.NAME, cq_syndicate.money, legion_rank_name.rank_name FROM cq_syndicate ,cq_user ,cq_synattr Inner Join legion_rank_name ON cq_synattr.rank = legion_rank_name.rank_number WHERE cq_syndicate.id =  cq_synattr.syn_id AND cq_synattr.id =  cq_user.id ORDER BY cq_user.emoney DESC LIMIT 100");

 

//$row = mysql_fetch_array($rank);

    $i=1;


 while($row = mysql_fetch_array($rank))

{

        if($row['cq_user.profession']==20)

 {

        $profession='Warrior';

 }

        else if($row['cq_user.profession']==30)

  {

        $profession='Paladin';

  }

        else{$profession='Mage';

 

}

        echo '

    <td><font color="#FFFFFF"><div align="center">'.$i.'</td>

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_user.NAME'].'</td>

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_user.level'].'</td>

    <td><font color="#FFFFFF"><div align="center">'.$profession.'</td>

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_user.emoney'].'</td>

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_user.money_saved'].'</td>

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_syndicate.name'].'</td> 

    <td><font color="#FFFFFF"><div align="center">'.$row['cq_syndicate.money'].'</td> 

    <td><font color="#FFFFFF"><div align="center">'.$row['legion_rank_name.rank_name'].'</td>

  </tr> ';

  $i=$i+1;

    }

 

?>

</div>
note I have NEVER edited or did any PHP so it might screw up but I doubt it will I followed the general rules
10/14/2008 15:16 PowerChaos#13
Thank you added :)

Thank you for trying to help me

it now looks strange :S
i know to less from php and mysql to find the error

the strange thing is that it works (so there isnt a error) but it doesnt show everything that is needed

it show now
rank 1 ........ mage
rank 100 ........ mage
and all the other are emty spaces :s
[Only registered and activated users can see links. Click Here To Register...]

i still want to thank you for helping me and to be honnest , i dont get it why it doesnt works :S , it doesnt give errors so it loads from the db (otherwhise is it a mysql fetch error if i iam right :S )

still ,Thanky you for helping and Greets From The Crasher
10/14/2008 17:36 PowerChaos#14
i got it to work now :)

Thank you , i founded the small bug you got and that was preventing it to work

instead that you need to use
Code:
ORDER BY cq_user.emoney
$row['cq_user.name']
do you need to use
Code:
ORDER BY emoney
$row['name']
and then it shows it what it need to do :)

Thank you :)

now i got a small request if posseble

if there are members that arent in a legion , then it need to show 'no legion'
otherhwise it just show only the members that got a legion :)

but so far , Thank you for Fixing this problem :)
10/14/2008 18:18 funhacker#15
Glad I could help I am not entirely sure on how to put that out there, best guess would be to include another colum but dont display it, cq_user.syndicate_id say
Code:
if $row['syndicate_id'] == 0
{
$legion_name = 'No Legion'
$legion_rank = 'No rank'
}
else 
{
$legion_name = $row['cq_syndicate.name']
$legion_rank = $row['rank_name']
}
Page 1 of 2 1 2