php help

Any problem with PHP can be disscused here
UNDERCOVER
Posts: 115
Joined: Tue Apr 05, 2005 1:02 pm

php help

Post by UNDERCOVER »

Database error: Invalid SQL: SELECT password,perms,rooms,invisible FROM c_reg_users WHERE username='test' LIMIT 1
MySQL error: 1054 (Unknown column 'invisible' in 'field list')
Session halted. help wtf do i do


phoxchange
Posts: 124
Joined: Wed Mar 02, 2005 10:22 am
Contact:

Post by phoxchange »

ok first go in mysql and **** go where says make new w/e and type invisible and save and do same in c_users
Image
RuneScape: Phoxey
Lixas
Posts: 750
Joined: Wed Feb 16, 2005 4:21 pm

Post by Lixas »

question:
What kind of query do you use??
And what for that "invisible" is used
Maybe not everything ok with your sql structure ??

these is just my opinion, i'm not super good at sql :wink:
Image
securitylab
Posts: 4
Joined: Mon Apr 11, 2005 5:39 pm

Post by securitylab »

Good morning, yes you should create additional column called invisible and perhaps increase LIMIT
totaled*eclipse
Posts: 7
Joined: Thu Apr 14, 2005 2:31 am

Post by totaled*eclipse »

thanks guys i was also having the same problem thanks for the tips:)
totaled*eclipse
Posts: 7
Joined: Thu Apr 14, 2005 2:31 am

Post by totaled*eclipse »

does anyone know how to make and add commands to chat like in the files it says u have the commands but when u go to use them in your chat u t=geth teh invailed command pop-up
fastracers
Posts: 44
Joined: Wed Apr 13, 2005 4:42 am

Post by fastracers »

To edit commands in php chats go into lib folder then into commands and edit the text in there
phoxchange
Posts: 124
Joined: Wed Mar 02, 2005 10:22 am
Contact:

Post by phoxchange »

Its more complicated then that u have to add the command files in the command thingy folder then add the type command like /.... to the command.lib.php3. I think iono been a while since tried to edit

This post was edit by moderator (Lixas). All post in caps are not allowed here
UNDERCOVER
Posts: 115
Joined: Tue Apr 05, 2005 1:02 pm

Post by UNDERCOVER »

dont for get to make it int
UNDERCOVER
Posts: 115
Joined: Tue Apr 05, 2005 1:02 pm

Post by UNDERCOVER »

money u just cant edit them files with our understaning php as one mistake can miss up the hole file
Post Reply