rlfem123 Posted June 2, 2016 Share Posted June 2, 2016 How i can make char_template.sql for acis pack? ...I need for a connect to website Link to comment Share on other sites More sharing options...
0 Tryskell Posted June 2, 2016 Share Posted June 2, 2016 (edited) It got nothing related to chars templates, this info is stored on characters.sql `classid` TINYINT UNSIGNED DEFAULT NULL, `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0, baseClass being the initial class, and classId the current class (can be subclass). To retrieve class name : CharTemplateTable.getInstance().getClassNameById(player.getBaseClass()) or more simply player.getTemplate().getClassName() You can build a simple array on your website with id<>name and retrieve classid the same way you retrieve pvpkills. Edited June 2, 2016 by Tryskell Link to comment Share on other sites More sharing options...
0 Gam3Master Posted June 2, 2016 Share Posted June 2, 2016 character templates is in xml files located in data/xml/classes. why do you need them on website Link to comment Share on other sites More sharing options...
0 rlfem123 Posted June 2, 2016 Author Share Posted June 2, 2016 character templates is in xml files located in data/xml/classes. why do you need them on website For section classes on statistics Link to comment Share on other sites More sharing options...
0 Elfo Posted June 2, 2016 Share Posted June 2, 2016 How i can make char_template.sql for acis pack? ...I need for a connect to website Depends. Do you need all the info in there? If yes then only manually i guess. If not then you can right some regex to generate the insert statement. Link to comment Share on other sites More sharing options...
0 Gam3Master Posted June 2, 2016 Share Posted June 2, 2016 If you want it only for for heroes,top pvp/pk statistics you can import any char_templates on your database, that will not cause any problems Link to comment Share on other sites More sharing options...
0 rlfem123 Posted June 2, 2016 Author Share Posted June 2, 2016 If you want it only for for heroes,top pvp/pk statistics you can import any char_templates on your database, that will not cause any problems Any hah but from where i can take such file?? Link to comment Share on other sites More sharing options...
0 Tryskell Posted June 2, 2016 Share Posted June 2, 2016 (edited) What specific static infos do you want to call ? Easiest would be to reuse already loaded templates maps, and run a single method which build sql strings based on those maps. But you will probably need multiple sql tables to handle all infos (like npcs, which is a merge of something like 5+ sql tables : drops, ai, templates, teachto, minions,...). Edited June 2, 2016 by Tryskell Link to comment Share on other sites More sharing options...
0 rlfem123 Posted June 2, 2016 Author Share Posted June 2, 2016 What specific static infos do you want to call ? Easiest would be to reuse already loaded templates maps, and run a single method which build sql strings based on those maps. But you will probably need multiple sql tables to handle all infos (like npcs, which is a merge of something like 5+ sql tables : drops, ai, templates, teachto, minions,...). i need to connect classes of characters in the website. http://postimg.org/image/iwhm2ov8r/ Link to comment Share on other sites More sharing options...
0 rlfem123 Posted June 3, 2016 Author Share Posted June 3, 2016 It got nothing related to chars templates, this info is stored on characters.sql `classid` TINYINT UNSIGNED DEFAULT NULL, `base_class` TINYINT UNSIGNED NOT NULL DEFAULT 0, baseClass being the initial class, and classId the current class (can be subclass). To retrieve class name : CharTemplateTable.getInstance().getClassNameById(player.getBaseClass()) or more simply player.getTemplate().getClassName() You can build a simple array on your website with id<>name and retrieve classid the same way you retrieve pvpkills. Thank you Tryskell Link to comment Share on other sites More sharing options...
0 Diana Melison Posted June 6, 2016 Share Posted June 6, 2016 Solved/Locked. Link to comment Share on other sites More sharing options...
Question
rlfem123
How i can make char_template.sql for acis pack? ...I need for a connect to website
Link to comment
Share on other sites
10 answers to this question
Recommended Posts