Fix Age 15 Connect Problem (Old and New Registered Players)

[Pinoyrealm]

Database Part

1. Run this script

Use MuOnline;
UPDATE dbo.MEMB_INFO SET sno__numb = '1111111111111'
WHERE sno__numb != '1111111111111'

or

Use MuOnline;
UPDATE dbo.MEMB_INFO SET sno__numb = '1111111111111'

Website Part

2. Put the attached files for Muweb 0.8 users, and for the other website users, make sure your personal ID code will always insert 1111111111111 to memb_info tables... if its not you may have problem, we have different website so just look on that field on your site and edit them.



ATTACHED FILES UPDATED

credits: MuForum.Info - for the script

[MentaL]

[drakelv]

whats the point of reposting

[Pinoyrealm]

whats the point of reposting

LOL the point is the guide you and others made will affect only on current people registered on your server, with this procedure you will not need to run again and again the script, this will default the value of the database and will make sure the there will be no problem when they registered... i saw your guide and it will work only if you are already registered, and i test your guide, but if somebody registered again they will have again the same problem and you need to run the query again...

Im sorry...

I dont need credits i want people to know the proper way... and you will call 100% fixed not temporary fixed

[isccarm]

Nice guide! thanks jumong i will test...

[Pinoyrealm]

youre welcome but it is much better if people will post if it works, so we will confirm the fixes

[drakelv]

i recommend not to delete sno numb but make in register script that it automaticly sets it 111111111111. it will cause less problems.

[Pinoyrealm]

i recommend not to delete sno numb but make in register script that it automaticly sets it 111111111111. it will cause less problems.

im not trying to sabotage your guide i made my guide with my own fixes, if you are jealus then make proper guide and put it in your own thread, its ok with me and its good you have also idea but you are not respecting me in my own thread, so just get off and be the best of what you are...

[drakelv]

im not jelaus xD i really dont care, i just adviced.

[bhudz30]

@Jumong

I did the 2nd part at SQL the 13 "1" thing ..... will that be forever ? or do i have to do the Webby too ?
coz as what you said the old same topic like this, i have to do it again and again.. its kinda good but little hard.

Thanks in advance

Off Topic :
I have problem in my BC .. the NPC say cannot enter more than 6 times a day to player can you help me with this
seems nothing response when i post at Help section

Thanks

Mabuhay ka pINOY

[Pinoyrealm]

I will update this guide later, i found better procedure that works 100% good (this guide is for newbie, if you know it already just fcked out, i dun need you here)

[grantz]

thanks..our server encounter this problem....nice guide kababayan

[3yeka]

Very Very Thanks for Script !!!

BG : mnoo blagodarq pi4 . Velik si ! :)

[ivo2296]

Website Part

3. On your website Registration page, remove personal id field, if you are using =Master= Muweb you remove them on modules/register.php and includes/character.class.php remove everything related to personal ID field

This guide work for those who migrated or have old players in database before changing files and have this problem after changing.

This guide will also work for new created account on web

i saw the script on one guide here but it will only work on people who already registered so i make this guide so that there will be no problem for old registered and newly registered players

i include fixed for muweb 0.8

credits: MuForum.Info - for the script

When i use attached files - web page gives:
Your Account Has Been Created SuccesFully!

but actually no account is registered in database




2. Open Enterprise Manager --> MuOnline(your db name where memb_info Located) --> Tables--> right click Memb_info-->design table--->sno__numb--> set default value to 1111111111111(13pcs of 1).----------> that also don't work

[Pinoyrealm]

Attached files updated, this will work on muweb 0.8, i edit the file character class to insert only 1111111111111 and remove the field personal id code in registration field, this way it will always insert 1x13 to database and nothing more, this bug can be fixed on registration problem or

generate a SQL job with

UPDATE dbo.MEMB_INFO SET sno__numb = '1111111111111'

Please post any question i am willing to help, just dont flame here coz its working on me and we have different servers

[aznki113r]

thx a lot works 100% here ^^

[ivo2296]

Attached files updated, this will work on muweb 0.8, i edit the file character class to insert only 1111111111111 and remove the field personal id code in registration field, this way it will always insert 1x13 to database and nothing more, this bug can be fixed on registration problem or

generate a SQL job with

UPDATE dbo.MEMB_INFO SET sno__numb = '1111111111111'

Please post any question i am willing to help, just dont flame here coz its working on me and we have different servers

I'm really far away from flaming or blaming you, i just noticed what doesn't take effect in the 1st post.
Actually i have DB job running every 10 min.

Thanks for your efforts!!!

[Pinoyrealm]

try reading the update coz the first one i made was little tricky but working, maybe you need more practice on php and DB if you cant work it out :P, the updated one is better, still needed to learn php if you want to do it in other site rather than my attached file.

Its working on me, and if you want i will bet, i will give you full access to my server on vnc or radmin and do anything you want and you will give me yours if it works... LOL

[lakay]

i have a problem Jumong... i can register successfully in website but in game i got "Account does not exist" error...

[Pinoyrealm]

make sure you patch in proper place :D

[bhudz30]

Jumong just wondering is their a way to run this Script every 5mins?
I mean automatically?

[livewirecebu]

Excuse me I have other problem I done registering in my web without error (Mu web 0.4) sir but i got this problem "Account is Invalid" even i use the MuEditor by SkyTeam. Account Invalid I always got. Is this attach file can solve my problem? what do u think sir?

[Pinoyrealm]

No it will not solve it, if you need help add me coz im now open on Server Help

[kateri4oka]

i do this and work...
ID on charachters is 1111111
but when put the web patch... can`t register new acc...
say: your account is sucsessful...but haven`t account....
Pls help

[Ins1d3r]

i cant use it for muweb 0.6 can you tell me how i can use it for 0.6 web

[_Shotlandetsa_]

I have the same Web problem with creating Accounts. Pls fix your Muweb add-ons. I'll try to fit it but after few days