Hall Of Fame / Flux CP

[animous]

i want to know how can i make this work and if u guys could help me

the guild ranking is working fine but the pvp ranking not... any help <3?

-----------------------------------------------------------------------------------------------------------------------------

PROBLEM FIXED~...

i did it by myself so i wont give any credits ^^ thanks...

Edited January 28, 2013 by animous

[ReSp]

what sql command is for creating correct table pvpladder is?

for that top fluxcp:

 $sqlpvp  = "SELECT pvpladder.name AS char_name, pvpladder.kills AS kills, pvpladder.deaths AS deaths, char.char_id, char.class AS bclass, login.sex, guild.name as gname 
                    FROM pvpladder
                    LEFT JOIN  `char` ON pvpladder.char_id = char.char_id
                    LEFT JOIN  `login` ON char.account_id = login.account_id
                    LEFT JOIN  `guild` ON char.guild_id = guild.guild_id
                    ORDER BY kills DESC 
                    LIMIT 1";

[technoriot01]

have this problem too. hope someone can help us both.

[animous]

i think nobody will answer us xD!~ damn.. theres not a WebDeveloper here?

[Nana]

You really have that tables? o.o? (table: pvpladder )

schema (vpladder.name, pvpladder.kills, pvpladder.deaths, char.char_id, char.class , login.sex, guild.name)

Something you can do is try your sql query in a database manager (like navicat or heidi) and see where is your problem

[animous]

no i dont , thats why im looking for help :/

[Nana]

Hmm open a db manager, create the table pvpladder

THen inside the db schema create each field ._. and tahts all,

Remember that you have to get from the game that values, so maybe you need to make a src mod or a good script for that n_n ~

[animous]

please somebody close it i make this Work Fine now .. thanks you for the "support"..

@Aisha Thank you so much for tips ... <3

Edited January 26, 2013 by animous