End-User Options - Secret Admirer / Crush System

No longer supported by the author.

[carolmyt]

Well, mine installed just fine, with just one strange problem: the first time you click to send admiration, you get the duplicate phrase. I've double checked the code, and its all correct. Any ideas why this is happening?

You know, I think I may know what the problem is: I missed "NOTE: You must replace TABLE_PREFIX with the prefix that you use on your VB3
installation... OR remove it if you are not using a table_prefix." So . . . can somebody explain that to me? I'm new to the SQL queries. How do I know if I'm using a table prefix, and if I am, what it is?

[buro9]

Originally Posted by carolmyt

Well, mine installed just fine, with just one strange problem: the first time you click to send admiration, you get the duplicate phrase. I've double checked the code, and its all correct. Any ideas why this is happening?

You know, I think I may know what the problem is: I missed "NOTE: You must replace TABLE_PREFIX with the prefix that you use on your VB3
installation... OR remove it if you are not using a table_prefix." So . . . can somebody explain that to me? I'm new to the SQL queries. How do I know if I'm using a table prefix, and if I am, what it is?

Good good, just got the email notification and thought... nope... not installed correctly.

The hack cunningly uses MySql trickery to detect duplicates... the trickery is that when two identical rows get inserted it causes an error. I detect the error and that's how I know that an admiration already exists.

However, it means I am basically masking MySql errors.

Anyhow... table prefix.

In your /includes/config.php file there is a bit that looks like this:

// Prefix that your vBulletin tables have in the database.
// For example: $tableprefix = 'vb3_';
$tableprefix = 'vb3_';

Now, in my instructions I ask you to do this:

DATABASE WORK

In phpMyAdmin or from the MySql command line, run the applicable piece of SQL.
NOTE: You must replace TABLE_PREFIX with the prefix that you use on your VB3
installation... OR remove it if you are not using a table_prefix.

FOR A FRESH INSTALL:

  CREATE TABLE TABLE_PREFIXsecretadmirer (
    userid INT(10) NOT NULL,
    admiresuserid INT(10) NOT NULL,
    datecreated INT(10) NOT NULL,
    PRIMARY KEY (userid, admiresuserid),
    KEY admiresuserid_ix (admiresuserid),
    KEY userid_ix (userid)
  ) TYPE = MYISAM;

FOR AN UPGRADE FROM A VB2 VERSION:

RENAME TABLE secret_admirer TO TABLE_PREFIXsecretadmirer;

Because you are a new install you are doing the CREATE TABLE bit.

Now, in that CREATE TABLE bit the first line says:

  CREATE TABLE TABLE_PREFIXsecretadmirer (

If your $tableprefix in your config.php file was blank (''), then that should be:

  CREATE TABLE secretadmirer (

If your $tableprefix in your config.php file contained vb3_ ('vb3_'), then that should be:

  CREATE TABLE vb3_secretadmirer (

So whatever your table prefix is... adjust the name of the database table to be created accordingly.

You only need to do this once, in that piece of SQL. The script can work it out when running, but because I didn't build an installer, I couldn't work out whether you have a table prefix.

Oh, and you will also want to run this which will delete the table that you made by accident:

  DROP TABLE TABLE_PREFIXsecretadmirer;

Hope that all makes sense to you

[carolmyt]

Perfectly clear, and now running perfectly! Many thanks!

[docvader]

Buro, I've looked in my phpadmin, and found a table called "TABLE_PREFIXsecretadmirer". Now, I have no table prefixes in my config file, so I'm not sure how this got created. And, the hack is working fine.

Suggestions???

[buro9]

Originally Posted by docvader

Buro, I've looked in my phpadmin, and found a table called "TABLE_PREFIXsecretadmirer". Now, I have no table prefixes in my config file, so I'm not sure how this got created. And, the hack is working fine.

Suggestions???

See two posts above.

You must've run the SQL and then modified it to remove the TABLE_PREFIX bit and then ran it again. So just deleted the unused table

[carolmyt]

Would it be possible to make this feature accessible from the user's postbit? So if you wanted to register admiration, you wouldn't have to go to the profile.

[Wifey]

Okay here's my problem.

No longer have the blank page problem - for some reason when I FTPed the file it didn't come up with the entire code. Who knows.

Anyhow, the PM's aren't sending like they're supposed to and neither are the e-mails.

Any idea?

[buro9]

Originally Posted by ashkarita

Okay here's my problem.

No longer have the blank page problem - for some reason when I FTPed the file it didn't come up with the entire code. Who knows.

Anyhow, the PM's aren't sending like they're supposed to and neither are the e-mails.

Any idea?

Check the install guide again and verify that you did everything.

Note these bits:

PHRASE WORK:

Under the phrase type: Front-End Redirect Messages

Add these phrases:

secretadmirer_acknowledged
  Your admiration for that user has been successfully registered.

secretadmirer_duplicate
  You've already registered your admiration for that user.<br/> Maybe it's time to PM them and let them know you like them?

secretadmirer_report_sent
  Your secret admirer report has been dispatched to your registered e-mail address.

secretadmirer_limit
  Sorry! You may only admire a maximum of 5 people within the last month.

[buro9]

Originally Posted by ashkarita

Okay here's my problem.

No longer have the blank page problem - for some reason when I FTPed the file it didn't come up with the entire code. Who knows.

Anyhow, the PM's aren't sending like they're supposed to and neither are the e-mails.

Any idea?

Ooops. I replied above to the other problem

Check that you created the templates:

TEMPLATE WORK

For each of the text files, you need to add it as a template of the same name.
Change the values within them to match your forum and personal preference :)
There are five in total:

  secret_admirer_alert_email
  secret_admirer_alert_pm
  secret_admirer_match_email
  secret_admirer_match_pm
  secret_admirer_report_email

The text files are in the install Zip file.

[buro9]

Originally Posted by carolmyt

Would it be possible to make this feature accessible from the user's postbit? So if you wanted to register admiration, you wouldn't have to go to the profile.

Yup, you just need to add the link:

<a href="profile.php?$session[sessionurl]do=admire&amp;userid=$userinfo[userid]">Register your admiration for $userinfo[username]</a>

You may need to check and change the $userinfo array name to match that of the post... but effectively you should add the above link to the relevant part of the postbit or postbit_legacy templates.