summaryrefslogtreecommitdiff
path: root/npc
diff options
context:
space:
mode:
authoreaac <eaac@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-07-03 22:53:27 +0000
committereaac <eaac@54d463be-8e91-2dee-dedb-b68131a5f0ec>2006-07-03 22:53:27 +0000
commitf42d3cac328f48c5b73adbb7554c26894988be54 (patch)
tree91e497294e89cd47ada2420c25237b0986bbf738 /npc
parentbb0a08a67c73be469c130567ec9e6c5b8a4a2963 (diff)
downloadhercules-f42d3cac328f48c5b73adbb7554c26894988be54.tar.gz
hercules-f42d3cac328f48c5b73adbb7554c26894988be54.tar.bz2
hercules-f42d3cac328f48c5b73adbb7554c26894988be54.tar.xz
hercules-f42d3cac328f48c5b73adbb7554c26894988be54.zip
*eAAC Update to donation girl. [erKURITA]
git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@7461 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'npc')
-rw-r--r--npc/custom/eAAC_Scripts/DonationGirl/donate.txt4
1 files changed, 3 insertions, 1 deletions
diff --git a/npc/custom/eAAC_Scripts/DonationGirl/donate.txt b/npc/custom/eAAC_Scripts/DonationGirl/donate.txt
index 99a2776f1..b22498289 100644
--- a/npc/custom/eAAC_Scripts/DonationGirl/donate.txt
+++ b/npc/custom/eAAC_Scripts/DonationGirl/donate.txt
@@ -21,6 +21,8 @@
//= with decimals.
//= 3.1 - Added quotes to some queries, fixed a variable and
//= removed a comment.
+//= 3.2 - Fixed a problem where eAthena would crash if a
+//= query returned NULL.
//===== Compatible With =====================================
//= eAthena - any version that contains the escape_sql
//= function (Stable 6299 OR Trunk 6262)
@@ -143,7 +145,7 @@ close;
L_STATS:
mes "[Donation Girl]";
-query_sql "SELECT SUM(amount) FROM `donate`", @total$;
+query_sql "SELECT IFNULL((SELECT SUM(amount) FROM `donate`),0)", @total$;
mes "Our fund is at a total of $"+@total$+"";
next;
menu "More info",L_INFO,"Make a claim",L_CHECK,"Statistics",L_STATS;