vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Show Thread Enhancements - [AJAX] Post Thank You Hack (https://vborg.vbsupport.ru/showthread.php?t=122944)

Abe1 09-15-2006 12:50 PM

Quote:

Originally Posted by brvheart
also for the upgrade is it just reup the xml and allow overwrite or are there changes in the template edits as well?

There were no changes in the template edits only in the templates the go along with this hack.

brvheart 09-15-2006 12:52 PM

thank you :)

scorpsy 09-16-2006 12:19 PM

Does anyone know why I am getting this error & how I can fix it I know it is in my database but I can't find it anywhere. I love this hack :)

Database error in vBulletin 3.6.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'post_thanks_on_off',
'post_thanks',
'0',
'1',
'boolean',
'yesno',
10,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_off',
'post_thanks',
'',
'',
'free',
'',
20,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first_all',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first',
'post_thanks',
'',
'',
'free',
'',
40,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_all',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_forum',
'post_thanks',
'',
'',
'free',
'',
60,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_usergroup_using',
'post_thanks',
'',
'',
'free',
'',
70,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_user_useing',
'post_thanks',
'',
'',
'free',
'',
80,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_reputation',
'post_thanks',
'0',
'0',
'number',
'',
90,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_post_count',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
100,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_delete_own',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
110,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_poster_button',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
130,
0,
1,
'',
0,
'post_thanks'
);

MySQL Error : Duplicate entry 'post_thanks_on_off' for key 1
Error Number : 1062
Date : Saturday, September 16th 2006 @ 03:08:33 PM

Abe1 09-17-2006 03:01 AM

Quote:

Originally Posted by scorpsy
Does anyone know why I am getting this error & how I can fix it I know it is in my database but I can't find it anywhere. I love this hack :)

Database error in vBulletin 3.6.1:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, validationcode, blacklist, product)
VALUES
(
'post_thanks_on_off',
'post_thanks',
'0',
'1',
'boolean',
'yesno',
10,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_off',
'post_thanks',
'',
'',
'free',
'',
20,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first_all',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
30,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_forum_first',
'post_thanks',
'',
'',
'free',
'',
40,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_all',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
50,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_date_forum',
'post_thanks',
'',
'',
'free',
'',
60,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_usergroup_using',
'post_thanks',
'',
'',
'free',
'',
70,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_user_useing',
'post_thanks',
'',
'',
'free',
'',
80,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_reputation',
'post_thanks',
'0',
'0',
'number',
'',
90,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_post_count',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
100,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_delete_own',
'post_thanks',
'1',
'1',
'boolean',
'yesno',
110,
0,
1,
'',
0,
'post_thanks'
),
(
'post_thanks_poster_button',
'post_thanks',
'0',
'0',
'boolean',
'yesno',
130,
0,
1,
'',
0,
'post_thanks'
);

MySQL Error : Duplicate entry 'post_thanks_on_off' for key 1
Error Number : 1062
Date : Saturday, September 16th 2006 @ 03:08:33 PM

Are going from vb3.0 -> vb3.6?

There are 4 quaries you must run first. You can find them in the vb3.5 version download.

scorpsy 09-17-2006 08:09 AM

Abe1 Yes I went from 3.0 to 3.6

What exactly do I have to do & run I am a bit of a newb :rolleyes:

MaviJean 09-17-2006 08:54 AM

You may want to change;

Code:

<version>5.11</version>
to

Code:

<version>5.1</version>
in the plugin file ;)

SCRIPT3R 09-17-2006 05:43 PM

Quote:

Originally Posted by scorpsy
What exactly do I have to do & run I am a bit of a newb :rolleyes:

Quote:

Originally Posted by Abe1
There are 4 quaries you must run first. You can find them in the vb3.5 version download.

You can find them in the vb3.5 version download.

scorpsy 09-17-2006 06:20 PM

Quote:

Originally Posted by GearTripper
You can find them in the vb3.5 version download.


Where and what do I do with them?

I looked through all the 3.5.1 files & only found 1 and that was in admicp folder.

Abe 1 said I have to run 4 queries but I don't understand what to do.

Aylwin 09-18-2006 10:47 AM

Quote:

Originally Posted by Abe1
Maybe if you play around with the template.

I've added a 'Thanked' column to my Members List page so it's easy to check who's been thanked the most. If anyone else is interested, here's what I did.

Open memberlist.php and find:
Code:

                case 'posts':
                        $sqlsort = 'user.posts';
                        break;

after, add:
Code:

                case 'thanked':
                        $sqlsort = 'user.post_thanks_thanked_posts';
                        break;

Edit the memberlist template and find:
Code:

        <if condition="$show['postscol']"><td class="thead" nowrap="nowrap"><a href="$sorturl&amp;order=DESC&amp;sort=posts&amp;pp=$perpage$usergrouplink">$vbphrase[posts]</a> $sortarrow[posts]</td></if>
after, add:
Code:

        <td class="thead" nowrap="nowrap"><a href="$sorturl&amp;order=DESC&amp;sort=posts&amp;pp=$perpage$usergrouplink">Thanked</a> $sortarrow[thanked]</td>
Edit the memberlist_resultsbit template and find:
Code:

        <if condition="$show['postscol'] AND exec_switch_bg()"><td class="$bgclass">$userinfo[posts]</td></if>
after, add:
Code:

        <td class="$bgclass">$userinfo[post_thanks_thanked_times]</td>

Abe1 09-18-2006 12:13 PM

Quote:

Originally Posted by scorpsy
Where and what do I do with them?

I looked through all the 3.5.1 files & only found 1 and that was in admicp folder.

Abe 1 said I have to run 4 queries but I don't understand what to do.

In the installation instructions.


All times are GMT. The time now is 12:24 AM.

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.02699 seconds
  • Memory Usage 1,812KB
  • 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
  • (8)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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