vb.org Archive - Yet Another Awards System [1.2.1]

Page 7 of 25

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)

- - Yet Another Awards System [1.2.1] (https://vborg.vbsupport.ru/showthread.php?t=78934)

mtha	04-02-2005 06:50 AM

Quote:

Originally Posted by fuse3k

Thank you very much for this Award hack. This will come in handy.

I need a quick hand though; I received this SQL error in the Admin CP after I added an award:

Code:

Database error in vBulletin 3.0.7:



Invalid SQL: 

                        SELECT * 

                        FROM forumsaward_user

                        WHERE award_user.award_id=1

                

mysql error: Unknown table 'award_user' in where clause

It was the prefix problem.
Upload this file into your admincp.php and you will be fine.

moley

04-02-2005 06:46 PM

hehehe i missed one edit. thanks it fixed now.

Found an error. If you put anything like ' in the issue reason it gives you a database error

Code:

 Database error in vBulletin 3.0.7:

 

 Invalid SQL: 

                 INSERT INTO award_user

                 (award_id, userid, issue_reason, issue_time) 

                                 VALUES ( '1', '2', 'He's', 1112474351)

         

 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', 1112474351)' at line 

 

 mysql error number: 1064

mtha	04-02-2005 09:05 PM

Quote:

Originally Posted by moley

Found an error. If you put anything like ' in the issue reason it gives you a database error

Thanks moley, I missed adding slashed at one query :D

fixed in my code and releasing a new version in few hours

idea: send PM/email to member when he/she got award :D

Koutaru

04-03-2005 02:27 AM

Yes that's actually a great idea too :) Can't wait for the new release (I've been trying to check every day ;))

mtha	04-03-2005 08:31 AM

YAAS 1.1 is AVAILABLE, please check the first post for more information

Hack Version: 1.1.050402

2005.04.03 - Version 1.1
- Can Create/Edit/Remove/Reorder categories/sub-categories in ACP (with category name and description)
- Can Move one (or all) award from one category to another, or set it un-classified (not displayed in the list in public site)
- Can re-order awards (in ACP)

How to UPGRADE/INSTALL:
Read README.txt and follow instructions

trulylowcarb

04-03-2005 10:03 AM

i think I got it first! :D
Seems to be working first try too, (hacked up vb3.07 and cmps1.1 with Gallery)
Now I just need to figure out how to set up award icons and add images and all that...
THANK YOU! Your installer is sweee-eeeet. ^5 "HacNho", which really cracked me up.

trulylowcarb

04-03-2005 10:27 AM

Hmmmm. It IS 430 am here, ....Your hack install instruction is excellent but I haven't a clue how to use this wonderful mod now that it is in there (if it is in there correctly?)

Never mind, I was just being 430 stupid. {Hate that .. but if I hadn't embarrassed myself asking I probably wouldn't have found it, LOL}

trulylowcarb

04-03-2005 10:42 AM

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.

Harry72

04-03-2005 11:16 AM

Yes, i found this too.

Go to awards_category template and than search for this:

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

and replace that with

<td class="thead" nowrap="nowrap">$vbphrase[award_icon]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_image]</td>
<td class="thead" nowrap="nowrap">$vbphrase[award_name] /

Cheers
Harry

mtha	04-03-2005 05:38 PM

Quote:

Originally Posted by trulylowcarb

I did find a legitimate oops for you though, an easy one I am sure. There seems to a duplicate column for Award Icon on the main awards page, as shown here.

:) oops, sorry, it was 4:30 my time too, I grap the wrong template, used it before adding phrases :D The installer was updated with the fix.

make the changes as Harry says, and you will be fine.

For those who see two "Award Icon" columns in the show awards page (/awards.php), please apply Harry's fix above.

If you have a fresh install, you can also run uninstall and re-install script. No file change.

Harry, would you click Install button please :) Thanks

All times are GMT. The time now is 11:52 AM.

Page 7 of 25

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01352 seconds Memory Usage 1,745KB 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 (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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
Messages: