• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Eskuel

Status
Not open for further replies.
Sherlok

Sherlok

Active Member
Joined
Aug 29, 2008
Messages
2,116
Reaction score
44
Location
Poland, Wrocław.
Hiho.
Potrzebuję zapytanie SQL, które sprawdzi czy na postaci (na całej postaci, łącznie w backpackami itp.) jest item o danym ID i jeśli jest, doda postaci X punktów premium.

Chcę, aby zapytanie sprawdziło wszystkich playersów z bazy.

Rep++; :thumbup:
 
Last edited:
update accounts SET premium_points = premium_points + ILEDODAC WHERE id IN (select DISTINCT(player_id) from player_items where itemtype= JAKIITEMID)
Click to expand...

zmienilem na quote zeby sie zawijaly wiersze :)
 
Status
Not open for further replies.
Back
Top