vb.org Archive
Page 6 of 14 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Miscellaneous Hacks - Yet Another Awards System (https://vborg.vbsupport.ru/showthread.php?t=187600)

pretke 09-07-2008 12:31 PM
Hi,

I installed this hack.

Vb version: vbulletin 3.7.3 Patch Level 1

User profil error message:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/member.php(504) : eval()'d code on line 91:(

FiMeTi 09-07-2008 01:05 PM
this is the same message we all get.
Hope this will be fixxed soon ....

VB-STYLE 09-07-2008 03:14 PM
Quote:
Originally Posted by pretke (Post 1616566)
Hi,

I installed this hack.

Vb version: vbulletin 3.7.3 Patch Level 1

User profil error message:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/member.php(504) : eval()'d code on line 91:(
me to ...

ImmortalForums 09-07-2008 03:25 PM
For those who have the error change to MySQL from MySQLi

kefallon 09-07-2008 06:04 PM
HELP-This mod is just what i am looking for but my database is running on MYSQLi and i am no expert in sorting program problems .
I am running vbulletin 3.7.1
Simple question i hope
Will it work or is it going to throw up error messages?:erm::erm::erm:

FiMeTi 09-07-2008 07:03 PM
Quote:
Originally Posted by ImmortalForums (Post 1616676)
For those who have the error change to MySQL from MySQLi
Mate how do we do that? Sorry for that newbie question, but can we change that in the Mod or do we have to change that in our DB? When we do that, might we get a non 100% working vBulletin tho?

Gotta google for the difference yet tho. ^^

cheers

Xanlamin 09-08-2008 03:38 PM
As I do not use MySQLi nor have ever worked with it and use only MySQL I do not foresee this change anytime soon. Sorry for those who can not change.

Xanlamin 09-08-2008 04:32 PM
I just went through every page here (14 of them) and recompiled a list of all your errors, suggestions, ideas, issues, and whatnot. It is 15 pages long in word.doc, we will be hitting this hard over the next week and am in hopes of having another release by this weekend/early next week.

Not everything suggested will be implemented as of yet, our main concern right now is getting issues and errors fixed first then we can start implementing other things...that may cause errors, so we don't have a hack that is nothing but errors we will get to those first.

Please be patient....I know you all already have been and we appreciate it very much.

VB-STYLE 09-08-2008 09:13 PM
Quote:
Originally Posted by Xanlamin (Post 1617557)
I just went through every page here (14 of them) and recompiled a list of all your errors, suggestions, ideas, issues, and whatnot. It is 15 pages long in word.doc, we will be hitting this hard over the next week and am in hopes of having another release by this weekend/early next week.

Not everything suggested will be implemented as of yet, our main concern right now is getting issues and errors fixed first then we can start implementing other things...that may cause errors, so we don't have a hack that is nothing but errors we will get to those first.

Please be patient....I know you all already have been and we appreciate it very much.
Thank you Xanlamin :up:

Deimos 09-09-2008 08:18 AM
Thanks for your hard work :)

AuroraStorm 09-09-2008 09:44 PM
Works just fine. Where can I get more medals?

*installed*

Tanpapasmurf 09-09-2008 11:12 PM
Thanks for your hard work, My user's are now striving to play better on the field to get awards on our forum.

Thank you so much.

AuroraStorm 09-10-2008 12:31 AM
Uh, at the rate of sounding like I'm picking a scab (which I'm doing), how can I change the outgoing PM?

Quote:
Congratulation! You have got a new award!
Quote:
On behalf of myforums, it is with great honor that I extend to you best wishes and congratulations as you are receiving Gold Medal award.

The reason that goes with your award is:
...because this is kind of busted...

kurv 09-10-2008 02:13 AM
Quick question.... is there a way to create a link that when you click on the award, it takes you to the thread they received the award for..? I guess it would have to have a URL link box for each award given that it links to.

Is that possible... and what would this modification cost me :)

Thank you!! and thanks for the hard work!!

ImmortalForums 09-10-2008 08:32 PM
For those having the MySQLi error on their member pages open the plugin with your text editor of choice

Go to line 704 or find
Code:
$total_awards = mysql_num_rows($alluserawards);
and change to
Code:
$total_awards = mysqli_num_rows($alluserawards);
I dont know how to make this work in MySQL and MySQLi but MySQLi is recommended over MySQL by both the vbulletin developers and creates of mysql so this is a simple fix.

Maybe this can be thrown into the main post.

pretke 09-11-2008 06:05 AM
Quote:
Originally Posted by ImmortalForums (Post 1619391)
For those having the MySQLi error on their member pages open the plugin with your text editor of choice

Go to line 704 or find
Code:
$total_awards = mysql_num_rows($alluserawards);
and change to
Code:
$total_awards = mysqli_num_rows($alluserawards);
I dont know how to make this work in MySQL and MySQLi but MySQLi is recommended over MySQL by both the vbulletin developers and creates of mysql so this is a simple fix.

Maybe this can be thrown into the main post.
Working!
Thank you:up:

liwo 09-11-2008 05:17 PM
Thanks for looking into that! I wanted to do, too, but haven't come round to update my testforum to 3.7.3 yet...

To make it work with both, mysql and mysqli, you could just use the vBulletin API:

PHP Code:
$total_awards = $db->num_rows($alluserawards); 
I haven't tested it yet but I'm sure it will work.

ssslippy 09-12-2008 04:03 PM
ah so $db replaces mysql supper easy fix!

nul7 09-13-2008 06:13 AM
Installed and working fine except for the links in the postbit did not link directly to the "My Awards" tab in the member profile. Here is the fix:

In member.php find:
Code:
        'contactinfo' => array(
                'class' => 'ContactInfo',
                'title' => $vbphrase['contact_info'],
        ),

Below that add the following:
Code:
        'myawards' => array(
                'class' => 'MyAwards',
                'title' => $vbphrase['my_awards'],
        ),

NOTE: It appears the coder is trying to do this with the plugin "YAAS in Member Profile - Profile", but it doesn't seem to be working.

Then, replace the entire awards_postbit_display template with:
Code:
<!-- show awards -->
<if condition="$post[showuserawards]">
<br />
<fieldset><legend><a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</fieldset>
</if>
<!-- /show awards -->

For anyone who has edited this template, all you need to do is replace the "#award" appended on the links with "&tab=myawards".

Hope that helps!

liwo 09-13-2008 07:23 AM
Thanks for that info! I tested it and there is no need to change anything in member.php. It works with the code in the plugin.
The template edit of course is necessary.

nul7 09-13-2008 08:00 AM
Quote:
Originally Posted by liwo (Post 1620962)
Thanks for that info! I tested it and there is no need to change anything in member.php. It works with the code in the plugin.
The template edit of course is necessary.
Strange... mine wouldn't work without doing the file edit. Must have interference from another plugin/product. Sorting that out will give me something to do tomorrow... er... later today. lol

Blackhat 09-13-2008 02:34 PM
I dont know if anyone requested this, but when you click the award icons in postbit you are taken to the member profile page.

Is it possible to be taken to the actual award tab on the member profile page ?

Thanks for a great mod! :)

AuroraStorm 09-13-2008 03:01 PM
I'm still waiting on word on how to change the message.

liwo 09-13-2008 04:17 PM
Quote:
Originally Posted by Blackhat (Post 1621217)
I dont know if anyone requested this, but when you click the award icons in postbit you are taken to the member profile page.

Is it possible to be taken to the actual award tab on the member profile page ?

Thanks for a great mod! :)
Look 3 Posts above yours, thank you. (You only need to do the template edit)

SVTCobraLTD 09-13-2008 07:56 PM
Can someone post how a link to one of their member profiles that shows how it should look? I cannot get the awards to show in members profiles. This is on 3.6.10pl2

inciarco 09-13-2008 09:50 PM
Quote:
Originally Posted by nul7 (Post 1620952)
Installed and working fine except for the links in the postbit did not link directly to the "My Awards" tab in the member profile. Here is the fix:

In member.php find:
Code:
        'contactinfo' => array(
                'class' => 'ContactInfo',
                'title' => $vbphrase['contact_info'],
        ),

Below that add the following:
Code:
        'myawards' => array(
                'class' => 'MyAwards',
                'title' => $vbphrase['my_awards'],
        ),

NOTE: It appears the coder is trying to do this with the plugin "YAAS in Member Profile - Profile", but it doesn't seem to be working.

Then, replace the entire awards_postbit_display template with:
Code:
<!-- show awards -->
<if condition="$post[showuserawards]">
<br />
<fieldset><legend><a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[award_showcase]</a></legend>
<div>
$post[userawards]
<br>
<a href="member.php?u=$post[userid]&tab=myawards" title="$vbphrase[more_awards]">$vbphrase[total_awards]</a>: $post[num_awards]
</div>
</fieldset>
</if>
<!-- /show awards -->

For anyone who has edited this template, all you need to do is replace the "#award" appended on the links with "&tab=myawards".

Hope that helps!
Great Help, Thank You Very Much, Works Really Fine. :up::up:

I'd also like to Add that for the Postbit Icons of the Awards to Point Right inside the Tab, you should also Modify the "awards_bit" Template Replacing the Current Code with the Following One (notice that I only Added a "&tab=myawards" before "#aw_issue$award[issue_id]" and after "u=$award[userid]":

Code:
<a href="member.php?$session[sessionurl]u=$award[userid]&tab=myawards#aw_issue$award[issue_id]"><img src="$award[award_icon_url]" alt="$award[award_name]" border="0" /></a>&nbsp;
(All of This Thanks To Your Very Useful Indications). :up:

My Best Regards.

:)

Xanlamin 09-13-2008 10:01 PM
This will not work on 3.6 version, as they do not have the tabs in the profile, you need version 2.1.4 of this hack which can be found HERE

Scarface Claw 09-14-2008 03:04 AM
Quote:
Originally Posted by ImmortalForums (Post 1619391)
For those having the MySQLi error on their member pages open the plugin with your text editor of choice

Go to line 704 or find
Code:
$total_awards = mysql_num_rows($alluserawards);
and change to
Code:
$total_awards = mysqli_num_rows($alluserawards);
I dont know how to make this work in MySQL and MySQLi but MySQLi is recommended over MySQL by both the vbulletin developers and creates of mysql so this is a simple fix.

Maybe this can be thrown into the main post.


Awesome, this fixed my problem also, thanks.


A little bug, my awards disappear from post bit after I edit a post, but display again once I click away.

hjmaier 09-14-2008 07:57 PM
I detected a small error.

I use links with [url] tags in awards. It seems that tags are not turned into html when displaying in the member profile. I can only see the tags there.

oh, i converted from 2.1.4. There everything was fine.

Best regards
hj

FiMeTi 09-15-2008 02:41 PM
Quote:
Originally Posted by ImmortalForums (Post 1619391)
Go to line 704 or find
Code:
$total_awards = mysql_num_rows($alluserawards);
and change to
Code:
$total_awards = mysqli_num_rows($alluserawards);
Cheers bro! It works like a charm ... thx very much

Saint_ago 09-15-2008 06:37 PM
Quote:
Originally Posted by Scarface Claw (Post 1621677)
A little bug, my awards disappear from post bit after I edit a post, but display again once I click away.
I'm having the same here!

Tanpapasmurf 09-16-2008 12:11 AM
I remember reading that there was a update in the works for the past weekend?

Any news on this?

gorentals 09-17-2008 02:01 PM
Anyway to get this to display under the visitor messages on the main profile instead of a tab? This would be for version 3.7.3

Thanks

kurv 09-17-2008 03:24 PM
Okay, asking again :)

Quick question.... is there a way to create a link that when you click on the award, it takes you to the thread they received the award for..? I guess it would have to have a URL link box for each award given that it links to.

Is that possible... and what would this modification cost me :)

Thank you!! and thanks for the hard work - installed and donated!!

Xanlamin 09-17-2008 03:54 PM
Thanks kurv;

Where would you like the link placed? cause right now when you click on an award it should take you to there profile (soon to the awards tab itself), we may be able to figure a way to have it choose able to which it would take you to.

to gorentals: this would be possible yes as an option.

As to an update...we where not able to work on this as much as we would have liked to this past week...I really hate emergancies, expect some major updates coming the weekend of the 27th.

gorentals 09-17-2008 04:52 PM
Ok thanks Xanlamin....Love your mod btw.

Is this something I can do or in the coming update?

Thanks again

Xanlamin 09-17-2008 05:56 PM
Not sure, I am only familure with certain parts of the code, my brother Cypher knows more of the deeper code and how to do the options aspect.

Tanpapasmurf 09-17-2008 07:07 PM
Thanks for your hard work.

dknelson 09-18-2008 12:58 AM
I had this working for some time now but suddenly members can't request an award. If you click on "request award", the page refreshes and nothing happens.

Then if I try to ISSUE an award from the admin panel, I get the following error.

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:

                        SELECT userid, username
                        FROM user
                        WHERE username = 'Sleeperhawk's Mechanic';

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 's Mechanic'' at line 3
Error Number  : 1064
Request Date  : Wednesday, September 17th 2008 @ 09:53:41 PM
Error Date    : Wednesday, September 17th 2008 @ 09:53:41 PM
Script        : http://www.mysite.org/forum/admincp/award.php?do=dogiveaward
Referrer      : http://www.mysite.org/forum/admincp/award.php?do=awardusers&award_id=1
IP Address    : 72.69.93.240
Username      : admin
Classname    : vB_Database
MySQL Version : 5.0.51a-community

dknelson 09-18-2008 01:07 AM
OK folks....I looked into this a bit deeper. The problem with the database error seems to be only when there is an apostrophe in the username. This user is Sleeperhawk's Mechanic. I can give awards to members with the apostrophe or to this one if I use the userID instead of the name. I can live with that but is there a fix for it?

As for not being able to request an award. That may be just because I, as admin, am trying to do so. Maybe it won't allow me to. Never tried before but was trying to test it in researching the above problem and noticed that it doesn't work if I click on "request award".


All times are GMT. The time now is 07:46 PM.
Page 6 of 14 « First 45 6 78 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.01829 seconds
  • Memory Usage 1,847KB
  • 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
  • (16)bbcode_code_printable
  • (1)bbcode_php_printable
  • (12)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