vb.org Archive
Page 10 of 49 « First 89 10 111220 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)

Flow Fusion 03-11-2004 02:20 PM
Quote:
Originally Posted by AnimeWebby
@Flow Fusion: As far as I can tell you have a different version or applied the code changes in the wrong place. There shouldn't be any code changes on line 679 or around there in v2. Send me your functions_showthread.php via pm and I will have a look.
Ok I PMed you and I went back to the way my board was till you can get back to me.

CHeeKY 03-12-2004 11:45 AM
AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there :)

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards

InfiniteWebby 03-13-2004 10:59 PM
Quote:
Originally Posted by CHeeKY
AnimeWebby just wanted to say thanks for all the support so far, ya doing well kid hang in there :)

I have a couple of things, working of a vb3rc2, have installed the hack and all seems ok apart from:

1. When I add a hack or modify I get a message telling me that the phrase "Saved named x saved succesfully" could not be found, I checked and its there for sure.

2. When I goto a user and click Yes to a medal and put a reason, I then click save, and it doesnt save, I go back to the user and its set to NO and viewing the users profile shows nothing. So basically its not saving the action. Any ideas?

Regards
1. do you mean when you try to add an award? if so make sure the phrase is in the control panel stop messages.

2. If you are using the htl version of the hack it might have something to do with the comments it places before and after any file edits. So just check out admincp/user.php and if you have any comments in between mysql then remove them. If not just make sure you applied all the changes to that file.

CHeeKY 03-14-2004 12:58 PM
Thanks m8, now I get a different error.

Code:
Database error in vBulletin 3.0.0 Release Candidate 2:

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=announcement.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(deletionlog.primaryid = post.postid AND deletionlog.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 (0,2175,2213,2226,2710,2753,2824,2826,2827,2829,2832)
ORDER BY dateline

mysql error: Unknown table 'announcement' in on clause

mysql error number: 1109
It stems from the install code of showpost.php and showthread.php

in my vb RC2 showthread.php I have

Code:
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
                LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid)
                LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
on your install script I have

Code:
>Find:

        LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

        LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
        LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)
I dont have reference to the annoucement.userid...

Hope you can help :)

CHeeKY 03-14-2004 01:28 PM
ok update :)

I took out the annoucements and fixed the user.php and its all working great :)
Top marks for the hack m8 :D:D:D

Flow Fusion 03-14-2004 06:53 PM
Ok in some of the files it says thing like edit "poll results" and add "poll result add award" or something. But I was wondering do you edit ALL of the poll results etc. Or just the first ones?

Flow Fusion 03-15-2004 10:02 PM
geez it's seems when I upload the "showthread.php" everything goes to hell. I don't know which one to edit. From the

In /showthread.php
-------------------------------

==>Find:

'pollresult'

==>Replace With:

'pollresult',
'awards_bit'

==>Find:

usertextfield.*,

==>Replace With:

usertextfield.*, useraward.*,

==>Find:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

==>Replace With:

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)
LEFT JOIN " . TABLE_PREFIX . "useraward AS useraward ON(useraward.userid = user.userid)

Their is 2 of each these. And on the LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid)

in my file it has
LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid = user.userid)

See how it has AS as oppose to ON?

Please help?

Flow Fusion 03-16-2004 08:58 PM
Any one?

lasto 03-16-2004 09:43 PM
not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two :)

Flow Fusion 03-16-2004 11:58 PM
Quote:
Originally Posted by lasto
not installed this m8 but if there is 2 here is what i would do

i would try it on the first one then save file (always backup orginal files first) and if it dont work then try it on the second one.

Its gotta be one of the two :)
Hey funk it why not? LOL


All times are GMT. The time now is 09:13 PM.
Page 10 of 49 « First 89 10 111220 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.01663 seconds
  • Memory Usage 1,759KB
  • 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
  • (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