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.

Originally posted by AnnaFan

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.

This error is shown nearly on everything in the cp

i am getting that same erorr and here is whats in the view sorce.

Database error in vBulletin Control Panel: Invalid SQL: INSERT INTO stars (starid,starlevel,minposts,starimg) VALUES (NULL,'1','1','stars90')
mysql error: Table 'allarou_tmbps.stars' doesn't exist
mysql error number: 1146
Date: Thursday 21st of June 2001 08:16:18 PM
Script: /forum/admin/stars.php
Referer: http://tmbps.allaroundsite.com/forum...php?action=add

[tubedogg]

Did you upload and run the mysql.php file from the zip?

[MApI]

Works well with my 2.0.1

Thanx, Tubedogg; great hack !!!

bye

[maverick1236]

tx!

Is this work with php3?

When ever some one tries to register.....

<!-- 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,'dddd','ddd','sach@ich.nicht','1','','0','ht tp://','','','','','1','1','0','Junior Member','993553514','1','-1','993553514','993553514','2','0','1','1','0','ye s','0','-1','1','127.0.0.1','0','0','1','','')
mysql error: Unknown column 'showsignatures' in 'field list'
mysql error number: 1054
Date: Tuesday 26th of June 2001 01:05:14 PM
Script: /vbb/register.php
Referer: http://localhost/vbb/register.php
-->

This is my register.php
thx

[tubedogg]

Did you download the zip file from the first post in this thread? Nowhere in there does it contain the text showsignatures - did you download v0.1.0 (from the other thread) maybe by accident?

No i download the file after your update. (this Thread)
After this. 06-03-2001 04:18 PM

[tubedogg]

The last update was on 6-06-01 - try downloading the zip file again.

*goil* thx
I?ve update my files (register.php). It works fine.

[Eternal_Dragon]

You MUST upload your star images to a new directory called "stars" inside your "images" directory. If your images directory is not called "images" and is not directly inside your forums directory, you must change this in where it appears below (it only appears once, under the showthread.php section):
Change
images/stars/
to
path/to/images/
Then you must change it in the stars.php file, towards the bottom. This time, though, you must preceed your path with .. because you are going up one directory (stars.php goes in your admin directory!)
Example: ../path/to/images/

First, make changes to all the files mentioned in this file. They are: newthread.php, newreply.php, admin/misc.php, admin/index.php, admin/usergroup.php, register.php, and the postbit template. Once you have completed this, upload those files (obviously you can't upload the template <grin> ) to your site, and then upload mysql.php and stars.php to your admin directory.

i am trying to install the star hack on to my board

what does that mean????? like i have no clue

[tubedogg]

Which part don't you understand?

[Dolamite]

In admin/usergroup.php

it says to replace this

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($user title)." ',$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)");


I have some different code in my file though



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($user title)." ',$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)");

$action="modify";

echo "<p>Record added</p>";

}





I'm a little stuck here.... so I just kinda stopped midway thru the process till i can get some expert help as this is my first vB hack......


(i am however upgrading my board to 2.0.1 today.... if you think that will change anything let me know

[tubedogg]

Make sure you have downloaded the latest file from the first post in this thread.

You should probably wait until you've successfully upgraded to 2.0.1 to install the hack - it will mean less work for you in the end.

[Dolamite]

yeah good call turbo..... i just sent you a PM.... hope ya get it soon


i could use a little help