Announcement

Collapse
No announcement yet.

[Release v2] Stars v0.2.0

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • #61
    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
    My FFXI Linkshell Website
    - http://www.stealthvertigo.com

    Comment


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

      Comment


      • #63
        Works well with my 2.0.1

        Thanx, Tubedogg; great hack !!!

        bye

        Comment


        • #64
          I fixed it

          tx!

          Comment


          • #65
            Is this work with php3?

            Comment


            • #66
              When ever some one tries to register.....

              <!-- 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,joindate,cookieuser,daysprune,lastvisit,last activity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,showsignatures,b irthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash,starlevel,starimg) VALUES (NULL,'dddd','ddd','[email protected]','1','','0','http://','','','','','1','1','0','Junior Member','993553514','1','-1','993553514','993553514','2','0','1','1','0','yes','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

              Comment


              • #67
                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?

                Comment


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

                  Comment


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

                    Comment


                    • #70
                      *goil* thx
                      I´ve update my files (register.php). It works fine.

                      Comment


                      • #71
                        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

                        Comment


                        • #72
                          Which part don't you understand?

                          Comment


                          • #73
                            I could use a little help

                            In admin/usergroup.php

                            it says to replace this

                            if ($action=="insert") {

                            $DB_site->query("INSERT INTO usergroup (usergroupid,title,usertitle,cancontrolpanel,canmodifyprofile,canviewmembers,canview,canse arch,canem
                            ail,canpostnew,canmove,canopenclose,candeletethread,canreplyown,canreplyothers,canviewothe rs,canedit
                            post,candeletepost,canusepm,canpostpoll,canvote,canpostattachment,ismoderator,canpubliceve nt,canpubl
                            icedit,canthreadrate) VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)." ',$cancontrolpanel,$canmodifyprofile,$canviewmembers,$canview,$cansearch,$canemail,$canpos tnew,$canm
                            ove,$canopenclose,$candeletethread,$canreplyown,$canreplyothers,$canviewothers,$caneditpos t,$candele
                            tepost,$canusepm,$canpostpoll,$canvote,$canpostattachment,$ismoderator,$canpublicevent,$ca npublicedi
                            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,canmodifyprofile,canviewmembers,canview,canse arch,canem
                            ail,canpostnew,canmove,canopenclose,candeletethread,canreplyown,canreplyothers,canviewothe rs,canedit
                            post,candeletepost,canusepm,canpostpoll,canvote,canpostattachment,ismoderator,canpubliceve nt,canpubl
                            icedit,canthreadrate,cantrackpm,candenypmreceipts,maxbuddypm,maxforwardpm)
                            VALUES (NULL,'".addslashes($title)."','".addslashes($usertitle)." ',$cancontrolpanel,$canmodifyprofile,$canviewmembers,$canview,$cansearch,$canemail,$canpos tnew,$canm
                            ove,$canopenclose,$candeletethread,$canreplyown,$canreplyothers,$canviewothers,$caneditpos t,$candele
                            tepost,$canusepm,$canpostpoll,$canvote,$canpostattachment,$ismoderator,$canpublicevent,$ca npublicedi
                            t,$canthreadrate,$cantrackpm,$candenypmreceipts,$maxbuddypm,$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

                            Comment


                            • #74
                              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.

                              Comment


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


                                i could use a little help

                                Comment

                                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                                Working...
                                X