Winterfox

@@Stein When you use a portal or when you use @go/@warp or when you get warped by a npc? Is it on every map or just on specific maps? Did you hex edit your client?

@@Ranz If you are sure you configured your MySQL properly to accept remote connections and you can connect to it from another pc, but not your host, you should ask your hosting provider to change it for you in case you can't change this setting yourself.

What is the mapflag good for if it uses a global command? If i understand it right, the mapflags are made especially to apply only to one map. I thought maybe the map zone can fine grain it better in some way that it really only applies to the maps that belong to that zone.

@@Aeromesi Not sure if you still need that but maybe you could try to create a map zone that applies the night enabled map flag.

@@keough Basically you just can look at your current config and add 1x to it.

@@Stein http://herc.ws/board/files/file/182-old-prontera/

Because there are still duplicates that reference the original NPC.

- script testnpc 123,{ OnWhisperGlobal: setarray .test[0],1,12,123; callfunc "abc"; end;}function script abc { copyarray .@test, getvariableofnpc(.test,"testnpc"), getarraysize( getvariableofnpc(.test,"testnpc") ); return;}

@@Lord Ganja Usually return 0 and return false, mean the same. The same is true for return 1 and return true. Every other return value is usually either data or some kind of success/error code.

@@Sharpienero That is a problem with any scripted solution that requires the user to input anything. It is either too intruding so regular players will be pissed off or it can be bypassed easily. I think in generall you are better ocf with encrypting the traffic and scanning the server logs for weird behaviour of players. If you configured openkore to teleport for example it is quiet likely that it tries to teleport even you run out of items and fails a lot in a matter of seconds or if someone allways teleports right before he dies, those are strong indicators that some things are not right with that person.

If you have nothing usefull to say, you should say nothing at all.

@@zhaosin I would go for hashield.

@@Noil It is still overkill for a default server of 200-1k of users, especially since there are tons of asian servers. And a load balancer won't help you when the servers are all in one location.

@@Noil I think if you don't have a really big server with 20000+ international requests per day and active userbase to go with it, a CDN isn't really worth it since the savings mostly come from splitting the traffic and less because the locations are nearer to your user, except when you want to deliver content to Asia for example. Also i am not even sure if it has use for other things besides websites if your server wasn't reprogrammed to support to have itself spread over multiple servers that work with one database. It is probably overkill and for the traffic i think it won't be that much depending on how load heavy your website is and how big and frequent your patches are and how you distribute your client. If you really want to go for a CDN you should check yourself how much traffic your server generates before deciding. Since it is such a relative thing from server to server that depends on many factors.

- script HappyHourDrops -1,{ OnMon1500: OnMon1600: OnMon2000: OnMon2200: OnTue1500: OnTue1600: OnTue2000: OnTue2200: OnWed1500: OnWed1600: OnWed2000: OnWed2200: OnThu1500: OnThu1600: OnThu2000: OnThu2200: OnInit: if ( gettime( 4 ) == 0 || gettime( 4 ) > 4 ) { setbattleflag "item_rate_common", 3000; setbattleflag "item_rate_heal", 3000; setbattleflag "item_rate_use", 3000; setbattleflag "item_rate_equip", 3000; atcommand "@reloadmobdb"; announce "The Happy Hour Drop Rate has ended!", bc_all; } else if ( ( gettime( 3 ) >= 15 && gettime( 3 ) < 16 ) || ( gettime( 3 ) >= 20 && gettime( 3 ) < 22 ) ) { setbattleflag "item_rate_common", 4000; setbattleflag "item_rate_heal", 4000; setbattleflag "item_rate_use", 4000; setbattleflag "item_rate_equip", 4000; atcommand "@reloadmobdb"; announce "The Happy Hour Drop Rate has started!", bc_all; } end;}

This query return anything only if item present in all this tables Yeah right. Thought the thing was to combine them based on if the user has the same stuff in his storage stuff. SET @nameid = 2629;SELECT * FROM inventory, cart_inventory, `storage`, guild_storageWHERE inventory.nameid = @nameidOR cart_inventory.nameid = @nameidOR`storage`.nameid = @nameidOR guild_storage.nameid = @nameidGROUP BY inventory.nameid

You only need those ticks if you use reserved words and only for them. If you use the char table or row for example which is a reserved word because of the char datatype that is used in the sql syntax when creating a new table. In this case it is storage that is a reserved word. A full list can be found here: https://dev.mysql.com/doc/refman/5.5/en/keywords.html SET @nameid = 2629;SELECT * FROM inventory, cart_inventory, `storage`, guild_storageWHERE inventory.nameid = @nameidOR cart_inventory.nameid = @nameidOR`storage`.nameid = @nameidOR guild_storage.nameid = @nameidGROUP BY inventory.nameid

@@tmav94 What is the question or problem you need support with?

Shouldn't be a problem if you have the soundeffects you want in .wav format.

@@Lord Ganja I know, i once wanted to do the same thing, but sadly it is not possible. Atleast not until someone makes a plugin or source mod for it.

@@Lord Ganja Only if you create copies of them that have 200% HP and spawn them on abbey02 instead of the original ones. Sadly you can't set monster attributes dynamically.

@@aznguy212 That seems to be a bug, according to the documentation it only should change the sprite. It explicitly states that nothing except the sprite ist changed.

I think holding the state if happy hour is enabled or not shouldn't be handled by a temporary character variable. I would go for a on and off command build instead of a toggle. But it doesn't really do what was requested anyway. - script bghappy_1 -1,{ OnInit: bindatcmd "bghappy", strnpcinfo( 3 ) + "::OnBGHappyhour", 40, 99; end; OnBGHappyhour: .@rate = atoi( .@atcmd_parameters$[ 0 ] ); setbattleflag "bg_reward_rates", 100 + .@rate; if( .@rate ) { .@ranked = 1; dispbottom "Battlegrounds Happyhour +" + .@rate + "% mode is ON."; } else { .@ranked = 0; dispbottom "Battlegrounds Happyhour mode is OFF."; } setbattleflag "bg_ranked_mode", .@ranked; end;}

@ What does it say? It sounds like it doesn't have the permissions to write to the output directory for the server executables.

@@Angelmelody That is correct, you need to use it with caution and this approach only is really usefull if you have to call that comparison a lot and / or the array is really big. Otherwise i think the performance benefit is really low.