WC - Avatar Shop Trade Fix

[Leo The Fox]

Most WC servers disable trading because of "NetWork Error". The fix is stupid-simple. Just simply create a script and run the following query every second (cron job, probably):

UPDATE `GiftMsg` SET `No`=`GiftItemNo`

That's literally it. As long as you run this query every second, you're set. There's probably a way to fix this with hex editing the server files, but this at least keeps them a bit more vanilla.

PS: this is a crappy way to fix it, but it fixes it nonetheless. Feel free to find your own workaround.

Cheers.

 

[garsia]

Most WC servers disable trading because of "NetWork Error". The fix is stupid-simple. Just simply create a script and run the following query every second (cron job, probably):

UPDATE `GiftMsg` SET `No`=`GiftItemNo`

That's literally it. As long as you run this query every second, you're set. There's probably a way to fix this with hex editing the server files, but this at least keeps them a bit more vanilla.

more easy create a mysql tiggert on insert make same querry

 

[Leo The Fox]

Most WC servers disable trading because of "NetWork Error". The fix is stupid-simple. Just simply create a script and run the following query every second (cron job, probably):

UPDATE `GiftMsg` SET `No`=`GiftItemNo`

That's literally it. As long as you run this query every second, you're set. There's probably a way to fix this with hex editing the server files, but this at least keeps them a bit more vanilla.

more easy create a mysql tiggert on insert make same querry

This would be the answer except I believe triggers were introduced after OLD_PASSWORD was depreciated/removed, which means unless you’re running a passwordless db (don’t), don’t think this is possible.

 

[garsia]

tiggert add on mysql 5.6 pre4.1 auth is deprecated on 5.7.5

 

[Leo The Fox]

tiggert add on mysql 5.6 pre4.1 auth is deprecated on 5.7.5

Interesting, a very small window of opportunity that I wasn't aware of. Good to know.