I want to count all points from table character_raid_points for same charId
Example: I have 100 records for charID: 11111 and in every records has different int points for kill RB.
So I need to COUNT all RBs points per charId
"SELECT characters.char_name,character_raid_points.charId, character_raid_points.points FROM character_raid_points, characters WHERE character_raid_points.points AND characters.charId = character_raid_points.charId ORDER BY points DESC LIMIT 10;"
This command now generate CharId and points pet one row ( i mean per one kill RB ) - so Need to count all to one INT
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
I apologize for my incompetence. The ability to trade is limited only for builder 1. Ordinary characters can trade with each other, and this has nothing to do with auto loot.)
Question
alexas545
Hi,
I want to count all points from table character_raid_points for same charId
Example: I have 100 records for charID: 11111 and in every records has different int points for kill RB.
So I need to COUNT all RBs points per charId
"SELECT characters.char_name,character_raid_points.charId, character_raid_points.points FROM character_raid_points, characters WHERE character_raid_points.points AND characters.charId = character_raid_points.charId ORDER BY points DESC LIMIT 10;"
This command now generate CharId and points pet one row ( i mean per one kill RB ) - so Need to count all to one INT
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.