1 - Add to database-Table user, field named: country
( country varchar(2) NOT NULL )

Before I screw up my database

should the part I insert into "Run SQL query/queries on database" textbox in phpmyadin is

Table user, field named: country
( country varchar(2) NOT NULL )

or do I use the

- Add to database-Table user, field named: country
( country varchar(2) NOT NULL )

when I insert it.

Thanks for the help!

In phpMyAdmin, you can run this query:

ALTER TABLE user ADD country CHAR (2) not null

4 mins on that reply.. not bad
:)

Parse error: parse error in /home/dlrarmy/public_html/forums/register.php on line 93

That was probably my fault... I don't know. I thought I did it right.


Anyways besides in register.php I have the hack installed and it looks really good!



http://www.dlrarmy.com/images/vb.gif

I wonder if the parse error was because of my stars hack?

Looks good Sarge! Got a few hacks installed do ya :). For your register error, make sure your register.php looks like this around the line 90's (I put in some code above and below the hack):

Just make sure you put the eval line for the country hack in the right place.

<!-- Database error in vBulletin: Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,country) VALUES (NULL,'Kinta Kunte','eeeeee','e@blackman.com','','0','http://www.dlrarmy.com','','','','','1','1','0','Recruit' ,'999421680','1','-1','999421680','999421680','3','0','1','1','1','15 ','1966-3-4','-1','1','209.244.79.18','1','0','1','','','pg')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Sunday 02nd of September 2001 05:08:00 AM
Script: /forums/register.php
Referer: http://www.dlrarmy.com/forums/register.php

I changed it and this is what I got..

Want me to send you the register file so you can look it over? I know this has to do because I have hacked the sheettz out of my forums.

My users are digging this hack by the way
Thanks
Sarge

Just read what the error is telling you... field mismatch - means either there are too many column names, or too many values. After matching them up, you have too many values trying to be inserted into the database.

It looks like you have the stars hack installed because the extra spaces are the ,'','', below from the error message:

'1','','','pg')

If you have the stars hack installed, make sure on the $DB_site->query line just before VALUES you have the following:

nosessionhash,starlevel,starimg,country)

Currently you only have:

nosessionhash,country)

If you don't get what I mean let me know.

nice hack

I just emailed you bro.
Thnks for doing this hack i have been waiting a long time for this
Thanks
Sarge