Landing page Top 10 richest users

[mitchellrjc]

Hey Guys,

Yet another question.

My landing page shows Top 10 richest users. But I want to put the Online staff (if not possible all staff) in this place.

Not sure which emu base this emu is build on (Plus or Uber)

See it for yourself here

Someone knows how to do this?

You must be registered for see images attach

 

[Johno]

Sorry, just clarifying, you want staff to be included in this ?

 

[JayC]

Sorry, just clarifying, you want staff to be included in this ?

No he wants to remove this and put online staff instead

 

[mitchellrjc]

Sorry, just clarifying, you want staff to be included in this ?

No he wants to remove this and put online staff instead

Yes as Jay says.

 

[Johno]

Edit the query that is pulling the richest to something such as

SELECT * FROM users WHERE rank = >(lowest staff rank you wish to display) AND online = 1

something a little like that may need tweaking depending on your CMS / setup

 

[JayC]

Edit the query that is pulling the richest to something such as

SELECT * FROM users WHERE rank = >(lowest staff rank you wish to display) AND online = 1

something a little like that may need tweaking depending on your CMS / setup

Where is that query located? This is on the client?

 

[Johno]

I do am not active in retros anymore, if you can tell me the version of the CMS that is been used I will download a copy and look over the code to find out and post what needs to be changed, I was simply providing a pointer in my last reply

 

[Chuckie_]

For Arcturus based emulators, iirc it's located in the emulator_settings. Might be the same for Plus.

 

[JayC]

I do am not active in retros anymore, if you can tell me the version of the CMS that is been used I will download a copy and look over the code to find out and post what needs to be changed, I was simply providing a pointer in my last reply

Has nothing to do with the cms

 

[Pinkman]

This has nothing to do with CMS. It’s all coded inside the emulator. And as Johno said, identify the query running and change it to “SELECT * from ‘users’ WHERE ‘online’ == ‘1’ AND ‘rank’ => 3” If you want send me a message with a zip of your emulator and I’ll happily do it for you.

 

[mitchellrjc]

This has nothing to do with CMS. It’s all coded inside the emulator. And as Johno said, identify the query running and change it to “SELECT * from ‘users’ WHERE ‘online’ == ‘1’ AND ‘rank’ => 3” If you want send me a message with a zip of your emulator and I’ll happily do it for you.

It's not that I cannot do it myself, but hard to find it xD maybe someone here knew where to edit this piece But i'll search for it than

Post automatically merged: Aug 26, 2019

Apparantly this is the GetHallOfFame.cs file. Found that, but my staff query doesn't seem to work.

SELECT * FROM users WHERE rank = > 4 AND online = 1

 

[Silenos]

SELECT * FROM users WHERE rank >= 4 AND online = 1
Would also recommend to name the wanted columns explicitly.

 

[Joe]

It's not that I cannot do it myself, but hard to find it xD maybe someone here knew where to edit this piece But i'll search for it than

Post automatically merged: Aug 26, 2019

Apparantly this is the GetHallOfFame.cs file. Found that, but my staff query doesn't seem to work.

SELECT * FROM users WHERE rank = > 4 AND online = 1

Post the GetHallOfFame.cs

 

[Pinkman]

SELECT * FROM users WHERE rank >= 4 AND online = 1
Would also recommend to name the wanted columns explicitly.

Actually it’s,

SELECT * FROM ‘users’ WHERE ‘rank’ >= ‘4’ AND ‘online’ = ‘1’

Post automatically merged: Aug 26, 2019

Actually it’s,

SELECT * FROM ‘users’ WHERE ‘rank’ >= ‘4’ AND ‘online’ = ‘1’

On top of that note it also depends on your Navicat version. That is if you use navicat.

 

[Silenos]

Backticks ` are used to indicate database, table, and column names. Unless you're using reserved or conflicting words for table and database names, you'll not need to use them..
That means your post was totally unnecessary. (Not being offensive, just saying)