Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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!
jakie zapytanie wysłać, aby:
graczom którzy nie mają itemu id=2649 dac go w miejsce legow, a tym ktorzy maja nie dawac??
pid = 7, sid = 107, itemtype= 2649
Nie jestem pewien, ale to powinno updatnac legi jesli nie ma sie 2649 na ich miejscu:
Code:
UPDATE `player_items` SET `itemtype` = 2649 WHERE `pid` = 7 AND `sid` = 107 AND `player_id` NOT IN (SELECT `player_id` FROM `player_items` WHERE `itemtype` = 2649);
UPDATE `player_items` SET `itemtype` = 2649 WHERE `pid` = 7 AND `sid` = 107 AND `player_id` NOT IN (SELECT `player_id` FROM (SELECT `player_id`, `itemtype` FROM `player_items`) AS `nt` WHERE `itemtype` = '2649')