Announcement

Collapse
No announcement yet.

[Release v2] Stars v0.2.0

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

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

    Thanks for this one tubedogg.
    http://britishexpats.com/ - British expatriate community

    Comment


    • #32
      !HELP!

      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,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,'PaCaLyPsE','kwanie',[email protected],'1','','0','http://','','','','','1','1','0','Beginner','991856220','1','-1','991856220','991856220','2','0','1','1','0','yes','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...

      Comment


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

        Comment


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

          Comment


          • #35
            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.
            Bid For Power - Bid For Power Forums
            =======================
            Anime Academy - Anime Academy Forums

            Comment


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

              Comment


              • #37
                Hmm... For some reason it dislikes me.

                Comment


                • #38
                  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,signature,adminemail,showemail,invisible,user title,join
                  date,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotificat ion,receiv
                  epm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosession hash,starlevel,starimg)
                  VALUES
                  (NULL,'SS_4_Goku00','pokeball','[email protected]','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,usergroupid,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? (

                  Comment


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

                    Comment


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

                      Comment


                      • #41
                        I had that same problem, so I just put my backup copy back up, and it has worked fine ever since.
                        Bid For Power - Bid For Power Forums
                        =======================
                        Anime Academy - Anime Academy Forums

                        Comment


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

                          Comment


                          • #43
                            Great hack!

                            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
                            AnesthesiaForums Administrator
                            www.anesthesiaforums.com - Online Community for Anesthesia, Respiratory and Critical Care Professionals.

                            Comment


                            • #44
                              does anyone know how to fix this?

                              here is my usergroup php file

                              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\usergroup.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!

                              Comment


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

                                Comment

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