Please, I wish someone could help me with the prize for this event.
Due to the event's award being in points loaded directly into the 'login' and 'guild' tables this generates a huge delay on my server.
The award works as follows:
Whoever destroys the monsters will receive 100 cashpoints and 100 wotpoints. And the rest of the clan players who manage to survive the event will receive 50 wotpoints.
And I would like to change it. But I have no idea how I do it.
Is it possible, instead of adding points, to add item? for example:
Whoever destroys the mafia will win 100 PoringCoin (7539)
And the rest of the clan that survives on the map will win 50 PoringCoin?
Script:
Spoiler
monster "prt_are_in",178,87,"Treasure chest",1324,1,strnpcinfo(0)+"::OnMobDeath";
monster "prt_are_in",126,139,"Treasure chest",1324,1,strnpcinfo(0)+"::OnMobDeath";
stopnpctimer;OnMobDeath:set.@GID,getcharid(0);set.@NAME,getcharid(2);set.@ACC,getcharid(3);
query_sql "UPDATE `char` SET `baus` = `baus` +1 WHERE `char_id`="+.@GID+"";
query_sql "UPDATE `login` SET `wotpoints` = `wotpoints` +100 WHERE `account_id`="+.@ACC+"";
announce "[Wot] The player ["+strcharinfo(0)+"] of the clan ["+getguildName(.@NAME)+"] just destroyed one of the chests!",8;
atcommand "@cash 100";set.@GUILD,getcharid(2);
query_sql "UPDATE `guild` SET `baus` = `baus` +1 WHERE `guild_id`="+.@GUILD+"";
query_sql "UPDATE `guild` SET `pontosgwot` = `pontosgwot` +50 WHERE `guild_id`="+.@GUILD+"";
end;}
Question
hardelite
Hello community friends, how are you ?a
Please, I wish someone could help me with the prize for this event.
Due to the event's award being in points loaded directly into the 'login' and 'guild' tables this generates a huge delay on my server.
The award works as follows:
Whoever destroys the monsters will receive 100 cashpoints and 100 wotpoints. And the rest of the clan players who manage to survive the event will receive 50 wotpoints.
And I would like to change it. But I have no idea how I do it.
Is it possible, instead of adding points, to add item? for example:
Whoever destroys the mafia will win 100 PoringCoin (7539)
And the rest of the clan that survives on the map will win 50 PoringCoin?
Script:
Honestly, thank you very much!
Edited by hardeliteLink to comment
Share on other sites
6 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.