@item Mod From Eathena

[Jhosef]

I try This to Rathena but its not Working

Can you help me

@item patch

Index: atcommand.c
===================================================================
--- atcommand.c (revision 14843)
+++ atcommand.c (working copy)
@@ -1576,6 +1576,7 @@
{
 char item_name[100];
 int number = 0, item_id, flag;
+ int itemid, level; //To Check the item_deny from sql [Vengence]
 struct item item_tmp;
 struct item_data *item_data;
 int get_count, i;
@@ -1602,6 +1603,27 @@
 }

 item_id = item_data->nameid;
+ //To Check the item_deny from sql [Vengence]
+ if(SQL_ERROR == Sql_Query(mmysql_handle, "SELECT * FROM `item_deny` WHERE `itemid` = '%d'",item_id))
+  {
+   Sql_ShowDebug(mmysql_handle);
+  }
+  else
+  {
+   while( SQL_SUCCESS == Sql_NextRow(mmysql_handle) )
+   {
+    char *data;
+    Sql_GetData(mmysql_handle, 0, &data, NULL);
+    itemid = atoi(data);
+    Sql_GetData(mmysql_handle, 1, &data, NULL);
+    level = atoi(data);
+   }
+  }
+ if (item_id == itemid && pc_isGM(sd) < level) {
+		    clif_displaymessage(sd->fd, "You are restricted from creating this item.");
+   return -1;
+   }
+
 get_count = number;
 //Check if it's stackable.
 if (!itemdb_isstackable2(item_data))

item_deny Sql

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `item_deny`
-- ----------------------------
DROP TABLE IF EXISTS `item_deny`;
CREATE TABLE `item_deny` (
 `itemid` smallint(5) NOT NULL,
 `level` tinyint(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of item_deny
-- ----------------------------
INSERT INTO `item_deny` VALUES ('501', '90');
INSERT INTO `item_deny` VALUES ('502', '90');

[FrustFenix]

change all level to group_id

[Jhosef]

1>c:\users\adminjoseph\desktop\rathena runk\src\map\atcommand.c(1413): error C2065: 'itemid' : undeclared identifier

1>c:\users\adminjoseph\desktop\rathena runk\src\map\atcommand.c(1415): error C2065: 'group_id' : undeclared identifier

1>c:\users\adminjoseph\desktop\rathena runk\src\map\atcommand.c(1418): error C2065: 'itemid' : undeclared identifier

1>c:\users\adminjoseph\desktop\rathena runk\src\map\atcommand.c(1418): warning C4013: 'pc_isGM' undefined; assuming extern returning int

1>c:\users\adminjoseph\desktop\rathena runk\src\map\atcommand.c(1418): error C2065: 'group_id' : undeclared identifier

still an error

[Lilith]

Index: atcommand.c
===================================================================
--- atcommand.c (revision 16385)
+++ atcommand.c (working copy)
@@ -1372,7 +1372,7 @@
ACMD_FUNC(item)
{
 char item_name[100];
- int number = 0, item_id, flag;
+ int number = 0, item_id, flag, level, itemid;
 struct item item_tmp;
 struct item_data *item_data;
 int get_count, i;
@@ -1399,6 +1399,26 @@
 }

 item_id = item_data->nameid;
+ 
+ //To Check the item_deny from sql [Vengence]
+ if(SQL_ERROR == Sql_Query(mmysql_handle, "SELECT * FROM `item_deny` WHERE `itemid` = '%d'",item_id))
+ Sql_ShowDebug(mmysql_handle);
+ else
+ {
+ while( SQL_SUCCESS == Sql_NextRow(mmysql_handle) )
+ {
+ char *data;
+ Sql_GetData(mmysql_handle, 0, &data, NULL);
+ itemid = atoi(data);
+ Sql_GetData(mmysql_handle, 1, &data, NULL);
+ level = atoi(data);
+ }
+ }
+ if (item_id == itemid && pc_get_group_level(sd) < level)
+ {
+ clif_displaymessage(sd->fd, "You are restricted from creating this item.");
+ return -1;
+ }
 get_count = number;
 //Check if it's stackable.
 if (!itemdb_isstackable2(item_data))

[Jhosef]

thanks its already Working

[maynard]

How to add item to be deny in the sql table? do I have to add item_deny.txt or something else?

[Emistry]

How to add item to be deny in the sql table? do I have to add item_deny.txt or something else?

load it into your sql database...

example..

INSERT INTO `item_deny` VALUES ('501', '90');
INSERT INTO `item_deny` VALUES ('502', '90');

[maynard]

ok I get it now, I will manually type it all if item I want to deny. Tnx sir Emistry and Happy New Year.

[uDe]

I've got some error for this src.. Need some help...

 

        CC      atcommand.c
atcommand.c: In function 'atcommand_item':
atcommand.c:1169:5: warning: 'flag' may be used uninitialized in this function [-Wuninitialized]
atcommand.c:1146:5: warning: 'itemid' may be used uninitialized in this function [-Wuninitialized]
atcommand.c:1146:24: warning: 'group_id' may be used uninitialized in this function [-Wuninitialized]

I'm using this src : http://rathena.org/board/topic/67383-item-mod-from-eathena/#entry119245

BUMP

BUMP

[uDe]

BUMP

[Erba]

bump, how to use this at rathena 17701?

bump

bump

bump