summaryrefslogtreecommitdiff
path: root/npc/custom/eAAC_Scripts/DonationGirl/sql
diff options
context:
space:
mode:
authoreaac <eaac@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-06-21 21:15:39 +0000
committereaac <eaac@54d463be-8e91-2dee-dedb-b68131a5f0ec>2007-06-21 21:15:39 +0000
commit945b5710110eefaf9ddacbfac8f78b6556751015 (patch)
tree3d5010e39b5e7e67599cacb7ea0a1ba24b001b5f /npc/custom/eAAC_Scripts/DonationGirl/sql
parent904f0fd88b48db84db26f842f65ac9d2d7c110ea (diff)
downloadhercules-945b5710110eefaf9ddacbfac8f78b6556751015.tar.gz
hercules-945b5710110eefaf9ddacbfac8f78b6556751015.tar.bz2
hercules-945b5710110eefaf9ddacbfac8f78b6556751015.tar.xz
hercules-945b5710110eefaf9ddacbfac8f78b6556751015.zip
* Update to the eAAC Scripts (don't ask...). [eAAC]
*= Removed disguiser.txt as it seems to error, thus failing to comply with eAAC terms git-svn-id: https://rathena.svn.sourceforge.net/svnroot/rathena/trunk@10801 54d463be-8e91-2dee-dedb-b68131a5f0ec
Diffstat (limited to 'npc/custom/eAAC_Scripts/DonationGirl/sql')
-rw-r--r--npc/custom/eAAC_Scripts/DonationGirl/sql/donate.sql6
-rw-r--r--npc/custom/eAAC_Scripts/DonationGirl/sql/donate_item_db.sql17
2 files changed, 11 insertions, 12 deletions
diff --git a/npc/custom/eAAC_Scripts/DonationGirl/sql/donate.sql b/npc/custom/eAAC_Scripts/DonationGirl/sql/donate.sql
index 9315228a9..6838297bc 100644
--- a/npc/custom/eAAC_Scripts/DonationGirl/sql/donate.sql
+++ b/npc/custom/eAAC_Scripts/DonationGirl/sql/donate.sql
@@ -1,6 +1,6 @@
CREATE TABLE `donate` (
`account_id` int(11) unsigned NOT NULL,
- `amount` float(5,2) unsigned NOT NULL,
- `claimed` float(5,2) unsigned NOT NULL,
- PRIMARY KEY (`account_id`,`amount`)
+ `amount` float(9,2) unsigned NOT NULL,
+ `claimed` float(9,2) unsigned NOT NULL,
+ PRIMARY KEY (`account_id`)
) TYPE=MyISAM; \ No newline at end of file
diff --git a/npc/custom/eAAC_Scripts/DonationGirl/sql/donate_item_db.sql b/npc/custom/eAAC_Scripts/DonationGirl/sql/donate_item_db.sql
index 34519324b..2b3caf104 100644
--- a/npc/custom/eAAC_Scripts/DonationGirl/sql/donate_item_db.sql
+++ b/npc/custom/eAAC_Scripts/DonationGirl/sql/donate_item_db.sql
@@ -1,14 +1,13 @@
CREATE TABLE `donate_item_db` (
`id` smallint(5) unsigned NOT NULL default '0',
- `name` varchar(30) NOT NULL default '',
- `price` float(5,2) unsigned NOT NULL,
+ `price` float(9,2) unsigned NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
-#(ID,'Name',Price);
-REPLACE INTO `donate_item_db` VALUES (601,'Fly_Wing',0.06);
-REPLACE INTO `donate_item_db` VALUES (602,'Butterfly_Wing',0.33);
-REPLACE INTO `donate_item_db` VALUES (603,'Old_Blue_Box',10);
-REPLACE INTO `donate_item_db` VALUES (604,'Dead_Branch',0.05);
-REPLACE INTO `donate_item_db` VALUES (605,'Anodyne',2);
-REPLACE INTO `donate_item_db` VALUES (606,'Aloevera',2); \ No newline at end of file
+#(ID,Price);
+REPLACE INTO `donate_item_db` VALUES (601,0.06); #Wing_Of_Fly
+REPLACE INTO `donate_item_db` VALUES (602,0.33); #Wing_Of_Butterfly
+REPLACE INTO `donate_item_db` VALUES (603,10); #Old_Blue_Box
+REPLACE INTO `donate_item_db` VALUES (604,0.05); #Branch_Of_Dead_Tree
+REPLACE INTO `donate_item_db` VALUES (605,2); #Anodyne
+REPLACE INTO `donate_item_db` VALUES (606,2); #Aloebera \ No newline at end of file