The code for the Guildmasters does work.. after i sourced the first set of sql code all the NPC's that had it indicated they were a guildmaster trained the appropriate classes, and refused anyone not of the appropriate class.
The lastname thing apparently does not work or so I've been told.. I;ve heard people say it does i've heard people say it doesn't.. i;ve not gotten it to work.. looking at the code (I'm not a programer by any means) i don't see an obvious reason as to why it doesn't. but If and when it does work the above .sql code will work to populate the lastname field according to whats at the end of the name in the DB.
I mainly did this to see if i *COULD* do it, (i am starting to learn some sql stuff at work) mainly for my own personal satisfaction. Since it did what i wanted it to do and did make the Trainers functional I figured I would share the code.
|