summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorshennetsind <shennetsind@users.noreply.github.com>2014-01-14 11:34:41 -0800
committershennetsind <shennetsind@users.noreply.github.com>2014-01-14 11:34:41 -0800
commit31f29768a286ba0fc47a3d7a9470d6fdf37c7546 (patch)
tree4368d26a9137d52c5fdb86a02170bd9849434068
parent499e228a01d84ec2ab0a4edaf8aeb868ad4e7618 (diff)
parent634e7e707819454a82f7bd965f06bb0c2590e81b (diff)
downloadhercules-31f29768a286ba0fc47a3d7a9470d6fdf37c7546.tar.gz
hercules-31f29768a286ba0fc47a3d7a9470d6fdf37c7546.tar.bz2
hercules-31f29768a286ba0fc47a3d7a9470d6fdf37c7546.tar.xz
hercules-31f29768a286ba0fc47a3d7a9470d6fdf37c7546.zip
Merge pull request #252 from ossi0110/master
Updated hunting_missions.txt
-rw-r--r--npc/custom/quests/hunting_missions.txt6
1 files changed, 3 insertions, 3 deletions
diff --git a/npc/custom/quests/hunting_missions.txt b/npc/custom/quests/hunting_missions.txt
index 5c3c6a469..8da51a1c0 100644
--- a/npc/custom/quests/hunting_missions.txt
+++ b/npc/custom/quests/hunting_missions.txt
@@ -126,7 +126,7 @@ function Chk; function Cm;
case 6:
mes "[Hunting Missions]";
mes "The top hunters are:";
- query_sql("SELECT char_id AS id, (SELECT `name` FROM `char` WHERE char_id = id),`value` FROM `global_reg_value` WHERE str = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5",.@id,.@name$,.@val);
+ query_sql("SELECT char_id AS id, (SELECT `name` FROM `char` WHERE char_id = id),`value` FROM `char_reg_num_db` WHERE `key` = 'Mission_Total' ORDER BY CAST(`value` AS SIGNED) DESC LIMIT 5",.@id,.@name$,.@val);
for(set .@i,0; .@i<5; set .@i,.@i+1)
mes " [Rank "+(.@i+1)+"] "+((.@name$[.@i] == "")?"^777777none":"^0055FF"+.@name$[.@i]+"^000000 : ^FF0000"+.@val[.@i]+" pt.")+"^000000";
close;
@@ -181,8 +181,8 @@ Mission_Status:
set #Mission_Count,0;
if (.Delay) set #Mission_Delay, gettimetick(2)+(.Delay*3600);
set Mission_Total, Mission_Total+1;
- if (Mission_Total == 1) query_sql("INSERT INTO `global_reg_value` (`char_id`,`str`,`value`,`type`,`account_id`) VALUES ("+getcharid(0)+",'Mission_Total','1',3,0)");
- else query_sql("UPDATE `global_reg_value` SET `value` = "+Mission_Total+" WHERE char_id = "+getcharid(0)+" AND `str` = 'Mission_Total'");
+ if (Mission_Total == 1) query_sql("INSERT INTO `char_reg_num_db` (`char_id`,`key`,`index`,`value`) VALUES ("+getcharid(0)+",'Mission_Total','0',1)");
+ else query_sql("UPDATE `char_reg_num_db` SET `value` = "+Mission_Total+" WHERE `char_id` = "+getcharid(0)+" AND `key` = 'Mission_Total'");
close;
Mission_Info: