Stars for vB2.2.1 (english/german)

[Wolf42]

Update 03/26/2002: Changed one DB_site->quere in usergroup.php to make it fit to vB 2.2.4. If the hack is still running no update is needed.

Update v. 26.03.2002: Habe eine kleine ?nderung in einer DB_site-quere der usergroup.php gemacht, die sich im vB 2.2.4 ge?ndert hat. Sollte der Hack nach wie vor funktionieren ist kein Update notwendig.

This is not a new hack only a modification for tubedogg's Stars v0.2.3 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=19081) to run on vB 2.2.1.

I got it run on my board, but most of the Users with this version got troubles.

I did the mods on the original vb-scripts, if you have any hacks installed (who not :D) be carefull!

Das ist kein "neuer" Hack sondern nur eine Modifikation von tubedogg's Stars v0.2.3 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=19081) Version damit er auf einem vB 2.2.1 l?uft.

Bei mir funzt er ganz gut, aber sichtlich hatten einige Benutzer Probleme ihn auf dieser Version zum laufen zu bringen.

Bei den ?nderungen beziehe ich mich immer auf die Originalscripte, solltet ihr diese schon ver?ndert habe heisst es: Schau genau!!

There is a german and an (I hope) english instruction.

Es gibt eine deutsch und eine (hoffentlich) englische Anleitung.

[vertex]

demo please?

[TheComputerGuy]

<a href="http://www.bacaon.com/forum/showthread.php?threadid=78" target="_blank">http://www.bacaon.com/forum/showthread.php?threadid=78</a>

[Wolf42]

@TheComputerGuy

THX! :D

[Dolamite]

can someone verify 2.2.2 ?

that would be great!!

thx

[sezmar]

mmm, for some reason it isn't shoing the stars,
double checked the hacked files, but everything is in place.

i also updated the counters,
weird part about it is that also the new post indictors have stopped working

[Wolf42]

@sezmar
Version ? It is running von my 2.2.1.

Did you upload the stars.php? Did you run the mysql.php?

@Dolamite
i don't know, didn't upgrade to 2.2.2.

[Wolf42]

@setmar
Did you updated "Usertitles and Stars" too?? AFTER configure the stars!!

[sezmar]

im running version 2.2.1

and i did all the steps in the install instructions, updated everything

[Psychdrone]

what a joke, the old one dose work for version 2.2.1,

This is a silly silly thread

[black]

Originally posted by Psychdrone
what a joke, the old one dose work for version 2.2.1,

This is a silly silly thread

Youll just have to read the last few post to get the registration working and thats it basicly to make it work for 2.2.1

[Wolf42]

Originally posted by Psychdrone
what a joke, the old one dose work for version 2.2.1,

This is a silly silly thread

Erstens: Definiere "Silly Thread"
Zweitens: Wenn die alte Version problemlos auf 2.2.1 laufen w?rde, warum haben immer wieder welche nach einer Version f?r 2.2.1 gefragt? Wenn Du die alte Version 1:1 ?bernimmst hast Du ein Problem.

Und .....

Du musst das hier nicht lesen!


@Any Moderator!

Please close AND DELETE(!!!) this thread!

Thank you

Wolfgang

[Thomas P]

Goody!

There are problems using the original stars hack unmodified

Psycho: nomen est omen, or what? ;)

Thanks Wolfgang,
-Tom

[Thomas P]

I have checked my own modified files with Wolf's Rehack - good job!

I did a small mistake though being careful, Wolf did everything correct imo.

Thanks,
-Tom

[Rapclick]

im having a small problem with this hack, when a new user register's i get a database error


Database error in vBulletin 2.2.1:

Invalid SQL: INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES (,'','IL','','')
mysql error: You have an error in your SQL syntax near ''','IL','','')' at line 1

mysql error number: 1064

Date: Monday 04th of February 2002 06:34:34 PM
Script: http://forums.rapclick.com/register.php
Referer: http://forums.rapclick.com/register.php


:confused: help me? i have no idea what i coulda done wrong, stars works great other than this

[Wolf42]

It seems you have a problem with custom userfields. This hack dosn't change anything on the custum user fields. :confused:

This is my DB_quere for this fields:
// insert custom user fields
$DB_site->query("INSERT INTO userfield $userfieldsnames VALUES ($userid$userfields)");

[Rapclick]

hmm thats the exact code i have.....i have no idea what the problem could be, Wolf if you have Aol/Aim please contact me

AIM = StonedUser420 or Rapclick

[sezmar]

problem with registrations are fixed now, but still the stars aren't showing.

i have been looking in all my files and checked them 3 times, but i have hacked them right.

[Wolf42]

Originally posted by sezmar
problem with registrations are fixed now, but still the stars aren't showing.

i have been looking in all my files and checked them 3 times, but i have hacked them right.

Where have you added the $post[stars] in the postbit template??

It could look like this (the part with the starts):

<normalfont><b>$post[profile]</b></normalfont> [$post[search]]<br>
<smallfont>$post[usertitle]</smallfont><br>
$post[stars]<br>
$post[avatar]<p>
<smallfont>$onlinestatus<br>
Registriert seit: $post[joindate]<br>
Wohnort: $post[field2]<br>
Beitr?ge: $post[posts]<br>
$post[hidden]</smallfont></td>

[sezmar]

yep, thats exactly how i did it,

the weird part is, in normal posts the stars aren't showing,
but in announcements they are visible!?!?!

how can that be?

[Wolf42]

****In admin/functions.php****

**Find

if ($post['receivepm'] and $enablepms==1) {
eval("\$post[pmlink] = \"".gettemplate("postbit_sendpm")."\";");
} else {
$post[pmlink] = "";
}

**After this insert

$sli = 0;
while ($sli < $post[starlevel]) {
$post[stars] .= "<img src=\"images/stars/$post[starimg].gif\" border=\"0\">";
++$sli;
}


It seems this part of the instruction is not working on your board. :(

Can you please post your postbit-template?

[sezmar]

ok, this is my postbit template:

<table bgcolor="{pagebgcolor}" width="{tablewidth}" cellpadding="0" cellspacing="0" border="0"><tr><td width="10"><img width="10" height="1" src="{imagesfolder}/space.gif" alt=""></td><td width="100%"><!-- spacer -->

<table cellpadding="{tableouterborderwidth}" cellspacing="0" border="0" bgcolor="{tablebordercolor}" {tableouterextra} width="{contenttablewidth}" align="center"><tr><td>
<table cellpadding="4" cellspacing="{tableinnerborderwidth}" border="0" {tableinnerextra} width="100%">
<tr>
<td bgcolor="$post[backcolor]" width="175" valign="top" nowrap>
<a name="post$post[postid]"></a>
$post[firstnewinsert]
<normalfont><b>$post[username]</b></normalfont><br>
<smallfont>$post[usertitle]</smallfont><br>$post[stars]<br>
$post[avatar]<p>
<smallfont>Registered: $post[joindate]<br>
Location: $post[field2]<br>
Posts: $post[posts]<br>
<a href="moderator.php?s=$session[sessionhash]&action=points&userid=$userinfo[userid]" target=_blank>Status:</a> $post[field5]<br></smallfont></td>

<td bgcolor="$post[backcolor]" width="100%" valign="top">
<smallfont>$post[icon] <b>$post[title]</b></smallfont>
$ftpinfo
<p><normalfont>$post[message]</normalfont></p>
$post[attachment]
<p>$post[signature]</p>
<p>$post[editedby]</p>
<p align="right"><smallfont><a href="report.php?s=$session[sessionhash]&postid=$post[postid]">Report this post to a moderator</a> | $post[iplogged]</smallfont></p>
</td>
</tr>
<tr>
<td bgcolor="$post[backcolor]" width="175" height="16" nowrap><smallfont>$post[foldericon]
$post[postdate] <font color="{timecolor}">$post[posttime]</font></smallfont></td>

<td bgcolor="$post[backcolor]" width="100%" valign="middle" height="16">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr valign="bottom">
<td><smallfont>$onlinestatus
$post[profile] $post[pmlink] $post[useremail] $post[homepage] $post[search] $post[buddy]
<!-- $ post[icqicon] --> <!-- $ post[aimicon] --> <!-- $ post[yahooicon] -->
</smallfont></td>
<td align="right" nowrap><smallfont>
<a href="editpost.php?s=$session[sessionhash]&action=editpost&postid=$post[postid]"><img src="{imagesfolder}/edit.gif" border="0" alt="Edit/Delete Message"></a>
<a href="newreply.php?s=$session[sessionhash]&action=newreply&postid=$post[postid]"><img src="{imagesfolder}/quote.gif" border="0" alt="Reply w/Quote"></a>
</smallfont></td>
</tr>
</table>
</td>
</tr>
</table>
</td></tr></table>

<!-- spacer --></td><td width="10"><img width="10" height="1" src="{imagesfolder}/space.gif" alt=""></td></tr></table>

[Wolf42]

Ok, the template is correct. Is your board online? On "your" homepage is running a UBB and not a vB.

[sezmar]

yep. its online.

the ubb is an old one.

could it be that there is something missing in the instructions?
cause all other hacks are working

[sezmar]

hey i just noticed that the online /offline function stopped working too

[Rapclick]

hmmm i have now upgraded to 2.2.2 and im just wondering how different 2.2.1 and 2.2.2 actually are enough were i could not succesfully install this hack...? i know there is no support for any other versions i am just wondering........ :D

[Radon3k]

Doesn't make sense....Where do you find "Stars" in the admin CP? I ran the script, and it just had me log in, then said "go to ur admin CP and follow stars.txt from there".....Where in the admin CP is "Stars" that you modify?

[sezmar]

Originally posted by Radon3k
Doesn't make sense....Where do you find "Stars" in the admin CP? I ran the script, and it just had me log in, then said "go to ur admin CP and follow stars.txt from there".....Where in the admin CP is "Stars" that you modify?

after running that script, you must follow the instruction
in the text file that was in the zip you downloaded.

after you've done that, the parts that can be modified will appear in your cp

[Wolf42]

Originally posted by sezmar
could it be that there is something missing in the instructions?
cause all other hacks are working

No, the instruction is complete.

I just made a new clean install of a vB 2.2.2 on my testserver.

Then build in the star-hack (english version, the most of you are running an english board).

And it is working.

Friends, I don't know what you are doing. But it seems you are doing something wrong. :confused:

@Redon3k
This stars.txt is starhack221_english.txt or starhack221_deutsch.txt. This is the instruction (like sezmar said). The MYSQL.PHP is only creating and altering tabels.

@sezmar
What is your adminpanel showing when clicking on Stars -> Modify? In the attachement is mine.

[sezmar]

mine shows the same thing!
look at the attachment

[Radon3k]

Ok I uploaded the "stars.php" and "mysql.php" into my admin folder....I ran the script, same thing...It's not doing anything still...

[Rapclick]

i just succesfully installed stars on my vb2.2.2 :)
everything works fine exept for a small error in the control panel, users that register after this hack was installed do not show up when i search for users... its as if thier not there...or not in the database......

[Wolf42]

@Radon3k
Did you changed the PHP-Files too?

@Rapclick
I just registered on your board. Try if you find me. The nick is same like in this board. ;)

[Radon3k]

Ok...The good news is that it's successfully working on my test forums, yay! :) Bad news, I can't figure out how to assign stars to admins and mods, any help Wolf? Thanks! :)


Edit: Forgot to mention that I went into "modify user groups" and for Administrators and Moderators, but I don't see where you add it...Nothing in there has changed...So how do I give them their own stars and stuff if in the user groups there is no place to add it? Thanks! :)

[Rapclick]

no it said it couldnt find you, and also i have about 80 members now and this count stopped at 40 in the admin cp when the stars was installed...

[Rapclick]

also there seems to be that problem with new registration...did you get that too? :confused:

[Radon3k]

No problems with registration as of yet....Just problems with giving admins and mods their own stars....Did you get this to work?

[Rapclick]

yes mine works fine, jus in your admin cp click modify usergroups, and there is a new field thier for the stars... mine worked great... hey are u running 2.2.2? or 2.2.1?

[Wolf42]

Originally posted by Radon3k
Ok...The good news is that it's successfully working on my test forums, yay! :) Bad news, I can't figure out how to assign stars to admins and mods, any help Wolf? Thanks! :)


Edit: Forgot to mention that I went into "modify user groups" and for Administrators and Moderators, but I don't see where you add it...Nothing in there has changed...So how do I give them their own stars and stuff if in the user groups there is no place to add it? Thanks! :)

Got to your admin/usergroup.php. It has to look like this:
// ###################### Start add #######################
if ($action=="add") {

doformheader("usergroup","insert");
maketableheader("Add new usergroup");

makeinputcode("Title","title");
makeinputcode("User Status<br>Use this to override the default 'ladder' of user status titles","usertitle");
makeinputcode("Stars shown<br>Use this to override the default 'ladder' of stars","starlevel");
makeinputcode("Star image shown<br>Give this group a unique star image - do not add the .gif after the image name!","starimg");
makeyesnocode("Viewable on <a href=\"../showgroups.php?s=$session[sessionhash]\" target=\"_blank\">Show Groups</a>?","showgroup",1);
and
// ###################### Start edit #######################
if ($action=="edit") {

$usergroup=$DB_site->query_first("SELECT * FROM usergroup WHERE usergroupid=$usergroupid");

doformheader("usergroup","doupdate");
makehiddencode("usergroupid","$usergroupid");
maketableheader("Edit usergroup: </b>$usergroup[title]<b>","",0);

makeinputcode("Title","title",$usergroup[title]);
makeinputcode("User Status<br>Use this to override the default 'ladder' of user status titles","usertitle",$usergroup[usertitle]);
makeinputcode("Stars shown<br>Use this to override the default 'ladder' of stars","starlevel",$usergroup[starlevel]);
makeinputcode("Star image shown<br>Give this group a unique star image - do not add the .gif after the image name!","starimg",$usergroup[starimg]);
Your AdminCP (Modify Usergroups) must look like the Attachement. If you want to assign other stars to your Admins/Mods just upload a different star-image (ie admin.gif or mod.gif) in your images/stars-folder.

[Wolf42]

Originally posted by Rapclick
no it said it couldnt find you, and also i have about 80 members now and this count stopped at 40 in the admin cp when the stars was installed...

http://forums.rapclick.com/member.php?s=&action=getinfo&userid=67

I am there! :D

Got to your AdminCP and run
/admin/user.php?s=&action=find
This should show all user.

[Radon3k]

Ok I'll try this when I get home. Maybe usergroup.php didn't upload right or something, but I didn't see that in my Admin CP. Will try again when I get home, thanks! :)

[Radon3k]

Ok it works...Don't know what I was doing, but great! Thanks for this great hack! Going to put it on my real board now that I know it works...Yippiee! Thanks! :)

[Radon3k]

"The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:"

This is the error I get when I installed it on my main board. In the Admin CP, I click on either "Add" or "Modify" and that's what I get. Why.....??????

[Radon3k]

Ok everything works now...I accidently added some code twice in "usergroup.php" so under the admins and mods it said two times instead of one "image name, how many"...that thing..heh...its fixed now and it all works...Great hack, thanks again! :)

[Massiel]

I am fairly new at this, I love the star hack though. I have version 2.2.2 and I am not sure which star hack to use, yours or the other one... if I use yours, do I still have to use the other one or yours completely replaces the other one? Don't even know why I am confusing myself but I am confused LOL!

I guess what I am trying to ask is, do I have to first install tubedogg's hack then yours? Or can I just do yours?

[Massiel]

I started modifying the files however I am stuck at this

****In newreply.php****

**Find

if ($bbuserinfo[userid]!=0)
{

I just can't find that entry, I have looked at it over 5 times and I can't find it. Help please!

Also what do I do first, modify the files or go to go to http://www.your-domain.com/forum/admin/mysql.php in your browser and login?

The instructions are not very clear on what is to be done first. Please help me!

And what does this mean?
****Tipp-Anfang****
Keep the empty lines!! (Beim ver?ndern der Dateien, darauf achten, dass die Leerzeilen erhalten bleiben.)
****Tip-Ende****

[Massiel]

I found it, it was pretty well hidden LOL!

On to admin/misc.php

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

Now this is what is in my misc.php (using version 2.2.2)

// ###################### 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();
?>

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

Am I missing something? Please help me out!

[Wolf42]

In vB 2.2.2 its the line:
maketableheader("Update User's Titles","",0);

[Wolf42]

Originally posted by Massiel
I am fairly new at this, I love the star hack though. I have version 2.2.2 and I am not sure which star hack to use, yours or the other one... if I use yours, do I still have to use the other one or yours completely replaces the other one? Don't even know why I am confusing myself but I am confused LOL!

I guess what I am trying to ask is, do I have to first install tubedogg's hack then yours? Or can I just do yours?

"My" Hack is just a rehack of tubedogg's hack for vB 2.2.1 and up. :D

[Massiel]

So do I have to install his first? I already did the first step of his, where the tables are created... I am up to modifying files but I have been having lots of trouble just finding lines in misc.php and index.php

Can you take a look at his thread? I have spend all day trying to figure out this hack and I am a bit disappointed that I have gotten nowhere so far. :(

[Massiel]

I noticed most of the steps on his hack are very similar to yours, that is why I was asking if I have to do his first, then yours or if I can just do the rehack you did without having to do his first.... please tell me hahaha, this would make things a lot easier to understand.

Is the stars.php the same for both hacks?

Are there other lines that are different from 2.2.1 compared to 2.2.2?

I got as far as misc.php and then got stuck there!

[Wolf42]

Yupp, the stars.php is the same one. ;)

If you are running a vB 2.2.1 or up do not install tubedoff's hack, couse some DB_quere are different and the entries in the AdminCP (read above in this thread). This was the reason why I have rehacked his version. My instructions should work if you are using a original vB without hacks. If you have modifyed you scripts be carefull with the changes.

Just follow the instructions and if you have done everthing corretly it should work. :D

The german instruction is better couse I am from Austria, so my german is better than my english. :cool:

If you have backups from original PHP-Files compare them with "Beyond Compare". If the new scripts are not working you can find the errors more easier.

[Massiel]

Wolf thanks for a great hack rehack LOL, I figured it all out and it is running smoothy!!! Finally, now I am a happy camper, thank you so much for your help and patience, you rule! :D

[Rapclick]

i tried running /admin/user.php?s=&action=find thats were im talking about it wont show you.... users fields like location and the points hack ceaced working on new users also.... hmm but the strange thing is i can acess them as members if they have loged in the passed 24 hours and all other methods just cant see a solid list

[Raptor]

I can confirm this works great in vb2.2.2

[Radon3k]

This works just fine in 2.2.4. The only problem I had was I got a parse error on line 81 of /admin/usergroup.php. So I commented that line out and it works great! Thanks for this great hack! :)

[Wolf42]

@Radon3k
Yes, I noticed that the "$DB_site->query("INSERT INTO usergroup .... (line 80)" is not in one line. The is a CR before "VALUES (NULL ... (line 81)". If you leave that part of the quere you get an parse error.

Changed instruction and updated to vB 2.2.4.

[Thomas P]

Hi Wolf,

does it work with 2.2.5, too?

Guess so, since not much changed from 2.2.4.
Am upgrading right now :)

thx,
-Tom

[Wolf42]

Hi Tom!
Da keine gravierenden Änderungen in vB 2.2.5 sind funzt der Hack noch immer.

[Thomas P]

Danke :)
Dann leg ich mal los...
thx,
-Tom

[Radon3k]

Hey Wolf, this works just fine on 2.2.5 and I didn't have to edit out that line! Thanks! :)

[Highlander]

Hi there..i cannot find this query in the Admin/misc.php

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

it is not given for any reason in the misc.php...i also control all other misc.php`s in the directories...but really i did nothing wrong the only query here is shown is this one:

maketableheader("Update User's Titles","",0);

maybe you mean this ??

if someone gots the vbportal..please call me @ ICQ i got a porblem to get in the administration
my ICQ: 148041353

[Wolf42]

The line is in admin/misc.php at 330 (vb2.2.5)! And that is the one you "could" change, you must not. Just a notice. ;)

[Smoothie]

Wolf42-

Excellent! Installed without a problem. :)

[Webmasta XT]

ok, when new users try to join my forumz, they get an error about the database, and I get this e-mail...

can someone help me plz???

[PHP]
Database error in vBulletin 2.2.5:

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,'Ace','king','Calebmoore@hotmail.com','1','' ,'0','http://','','','','','0','0','1','n00b','1022669217','1', '-1','1022669217','1022669217','2','0','1','1','0',' 15','1986-6-4','-1','2','209.68.64.69','0','0','1','','','0','0')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Wednesday 29th of May 2002 03:46:57 AM
Script: http://www.xtreme-forumz.net/register.php
Referer: http://www.xtreme-forumz.net/register.php
[/PHP}

[Wolf42]

$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','$userstarlvl','$us erstarimg')");
The line in the user.php must look like this. Please check. Your line looks like vB 2.0.3 couse something is missing (avatarid, and password in plain, but should be encrypted).

[Webmasta XT]

sry, that didn't help, there is some problem in register.php and my vb is 2.2.5

[Wolf42]

Which version of Stars have you installed on your vB? Tubedoggs (for 2.0.3) or my Rehack?

Sorry, in register.php the code should be:
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','$userstarlvl','$us erstarimg')");
Think its the same code as in user.php (did this some time ago). If you download my instructions it should work.

[Webmasta XT]

contact me on AIM plz!!

[Webmasta XT]

can you explain how can I have two different kind of stars on two different styles?? plz, cuz I need the color mtach kind of thing, so I have made seprate stars for each style, I was wondering if its possible to do that...

[Wolf42]

Originally posted by Webmasta XT
contact me on AIM plz!!
I'm not using AIM, sorry.
Originally posted by Webmasta XT
can you explain how can I have two different kind of stars on two different styles?? plz, cuz I need the color mtach kind of thing, so I have made seprate stars for each style, I was wondering if its possible to do that...
It can be done. But you need for every style an extra images-folder!
Find in admin/functions.php:

$sli = 0;
while ($sli < $post[starlevel]) {
$post[stars] .= "<img src=\"images/stars/$post[starimg].gif\" border=\"0\">";
++$sli;
}

and replace with:

$sli = 0;
while ($sli < $post[starlevel]) {
$post[stars] .= "<img src=\"{imagesfolder}/stars/$post[starimg].gif\" border=\"0\">";
++$sli;
}

In announcement.php do the same. Now you have different stars for different styles.

[xeon]

Originally posted by Wolf42
The line is in admin/misc.php at 330 (vb2.2.5)! And that is the one you "could" change, you must not. Just a notice. ;)
OK, so this line(330) should not be changed at all in 2.2.5? I am just a little unclear about this point. If you would expand on this I would appreciate it. Thanks in advance...

[Wolf42]

It dosn't matter if the line saying "Update user Titles" or "Update User Titles and Stars", the effect is the same.

[Webmasta XT]

Thnx Wolf42!! I luv ya man..

[Crunch]

hmm i think mines messing up the same as webmasta's because i have the gender hak installed in that line so i'm not sure to put it but mine looks like

$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,avata rid,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm',' $options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','$gender','$usersta rlvl','$userstarimg')");

im running vs. 2.2.6 for the info.

[Wolf42]

First: What is your problem or what error do you get?

Second: In with file do you have this line?

[Crunch]

ok well all that works fine and I get no errors but now when people post or I add a moderator I have to update counters everytime. Is this because of a mySql query or maybe using quick reply?

[Wolf42]

You only have to update counters if you change the usergroup of a user (eg make him Moderator and Mods have different stars) or you change the configuration of the stars (lower or rise the postcount for a starlevel).

[Crunch]

ok well i have been testing on just raising a test members post then posting but even then when i get to the amount of posts they need to get a new star it wont go on with out updating counters. got any ideas?

[Wolf42]

It seams that there is something wrong with you newthred.php/newreply.php!

Can you post the part from your newthread.php between // update user stuff (about line 267 in 2.2.6 original) and // send email to moderators (about line 288 in 2.2.6 original).

And the same from newreply.php (324 to 345).

[Crunch]

NEWTHREAD:


Update user stuff:
// update user stuff
$dotitle="";
if ($bbuserinfo[userid]!=0)
{
if ($foruminfo[countposts]) {
$usergstars=$DB_site->query_first("SELECT starlevel,starimg FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");
if ($usergstars[starlevel]=="") {
$getstars=$DB_site->query_first("SELECT starlevel,starimg FROM stars WHERE minposts<=$bbuserinfo[posts]+1 ORDER BY minposts DESC LIMIT 1");
$userstarlvl=$getstars[starlevel];
$userstarimg=$getstars[starimg];
} else {
$userstarlvl=$usergstars[starlevel];
$userstarimg=$usergstars[starimg];
}
$dostars=",starlevel='$userstarlvl',starimg='$userstarimg'";
}
if ($bbuserinfo[customtitle]==0 && $foruminfo[countposts])
{
$usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");
if ($usergroup[usertitle]=="") {
$gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=$bbuserinfo[posts]".iif ($foruminfo['countposts'],"+1","")." ORDER BY minposts DESC LIMIT 1");
$usertitle=$gettitle[title];
} else {
$usertitle=$usergroup[usertitle];
}
$dotitle="usertitle='".addslashes($usertitle)."',";
}

$DB_site->query("UPDATE user SET
".iif ($foruminfo[countposts],"posts=posts+1,","")."
$dotitle"."lastpost='".time()."',away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");
}






Email moderator stuff:
// send email to moderators
if ($enableemail) {
$moderators=$DB_site->query_first("SELECT CONCAT(newthreademail,' ',newpostemail) AS newthreademail FROM forum WHERE forumid='$forumid'");

$modtable=$DB_site->query("SELECT DISTINCT user.email FROM moderator,user WHERE moderator.userid=user.userid AND forumid IN ($foruminfo[parentlist]) AND (newthreademail=1 OR newpostemail=1)");
while($thismod=$DB_site->fetch_array($modtable)) {
$moderators['newthreademail'].=" $thismod[email]";
}

if ($moderators['newthreademail']!="") {
$mods=explode(" ",trim($moderators['newthreademail']));
while (list($key,$val)=each($mods)) {

if (trim($val)!="") {
$toemail=$val;
$forumtitle = $foruminfo['title'];
$threadinfo['title'] = $subject;

eval("\$emailmsg = \"".gettemplate("email_moderator",1,0)."\";");
eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");
mail($toemail,$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
}
}
}
}

// redirect
if ($postpoll) {
$goto="poll.php?s=$session[sessionhash]&threadid=$threadid&polloptions=".intval($polloptions);
} elseif ($visible) {
$goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";
} else {
$goto="forumdisplay.php?s=$session[sessionhash]&forumid=$forumid";
}
eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");");
}
}
}


NEWREPLY:

update user stuff:
// update user stuff
$dotitle="";
if ($bbuserinfo[userid]!=0)
{
if ($foruminfo[countposts]) {
$usergstars=$DB_site->query_first("SELECT starlevel,starimg FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");
if ($usergstars[starlevel]=="") {
$getstars=$DB_site->query_first("SELECT starlevel,starimg FROM stars WHERE minposts<=$bbuserinfo[posts]+1 ORDER BY minposts DESC LIMIT 1");
$userstarlvl=$getstars[starlevel];
$userstarimg=$getstars[starimg];
} else {
$userstarlvl=$usergstars[starlevel];
$userstarimg=$usergstars[starimg];
}
$dostars=",starlevel='$userstarlvl',starimg='$userstarimg'";
}
if ($bbuserinfo[customtitle]==0 && $foruminfo[countposts])
{
$usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");
if ($usergroup[usertitle]=="") {
$gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=$bbuserinfo[posts]".iif ($foruminfo['countposts'],"+1","")." ORDER BY minposts DESC LIMIT 1");
$usertitle=$gettitle[title];
} else {
$usertitle=$usergroup[usertitle];
}
$dotitle="usertitle='".addslashes($usertitle)."',";
}

$DB_site->query("UPDATE user SET
".iif ($foruminfo[countposts],"posts=posts+1,","")."
$dotitle"."lastpost='".time()."',away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");

}



email moderator stuff:

// send email to moderators
if ($enableemail) {
$moderators=$DB_site->query_first("SELECT newpostemail FROM forum WHERE forumid='$threadinfo[forumid]'");

$mods=$DB_site->query("SELECT DISTINCT user.email FROM moderator LEFT JOIN user USING (userid) WHERE moderator.forumid IN ($foruminfo[parentlist]) AND moderator.newpostemail=1");
while ($mod=$DB_site->fetch_array($mods)) {
$moderators[newpostemail].=' '.$mod[email];
}
$moderators[newpostemail]=trim($moderators[newpostemail]);

if ($moderators[newpostemail]!="") {
$bbuserinfo['username']=unhtmlspecialchars($bbuserinfo['username']); //for emails
$mods=explode(" ",$moderators[newpostemail]);
while (list($key,$val)=each($mods)) {
if (trim($val)!="") {
$subject=$threadtitle;
$toemail=$val;

eval("\$emailmsg = \"".gettemplate("email_moderator",1,0)."\";");
eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");

mail($toemail,$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");
}
}
$bbuserinfo['username']=htmlspecialchars($bbuserinfo['username']); //back to norm
}
}

// redirect
if ($visible) {
$goto="showthread.php?s=$session[sessionhash]&postid=$postid#post$postid";
} else {
$goto="forumdisplay.php?s=$session[sessionhash]&forumid=$threadinfo[forumid]";
}
eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");");
}
}
}

[Wolf42]

Look at the query above // send email to moderators (in both files), it must look like these:
$DB_site->query("UPDATE user SET
".iif ($foruminfo[countposts],"posts=posts+1,","")."
$dotitle"."lastpost='".time()."'$dostars,away=0,awaydate='',awayreason='',returnd ate='' WHERE userid='$bbuserinfo[userid]'");

You forgot the $dostars in the query, I think you deleted that by building in the "Away-Hack"!

[Crunch]

ok i added that but those were in the update user stuff, and now no stars appear for normal members at all when i updated counters!

[Crunch]

NM it for some reason deleted all my star settings. gah oh well let me test it for a sec.

[Crunch]

YES! thanks ya wolf guy. i know i did something wrong cause it was working before i went on another hack spree. thanks again :D

[Wolf42]

Pleased that I could helped you! :cool:

[Webmasta XT]

is there a way users can have custom stars?? =P

[Wolf42]

Originally posted by Webmasta XT
is there a way users can have custom stars?? =P
You can set custom stars to each usergroup but not to each user. ;)

But you give each user his own usergroup :D (just joking).

[Webmasta XT]

so there is no way? what I am talking about is.. we can specify what amount of stars a member can have, not all members, just the few that wanted to have low stars and stuff, and we wanted to give the admins the highest stars, is it possible?

[Chris M]

Does this work with 2.2.6?

Satan

[Wolf42]

@hellsatan
Yes, working on vB 2.2.6.

@Webmasta XT
You want to decide how many stars each usergroup can reach at max depending on the amout of posting? (i.e. Members max 5 stars, Mods 7 stars and Admins 8, but depending on the amount of postings)

[Chris M]

Sweet...

I'll install it then!

*installs*

Satan

[Thewnagchung]

Hi. I just cant get this hack to work, i do fine until i reach functions.php, then i get a weird error message about T_encassed or something.

here is my functions.php file, could someone edit it to the way it should be ? thanks

and im on 2.2.6 btw


Please do not post full files of vBulletin. Thank you.

[Wolf42]

This is what the instructions says:

****In admin/functions.php****

**Find

if ($post['receivepm'] and $enablepms==1) {
eval("\$post[pmlink] = \"".gettemplate("postbit_sendpm")."\";");
} else {
$post[pmlink] = "";
}

In your functions.php is this line 208 to 212.

**After this insert

$sli = 0;
while ($sli < $post[starlevel]) {
$post[stars] .= "<img src=\"{imagesfolder}/stars/$post[starimg].gif\" border=\"0\">";
++$sli;
}

Thats all you have edit in functions.php.

[Molok]

Hello!
I become problems when i modify a User Group!
When i click on the save button this error msg will be show:


Invalid SQL: UPDATE usergroup SET title='Administrators',usertitle='Administrator',s tarlevel='',starimg='',cancontrolpanel=1,canmodify profile=1,canviewmembers=1,canview=1,showgroup=1,c ansearch=1,canemail=1,canpostnew=1,canmove=1,canop enclose=1,candeletethread=1,canreplyown=1,canreply others=1,canviewothers=1,caneditpost=1,candeletepo st=1,canusepm=,canpostpoll=,canvote=1,canpostattac hment=1,ismoderator=1,canpublicedit=1,canpubliceve nt=1,canthreadrate=1,cantrackpm=1,candenypmreceipt s=1,maxbuddypm=1,maxforwardpm=1,canwhosonline=1,ca nwhosonlineip=1,cangetattachment=1 WHERE usergroupid=6
mysql error: You have an error in your SQL syntax near 'canpostpoll=,canvote=1,canpostattachment=1,ismode rator=1,canpublicedit=1,canpubl' at line 1

mysql error number: 1064

Date: Thursday 22nd of August 2002 01:04:10 AM
Script: http://domain.de/admin/usergroup.php
Referer: http://domain.de/admin/usergroup.php?action=edit&usergroupid=6


I have vB 2.2.6
Can you help me?!

[Wolf42]

Sorry for my late reply, but I was on holidays.

I've checked the SQL-command and it is correct!! It must be an other problem (maybe PHP). Which version of PHP are you running?

[Molok]

its php 4.0.4

[Wolf42]

Please check you admin/usergroup.php again.
$DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',starlevel='$starlevel',starimg='$starimg',cancon trolpanel=$cancontrolpanel,canmodifyprofile=$canmo difyprofile,canviewmembers=$canviewmembers,canview =$canview,showgroup=".intval($showgroup).",cansearch=$cansearch,canemail=$canemail,canpostne w=$canpostnew,canmove=$canmove,canopenclose=$canop enclose,candeletethread=$candeletethread,canreplyo wn=$canreplyown,canreplyothers=$canreplyothers,can viewothers=$canviewothers,caneditpost=$caneditpost ,candeletepost=$candeletepost,canusepm=$canusepm,c anpostpoll=$canpostpoll,canvote=$canvote,canpostat tachment=$canpostattachment,ismoderator=$ismoderat or,canpublicedit=$canpublicedit,canpublicevent=$ca npublicevent,canthreadrate=$canthreadrate,cantrack pm=$cantrackpm,candenypmreceipts=$candenypmreceipt s,maxbuddypm=$maxbuddypm,maxforwardpm=$maxforwardp m,canwhosonline=$canwhosonline,canwhosonlineip=$ca nwhosonlineip,cangetattachment=$cangetattachment WHERE usergroupid=$usergroupid");
Thats the query where the usergroup is updated.

I don't understand why the bits canusepm and canpostpoll are set to null in you query.

[Barto]

Any one can help me to use this in v. 2.2.6?
give me an icq number pls :(

[Wolf42]

What's your problem? Support is only given here. ;)

[subu1]

ups my eng. ist not so good *g* Läuft der Hack auch auf 2.2.7?
oder bin ich nur zu doof das zu installieren.habs drin nur ich seh keine Sternchen in acp kann ich alles einstellen, sehe aber auch da keine Sterne.
achso ich habe unter anderem das gleiche Prob wie mein Vorgänger, ich habs einfach nicht drin
**Finde

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

das wäre ja sowieso nur optional?

whats going on, please

greetz subu1

[Wolf42]

@subu1
Grundsätzlich läuft der Hack auf 2.2.7, zumindestens bei mir. Hast Du nach der Installation auch die Benutzertitel upgedated?

[subu1]

ups, sorry habe keine Benachrichtigung bekommen, deshalb schaue ich erst jetzt nach. Muß Ihn neu einbauen denn wir haben neu 2.2.8 installiert. Danke Dir ich melde mich wieder;-)

gruß subu1

[subu1]

so hab jetzt den Fehler gefunden und zwar habe ich das hier nicht.

I dont have this, please help me

****In admin/misc.php****

**Finde

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

**und ersetze es mit

maketableheader("Update Benutzer-Info</b> - </b>aktualisieren der Benutzertitel und Sterne<b>","",0);

greetz subu1

[subu1]

"Bingo" :-))) He is on, jappp

thxxx wolf:-)))

[Zalbard]

Is this working in version 2.2.9? I would love to install this in mine, but I want to make sure it works. I bet it does though, should I try and be a guini pig?

[Dean C]

Yes works fine in vb 2.2.9

It's all about how you follow the instructions

If you run into any problems give me a shout and i'll help

- miSt

[Zalbard]

Great, thanks! I will install this hack right away!

[Zalbard]

Ahhh! When I get to Admin/misc.php, I can't find maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0); and I tried over and over again! Wher is this line? Please help!

[cono]

can someone release the hack with correct edits for v2.2.9?

[Wolf42]

Originally posted by Zalbard
Ahhh! When I get to Admin/misc.php, I can't find maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0); and I tried over and over again! Wher is this line? Please help!
In vB 2.2.9 its line 380
maketableheader("Update User's Titles","",0);
Seams I have to modify it again. :(

[Dean C]

A lot of people are getting problems as the releases go up..

Perhaps it's best you make this version for 2.2.9 :)?

- miSt

[Angelus]

wie kommen die stars ins getinfo ?
habe versucht folgenden code in die member.php zu kopieren:

// Stars Hack Ende
$sli = 0;
while ($sli < $post[starlevel]) {
$post[stars] .= "<img src=\"images/stars/$post[starimg].gif\" border=\"0\">";
++$sli;
}
// Stars Hack Ende

es wir mir im userprofil nicht angezeigt :(

[Wolf42]

Hallo Angelus!

Du hast einen kleinen Denkfehler, ist aber kein Problem. Statt $post solltest Du $userinfo verwenden. Das sieht dann ungef?hr so aus:

$sli = 0;
while ($sli < $userinfo[starlevel]) {
$userinfo[stars] .= "<img src=\"{imagesfolder}/stars/$userinfo[starimg].gif\" border=\"0\">";
++$sli;
}

Und im getinfo-Template f?gst Du dann irgendwo (wo Du die Sterne gerne haben m?chtest] $userinfo[stars] ein. Thats it. ;)

[Angelus]

danke für den tipp nun klappt es superstar

[iceman11111]

Please Help

after I installed this hack, whenever someone registers it doesn't send them the verification email!

Also, any email that I send via the admin options doesn't get to the user!

[Wolf42]

Did the mail-function work before installing the hack? And which version of vB are you using? Couse the hack dosn't change anything in the mail-function of vB. :confused:

[iceman11111]

Hi

Yes, everything was working before.

Ver 2.2.9

Also, I had to add a '3' to the end of every php

because I am using php3

[iceman11111]

Ok, I have semi figured it out!

I figured out that it is the stars.php file

[iceman11111]

FIXED

I had to add "error_reporting(7);"

just after the first line "<?php"

[mcyates]

I don't get any images, all i get is .gif???? instead of star.gif

[Wolf42]

Do you have folder called "stars" in your images-folder? Thats where the GIF's are located.

[Alien]

Anyone have this confirmed working in a fresh vB 2.3.0 install? :)

-Jason