Ok as far as I can find, this system works 100% as far as I have found. It's not completely finished but maybe other people can take it further and re-release it (giving me and inflikted credit for the initial work of course lol) I've made this system as an adaption to the guild bank system made by Inflikted.
First make a new table in Game3G in SQL. Call it TBL_GUILDPOINTS.
Make 2 fields. FLD_GUILD and FLD_GPOINTS
OR
Make a new field in Game3G in TBL_CHARACTER and call it FLD_GUILDPOINTS.
Then make another table called TBL_GUILDBANK.
Make 2 Fields. FLD_GUILD and FLD_GOLD.
Then make an npc and use the script GuildBank.txt as this is the system for the guild shop and the guild bank. I put this in Questdiary/System as thats where most of my scripts like this are and I have it call it from the D-Menu for convenience
Next you'll want to make a mapquest for getting guild points. It can be used any way you want I guess but it's completely upto you what way you use it. It works either way, you can give guildpoints to individual chars so that they can choose how and when to redeem them to a guild (Do the second option in SQL), or you can assign them to a guild itself (Do the first option in SQL).
attaching text documents with each script option, for both the char and guild options. Also I'm attaching script you can put into 00default.txt for when chars level if you wish to assign guildpoints on level up.
All I ask is that people don't take credit for my work. Once again thanks to Chimera for all the help getting this system to work and to Inflikted for the initial script that inspired me to get this system working .
Edit: Mondie for guild & chars fixed as were bugged.
First make a new table in Game3G in SQL. Call it TBL_GUILDPOINTS.
Make 2 fields. FLD_GUILD and FLD_GPOINTS
OR
Make a new field in Game3G in TBL_CHARACTER and call it FLD_GUILDPOINTS.
Then make another table called TBL_GUILDBANK.
Make 2 Fields. FLD_GUILD and FLD_GOLD.
Then make an npc and use the script GuildBank.txt as this is the system for the guild shop and the guild bank. I put this in Questdiary/System as thats where most of my scripts like this are and I have it call it from the D-Menu for convenience
Next you'll want to make a mapquest for getting guild points. It can be used any way you want I guess but it's completely upto you what way you use it. It works either way, you can give guildpoints to individual chars so that they can choose how and when to redeem them to a guild (Do the second option in SQL), or you can assign them to a guild itself (Do the first option in SQL).
attaching text documents with each script option, for both the char and guild options. Also I'm attaching script you can put into 00default.txt for when chars level if you wish to assign guildpoints on level up.
All I ask is that people don't take credit for my work. Once again thanks to Chimera for all the help getting this system to work and to Inflikted for the initial script that inspired me to get this system working .
Edit: Mondie for guild & chars fixed as were bugged.
Attachments
Last edited: