Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Share Posted July 18, 2012 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? Quote Link to comment Share on other sites More sharing options...
Emistry Posted July 18, 2012 Group: Forum Moderator Topic Count: 93 Topics Per Day: 0.02 Content Count: 10015 Reputation: 2348 Joined: 10/28/11 Last Seen: 8 hours ago Share Posted July 18, 2012 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... Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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? Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 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 Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 I tried doing the SQL DB, but I'm still recieving the error D: Did you make sure to restart the server? o_O Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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.. Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 Your image is damaged for me =/ Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 Your image is damaged for me =/ http://s14.postimage.org/8rww3t4cv/SQL_DB.jpg Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 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. Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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! Quote Link to comment Share on other sites More sharing options...
Mystery Posted July 18, 2012 Group: Members Topic Count: 94 Topics Per Day: 0.02 Content Count: 2192 Reputation: 252 Joined: 11/11/11 Last Seen: June 24, 2020 Share Posted July 18, 2012 Everything good? xD Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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 Quote Link to comment Share on other sites More sharing options...
Wise Posted July 18, 2012 Group: Members Topic Count: 46 Topics Per Day: 0.01 Content Count: 147 Reputation: 26 Joined: 11/19/11 Last Seen: October 28, 2021 Share Posted July 18, 2012 Maybe sprite error ;o or somewhere in accessoryid.lua/accname.lua Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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. Quote Link to comment Share on other sites More sharing options...
Wise Posted July 18, 2012 Group: Members Topic Count: 46 Topics Per Day: 0.01 Content Count: 147 Reputation: 26 Joined: 11/19/11 Last Seen: October 28, 2021 Share Posted July 18, 2012 how about visionary_tab, idnum2resnametable? Quote Link to comment Share on other sites More sharing options...
starkBastard Posted July 18, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 07/16/12 Last Seen: January 18, 2013 Share Posted July 18, 2012 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? Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 Go to MySQL, add another row into the login db then add 2000000, username, password, sex, email, 0-99(GM). Quote Link to comment Share on other sites More sharing options...
starkBastard Posted July 18, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 07/16/12 Last Seen: January 18, 2013 Share Posted July 18, 2012 thanks! is it the GM account? Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 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 1 Quote Link to comment Share on other sites More sharing options...
starkBastard Posted July 18, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 07/16/12 Last Seen: January 18, 2013 Share Posted July 18, 2012 ok ,how bout state for standard account? Quote Link to comment Share on other sites More sharing options...
Kurby Posted July 18, 2012 Group: Members Topic Count: 37 Topics Per Day: 0.01 Content Count: 113 Reputation: 1 Joined: 07/15/12 Last Seen: January 5, 2013 Author Share Posted July 18, 2012 ok ,how bout state for standard account? Normal account is 0? Quote Link to comment Share on other sites More sharing options...
starkBastard Posted July 19, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 07/16/12 Last Seen: January 18, 2013 Share Posted July 19, 2012 ive try change it to 99 ...but i got this error when i try to log in with that "99" account ERROR 98 Quote Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
27 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.