PDA

View Full Version : Major Additions - Nexia's POINTS system


Pages : 1 [2]

auctionguy
04-04-2007, 08:59 PM
I have it installed now on my site but how do you Donate money to other members? I didn't see a function for that! any news on a ibPro integration addon??

nexialys
04-04-2007, 09:05 PM
there is no donation system in it actually... or it would be indicated in the first post...

also, the vbPro integration is not in my plans for the next days.. you have to understand that coding takes time, and time is not free when you have to feed 3 kids and a wife... i use my spare time to provide support for this script, and actually it is more than 2 hours per day...

in the next days, the focus is on the adminCP system for managing points, adding new features have to be tossed for a moment...

milsirhc
04-05-2007, 06:59 AM
Hi Nex,

Is the deduction error done? Cos I've read the last few posts and I'm lost whether has the attachment been updated...

Can you also remember update the update statement when you update the plugin? Hahaha, tongue twister!

ktutorials
04-05-2007, 02:17 PM
can members donate points to other members...

nexialys
04-05-2007, 02:49 PM
Hi Nex,

Is the deduction error done? Cos I've read the last few posts and I'm lost whether has the attachment been updated...

Can you also remember update the update statement when you update the plugin? Hahaha, tongue twister!

Deduction error done... and will not touch it more... i lost like 5 hours just to fix it, and i'm sure something will drop by another time.. lol

sorry for the non-update entry, forgot about it!

nexialys
04-05-2007, 02:49 PM
can members donate points to other members...

As stated in the first post, not yet... but as i'm finishing the adminCP side for dealing with points deals, i will try to make that donation process after...

Blaine0002
04-05-2007, 04:38 PM
I love how people dont read and expect to get answers.

nexialys
04-05-2007, 04:42 PM
I love how people dont read and expect to get answers.

they get answers.. .but they learn the hard way that there is some "real life" to mimic here...

blockbusted
04-05-2007, 05:14 PM
they get answers.. .but they learn the hard way that there is some "real life" to mimic here...

Hey nex, don't forget to update the changelog whenever you change something. It helps us out :)

milsirhc
04-05-2007, 05:19 PM
Deduction error done... and will not touch it more... i lost like 5 hours just to fix it, and i'm sure something will drop by another time.. lol

sorry for the non-update entry, forgot about it!

Erm.. so the latest one should be working ya?

nexialys
04-05-2007, 05:20 PM
Erm.. so the latest one should be working ya?

working or not, i'm done with that part... but yeap, it is supposed to work..;)

in the next hours i will release the first version of the AdminCP!

blockbusted
04-05-2007, 05:24 PM
in the next hours i will release the first version of the AdminCP!

Great! I can't wait!

milsirhc
04-05-2007, 05:32 PM
HI nex, can you show me the options you have put for it to work? cos it's still not working on my side.. the thread poster still got his points deducted as thread+ replies point.. =(

rjmjr69
04-05-2007, 05:39 PM
WOW and I just fixed my Plaza install.... Well I guess I wont activate it and wait to see what happens here. Nex the work you are doing is amazing. I have never seen a mod updated so fast and with such precision. Please keep up the good work. Make sure you take care of that family before you take care of us......

Thanks.

""Clicks install until finished""""

nexialys
04-05-2007, 06:11 PM
.. the script is updated often because it is bogus, not because i'm efficient.. .lol

paulvev
04-05-2007, 09:16 PM
Hi,

One of my registered forum members is NOT accumulating points when posting, even although everybody else is? Whilst strange, I cant see why not? Searching through User permissions in AdminCP, her settings are exactly the same as everybody elses and she's clearly posted today and yesterday?! Any suggestions? I dont think shes noticed yet but thought i would bring this to your attention Nexialys. Her points remain at zero no matter how many posts she makes. Hope you can advise. Thanks.

novelidea
04-05-2007, 09:24 PM
When I tried to import from vbbux, it's not importing the bank points at all.

zardos
04-05-2007, 09:55 PM
what about the option to get a point very time one of ones referrals posts?

Regs
04-05-2007, 11:07 PM
When I tried to import from vbbux, it's not importing the bank points at all.I had no issues with it... they were imported fine, they are just not 'accessible' at the moment.

Cheers,

~Regs.

nexialys
04-05-2007, 11:23 PM
Hi,

One of my registered forum members is NOT accumulating points when posting, even although everybody else is? Whilst strange, I cant see why not? Searching through User permissions in AdminCP, her settings are exactly the same as everybody elses and she's clearly posted today and yesterday?! Any suggestions? I dont think shes noticed yet but thought i would bring this to your attention Nexialys. Her points remain at zero no matter how many posts she makes. Hope you can advise. Thanks.

there is no possibility of a user not gaining point where everybody else does... there is no permission on this system... yet!

i don't see how this could not work on her own account...

nexialys
04-05-2007, 11:24 PM
When I tried to import from vbbux, it's not importing the bank points at all.

actually the points in bank are stored in the nex_points_bank field, so they are present... you can go in the adminCP and edit a member, you'll see the detail in the Nexia's Points System part... the problem you have is that you can't use them yet because you did not install another bank system, and the one planned here is not built yet...

nexialys
04-05-2007, 11:27 PM
what about the option to get a point very time one of ones referrals posts?

you ask to create a addon that will give the referrer some points when his/her referred friend post in the forum ?!

this is possible... easy to add... but i think you'd be the only one on this community to need this addon... the point here is to build tools that will profit to everybody... you can contact me in private if really necessary to your board though.

actually it is trivial, because you would ask 2 queries for each post made on the forum, added to the existing 1 addition from the actual system.. one query to check the referrer, and one to the referee... if your forum is big enough, you would have an overheating sql server just for that... :erm:

cashpath
04-05-2007, 11:40 PM
I would be interested in something like that too (points for referrals posts).

But not at the expense of overloading a server.. no other way of doing it without the queries? (No I don't have this installed yet but have been watching closely)

nexialys
04-05-2007, 11:54 PM
I would be interested in something like that too (points for referrals posts).

But not at the expense of overloading a server.. no other way of doing it without the queries? (No I don't have this installed yet but have been watching closely)
logically, it is impossible to use this system without queries on the database... it writes stuff into it...

i've checked closely, this would add one query per post made... so it is possible... i may add this in the shelf of the "referral and registration" part... will do that part in a day or two when the AdminCP is built.

cashpath
04-06-2007, 12:02 AM
What about something like a weekly cron that checks how many new posts your referrals have made and gives points based off of that. Would that be better than a query every post?

nexialys
04-06-2007, 12:09 AM
cron jobs are good when everything is quiet and steady... you can store as many informations as you want when nothing move...

but if you have posts that are deleted or moved or moderated, etc... that makes a lot of things to check...

btw, a single query takes something like 0.003sec. to execute... the query itself is not a problem... the serverload for such feature is taken into consideration when you have a popular board, but it is not the only feature you have to take care of... like the "mark forum as read" is more server intense...

milsirhc
04-06-2007, 12:49 AM
hmm.. sorry to be a pain..

I tested the deduction again for thread now.. and it's still wrong.. it's minus-ing the thread as (thread+post) points.

@Nex: it was working OK in the previous version.. but now, it's not.. *sigh*

cashpath
04-06-2007, 01:09 AM
Just a few questions..

What can vbbux do that this can't right now?

If vbbux is replaced by this will VBplaza work with this until a suitable store is made?

nexialys
04-06-2007, 01:20 AM
vBbux was dropped due to some exploits and due to the non-followup of the developpers... he disapeared from the planet.

vBplaza is part of vBbux... same thing then...

NPS is not and will never be a replacement for vBbux... vbplaza was for me a pain and a complete loss of resources for a real forum... and i'm not interested to make a mimic of this tool with my system.

nexialys
04-06-2007, 01:21 AM
hmm.. sorry to be a pain..
I tested the deduction again for thread now.. and it's still wrong.. it's minus-ing the thread as (thread+post) points.
@Nex: it was working OK in the previous version.. but now, it's not.. *sigh*

ok, i don't know now... why did i test the same situations and did not have the same results...

i will not work on it anymore until someone play with the calculations and find the bug... i lost too much time on this part - that not everybody will use anyway, and i did not finish the adminCP due to that...

i'll finish the release and come back to this bug once i'm rested... sorry.

cashpath
04-06-2007, 02:00 AM
NPS is not and will never be a replacement for vBbux...

Why not? (what can vbbux do that NPS can't?)

vbplaza was for me a pain and a complete loss of resources for a real forum... and i'm not interested to make a mimic of this tool with my system.

Thats acceptable, but if I have vbbux installed and I wanted to convert it to NPS would I be able to keep VBPlaza working with it?

I'm not asking anyone to make anything or do anything I'm just asking whether or not Vbplaza will work with NPS and what features I lose if I convert from vbbux to NPS

milsirhc
04-06-2007, 02:26 AM
ok, i don't know now... why did i test the same situations and did not have the same results...

i will not work on it anymore until someone play with the calculations and find the bug... i lost too much time on this part - that not everybody will use anyway, and i did not finish the adminCP due to that...

i'll finish the release and come back to this bug once i'm rested... sorry.

It's alright buddy.. I'm just implemented this mod onto my forum and with that bug, I made it as a feature instead where if a thread were to be deleted (as likely to be spam), the thread start will be deducted the thread points + a fine of the reply points.

Hahaha!

nevertheless, thanks for this great mod! Have a Happy Easter!

ktutorials
04-06-2007, 05:33 AM
As stated in the first post, not yet... but as i'm finishing the adminCP side for dealing with points deals, i will try to make that donation process after...

please make it fast mate... since without donation.. the point system will be like just a post count with some ratio...

ATB mate... finish it soon... eager to see this addon.... :)


Also make a feature like only point work for few forums(Ex: it shoud not increase points in some forum like OFF TOPIC and shud be enabled in other forum sections...)


Also make a option like you can edit the points for all users by the admin... :) Hope its a easy one .. just a update query.. hope so...

Also it will be nice to see Points for Referrals..

paulvev
04-06-2007, 10:25 AM
Solved it today with further investigation. Her points accumulated were ALL used when she spent a day viewing attachments on the forum, and i had set points to be deducted upon each view....so she had no points left. Everything is ok and apologies if i created a mystery from nothing!

Suggestion for Admin CP update : Is there any way we can see the TOTAL points in hand accumulated and TOTAL points in Bank summarised as Two figures at the bottom of the forum for example in "whats going on?" section.
e.g

Total Cash in Hand for all members : ?56.34p
Total Cash in Bank for all members : ?0.00p

For me this is important as points = cash and i need to be able to see the sum total of them at any one time. Many people must have the same need.

Thanks for the great mod, fast replies, relax for while and have a brilliant Easter!

nexialys
04-06-2007, 10:56 AM
@ktutorials : every good comes when every need fit... ;)
@paulvev...: good to know it is correct... and for your suggestion, i'm on it as soon as i finish the adminCP...

colicab-d
04-06-2007, 12:52 PM
Anyway to edit users points mnaually. Im using this systems as a way to share loot out in World Of Warcraft and with the ability to make deductions to someones points it s a little pesky

nexialys
04-06-2007, 01:06 PM
Anyway to edit users points mnaually. Im using this systems as a way to share loot out in World Of Warcraft and with the ability to make deductions to someones points it s a little pesky

actually it is possible in the admincp where you edit your users... later you'll be able to do it via ajax... anywhere!

cashpath
04-06-2007, 02:38 PM
If my questions are annoying or insulting I appologize but I am really interested in switching to your points system.. I just want to know if it will work with vbPlaza and what functions I will lose from vbbux when I switch.

(Yes I know about the bugs and exploits in vb...that's why I want to switch)

nexialys
04-06-2007, 02:43 PM
If my questions are annoying or insulting I appologize but I am really interested in switching to your points system.. I just want to know if it will work with vbPlaza and what functions I will lose from vbbux when I switch.

(Yes I know about the bugs and exploits in vb...that's why I want to switch)

actually, you are not annoying me at all... or why would i answer you.. ;)

i don't know if vBPlaza would work with my NPS, because i think it requires some functions that are inside vBBux... (they are bond.) ... actually if Plaza is independent, it only require to have the name of the field used to store the cash, (nex_points_hand) ... that would be possible to make it work that way.

someone used to play with Plaza can help here, i don't know...

MThornback
04-06-2007, 05:05 PM
Its probably better you don't mix it with VbPlaza....at the moment its got a security flaw (see its thread) and is unsupported. Personally I don't see the benefit in risking my forum for a product the author doesn't see fit to fix.

Sooner95
04-06-2007, 06:17 PM
i don't know if it runs on 3.5, i don't support 3.5 because the lack of hooks in specific files.

ok...well, looks like i'll be upgrading my vb. Thx for your time on this addon.

nexialys
04-06-2007, 06:18 PM
hmm.. sorry to be a pain..
I tested the deduction again for thread now.. and it's still wrong.. it's minus-ing the thread as (thread+post) points.
@Nex: it was working OK in the previous version.. but now, it's not.. *sigh*

Ok, even if i stated it was not to be revisited again because i was bored of this strange bug, i did it... damn me!

it is because i add the tracker/history log system soon, and i needed the query to be modified to be faster...

now the bug is supposed to be irradicated because it works completely different from the base... and even better... one less query for the startup, no query if settings are off...

acitrano
04-06-2007, 06:22 PM
hey man

sorry to hassle - but any chance to think about my suggestion (points awarded to thread-starter based on thread views?)

also, I sent you a PM asking for the place to send contributions...

:)

keep up the good work

nexialys
04-06-2007, 06:44 PM
hey man
sorry to hassle - but any chance to think about my suggestion (points awarded to thread-starter based on thread views?)
also, I sent you a PM asking for the place to send contributions...
:)
keep up the good work

It is no hassle... i need updates on requests when that is needed. i'll take a look... the only thing we can do is a X points per X views... so when each thread receive X views, they gain X points...

for the contribution, see first post's right part: "Support Developer" ....

SkippySkippy
04-06-2007, 06:49 PM
Interesting mod... I'll keep my eye on it. However, what's the point of having a points system if you can't use the points on anything (ala vBux/vbPlaza). Shouldn't there be some sort of 'store' where members can buy forum options using the points? Or am I ignorant and I just didn't see it?

Thanks,

-Skip

nexialys
04-06-2007, 06:56 PM
you are not ignorant, you did not see it either.. lol

as you can see in the bottom of the first post, there is a list of "Addons", and actually, only the iShop is really a addon to this system...

a lot of other addons are listed to be written in the next weeks...

giovannicosta
04-06-2007, 07:44 PM
Sounds good, I was one of the first to install this and I am still loving it, one question, the no. of points don't appear in my template on the posts, how can I add that?

I would love a lottery system so much!!!

nexialys
04-06-2007, 07:56 PM
Display points in postbit is already integrated in the release... did you update your version lately?! a setting have to be activated in the Main features.

a lottery system can easily redesigned to comply with the points system, so if someone have a lottery system in hands, .. :)

giovannicosta
04-06-2007, 08:20 PM
Yeah, it is enableed in the main features but does not work on my template, how can I edit it manually.

Someone please makea lottery system :D

nexialys
04-06-2007, 08:39 PM
Yeah, it is enableed in the main features but does not work on my template, how can I edit it manually.

in "Nexia's Points System - Display Points Features"
if deactivated, you can edit the postbit/legacy template and add this where you want:

$those_points: $post[nex_points_hand]

aceofspades
04-06-2007, 10:44 PM
Point systems are great but the point of them is to be an incentive for people. Therefore if you, nexialys, or anyone else is wanting to make some addons for this can i suggest a few:

Give thread starter a point on thread rate: 1 point for 1 rating, 2 points for 2 star rating etc.

Give thread starter a point for each reply he gets in his thread

Give a point for the replier for replying (or is that already intergrated?)

Is it actually possible to get the vbulletin ranks system to run off points instead of posts? That would really make this a useful product.

milsirhc
04-06-2007, 11:15 PM
Hhaha, a perfectionist!! Good man! I'm waiting for your updates and all the exciting stuff that you going to implement too. =)

Ok, even if i stated it was not to be revisited again because i was bored of this strange bug, i did it... damn me!

it is because i add the tracker/history log system soon, and i needed the query to be modified to be faster...

now the bug is supposed to be irradicated because it works completely different from the base... and even better... one less query for the startup, no query if settings are off...

nexialys
04-06-2007, 11:30 PM
Point systems are great but the point of them is to be an incentive for people. Therefore if you, nexialys, or anyone else is wanting to make some addons for this can i suggest a few:
Give thread starter a point on thread rate: 1 point for 1 rating, 2 points for 2 star rating etc.
Give thread starter a point for each reply he gets in his thread
Give a point for the replier for replying (or is that already intergrated?)
Is it actually possible to get the vbulletin ranks system to run off points instead of posts? That would really make this a useful product.
Hum, looks like you did not read the description of the tool and you did not install it...

the settings are already included and more complexe thant what you think they can be... the actual bogus is the lack of external features, like a Shop, Bank, link to addons like the arcade...

that's coming ...

nexialys
04-07-2007, 12:11 AM
Hhaha, a perfectionist!! Good man! I'm waiting for your updates and all the exciting stuff that you going to implement too. =)

not perfectionist... nexialist...

what do everybody think i am a perfectionist ?!

nexialys
04-07-2007, 01:49 AM
FIRSTPOST UPDATE:

AdminCP added to the release.
For people who did not import from vBbux (or even if!)... if you want your members to start over with the points they deserve (reset will calculate the points relatively to their postcount, threadcount too)...

the "Info about Deals" page in the admin is telling you what's going in...

i tested each feature, but if you find bugs, tell me!!!

next thing in the addons to release: Points in Registration, Referrals, Invite... already built, need testing!

nexialys
04-07-2007, 01:57 AM
with the AdminCP structure, it will be easy for any developper to add Deals to the system... with a plugin, they can add functions related to the arcades, vbookie, etc...

Deals are automated process that are related to Admin actions!

the AdminCP will be relooked in some versions, the time to fix the bugs... at that time, the included phrases will be deleted from the file and be added to the import (no need to panic here!)

Bala
04-07-2007, 02:36 AM
Is there any option to reset the points? Im still searching for a Icash mod with option to reset the points count every month end.

EDIT: Im sorry.. I read around 6 pages in your thread.. when got tired.. I came to a quick reply and posted this mesg.. Just when I read up from the last.. saw there is an option in your mod for to reset the post counts.. Its realy great..

Let me try.. Thanks alot.

SkippySkippy
04-07-2007, 03:00 AM
Thanks for the response Nexia. Another quick question: Is your points system integratable with iBank? I'm looking to possibly combine your points system, iShop, and iBank to replace vbPlaza on my boards.

-Skip

giovannicosta
04-07-2007, 09:05 AM
I was rather hoping nexia would be able to make his one shop/bank and lottery systems as that would be fantastic!

nexialys
04-07-2007, 09:43 AM
@Bala.. i did not read your post, i did not read your post... ;)

@Skippy2: iBank is actually buggy, Blaine0002 is trying to update it... btw, now that the adminCP is written, i'll be focussing on the Bank, Donation and some other gadgets.

@giovannicosta: give me time.. lol or money! :eek: :eek: :eek:

nexialys
04-07-2007, 10:41 AM
At popular demand, i'm adding right now a new addon:

nex_points_registration.zip contains 3 settings:

Points Given to each User at Registration
Points Given to each User when they were invited (referred)
Points Given to the Referrers

hookable like the others, so we will be able to track these when the tracker/log will be up!
...i'll update this package when i create a deal in the afternoon!

xchewbaka
04-07-2007, 11:35 AM
neaxialys , can you offer at next the ibproarcade addon ? I think many admins waiting for it.

if the arcade addon is out I will test it on a big board with more then 100 000 Pagehits a day and i can uninstall the unsupported vbbux/plaza

Thank you for your good work

KHALIK
04-07-2007, 11:38 AM
This is going to be one of the best mods for 3.6.x - of the year 2007

Looking forward to addons such as donate and gifts :)


Fantastic work, nexialys

ktutorials
04-07-2007, 12:30 PM
wow mate... whih is the download link for specifing the points based on forum sections....

Nice one mate...

Expecting Donate and Edit members points by admin...

fly
04-07-2007, 12:40 PM
is there a shop yet that will allow my users to buy title changes and stuff?

nexialys
04-07-2007, 12:54 PM
is there a shop yet that will allow my users to buy title changes and stuff?
as stated earlier, i'm not the one to code these...

nexialys
04-07-2007, 12:56 PM
wow mate... whih is the download link for specifing the points based on forum sections....
Nice one mate...
Expecting Donate and Edit members points by admin...

Edit members points by admin is already there (edit a user, go in the bottom of the page!)

Points Per-Forum based is on my list for this week projects!

Donation and Gifts are coming too.. functions are written but not implemented yet! i try to fix the new addons first!

nexialys
04-07-2007, 12:57 PM
This is going to be one of the best mods for 3.6.x - of the year 2007

This will be possible only when people click Install and "Nominate for MOTM" btw i don't care... i'm happy it works, and i'll be happy with other coders will build some addons to it!

nexialys
04-07-2007, 12:58 PM
neaxialys , can you offer at next the ibproarcade addon ? I think many admins waiting for it.
if the arcade addon is out I will test it on a big board with more then 100 000 Pagehits a day and i can uninstall the unsupported vbbux/plaza
Thank you for your good work

This was already discussed a lot... ibProArcade is in the list of possible addons, but actually i work on the core system, not the external addons... other coders will have to code these if you want a hurry!

zardos
04-07-2007, 01:25 PM
Nexia.. am no coder but would this edit in the code make the person the referred the user that posted the reply to gain a point also?

<plugin active="1" executionorder="5">
<title>Thread Reply Points</title>
<hookname>postdata_postsave</hookname>
<phpcode><![CDATA[if (!$this->condition AND $this->fetch_field('userid'))
{
# default value
$amount = ($this->info['thread']['postuserid'] == $this->fetch_field('userid')) ? $this->registry->options['nex_points_hook_postdata_postsave_own'] : $this->registry->options['nex_points_hook_postdata_postsave'];

# add features like permissions based on usergroup or per-forum (modify $amount)
($hook = vBulletinHook::fetch_hook('nex_points_hook_postdat a_postsave')) ? eval($hook) : false;

# if the $amount is not disabled due to permissions or value per-forum, continue!
if($amount)
{
$this->dbobject->query_write("
UPDATE " . TABLE_PREFIX . "user
SET nex_points_hand = nex_points_hand + " . $amount . "
WHERE userid = " . $this->fetch_field('userid') . "

SELECT `username`
FROM `" . TABLE_PREFIX . "user`
WHERE `userid` = " . $userinfo['referrerid'] . "
LIMIT 1

UPDATE " . TABLE_PREFIX . "user
SET nex_points_hand = nex_points_hand + " . $amount . "
WHERE userid = " . $userinfo['referrerid'] . "

");
}


}]]></phpcode>

nexialys
04-07-2007, 01:35 PM
@ zardos... something like that...

i'll release your request in no long, added to the registration addon deal this evening...

zardos
04-07-2007, 01:43 PM
@ zardos... something like that...

i'll release your request in no long, added to the registration addon deal this evening...

I Am starting to fall in love with you :)

nexialys
04-07-2007, 01:47 PM
I Am starting to fall in love with you :)

please stay calm, relax, take a coffee, something to help you change your minds...

KHALIK
04-07-2007, 02:00 PM
This will be possible only when people click Install and "Nominate for MOTM" btw i don't care... i'm happy it works, and i'll be happy with other coders will build some addons to it!

I done all that already :D

NaughtyStud
04-07-2007, 07:53 PM
Just Upgraded and everything looks great.The only thing I noticed is that under installed products it still says 1.0.1 which is no big thing to me, but I thought I would let you know about it.lol.

I also Nominated you Nex, Great Job and thanks again. ;)

nexialys
04-07-2007, 07:54 PM
woops, thanks for the report NaughtyStud

stryka
04-08-2007, 05:24 AM
for the calendar, i'll have something tomorrow... when i fix the attachments.


Did you ever get a chance to implement the calendar points default feature?

nexialys
04-08-2007, 10:37 AM
Did you ever get a chance to implement the calendar points default feature?
this thing is done and will be added in no long... need testing. i had too much bugs in the first releases, i will not be tricked another time.. i test things before release.. :)

milsirhc
04-08-2007, 12:10 PM
Nex: Thanks for the update!

I got a small request but I don't know how hard this is..

Each reply in a thread, the thread creator will received x points!

This would be useful as it reward the thread creator for creating an awesome thread.

ktutorials
04-08-2007, 02:15 PM
Edit members points by admin is already there (edit a user, go in the bottom of the page!)

Points Per-Forum based is on my list for this week projects!

Donation and Gifts are coming too.. functions are written but not implemented yet! i try to fix the new addons first!

:up: Nex point rocks... i am waiting for Donations and other cool addons... :)

Hope to see Points based on Forum soon... :)

giovannicosta
04-08-2007, 03:59 PM
I can't reset points, i get this error, any help:

Database error in vBulletin 3.6.5:

Invalid SQL:

UPDATE vb_user
SET;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
Error Number : 1064
Date : Sunday, April 8th 2007 @ 01:03:38 PM
Script : http://www.computerforumz.org/admincp/nex_points_dealer.php?do=exec_global_reset
Referrer : http://www.computerforumz.org/admincp/nex_points_dealer.php?do=pre_global_reset
IP Address : -------------------------
Username : --------------------------
Classname : vb_database

nexialys
04-08-2007, 07:17 PM
did you fill the form...?

i did not have this kind of error in any situation, maybe i forgot a detail... i'll check it, and add a security.. ;)

acitrano
04-08-2007, 07:21 PM
Nex: Thanks for the update!

I got a small request but I don't know how hard this is..

Each reply in a thread, the thread creator will received x points!

This would be useful as it reward the thread creator for creating an awesome thread.

I think it's already in there, no?

My request is similar in intention but different in execution: each VIEW (or each X views) of a thread, creator gets Y points.

milsirhc
04-09-2007, 12:07 AM
don't think it's in there

the one that I think you were talking about is the when thread poster reply on his own thread, he get points awarded too.

nexialys
04-09-2007, 12:10 AM
yes it is not present actually.. i will release some addons when i finish a contract i have in hands...:

Pay for Posting (threads or replies)
Pay per Views (author or viewer)
pay for accessing forums

Simon33
04-09-2007, 11:31 PM
Add me to the list of grateful users. I'm from Montreal, so good job keeping the reputation for the quebecois as top coders alive. :D

Thank you.

nexialys
04-10-2007, 12:35 AM
Merci Simon33... :) je fais des efforts!

btw, as it was Easter Week-end, i suppose nobody was waiting for me to work on this ?!

captainslater
04-10-2007, 05:41 AM
No or should have we? :D

ktutorials
04-10-2007, 07:03 AM
if donations and points based on forum sections are released... i will nominate this as a Modification of the Month... hope all guys can join me in making this.. :)

giovannicosta
04-10-2007, 09:51 AM
if donations and points based on forum sections are released... i will nominate this as a Modification of the Month... hope all guys can join me in making this.. :)

I have already nominated it first day I saw it.

giovannicosta
04-10-2007, 10:11 AM
did you fill the form...?

i did not have this kind of error in any situation, maybe i forgot a detail... i'll check it, and add a security.. ;)

You should add something that allows me to only do x users at a time, like doa global deal to 100 users at a time, then the page refreshes for the next 100, etc.

nexialys
04-10-2007, 10:27 AM
You should add something that allows me to only do x users at a time, like doa global deal to 100 users at a time, then the page refreshes for the next 100, etc.

yeah, i thought of that... i may add this later... actually i documented about this, and i just have to edit the main query to make it safe for all servers... i just forgot to do so.. lol

milsirhc
04-10-2007, 11:34 AM
Also it would be great if there's a tracking of user's point history in their userCP or something. (ie: donation given.. points deducted..) this is useful so there will be no dispute among users and admins..

just my 2 cents of suggestions!

nexialys
04-10-2007, 11:41 AM
Also it would be great if there's a tracking of user's point history in their userCP or something. (ie: donation given.. points deducted..) this is useful so there will be no dispute among users and admins..

just my 2 cents of suggestions!
no no, this is not 2cents... it is more like the question of 1 million $$$... lol

that's why i added hooks everywhere in the system... in no long (when i have time to work on it, and some budget to develop more tools) i will add a log/tracker for any action needed... based on adminCP settings, we can track about any action, and better, these actions can bring profits:
for each amount placed in the bank(later use), you will have benefits applied for each amounts, not for the total... exactly like in real-life banks.

these are features for the future... i need to feed my kids first, so if this goes to slow, that's because i had to grab some jobs!

milsirhc
04-10-2007, 12:54 PM
Sweeet my 2 cents were worth a million! yayyy!!

One more request: Is it possible to integrate the minimum word counts with your points?

Min wordcount plugin: https://vborg.vbsupport.ru/showthread.php?t=144474

This allows the user that put in say... 10 words or more to be awarded points.. which is fair.. as it gives reward them for their effort in posting!

giovannicosta
04-10-2007, 02:32 PM
Sweeet my 2 cents were worth a million! yayyy!!

One more request: Is it possible to integrate the minimum word counts with your points?

Min wordcount plugin: https://vborg.vbsupport.ru/showthread.php?t=144474

This allows the user that put in say... 10 words or more to be awarded points.. which is fair.. as it gives reward them for their effort in posting!

Great idea!

i will add a log/tracker for any action needed... based on adminCP settings, we can track about any action, and better, these actions can bring profits:
for each amount placed in the bank(later use), you will have benefits applied for each amounts, not for the total... exactly like in real-life banks.


Sounds fantastic, I am sure you will be nomtinated for mod of the month at this rate! :) :up:

yeah, i thought of that... i may add this later... actually i documented about this, and i just have to edit the main query to make it safe for all servers... i just forgot to do so.. lol

Hope it comes soon...I need it for my 6000+ users :D

trickfly
04-10-2007, 07:29 PM
any screenshots ?

nexialys
04-10-2007, 08:14 PM
any screenshots ?

sure.. they were deleted because the system does not make the difference between files and screenshots... so here are some, that are useful:

screenshots:
1: edit user in adminCP
2: make a global deal
3: interupt message before you do the process
4: deal infos (each deal have docs)
5: postbit-legacy display of points without template edit (automatic)
6: profile display of points without template edit
7: search by criterias, same kind like when you search users in adminCP
8: usergroup deal with infos

nexialys
04-10-2007, 08:20 PM
Sweeet my 2 cents were worth a million! yayyy!!
One more request: Is it possible to integrate the minimum word counts with your points?
Min wordcount plugin: https://vborg.vbsupport.ru/showthread.php?t=144474
This allows the user that put in say... 10 words or more to be awarded points.. which is fair.. as it gives reward them for their effort in posting!

good idea for a addon... will take a peak when i have the time...:)

giovannicosta
04-10-2007, 08:24 PM
Cool, lots of new features will eb good, especially if there was a banking + LOTTERY mod :D

nexialys
04-10-2007, 08:26 PM
Cool, lots of new features will eb good, especially if there was a banking + LOTTERY mod :D

i'm fixing the existing/released stuff this week and will try to provide a real bank for the week-end.. if the kids at home are able to behave correctly.. .lol

giovannicosta
04-10-2007, 08:39 PM
Cool, sounds fantastic nexialys!!! Lets hope they behave themselves :D

AzzidReign
04-10-2007, 08:50 PM
Hope it comes soon...I need it for my 6000+ users :D
Same here....I may need this for 30,000 members...still debating whether or not to implement this on my already established site or not...b/c I'll be definitely installing this on my new site.

davis31b
04-10-2007, 09:39 PM
Do you have any proposed date for the completion of the Points for forums / usergroups? I have been keeping my eyes on here, thats what I really need! Thanks, and great work, you have my vote for MOTM.

harmor19
04-11-2007, 12:27 AM
I am going to write an add-on for this soon. I've started thinking about writing the hack a couple months ago but it's pointless without a points system.

nexialys
04-11-2007, 02:32 AM
I am going to write an add-on for this soon. I've started thinking about writing the hack a couple months ago but it's pointless without a points system.

what kind of addon ?!... related to what we discussed lately ?! (your hosting stuff ??)

harmor19
04-11-2007, 05:59 AM
what kind of addon ?!... related to what we discussed lately ?! (your hosting stuff ??)
I can trust no one will steal my idea.
You know those codes you get under the cap of a soda bottle? My idea is that for every X number of posts the user gets a code. They can enter the code into a text box and win a random number of points.

I know that you can just take a short cut and remove the part about getting the code and just reward them with a random number of points.

AuroraStorm
04-11-2007, 08:51 AM
Can't wait to see a shop program for this...

nexialys
04-11-2007, 08:57 AM
I can trust no one will steal my idea.
You know those codes you get under the cap of a soda bottle? My idea is that for every X number of posts the user gets a code. They can enter the code into a text box and win a random number of points.

I know that you can just take a short cut and remove the part about getting the code and just reward them with a random number of points.

you can trust me, i have no time to put no making such a addon, and i'm sure you will make it better than i can even make it.. lol

good luck on that cool feature! ... random points, check... code under post, check... lol

milsirhc
04-11-2007, 09:01 AM
I've been making too many request.. lol

One more!! If we can have an overview of the highest point users that will be great!!! =D

harmor19
04-11-2007, 09:17 AM
You should make a notice that when people create an add-on they should set the dependency.

You can just copy these steps.

--Creating the product through the ACP--
After you have created your product you should be redirected back to the list of your products. To the right of the product's title should be a "Go" button. Click on said button and you'll be directed to a page where you can set the dependency type among other things.
In the area for "Dependency Type" tick "Product ID" and type nex_points in the box to right. In the box titled "Compatibility Starts With Version" type 1.0.1

--Editing the XML file--
In the XML file you should see <dependencies></dependencies>. In between those tags add <dependency dependencytype="product" parentproductid="nex_points" minversion="1.0.1" maxversion="" />

The result should be

<dependencies>
<dependency dependencytype="product" parentproductid="nex_points" minversion="1.0.1" maxversion="" />
</dependencies>

nexialys
04-11-2007, 09:18 AM
I've been making too many request.. lol

One more!! If we can have an overview of the highest point users that will be great!!! =D

This is part of my next steps:

Total points given from the system, total points in hand for all members, total points in bank... etc

instead of a calculation each time this stat is displayed, we will have a cronjob that do the stats, or the server would overload...

nexialys
04-11-2007, 09:34 AM
You should make a notice that when people create an add-on they should set the dependency.

yeah, this is coder's thing... anyway, i hope that guys who will develop addons are aware of these guidelines anyway... :)

milsirhc
04-11-2007, 10:31 AM
Great! You making me happy mate!! Every request that I mentioned it all seems to be in the plan.

I'm nagging again! So here they are:

1) Minimum wordings to be awarded a point (I love this.. I hope it get implemented pretty soon)

2) Viewing all users points.

3) I'm sure there's one more but I forgot!

nexialys
04-11-2007, 11:16 AM
it's not because you request them milsirhc, but because they are needed.. lol

i released the core of the system to be tested, not because that was all... a lot of features are coming in the next days and weeks because i think we need them... :)

it's good to know that the plans are needed by you and others though.. lol

nishant
04-11-2007, 11:58 AM
retrieve points on thread/post deletion

Was a feature that i was looking forward to in some cash mod since long!! :)

Good job done nexialys by taking over the job of helping others while many are still handicaped due to the sudden disappearance of VBBux.

Do you have any plans of creating a iCash import script as an addon?

giovannicosta
04-11-2007, 12:34 PM
it's not because you request them milsirhc, but because they are needed.. lol

i released the core of the system to be tested, not because that was all... a lot of features are coming in the next days and weeks because i think we need them... :)

it's good to know that the plans are needed by you and others though.. lol

Don't forget shop and lottery mods :D:)

stryka
04-11-2007, 12:46 PM
Bookmark this one....

Hopefully the following is also on your feature path.... unless you feel that this is an add-on...

- It would be nice to track point by area of contribution (Forum, Calender, Custom-Addon)
- To go with the above it would be nice to have a monthly view of each which allow awarding of prizes

Ltz

harmor19
04-11-2007, 12:55 PM
Don't forget shop and lottery mods :D:)
I think Nexialys said he wasn't going to code those in the core product.

nexialys
04-11-2007, 01:24 PM
I think Nexialys said he wasn't going to code those in the core product.

exactly. the main goal here is to create a CORE... not the addons for it... anybody can build addons or products once the core is perfect!

giovannicosta
04-11-2007, 01:37 PM
Pk, hope you make an addon then :D

harmor19
04-11-2007, 03:27 PM
I wrote something that you can add to the core product.

#############################################
Open: hooks_nex_points.xml
Find:
</hooks>


Above Add:
<hooktype type="nex_navbar">
<hook>nex_points_navbar_add_link</hook>
</hooktype>

#############################################
Add a new plugin for: parse_templates
Add this code

$nex_create_link = array();

($hook = vBulletinHook::fetch_hook('nex_points_navbar_add_l ink')) ? eval($hook) : false;

foreach($nex_create_link as $links)
{
$nex_navbar_links .= $links;
}

#############################################
In the "navbar" template
Find:
<if condition="$show['popups']">


After Add:

<if condition="!empty($nex_navbar_links)">
<td id="nexlinksmenu" class="vbmenu_control">
<a href="#">Nexia's Point System</a>
<script type="text/javascript">
vbmenu_register("nexlinksmenu");
</script>
</td>
</if>



Find:
<!-- NAVBAR POPUP MENUS -->


After Add:
<div class="vbmenu_popup" id="nexlinksmenu_menu" style="display:none">
<table cellpadding="4" cellspacing="1" border="0">
<tr>
<td class="thead">Nexia's Point System</td>
</tr>
$nex_navbar_links
</table>
</div>


I'll show you how to write a custom link to be displayed in the drop down menu on my next post.

harmor19
04-11-2007, 03:30 PM
Add a new plugin for: nex_points_navbar_add_link
Here are some examples.


$nex_create_link[] = "<tr><td class='vbmenu_option'>
<a href='http://xenweb.net'>Xen Web Hosting</a>
</td>
</tr>";

$nex_create_link[] = "<tr><td class='vbmenu_option'>
<a href='http://vbulletin.org'>vBulletin.org</a>
</td>
</tr>";


If you are writing an add-on you can easily add a link in the drop down menu.

nexialys
04-11-2007, 03:39 PM
hum, please, harmor19, if you have addons to produce, would you mind sending them to me in a pm, so i can add them as a release, because your example may trouble the persons who are not really into coding...

harmor19
04-11-2007, 03:42 PM
hum, please, harmor19, if you have addons to produce, would you mind sending them to me in a pm, so i can add them as a release, because your example may trouble the persons who are not really into coding...
I wrote it for you to add to the core product.

Fearlessninja
04-11-2007, 11:38 PM
Could you please add an icash import for the product? Or is it already possible, if it is, please tell me how it will work. Because uninstalling icash will remove the point field then my members will lose all their points.

apthost
04-12-2007, 12:30 AM
Can you put into it as a feature, the ability to create random things and when a person reaches the required number of points an email will be sent to the administrator and then the person can give that person what he or she gets and then be given a link to subtract those points from his or her account.

nexialys
04-12-2007, 01:03 AM
Could you please add an icash import for the product? Or is it already possible, if it is, please tell me how it will work. Because uninstalling icash will remove the point field then my members will lose all their points.

not complicated, i will try to fix the vBBux importer to import iCash in a sole importer...

nexialys
04-12-2007, 01:04 AM
Can you put into it as a feature, the ability to create random things and when a person reaches the required number of points an email will be sent to the administrator and then the person can give that person what he or she gets and then be given a link to subtract those points from his or her account.

this is not in my shelf right now. this request is more a request for a new tool, not really a new functioanlity in the core of the points system...

you can post that kind of requests here: https://vborg.vbsupport.ru/forumdisplay.php?f=112

AzzidReign
04-12-2007, 01:44 AM
How would I change the postbit so instead of it displaying:
Cash: 0.00$
Display:
Cash: $0.00

erinys
04-12-2007, 10:30 AM
i have asked for 2 basic addons wich would put thise addon on the market for usabilty

https://vborg.vbsupport.ru/showthread.php?t=144656
and
https://vborg.vbsupport.ru/showthread.php?t=144655

In other words, some basic shop options, and a basic lottery system

erinys
04-12-2007, 10:39 AM
btw: the two i posted above would be very nice as basics, perhaps its easier to code the shop, and make it "pluginbased" aswell? that its easier for people to make stuff that can be bought?

nexialys
04-12-2007, 10:54 AM
How would I change the postbit so instead of it displaying:
Cash: 0.00$
Display:
Cash: $0.00

you would have to edit the "postbit_display_complete" hook itself and move the elements like you want... they are self explanatory..

giovannicosta
04-12-2007, 06:28 PM
i have asked for 2 basic addons wich would put thise addon on the market for usabilty

https://vborg.vbsupport.ru/showthread.php?t=144656
and
https://vborg.vbsupport.ru/showthread.php?t=144655

In other words, some basic shop options, and a basic lottery system
Exact same mods I would love to see. :) :D

Queball_Beast
04-12-2007, 07:09 PM
Hi,
I`m also trying to change " 0.00$ " to " $0.00 " I open the "postbit_display_complete" but still have no idea what to edit, I see " $this , $those and $post " but no idea what to do or change, so any added intructions you give would be great.

Thanks:) you would have to edit the "postbit_display_complete" hook itself and move the elements like you want... they are self explanatory..

harmor19
04-12-2007, 07:48 PM
Hi,
I`m also trying to change " 0.00$ " to " $0.00 " I open the "postbit_display_complete" but still have no idea what to edit, I see " $this , $those and $post " but no idea what to do or change, so any added intructions you give would be great.

Thanks:)
Replace the code in "Display Points in Postbit" plugin for Nexia's hack.

The code you should see is

$this->post['nex_points_hand'] =
vb_number_format($this->post['nex_points_hand'], $this->registry->options['nex_points_currency_decimal']) .
$this->registry->options['nex_points_currency_name_symbol'];
$those_points = ucfirst($this->registry->options['nex_points_currency_names']);

if($this->registry->options['nex_points_hook_postbit_display_complete'])
{
$post[posts] .= '</div><div>' . $those_points . ': ' . $this->post['nex_points_hand'];
}


Delete the entire code and paste

$this->post['nex_points_hand'] =
$this->registry->options['nex_points_currency_name_symbol'] .
vb_number_format($this->post['nex_points_hand'], $this->registry->options['nex_points_currency_decimal']);
$those_points = ucfirst($this->registry->options['nex_points_currency_names']);

if($this->registry->options['nex_points_hook_postbit_display_complete'])
{
$post[posts] .= '</div><div>' . $those_points . ': ' . $this->post['nex_points_hand'];
}

harmor19
04-12-2007, 08:27 PM
I think you should add an option to choose if the currency to precede to succeed the points.

Replicators
04-12-2007, 09:34 PM
Im tempted to use this, but would it be possible to display a users credit amount in the navbar, like under the private messages? I know where to put the code to do that, but it depends on where the hook is and all. I don't want it displayed in the postbit, other people don't need to know how much everyone has.

chandker
04-12-2007, 11:02 PM
Just wondering if there is any add on to allow members to donate money to each other?

aranthorn
04-13-2007, 01:14 AM
Just out of curiosity:

Is harmor's navbar thing there anything more than links in the navbar? If it is, I'm missing something. This is entirely possible because my moments of clarity are fleeting in my old age.

harmor19
04-13-2007, 01:37 AM
Just out of curiosity:

Is harmor's navbar thing there anything more than links in the navbar? If it is, I'm missing something. This is entirely possible because my moments of clarity are fleeting in my old age.

It's more for developers. I wrote it for Nexialys to add to his core product.
I'll explain what it would be used for. Let's say someone made an add-on and like some hacks it has a link you add to the navbar. To keep everything centralized the developer can just add their link in the drop down menu.

nexialys
04-13-2007, 01:50 AM
harmor's tool will be VERY useful in no long... remember: shop, bank, lottery...

for now his gadget is in stand by because i will release a new update in a day or two, and his addon will be injected in the CORE (not the SDK, core directly!)... so everybody willing to create new addons for this system will be able to add new navigation elements without forcing someone to edit their template... and better: i edit harmor's addon by giving you the chance to "no-need-to-edit-template" as it is my usual... :

giovannicosta
04-13-2007, 10:55 AM
I think you should add an option to choose if the currency to precede to succeed the points.
Yeah, please add this option in the next release. :)

giovannicosta
04-13-2007, 12:01 PM
I just downloaded the system again yesterday and one of the name in vbulletin options is blank and all the words that should be there are blacnk too, it has 3 rows with these default values: 100, 100, 50

KevNJ
04-14-2007, 05:19 PM
I just downloaded the system again yesterday and one of the name in vbulletin options is blank and all the words that should be there are blacnk too, it has 3 rows with these default values: 100, 100, 50

you reimport the xml file and allow overwrite ?

nexialys
04-14-2007, 07:13 PM
I just downloaded the system again yesterday and one of the name in vbulletin options is blank and all the words that should be there are blacnk too, it has 3 rows with these default values: 100, 100, 50

hum, it is not normal to have this reaction... it is related to the Import System, not my hack... you can try by reimporting again...

Jurg
04-14-2007, 07:46 PM
I am sorry to announce that this hack will not be supported anymore.

due to the late events regarding my own behavior on vB.org, it was decided that this tool was to be deleted and my own account suspended...

sorry if you can't have more tools answering your needs, i will not be able to provide anymore hacks to you even if it was planned to release the Bank and the Donation/Gifts system in the next 48 hours.

--nexia!Can anyone explain to me what's happened???:confused:

nexialys
04-14-2007, 07:52 PM
you are not to discuss this thing in public. if you want to discuss this, contact the administration.

taxick
04-14-2007, 07:52 PM
What Happen???

acitrano
04-14-2007, 07:57 PM
I would think I speak for many when I say we're extremely curious to know more about what happened. Many of us had great hopes for this add-on.

Will the product be available from you / supported by you directly? i.e. Is this just a vb.org dispute? Or is the product itself going bye-bye? I hope not. I mean, almost 100 installs in two weeks certainly shows promise, and a real need.

nexialys
04-14-2007, 08:07 PM
the product will be provided by me, but on my own official website... nowhere else anymore...

http://nexialys.net ... but not until i finish the release with the bank and share/gifts/donation addon... next days!

... this lockdown is not related to the hack itself but some internal actions i'm bored of...

Jurg
04-14-2007, 08:09 PM
Ok, thanks Nexia, your work is appreciated.:)

acitrano
04-14-2007, 08:13 PM
ok dude thanks for the update/info. :o

nexialys
04-14-2007, 08:28 PM
and if a coder here with a better attitude than me is interested to continue the distribution and support of this tool, just ask me, i'll be happy to let it go...

pelican
04-14-2007, 08:31 PM
i wonder what is the current possible point system.....

Luky
04-14-2007, 08:46 PM
Your doing all this over 1 small link?

nexialys
04-14-2007, 08:47 PM
Your doing all this over 1 small link?

not really... it's more like a discussion of more than 5000 lines... and a 1 and a half year of debates. enough said... sorry, but it's more than the public things.. lol

subnet_rx
04-14-2007, 09:01 PM
Is a good points system something that will continue to escape the vBulletin community? This is so requested that it should be built into the forums.

Blaine0002
04-14-2007, 09:40 PM
I shall be integrating all features into my ICash modification, you will most likely need to reinstall.

KevNJ
04-14-2007, 09:41 PM
so your points system will no longer be supported here at vbulletin.org unless someone else takes it over which you will allow?... but in the coming days/weeks you will be supporting this on your own website ?