vb.org Archive
Page 8 of 13 « First 67 8 910 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)

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

Code:
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
Quote:
Originally Posted by Blam Forumz
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:
Code:
        // 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 :

PHP Code:
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
Quote:
Originally Posted by dethfire
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
Quote:
Originally Posted by GlitterKill
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
Quote:
Originally Posted by apokphp
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
Quote:
Originally Posted by apokphp
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:

PHP Code:
// [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:

PHP Code:
// [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!!

Code:
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....

Quote:

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.

PHP Code:
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
Quote:
Originally Posted by AnimeWebby
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 :)


All times are GMT. The time now is 07:40 PM.
Page 8 of 13 « First 67 8 910 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.02006 seconds
  • Memory Usage 1,885KB
  • 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_code_printable
  • (4)bbcode_php_printable
  • (7)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