[Help] WILLING TO PAY 20$ FOR FIX!

[RetroAddict]

[HELP] Group Sorting based on User ID (NOT DATE)

I'm stuck with something for like a couple days and I'm using Comet Emulator.
Everything works fine besides the Group Sorting and I figured out like
if User A registered first at the hotel he will be on top of the group members list
and if User B registered on the hotel after User A he will get always sorted under User A
I want it to sort based on Date!

THIS IS THE CODE I FOUND ABOUT THE SORT FUNCTION:

You must be registered for see images attach

How it looks :

You must be registered for see images attach

If anybody knows how to fix tell me!

 

[Silenos]

Hello my dear friends,
this person will waste your time.

See here:

You must be registered for see links

and a screenshot of our previous conversation here:

You must be registered for see links

.
He also said he had fixed many bugs himself and extended/improved Comet a lot - but he was not able to sort this out since 4 days.
Can you imagine? Being hardstuck 4 days for this

If your database query doesn't include a particular order and you also don't sort the List, the data will have the same order as it is in the table - very simple logic.
Edit: Since you wanna sort objects, you should actually know the interfaces Comparable and Comparator, or? (I do, as a person who never uses Java for his own projects)

 

[RetroAddict]

I'm stuck with something for like a couple days and I'm using Comet Emulator.
Everything works fine besides the Group Sorting and I figured out like
if User A registered first at the hotel he will be on top of the group members list
and if User B registered on the hotel after User A he will get always sorted under User A



If anybody in which file or what this is called please tell me!

Hello my dear friends,
this person will waste your time.

See here:

You must be registered for see links

and a screenshot of our previous conversation here:

You must be registered for see links

.
He also said he had fixed many bugs himself and extended/improved Comet a lot - but he was not able to sort this out since 4 days.
Can you imagine? Being hardstuck 4 days for this

If your database query doesn't include a particular order and you also don't sort the List, the data will have the same order as it is in the table - very simple logic.
Edit: Since you wanna sort objects, you should actually know the interfaces Comparable and Comparator, or? (I do, as a person who never uses Java for his own projects)

U really think im that big of a retard i already sorted it in the db

Post automatically merged: Dec 24, 2019

U really think im that big of a retard i already sorted it in the db

SELECT * FROM group_memberships WHERE group_id = ? ORDER BY access_level, date_joined

 

[Hypothesis]

In this query:

SELECT * FROM group_memberships WHERE group_id = ? ORDER BY access_level, date_joined

Why is it collecting from "WHERE group_id = ?," shouldn't it be using a variable, not a ? symbol.

Sorry don't quote me if that's supposed to be like that, I don't know Java.

 

[Pollak]

In this query:

SELECT * FROM group_memberships WHERE group_id = ? ORDER BY access_level, date_joined

Why is it collecting from "WHERE group_id = ?," shouldn't it be using a variable, not a ? symbol.

Sorry don't quote me if that's supposed to be like that, I don't know Java.

You can use ? for define after something. I never used but exists.

 

[olliedean]

In this query:

SELECT * FROM group_memberships WHERE group_id = ? ORDER BY access_level, date_joined

Why is it collecting from "WHERE group_id = ?," shouldn't it be using a variable, not a ? symbol.

Sorry don't quote me if that's supposed to be like that, I don't know Java.

I imagine using question marks is to bind params in the query, preventing SQL injection, like in PHP.