TBDev Forum
Programming board
Main Page Forum Rules Privacy Policy Members Contact Us
Welcome Guest (Login | Register)
TBDev Forum TBDev.net - Help General Support Insert to 'users'

Insert to 'users'

2007-03-10 09:02:00
Group: Member
Posts: 48
Topics participated: 29
Topics started: 24
First post: 2006-12-24 17:09:00
Last post: 2007-03-15 07:42:00
I'm trying to install the invite system, but now I'm REALLY FUCKED.
Then we need to add another 2 fields into the users database:
 
2007-03-10 09:41:00
Group: Member
Posts: 157
Topics participated: 70
Topics started: 22
First post: 2006-12-31 17:46:00
Last post: 2007-09-10 15:11:00
add it manualy.. create 2 new colums and add it
 
2007-03-10 10:11:00
Group: Member
Posts: 48
Topics participated: 29
Topics started: 24
First post: 2006-12-24 17:09:00
Last post: 2007-03-15 07:42:00
That's what I'm trying to do, but where?
Can't find it...




And can't be here...


:(
 
2007-03-10 10:59:00
Group: Member
Posts: 1462
Topics participated: 667
Topics started: 22
First post: 2006-02-25 13:08:00
Last post: 2008-12-29 14:13:00
SQL
ALTER TABLE users ADD `invites` int(10) NOT NULL default '4';
ALTER TABLE users ADD `invited_by` int(10) NOT NULL default '0';


just run that on db
 
2007-03-10 11:40:00
Group: Member
Posts: 48
Topics participated: 29
Topics started: 24
First post: 2006-12-24 17:09:00
Last post: 2007-03-15 07:42:00
Thnx, but still errors:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE users ADD `invited_by` int(10) NOT NULL default '0',' at line 2

:(
 
2007-03-10 11:54:00
Group: Member
Posts: 1462
Topics participated: 667
Topics started: 22
First post: 2006-02-25 13:08:00
Last post: 2008-12-29 14:13:00
try it again, just edited it
 
2007-03-10 00:21:00
Group: Member
Posts: 48
Topics participated: 29
Topics started: 24
First post: 2006-12-24 17:09:00
Last post: 2007-03-15 07:42:00
Thank you!
Now it's only these errors left:
arning: set_time_limit(): Cannot set time limit in safe mode in /home/***/include/cleanup.php on line 9

And
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/***/include/cleanup.php on line 150

...And this:
You have a solution for that?

Thank you :D
 

Similar threads

Topic Posts Last post
Help insert image 2 2007-05-08 11:12:00
Need an Insert Query 7 2008-10-21 12:23:00
Can somebody pls insert that code 5 2008-03-30 14:01:00
Auto Insert Tracker ID 4 2008-08-31 03:57:00
How to insert a layout to a tracker? 4 2007-02-20 13:08:00