Anti Gold Dupe
#6
#!/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.



Messages In This Thread
[No subject] - by Stormax - 01-21-2023, 10:24 AM
[No subject] - by Veni - 01-21-2023, 11:41 AM
[No subject] - by Stormax - 01-21-2023, 01:27 PM
[No subject] - by rondo157 - 01-21-2023, 02:34 PM
[No subject] - by Desarija - 01-23-2023, 11:51 AM
[No subject] - by dethunter12 - 02-10-2024, 09:12 PM
[No subject] - by Scura - 02-18-2024, 09:46 AM
[No subject] - by dethunter12 - 02-18-2024, 05:08 PM
[No subject] - by dethunter12 - 02-18-2024, 05:50 PM
[No subject] - by Scura - 03-01-2024, 04:53 PM
[No subject] - by dethunter12 - 03-01-2024, 07:39 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)