vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Yet Another Awards System [1.2.1] (https://vborg.vbsupport.ru/showthread.php?t=78934)

TTG 03-28-2005 02:29 PM

Very useful hack :)

All went well with the install .. added new awards to test the hack and when award was issued received this database error :-

Code:

Database error in vBulletin 3.0.6:

Invalid SQL:
                        SELECT user.username,userfield.field10,userfield.field11,userfield.field12,userfield.field13,userfield.field14
                FROM user, userfield
                WHERE (user.userid=1) and (userfield.userid=1)
               
mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

I ran the sql updates included in the install file and tried several different user ID's !?

GamerzWorld 03-28-2005 03:02 PM

I want to wait before i uninstall current one to see a demo. Looking good tho

mtha 03-28-2005 04:08 PM

Quote:

Originally Posted by TTG
Very useful hack :)

All went well with the install .. added new awards to test the hack and when award was issued received this database error :-

Code:

Database error in vBulletin 3.0.6:

Invalid SQL:
                        SELECT user.username,userfield.field10,userfield.field11,userfield.field12,userfield.field13,userfield.field14
                FROM user, userfield
                WHERE (user.userid=1) and (userfield.userid=1)
               
mysql error: Unknown column 'userfield.field10' in 'field list'

mysql error number: 1054

Date: Monday 28th of March 2005 05:13:22 PM
Script: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=awardusers&award_id=1
Referer: http://www.thetechguys.co.uk/retreat/admincp/award.php?do=manage
Username: The Tech Guy
IP Address: 82.44.23.235

I ran the sql updates included in the install file and tried several different user ID's !?

Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields :D

Blackbeard 03-28-2005 04:17 PM

Does anyone know where there are award icons on the net that can be used with this

mtha 03-28-2005 04:36 PM

Quote:

Originally Posted by Blackbeard
Does anyone know where there are award icons on the net that can be used with this

There are few icons in the zip file. The Icons (c) belong to phpBB Medal hack and some other place online

TTG 03-28-2005 04:47 PM

Quote:

Originally Posted by mtha
Please download and replace the award.php in your admincp folder with the award.php file attached in the first post.

It was 4am at that time, I forgot to take out those fields :D

That solved the problems .. thanks for the quick update.

All running with no problems on 3.0.6

TTG 03-28-2005 05:24 PM

Quote:

Originally Posted by lsmba
I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy... :)

Thanks all,

lsmba

Awards when rewarded at the moment can only be viewed in members profile. Next upgrade will hopefully allow rewards to be shown in postbit display for rewarded members.

yinyang 03-28-2005 05:55 PM

omg, this would be the best!

i can't wait for the post-bit code and will definitely install then.

Jon@Refresh 03-28-2005 06:47 PM

Do you know what the difference between this and AnimeWebby's hack is?

mtha 03-28-2005 07:15 PM

Quote:

Originally Posted by lsmba
I'm not sure what is meant by..."cannot be display awards in postbits"

What effect does this have on the functionality of the hack? Can someone enlighten the less tech-savvy... :)

Just that I want to release the first version ASAP, so I just thru something out for people to discuss.
It is not "cannot", it's just not yet implemented. I am working on postbits, update will be available soon.

Quote:

Do you know what the difference between this and AnimeWebby's hack is?
Yes I do :D





- Database structure is different
- Award managements is different (read description in first post)
- Support is different (I am currently supporting the hack)
- and ... you can add to the list


All times are GMT. The time now is 01:42 PM.

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.01188 seconds
  • Memory Usage 1,744KB
  • 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
  • (2)bbcode_code_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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