Stars for vB2.2.1 (english/german)

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.

[Radon3k]

Hey Wolf, this works just fine on 2.2.5 and I didn't have to edit out that line! Thanks!

[Highlander]

Hi there..i cannot find this query in the Admin/misc.php

maketableheader("Update Users Info</b> - </b>updates user titles<b>","",0);

it is not given for any reason in the misc.php...i also control all other misc.php`s in the directories...but really i did nothing wrong the only query here is shown is this one:

maketableheader("Update User's Titles","",0);

maybe you mean this ??

if someone gots the vbportal..please call me @ ICQ i got a porblem to get in the administration
my ICQ: 148041353

[Wolf42]

The line is in admin/misc.php at 330 (vb2.2.5)! And that is the one you "could" change, you must not. Just a notice.

[Smoothie]

Wolf42-

Excellent! Installed without a problem.

[Webmasta XT]

ok, when new users try to join my forumz, they get an error about the database, and I get this e-mail...

can someone help me plz???

[PHP]
Database error in vBulletin 2.2.5:

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,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,starlevel,stari mg)
VALUES
(NULL,'Ace','king','Calebmoore@hotmail.com','1','' ,'0','http://','','','','','0','0','1','n00b','1022669217','1', '-1','1022669217','1022669217','2','0','1','1','0',' 15','1986-6-4','-1','2','209.68.64.69','0','0','1','','','0','0')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Wednesday 29th of May 2002 03:46:57 AM
Script: http://www.xtreme-forumz.net/register.php
Referer: http://www.xtreme-forumz.net/register.php
[/PHP}

[Wolf42]

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,avatarid,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($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','$avatarid','$userstarlvl','$userstarimg')"); 


The line in the user.php must look like this. Please check. Your line looks like vB 2.0.3 couse something is missing (avatarid, and password in plain, but should be encrypted).

[Webmasta XT]

sry, that didn't help, there is some problem in register.php and my vb is 2.2.5

[Wolf42]

Which version of Stars have you installed on your vB? Tubedoggs (for 2.0.3) or my Rehack?

Sorry, in register.php the code should be:

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,avatarid,starlevel,starimg) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($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','$avatarid','$userstarlvl','$userstarimg')"); 


Think its the same code as in user.php (did this some time ago). If you download my instructions it should work.

[Webmasta XT]

contact me on AIM plz!!

[Webmasta XT]

can you explain how can I have two different kind of stars on two different styles?? plz, cuz I need the color mtach kind of thing, so I have made seprate stars for each style, I was wondering if its possible to do that...