Guild points

[mirlin6]

Hello all,

I want to make a guild points system, so when user kills as certain mob they get guild points and then they go on to a npc and can be spend them on upgrade for there guild.

anyone know how i could this, i think it would have to be done in sql but im not sure about the mobs giving GuildPoints

Thank

 

[Geordiehc]

I haven't 100% figured it out yet and my scripts don't belong to me and i've been told not to release them so i can't but i can tell you you need to add a table to SQL and then u use mondie to add values to it. When i posted about this before i got told that people are willing to share this info as up until a few months ago there was only 1 server using it and wouldnt share, so maybe someone could release a min die script or something?

 

[mirlin6]

Well if i get this working im willing to release all my work

 

[idaBigA]

If you understand how to manipulate SQL and can read the MapQuest files, making a Guild Point system is easy enough.. and Inflikted has already posted a basic one on another thread.

 

[mirlin6]

I want to add a certain amount of points say 5 point to the database, im guessing i would need to use a vairible for this? so that when the mob dies you will receive a certain amount of points.

 

[Inflikted]

first off geo.. whats the big secret? :P people hide scripts likes its a treasure chest or something lol. most of these scripts can be made in 10 minutes or less.. if you no what your doing lol but most dont no what they are doing.

i already made one, i could release it. but i rather people learn it.. if you spend time and look at the full example scripts i posted.. then it wont be very difficult it turns out to be a simple mondie mapquest script as geo said

look through my example, pay attention.. how new users/guilds are added to the db, how fields are updated in the tables... how to add strings to the table. once you understand this basic concept then you can manipulate this for many other things.

come back when you got a basic grasp of SQL manipulation then you will get help

and to be fair idabiga.. i posted those examples.. but i learned it from you :P when you originally posted that guild pk system for amenovis, i learned how it worked and made it to my own so ty hehe

 

[Coly]

You don't need Knowlage in MirScript for this, you only need knowlage in SQL-Programming not more ;-) then you can made all you love. "the hint is Stored Proc."

 

[mirlin6]

ive made the script and database but something seems to be wrong with the script it doesent do anything :S tryed to do the mondie also stuck on this...

 

[chimera]

*sounding like school maths teacher*

Show your workings and we can more clearly see where you've gone wrong