PHP script for guild in top pvp

[agoenk]

How to show guild in php script top pvp? Because I try to add with id from tbl_Guild, all players show 1 same guild and double player name. Please clue for queries.
Sorry bad my english

 

[likertuban]

i think what you need : "inner join" tbl_general guildserial column part with tbl_guild serial column
after joining, you can take the guild name from tbl_guild...

 

[agoenk]

i think what you need : "inner join" tbl_general guildserial column part with tbl_guild serial column
after joining, you can take the guild name from tbl_guild...

Thank for a clue vroh, but inner join in sql server like Trigger?

 

[dodojimbun]

Here is the sql query, i just create it

use rf_world_novus
select g.guildserial, b.accountserial, b.account, b.serial 'char serial', b.name 'char name'
from tbl_base b inner join tbl_general g
on b.serial = g.serial
where g.guildserial in (select serial from tbl_guild where id = 'guild name') and b.dck = 0

 

[agoenk]

Here is the sql query, i just create it

Nice info vroh, I will try after sahur time :w00t:

 

[agoenk]

Now how do in order to bring together the same name and change the numbers GuildSerial in tbl_general to Guild name in id tbl_Guild?

and this my query

$query ='SELECT t1.Name, t1.Class, t1.Lv, t1.Race, t1.Serial, t2.PvpPoint, t2.PvpCash, t4.id, t3.GuildSerial, t3.TotalPlayMin, t1.AccountSerial
FROM tbl_pvporderview AS t2, tbl_Guild AS t4, tbl_base AS t1 inner join tbl_general AS t3 ON t1.Serial = t3.Serial
WHERE t1.Serial = t2.Serial and DeleteName ="*"
ORDER BY t2.PvpCash DESC, t1.Lv desc';

and for Guild Coloum

if ($row[8]=="-1"){
echo '<center>-</center>';
}
if ($row[8]>="0"){
echo $row[8];
}

 

[dodojimbun]

$query ='SELECT t1.Name, t1.Class, t1.Lv, t1.Race, t1.Serial, t2.PvpPoint, t2.PvpCash, t4.id, t3.id, t3.GuildSerial, t3.TotalPlayMin, t1.AccountSerial
FROM tbl_pvporderview AS t2, tbl_Guild AS t4, tbl_base AS t1 inner join tbl_general AS t3 ON t1.Serial = t3.Serial
WHERE t1.Serial = t2.Serial and DeleteName ="*"
ORDER BY t2.PvpCash DESC, t1.Lv desc';


then row still 8

 

[agoenk]

echo $row[7];

if to change to echo $row[7] like this vroh
if ($row[7]>="1"){
echo $row[7];

or
if ($row[8]>="1"){
echo $row[7];
still same, and there is double name

 

[dodojimbun]

here is the right query

SELECT t1.Name, t1.Class, t1.Lv, t1.Race, t1.Serial, t2.PvpPoint, t2.PvpCash, t4.id, t3.GuildSerial, t3.TotalPlayMin, t1.AccountSerial
FROM tbl_pvporderview AS t2 inner join tbl_base as t1
on t2.serial = t1.serial
inner join tbl_general AS t3
ON t3.Serial = t1.Serial
inner join tbl_guild as t4
on t4.serial = t3.guildserial
WHERE t1.Serial = t2.Serial and t1.dck = 0

 

[agoenk]

here is the right query

work vroh but for a player who has no guild can't perform :w00t:

 

[dodojimbun]

-_- u say only for guild

 

[agoenk]

-_- u say only for guild

:v sorry vroh, but I want work to all included with the payer does not have a guild :junglejane:

 

[dodojimbun]

find it your self :w00t: i'm already give u 2 query that you can develop it more