~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~
| Step 6: Finishing up!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~

==>You need to run 'Fix broken user profiles' in the update counters part of the admincp. This is found under the nav bar 'Import & Maintenance' > 'Update Counters' > 'Fix broken user profiles'. This will add the awards for all the users currently in your database.

==>Don't forget to upload award.php to your admincp directory and awards.php to your root directory as well as any modified files to their appropriate directories.

Ok I did it same error message on the same line 679

Matter of fact I fixed everything...help meeeeeeee

lol

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 679

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php:679) in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php on line 2753

$url = str_replace('&', '&', $url); // prevent possible oddity
header("Location: $url");
unset($shutdownqueries['pmpopup']);

Unable to add cookies, header already sent.
File: /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions.php
Line: 3695

Now I'm getting this error message after I removed the spaces

Database error in vBulletin 3.0.0 Release Candidate 4:

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,

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 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,3861,3863,3866,3870,3873,3895,3896,3910)
ORDER BY dateline

mysql error: You have an error in your SQL syntax near ')
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS a' at line 19

mysql error number: 1064

Date: Wednesday 10th of March 2004 10:57:54 AM
Script: http://flowfusion.biz/forum/showthread.php?t=748
Referer: http://flowfusion.biz/forum/forumdisplay.php?f=2


Back to where I started

I can?t find


where paste this?

Thanks

Parse error: parse error in /hsphere/local/home/mojoblac/flowfusion.biz/forum/includes/functions_showthread.php on line 680

Fatal error: Call to undefined function: construct_postbit() in /hsphere/local/home/mojoblac/flowfusion.biz/forum/private.php on line 1331

When I click on any private messages. This is the only hack I really want please someone help me. Or at lease tell me how to revert my board back to the way it was.

Anime:

If I remember correctly, it was $awardsbit and $award_bit ...

It was a headache having to go through the code trying to figure out what was not working...

Shaz

@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.

@Alzeimer: Sorry, should be find:@Cyricx: You said you had trouble finding templates to edit. The names you just gave me are varibales hence the $ sign and if you meant you needed to find awardsbit and award_bit then you needed to add them not edit them.

Ok I PMed you and I went back to the way my board was till you can get back to me.

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.

Thanks m8, now I get a different error.

It stems from the install code of showpost.php and showthread.php

in my vb RC2 showthread.php I have

on your install script I have

I dont have reference to the annoucement.userid...

Hope you can help :)

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

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?

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?

Any one?

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

OK I figured it out..I think...everything seems to be working ok but the awards are not showing?

On the showthread.php I went edit 1 than 2 than 2. Not sure if that was correct but I don't get any errors on viewing the forum. Any suggestions on how to make them show anybody? I'll post up what I did later to help others when I come home from work in the morning.

<a href="http://flowfusion.biz/forum/awards.php" target="_blank">http://flowfusion.biz/forum/awards.php</a>

Is all I get. I can't get the images to show in the postbit. Or in the members.php.

Any suggestions on why the images are not showing?

aint tried this hack but lookin at your awards m8 it looks a good hack

im gonna grab and install local and will let u know how i get on with it see if i have same prob

cant go no furhter so u got further than me m8

the queries dont work for me

CREATE TABLE " . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM
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 '" . TABLE_PREFIX . "award ( awardid smallint(5) unsigned NOT NU

in fact i get same error trying any of the queries and they do have the ; on the end

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: 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 '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL aut

IGNORE - dumbo here forgot to remove the table prefix - not sure why that was in there.

I'm lurking here. Just take your time ok. And double check everything till you get to the "showthread.php" and remember the 1, 2, 2, thing I posted it will come in handy. If I'm right. Geez this is the heart and soul of my forum.

Replace " . TABLE_PREFIX . " with and table prefix you might be using for your copy of vb3 if not using a table prefix remove it from the query and then it will work.

If I get time tonight I will install this hack on my site and then tell you all what I had to change or what not.

Ooh help me, help me?

i cant go no further - the full hack is installed local but im getting this

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 = 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,41328)
ORDER BY dateline

mysql error: Unknown table 'useraward'

mysql error number: 1051

an di can tell u ive double checked though mysql front and the table is deffo there with no info in it when i query it so im double stuck now as im lost

thi ssi the way i ran the query as i dont use prefixs

CREATE TABLE useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

Try repairing the table and see what happens.

tried it m8

no luck - was first think i thought of - ive even dropped the 2 tables and re-added em

could anything else be causing that error ??

i really stuck here at moment as i can view main page of my test board but i get the error when i got to view any post

Im on vb3 rc4 if that helps

I did have some trouble with showthread.php
what it told me to find i could`nt

==>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)

in mine i never had the announcement.userid on what i was meant to find - it simpley was`nt in my files so i just replaced what was there

ive put me old copy of showthread back and i can now read posts etc so obviously the problem lies in showthread so how can i edit that if what im meant to find simply aint there ??

someone must have this installed on v3 rc4 - cause it does look like a good hack as the admin part works for adding em and the awards.php page displays em fine but i just cant view me board :( cause i cant find what im meant to replace

I will look at this latter tonight like I said if I have time.

im a genuis LOL

it works fine and every one appears in postbit

all i did was this in showthread was replace every occurance of where

==>Find:

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

with this

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

u notice on the first line i did`nt add announcement - i replaced it with user (userid=user.userid) and it works fine

I aint sure what damage i may of doen to the rest of the board though by ommititing announcements out of it

I added what you said but i still don't get the images to load anywhere but that page I posted. What did you do to your post bit? I recall in the other one 2.0 it was something about showing the image URL

oh yeah did you get the images to show in the admincp?

lo flow

the images dont show in the admin cp just the name and then u tick what pic u want to show

as for postbit all i added was what was in the file - i had no problems there at all.

Its showthread thats the problem m8

find all occurances and swap em for the 2 lines i posted above as this is the only way mine worked and now i have no probs at all (opps touch wood i should`nt say that)

wot version are u on m8 ?

damn I might just start from scrach. I don't see the images at all in the post bit

u dont need to start from scratch

just replace

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=announcement.userid) - (which is`nt even their mind you as announcement.userid aint there so search upto that bit and replace thelot )

and replace with

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

replace both in showthread as there is 2 occurances.


also images do appear in admin cp in awards manager - they dont appear when u bring an account up to give em to that user so hacks works fine