Member Awards (2.0 Compatible!)

[Mr_JimWest]

what do i do with..

its the Installation Instructions for 1.1.7....

i dont get what i have to do at all 

Code Select Expand

This file should not be able to execute standalone. You may have to run the following queries manually.


Query: [Select]

CREATE TABLE IF NOT EXISTS {$db_prefix}awards_members
(
ID_AWARD_MEMBER int(8) unsigned NOT NULL DEFAULT '0',
ID_AWARD BIGINT(10) UNSIGNED NOT NULL DEFAULT '0',
ID_MEMBER INT(8) UNSIGNED NOT NULL DEFAULT '0',
dateReceived DATE NOT NULL DEFAULT '0001-01-01',
favorite TINYINT(4) UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY ID_AWARD_MEMBER (ID_AWARD_MEMBER),
KEY ID_AWARD (ID_AWARD)
)
Query: [Select]

CREATE TABLE IF NOT EXISTS {$db_prefix}awards
(
ID_AWARD MEDIUMINT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,
awardName VARCHAR(80) NOT NULL DEFAULT '',
gameName VARCHAR(80) NOT NULL DEFAULT '',
timeAdded INT(10) UNSIGNED NOT NULL DEFAULT '0',
filename TINYTEXT NOT NULL DEFAULT '',
width MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0',
height MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT '0'
)
Query: [Select]

REPLACE INTO {$db_prefix}settings
(variable, value)
VALUES
('pa_awardsDir', 'awards'),
('pa_columns', 4),
('pa_rows', 5),
('pa_favorites', 1)

[Fustrate]

That is an SQL query. It should be run in something like phpMyAdmin.

[Mr_JimWest]

how - is my question i guess then....

i have phpMyAdmin....but...have no idea how to do that stuff

[Fustrate]

Open phpMyAdmin, go to your database (i.e. forum_db) in the dropdown box, and click on a table name (i.e. smf_members). Click "Browse", then find [Edit] and click it. You should get a big text field. Replace {$db_prefix} with your forum's prefix (default is 'smf_')  and put the whole query in the box.

I would just give you a file to run, but I was editing it this morning for a new version which doesn't use the same column names. Sorry

[mrmiyagi]

Hi,

Sorry to be a pain in the backside but when installing my awards this error come up!

7.     Execute Modification     ./Themes/default/index.template.php     Test failed

[Fustrate]

1.1.x or 2.0?

[MaNaRa]

i have "Day Of Defeat" theme, this is the link: http://custom.simplemachines.org/themes/index.php?lemma=441
and my smf version is the 1.1.7 but I do not know how to put the awards up to the signature, I tried several codes in the display template.php but I did not the solution.
Anyone can help me? I need to put the awards up to the signature 

[Fustrate]

Do you mean it's already showing, but you want it to be somewhere else, or it's not even showing on the page?

[MaNaRa]

No, I do not awards shows or in the default theme that I have neither the default position, the Day of Defeat

(sorry my english)

[Fustrate]

Attach your theme's Display.template.php file to a post here, and I'll put the code in for you.

[MaNaRa]

Here is
thanks in advance

[MaNaRa]

and this is the default theme

[OperationMagic]

Where is it supposed the tab supposed to be? I use 1.1.7.

Here is a screen shot.

[Fustrate]

What language are you using? Did the language edits get made to /Themes/default/languages/Modifications.{your language}.php?

[D3N1553]

I've seen you have patience with support XDD... anyway

Thank you, the mod is working 100% in my site... im using a cusotimized core SMF template... and spanish_es... I've translated almost everything of your mod... but im a little lazy to upload..maybe another day.

Anyway, I dont have any problems... the mod is showing where it;s supposed to be... but I want to display a single award (or multimple... maybe) under  user's avatar. I've used the search in this board but I didnt find useful information... I guess I'll have a look through these 52 pages, but It would be amazing if you help me with that.

[mrmiyagi]

1.1.x or 2.0?

1.1.7 i have and used 1.1.x download

[Mr_JimWest]

This is driving me nuts, I have been trying to work on this for weeks – and nothing is working! 

SMF: 1.1.7
Template: Custom (based off "luckycharms")
Install: Manual

-   I followed these instructions, "Member Awards - Installation Instructions for 1.1.7" and put "ManageAwards.php", "ManageAwards.template.php","award.gif", and "ManageAwards.english.php" wher they are suppose to go - i did not run the install.

Problems:

-   None of the test shows up, so I have blank spaces all around my forums where it is suppose to say "Awards" or w/e.
-   If I click on the awards image, it takes me to the user profile with a big blank space.


Now, could this be a result of my database not being set up? I wouldn't think so, you would think it would still say "awards" and stuff – even if my databases where perfect! I didn't set them up yet because of lack of knowledge of how to do so.

Open phpMyAdmin, go to your database (i.e. forum_db) in the dropdown box, and click on a table name (i.e. smf_members). Click "Browse", then find [Edit] and click it. You should get a big text field. Replace {$db_prefix} with your forum's prefix (default is 'smf_')  and put the whole query in the box.

For one, you keep using (i.e.) - so should I use those exact examples (if not) - what should I use - (if unknown) - how can I figure it out? Do I put all of the query that I quoted above in? Second, how can I figure out me forum's prefix?

If you want to help me, I need really good instructions (because I am an idiot)



Thanks for your help.....

[HR]

IF (and if i recall you were) making use of the ultimate profile member awards addition for profile.template.php is a function. Because that is there you cant have it in the ultimate profile as well. Oddly enough you cant just remove it from profile.template and use it in ultimate.profile because it fails to show at all.

I did pick and poke and find a way to display the information in the ultimate profile and the returned number acts as a link to the awards page but that is about it
Ref Link:
http://www.simplemachines.org/community/index.php?topic=114701.msg1849790#msg1849790

[Mr_JimWest]

IF (and if i recall you were) making use of the ultimate profile member awards addition for profile.template.php is a function. Because that is there you cant have it in the ultimate profile as well. Oddly enough you cant just remove it from profile.template and use it in ultimate.profile because it fails to show at all.

I did pick and poke and find a way to display the information in the ultimate profile and the returned number acts as a link to the awards page but that is about it
Ref Link:
http://www.simplemachines.org/community/index.php?topic=114701.msg1849790#msg1849790

I cant find UltimateProfile.template.php   -   only   -   profile.php   -   wher can i find the other one?

[HR]

Would be in Themes/default/UltimateProfile.template.php