Referal Points

[Maniakc]

I wanna be able to give 1000 points to all the people who refer someone else, but I'm too lazy to do it every time. Is there any plan to add this in a future version of SMF Shop? With the list of people who've been referred and how many points they received from the referrals. Maybe in the next release? I've tried the affiliates mod, but I don't wanna use that because its confusing with the $ thing. Might there be a way to modify the points from the affiliates mod to go with the shop points? Anyway, this is something I'd like to see happen if anyone is up for this job, or if you, Daniel15, want to add it to the next version. It would be the best thing to help get members!

[feeble]

is this what you are refering to?

http://www.daniel15.com/forum/index.php/topic,580.0.html

[Maniakc]

That is kinda what I meant, but when I try to install it in the package manager, I get this:

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 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 11
File: /home/content/m/a/n/maniakc/html/forums/Packages/temp/db.php
Line: 16

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.

Im gonna try the upgrade.php thing...

EDIT: Ok, now it shows that message without the "Note" thing...

[Daniel15]

That is kinda what I meant, but when I try to install it in the package manager, I get this:

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 'DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci' at line 11
File: /home/content/m/a/n/maniakc/html/forums/Packages/temp/db.php
Line: 16

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 1.1.2, while your database is at version 1.1.1. The above error might possibly go away if you execute the latest version of upgrade.php.

Im gonna try the upgrade.php thing...

EDIT: Ok, now it shows that message without the "Note" thing...

Was that for the Invites mod? If so, you'll need to ask the author to fix their install script. You're using an old version of MySQL (probably 4.0), which doesn't support some features.

[Maniakc]

Yea, I am using 4.0 I checked my CPanel. Well, I hope the author fixes this to support older SQL or my host upgrades!

[Daniel15]

You could try this: In the db.php file, find the

Code: [Select]

DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci
bit (it will be at the end of a query), and remove it. This should work...

Although, your host should really upgrade (4.1 has been standard for a long time, and 5.0 is becoming standard now )