vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Stars for vB2.2.1 (english/german) (https://vborg.vbsupport.ru/showthread.php?t=34626)

Radon3k 04-14-2002 02:20 PM

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

Highlander 05-16-2002 06:47 AM

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 05-16-2002 06:58 AM

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 05-16-2002 10:48 AM

Wolf42-

Excellent! Installed without a problem. :)

Webmasta XT 05-29-2002 01:30 AM

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 05-29-2002 05:09 AM

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 05-29-2002 10:41 AM

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

Wolf42 05-29-2002 11:12 AM

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 05-29-2002 06:33 PM

contact me on AIM plz!!

Webmasta XT 05-29-2002 06:40 PM

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...


All times are GMT. The time now is 07:31 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01421 seconds
  • Memory Usage 1,771KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_php_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete