Anti Gold Dupe

[Stormax]

Hello everyone,

I make a simple anti gold Dupe in .sh 

 

2

 

Have fun ? 

[Veni]

Just so everyone knows, this does NOT do anything on EP4! You can only use this for EP1/2/3 and that's it.

[Stormax]

Or edit it also. It's just a base.

But veni say right with this code it could not work on ep4.

[rondo157]

very old script, but ok. 

[Desarija]

In ep4 gold is stored in t_characters -> field a_nas and in t_stash_money, so the t_inven/t_stash stuff can be removed from the script and replaced with checks for these 2. The general logic of the script can be kept though

[dethunter12]

#!/bin/sh
#### Paramètre de connections MYSQL
sql_host="127.0.0.1"
slq_usuario="root"
sql_password=""
sql_database="newproject_db"

### Config ( Max gold - NewGold )
MaxGold="1500000000000"
NewGold="100000000000"

### Parametres de connections
sql_args="-h $sql_host -u $slq_usuario -p$sql_password -D $sql_database -s -e"

### STASH & CHARACTER QUERY
mysql $sql_args "UPDATE t_stash_money SET a_stash_money = $NewGold WHERE a_stash_money > $MaxGold;"
mysql $sql_args "UPDATE t_characters SET a_nas = $NewGold WHERE a_nas > $MaxGold;"

this code should do the job removed the unnecessary checks and modified the query change the sql host parameters it should work.

[Scura]

On 2/10/2024 at 10:12 PM, dethunter12 said:



#!/bin/sh
#### Paramètre de connections MYSQL
sql_host="127.0.0.1"
slq_usuario="root"
sql_password=""
sql_database="newproject_db"

### Config ( Max gold - NewGold )
MaxGold="1500000000000"
NewGold="100000000000"

### Parametres de connections
sql_args="-h $sql_host -u $slq_usuario -p$sql_password -D $sql_database -s -e"

### STASH & CHARACTER QUERY
mysql $sql_args "UPDATE t_stash_money SET a_stash_money = $NewGold WHERE a_stash_money > $MaxGold;"
mysql $sql_args "UPDATE t_characters SET a_nas = $NewGold WHERE a_nas > $MaxGold;"


this code should do the job removed the unnecessary checks and modified the query change the sql host parameters it should work.




So it just check all the inventory which has the max amount of of gold setted, and instead of ban him, just set it to the max value? Don't understand the utility ahahah 

 

 

(not agaist you deth, of course is not your script) 

[dethunter12]

right, i just modified the original post and added the appropriate table nothing else.

[dethunter12]

 

something like this should work

 

-----------------
--add this in _db
------------------
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_gold_results
-- ----------------------------
DROP TABLE IF EXISTS `t_gold_results`;
CREATE TABLE `t_gold_results` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_user_index` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
`a_nick` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
`a_nas` bigint(22) NULL DEFAULT NULL,
`a_gold_type` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
PRIMARY KEY (`a_index`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

#!/bin/sh
# Connection parameters for MySQL
sql_host="127.0.0.1"
slq_usuario="root"
sql_password="password"
sql_database="newproject_db"

# Config (Max gold amount)
MaxGold="21312321311"

# Connection parameters for mysql command
sql_args="-h $sql_host -u $slq_usuario -p$sql_password -D $sql_database -s -e"

# Insert into t_gold_results from t_characters
mysql $sql_args "INSERT INTO t_gold_results (a_user_index, a_nick, a_nas, a_gold_type) \
SELECT a_user_index, a_nick, a_nas, 'Character' AS a_gold_type \
FROM t_characters \
WHERE a_nas > $MaxGold;"

# Insert into t_gold_results from t_stash_money
mysql $sql_args "INSERT INTO t_gold_results (a_user_index, a_nick, a_nas, a_gold_type) \
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 \
JOIN t_characters ON t_stash_money.a_user_index = t_characters.a_user_index \
WHERE t_stash_money.a_stash_money > $MaxGold;"

# Update gold amount in t_stash_money and t_characters for records > $MaxGold
mysql $sql_args "UPDATE t_stash_money SET a_stash_money = $MaxGold WHERE a_stash_money > $MaxGold;"
mysql $sql_args "UPDATE t_characters SET a_nas = $MaxGold WHERE a_nas > $MaxGold;"

The part where you update the gold when found is not necessary up to the user if you just want to log it then you dont need to run the bottom 2 lines.



Here is example how it looks

2

[Scura]

On 2/18/2024 at 6:50 PM, dethunter12 said:




 



something like this should work

 


-----------------
--add this in _db
------------------
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_gold_results
-- ----------------------------
DROP TABLE IF EXISTS `t_gold_results`;
CREATE TABLE `t_gold_results` (
`a_index` int(11) NOT NULL AUTO_INCREMENT,
`a_user_index` varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '0',
`a_nick` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
`a_nas` bigint(22) NULL DEFAULT NULL,
`a_gold_type` varchar(30) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT '',
PRIMARY KEY (`a_index`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;

#!/bin/sh
# Connection parameters for MySQL
sql_host="127.0.0.1"
slq_usuario="root"
sql_password="password"
sql_database="newproject_db"

# Config (Max gold amount)
MaxGold="21312321311"

# Connection parameters for mysql command
sql_args="-h $sql_host -u $slq_usuario -p$sql_password -D $sql_database -s -e"

# Insert into t_gold_results from t_characters
mysql $sql_args "INSERT INTO t_gold_results (a_user_index, a_nick, a_nas, a_gold_type) \
SELECT a_user_index, a_nick, a_nas, 'Character' AS a_gold_type \
FROM t_characters \
WHERE a_nas > $MaxGold;"

# Insert into t_gold_results from t_stash_money
mysql $sql_args "INSERT INTO t_gold_results (a_user_index, a_nick, a_nas, a_gold_type) \
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 \
JOIN t_characters ON t_stash_money.a_user_index = t_characters.a_user_index \
WHERE t_stash_money.a_stash_money > $MaxGold;"

# Update gold amount in t_stash_money and t_characters for records > $MaxGold
mysql $sql_args "UPDATE t_stash_money SET a_stash_money = $MaxGold WHERE a_stash_money > $MaxGold;"
mysql $sql_args "UPDATE t_characters SET a_nas = $MaxGold WHERE a_nas > $MaxGold;"


The part where you update the gold when found is not necessary up to the user if you just want to log it then you dont need to run the bottom 2 lines.



Here is example how it looks

2




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;
)