Help! Rankin the problem of Char and Clan

Results 1 to 13 of 13
  1. #1
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Help! Rankin the problem of Char and Clan

    I would like to help a someone. is very important to me the information I need. Recently I changed my dedicated server, because I had with a pentium 4 with 2 gigs of ram with 32-bit processor. And now I migrated the server to a 64-bit processor Core2Quad Q9650 8 gigs of ram. everything worked normally on migration, except for one thing, the ranking of char and ranking clan that does not appear, or in other old server worked perfectly so much that I had in my site's ranking for the players having access to his time game, time Weekly and other more. Now the new dedicated server icon appear over the names of the char and the clans are not only " " in place of names. Apparently not contained errors in the database, everything works perfectly with the exception of the names of char and clan. I really need help from someone please. I want to name appears among the " " thank you.


  2. #2
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    I will add information to see if someone finds my problem. forgot to mention that I use mysql. I put the link in my page ranking to verify the name of the character who appears so "" ""
    If you can not post, please moderation can delete at will. sorry for my English and via google translator http://www.andromedapw.com/index.php?ranking

  3. #3
    ~<3 Camille <3~ KrimsonBlades is offline
    MemberRank
    Jan 2009 Join Date
    ValhallaLocation
    262Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by lukmussulin View Post
    I will add information to see if someone finds my problem. forgot to mention that I use mysql. I put the link in my page ranking to verify the name of the character who appears so "" ""
    If you can not post, please moderation can delete at will. sorry for my English and via google translator http://www.andromedapw.com/index.php?ranking
    I might be going out on a limb here, but I had that problem when I hosted my server for PW, How i fixed was adding my charater table in the ranking.php(on my webpage).So try checking all your .php and .conf files to see if you missed adding your dbo info pertaining to characters.The other thing you can check seeing as though you changed servers is the permissions in your mysql,sometimes i found that when i changed servers but used the same DB i had to change the permissions,sometimes on extreme cases dumping the sql's and reinstalling Mysql was the other way i had to do it
    Last edited by KrimsonBlades; 15-09-09 at 07:04 PM.

  4. #4
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by KrimsonBlades View Post
    I might be going out on a limb here, but I had that problem when I hosted my server for PW, How i fixed was adding my charater table in the ranking.php(on my webpage).So try checking all your .php and .conf files to see if you missed adding your dbo info pertaining to characters.The other thing you can check seeing as though you changed servers is the permissions in your mysql,sometimes i found that when i changed servers but used the same DB i had to change the permissions,sometimes on extreme cases dumping the sql's and reinstalling Mysql was the other way i had to do it
    actually the problem is not with mysql but with the server, because I checked the bank and also displays without the names of char, it only shows """". I wipe to see if it would be problem with the database but even with the new database has continued in the same way "" "" why I think that the problem could be with the server settings by having dedicated 64-bit processor. sorry my bad English

  5. #5
    ~<3 Camille <3~ KrimsonBlades is offline
    MemberRank
    Jan 2009 Join Date
    ValhallaLocation
    262Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by lukmussulin View Post
    actually the problem is not with mysql but with the server, because I checked the bank and also displays without the names of char, it only shows """". I wipe to see if it would be problem with the database but even with the new database has continued in the same way "" "" why I think that the problem could be with the server settings by having dedicated 64-bit processor. sorry my bad English
    did you check your ranking.php? did you change your password for mysql when you changed over?

  6. #6

    Re: Help! Rankin the problem of Char and Clan

    XD i dont know how it woks and im out of subject can i please have a ranking.php script XD and the table for mysql please please please XD

  7. #7
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    the php script and the database is ok!

    see what appears when I give the command. / gamedbd query 32


    Base:
    ID:32
    name: ←here should be the name of the char
    race:1
    occupation:3
    gender:1
    custom_data.size:172
    custom_stamp:0
    status:1
    delete_time:-
    create_time:Fri Jun 19 01:12:59 2009
    lastlogin_time:Wed Aug 12 15:27:53 2009
    forbid.size:0
    Status:
    level:999
    level2:22
    exp:7873364
    sp:6124306
    pp:0
    hp:2292
    mp:7476
    posx:1271.1
    posy:219.8
    posz:1037.3
    worldtag:1
    money:0
    invader_state:0
    invader_time:0
    pariah_time:0
    factionid:0
    factionrole:0
    reputation:200000
    custom_status.size:0
    filter_data.size:4
    charactermode.size:8
    ...

    it will be some font setting?
    Last edited by lukmussulin; 20-09-09 at 08:41 AM.

  8. #8
    ~<3 Camille <3~ KrimsonBlades is offline
    MemberRank
    Jan 2009 Join Date
    ValhallaLocation
    262Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by lukmussulin View Post
    the php script and the database is ok!

    see what appears when I give the command. / gamedbd query 32


    Base:
    ID:32
    name: ←here should be the name of the char
    race:1
    occupation:3
    gender:1
    custom_data.size:172
    custom_stamp:0
    status:1
    delete_time:-
    create_time:Fri Jun 19 01:12:59 2009
    lastlogin_time:Wed Aug 12 15:27:53 2009
    forbid.size:0
    Status:
    level:999
    level2:22
    exp:7873364
    sp:6124306
    pp:0
    hp:2292
    mp:7476
    posx:1271.1
    posy:219.8
    posz:1037.3
    worldtag:1
    money:0
    invader_state:0
    invader_time:0
    pariah_time:0
    factionid:0
    factionrole:0
    reputation:200000
    custom_status.size:0
    filter_data.size:4
    charactermode.size:8
    ...

    it will be some font setting?
    Oh man, it seems that your data got corrupted maybe? Does it show the name of the characters in the game? or does it do the "" as well.When you re-installed your dbo did you get any errors? And did you backup your db?
    Last edited by KrimsonBlades; 20-09-09 at 05:12 PM.

  9. #9
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by KrimsonBlades View Post
    Oh man, it seems that your data got corrupted maybe? Does it show the name of the characters in the game? or does it do the "" as well.When you re-installed your dbo did you get any errors? And did you backup your db?
    The names of the char in the game appear normal. already used other old backups is also still the same thing. on my test server I have here runs normal and the name of the char appear. only the new dedicated server that is just as "" "" I do not know what to do.

  10. #10
    ~<3 Camille <3~ KrimsonBlades is offline
    MemberRank
    Jan 2009 Join Date
    ValhallaLocation
    262Posts

    Re: Help! Rankin the problem of Char and Clan

    Hmmm...Makes me wonder, you said your old server was 32-bit and all the characters show up but when you transfered to a 64 bit no chars show up only "".Question..Is your test server 32-bit?

    Quote Originally Posted by lukmussulin View Post
    The names of the char in the game appear normal. already used other old backups is also still the same thing. on my test server I have here runs normal and the name of the char appear. only the new dedicated server that is just as "" "" I do not know what to do.

  11. #11
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by KrimsonBlades View Post
    Hmmm...Makes me wonder, you said your old server was 32-bit and all the characters show up but when you transfered to a 64 bit no chars show up only "".Question..Is your test server 32-bit?
    yes. the test is 32 bits. I considered also could be a problem with the debian source 5.

  12. #12
    ~<3 Camille <3~ KrimsonBlades is offline
    MemberRank
    Jan 2009 Join Date
    ValhallaLocation
    262Posts

    Re: Help! Rankin the problem of Char and Clan

    Very well could be, or it could be that your server is 64 bit,A few friends of mine had that issue too but fixed it from an update from Microsoft web site they didnt mention how they fixed it,but I would assume it was from that site. I don't use linux,I have never had that problem on my dedi.

    Quote Originally Posted by lukmussulin View Post
    yes. the test is 32 bits. I considered also could be a problem with the debian source 5.

  13. #13
    Apprentice lukmussulin is offline
    MemberRank
    Mar 2009 Join Date
    10Posts

    Re: Help! Rankin the problem of Char and Clan

    Quote Originally Posted by KrimsonBlades View Post
    Very well could be, or it could be that your server is 64 bit,A few friends of mine had that issue too but fixed it from an update from Microsoft web site they didnt mention how they fixed it,but I would assume it was from that site. I don't use linux,I have never had that problem on my dedi.
    Friend, sorry, sorry, forgot to add one very important information: When did the server migration made as follows: I uploaded all files, including the db, i changed the ip's and everything worked perfectly, except for the names char. but when I log in my serverlist not appear online server, but normally done in and I noticed that it happens to all players from the server. the login screen is the status of the server is as - conction speed and status, ie, as if you were off line. For me, I checked all the ip that should be changed, but not remember for sure what the ip which is responsible for the status on the login screen. I do not know if this may be influencing the problem into something of the names of char.



Advertisement