Anti Gold Dupe

[dethunter12]

2 hours ago, Scura said:




Nice! I wanna point out just a simple consideration:



Remember that you can directly create a table with a select, wich means you don't have to perform 2 different mysql commands:


CREATE TABLE IF NOT EXISTS `t_gold_results` AS (
SELECT x, y
FROM k
LEFT JOIN ...);


In this case you can call it as (where MaxGold is an sql variable or bash var):


CREATE TABLE IF NOT EXISTS `t_gold_results` AS (
SELECT

a_user_index,
a_nick,
a_nas,
'Character' AS a_gold_type

FROM t_characters


WHERE a_nas > $MaxGold


UNION


SELECT

t_stash_money.a_user_index,
t_characters.a_nick,
t_stash_money.a_stash_money,
'Stash' AS a_gold_type

FROM t_stash_money

INNER JOIN t_characters
ON t_characters.a_user_index = t_stash_money.a_user_index

WHERE t_stash_money.a_stash_money > $MaxGold;
)


 i wasn't aware thank you.