John Lamprou Posted September 26, 2007 Author Posted September 26, 2007 Hi there and thx for sharing this guide. I have problem in making that sql parts, i mean i ve tried but i cant figure out the correct structure of tables. can anyone post those scripts for making those tables here plz? thx... -- ---------------------------- -- Table structure for `character_faction_quests` -- ---------------------------- CREATE TABLE IF NOT EXISTS `character_faction_quests` ( `char_id` INT NOT NULL DEFAULT 0, `faction_quest_id` INT NOT NULL DEFAULT 0, PRIMARY KEY (`char_id`,`faction_quest_id`) ) DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `faction_members` -- ---------------------------- CREATE TABLE IF NOT EXISTS `faction_members` ( `player_id` INT NOT NULL DEFAULT 0, `faction_id` INT NOT NULL DEFAULT 0, `faction_points` INT NOT NULL DEFAULT 0, `contributions` INT NOT NULL DEFAULT 0, `join_date` INT NOT NULL DEFAULT 0, PRIMARY KEY (`player_id`,`faction_id`,`faction_points`,`contributions`,`join_date`) ) DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for `faction_quests` -- ---------------------------- CREATE TABLE IF NOT EXISTS `faction_quests` ( `id` INT NOT NULL DEFAULT 0, `faction_id` INT NOT NULL DEFAULT 0, `name` INT NOT NULL DEFAULT 0, `description` INT NOT NULL DEFAULT 0, `reward` INT NOT NULL DEFAULT 0, `mobid` INT NOT NULL DEFAULT 0, `amount` INT NOT NULL DEFAULT 0, `min_level` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`,`faction_id`,`name`,`description`,`reward`,`mobid`,`amount`,`min_level`) ) DEFAULT CHARSET=utf8; Thats all have fun man
kauliaris Posted September 26, 2007 Posted September 26, 2007 and many other things that related on gve for example the buff coin and you can take a town in your side by winning it Can you explain what you mean exactly by the buffcoin? I didnt see any new item in these files..:S And how is the coin related to castles?
John Lamprou Posted September 26, 2007 Author Posted September 26, 2007 This coin is located in inventory in quest items.You click on it and a menu with bufs appear.You choose the buffs and thats all
ICxtir Posted September 27, 2007 Posted September 27, 2007 oH! ty! i ll give it a try with those sql's,mine was wrong a bit :-\ i am working with htms now and i have an idea for npc with auto lvl function (i am thinking to use gm's code for editing a char) it might be work. anyway thx again for sharing this it will be a great lesson for me as i m learning now java ;D
Shoel Posted September 28, 2007 Posted September 28, 2007 well, nice share, but it is not for newbies, you just tell us to paste your file somewhere and then do everything else alone, that's not a guide thx anyway...
ICxtir Posted September 28, 2007 Posted September 28, 2007 Agree with that, i am trying 7 days now to get this think work with no lack till now but as noone wants to share a full pack with this i cant see another way to run a server like this :(
ICxtir Posted September 29, 2007 Posted September 29, 2007 well i m sorry for trying :( sorry for not been a programer sorry because my only relation with pc's till now was music production and sorry because i want to run a really free server to have my friends playing without donations....at all.....:D
Shoel Posted September 29, 2007 Posted September 29, 2007 well, nice share, but it is not for newbies, you just tell us to paste your file somewhere and then do everything else alone, that's not a guide thx anyway... T_T
John Lamprou Posted September 30, 2007 Author Posted September 30, 2007 well i m sorry for trying :( sorry for not been a programer sorry because my only relation with pc's till now was music production and sorry because i want to run a really free server to have my friends playing without donations....at all.....:D Well man can you tell me someting?I have friends that not know enything about java and ect but when i post the gude after a bit work they made the server.So as we understand you are a leacher and you wait from others
ICxtir Posted September 30, 2007 Posted September 30, 2007 i am just trying to make it work, is it so bad??only asked for help.did i ask anyone to give the full pack?no i only said that noone wants to share such think.anyway i will not argue anymore with noone cause i am doing this just for fun, its not my job and i dont make money from this,just trying to learn something in my free time,next month i will be in studio recording so->no free time at all. that's all from me thank you.
John Lamprou Posted October 4, 2007 Author Posted October 4, 2007 Because some users say that the files are not completed and need editing is falsi.All faction codes/faction points/buff coin and all are include just follow the guide and activate the system and spawn correct npcs
Kelemvor Posted February 4, 2009 Posted February 4, 2009 Edited: Akito palio post kapoios na to svisei
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now