The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 01-29-2002

Update 03/26/2002: Changed one DB_site->quere in usergroup.php to make it fit to vB 2.2.4. If the hack is still running no update is needed.

Update v. 26.03.2002: Habe eine kleine ?nderung in einer DB_site-quere der usergroup.php gemacht, die sich im vB 2.2.4 ge?ndert hat. Sollte der Hack nach wie vor funktionieren ist kein Update notwendig.

This is not a new hack only a modification for tubedogg's Stars v0.2.3 to run on vB 2.2.1.

I got it run on my board, but most of the Users with this version got troubles.

I did the mods on the original vb-scripts, if you have any hacks installed (who not

) be carefull!

Das ist kein "neuer" Hack sondern nur eine Modifikation von tubedogg's Stars v0.2.3 Version damit er auf einem vB 2.2.1 l?uft.

Bei mir funzt er ganz gut, aber sichtlich hatten einige Benutzer Probleme ihn auf dieser Version zum laufen zu bringen.

Bei den ?nderungen beziehe ich mich immer auf die Originalscripte, solltet ihr diese schon ver?ndert habe heisst es: Schau genau!!

There is a german and an (I hope) english instruction.

Es gibt eine deutsch und eine (hoffentlich) englische Anleitung.

Crunch · #82 06-11-2002, 09:44 AM

NEWTHREAD:

Update user stuff:

PHP Code:


			
// update user stuff

      $dotitle="";

      if ($bbuserinfo[userid]!=0)

      {

if ($foruminfo[countposts]) {

          $usergstars=$DB_site->query_first("SELECT starlevel,starimg FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

          if ($usergstars[starlevel]=="") {

            $getstars=$DB_site->query_first("SELECT starlevel,starimg FROM stars WHERE minposts<=$bbuserinfo[posts]+1 ORDER BY minposts DESC LIMIT 1");

            $userstarlvl=$getstars[starlevel];

            $userstarimg=$getstars[starimg];

          } else {

            $userstarlvl=$usergstars[starlevel];

            $userstarimg=$usergstars[starimg];

          }

          $dostars=",starlevel='$userstarlvl',starimg='$userstarimg'";

        }

        if ($bbuserinfo[customtitle]==0 && $foruminfo[countposts])

        {

          $usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

          if ($usergroup[usertitle]=="") {

            $gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=$bbuserinfo[posts]".iif ($foruminfo['countposts'],"+1","")." ORDER BY minposts DESC LIMIT 1");

            $usertitle=$gettitle[title];

          } else {

            $usertitle=$usergroup[usertitle];

          }

          $dotitle="usertitle='".addslashes($usertitle)."',";

        }



$DB_site->query("UPDATE user SET

          ".iif ($foruminfo[countposts],"posts=posts+1,","")."

          $dotitle"."lastpost='".time()."',away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");

      }

Email moderator stuff:

PHP Code:


			
// send email to moderators

      if ($enableemail) {

        $moderators=$DB_site->query_first("SELECT CONCAT(newthreademail,' ',newpostemail) AS newthreademail FROM forum WHERE forumid='$forumid'");



        $modtable=$DB_site->query("SELECT DISTINCT user.email FROM moderator,user WHERE moderator.userid=user.userid AND forumid IN ($foruminfo[parentlist]) AND (newthreademail=1 OR newpostemail=1)");

        while($thismod=$DB_site->fetch_array($modtable)) {

          $moderators['newthreademail'].=" $thismod[email]";

        }



        if ($moderators['newthreademail']!="") {

          $mods=explode(" ",trim($moderators['newthreademail']));

          while (list($key,$val)=each($mods)) {



            if (trim($val)!="") {

              $toemail=$val;

              $forumtitle = $foruminfo['title'];

              $threadinfo['title'] = $subject;



              eval("\$emailmsg = \"".gettemplate("email_moderator",1,0)."\";");

              eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");

              mail($toemail,$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");

            }

          }

        }

      }



      // redirect

      if ($postpoll) {

        $goto="poll.php?s=$session[sessionhash]&threadid=$threadid&polloptions=".intval($polloptions);

      } elseif ($visible) {

        $goto="showthread.php?s=$session[sessionhash]&threadid=$threadid";

      } else {

        $goto="forumdisplay.php?s=$session[sessionhash]&forumid=$forumid";

      }

      eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");");

    }

  }

}

NEWREPLY:

update user stuff:

PHP Code:


			
// update user stuff

      $dotitle="";

      if ($bbuserinfo[userid]!=0)

      {

if ($foruminfo[countposts]) {

          $usergstars=$DB_site->query_first("SELECT starlevel,starimg FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

          if ($usergstars[starlevel]=="") {

            $getstars=$DB_site->query_first("SELECT starlevel,starimg FROM stars WHERE minposts<=$bbuserinfo[posts]+1 ORDER BY minposts DESC LIMIT 1");

            $userstarlvl=$getstars[starlevel];

            $userstarimg=$getstars[starimg];

          } else {

            $userstarlvl=$usergstars[starlevel];

            $userstarimg=$usergstars[starimg];

          }

          $dostars=",starlevel='$userstarlvl',starimg='$userstarimg'";

        }

        if ($bbuserinfo[customtitle]==0 && $foruminfo[countposts])

        {

          $usergroup=$DB_site->query_first("SELECT usertitle FROM usergroup WHERE usergroupid='$bbuserinfo[usergroupid]'");

          if ($usergroup[usertitle]=="") {

            $gettitle=$DB_site->query_first("SELECT title FROM usertitle WHERE minposts<=$bbuserinfo[posts]".iif ($foruminfo['countposts'],"+1","")." ORDER BY minposts DESC LIMIT 1");

            $usertitle=$gettitle[title];

          } else {

            $usertitle=$usergroup[usertitle];

          }

          $dotitle="usertitle='".addslashes($usertitle)."',";

        }



$DB_site->query("UPDATE user SET

          ".iif ($foruminfo[countposts],"posts=posts+1,","")."

          $dotitle"."lastpost='".time()."',away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");



      }

email moderator stuff:

PHP Code:


			
 // send email to moderators

      if ($enableemail) {

        $moderators=$DB_site->query_first("SELECT newpostemail FROM forum WHERE forumid='$threadinfo[forumid]'");



        $mods=$DB_site->query("SELECT DISTINCT user.email FROM moderator LEFT JOIN user USING (userid) WHERE moderator.forumid IN ($foruminfo[parentlist]) AND moderator.newpostemail=1");

        while ($mod=$DB_site->fetch_array($mods)) {

          $moderators[newpostemail].=' '.$mod[email];

        }

        $moderators[newpostemail]=trim($moderators[newpostemail]);



        if ($moderators[newpostemail]!="") {

          $bbuserinfo['username']=unhtmlspecialchars($bbuserinfo['username']); //for emails

          $mods=explode(" ",$moderators[newpostemail]);

          while (list($key,$val)=each($mods)) {

            if (trim($val)!="") {

              $subject=$threadtitle;

              $toemail=$val;



              eval("\$emailmsg = \"".gettemplate("email_moderator",1,0)."\";");

              eval("\$emailsubject = \"".gettemplate("emailsubject_moderator",1,0)."\";");



              mail($toemail,$emailsubject,$emailmsg,"From: \"$bbtitle Mailer\" <$webmasteremail>");

            }

          }

          $bbuserinfo['username']=htmlspecialchars($bbuserinfo['username']); //back to norm

        }

      }



      // redirect

      if ($visible) {

        $goto="showthread.php?s=$session[sessionhash]&postid=$postid#post$postid";

      } else {

        $goto="forumdisplay.php?s=$session[sessionhash]&forumid=$threadinfo[forumid]";

      }

      eval("standardredirect(\"".gettemplate("redirect_postthanks")."\",\"$goto\");");

    }

  }

}

Wolf42 · #83 06-11-2002, 09:55 AM

Look at the query above // send email to moderators (in both files), it must look like these:

PHP Code:


			
          $DB_site->query("UPDATE user SET

          ".iif ($foruminfo[countposts],"posts=posts+1,","")."

          $dotitle"."lastpost='".time()."'$dostars,away=0,awaydate='',awayreason='',returndate='' WHERE userid='$bbuserinfo[userid]'");

You forgot the $dostars in the query, I think you deleted that by building in the "Away-Hack"!

Crunch · #84 06-11-2002, 10:04 AM

ok i added that but those were in the update user stuff, and now no stars appear for normal members at all when i updated counters!

Crunch · #85 06-11-2002, 10:06 AM

NM it for some reason deleted all my star settings. gah oh well let me test it for a sec.

Crunch · #86 06-11-2002, 10:08 AM

YES! thanks ya wolf guy. i know i did something wrong cause it was working before i went on another hack spree. thanks again

Wolf42 · #87 06-11-2002, 10:14 AM

Pleased that I could helped you!

Webmasta XT · #88 06-30-2002, 11:12 PM

is there a way users can have custom stars?? =P

Wolf42 · #89 07-01-2002, 05:07 AM

Quote:

Originally posted by Webmasta XT
is there a way users can have custom stars?? =P

You can set custom stars to each usergroup but not to each user.

But you give each user his own usergroup

(just joking).

Webmasta XT · #90 07-04-2002, 02:08 PM

so there is no way? what I am talking about is.. we can specify what amount of stars a member can have, not all members, just the few that wanted to have low stars and stuff, and we wanted to give the admins the highest stars, is it possible?

Chris M · #91 07-04-2002, 02:14 PM

Does this work with 2.2.6?

Satan

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04848 seconds Memory Usage 2,387KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (5)bbcode_php (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!