[Release v2] Stars v0.1.0 with new features!

[tubedogg]

Last Update 4.01.01 4:10 AM Eastern

Important: I have fixed a slight bug found by Marl in stars.php. You need to do this:

Find
$DB_site->query("INSERT INTO stars (starid,starlevel,minposts,starimg) VALUES (NULL,$starlevel,$minposts,$starimg)");
And replace it with
$DB_site->query("INSERT INTO stars (starid,starlevel,minposts,starimg) VALUES (NULL,'$starlevel','$minposts','$starimg')");

If you have not installed this hack yet, I have updated the zip file, so don't worry about this.

Note: I forgot stars.php in the zip file the first time around. Sorry, my bad. It's there now! ;)

This is the hack that some of you were clamoring for over in my other Stars hack thread, so here it is. You can now specify a different star image per number of posts or per usergroup. You can also still specify a number of stars to give, and it is still integrated tightly with the vB Admin Control Panel. If you wish to upgrade to this version, there is a way to do that, and I will put that in the next post in this thread, as it requires different files than a full install.

Please note: I will *not* support the other version of this hack (0.0.2) from now on, so please upgrade to (or install) this version.

This hack is too detailed to list all the instructions in this thread, so please download the zip file and read the file called stars.txt in there.

REMEMBER: If you are upgrading, go to the second post in this thread and upgrade from there!

Hack version: 0.1.0

Changes since last version: You can now set different images per level of posts/usergroup as well as the number of stars.

For version: vBulletin v2 beta 3 (possibly beta 1 and beta 2, but it is untested with those versions).

Files needed: stars.php, mysql.php

Files to edit: stars.php (possibly), newthread.php, newreply.php, admin/misc.php, admin/index.php, admin/usergroup.php, register.php

Templates to edit: postbit

Instructions are in the zip file (the file called stars.txt).

PLEASE backup your board before making any changes, and PLEASE be careful. I have tested this extensively, but I cannot guarantee it will work on your board. If you have problems, please post them in this thread and I will try to help you.

PLEASE DO NOT contact me via ICQ, AIM, email, or PM to help you with this hack. Post your problem here - I will see your post and try to help you, and contact you via IM service if necessary.

[tubedogg]

This is the upgrade file, to upgrade from v0.0.1 or v0.0.2. Please follow all instructions as found in the stars.txt file in the zip file. You will need to replace your stars.php file with the one found in the zip file, and you will need to run mysqlupgrade.php as well. Please backup your board first!

[marl]

that's great, i've only modified it to show mod stars only in forums where my users are actually moderators.

thanks a lot, tubedogg
:)

[tubedogg]

If a lot of people would want that function (only showing mod stars in the forum where the user *is* a mod), I'll look into it. Anyone?

[marl]

i would like to have different color stars summing rather than being all of the same filename....

eg..
5posts-> star1.gif
10posts->star2.gif


so the user obtain
star1.gif+star2.gif


got the point?

[marl]

tube, i found a little bug in stars.php (0.1.0)

changed this line:

$DB_site->query("INSERT INTO stars (starid,starlevel,minposts,starimg) VALUES (NULL,$starlevel,$minposts,$starimg)");

to

$DB_site->query("INSERT INTO stars (starid,starlevel,minposts,starimg) VALUES (NULL,'$starlevel','$minposts','$starimg')");


otherwise gives a db error.

[tubedogg]

Yes you're right about that.

I'll look into multiple images for the next version, after beta 4 is released.

[tubedogg]

I have fixed the bug that Marl found, and the zip file is updated. The instructions are in both Marl's post and the first post in this thread for how to fix it if you already have installed this hack.

[jojo85]

WHERE CAN I SEE A DEMO?

[rebby]

Originally posted by jojo85
WHERE CAN I SEE A DEMO? http://board.tubescan.com/

[Raptor]

has anyone tested this on b4.1 ?

and can you also do a php3 version please ?

[conan]

I guess it will work on 4.1, and just rename to .php3 should work fine!

[tubedogg]

Actually board.tubescan.com uses a different star system. It is not this hack; I merely used user titles and used HTML in them. This is a completely different thing than that.

I have not tested it with 4.1, I will do so shortly. However, there's no reason it shouldn't work. For a php3 version, just rename stars.php to stars.php3.

[jojo85]

Originally posted by tubedogg
Actually board.tubescan.com uses a different star system. It is not this hack; I merely used user titles and used HTML in them. This is a completely different thing than that.

.

Ok,why?

[upgrader]

Originally posted by tubedogg
I have not tested it with 4.1, I will do so shortly. However, there's no reason it shouldn't work. For a php3 version, just rename stars.php to stars.php3.

Installed and tested OK on 4.1 last night, works a treat :D

[tubedogg]

Originally posted by jojo85
Ok,why [don't you use the hack on your site]?

Because when I set up stars I hadn't decided to do this hack yet, and I haven't changed over to it. I may, sometime in the future, but I may not. I don't know yet. I wrote the hack because of a specific request, a month after I set up my board.

[mschoel]

dude, my stars just don't show.. everything seems to be setup correctly, admin, etc..
the showthread template also leaves space for the stars underneath the username.. but the bloody stars just don't show..

any idea why.. please help..

thanks!

[-=WTFxP=-]

sorry but my stars wount appear on the board anyone know whats the problem then ?


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

i dont know please help

[-=WTFxP=-]

i was just dumb worked now ..and many many thx for the work

[rickjansen105]

Doesn't work in RC2??? :(
i just don't see the stars... i DID EVERYTHING that's in the info (i got a few probs with admin/misc.php, because some coding was different -because new options were added since beta 3-)
i tried EVERYTHING to get it to work...

-maybe i can't update the counters for the stars, because of the probs with admin/misc.php - maybe that's the problem???-

please help me...
i want this hack! :)
maybe you can make it RC2-compitable?
thanks for your help in advance...


Rickjansen105

[Maverick1236]

heres what i see when i click submit in control panel:
There seems to have been a slight problem with the 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.

[tubedogg]

You need to view the source of the page when it gives you the error and copy and paste that here or copy and paste the contents of the email you should receive.

[Maverick1236]

seems to work now xcept 4 this
Parse error: parse error in h:\nusphere\apache\htdocs\upload\admin\usergroup.p hp on line 202(when i go to modify usergroups)

here is my usergroup.php file:
oh no it isn't (#)

[Maverick1236]

Could you do me a huge favor and just post a usergroup.php file for RC3-with everything already set up for the stars hack?
my file is a mess now lol-i would REALLY appreciate it
everything seems to be working xcept usergroup permissions-i assume thats where i set up how many stars for how many posts?
thank ALOT-looks like a GREAT hack-its SO close to working!

[smelialichu]

Originally posted by Maverick1236
Could you do me a huge favor and just post a usergroup.php file for RC3-with everything already set up for the stars hack?
my file is a mess now lol-i would REALLY appreciate it
everything seems to be working xcept usergroup permissions-i assume thats where i set up how many stars for how many posts?
thank ALOT-looks like a GREAT hack-its SO close to working!
I think it's against the terms to post complete modified php file.

[tubedogg]

You're getting a parse error on line 202? Besides the obvious (that it shouldn't be happening), it really shouldn't be happening cause I don't have you edit anything around there. I'll look into it.

You know I cannot post usergroup.php.

[Maverick1236]

i took a fresh usergroup.php file and went from there
now the error is on line 75

[tubedogg]

K try this

find
if ($HTTP_POST_VARS['action']=="insert") {

$DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,cansearch,canem ail,canpostnew,canmove,canopenclose,candeletethrea d,canreplyown,canreplyothers,canviewothers,canedit post,candeletepost,canusepm,canpostpoll,canvote,ca npostattachment,ismoderator,canpublicevent,canpubl icedit,canthreadrate,cantrackpm,candenypmreceipts, maxbuddypm,maxforwardpm)
VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."',$cancontrolpanel,$canmodifyprofile,$canviewmembe rs,$canview,$cansearch,$canemail,$canpostnew,$canm ove,$canopenclose,$candeletethread,$canreplyown,$c anreplyothers,$canviewothers,$caneditpost,$candele tepost,$canusepm,$canpostpoll,$canvote,$canpostatt achment,$ismoderator,$canpublicevent,$canpublicedi t,$canthreadrate,$cantrackpm,$candenypmreceipts,$m axbuddypm,$maxforwardpm)");
and replace it with
$DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,starlevel,starimg, cancontrolpanel,canmodifyprofile, canviewmembers,canview,cansearch, canemail,canpostnew,canmove, canopenclose,candeletethread,canreplyown, canreplyothers,canviewothers,caneditpost, candeletepost,canusepm, canpostpoll,canvote,canpostattachment, ismoderator,canpublicevent,canpublicedit, canthreadrate,cantrackpm, candenypmreceipts,maxbuddypm,maxforwardpm)
VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."',$starlevel,$starimg,$cancontrolpanel, $canmodifyprofile,$canviewmembers, $canview,$cansearch,$canemail, $canpostnew,$canmove,$canopenclose, $candeletethread,$canreplyown,$canreplyothers, $canviewothers,$caneditpost,$candeletepost, $canusepm,$canpostpoll,$canvote, $canpostattachment,$ismoderator, $canpublicevent,$canpublicedit, $canthreadrate,$cantrackpm, $candenypmreceipts,$maxbuddypm, $maxforwardpm)");
Then find
exit;
}
$DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',cancontrolpanel=$cancontrolpanel,canmodifyprofil e=$canmodifyprofile,canviewmembers=$canviewmembers ,canview=$canview,cansearch=$cansearch,canemail=$c anemail,canpostnew=$canpostnew,canmove=$canmove,ca nopenclose=$canopenclose,candeletethread=$candelet ethread,canreplyown=$canreplyown,canreplyothers=$c anreplyothers,canviewothers=$canviewothers, caneditpost=$caneditpost,candeletepost=$candeletep ost,canusepm=$canusepm,canpostpoll=$canpostpoll,ca nvote=$canvote,canpostattachment=$canpostattachmen t,ismoderator=$ismoderator,canpublicedit=$canpubli cedit,canpublicevent=$canpublicevent,canthreadrate =$canthreadrate,cantrackpm=$cantrackpm,candenypmre ceipts=$candenypmreceipts,maxbuddypm=$maxbuddypm,m axforwardpm=$maxforwardpm WHERE usergroupid=$usergroupid");
and replace it with
exit;
}
$DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',starlevel='$starlevel',$starimg='$starimg',canco ntrolpanel=$cancontrolpanel, canmodifyprofile=$canmodifyprofile, canviewmembers=$canviewmembers,canview=$canview, cansearch=$cansearch, canemail=$canemail,canpostnew=$canpostnew,canmove= $canmove,canopenclose=$canopenclose, candeletethread=$candeletethread, canreplyown=$canreplyown,canreplyothers=$canreplyo thers,canviewothers=$canviewothers, caneditpost=$caneditpost, candeletepost=$candeletepost, canusepm=$canusepm,canpostpoll=$canpostpoll,canvot e=$canvote, canpostattachment=$canpostattachment,ismoderator=$ ismoderator,canpublicedit=$canpublicedit, canpublicevent=$canpublicevent,canthreadrate=$cant hreadrate,cantrackpm=$cantrackpm, candenypmreceipts=$candenypmreceipts,maxbuddypm=$m axbuddypm,maxforwardpm=$maxforwardpm WHERE usergroupid=$usergroupid");

And tell me if you still get an error.

[Nicholas Brown]

Maverick,

You might want to delete that page - its a violation of the License Agreement - distrobuting code and all ;)

[snyx]

Can I please see a working update for vB 2.0 FINAL, PLEASE?!? :D

[White Chocobo]

Originally posted by snyx
Can I please see a working update for vB 2.0 FINAL, PLEASE?!? :D

I think that's the third time I've seen snyx say that. Well I'm gonna test this hack on my vB 2 Final. But I'm guessing I'll have to make some modifications to the hack. Well wish me luck!

[snyx]

LOL! Yeah I posted it in the 3 threads I wanted solid, working, 2.0 updates. Yeah, if you could test it, it would be a great help. Im busy testing a script right now, and playing with my own sites. Thanks!

snyx

[tubedogg]

I really don't appreciate you posting like something's wrong with it when you haven't even tested it yet.

[snyx]

Originally posted by tubedogg
I really don't appreciate you posting like something's wrong with it when you haven't even tested it yet.
Whats the insult? I would simply like the script to be tested before I install it, whats so wrong with asking that? Just the wording, it works on 2.0 Final is all im looking for. Lets not jump to conclusions, you know I would never insult your work tubedogg, or atlest you should know I wouldnt.

[fastforward]

snyx,

With all due respect, if you are so anxious for this hack and are concerned about the stability, how about you taking some time and testing it for everyone else? The fact you said you're to busy working on your own site doesn't really inspire anyone else to neglect their own sites to test it for you.

I know you said you didn't mean to insult anyone, but I just happened to come across this post while posting another hack. I didn't even write this particular one and I still took offense. :)

[snyx]

Whatvere, delete the posts for all I care. If ya wanna take everything to heart, thats fine. I just wont ask for help anymore, or anything in your threads anymore. Sheesh, don't bother debating about it, leave it and PM me if ya must. Im quite shocked and dissapionted in some ppl right now. I thought you would have known me better kevin.

myles

[TwiZteR]

Originally posted by rickjansen105
Doesn't work in RC2??? :(
i just don't see the stars... i DID EVERYTHING that's in the info (i got a few probs with admin/misc.php, because some coding was different -because new options were added since beta 3-)
i tried EVERYTHING to get it to work...

-maybe i can't update the counters for the stars, because of the probs with admin/misc.php - maybe that's the problem???-

please help me...
i want this hack! :)
maybe you can make it RC2-compitable?
thanks for your help in advance...


Rickjansen105

try to update your counters ;)

[TwiZteR]

umm, the hack worked great for all members who are already registered, but now ppl aren't able to register:

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,starlevel,starimg) VALUES (NULL,'Pure','*******','spsr9@hotmail.com','','0', 'http://','','','','','1','1','0','','990781330','1','-1','990781330','990781330','4','0','1','1','0','15 ','0','-1','1','217.32.130.234','0','0','0','1','1','0star s')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Friday 25th of May 2001 11:02:10 AM

are there any versions for the RC releases ??

[White Chocobo]

Well here's what I got for you people who wish not to test it before it's been tested. *cough*synx*cough*

Anyways I got the thing to work. But with a few modifications. (Kinda forgot them) Anyways the only thing that doesn't work in the hack is that in vB2 the stars don't show up in the threads/posts. I don't know what's wrong. Hope someone can figure it out for me.

http://ffanitopia.maryginseng.com/forums/

Just check a forum. It should show 1 star but it doesn't.

[snyx]

Originally posted by White Chocobo
Well here's what I got for you people who wish not to test it before it's been tested. *cough*synx*cough*

:rolleyes:

[catocom]

I don't see this any where in the 2.0final version of misc.php

**Find
echo "<p><b>Update Users Info</b> - updates user titles<br>\n";
**Replace it with
echo "<p><b>Update Users Info</b> - updates user titles and Stars<br>\n";


also I think this needs to be updated...


****In admin/index.php****
**Find
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr bgcolor="#3F3849"><td><font color="#BCB6CD">
<b>User Titles</b>
</font></td></tr></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>
**Right below it, add
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2">
<tr bgcolor="#3F3849"><td><font color="#BCB6CD">
<b>Stars</b>
</font></td></tr></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>

I believe the right line in mine looks like this...
<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>

[catocom]

Originally posted by TwiZteR
umm, the hack worked great for all members who are already registered, but now ppl aren't able to register:

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,starlevel,starimg) VALUES (NULL,'Pure','*******','spsr9@hotmail.com','','0', 'http://','','','','','1','1','0','','990781330','1','-1','990781330','990781330','4','0','1','1','0','15 ','0','-1','1','217.32.130.234','0','0','0','1','1','0star s')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Friday 25th of May 2001 11:02:10 AM

are there any versions for the RC releases ??

Yeap, I'm getting almost the same thing
new users can't register, and I also can't add new user
groups..(same error)

[catocom]

well on my problem I've tracked it down to something
with the coding in the usergroup.php and the register.php files

All the other files work fine, and the stars work and
everything.
The only problem I can see is that in CP when you
add a new group you can't setup the stars for it,
LOL, but if you use the modified file after you create
the group you can add or change the settings, just
not create new ones, and new users can;t register while
your doing that, but then switch back to the originals,
on those 2 files an everything seems fine. :D

I will track this down :D I'm gettin close now.
If I can just figure out what the problem is in the
register file.
I gives me an error that..
Database error in vBulletin: 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,showsignatures,birthday,maxposts,startofweek,i paddress,pmpopup,referrerid,nosessionhash,starleve l,starimg) VALUES (NULL,'me2','4278','catocom@yahoo.com','1','','0', 'http://','','','','','1','1','0','Junior Member','990861455','1','-1','990861455','990861455','2','0','1','1','0','ye s','0','-1','1','192.168.0.3','0','0','1','1','Mod1')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054


If you want to see my stars in action...(what I've got so far)
http://24.181.7.75/forum/showthread.php?threadid=26

[White Chocobo]

Okay I only have 2 problems. I can't add new User Groups like catocom said. And when I set the Admins to 8 stars it doesn't work. It still shows only 1 star. Is there anyway to fix this?

[jojo85]

Huh
i haven't got that in usergroup.php:


**Find
if ($action=="insert") {

$DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,cansearch,canem ail,canpostnew,canmove,canopenclose,candeletethrea d,canreplyown,canreplyothers,canviewothers,canedit post,candeletepost,canusepm,canpostpoll,canvote,ca npostattachment,ismoderator,canpublicevent,canpubl icedit,canthreadrate) VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."',$cancontrolpanel,$canmodifyprofile,$canviewmembe rs,$canview,$cansearch,$canemail,$canpostnew,$canm ove,$canopenclose,$candeletethread,$canreplyown,$c anreplyothers,$canviewothers,$caneditpost,$candele tepost,$canusepm,$canpostpoll,$canvote,$canpostatt achment,$ismoderator,$canpublicevent,$canpublicedi t,$canthreadrate)");


WhY?:confused:

[DEMOLiTiON]

I installed this hack on my vb2.0 Final, worked great thnx :)

[Tom Dooley]

What should i do here ?

I could not find this in the final

**Find
echo "<p><b>Update Users Info</b> - updates user titles<br>\n";
**Replace it with
echo "<p><b>Update Users Info</b> - updates user titles and Stars<br>\n";

[dadada]

how did u manage to install it ?

there

are u using beta versions ?

this aint working on the vb 2.0 gold release

[DEMOLiTiON]

Originally posted by Tom Dooley
What should i do here ?

I could not find this in the final

**Find
echo "<p><b>Update Users Info</b> - updates user titles<br>\n";
**Replace it with
echo "<p><b>Update Users Info</b> - updates user titles and Stars<br>\n"; Just search for "Update Users Info" it aint that hard..

[DEMOLiTiON]

Originally posted by dadada
how did u manage to install it ?

there

are u using beta versions ?

this aint working on the vb 2.0 gold release Edit newthread.php, newreply.php, register.php the way tubedogg did.

Edit admin/misc.php, admin/index.php, admin/usergroup.php the way I did with my vB2.0 Final.****In admin/usergroup.php****
**Find
makeinputcode("User Status<br>Use this to override the default 'ladder' of user status titles","usertitle");

**Right under it, add
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");

**Find
if ($HTTP_POST_VARS['action']=="insert") {

$DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmo difyprofile,canviewmembers,canview,cansearch,canem ail,canpostnew,canmove,canopenclose,candeletethrea d,canreplyown,canreplyothers,canviewothers,canedit post,candeletepost,canusepm,canpostpoll,canvote,ca npostattachment,ismoderator,canpublicevent,canpubl icedit,canthreadrate,cantrackpm,candenypmreceipts, maxbuddypm,maxforwardpm)
VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."',$cancontrolpanel,$canmodifyprofile,$canviewmembe rs,$canview,$cansearch,$canemail,$canpostnew,$canm ove,$canopenclose,$candeletethread,$canreplyown,$c anreplyothers,$canviewothers,$caneditpost,$candele tepost,$canusepm,$canpostpoll,$canvote,$canpostatt achment,$ismoderator,$canpublicevent,$canpublicedi t,$canthreadrate,$cantrackpm,$candenypmreceipts,$m axbuddypm,$maxforwardpm)");

**Replace it with
if ($HTTP_POST_VARS['action']=="insert") {

$DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,starlevel,starimg,can controlpanel,canmodifyprofile,canviewmembers,canvi ew,cansearch,canemail,canpostnew,canmove,canopencl ose,candeletethread,canreplyown,canreplyothers,can viewothers,caneditpost,candeletepost,canusepm,canp ostpoll,canvote,canpostattachment,ismoderator,canp ublicevent,canpublicedit,canthreadrate,cantrackpm, candenypmreceipts,maxbuddypm,maxforwardpm)
VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)."',$starlevel,$starimg,$cancontrolpanel,$canmodifyp rofile,$canviewmembers,$canview,$cansearch,$canema il,$canpostnew,$canmove,$canopenclose,$candeleteth read,$canreplyown,$canreplyothers,$canviewothers,$ caneditpost,$candeletepost,$canusepm,$canpostpoll, $canvote,$canpostattachment,$ismoderator,$canpubli cevent,$canpublicedit,$canthreadrate,$cantrackpm,$ candenypmreceipts,$maxbuddypm,$maxforwardpm)");

**Find
makeinputcode("User Status<br>Use this to override the default 'ladder' of user status titles","usertitle",$usergroup[usertitle]);

**Right under it, add
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]);

**Find
exit;
}
$DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',cancontrolpanel=$cancontrolpanel,canmodifyprofil e=$canmodifyprofile,canviewmembers=$canviewmembers ,canview=$canview,cansearch=$cansearch,canemail=$c anemail,canpostnew=$canpostnew,canmove=$canmove,ca nopenclose=$canopenclose,candeletethread=$candelet ethread,canreplyown=$canreplyown,canreplyothers=$c anreplyothers,canviewothers=$canviewothers,canedit post=$caneditpost,candeletepost=$candeletepost,can usepm=$canusepm,canpostpoll=$canpostpoll,canvote=$ canvote,canpostattachment=$canpostattachment,ismod erator=$ismoderator,canpublicedit=$canpublicedit,c anpublicevent=$canpublicevent,canthreadrate=$canth readrate,cantrackpm=$cantrackpm,candenypmreceipts= $candenypmreceipts,maxbuddypm=$maxbuddypm,maxforwa rdpm=$maxforwardpm WHERE usergroupid=$usergroupid");

**Replace it with
exit;
}
$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,cansearch=$cansearch,canemail=$canemail, canpostnew=$canpostnew,canmove=$canmove,canopenclo se=$canopenclose,candeletethread=$candeletethread, canreplyown=$canreplyown,canreplyothers=$canreplyo thers,canviewothers=$canviewothers,caneditpost=$ca neditpost,candeletepost=$candeletepost,canusepm=$c anusepm,canpostpoll=$canpostpoll,canvote=$canvote, canpostattachment=$canpostattachment,ismoderator=$ ismoderator,canpublicedit=$canpublicedit,canpublic event=$canpublicevent,canthreadrate=$canthreadrate ,cantrackpm=$cantrackpm,candenypmreceipts=$candeny pmreceipts,maxbuddypm=$maxbuddypm,maxforwardpm=$ma xforwardpm WHERE usergroupid=$usergroupid");

****In admin/misc.php****
**Find
maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0);

**Replace it with
maketableheader("Update Users Info</b> - </b>updates user titles and Stars<b>","",0);

****In admin/index.php****
**Find
<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>

**Right below it, add
<tr><td>
<table width="100%" border="0" cellspacing="0" cellpadding="2" id="navtable">
<?php maketableheader("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>I hope I didn't forget something! Hope this wil help ya'll.

[First-Man]

Does it work with the final release?

[White Chocobo]

Yeah it does work with the final version. But some of the codes you need to modify are a bit different from the Final Version's codes. You just have to find them.

[First-Man]

Originally posted by White Chocobo
But some of the codes you need to modify are a bit different from the Final Version's codes. You just have to find them.

Ehm.... I don´t know what I´ve to modify Newbie :D
thx

[Tom Dooley]

Hi,
does anyone kno how to fix the problem in register.php right know ?

User ca not register, and i get this

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,show signatures,birthday,maxposts,startofweek,ipaddress ,pmpopup,referrerid,nosessionhash,starlevel,starim g) VALUES (NULL,'mummel','test1','mummel44@hotmail.com','',' 0','http://','','','','','1','1','0','ist noch neu hier','991266968','1','-1','991266968','991266968','3','1','0','1','1','ye s','0','-1','2','217.87.184.133','1','0','1','','')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Wednesday 30th of May 2001 07:56:08 PM
Script: /forum/register.php


Help please

[Black Tiger]

Maybe someone can help me with this.
VB 2.0 final.
I think I must have made some mistake somewhere.
Took the hack and implemented it like described by DEMOLiTiON.

Now my CP looks fine, I can do everything.
In the stars section of the CP I added the star levels and I see little stars blinking, so that's also correct.

But the problem is, after updating the usercounts, stars won't show up on the board.
I also got the problem new users can't register, they can't come further then the form, when submitting the form an error notice is coming up:

Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,show signatures,birthday,maxposts,startofweek,ipaddress ,pmpopup,referrerid,nosessionhash,starlevel,starim g) VALUES (NULL,'test','test','technical@satellitefun.org',' ','0','http://','','','','Bye','1','0','0','Junior Member','991388438','1','-1','991388438','991388438','3','0','0','0','0','ye s','0','-1','2','my.ip.adres.here','0','0','1','','')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Friday 01st of June 2001 05:40:38 AM
Script: /bbs/register.php

Any idea what I could have done wrong of could have forgotten? Due to this error I closed new registrations for the time being.

ps. mysql.php is needed or can be deleted after the implementation?

[Black Tiger]

@Tom Dooley, I think i've solved our problem about the new user registrations in VB2.0 final.

Unpack a new register.php from the zipfile

Edit like in stars.txt

When you come to the second change:
**Find
$DB_site->query("INSERT INTO user (userid,username,password,email,".$etcetera

Do NOT copy the new line as mentioned. This will give the new-user error in the database, somewhere there is a fault.

I solved the problem the easy way.
Just find this line and add the "starlevel" and "starimg" by hand in the middle of the line, and at the end of the linke $starlevel and $starimg.

You can also copy this line, its the working one I've got now:

$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,starl evel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes($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','$userstarlvl','$userstarimg')");

Under this you will find a line:
$userid=$DB_site->insert_id();

You can just leave that there, don't need to change.

Now the only problem I still got is my stars won't show up in the forum. Who can help?

[Tom Dooley]

Hi,
thanks but still the same problem this did not fix it :(
Any other idee ?

[Black Tiger]

No sorry, I just downloaded the new stars10.zip which is in the first post of this thread, did what was in the stars.txt and the changes mentioned here by DEMOLiTiON.

After that I took a new register.php and updated the line I wrote about manually. Then it worked.
I registered newly as a test user and the problem was over.

Did you replace the online register.php with the new editted one? Do you get an other error notice?
First you got: Unknown column 'showsignatures' in 'field list'
You can check with phpmyadmin if this "showsignatures" field is in there. In my case it wasn't and neither was ip adres, that way I noticed something had changed places in the line which was to be editted in register.php.

I just don't see any stars coming up on the board.

In the original vb20final zipfile also where some stars named 0stars,1stars,2stars etc till 5stars.
Was it first the intention of the developers to implement their own starhack?

[Tom Dooley]

Hi,
i didi it again it works :)
Thanks a lot, the frist time i used the complet sentence from you did not work, the second time i edited manuelly and i works :)

Great

[Black Tiger]

Hmmz.. strange, maybe then the problem lies in the fact that it must be in 1 line?

Anyway, nice that it works now.

Let me know if you succeed to get the stars on the board itself, cause that's the only problem remaining now.:)

[SSJ4 Saiya-jin]

Can some one just make a 2.0 final star hack? I mean skimming through all this junk hurts my eyes. It would just be a lot better for someone to remake it and the zip it up to a free web space provider so it is avaliable to download. I really need one bad.

[Brady]

Yes, this would be GREATLY appreciated

[SSJ4 Saiya-jin]

Yeah, it would be appreciated. :) Anyway's i know lots of people would use it.

[AnnaFan]

hi,

ist there a version out for 2.0.0? Where can I find this:

****In the postbit _template_****
**Find
<smallfont>$post[usertitle]</smallfont><br><br>
**Replace it with
<smallfont>$post[usertitle]</smallfont><br>$post[stars]<br><br>

:confused: :confused: :confused:

[Black Tiger]

It's in the postbit template just called "postbit".
But in vb2.0final there is only 1 <br> instead of 2 <br><br> in the line you have to find.

I think the problem is in the postbit template or stars.php somewhere.

If you state [starimg] instead of [stars] in the postbit, then under the username on the board the word "star" appears (without the quotes ofcourse)

When putting [stars] no stars appear on the board neither any words.

[White Chocobo]

Okay well this hack works perfectly for my board. At least it did till some hacker screwed up my forum. But once I re-install it how about I make the proper instructions to install it to vB2Final? Sound good? Okay then. Well I'll try to have it up by tomorrow.

[SSJ4 Saiya-jin]

Cool thanks.

[AnnaFan]

that's great White Chocobo. I'll wait for that.

[Black Tiger]

Thanks White Chocobo, I would really appreciate it too.

[White Chocobo]

Well I'm done all the modifications do the hack to make it work for the vB2 Final. Have fun!

P.S. Please PM if there is any trouble with the hack.

[tubedogg]

Just so we're clear I cannot and will not support White Chocobo's version of the hack. I will post *my* version for v2.0.0 when it's ready.

[White Chocobo]

Just to make everyone feel a bit better about my version. It does work you can check out my forum.

http://ffanitopia.maryginseng.com/forums

Or you can wait for tubedogg to bring out the offical version 2 of his.

[tubedogg]

I didn't mean to imply that it did not.

[White Chocobo]

Oh tubedog dog...I really didn't mean to make it sound like you say it didn't...Just re-insuring people that it does that's all. :)

[SS2 Dan]

thanks I can't wait to install it.....

[Ed FvC]

This might be a *tad* off topic, but I'm curious anyways. I'd like it to show up as this... Okay, this might be a bit difficult to explain... :)

Users:
Name
Title (Custom if over 500 posts)
Yellow Stars

Moderators:
Name
Title (IF there's a custom title, I want "Moderator" underneath it)
Red Stars

Admins:
Name
Title (IF there's a custom title, I want "Moderator" underneath it)
Blue Stars

Chances are this won't work, or will be a major pain in the arse. Just being idealistic. :D If it's too hard, what're the chances of the different colored stars?

Thanks!

[Kier]

Closed by request of tubedogg.