vb.org Archive
Page 10 of 13 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   [HTL] & [TXT] Awards/Medals/Cards Hack [vB3] (https://vborg.vbsupport.ru/showthread.php?t=61108)

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
Quote:
Originally Posted by RetroDreams
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
Quote:
Originally Posted by deb0
Are there any issues with this hack and 3.03?
Works fine for me :).

wwesn1 01-22-2005 05:31 PM
Quote:
Originally Posted by rex_b
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
Quote:
Originally Posted by GlitterKill
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
PHP Code:
    // 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

PHP Code:
$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
Quote:
Originally Posted by jluerken
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
Quote:
Originally Posted by jluerken
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
Quote:
Originally Posted by jluerken
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:

PHP Code:
// ###################### 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
Quote:
Originally Posted by Glenn379
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
Quote:
Originally Posted by Glenn379
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=med...-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
Quote:
Originally Posted by Creed
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
Quote:
Originally Posted by deb0
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?


All times are GMT. The time now is 07:42 PM.
Page 10 of 13 « First 89 10 1112 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02234 seconds
  • Memory Usage 1,884KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_php_printable
  • (11)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete