Jump to content
MakeWebGames

MYSQL to give pics to User_level 0 how ???


Recommended Posts

Posted

i want to set all my NPCS so they all have the same IMAGE picture i have the images

in the USERS table but how do i make it so the NPCS get the same image without having to do it manually via the phpmyadmin.

i was thinking something like

UPDATE user_level=0 FROM users WHERE attpics='default.jpg'

but that doesnt seem to work at the moment all the NPCS images for the attpics table is empty.

Posted

Re: MYSQL to give pics to User_level 0 how ???

 

update users set attpics = 'default.jpg' where user_level = 0

Cheeers Deception your a life saver this has been driving me mental :)

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...