-
Posts
227 -
Joined
-
Last visited
-
Days Won
5 -
Feedback
0%
Community Answers
-
Endymion's post in Query problem / WHERE conditions was marked as the answer
SELECT l.id AS id, l.login_time AS login, l.logout_time AS logout, p.name AS name
FROM log.loginlog2 AS l
LEFT JOIN player.player AS p ON (p.id = l.pid)
WHERE DATE_SUB(NOW(), INTERVAL 14 DAY) < l.logout_time
AND l.is_gm = 'Y'
ORDER BY l.id DESC;
-
Endymion's post in battle.cpp argument problem was marked as the answer
SELECT item_proto.vnum, item_proto.locale_name,item_proto.value1,item_proto.value2,item_proto.value3,item_proto.value4,item_proto.value5 FROM player.item_proto WHERE (item_proto.value1+item_proto.value5) > (item_proto.value2+item_proto.value5) OR (item_proto.value3+item_proto.value5) > (item_proto.value4+item_proto.value5); ?
Check if any weapon don't have min dmg bigger than max dmg.