Added item, now error

[Kurby]

I tried implementing a new item, I spawned the item. It showed as apple. I tried wearing it, now I can't log into my account?

Anyone know how I can delete the account and characters without logging in or fixing the error?

[Emistry]

remove the item from item_db ...

but you will get spammed with dummy error if you still didnt remove the exist item in your char..

or better way login your SQL database..and delete it...

[Mystery]

You're better off logging into your SQL tables and deleting the item from your DB and item attached to every char's inventory/storage that has it. OR if you have a FLUXCP, do everything through there.

Edited July 18, 2012 by Mysterious

[Kurby]

remove the item from item_db ...

but you will get spammed with dummy error if you still didnt remove the exist item in your char..

or better way login your SQL database..and delete it...

You're better off logging into your SQL tables and deleting the item from your DB and item attached to every char's inventory/storage that has it. OR if you have a FLUXCP, do everything through there.

Thank you!

Well, I tried deleting from "inventory" section of the SQL db, but I'm still getting errors?

[Mystery]

Thank you!

Well, I tried deleting from "inventory" section of the SQL db, but I'm still getting errors?

Using FLUXCP, reset your character's "Look" or manually do it in your character table, look for your char, and look for the columns of the headgear section and input 0.

Edited July 18, 2012 by Mysterious

[Kurby]

Thank you!

Well, I tried deleting from "inventory" section of the SQL db, but I'm still getting errors?

Using FLUXCP, reset your character's "Look" or manually do it in your character table, look for your char, and look for the columns of the headgear section and input 0.

I don't have FLUXCP, can I still do this if I get it now?

I don't think I have it anyway, not sure

Edited July 18, 2012 by Kurby

[Mystery]

Thank you!

Well, I tried deleting from "inventory" section of the SQL db, but I'm still getting errors?

Using FLUXCP, reset your character's "Look" or manually do it in your character table, look for your char, and look for the columns of the headgear section and input 0.

I don't have FLUXCP, can I still do this if I get it now?

I don't think I have it anyway, not sure

You can do it any way you like lol. With Flux, you're gonna be resetting all your char's Dyes, Item equipped, etc. while just doing it in your SQL DB, you'll just be aiming for the equipment attached. ;3

[Kurby]

Thank you!

Well, I tried deleting from "inventory" section of the SQL db, but I'm still getting errors?

Using FLUXCP, reset your character's "Look" or manually do it in your character table, look for your char, and look for the columns of the headgear section and input 0.

I don't have FLUXCP, can I still do this if I get it now?

I don't think I have it anyway, not sure

You can do it any way you like lol. With Flux, you're gonna be resetting all your char's Dyes, Item equipped, etc. while just doing it in your SQL DB, you'll just be aiming for the equipment attached. ;3

I tried doing the SQL DB, but I'm still receiving the error D:

Edited July 18, 2012 by Kurby

[Mystery]

I tried doing the SQL DB, but I'm still recieving the error D:

Did you make sure to restart the server? o_O

[Kurby]

I tried doing the SQL DB, but I'm still recieving the error D:

Did you make sure to restart the server? o_O

I recompiled just incase and restarted the server.. Lol

My SQL DB looks like this..

Is there anyway to delete my account? I don't think I can get back on it..

[Mystery]

Your image is damaged for me =/

[Kurby]

Your image is damaged for me =/

http://s14.postimage.org/8rww3t4cv/SQL_DB.jpg

[Mystery]

You wanna look for these:

`head_top` smallint(6) unsigned NOT NULL default '0',
 `head_mid` smallint(6) unsigned NOT NULL default '0',
 `head_bottom` smallint(6) unsigned NOT NULL default '0',

head_top, head_mid, and head_bottom in your char SQL Table and change the value to 0.

[Kurby]

You wanna look for these:

`head_top` smallint(6) unsigned NOT NULL default '0',
 `head_mid` smallint(6) unsigned NOT NULL default '0',
 `head_bottom` smallint(6) unsigned NOT NULL default '0',

head_top, head_mid, and head_bottom in your char SQL Table and change the value to 0.

You wanna look for these:

`head_top` smallint(6) unsigned NOT NULL default '0',
 `head_mid` smallint(6) unsigned NOT NULL default '0',
 `head_bottom` smallint(6) unsigned NOT NULL default '0',

head_top, head_mid, and head_bottom in your char SQL Table and change the value to 0.

Thank you!

[Mystery]

Everything good? xD

[Kurby]

Should've posted here, instead of new post.. Damn

Everything good? xD

Do you by any chance know why I'm not allowed to wear the item? It shows the item, and name correctly, but I still get an error when I wear it

[Wise]

Maybe sprite error ;o or somewhere in accessoryid.lua/accname.lua

[Kurby]

Maybe sprite error ;o or somewhere in accessoryid.lua/accname.lua

I think they're both fine, I'm not sure.. It's only when I click on it or try putting it on. I can view description though.

[Wise]

how about visionary_tab, idnum2resnametable?

[starkBastard]

PLZ HELP

what is the password used to log in to the client? how can I edit them??

its the login password after choosing server . is it the same as mySQL password??

my server is working fine and ive start the game to log in to character. but idk the password....

do i need to create an account first?

[Kurby]

Go to MySQL, add another row into the login db then add

2000000, username, password, sex, email, 0-99(GM).

[starkBastard]

thanks! is it the GM account?

[Kurby]

thanks! is it the GM account?

If you put the state to 99, it's a GM account. To show GM sprite and add show yellow text/name to others, you have to add your ID to clientinfo folder

[starkBastard]

ok ,how bout state for standard account?

[Kurby]

ok ,how bout state for standard account?

Normal account is 0?

[starkBastard]

ive try change it to 99 ...but i got this error when i try to log in with that "99" account

ERROR 98