RPG Mod Defined

[scx]

irbrian: that's the way to learn PHP
However I dont rock at PHP, but I could help you

[irbrian]

Good enough for me. The challenge right now, as I mentioned, is figuring out how to convert from the standard Number of Posts Membergroups system to the Experience Points Awarded Per Post and Leveling system.

I don't know what variables are going to be relevant here and where those can be found, or how to create new items in the database for Experience and Level.

[scx]

Hmm, everytime a user make a post calculate using karma how many exp point he gets.
And when someone wants to read a topic, an instant message or wants to view profile of another user, calculate which level a user has, which depends of exp points.

And MySQL query for new column would be like:
ALTER TABLE table_name ADD exp int NOT NULL;

This creates a column called exp (which can contain only numbers) in the given table. Because of NOT NULL modifier value is set to 0 at creating.

[irbrian]

I don't want to involve Karma just yet. Because Karma is already incorporated into the board software (and may I just say, Hallelujah and Thank You YaBB SE Developers) I don't have to program that anyway, so it should be fairly easy to include Karma in this whole equation later on.

Lets just focus on getting the Experience Points and Levels in first. For me that may end up being the trickiest part, too.

Thanks for the MySQL snippet.. once I figure out what to do with it or where to put it, I'm sure that will help immensely.

[scx]

That query should be executed only once, so I guess this mod has to have an installation script.

[scx]

I was trying to make a code, which adds 100 exp each time a user post.
Well, I did it though, it's kinda boring - 100 exp at every post, no differnece.
Now I gonna add levels too.

[irbrian]

SCX, you are way ahead of me lol. That's excellent work! I should think the levels should be quite easy for you. Maybe you could share your code/changes with me so I can see what you did, and what I'm doing wrong.

Remember, try to make the levels progressive.. in other words, Level 2 might be 500 points, while Level 3 might be 1200 points, Level 4 2000, etc. Those are just examples, they can be tweaked as necessary. And also keep in mind that later, Karma could be used to dynamically adjust the actual experience points awarded per post.

You seem to have this project well in hand! Let me know if you need assistance!

Actually, I had one final request. Could you adjust the code so that instead of pasting the "Add Experience Points" code right into the Post function, you put it in a "postExperience()" function or something (if its not like this already)? That would make it easier for the Mod Team to check for compatibility!

Thanks!!!

[scx]

I have send you that code with IM.
Well, I chose experience points for levels from Baldur's Gate 2 manual, from class druid.

BTW: there's one typo/mistake in my message -> change one "I" in "you", which one figure out yourself .

[irbrian]

Do you have a board you've tried this on yet? If so, whats the URL, I'd like to check it out?

[scx]

I have that board on my comp. If you want I can leave server running for few hours. I will send you an IM, so check it!

[Wiedo]

wow you are actually started the project!
I like this.. !

 

and the project is developing (english?) very fast...
I like seeing this... maybe I must learn more PHP to... my site include only a few basics (actualy only the include code)...

hope to use your mod sooN!

[irbrian]

Heh, well so far its SCX's mod. Perhaps I'm the creative source, the inspiration behind the project. Or perhaps I'm fishing for credit. Either way though, I think we'll actually get this mod done someday, and its going to be amazing!

(Thats me thinking big.)

For now, lets focus on what we've got. How's it coming SCX, and is there anything I can help with yet?

[scx]

irbrian: have you got my two messages?

Anyway, can you write a code, that will adjust how many exp, depend of karma, a member gets with one post? 100 exp for karma of 0 say. Or maybe should we call it reputation?

[irbrian]

Sorry, SCX! Yes, I got your messages 2 days ago. I haven't had time to try out the code though.

Anyway, can you write a code, that will adjust how many exp, depend of karma, a member gets with one post? 100 exp for karma of 0 say.

I would definitely write the code to adjust the exp. points based on karma, but I'm afraid I don't know where in the software to put it. Where do you think it should go?

Ultimately (once I understand this all better) I'd like to create a section in the Admin panel that allows the admin to set the number of experience points per post )(or attachment or poll or registration or whatever), as well as the number of levels possible and the experience points required for each.

But for now, your system is an excellent starting place.. I just still don't understand the syntax I would use to CREATE a new item in the database, or how that works with multiple members, etc. I wish I had more time to spend on hacking, experimenting, and just browsing through the code.

Or maybe should we call it reputation?

Or maybe we should leave it as karma for now, but in the future we could modify it so that admins can also specify the text to replace "Karma" with.

Does anyone know a good way to learn how to use MySQL within PHP? I understand basic PHP, but I'm still confused on how to create and edit database tables and values in MySQL.

DATABASE	Member1	Member2
Karma	How do I...	Edit these?
Exp	How do I...	Add these?
Level	Where do I...	Put the code?

[scx]

At Dev Shedyou can learn mysql and also PHP tutorials are there (just go to PHP section).

There's no need to add new table into YaBB SE database, just modify the table "members". Also you dont need to put level of a member in a database. Levels are caculated from ex points.

Anyway, I had no time yesterday nor today for this mod.

Happy new year, Irbrian!