aegsav Posted December 31, 2008 Posted December 31, 2008 Friends thought these shields in Interlude version, I found interesting and decided to adapt the other versions. I hope you enjoy. Link: http://www.4shared.com/file/76175210/6cd2a4fe/AEGSAVINTER-KAMAEL-HELLBOUND-GRACIA-TRANSPARENTS_CUSTOM_SHIELDS.html Correct Xml: http://www.4shared.com/file/78288717/52ecb549/38812-38817.html Screens: Credits: Jmagaiver: Adapted kamael for Interlude aegsav: Adapted for All versions. Sorry For My Bad English
liquid_ice Posted December 31, 2008 Posted December 31, 2008 found a bug in ur XML file.. all the items dont have the </item> at the end of the line.. EDIT. the shields wont load up SEVERE Stats for item id 38812 ignored ! SEVERE Stats for item id 38813 ignored ! SEVERE Stats for item id 38814 ignored ! SEVERE Stats for item id 38815 ignored ! SEVERE Stats for item id 38816 ignored ! SEVERE Stats for item id 38817 ignored ! this happens normally when the items arent in the database, but the thing is, they are.they are all in the database. unless ur sql is wrong..
aegsav Posted December 31, 2008 Author Posted December 31, 2008 found a bug in ur XML file.. all the items dont have the </item> at the end of the line.. EDIT. the shields wont load up SEVERE Stats for item id 38812 ignored ! SEVERE Stats for item id 38813 ignored ! SEVERE Stats for item id 38814 ignored ! SEVERE Stats for item id 38815 ignored ! SEVERE Stats for item id 38816 ignored ! SEVERE Stats for item id 38817 ignored ! this happens normally when the items arent in the database, but the thing is, they are.they are all in the database. unless ur sql is wrong.. Thankx man. I post the correct xml.
varo Posted December 31, 2008 Posted December 31, 2008 error sql again take a look [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38812', 'Blue Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38813', 'Dark Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38814', 'Fire Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38815', 'Gold Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38816', 'Ice Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38817', 'Wind Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Msg] Finished - Unsuccessfully --------------------------------------------------
liquid_ice Posted December 31, 2008 Posted December 31, 2008 that happens coz u ran the sql thats outside th SQL folder...one with a long name...
aegsav Posted December 31, 2008 Author Posted December 31, 2008 error sql again take a look [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38812', 'Blue Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38813', 'Dark Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38814', 'Fire Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38815', 'Gold Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38816', 'Ice Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Err] 1136 - Column count doesn't match value count at row 1 [Err] INSERT INTO `weapon` VALUES ('38817', 'Wind Dragon Shield', 'lhand', 'true', '1170', '0', '0', 'bone', 's', '0', '5', 'none', '0', '0.00000', '-8', '290', '20', '0', '0', '0', '-1', '3760000', '188', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0'); [Msg] Finished - Unsuccessfully -------------------------------------------------- Try use the sql by name: [AEGSAV]SQL EMU FREE TRANSPARENT CUSTOM SHIELD.sql Contained in RAR Folder.
Zeronimo Posted January 1, 2009 Posted January 1, 2009 It's because the lines doesnt match the sql table in the DB. There are missing columns.
jossoo Posted January 2, 2009 Posted January 2, 2009 and its work for kamael? yes... nice share..tnx :)
Bleik Posted January 13, 2009 Posted January 13, 2009 Nice share!!Imperial shield in colourfull style!!
xKenji Posted February 1, 2009 Posted February 1, 2009 haha the blue and red ones just own! keep it up :P
TexasJunior Posted February 1, 2009 Posted February 1, 2009 Amazing Share :D i like your work and i will add this shields to my server ;) keep Up
Recommended Posts