I can't find this code in misc.php

maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0);

What do I do?

I am using 2.2.1

Can U Give Me A Link To Where Da Instructions are? I have version 2.03...Thanx...

Same problem here. How did you fix this one?

Anybody has a link to instructions for post it here?

Upload the install_starshack.php into your admin folder and execute it, then you will get your instructions :p

I tried to execute it but it comes up an error sayin "ERROR Executing Associated Application Or Association Not Found."
Can any body help? I need Da Instructions...

Check this link http://vbulletin.com/forum/showthrea...threadid=32953

Hope it helps,

Hello anybody?

what the hell?


On mine , I uploaded the images and installed it right, but yet, it only show up under, really too, random people??

what the hell is going on??


Heres the link to my board

ochroma.net/forum

please help me guys!:(

I have installed Stars

some of my users who try to register get this error when they submit...

There seems to have been a slight problem with the MacUser.de community! database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.

I received an email:

Subject: vBulletin (forum) Database error!


Database error in vBulletin 2.2.1:

Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,yahoo,signature,admin email,showemail,invisible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotification,receivepm,emailo npm,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,starlevel,stari mg) VALUES (NULL,'freeze','a6008231fa64ff879ecb286a657b6a99', 'eric@macinmotion.com','0','','0','http://','114975541','','','','0','1','0','Member','10076 59894','1','-1','1007659894','1007659894','2','+1','1','1','0', '15','0000-12-9','-1','1','80.128.211.49','0','0','1','1','star1','0' )
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Thursday 06th of December 2001 06:31:34 PM
Script: http://www.macuser.de/forum/forum/register.php
Referer: http://www.macuser.de/forum/register.php

please help me

Changes to
register.php (2)
Step 2 of 2

>>my change

$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes(md5($password) )."','".addslashes(htmlspecialchars($email))."',". $newstyleval."'".addslashes(ht mlspecialchars($parentemail))."','$coppauser','".a ddslashes(htmlspecialchars($ho mepage))."','".addslashes(htmlspecialchars($icq)). "','".addslashes(htmlspecialch ars($aim))."','".addslashes(htmlspecialchars($yaho o))."','".addslashes($signatur e)."','$adminemail','$showemail','$invisible','".a ddslashes($usertitle)."','".ti me()."','$cookieuser','".addslashes($prunedays)."' ,'".time()."','".time()."','$n ewusergroupid','".addslashes($timezoneoffset)."',' $emailnotification','$receivep m','$emailonpm','$options','".addslashes($birthday )."','".addslashes($umaxposts) ."','".addslashes($startofweek)."','".addslashes($ ipaddress)."','$pmpopup','".ad dslashes($testreferrerid['userid'])."','$nosessionhash','$userstarlvl','$userstarimg ','$avatarid')");

solved it and everything works fine currently
I changed to this:

// Stars Hack
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes(md5($password) )."','".addslashes(htmlspecialchars($email))."',". $newstyleval."'".addslashes(ht mlspecialchars($parentemail))."','$coppauser','".a ddslashes(htmlspecialchars($ho mepage))."','".addslashes(htmlspecialchars($icq)). "','".addslashes(htmlspecialch ars($aim))."','".addslashes(htmlspecialchars($yaho o))."','".addslashes($signatur e)."','$adminemail','$showemail','$invisible','".a ddslashes($usertitle)."','".ti me()."','$cookieuser','".addslashes($prunedays)."' ,'".time()."','".time()."','$n ewusergroupid','".addslashes($timezoneoffset)."',' $emailnotification','$receivep m','$emailonpm','$options','".addslashes($birthday )."','".addslashes($umaxposts) ."','".addslashes($startofweek)."','".addslashes($ ipaddress)."','$pmpopup','".ad dslashes($testreferrerid['userid'])."','$nosessionhash','$userstarlvl','$userstarimg ')");
// Stars Hack End

this hack doens work for vb 2.2.1

i have to modified a few thing but doesnt work yet

isnt show the starts

i look the postbit and it is fine i think

what can i do?

$post[stars] are empty

i think i do bad the misc change beacuse i dont found "user info update"

or something like that

and update the file or put 2 file for 2.2 and 2.0

I am running vBulletin 2.2.1 and it works fine for my board.
The only thing I saw on the installation was that if the stars
were not in the forum directory specified I had to edit
showthread.php (I never had to touch that file - you have to
edit admin/functions.php and stars.php).

But I have it working perfectly fine on my board right now

i dont know what are you talking about :(

Did you get it installed (the stars hack)?

I was saying that it is working fine on my board
and I am running vB 2.2.1 and nothing is going
wrong or anything, everything is running perfect.

read my first post

i say isnt show any starts but all work perfectly but dont show anything

What is the directory that you have the 'star' images in?
Do you have them in /forums/stars?

If you have you stars in another directory other
than /forums/stars/ follow the below instructions:

(This is what I did on my board - the stars were not
appearing on my board until after I did this)

1. Look for (in stars.php):

../images/stars/$star[starimg].gif\

and change it to

path/to/images/stars/$star[starimg].gif\

2. Look for (in admin/functions.php)

../images/stars/$star[starimg].gif\

and change it to

path/to/images/stars/$star[starimg].gif\

----------------------------------------------------

Backing up would be helpful as this is what I did on my forums

----------------------------------------------------

I hope this helps you out HellMind - Let me know

ty
but thata isnt my problem :(

can anyone post the final release for VB2.2.1 ??

Sorry but this one is a megathread.. it´s very hard to concentrate reading 20 sites...

What do I need to do in the admin/index file?

this hack is beta for 2.2.1 :(

Am I correct that Stars doesn't really work with vB 2.2.1? Are there any plans to release an update anytime soon?

Please correct me if wrong, but
the prefix [vB v2.2.1] before an hack release doesn't mean IT WORKS with that version ?

Could any .org moderator place a definitive word about this annoying thread ?
I mean also other hacks with conflicting authors or copyrighters and the war of the compatibility versions

Thanks a lot.

I am using the Starhack 0.2.0 (german) on my vB 2.2.1 with no probs.

The Hack is still for vB 2.0.3, for 2.2.1 I had to change some "$DB_site->query"-entries, couse in 2.2.1 it is e.g. md5($password) and NOT $password (this will write the password in plain text into the user-table). Also the $avatarid is still missing.

But after some testing I got it. ;)

Auf gut deutsch, ich habe diesen bzw. eine Vorversion dieses Hacks zum laufen gebracht. Die Installationsanleitung darf man leider nicht 1:1 ?bernehmen.

Works just fine on my test board, I did not have to change anything except some admin options because the coding that makes that table headers is not the same from 2.0.3 to 2.2.1.

Other from modifying links, I did not have to modify anything else and it is working fine, it is about to go on my main board when my site opens up.

Have to agree here,
am upgrading to 2.2.1 and it's getting a pain...

Whatever - the following has changed in 2.2.0/2.2.1:

1. register.php | step 2
Nam and Wolf42 are right (thanks), serious change here:
https://vborg.vbsupport.ru/showthrea...068#post200068

I recommend not to delete the old db string, but to change the bits which tube has added to reflect the changes (2 or 3 strings).

2. admin/index
damicatz has the solution to this one:
https://vborg.vbsupport.ru/showthrea...071#post204071

3. admin/misc.php (Update User's Titles)
You can look for Update User's Titles and replace the line with

maketableheader("Update User's Titles - updates user titles and stars","",0);

or just add something like updates user titles and stars, which is only cosmetics and not important at all (!)

4. usergroup.php | step 2
$cangetattachment seems to be new in 2.2.0 or 2.2.1, so change the db-strings as mentioned above - with care ;)
Just add the 2 or 3 missing bits to the strings which are there, don't just exchange them...

Good luck,
Worked for me this way in 2.2.1.
And again: Adding manually the bits of tube's hack to the strings you find is a clean an somewhat simple method.

cu,
-Tom

ok im havin just a few small problems.....

error in Register.php and Newthread.php

could you please repost the Codes here cuz im confused about who ta believe i keep getting errors...please help as soon as possible

:confused:

anybody ?? :confused:

when users go to register or post a new thread...it gives them this error below in quotes....althoug it still lets them perform these actions when they logout it doesnt let them log back in....i am running Vb 2.2.1 and iv tried all the above solutions and none work...please help me my site needs to grow

i am sorry for replying so many times but i really need someones help users at my website cannot log backin and are recievign errors... :(

Excuse for my ignorance, but what in the heck does this hack do? I've read through page after page in this thread and didn't really see a description of what this hack does.

I may have well missed it, and if so, I apologize, but I want to know what it does. There seems to be quite a bit of interest in it.

It is genating stars dependig on the number of postings.

Ahhhh...okay thanks Wolf! I figured it was something along those lines, but wasn't sure :)

Appreciate it!

tubedogg, is this updated for 2.2.1? I can;t seem to find the code to change in index.php?

Hi, I am going to be trying to install this hack on my forums. I previously used UBB and had a star hack there.

This of course is quite different, so I am having some enquiries.

I have 8 user titles in my forums. I would then need 8 different color stars, one for each, one for the mods and one for the administrator. I notice the hack only has 2 stars with it. Would it work to add more then 2, if so, where are they added, does it need to be modified, and if so, how?

I am new at this but I just love this hack and if I had to choose one hack out of all the hundreds out there, this would be the one. Please help me out!

It just looks so complicated, it asks to modify all those files yet there is an installer to upload? I don't see any explanations on what to edit, or does this become obvious once you start the installation?

Well I tried doing it and run into some problems, here they are, somebody please help me!

It says to find this in admin/index.php

<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("User Titles"); ?>
</table>
<a href="usertitle.php?s=<?php echo $session[sessionhash]; ?>&action=add"> Add </a> |
<a href="usertitle.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>
</td></tr>

I looked everywhere, many times, all I can find close to that is:

<table width="100%" border="0" cellspacing="0" cellpadding="<?php echo iif($cpnavjs,2,5); ?>" id="navtable">

Why can't I find it? I see others had no trouble installing this hack...

Now the other one is at misc.php, says to find this:

maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0);

This is all there is there:

// ###################### Start user choices #######################
if ($action=="chooser") {

doformheader("misc","updateuser");
maketableheader("Update User's Titles","",0);
makeinputcode("Number of users to do per cycle: ","perpage","1000");
doformfooter("Update");

doformheader("misc", "updateposts");
maketableheader("Update User's Post Counts</b> - does not add non-posting forums to total. (This will recalculate all of your user's post counts based on their CURRENT posts in the database. Do not run this if you have pruned posts or manually changed post counts and you wish to maintain their current counts.)<b>", "", 0);
makeinputcode("Number of users to do per cycle: ","perpage","1000");
doformfooter("Update");

doformheader("misc","updateforum");
maketableheader("Update Forums Info</b> - update forum post counts<b>","",0);
makeinputcode("Number of forums to do per cycle: ","perpage","100");
doformfooter("Update");

doformheader("misc","updatethread");
maketableheader("Update Thread Info</b> - update thread post counts, original posters, last post date, attachment totals<b>","",0);
makeinputcode("Number of threads to do per cycle: ","perpage","2000");
doformfooter("Update");

doformheader("misc","buildsearchindex");
maketableheader("Rebuild search index</b> - (very intensive, but rarely needed)<b>","",0);
makeinputcode("Number of threads to do per cycle: ","perpage",100);
makeinputcode("Thread number to start at: ","startat",0);
makeinputcode("Total number of threads to process: <BR>(0 for unlimited)","doprocess",0);
makeyesnocode("Include automatic JavaScript<BR>redirect to next page?","autoredirect",1);
echo "<tr class='".getrowbg()."'><td colspan=2><p><i>If you are reindexing, you may want to empty the indexes.</i> <a href=\"misc.php?action=emptyindex\"><b>Click Here to do so!</b></a></td></tr>";
doformfooter("Re-index");

doformheader("misc","removedupe");

maketableheader("Remove dupe threads</b> - (relatively intensive, but useful after importing posts)<b>","",0);
makeinputcode("Number of threads to do per cycle: ","perpage","500");
doformfooter("Remove");
}

cpfooter();
?>

Any ideas of what is going on? Please help! :(

Persistence pays off, please ignore my msg, I figured it out! Thanks !

Massiel

I am having the same problem. What was your solution? Or can anyone else help?

Just to help u all. here is a little change i made myself....

Where is says
Find In Admin/index.php
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("User Titles"); ?>
</table>
<a href="usertitle.php?s=<?php echo $session[sessionhash]; ?>&action=add"> Add </a> |
<a href="usertitle.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>
</td></tr>

And Replace With:
<!-- Stars Hack -->
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("User Stars"); ?>
</table>
<a href="stars.php?s=<?php echo $session[sessionhash]; ?>&action=add"> Add </a> |
<a href="stars.php?s=<?php echo $session[sessionhash]; ?>&action=modify"> Modify </a>
</td></tr>
<!-- Stars Hack End -->

IGNORE THIS ABOVE.. USE WHATS BELOW
****************************

Find In Admin/index.php:

makenavoption("Add","usertitle.php?action=add","|" );
makenavoption("Modify","usertitle.php?action=modif y");
makenavselect("User Titles");
// ***

Add Below that:

makenavoption("Add","stars.php?action=add","|");
makenavoption("Modify","stars.php?action=modify"," |");
makenavselect("Stars Hack");
// ***