PDA

View Full Version : [HTL] & [TXT] Awards/Medals/Cards Hack [vB3]


Pages : 1 [2]

miker_316
06-23-2004, 02:16 AM
Ah yes, I wasn't thinking clearly enough and forget the condition. The correct way to do it is to replace it with...

<if condition="$post['userawards']">Earned Awards:<br /><div>$post[userawards]</div></if>

I tested it out and this way works like you want. My apologies. I also edited my original reply so as not to confuse anyone. :)

WoodiE
06-23-2004, 04:24 AM
miker 316 - You're awesome man, worked perfectly!

-Michael

dssart
06-28-2004, 09:30 AM
I'm also ready to install this onto 3.01, anyone have any problems with 3.01?

Another dumb question...when VBulletin issues updates and I install them, what do I do to prevent the new updates from overwriting my installation of this hack? Do I need to backup the templates or something else?

Thanks AnimeWebby..you've really put alot of work into this and I appreciate it. If you have a PayPal account please PM me your email and I will send you a donation once I get this up and running.

wcbryant
06-28-2004, 07:00 PM
I installed this some time ago, I have a site where the community drives 90% of the content, so I wanted something to acknowledge the people who contribute materially either with content, or by our semi-annual fundraisers.

Recently, I decided to also use this as a system to flag people who are on XBoxLive or PS2Online, to make it easy for them to set up games. I have a college football focused site, but with EA Sport's NCAA 2005 title being online for both consoles, there's a significant enough level of interest from the users that I'm going to support it on the site level.

My question is this... Has anyone figured out a way, could an add-on be developed, or might a future version include a way to generate user lists for specific medals?

I'd love to have the little Xbox logo/'award' link to a page that lists everyone with that award. Ditto for the PS2 logo. As is, I have it set up to display people's gamertags on the mouseover, but a centralized 'roster' of people with the specific award/logo would be even more helpful.

turbidblue
06-30-2004, 08:06 PM
I tryed to install this via the hack tracking log, got to step three and this error occured...

********************

Invalid SQL: CREATE TABLE award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 7

mysql error number: 1064

****************

I am using vB 3.0.1

Any help?

Thanks :)

Wolffman
07-01-2004, 02:08 AM
I'm using vB 3.0.1. When I ran the uninstall script, I got this error:

Invalid SQL:
SELECT
userfield.*, usertextfield.*, useraward.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 14

mysql error: Table 'afceyri_forums.useraward' doesn't exist

mysql error number: 1146

This is VERY urgent because my forums are down because of it. Any help is very greatly appreciated.

Cheeko
07-01-2004, 12:00 PM
hmm.. i just installed this hack, seems ok except for some reason the awards arent showing up on the post bit...

Polo
07-02-2004, 01:05 AM
Is this hack compatible with vb3.0.1?

Oldfart
07-02-2004, 08:04 AM
This hack works fine on vb301 you just have to make sure you follow the instructions very carefully. Especially the file and template edits. I've installed it 3 or 4 times on different boards so far.

Polo
07-02-2004, 12:14 PM
oh ok, i will install it then. Thank you.

turbidblue
07-02-2004, 04:01 PM
this may sound really dumb, but how does one run an installer via the hack tracking log?

i cannot figure this out!

please help :)

dssart
07-03-2004, 12:49 PM
Well, I installed this last nite, paying particular attention to the manual edits to all the .php and template edits ( all 15 or so..ugh ) and after all that, I load up my admincp and get the "There is a new version of VBulletin"...so, I carefully looked through the list of changed files in VB 3.0.2, and noticed two templates had to be reverted, postbit and postbit_legacy. No problem, so I looked through the list of changed .php files and noticed that all of the files I had just edited were changed. I thought, no problem, I'll just go back and re-edit them. Then I thought, how am I going to re-edit the files? all the necessary changes were given at the end of the installation process. I finally uninstalled it all. Is there an easier way to do this? Is there a more automatic way to re-apply the hack script in the event of a VBulletin update? I really don't want to have to edit 15 templates/php files every VBulletin update.

JamesFrost
07-05-2004, 07:30 AM
Well, I installed this last nite, paying particular attention to the manual edits to all the .php and template edits ( all 15 or so..ugh ) and after all that, I load up my admincp and get the "There is a new version of VBulletin"...so, I carefully looked through the list of changed files in VB 3.0.2, and noticed two templates had to be reverted, postbit and postbit_legacy. No problem, so I looked through the list of changed .php files and noticed that all of the files I had just edited were changed. I thought, no problem, I'll just go back and re-edit them. Then I thought, how am I going to re-edit the files? all the necessary changes were given at the end of the installation process. I finally uninstalled it all. Is there an easier way to do this? Is there a more automatic way to re-apply the hack script in the event of a VBulletin update? I really don't want to have to edit 15 templates/php files every VBulletin update.
dssart - I hope you havn't redone it on vb3.02 yet - 3.03 is just out!!!!!

It seems to be a 'feature' of vbulletin that they do not make hacking easy, even though it is the hacking community that makes vb popular. I don't see how an addition such as awards / medals (good as it is!) should require any changes to php files at all.

dssart
07-05-2004, 12:22 PM
JamesFrost, once in awhile Vbulletin does that. They'll release an update then a day or so later another. I wish they would do it perhaps once a month and kill a million birds with one stone.

This hack is really cool but to much manual-editing of files for me. No, I'm not lazy or ungrateful for free hacks, it's because given the nature of the precision required in editing (i.e. one small slip-up and your forum doesn't work) I can see myself editing these files for the nth number of times and misplacing a block of code or two. I'll think I'll pass on this hack unless some upgrade script becomes part of the hack. I don't know about anyone else, but I'd be willing to pay for this piece of software in order to receive updates.

JamesFrost
07-05-2004, 01:08 PM
JamesFrost, once in awhile Vbulletin does that. They'll release an update then a day or so later another. I wish they would do it perhaps once a month and kill a million birds with one stone.

This hack is really cool but to much manual-editing of files for me. No, I'm not lazy or ungrateful for free hacks, it's because given the nature of the precision required in editing (i.e. one small slip-up and your forum doesn't work) I can see myself editing these files for the nth number of times and misplacing a block of code or two. I'll think I'll pass on this hack unless some upgrade script becomes part of the hack. I don't know about anyone else, but I'd be willing to pay for this piece of software in order to receive updates.
I usually wait 4-5 days after a VB upgrade for the real version. Now installed this hack on VB3.03.

Animwebby - this hack is SOOO much easier to install than it used to be - really good work. :D

The only downside to the awards_install.php approach is it makes it harder to upgrade (as you have to uninstall / reinstall the hack - losing the details of who has which award).

teksigns
07-05-2004, 09:34 PM
when i view a persons profile after adding a award for them

the awards section is not showing up in the public profile ...


when i check in the admincp its showing checked as Yes for the award.


the awards are showing fine in the threads....


but not in the public profile .....


this is what i have in members.php


// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 14 ]
// AWARDS IN MEMBERINFO
$getuserawards = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "award AS award ORDER BY awardid ASC");
$show['userawards'] = false;
while ($useraward = $DB_site->fetch_array($getuserawards))
{
$userawardid = "award$useraward[awardid]";
if (!empty($userinfo[$userawardid]))
{
$userawardid_desc = $userawardid."_desc";
if ($userinfo[$userawardid_desc] != '')
{
$useraward[description] = $userinfo[$userawardid_desc];
}
$show['userawards'] = true;
eval('$userinfo[userawards] .= "' . fetch_template('awards_bit') . '";');
}
}
// END AWARDS IN MEMBERINFO
// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 14 ]


i have the arcade hack installed also and was wondering if this may be conflicting

teksigns
07-06-2004, 12:20 AM
i have went back throught the install really slow and made sure i done all the edits .... everything works fine but nothing shows in the

members.php file when i view a members profile ....

no award block or anything .... i have double checked and made sure the user has a award enabled in the admincp/user.php

anyone have any ideas?

i have vb3.0 gold .... with the major fixes applied from 3.0.1 and 3.0.2

y2krazy
07-06-2004, 03:50 AM
Installed on 3.0.1 and working just fine! The regular installer was used as I haven't been able to trust any HTL hacks here lately(they just don't seem to work while all the regular installations do). Thanks for the great port! ^^

-y2k-

teksigns
07-06-2004, 01:26 PM
are there not any support anymore for this hack ?

Polo
07-06-2004, 01:35 PM
Installed on 3.0.1 and working just fine! The regular installer was used as I haven't been able to trust any HTL hacks here lately(they just don't seem to work while all the regular installations do). Thanks for the great port! ^^

-y2k-

I agree, when i use htl hacks, i really dont know what happens...

i have tried them, they have fail...

i prefer manually... that way i have a more oriented prespective of what i am doing...

turbidblue
07-09-2004, 01:46 AM
sweet jesus!

i finally got this installed!

only took me 4 hours!

but, i am slow at this, so thats why..lol


i love this hack and have been trying for months to get it to work!

thanks!!


*click install finally!

Eagle Creek
07-17-2004, 12:25 AM
Wish my luck, I'm going to install it (3.0.3 board)

teksigns
07-17-2004, 03:30 AM
any idea when the request award link will be added ....

my members kept asking how to use it .....

so i had to disable all the awards ......

Oldfart
07-17-2004, 05:30 AM
I made the link to request an award live and I installed Erwin's form hack and made a generic form to request an award. Very simple to do.

In the awards_earnedawards_bit find this pice of code:

<td class="$bgclass" align="center" nowrap="nowrap">$vbphrase[request_award]</td>
</tr>

then change it to look like this:

<td class="$bgclass" align="center" nowrap="nowrap"><a href="http://yourwebsite/forums/form.php">$vbphrase[request_award]</td>
</tr>

Change the address to your web site and thats it. Just modify Ewrin's form hack to whatever you want to request an award.

treez
07-17-2004, 06:36 AM
at the risk of sound stupid... how do you add an award to a user? in the admin cp you can only edit/add/delete awards and stuff... wheres the add button?

treez
07-17-2004, 06:41 AM
nvm I got it :p

Eagle Creek
07-17-2004, 07:11 AM
nvm I got it :p
Go to edit a profile and in the left corner, under the page it is :).

Owh, didn't see you reply :p

teksigns
07-17-2004, 01:58 PM
I made the link to request an award live and I installed Erwin's form hack and made a generic form to request an award. Very simple to do.

In the awards_earnedawards_bit find this pice of code:

<td class="$bgclass" align="center" nowrap="nowrap">$vbphrase[request_award]</td>
</tr>

then change it to look like this:

<td class="$bgclass" align="center" nowrap="nowrap"><a href="http://yourwebsite/forums/form.php">$vbphrase[request_award]</td>
</tr>

Change the address to your web site and thats it. Just modify Ewrin's form hack to whatever you want to request an award.


can you attach the form and template your using from the Erwin's form hack so i dont have to recreate something .

Oldfart
07-17-2004, 06:06 PM
can you attach the form and template your using from the Erwin's form hack so i dont have to recreate something .

My form is customized to my board so it probably wouldn't be of any use to you. You would have to re-write it over anyways so a fresh form would be the best IMO. Erwins form hack is a very easy and generic form. there isn't a lot of "guess work" to get it to look the way you want it just follow the instructions and you'll be fine.

Bro_Joey_Gowdy
07-20-2004, 03:04 PM
clicks install

pgp2003
07-20-2004, 08:10 PM
now my register.php won't go anywhere when you click submit :( Do u know what could cause that?


EDIT: I am gonna double check the codes in register.php again when i get home

pgp2003
07-20-2004, 08:37 PM
Well that Award is working perfect...

I just checked my register.php, and I did exactly what the installation file said, but my register.php doesnt work anymore

Blam Forumz
08-02-2004, 11:29 AM
This hack ++++ed up my database and now i dont know how to restore it

Polo
08-02-2004, 01:13 PM
just upload your backed up database

Blam Forumz
08-02-2004, 02:06 PM
you see wat this hack did was, when i installed it, when i was done, i had a php error, so i decided to uninstall it, when i uninstalled it, i had a database error, so i tried to restore my database, but now i get errors like


Invalid SQL:
SELECT languageid,
phrasegroup_vbindex AS phrasegroup_vbindex,
phrasegroup_global AS phrasegroup_global,
options AS lang_options,
languagecode AS lang_code,
charset AS lang_charset,
locale AS lang_locale,
imagesoverride AS lang_imagesoverride,
dateoverride AS lang_dateoverride,
timeoverride AS lang_timeoverride,
registereddateoverride AS lang_registereddateoverride,
calformat1override AS lang_calformat1override,
calformat2override AS lang_calformat2override,
logdateoverride AS lang_logdateoverride,
decimalsep AS lang_decimalsep,
thousandsep AS lang_thousandsep
FROM language
WHERE languageid = 1

mysql error: Unknown column 'phrasegroup_vbindex' in 'field list'

mysql error number: 1054


Whats the problem?

Blam Forumz
08-02-2004, 02:57 PM
Nevermindfixed it now

Polo
08-02-2004, 03:35 PM
Nevermindfixed it now

oh that's good ;)

xmorpher
08-11-2004, 02:36 AM
i installed the hack thru the HTL,
but after install, i can't find the Menu Options
in the admincp...

how/where can i add awards?...

Willgames
08-18-2004, 12:08 AM
I have 3.0.3 and I cant get the Awards to show up on the posts. I have been through the files 3 times but i cant seem to find the problem (I had 3.0.1 installed and it worked fine) I was wondering if this was a common problem with 3.0.3

Willgames
08-20-2004, 01:56 AM
Ok. I dont know if my version of the software was old and not updated, but if you have installed the software on 3.0.3 and are having trouble making it show in the post where it says:
functions_showthread.php ADD BELOW:
// do posts from ignored users
if ($tachyuser AND THIS_SCRIPT != 'showpost' AND THIS_SCRIPT != 'private')
{
$maintemplatename = 'postbit_ignore_global';
}
else if ($ignore["$post[userid]"]/* AND !in_array($post['userid'], explode(' ', $bbuserinfo['buddylist']))*/)
{
$maintemplatename = 'postbit_ignore';
$show['showpostlink'] = ($alternate != 'usernote');
}

It really needs to be Added ABOVE! And If this has already been said, sorry. I didnt feel like searching through the posts, and this way, someone else wont have to either. And It may only be if the Arcade Awards are on, so that is another reason why you may be having trouble.

Blam Forumz
08-20-2004, 01:31 PM
Second time this has screwed up my database and ive had to restore it to 2 days before i installed it

I never want to see it again

y2krazy
08-29-2004, 01:03 PM
Installed and working well, but I just was wondering if an update was being worked on at this time...? Thanks for the great hack!

/me clicks install!

InfiniteWebby
08-29-2004, 10:59 PM
Not at the moment, I am busy with work, trying to get my boards back up and running and a whole list of other things that take priority to this hack.

Davez
08-30-2004, 01:29 AM
I have a big problem , i uninstalled the hack right now , and now i can?t enter on board or on admincp.
I got the folling database error :


Database error in vBulletin 3.0.1:

Invalid SQL:
SELECT
userfield.*, useraward.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
INNER JOIN userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN useraward AS useraward ON (useraward.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 1

mysql error: Table 'dffcars_vBulletin.useraward' doesn't exist

mysql error number: 1146

What can i do , can please someone help me ?

Many thanks

GlitterKill
08-30-2004, 04:43 PM
BIG problem here... I jsut followed all of the instructions to the T and I am getting this sql error when trying to view any thread.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN ()

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 23

mysql error number: 1064

It was my mistake. This is fixed now. Now I have to fix this dang "foreach" error.

GlitterKill
08-30-2004, 05:19 PM
I made the changes that are supposed to fix the foreach errors but I still have them.

Any ideas? I did the regular install.

GlitterKill
08-30-2004, 06:01 PM
Well, I tracked the problem down to this. I removed this chunk of code and now my forums actually work but not the awards... There is somthign in this code that is not workign well:

// ###### [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 12 ]
// AWARDS IN POSTBIT
foreach($userawards AS $key => $useraward)
{
$userawardid = "award$useraward[awardid]";
if (!empty($post["$userawardid"]))
{
$userawardid_desc = $userawardid."_desc";
if ($post[$userawardid_desc] != '')
{
$useraward[description] = $post[$userawardid_desc];
}
eval('$post[\'userawards\'] .= "' . fetch_template('awards_bit') . '";');
}
}
// END AWARDS IN POSTBIT
// ###### [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 12 ]

Davez
08-30-2004, 07:05 PM
I removed my one too ... replacing the files with my old ones ..

dethfire
08-30-2004, 09:07 PM
has anyone gotten this to install on 3.0.3, otherwise I will stay away

GlitterKill
08-30-2004, 11:21 PM
has anyone gotten this to install on 3.0.3, otherwise I will stay away
I think some people have by lookign at other posts. I am running 3.0.3 and it won't work so far. I am waiting to hear from AnimeWebby.

y2krazy
08-31-2004, 04:09 AM
I have it installed on 3.0.3 and it's working just fine. In fact, I have about 30 hacks on my 3.0.3 and I have no errors whatsoever! You can find a link to it in my sig, but it has not been grated public access yet. It will be opening soon, so all I can say now is that it works just fine on 3.0.3! I have attached a screenshot for everyone to see that it does work on 3.0.3! Hope everyone that needs help, gets it working soon! :)

GlitterKill
09-01-2004, 12:37 PM
After AnimeWebby pointed out the mistake I must have made everything works great. I have installed MANY hacks and even went over my work a second time before asking for help form the author but it was still user error on my part.

Thanks AnimeWebby! Great hack!

I am running vb 3.0.3 btw.

Caiman
09-01-2004, 03:18 PM
After AnimeWebby pointed out the mistake I must have made everything works great. I have installed MANY hacks and even went over my work a second time before asking for help form the author but it was still user error on my part.

Thanks AnimeWebby! Great hack!

I am running vb 3.0.3 btw.
Um, I cant find file modification instructions in this download? (NORMAL) ?

InfiniteWebby
09-02-2004, 09:29 AM
Just run admincp/awards_install.php they are at the end :D

Spacey
09-02-2004, 10:44 PM
Great hack im using it :)

apokphp
09-03-2004, 01:53 AM
I can't get the awards to "stick" to the member I give it to. In the adminCP, I go to the user, choose the award (only have 1 installed at the moment), click "yes", hit "save", but it does not save. Any ideas?

*edit* I've gone through all files/templates 2x now. Still no dice.

Also, I've installed this hack about 3x on other sites running 3.0.3. The hack works fine for them...but not on this latest one. Could it have something to do w/ the fact that I also have uShop and the Arcade hack installed?

It's just odd though, that the setting just won't save. That seems to be the only problem.

y2krazy
09-03-2004, 02:48 AM
Could it have something to do w/ the fact that I also have uShop and the Arcade hack installed?I have all 3 hacks installed on my 3.0.3 vB and I have no errors or bugs whatsoever... :)

apokphp
09-03-2004, 03:02 AM
:( Well damnit...I don't know wuttup. What file determines if that is to be saved or not? Could it be a setting instead??

I thought this would be admincp/user.cp, but I've made sure that the code edits are correct there.

Also, I used HTL, and I'm using 3.0.3.

y2krazy
09-03-2004, 10:37 AM
Also, I used HTL, and I'm using 3.0.3.That's probably the difference. I don't trust HTL hacks anymore since I had to removed the HTL hacks from an old forum when they didn't work correctly. I use manual/regular installs now, and everything works just fine. :)

InfiniteWebby
09-04-2004, 08:09 AM
Go into your phpmyadmin and see if the useraward table is in there. Otherwise the only thing I could think of is a problem with admincp/user.php specifically:

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.1' CHANGEID= 3 ]
// GET USER AWARDS FOR USER PART OF ADMINCP
$useraward = $DB_site->query_first("SELECT * FROM " . TABLE_PREFIX . "useraward WHERE userid = $userid");

// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.1' CHANGEID= 3 ]

And:

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.1' CHANGEID= 5 ]
// AWARDS IN USER PART OF ADMINCP
$fetchawards = $DB_site->query("SELECT * FROM " . TABLE_PREFIX . "award");
$awardnames = '(userid';

while ($award = $DB_site->fetch_array($fetchawards))
{
globalize($_POST, array('awards'));
$varname = 'award' . $award['awardid'];
$varname_desc = $varname . '_desc';
$bitwise = 0;

$awardnames .= ',award' . $award['awardid'] . ',award' . $award['awardid'] . '_desc';
if ($new)
{
$userawards .= ",'" . addslashes(htmlspecialchars_uni($awards[$varname])) . "','" . addslashes(htmlspecialchars_uni($awards[$varname_desc])) . "'";
}
else
{
$userawards.= ",$varname = '" . addslashes(htmlspecialchars_uni($awards[$varname])) . "',$varname_desc = '" . addslashes(htmlspecialchars_uni($awards[$varname_desc])) . "'";
}
}

if ($new)
{
$DB_site->query("
INSERT INTO " . TABLE_PREFIX . "useraward
$awardnames)
VALUES
($userid$userawards)
");
}
else
{
$DB_site->query("UPDATE " . TABLE_PREFIX . "useraward SET userid = $userid$userawards WHERE userid = $userid");
}
// END AWARDS IN USER PART OF ADMINCP
// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.1' CHANGEID= 5 ]

Flow Fusion
09-04-2004, 04:51 PM
Is it anyway possible to allow mods to give out awards? Just to make my life easier?

Or a way to schedule a way to have "broken user profile" fixed?

7aurelius
09-08-2004, 01:07 AM
installed with out a problem good ? flow

rex_b
09-08-2004, 08:59 PM
I have a problem..

Everything seems to work fine except when I try to view my member's public profile. So put back my original member.php and still have errors. help!!

Invalid SQL:
SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, level, avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline, " AS profilepic, customprofilepic.dateline AS profilepicdateline
FROM vb3user AS user
INNER JOIN vb3userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN vb3usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN vb3useraward AS useraward ON (useraward.userid = user.userid) LEFT JOIN vb3reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) LEFT JOIN vb3avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb3customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb3customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid)
WHERE user.userid = 58


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 '" AS profilepic, customprofilepic.dateline AS profilepicdatelin

mysql error number: 1064

Date: Wednesday 08th of September 2004 03:56:16 PM
Script: http://www.***/forum/member.php?userid=58
Referer: http://www.***/forum/showthread.php?p=26959#post26959

rex_b
09-08-2004, 09:05 PM
Well I narrowed down the problem to the functions.php file. I'm really not worried about this hack being shown in the member profile but rather just in the post bit..

So should I worry?

apokphp
09-08-2004, 11:17 PM
that's exactly what I have AnimeWebby...still no dice. Would you mind taking a look at the file yourself to see if something else is conflicting with it?

apokphp
09-19-2004, 07:19 AM
bump

need help on this please.

I have confirmed that it is NOT the user.php file. I have 2 sites. It works on 1, but not the other. So I took the user.php from the 1 that it did work on, and copied it to the site having troubles. Still, no change. It will not accept the change or selection of awards for a user.

mfacer
09-19-2004, 09:53 AM
I've just tried to install this hack... I'm running 3.0.3 and followed the instructions to a tee..... I've reinstalled the original code twice now and continue to get the same error message....



Parse error: parse error in /home/recaf/domains/yu-gi-oh-online.co.uk/public_html/includes/functions.php on line 1890

Fatal error: Call to undefined function: is_browser() in /home/recaf/domains/yu-gi-oh-online.co.uk/public_html/global.php on line 59


any ideas where I've gone wrong?!! It's driving me mad!
I have no other hacks or anything installed - this has been coded from a fresh install....

InfiniteWebby
09-20-2004, 08:13 AM
rex_b: I don't have any idea what has happened with your member profile page file... that is seriously messed up. If you want me to have a look contact me on any of my instant messenger services.

Apok: Try running this query in your admincp or phpmyadmin. If you still have troubles then contact me as above.

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;
Of course change " . TABLE_PREFIX . " to your vbulletin prefix ;)

mfacer: I'll need to know what bit of code surrounds line 1890 and where this is happening. But there shouldn't be any code changes around that line to do with this hack.

mfacer
09-20-2004, 08:30 AM
mfacer: I'll need to know what bit of code surrounds line 1890 and where this is happening. But there shouldn't be any code changes around that line to do with this hack.

I pinned the problem down to Dreamweaver saving the file incorrectly. Maybe there are too many lines, I dont know - but when I made changes to the functions.php file then saved it to upload - I got errors. Even when I reverted the code back to its original state and saved in DW it came up with the same errors. I noticed this as it happened with another smaller hack I tried earlier.

I've used WordPad to edit functions.php and that worked perfectly. Off to try your hack now :)

InfiniteWebby
09-20-2004, 08:33 AM
That's good to hear, keep me posted on the results :)

PlenoJure
09-21-2004, 07:55 PM
Thanks for the great hack, installed & working perfectly on a highly customized 3.0.3 install. :)

Amavisca
09-23-2004, 03:52 AM
Man what is going on? I did install the hack and it works ok however later on i decide i dont like this hack no more since my user dont need it .

I do the uninstall options and it mess up mydatabase:
There seems to have been a slight problem with the CafeBuon database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

Grr tell me what is wrong plz

InfiniteWebby
09-24-2004, 12:16 AM
For the uninstall to work properly you have to remove any file changes made by the hack otherwise just keep it installed without actually using it ;) I shoulda made that more clear.

davievil
09-28-2004, 02:29 PM
hello i'm new to the hacks for vb, it took me awhile to figure out how to get the hack up but my issue is... um now what? where do i go to add the awards and all that... maybe i installed it wrong?

Vman
10-04-2004, 03:34 AM
"INSTALLED" and works great...

Now, How would I be able to grant permission for my Mods/Sup Mods and Assit. Admin to be able to give medals out to the members...(Without having access to the AdminCP)

Thanks!!!

Twiser
10-04-2004, 02:19 PM
Great hack , Thx

davievil. Go to adminsection and then users , U will be able to award a player there.

Flow Fusion
10-04-2004, 02:20 PM
"INSTALLED" and works great...

Now, How would I be able to grant permission for my Mods/Sup Mods and Assit. Admin to be able to give medals out to the members...(Without having access to the AdminCP)

Thanks!!!Good question and I would also like to know.

hello i'm new to the hacks for vb, it took me awhile to figure out how to get the hack up but my issue is... um now what? where do i go to add the awards and all that... maybe i installed it wrong?From your index.php in the admincp. If you installed it right you should see "Add new award."

Flow Fusion
10-06-2004, 05:03 AM
Is it any way to fix the broken user profile issue? Cause everytime someone registers on my forum and post they show us as a guest until I fix that. And my board averages 15-30 people a day. This is kinda tedious.

Vman
10-07-2004, 12:27 AM
OK, I changed skins and now my medals are not showing...Can you please just give me the code for it to show on the forums, everything else is still there, just not showing up on in the posts....

Thanks..

I Figured It Out!!!....

InfiniteWebby
10-07-2004, 07:24 AM
Flow, the edits for this are already in there, probably in the registration.php file?!? I think, but they are definately there.

Ok found them:

In register.php find:
// insert custom user fields
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "userfield $userfieldsnames VALUES ($userid$userfields)");

Add below:
// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 15 ]
// insert user awards
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "useraward (userid) VALUES ($userid)");

// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 15 ]

Lionel
10-07-2004, 12:09 PM
From the first post:Extra page showing all awards available as well as all the users who have earned an award.

How do we display that?

moley
10-07-2004, 04:56 PM
award or awards.php its one of the two.

rex_b
10-07-2004, 06:59 PM
"INSTALLED" and works great...

Now, How would I be able to grant permission for my Mods/Sup Mods and Assit. Admin to be able to give medals out to the members...(Without having access to the AdminCP)

Thanks!!!


anybody?

Flow Fusion
10-08-2004, 01:56 AM
Flow, the edits for this are already in there, probably in the registration.php file?!? I think, but they are definately there.

Ok found them:

In register.php find:
// insert custom user fields
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "userfield $userfieldsnames VALUES ($userid$userfields)");

Add below:
// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 15 ]
// insert user awards
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "useraward (userid) VALUES ($userid)");

// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 15 ]


Thank you so much I can finally sleep.

rex_b
10-08-2004, 07:04 PM
Originally Posted by BBCVman
"INSTALLED" and works great...

Now, How would I be able to grant permission for my Mods/Sup Mods and Assit. Admin to be able to give medals out to the members...(Without having access to the AdminCP)

Thanks!!!




anybody?


bumpity bump

Blam Forumz
10-08-2004, 08:25 PM
didnt work for me, messed up my database, all the time

paulomt1
10-09-2004, 11:05 PM
I have instaled it in my vb303 and works great, thanks:)

Anyone know where I can get more medals images?

InfiniteWebby
10-10-2004, 01:57 AM
Blam, either send me a pm with what is happening or shutup. This hack works fine apart from a few people who have missed some steps when installing all of which I have walked them through how to fix it.

At the moment there is no way to allow your mods to control this hack. I have no time to do anything at the moment so please don't rely on me to make it so. I suppose you could do all the admincp/ file edits to the corresponding ones in modcp/ but nothing can be guarenteed.

Vman
10-10-2004, 03:43 AM
At the moment there is no way to allow your mods to control this hack. I have no time to do anything at the moment so please don't rely on me to make it so. I suppose you could do all the admincp/ file edits to the corresponding ones in modcp/ but nothing can be guarenteed.

Thanks for the great hack either way!!!...You have done a great job and I have had no problem installing with 3.0.3!!!!

Sad tho to see the support end this way. I hope to see some changes when you have the time to make this even a better if not the best hack of its time.

pfvc
10-29-2004, 11:19 AM
Excellent mod, works a charm on my 3.03 board and the users love it. One question I did have the gfx I use for the awards and the number of awards I have available, when someone has a number of them it goes of to the right of the screen and you need to scroll across to see the whole profile page. By chance is there any way to have it so that once it hits a certain length it wraps to the next line under (this is the awards bit only I refer to), so that the member profile screen doesn't skew off to the right via scroll bars?

Excellent job.

rex_b
11-10-2004, 07:56 PM
Ugh someone plz make this available for the MODCP.. I've been trying but can't make it where the MODCP can save the changes..

rex_b
11-11-2004, 06:46 PM
I know someone knows what to do! Step up, pweeaasseee?

snake-boy
11-19-2004, 02:49 PM
Hi,

I have been looking for something like this FOREVER, please please assist me in getting it working.

Info requested:

- HTL or Standalone installer. - Standalone Installer
- Version of vB you are running. - V3.0.3
- File where error is encountered. - During install process (awards_install.php)
- Exact error or description of error. - See below:

======================================
Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip,
user.*, userfield.*, usertextfield.*, useraward.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,
level,
NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN useraward AS useraward ON(useraward.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid) LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
WHERE post.postid IN (0,10)
ORDER BY dateline

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109

Date: Friday 19th of November 2004 10:50:38 AM
Script: http://<path_to_my_forums>/showthread.php?t=8
Referer:
Username: <myusername>
IP Address: <my_ip_address>
===========================

I have checked to see that the table "announcement" actually exists. It does. I also tried to fix broken user profiles from admincp just in case, but no go. Everything "seems" ok until I hut a showthread.php :(

Please advise me how to fix this, I really (REALLY) want to install this hack.

I await your reply. Many thanks in advance to anyone who may advise?

-snake

paulmjno
11-29-2004, 12:40 AM
Amazing hack! But... very tiring to install! lol. The first hack I've installed thus far with no problems. :)

TosaInu
11-30-2004, 08:10 PM
Amazing hack! But... very tiring to install! lol. The first hack I've installed thus far with no problems. :)
vb 3.03, works without a flaw. Nice hack AnimeWebby.

tomcromp
12-03-2004, 12:28 AM
Well, it simply won't work for me.

I installed following all the steps, but I still get an error:

Unable to add cookies, header already sent.
File: /home2/tom/public_html/forum/includes/functions_showthread.php
Line: 704

It's really bothering me as this is my first hack install and it won't work.

trackpads
12-03-2004, 10:46 AM
Great Hack!

2 Additions if you ever get time.

1. Can you leave the small postbit but have the Awards display a large version of the award? Or both? I would like ot have full metals in the Awards page but only the tiny ribbons on the postbit.

2. Any way yo make them scroll in the postbit? The latest IPBArcade hack does this and it would be a great addon for this hack.

Agian, excellent work and thanks!!!!!

dssart
12-04-2004, 02:38 AM
Finally installed this hack..works great with 3.0.3..I'd like to see an update with some of the great suggestions posted here. I would definitely pay for the next one!

BTW, for all those having trouble with this script...make sure every bit of code is inserted correctly. I had a ");" in the wrong place and I couldn't view my members.php!

Eagle Creek
12-04-2004, 10:52 AM
Finally installed this hack..works great with 3.0.3..I'd like to see an update with some of the great suggestions posted here. I would definitely pay for the next one!

BTW, for all those having trouble with this script...make sure every bit of code is inserted correctly. I had a ");" in the wrong place and I couldn't view my members.php!
I wouldn't but still it is a great script!

Edric
12-08-2004, 11:49 AM
Ok this hack does not work in 3.1 unless you do this.

You need to use the 3.0 showthread.php, and the 3.0 includes/adminfunctions_showthread.php

It won't work on the 3.1 php files. I don't know why but that's the deal.

I have the shoutbox, who was online, awards, arcade, and store hack on my board.

And this is the only way I see getting this file to work.

I am using 3.0.1, where can I get the 3.0.0 files?

I keep on getting errors with the showthread files, obviously using the 3.0.1 files.

tomcromp
12-09-2004, 05:26 PM
Is there anyone willing to install this hack for us. It screwed up the forum last time. :(

red_baron2000
12-12-2004, 01:35 AM
great hack ..i've installed wothout any problem all works fine..however i am missing the medals icons anyone know where i can get some? thak you :)

SHARKY
12-12-2004, 05:31 PM
would be nice if there was an install text instead of the edits within the install so when ya add nnew templates to your site you can just edit them rather than have the edits in the install itself

SirJonathan
12-13-2004, 05:24 PM
hey guys! Got what I think is a simple bug to work out..

When viewing a member profile, I get:

Warning: in_array(): Wrong datatype for second argument in (address)/community/member.php on line 512

Line 512:


if (!in_array($userinfo['userid'], $buddylist))


This is code directly AFTER the awards hack. I've put the original up, works fine. Added the hacks in and it no longer works. Tested it a couple times to make sure I Wasn't messing up :).

Any thoughts?

TLSNetwork
01-01-2005, 10:31 AM
i have installed this and for the most part it is working well , The only problem i get is it is not showing up in the posts , It shows up ok in the users profile and everything looks good there , But for some reason and no matter how hard i try i cannot get it to show up in ther posts I am not getting any sql errors anywhere so all thats ok as far as i know.
Any ideas anybody this is on a 3.0.3 board.

edit : Never mind i sort out the problem

RetroDreams
01-01-2005, 01:44 PM
How do I edit this so if there are no awards, it will display "No Awards?"

GlitterKill
01-06-2005, 02:32 AM
I just updated to 3.0.4 which seems to break this hack. I went back to fix the hack by going through the install procedure again and when I did the functions.php hack (the file has changed in 3.0.4) I get this error on the site:

Parse error: parse error, unexpected T_STRING in /home/virtual/site2/fst/var/www/html/forums/includes/functions.php on line 941

I took out that functions.php hack and the board runs again but without the awards showing at all. Any ideas?

dssart
01-08-2005, 06:08 PM
I re-uploaded all the files from the zip and selected "uninstall" from the installation screen. Afterwards the forum was inoperable, however I then performed the VBulletin upgrade as normal and after the upgrade the forum was perfectly fine.

I'm leary about re-installing this..has anyone done the upgrade and re-installed? does it work O.K. under 3.0.5?

GlitterKill
01-08-2005, 08:34 PM
No, the hack will break vb 3.0.4 from my experience. Is that the version you are running? How did you install the functions.php hack when the file in 3.0.4 is different than the instructiosn for the hack? Where did you place the hack code?

dssart
01-09-2005, 01:38 AM
I read your message that you were having problems with this hack under 3.0.4 so I figured I'd better try uninstalling it before I updated from 3.0.3. I updated to 3.0.5 this evening. I didn't want to try and save this hack through the upgrade. It's more of a headache to save it than it would be to simply spend the hour or so to hand install it again.

In order to get a thorough uninstall, I uploaded all the files from the .zip file, and then ran the install script and from there the uninstall option. The uninstall ran seemingly well until it was done. When I then tried accessing my forum I received a MySQL error message. Same when trying to access the admin CP. If I hadn't been upgrading ( which must've replaced the corrupted file ) I would be screwed.

I'm not going to re-install this hack and risk crippling my forum until I hear someone has it up and working under 3.0.5

TCattitude
01-11-2005, 08:10 PM
Any upgrade to install it on 3.0.5?

GlitterKill
01-17-2005, 05:32 PM
I REALLY hope he comes back to let us know how to fix this. I love the hack when it worked but it won;t under the latest version for some reason.

dssart
01-17-2005, 07:57 PM
Yep, well I guess you get what you pay for ;)

trackpads
01-18-2005, 01:02 AM
How do I edit this so if there are no awards, it will display "No Awards?"
I would create an award called No Awards, a graphic for example and then add a conditional to the postbit to display it instead.

deb0
01-19-2005, 10:51 AM
Are there any issues with this hack and 3.03?

Eagle Creek
01-20-2005, 05:20 PM
Are there any issues with this hack and 3.03?

Works fine for me :).

wwesn1
01-22-2005, 05:31 PM
Ugh someone plz make this available for the MODCP.. I've been trying but can't make it where the MODCP can save the changes..

what I did (now this may not be the best solution but it worked) was copy the admincp/user.php then took out the information I don't want the mods to be able to edit then uploaded the user.php file over the one in the modcp folder. Again, might now be the best but it works!

GlitterKill
01-26-2005, 01:47 AM
So does anyone have this running on vb 3.0.5 or 3.0.6?

Eagle Creek
01-26-2005, 01:49 AM
So does anyone have this running on vb 3.0.5 or 3.0.6?
Not me.. I'm using the awardsystem very often so I do want to know it for sure.

dssart
01-26-2005, 02:06 AM
Nope..I don't have it installed. I was hoping either the author would confirm it is stable under 3.0.6 or some brave soul would have tried it by now.

CLowNxPE
01-27-2005, 07:25 PM
to make it work with 3.0.6 in functions.php

find

// no cache available - query the user
$user = $DB_site->query_first("
SELECT " .
iif(($option & 16), ' administrator.*, ') . "
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid" .
iif(($option & 1) AND $vboptions['reputationenable'] == 1, ', level') .
iif(($option & 2) AND $vboptions['avatarenabled'], ', avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline').
iif(($option & 8), ', customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline') .
iif(!isset($vbphrase), fetch_language_fields_sql(), '') . "
FROM " . TABLE_PREFIX . "user AS user
INNER JOIN " . TABLE_PREFIX . "userfield AS userfield ON (user.userid = userfield.userid)
INNER JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid) " .
iif(($option & 1) AND $vboptions['reputationenable'] == 1, "LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) ").
iif(($option & 2) AND $vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid) ") .
iif(($option & 8), "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) ") .
iif(($option & 16), "LEFT JOIN " . TABLE_PREFIX . "administrator AS administrator ON (administrator.userid = user.userid) ") .
iif(!isset($vbphrase), "INNER JOIN " . TABLE_PREFIX . "language AS language ON (language.languageid = IF(user.languageid = 0, " . intval($vboptions['languageid']) . ", user.languageid)) ")."
WHERE user.userid = $userid
");


replace with


$user = $DB_site->query_first("
SELECT " .
iif(($option & 16), ' administrator.*, ') . "
userfield.*, useraward.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid" .
iif(($option & 1) AND $vboptions['reputationenable'] == 1, ', level') .
iif(($option & 2) AND $vboptions['avatarenabled'], ', avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline').
iif(($option & 8), ', customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline') .
iif(!isset($vbphrase), fetch_language_fields_sql(), '') . "
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON (usertextfield.userid = user.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON (useraward.userid = user.userid) " .

iif(($option & 1) AND $vboptions['reputationenable'] == 1, "LEFT JOIN " . TABLE_PREFIX . "reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid) ").
iif(($option & 2) AND $vboptions['avatarenabled'], "LEFT JOIN " . TABLE_PREFIX . "avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN " . TABLE_PREFIX . "customavatar AS customavatar ON (customavatar.userid = user.userid) ") .
iif(($option & 8), "LEFT JOIN " . TABLE_PREFIX . "customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) ") .
iif(($option & 16), "LEFT JOIN " . TABLE_PREFIX . "administrator AS administrator ON (administrator.userid = user.userid) ") .
iif(!isset($vbphrase), "INNER JOIN " . TABLE_PREFIX . "language AS language ON (language.languageid = IF(user.languageid = 0, " . intval($vboptions['languageid']) . ", user.languageid)) ")."
WHERE user.userid = $userid
");

dssart
01-27-2005, 07:42 PM
Great work! Thanks alot!

jluerken
01-28-2005, 05:06 PM
1. The REQUEST AWARD link is not working for me.
How can I make this working?

2. I edit a user and give him an award.
When I edit the user again all buttons in the admincp are set to NO.
Now saving the user will result in the loss of the award for the user :-(

MikaK
01-30-2005, 08:22 AM
1. The REQUEST AWARD link is not working for me.
How can I make this working?


Same here:( Nor does the awards show at user profile... Otherwise seems to work ok and is a cool hack:)

=M= *installed*

jluerken
02-01-2005, 11:59 AM
2. I edit a user and give him an award.
When I edit the user again all buttons in the admincp are set to NO.
Now saving the user will result in the loss of the award for the user :-(

Can someone help me with this?

CLowNxPE
02-03-2005, 12:12 AM
1. The REQUEST AWARD link is not working for me.
How can I make this working?

maybe because it's not even implemented yet. If you scroll all the way up that is in the "Comming soon" section of the post.

TCattitude
02-03-2005, 10:54 PM
The "FIX EMPTY USER AWARD TABLE" from installation and the one inside the "update counters" dont work at all!
All users are show as guest, and... hack mess up all the forums :(

It only give a blank screen.
I cant make it works.

Help please :(

Here's the part of the misc.php with the info for the fix un the vb3_useraward table:


// ###################### Start find lost users #######################
if ($_POST['do'] == 'lostusers')
{

$users = $DB_site->query("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield USING(userid)
WHERE userfield.userid IS NULL
");

$userids = array();
while ($user = $DB_site->fetch_array($users))
{
$userids[] = $user['userid'];
}

if (!empty($userids))
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "userfield (userid) VALUES (" . implode('),(', $userids) . ")");
}

$users = $DB_site->query("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield USING(userid)
WHERE usertextfield.userid IS NULL
");

$userids = array();
while ($user = $DB_site->fetch_array($users))
{
$userids[] = $user['userid'];
}

if (!empty($userids))
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "usertextfield (userid) VALUES (" . implode('),(', $userids) . ")");
}

// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 2 ]
// FIX EMPTY USER AWARD TABLE
$users = $DB_site->query("
SELECT user.userid
FROM " . TABLE_PREFIX . "user AS user
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward USING(userid)
WHERE useraward.userid IS NULL
");

$userids = array();
while ($user = $DB_site->fetch_array($users))
{
$userids[] = $user['userid'];
}

if (!empty($userids))
{
$DB_site->query("INSERT INTO " . TABLE_PREFIX . "useraward (userid) VALUES (" . implode('),(', $userids) . ")");
}
// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 2 ]


define('CP_REDIRECT', 'misc.php');
print_stop_message('user_records_repaired');
}


I'm using vb3.0.5 (security flaw patched)
Any idea?
Somebody can help me? :o

eva01_
02-11-2005, 08:33 PM
well someone just unistalled it on a site and it blew up the entire database, now nothing on the site works.

any ideas?

FFZoneXtreme
02-13-2005, 05:36 AM
I installed the MOD, and all works fine =D

But I need to know what I need to modify to make this mod compatible with ARCADE MOD, I know that I have to change the "awards" to "awards2", but I dont know where :S:S:S (I prefer to change this Mod because Arcade is bigger and I would never end :S


If you want to take medal icons I have made a lot for my forums ;)
http://foros.ffzonextreme.com/awards.php

deb0
02-16-2005, 11:39 AM
I've been looking for something like this. Is there a plant to upgrade to 3.6 version of VB?

Glenn379
02-19-2005, 10:52 PM
Yeah I would love to install this on 3.0.6 :)
Hope someone does that soon

Glenn379
02-19-2005, 11:50 PM
Okay it works for me in 3.0.6 now. There were a few things that didn't work though. the whole functions.php does not work at all. I can't find it in there and I cannot find CLowNxPE's PHP. I tried substituting something almost exactly identicle, but it messed it up.

Basically what happens is, it works for the postbit, but not with Member Info. Any ideas?

PS: sorry for the double posting, just looking for answers

Eagle Creek
02-20-2005, 07:41 AM
Okay it works for me in 3.0.6 now. There were a few things that didn't work though. the whole functions.php does not work at all. I can't find it in there and I cannot find CLowNxPE's PHP. I tried substituting something almost exactly identicle, but it messed it up.

Basically what happens is, it works for the postbit, but not with Member Info. Any ideas?

PS: sorry for the double posting, just looking for answers
Does it work under 3.0.7?

Glenn379
02-20-2005, 07:57 AM
I don't know, I'm still in 3.0.6

>> Does anyone know where to find some good award images

Eagle Creek
02-20-2005, 08:43 AM
I don't know, I'm still in 3.0.6

>> Does anyone know where to find some good award images
http://images.google.nl/images?q=medal+icon&btnG=Zoeken&hl=nl&lr=&newwindow=1&client=firefox-a&rls=org.mozilla%3Anl-NL%3Aofficial maybe?

Glenn379
02-20-2005, 09:31 PM
Well I started making some pretty good gaming ones. I can't find any good medals anywhere though. If anyone wants help with gaming awards I'd be glad to help :). Contact me :D

Creed
02-22-2005, 06:55 AM
I've made a (semi) add-on for anyone who would like it. It makes the awards system a standalone page. You can view the list, or any member's awards. As well as go back to his/her profile, and link's from user's post in postbit in Username dropdown. If anyone is interested, I'll post some screenies tomorrow :)

Glenn379
02-22-2005, 06:58 AM
Oooo interesting, I'd like to see this :D

Creed
02-22-2005, 07:13 AM
The only thing I don't currently have working is the request an award, imagine that ;) However, I should have it working in the next couple of days. The screenies are attached, as I see there is interest...so I didn't want to keep you waiting :)

Creed
02-22-2005, 09:53 AM
The only thing I haven't been able to figure out, is how to pull the information for the current awards, so that they can be listed for selecting in the form to submit request for an award. If I had more knowledge of mySQL I would probably have this done by now. Everything else works like a charm :) Any ideas, possibly from the author? Can you help me call a list of available awards to put in something like this:

<select>
<option value=$awardid>$awardname
<option value=$awardid>$awardname
</select>

Obviously they would have to be different, but I am apparently not versed enough in mySQL to get the job done quite yet. Any help would be appreciated ;)

Eagle Creek
02-22-2005, 10:07 AM
The only thing I haven't been able to figure out, is how to pull the information for the current awards, so that they can be listed for selecting in the form to submit request for an award. If I had more knowledge of mySQL I would probably have this done by now. Everything else works like a charm :) Any ideas, possibly from the author? Can you help me call a list of available awards to put in something like this:

<select>
<option value=$awardid>$awardname
<option value=$awardid>$awardname
</select>

Obviously they would have to be different, but I am apparently not versed enough in mySQL to get the job done quite yet. Any help would be appreciated ;)
Nice!


(nice forum also!)

deb0
02-22-2005, 10:24 AM
Will this be upgraded to work in 306? Just the hack I've been looking for.

Eagle Creek
02-22-2005, 11:15 AM
Will this be upgraded to work in 306? Just the hack I've been looking for.
And what about 3.0.7?

Polo
02-22-2005, 12:27 PM
looks good creed keep up the good work :)

Glenn379
02-23-2005, 12:50 AM
:/ I thought it wascoming out today

Flow Fusion
02-23-2005, 01:12 AM
Help me upgraded to 3.0.7 and I get this

http://www.giftedsouls.com/gs/awards.php

Glenn379
02-23-2005, 01:17 AM
Can we get a screen... you need to be logged in to see

Flow Fusion
02-23-2005, 01:19 AM
Sorry it's just a blank page.

Flow Fusion
02-23-2005, 01:28 AM
Aww shucks the shout box is gone also how do I revert?

Glenn379
02-23-2005, 02:11 AM
Try uninstalling?

Creed
02-23-2005, 12:43 PM
Sorry Glenn379, as I was away for the day (regarding AIM) ;)

Now on to the good stuff, if anyone actually cares...I decided to release the standalone add-on :) Its in the attached zip. Hope you like it!

Also, I released with some updated screenies here (https://vborg.vbsupport.ru/showthread.php?p=616291)

Eagle Creek
03-02-2005, 08:12 PM
Sorry Glenn379, as I was away for the day (regarding AIM) ;)

Now on to the good stuff, if anyone actually cares...I decided to release the standalone add-on :) Its in the attached zip. Hope you like it!

Also, I released with some updated screenies here (https://vborg.vbsupport.ru/showthread.php?p=616291)
So is it working on 3.0.7?

Creed
03-03-2005, 02:51 AM
Yeah, I installed on 3.0.7 and works fine :)

Eagle Creek
03-03-2005, 01:07 PM
Yeah, I installed on 3.0.7 and works fine :)
HOOAH!

Uuhm, I mean, thankyou :)

Flow Fusion
03-03-2005, 10:48 PM
OK I see for all these updates and awards to work together you need to uninstall first. Then replace the "function.php" file with the first one. Reinstall the hacks and put the edited file back.

Arial
03-05-2005, 01:37 PM
Anybody interested in earning some $$$ utilising their knowledge of this hack go here:
https://vborg.vbsupport.ru/showthread.php?p=621249

Flow Fusion
03-11-2005, 10:58 AM
OK how do I upgrade this hack? I noticed after I upgrade my VB I need to uninstall this hack and reinstall then give out all my awards again? This is so very tedious. And Yes the awards are perm. @ ^^^

Flow Fusion
03-12-2005, 10:24 AM
bump...?

xug
03-13-2005, 10:53 AM
Just do only the file changes and check if the templates need to be changed, I didn't need to change anything in my templates.

I cut the install file so that only these file and template changes show.
See attached .html.txt file - rename to .html

I do run vB 3.0.7 and it runs fine, no problems seen yet.

Good Luck

Flow Fusion
03-13-2005, 10:59 AM
How do I check the templates? Cause I hate that I have to uninstall and reinstall all the time...

xug
03-13-2005, 11:26 AM
Rename the above file and load it into a browser.

Where it states to modify the templates follow these instructions (these are all original instructions, no changes made) and see if the changes are still there or not, if not execute these instructions ;)

All files changes must be done for sure, because with an vB upgrade you upload new files and these need to be adjusted again.

And please be patient because it's a pretty big hack, make a copy of the file you want to change before you do so.

Flow Fusion
03-13-2005, 07:42 PM
Thanks I'll try it in the morning.

Flow Fusion
03-15-2005, 04:27 PM
I don't know why it went out but I installed the HTL installer and I got a database error cause it was already installed but somehow it fixed it lol. But thanks for the help. All my files were edited as the attachment stated. Hope they stay up.

GamerzWorld
03-18-2005, 07:18 PM
Is there a way to make it so that i can have small version in postbit and when you click larger image. I made large and small images of same awards but obviously it ruins style with large images. Any ideas

Arial
03-19-2005, 07:07 AM
Don't think so, I am having to have one written for me from scratch to support that and other features.

dssart
03-19-2005, 01:56 PM
Arial, if you're having an awards/medals/cards hack written from scratch and you're interested in sharing some of the development costs PM me. This hack appears to be dead or at least dying. I had this working on my forum for 2 months, all my members loved it, but I never re-installed it because it was to much of a hassle to do the uninstall/install whenever VB updated. I was also thinking about having someone re-do this also complete with a one-click install/uninstall and many of the additional features discussed here. Let me know.

trackpads
03-19-2005, 02:37 PM
I am willing to invest in a new one as well.

Creed
03-19-2005, 11:24 PM
As far as an Install script, wouldn't be too hard to write. As far as completely re-writing it...may take more time than I have to do so. I would like to help, but I'm stretched thin as it is right now ;)

mtha
03-20-2005, 08:02 PM
Is there a way to make it so that i can have smallversion in postbit and when you click larger image. I made large andsmall images of same awards but obviously it ruins style with largeimages. Any ideas

:) Idea is having another field in award table, call it bigimage_url, and give it the link to your bigger image.

When displaying award (in award page, or in member profile), use big image instead of the small one.

Simple as it is. thinsg to do:

01. a query to add additional field
02. change /admincp/award.php to show this field, so that you can put URL for big images
03. change AWARD and/or MEMBER template, to use new URL for big image instead of old one.

I might be interested in writing something like this too.


Additional features would be ...


- Giving One award to One person multiple time,
For example, if you have a "Member of the month" award, and someone get it twice, you can give your member 2 of the award.

- A complete - seperated award management system in AdminCP would be nice.
this would include
+ list all award and add new award (already featured)
+ list all members who get each awards (and/or all awards for one member)
+ give/take away some member some award(s), without having to edit userprofile (using the vB's user.php) because giving award is a seperatework from editing profile.

and other features mentioned.

GamerzWorld
03-20-2005, 08:07 PM
:) Idea is having another field in award table, call it bigimage_url, and give it the link to your bigger image.

When displaying award (in award page, or in member profile), use big image instead of the small one.

Simple as it is. thinsg to do:

01. a query to add additional field
02. change /admincp/award.php to show this field, so that you can put URL for big images
03. change AWARD and/or MEMBER template, to use new URL for big image instead of old one.

I might be interested in writing something like this too.


Additional features would be ...


- Giving One award to One person multiple time,
For example, if you have a "Member of the month" award, and someone get it twice, you can give your member 2 of the award.

- A complete - seperated award management system in AdminCP would be nice.
this would include
+ list all award and add new award (already featured)
+ list all members who get each awards (and/or all awards for one member)
+ give/take away some member some award(s), without having to edit userprofile (using the vB's user.php) because giving award is a seperatework from editing profile.

and other features mentioned.

Do you think you could do simple addition of making bigger ;)

mtha
03-20-2005, 08:13 PM
Do you think you could do simple addition of making bigger ;)
Working on it, as your request :D


... and done, wait for update :D

and here's the quick release
https://vborg.vbsupport.ru/showthread.php?t=78466

anyone who want to improve the original hack, feel free to include the add-on

Creed
03-20-2005, 10:51 PM
Here is also a nice little fix for the postbit image sizing...as well as a couple of new features I guess :) Please make note, that you can change the size of the images by specifying your own height= and width= in the awards_postbit template.

mtha
03-21-2005, 07:32 PM
just went to phpbb site, and look at their Medal System Mod:
http://www.phpbb.com/phpBB/viewtopic.php?t=148362

Didnt install that mod and test it, but the database structure looks much better.

They add medals (awards) by issue_id, with fields medal_id, user_id, issue_reason, issue_time, which allow you to limit the size of database, without adding a whole bunch of empty awards for all users (like the current one does)

I know that Arial is paying for the hack to be made, but ... just wondering if anyone can share the idea :D
https://vborg.vbsupport.ru/showthread.php?p=621249

mtha
03-21-2005, 09:20 PM
Don't think so, I am having to have one written for me from scratch to support that and other features.

Arial, how far do you have your new hack coded on?

I am thinking about writing something like that too, but there's no point making duplicate versions.


well well, I have 50% code done. database structure setup, able tomanage awards, give/remove awards in AdminCP. Now just need to do thedisplay part :D

I may have the first release in few days.

uaetoon
03-23-2005, 10:15 PM
i have this prop in part 3

what can i do plez

=-
Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 7

mysql error number: 1064

Date: Wednesday 23rd of March 2005 06:10:51 PM
Script: http://xxxxxxx/vb/admincp/awards_install.php?step=doqueries
Referer:
Username:
IP Address:

Arial
03-25-2005, 07:02 AM
Arial, how far do you have your new hack coded on?

I am thinking about writing something like that too, but there's no point making duplicate versions.


well well, I have 50% code done. database structure setup, able tomanage awards, give/remove awards in AdminCP. Now just need to do thedisplay part :D

I may have the first release in few days.

Well the guy was only starting tommorow to be honest, having seen your doing one that may well do the job I have also asked just asked him to hold off and see how yours works.

Arial
03-25-2005, 07:05 AM
Arial, if you're having an awards/medals/cards hack written from scratch and you're interested in sharing some of the development costs PM me. This hack appears to be dead or at least dying. I had this working on my forum for 2 months, all my members loved it, but I never re-installed it because it was to much of a hassle to do the uninstall/install whenever VB updated. I was also thinking about having someone re-do this also complete with a one-click install/uninstall and many of the additional features discussed here. Let me know.

Sorry was not recieving notifications on this thread, if you want to share the costs and use the hack that would be fine, feel free to PM,, it also looks like Mtha is creating a new version as well, which you may find suits your purposes and not cost you anything.

The version I am having done is basically a complete copy of the phbb version with a few extra toys thrown in but I've just asked the developer to hold off as he has not started yet, if Mtha version turns out to be as good as the phpbb version I would rather use that and make Mtha a small contribution for the time spent.

Arial
03-25-2005, 07:08 AM
Mtha

What is your hack based on ? Will it work / display in the same fashion that the Phpbb version does or is it more along the lines of this version?

dssart
03-25-2005, 09:35 AM
Arial: Sounds good. My opinion, it seems mtha is enjoying the project and is visible within the forum. That's great for any of us who like to read how he's doing on this great add-on.

mtha: keep going man! but whatever you do, please make installation as easy as uninstallation. Ideally two or three clicks. No more hand-editing of code. That's stone-age. I'll bet 75% of the problem messages pertaining to this hack are errors in inserting the code. If that isn't possible, then at a maximum 2 or 3 files which need to be hand-edited. Also, a hack which is "version change resistant" would be great (although probably not realistic from a coding point of view) when VBulletin goes on their update binges every few months. I can't speak for Arial, or anyone else who may be interested in this hack, but if it works and installation is a breeze, I'd be happy to send you a few bucks when you've got a working app.

Arial
03-25-2005, 09:53 AM
Ditto dssart, I'm happy to contribute if its' what we are after, personally I feel the phpbb version displays the medals etc in a far more appealing fashion, so that's what we are after.

If Mtha is going down that route, I will happily donate / contribute to your time, if not I will carry on with my guy and pay him to do the entire thing for us as a personal project.

mtha
03-25-2005, 04:03 PM
What is your hack based on ? Will it work / display in the samefashionthat the Phpbb version does or is it more along the lines ofthisversion?
neither or both :D

I will have the database somewhat the same with phpbb one (on the idea), and the code is partly based on this version.

I write the code based on both this hack and phpBBhack.The displaythingie is not very important though. The featureswill be some howdifferent, which I like better.

Rightnow, I come to the point where you can give awardtosomeone,andtakeit away from, in control panel. Havent come tothe part of displaying inthe public profiles, so I dont know how I will arrange the awards inprofile and awards list yet

I didnt add the "Award Category" either. doyouthinkit'sgood/importantto add that too? Well I may need to createanewthreadfor the matter,otherwise, I would hijack this thread :D

Ditto dssart, I'm happy to contribute ifits'whatweareafter, personally I feel the phpbb version displaysthemedalsetcin afar more appealing fashion, so that's what we are after.

If Mtha is going down that route, I will happilydonate/contributetoyour time, if not I will carry on with my guy andpayhimto dotheentire thing for us as a personal project.

Thanks, but that's up to you to decide. I'm writing the hack formyself,and make it availabe for everyone. donations are alwayswelcome. releasetime is not set yet. features depends on ... :D


mtha: keep going man! but whatever you do,pleasemakeinstallation aseasy as uninstallation. Ideally two or threeclicks.Nomorehand-editing of code. That's stone-age. I'll bet 75%oftheproblemmessages pertaining to this hack are errors ininsertingthecode. Ifthat isn't possible, then at a maximum 2 or 3 fileswhichneedto behand-edited. Also, a hack which is "versionchangeresistant"would begreat (although probably not realistic from acodingpoint ofview)when VBulletin goes on their update binges everyfewmonths. Ican'tspeak for Arial, or anyone else who may be interestedinthishack, butif it works and installation is a breeze, I'd be happytosendyou afew bucks when you've got a working app.

Well, I myself actually like doing things manually better.Comingtoany"installer", I have to read the install code, inordertounderstandwhat it is doing. its somewhat harder, but youknowexactlywhat you aredoing (if you understand the code).
Also, all the installation currently availabe only dothedatabasepart(insert template/phrases), none of them have permissiontoeditfile.
If you want to "edit" files "automatically, I will show you how to do it, using a different tool, which is great.

But that's gonna be later on the road. It's good when having people supporting the idea. Thanks


===========
The new development for my YET ANOTHER AWARD SYSTEM start HERE:
https://vborg.vbsupport.ru/showthread.php?t=78763

=================================================

ChrisBaktis
03-26-2005, 01:17 AM
Im using 3.0.07 and during the install I received this error - I used the Standard .zip file.

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

mysql error: You have an error in your SQL syntax near ';
' at line 7

mysql error number: 1064

ClockCrew
03-26-2005, 09:45 PM
I have uploaded all the files...and when I do so, I go to Install this...and when I click Install....I get this...

Database error in vBulletin 3.0.6:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'add_new_award', 'Add New Award', '1')
mysql error: Duplicate entry 'add_new_award-0-1' for key 2

mysql error number: 1062

How do I fix this?

Eagle Creek
03-26-2005, 09:50 PM
I have uploaded all the files...and when I do so, I go to Install this...and when I click Install....I get this...

Database error in vBulletin 3.0.6:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'add_new_award', 'Add New Award', '1')
mysql error: Duplicate entry 'add_new_award-0-1' for key 2

mysql error number: 1062




How do I fix this?
I s i t f u l l 3.0.7 c o m p a t i b l e ?

mtha
03-26-2005, 10:10 PM
I s i t f u l l 3.0.7 c o m p a t i b l e ?

yes it is, if you can install it properly.

Eagle Creek
03-26-2005, 10:14 PM
yes it is, if you can install it properly.
Thx... Because I have two 2.0.3 boards running and I want to upgrade but don't want to lose this hack.

And I see many problems in this thread.

ClockCrew
03-27-2005, 12:28 AM
I s i t f u l l 3.0.7 c o m p a t i b l e ?
yes, im not that dumb.

Eagle Creek
03-27-2005, 12:38 PM
yes, im not that dumb.
What the * ??? I dont 'attack' you? I just want to know it for my own board!

mtha
03-27-2005, 09:31 PM
peace out people. just a small missunderstand eachother :)
A new awards system coming up for you guys to fight :D

Eagle Creek
03-27-2005, 10:50 PM
peace out people. just a small missunderstand eachother :)
A new awards system coming up for you guys to fight :D
T t t t haaaaank you! :D

Will you announce the new options also?

mtha
03-28-2005, 08:40 AM
T t t t haaaaank you! :D

Will you announce the new options also?

You can go here for information
https://vborg.vbsupport.ru/showthread.php?t=78934

lasto
03-28-2005, 10:45 AM
can anyone confirm if this hack works in latest version of vbull 3.0.7 ?

Imperial Fritz
03-28-2005, 03:10 PM
Seems to work with my 3.0.7.

mtha
03-28-2005, 04:13 PM
can anyone confirm if this hack works in latest version of vbull 3.0.7 ?

As far as you can figure out how to edit files, it will work with 3.0.7,

I think there's few places in original files having different code from what you need to find (for editing).

deathemperor
03-28-2005, 04:14 PM
the edit in admincp/misc.php cannot find, it's for updating member's info I think, without that it works fine

lasto
03-28-2005, 04:39 PM
not bothered about members info - postbit will do just fine and i liek this hack as well :)

cheers for reply deathemperor and mtha

deb0
05-12-2005, 01:33 AM
Ok, I uninstalled this tonight, and it crashed my database. Do youhave a log of all the changes that are made? How am I supposed to find out what files it edited and where?

Polo
05-12-2005, 02:19 AM
Ok, I uninstalled this tonight, and it crashed my database. Do youhave a log of all the changes that are made? How am I supposed to find out what files it edited and where?
That is easy, just use your backups..... you always do backups when you attempt to install a modification right?

mtha
05-12-2005, 06:22 AM
Ok, I uninstalled this tonight, and it crashed my database. Do youhave a log of all the changes that are made? How am I supposed to find out what files it edited and where?

was very surprised, thinking that this is my award hack making problems, wrote a reply, and look back, and recognize that this is not my hack :P oopsss

I think in the package, he has a file saying where to edit.

EricaJoy
06-13-2005, 04:06 PM
Yup crashed my stuff too. I think it broke the templates or something because every page I go to now gets the blank white screen. I can't really figure what broke where. No DB backups either because my hosts mysql client runs out of memory everytime I do a DB backup. I have file backups but uploading my originals doesn't seem to help matters. ARGH! Oh this was on VB 3.0.6 by the way.

Marco van Herwaarden
06-13-2005, 06:14 PM
If you get a blank page, this msot of the times can have 2 reasons:
- Extra characters (space, newline) before "<?php" or after "?>" in a php-file. Use a good editor (no DreamWeaver etc).
- Broken template: Go into Admincp, create a new style with no parent, and try browsing the board with that.

EricaJoy
06-13-2005, 07:18 PM
If you get a blank page, this msot of the times can have 2 reasons:
- Extra characters (space, newline) before "<?php" or after "?>" in a php-file. Use a good editor (no DreamWeaver etc).
- Broken template: Go into Admincp, create a new style with no parent, and try browsing the board with that.
Ah but I wouldn't use dreamweaver to edit my php files if i was forced to.I use either scite or gvim (whichever is handy).

As far as fixing my templates, I couldn't get into my AdminCP to do so period. Everything was white pages. I had one of my vB guru-ish type friends fix it for me so all is well again. (Thank goodness!)

Eagle Creek
07-05-2005, 10:41 AM
Ah but I wouldn't use dreamweaver to edit my php files if i was forced to.I use either scite or gvim (whichever is handy).

As far as fixing my templates, I couldn't get into my AdminCP to do so period. Everything was white pages. I had one of my vB guru-ish type friends fix it for me so all is well again. (Thank goodness!)
And now the BIG question: Will this hack be available for vBulletin 3.5 (with pluginsystem).

AnimeWebby??


==> Last Update: 03. Jun 2004
==> Last post: 10. Oct 2004, 04:57

jluerken
07-06-2005, 07:08 AM
And now the BIG question: Will this hack be available for vBulletin 3.5 (with pluginsystem).

AnimeWebby??



Important question and I would also like to know this.

wcbryant
07-23-2005, 05:19 PM
Important question and I would also like to know this.

And if not, will someone capable be able to step up and get permission to convert it. This is one of a number of key hacks that I'll need to have 3.5 ready before I move my site over, so I'm definitely looking forward to hearing if there are at least plans to do something with it.

InfiniteWebby
07-24-2005, 12:23 AM
And now the BIG question: Will this hack be available for vBulletin 3.5 (with pluginsystem).

AnimeWebby??


==> Last Update: 03. Jun 2004
==> Last post: 10. Oct 2004, 04:57

Maybe...

I closed down my vb early this year and have only just started working with vb3.5. This hack isn't on the top of my priorities but judging from how easy it was to convert some of my other hacks I might just give it a go. Otherwise I give anybody permission to convert it assuring they give me credit if a substantial amount of the same coding was used.

Eagle Creek
07-24-2005, 07:47 AM
Maybe...

I closed down my vb early this year and have only just started working with vb3.5. This hack isn't on the top of my priorities but judging from how easy it was to convert some of my other hacks I might just give it a go. Otherwise I give anybody permission to convert it assuring they give me credit if a substantial amount of the same coding was used.

Thank you Anime!

Eagle Creek
08-05-2005, 09:23 AM
Thank you Anime!

Btw, Is it possible to also let my mods give the awards?

InfiniteWebby
08-05-2005, 09:26 AM
Btw, Is it possible to also let my mods give the awards?

I'll see what I can do.

I am working on the port as we speak, but some of it is giving me some troubles. :ermm:

Eagle Creek
08-05-2005, 09:48 AM
I'll see what I can do.

I am working on the port as we speak, but some of it is giving me some troubles. :ermm:

Owh, cool.

Thx anime!

Blaine0002
08-05-2005, 06:25 PM
hm worked for me perfectly. im using 3.0.5, the only problem i had was the showthread.php and showpost.php file edits, but got around those easy.

Eagle Creek
08-05-2005, 08:42 PM
hm worked for me perfectly. im using 3.0.5, the only problem i had was the showthread.php and showpost.php file edits, but got around those easy.

Why? Is that code so massife rewritten?

safiel
08-10-2005, 10:52 PM
Thanks for updating it to 3.5. Eagerly awaiting :)

InfiniteWebby
08-10-2005, 10:54 PM
Some of the hooks I requested for vB3.5 will be implemented next version so you'll have to wait till then until this hack gets finished.

Eagle Creek
08-12-2005, 10:35 AM
Thanks for updating it to 3.5. Eagerly awaiting :)

Is it ? Cool! Thx AnimeWebby!

Gutspiller
08-19-2005, 10:03 PM
Does this hack work with 3.0.7 and also, what is the difference between the files? I see no mention of how they differ.

[HTL]AwardsMedalsCardsv2. 1.zip
[NORMAL]AwardsMedalsCardsv2. 1.zip

TosaInu
08-20-2005, 06:48 PM
Does this hack work with 3.0.7 and also, what is the difference between the files? I see no mention of how they differ.

[HTL]AwardsMedalsCardsv2. 1.zip
[NORMAL]AwardsMedalsCardsv2. 1.zip

Works with 3.07 for me.

Flow Fusion
10-09-2005, 02:46 PM
This won't install on 3.5...any updates?

Copperhead
10-21-2005, 08:53 AM
Agreed .. would love to see this working on 3.5 :)

Flow Fusion
10-21-2005, 09:06 AM
<a href="https://vborg.vbsupport.ru/showthread.php?t=94836&highlight=awards" target="_blank">https://vborg.vbsupport.ru/showt...ghlight=awards</a>

AshokForums.com
11-11-2005, 11:13 PM
please update this.. Would love it if this hack works for Vb 3.5.x

I dont like that yet another award system.. Like it more.. :)

Please update it!!

Flow Fusion
11-12-2005, 10:50 AM
please update this.. Would love it if this hack works for Vb 3.5.x

I dont like that yet another award system.. Like it more.. :)

Please update it!!


Why not? Just curious.

AquilaEagle
12-26-2005, 08:53 AM
Oh man i hope this works with 3.5.x

Also is it possible to make the awards appear below the user's signature (not in the sig) and on just the users first post per page?

Eagle Creek
12-26-2005, 02:32 PM
Is there a 3.5.x version??

InfiniteWebby
12-29-2005, 01:04 AM
Is there a 3.5.x version??

Only a half working version on my private forums.

Todd123
04-02-2006, 04:03 AM
Only a half working version on my private forums.

Any news on this hack? Just wondering. I know my members really enjoyed it on 3.0.

Hoobs
04-11-2006, 08:00 PM
Hi everyone!

I installed the hack on a 3.0.8 , but i get this error on showthread :

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting ')' in /www/htdocs/wxxxx/forum/showthread.php on line 71

What can i do to fix this error ?

Here my actually showthread.php

'polloption',
'polloption_multiple',
'pollresults_table',
// [START HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 18 ]
'pollresult',
'awards_bit'

// [END HACK='Awards/Medals/Cards by AnimeWebby' AUTHOR='AnimeWebby' VERSION='2.0' CHANGEID= 18 ]
'awards_bit'
'arcade_awards_bit',
);

Eagle Creek
04-11-2006, 08:12 PM
Only a half working version on my private forums.

Any news?

It's the reason I didn't upgrade yet..

Hoobs
04-14-2006, 05:00 AM
No one can help me with that problem ? ;9

hellbringer80
02-28-2007, 09:33 PM
Can someone help me? When I click continue with installation it goes to the "dophrases" thing but the page doesn't change, and the installer does nothing!?

XenonO
03-14-2007, 06:17 PM
I have got this problem too!:(

louisj1973
05-21-2007, 07:58 PM
Call me stooopid ..... but im new to this and wondered if anyone can give me a step by step installation guide to this ....

I've had a go and it doesnt work at all for me ....


Thanks :)

L

Chris Etc
07-29-2007, 08:44 AM
Anyone know how I can give the same award to a poster twice? Two identical medals showing up? It doesn't appear we can do this but I've seen it done.

Eagle Creek
03-17-2008, 11:55 AM
3.6.4, doesn't work?

NolePaul2008
02-07-2009, 03:21 PM
Hi, just tried to install this..I uploaded the files as instructed, went to the install page as instructed and when I went to begin process, nothing happened. Please help!

NolePaul2008
03-07-2009, 02:20 PM
Anyone?