Announcement

Collapse
No announcement yet.

[Release v2] Stars v0.2.0

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

  • Originally posted by tamarian
    Kevin,

    Another bug in the docs:

    Changes to
    admin/usergroup.php (4)

    Step 4 of 4 find:

    Should be:

    replace

    I haven't checked if they're all like that, I just check files when the sh*t hits the fan.

    There is what I need but I need to know what I need to replace it...???

    Comment


    • Replace it with the the code specified in the "add". The documentation is accurate accept for two mistakes where it says add instead of replace.
      vB Drupal Community Plumbing | vB Survey | vBusy | vB Spell | vBouncer

      Comment


      • tam your doing a great thing but your instructions are a bit confusing, include the code so we may copy and paste what your talking about.
        http://www.tchracing.com/forums/live...h_live_sig.jpg

        Comment


        • LuBi,

          It would be very confusing if I include the code, since it would depend if if it's pre hack or post hack.

          But I'll assume you already followed the instructions according to the instructions in the hack.

          In this case, two changes need to be made:

          A) In the register.php changes


          Step 2.2


          PHP Code:
          // Stars Hack
          //  $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) 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')");
          // Stars Replaced 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','$userstarlvl','$userstarimg')");
          // Stars Hack End 
          Simply comment out, or delete the line above it:

          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) 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')"); 

          B) In the usergroup.php

          Step 4 of 4:

          PHP Code:
          // Stars Hack
          /*  $DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',cancontrolpanel=$cancontrolpanel,canmodifyprofile=$canmodifyprofile,canviewmembers=$canviewmembers,canview=$canview,cansearch=$cansearch,canemail=$canemail,canpostnew=$canpostnew,canmove=$canmove,canopenclose=$canopenclose,candeletethread=$candeletethread,canreplyown=$canreplyown,canreplyothers=$canreplyothers,canviewothers=$canviewothers,caneditpost=$caneditpost,candeletepost=$candeletepost,canusepm=$canusepm,canpostpoll=$canpostpoll,canvote=$canvote,canpostattachment=$canpostattachment,ismoderator=$ismoderator,canpublicedit=$canpublicedit,canpublicevent=$canpublicevent,canthreadrate=$canthreadrate,cantrackpm=$cantrackpm,candenypmreceipts=$candenypmreceipts,maxbuddypm=$maxbuddypm,maxforwardpm=$maxforwardpm,canwhosonline=$canwhosonline,canwhosonlineip=$canwhosonlineip WHERE usergroupid=$usergroupid"); */
          // Stars Hack Code
            
          $DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',starlevel='$starlevel',starimg='$starimg',cancontrolpanel=$cancontrolpanel,canmodifyprofile=$canmodifyprofile,canviewmembers=$canviewmembers,canview=$canview,cansearch=$cansearch,canemail=$canemail,canpostnew=$canpostnew,canmove=$canmove,canopenclose=$canopenclose,candeletethread=$candeletethread,canreplyown=$canreplyown,canreplyothers=$canreplyothers,canviewothers=$canviewothers,caneditpost=$caneditpost,candeletepost=$candeletepost,canusepm=$canusepm,canpostpoll=$canpostpoll,canvote=$canvote,canpostattachment=$canpostattachment,ismoderator=$ismoderator,canpublicedit=$canpublicedit,canpublicevent=$canpublicevent,canthreadrate=$canthreadrate,cantrackpm=$cantrackpm,candenypmreceipts=$candenypmreceipts,maxbuddypm=$maxbuddypm,maxforwardpm=$maxforwardpm,canwhosonline=$canwhosonline,canwhosonlineip=$canwhosonlineip WHERE usergroupid=$usergroupid");
          // Stars Hack End 
          Simply delete or comment out the line above it:

          PHP Code:
          $DB_site->query("UPDATE usergroup SET title='".addslashes($title)."',usertitle='".addslashes($usertitle)."',cancontrolpanel=$cancontrolpanel,canmodifyprofile=$canmodifyprofile,canviewmembers=$canviewmembers,canview=$canview,cansearch=$cansearch,canemail=$canemail,canpostnew=$canpostnew,canmove=$canmove,canopenclose=$canopenclose,candeletethread=$candeletethread,canreplyown=$canreplyown,canreplyothers=$canreplyothers,canviewothers=$canviewothers,caneditpost=$caneditpost,candeletepost=$candeletepost,canusepm=$canusepm,canpostpoll=$canpostpoll,canvote=$canvote,canpostattachment=$canpostattachment,ismoderator=$ismoderator,canpublicedit=$canpublicedit,canpublicevent=$canpublicevent,canthreadrate=$canthreadrate,cantrackpm=$cantrackpm,candenypmreceipts=$candenypmreceipts,maxbuddypm=$maxbuddypm,maxforwardpm=$maxforwardpm,canwhosonline=$canwhosonline,canwhosonlineip=$canwhosonlineip WHERE usergroupid=$usergroupid"); 
          IF the line "above it" that I mentioned is not there, you're o.k. and it should work fine.
          vB Drupal Community Plumbing | vB Survey | vBusy | vB Spell | vBouncer

          Comment


          • I haven o clue what you mean. But now when people join it doesn't make dups but after they register it says error and refresh to them, then it says member name already in use. How can I fix this and what might the problem be.
            http://www.tchracing.com/forums/live...h_live_sig.jpg

            Comment


            • Originally posted by LuBi
              I haven o clue what you mean. But now when people join it doesn't make dups but after they register it says error and refresh to them, then it says member name already in use. How can I fix this and what might the problem be.
              You cannot find the dups through vb, you only see it in the user table through mysql or phpmysql. And yes, your symptoms are exactly like mine before I corrected the installation as indicated above.

              If you have no clue what I mean or the fixes that have been listed, I strongly recommend you un-install this hack, and bring the file back as they were before. There's no point adding bells and whistles, with the forum screwd up
              vB Drupal Community Plumbing | vB Survey | vBusy | vB Spell | vBouncer

              Comment


              • I am having the same problems with this hack also...

                The register page says there is an error in the database and then I hit refresh and it says someone has already registered with this address. Its in the database but not in VB?!?

                The usergroup page parse's out on me. I have checked all settings a thousand times and everything is as stated throughout these post and the installation file...

                Comment


                • Here is a copy of the email I get:

                  Database error in vBulletin: Invalid SQL: INSERT INTO userfield (userid,field1,field2,field3,field4) VALUES (,'','','','') mysql error: You have an error in your SQL syntax near ''','','','')' at line 1 mysql error number: 1064
                  Date: Saturday 08th of September 2001 07:57:20 PM
                  Script: /forums/register.php

                  Comment


                  • I get that same error, how can we fix this?
                    http://www.tchracing.com/forums/live...h_live_sig.jpg

                    Comment


                    • Considering nowhere in my instructions do I have you do anything with anything relating to userfield, that has nothing to do with my hack...

                      Comment


                      • I was thinking the same thing to but what do you think is wrong with it? Also, whats with the usergroup.php parsing out on line 240 something or another...

                        Comment


                        • I have no hack in the register page btw, so cant seem to figure it out, works before I put this hack ... hmm

                          Comment


                          • T-Dogg, cool hack as usual, but I have a few problemos.

                            When installing, it says there are (4) changes to be made to the postbit template, yet there is only one change documented. I think this is just a minor type in the file.

                            Also, I have run through the install process. The stars show up great!

                            But......, something happened during the install and now I have lost all of the "profile" link buttons which appear under each post.

                            Any ideas?
                            Last edited by VAN; Sun 9 Sep '01, 9:30pm.

                            Comment


                            • Well I tried the update with no luck. Such a simple thing and it didn't work. I don't know PHP very much more of a script kiddie but, it must be getting an error because of somewhere else in the script. Maybe it doubles like that somewhere else I'll do my best to look but I can't make any promises.

                              Below is the error message I keep getting sent. I installed the script as informed from before now I have used the update.txt and this is the error I get. Also again when members sign up they get an error then refresh and it says that user name is already taken. It no loger doubles in mySQL but I get in error instead. Someone please help me this is causing a lot of trouble.

                              Database error in vBulletin: Invalid SQL: INSERT INTO userfield (userid,field5,field4,field3,field2) VALUES (,'','','','')
                              mysql error: You have an error in your SQL syntax near ''','','','')' at line 1
                              mysql error number: 1064
                              Date: Monday 10th of September 2001 06:00:07 PM
                              Script: /register.php
                              Referer: http://forums.suprascene.com/register.php
                              http://www.tchracing.com/forums/live...h_live_sig.jpg

                              Comment


                              • help me
                                http://www.tchracing.com/forums/live...h_live_sig.jpg

                                Comment

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