Custom table/row/field selection for vbactivity.

I think it would be great (Invaluable) to have a feature for vBActivity where you allow the user to go through any of the tables rows and fields in the database and choose them to create their own criteria for awards and trophies.

Here is how it would work:

1. The mod would pull the information from the database and lay it out in a selectable form for the user.

2. The mod asks the user, which field contains the memberid? They'd find it and click on that field. The mod then creates the first portion of the SQL query. Something like SELECT memberid FROM.. and so on (Not sure exactly how it works)

3. The mod then asks, what field contains the numerical value? So then, I go and find that field and click it and the mod completes the query.

SELECT value FROM .... WHERE memberid = *

This would allow those of us who are a bit more technical, but not to the level of coding, to create our very own criteria for vbActivity.

An example in using this would be for example, in VBITTY torrent tracker for vBulletin.



In the example above, VBITTY uses uid as the memberid. But vBactivity won't care, it just needs to know where other mods/features store the userid so it can assign awards/trophies to memberid's.

So I'd first select uid as the column that contains memberid's and then I'd choose uploaded as the value I wanted to compare against.

I could then add it, and any member who uploads more than XXXXXX bytes of data receives the award "Torrent Uploader".

I guess it wouldn't have to be a GUI interface to do this, it could simply give dropdowns/boxes where we input tables/columns etc for pulling the information. Another popular points mod gives this extensibility but it's incredibly complex. I think this is a good middleground and it'd absolutely rock if vBactivity could do this.

Definitely a very interesting suggestion Sounds like fun to make too.
We'll take it into consideration

Sent from my X10i using Tapatalk

In the mean time would there be a quick way for me to add this point calculator based on the image I posted above? I looked around in the different types php files but couldn't quite figure out how to do it. I was trying to use post.php for my base.

The files in /dbtech/vbactivity/type hold the key, basically what you need to do is fill out the variables at the top and change any table names.
Also, you will need to insert a row into dbtech_vbactivity_type I believe, and add a few phrases. The points settings page will tell you the phrase name once you've added the row, though.