Stars v0.2.3

Thanks to Bane there has been a complete reworking of the installation/instructions for this hack. It is now up to date for 2.0.3 and the installer runs exactly like the vB install/upgrade scripts do.

There is no demo as I don't currently use stars on my board.

For version: 2.0.3

Files needed: stars.php

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

Templates to edit: postbit

Instructions: Upload install_starshack.php and stars.php to your admin directory. Go to example.com/admin/install_starshack.php and login, then follow the on-screen instructions.

Upgrade information: If you have previously installed the stars hack, make sure you choose the "upgrade" option on the screen mentioned in the instructions. If you have previously installed this version (using install_starshack.php), you MUST STILL use the upgrade option even if you are reinstalling or you will get database errors.

This hack is © 2001 Kevin Schumacher and may not be redistributed, modified or not, without prior permission.

Please DO NOT contact me via AIM, ICQ, PM, or email about this hack. Post your question/problem here and I will try to help you.

Feedback appreciated.

[fastforward]

Another hack installed and working. I'm going on a hack installation spree

Thanks for this one tubedogg.

[Lesane]

I just installed the hack and it works great, expect that no one cant register anymore, ill get a mysql error:
this is the error:

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,'PaCaLyPsE','kwanie',lala@lala.com,'1','','0 ','http://','','','','','1','1','0','Beginner','991856220',' 1','-1','991856220','991856220','2','0','1','1','0','ye s','0','-1','1','169.12.167','0','0','1','1','1')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Wednesday 06th of June 2001 09:37:00 PM
Script: /board/register.php

pllllzzz help, no new member anymore.... i already received 9 of them...

I still cant get the stars to show for the admin user group. What I want is one star that changes to other colors. I want 6 of them to show, and I have filled in the information correctly for the administrator user group, but it still does not work. can some one please help.

[tubedogg]

The thing mentioned two posts up about register.php - that was my bad. I apparently missed that query when rewriting the directions.

Anyway, the correct query is now in the stars.txt file in the zip file. Sorry about that.

[Dakota]

SSJ4, Under User Groups and permissions go to modify, then esit the administrator section to how you want it. Then go to Update counters and press Update on the Update Users info box.

Thanks dakota . Seen you round on a nother forum too. Bet you know. great job at that forum.

Hmm... For some reason it dislikes me.

When ever some one tries to register i get this sent to me


Database error in vBulletin: Invalid SQL: INSERT INTO user
(userid,username,password,email,styleid,
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,'SS_4_Goku00','pokeball','ss_4_goku00@yahoo. com','1','','0','','','','','','1','1','0','Junior
Member','991885732','1','-1','991885732','991885732','2','0','1','1','0','15 ','0','-1','1','127.0.0.1','0','0','1')
mysql error: You have an error in your SQL syntax near 'join
date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset' at
line 1
mysql error number: 1064
Date: Thursday 07th of June 2001 03:48:52 AM
Script: /forum/register.php
Referer: http://www.guyverout.f2s.com/forum/register.php


How do I allow them to register? (

[tubedogg]

I'm assuming you copied and pasted out of the thread here instead of using the zip file.

Replace all this:

PHP Code:

$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash,starlevel,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')");
  $userid=$DB_site->insert_id(); 


with the query on line 173 of stars.txt that starts

PHP Code:

  $DB_site->query("INSERT INTO user 


[Lesane]

Originally posted by tubedogg
The thing mentioned two posts up about register.php - that was my bad. I apparently missed that query when rewriting the directions.

Anyway, the correct query is now in the stars.txt file in the zip file. Sorry about that.

it works great now.
thnx.

[Dakota]

I had that same problem, so I just put my backup copy back up, and it has worked fine ever since.

Originally posted by Dakota
I had that same problem, so I just put my backup copy back up, and it has worked fine ever since.

Thankds Dakota , it works GREAT NOW.

Everything went smoothly. One question though. How can I get the stars to show up in the user's profile, similar to their avatars?
thanks

[maverick1236]

<a href="http://happyhome1.homestead.com/files/usergroup.txt" target="_blank">here is my usergroup php file</a>

the error im getting when i click on modify user groups and permissions is this :

Parse error: parse error in e:\program files\nusphere\apache\htdocs\forums\admin\usergrou p.php on line 84

By looking at the modified file i cant see any errors-do you?

im using vbulletin 2.0.0

thanks for any help-this looks like a great hack!

I know this is off topic, but how did you install php and mysql on apache? I need to know.

On the other side, I think maby you installd the hack wrong. Check over it again.