[Mccodes V2] Top 5 Users

[SpEcKs]

does anyone know how i would put the top 5 users onto my login page like this

1. Username | Level

2. Username | Level

3. Username | Level

4. Username | Level

5. Username | Level

Here is my login if you want to edit and post back here.

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

 

IF YOU CAN DO THIS PLEASE CAN YOU PUT IT UNDER MY 'CONTACT US' PLEASE THANKS

[ddupuis]

Re: [Mccodes V2] Top 5 Users

Here ya go.. hope this helps..

I just reposted for you. I had forgot to add the level.. it's there now..

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[POG1]

Re: [Mccodes V2] Top 5 Users

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[SpEcKs]

Re: [Mccodes V2] Top 5 Users

But will that look like that in a table

1. Username | Level

2. Username | Level

3. Username | Level

4. Username | Level

5. Username | Level

And i do not want it to show NPC's

[Karlos]

Re: [Mccodes V2] Top 5 Users

Use POG's...

You'll see no NPC's amd it show's it like:

1. Username | Level

2. Username | Level

3. Username | Level

4. Username | Level

5. Username | Level

But in a table.

[SpEcKs]

Re: [Mccodes V2] Top 5 Users

POG's one doesent work

i put it under the 'contact us' and it comes up with this error:

Parse error: syntax error, unexpected T_STRING in /*******/******/**********/login.php on line 190

Any ideas

[POG1]

Re: [Mccodes V2] Top 5 Users

show us your code with a few lines before and after as well :D

[Karlos]

Re: [Mccodes V2] Top 5 Users

I guess he didn't close his print :lol:

[SpEcKs]

Re: [Mccodes V2] Top 5 Users

I have posted my login at the top please can one of you just edit it and post it back please

[POG1]

Re: [Mccodes V2] Top 5 Users

 

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

[SpEcKs]

Re: [Mccodes V2] Top 5 Users

No this one doesent work it shows the whole login normally but where the top 5 users is meant to be it says this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/specks/public_html/login.php on line 198

# Username Level

[POG1]

Re: [Mccodes V2] Top 5 Users

change this

 

$result = mysql_query("SELECT username,id,level FROM users WHERE user_level != 0 ORDER BY level ASC LIMIT 5");

with this..

$result = mysql_query("SELECT `username`,`id`,`level` FROM `users` WHERE `user_level` != 0 ORDER BY `level` ASC LIMIT 5") or die(mysql_error());

and see what it says :)

[SpEcKs]

Re: [Mccodes V2] Top 5 Users

Yeh it workd but i just need to neaten it up a bit ok m8 thanks

[ddupuis]

Re: [Mccodes V2] Top 5 Users

i am sure he could have added this

You're unable to view this code.

Viewing code within this forum requires registration, you can register here for free.

to my post. it would have removed the NPC's.. other wise it does show in the existing table.. under contact us.. was tested and works.. but anyways .. you welcome..