[maldiablo]

Update: Version 1.03 out. A few important fixes.

Fixes include:
Hashes the passwords stored in cookies
Anti sql injection safeguards in place
Anti storage bin theft safeguards in place.
Supports MD5 database passswords (Aegis account emu only - see my sig)

All in all, this should now be a secure script and safe to use in all servers. Please let me know if you find a security hole and I'll do my best to fill it. Azndragon has moved on from this project and gone to do his work with ROCP, but since it seems the roster functions of ROCP seem to be broken for many, I've decided to release this. And now, on to the original post....
---

I had an idea, but have been to busy to implement it. Along came Azndragon. With his awesome coding skills, I bring the Aegis roster manager.

You may have heard of Azndragon before. He's the guy who coded the AthenaCP for mysql versions of athena. You can see everybody sucking up to him over in the athena section for his contributions. Believe me though, he earned it.

Anyway, one day I got a crazy idea. I was thinking.. why the hell is everybody going nuts trying get a working (and stable) 5 slot char server.. or for that matter, a 9 slot char server? I hate low expectations, so with Azndragon's php skills, I bring you a system that will allow up to 255 (YES... 255!!) characters per account. All without having to upgrade any of your existing setup.

As a bonus, this script will allow you to give characters multiple storage bins (yes, they can now store more than 100 items per account).

How does it work? What do you need to change? What do you need to add?

You add nothing but this script to a php enabled web server. Preferably apache as it doesn't appear to work with php enabled IIS (which sucks anyway).

You need no changes or additions in your existing database. It's THAT good.

Known issues:

Migrating to this system from a 5 slot character server system is currently a bad idea. This was designed as an addition to a 3 slot character server system.

This creates dummy aid numbers to store the extra chars. Thats why the multiplier is so important. A minor issue with this is that managing accounts with third party programs/scripts can cause some problems. Be wary of cleanup functions of various control panels out there and when in doubt, BACK UP YOUR DATABASE.

Configuration is easy too, just read the comments in config.inc.

If you can't figure it out from there, then you got problems. :band:

Oh yeah, and special thanks to Nucleo (I 'borrowed' some aegiscp code to improve the visual appearance of the script)

Mirrors
http://asb.groundtac...ablo/roster.rar

Attached File(s)

•  roster.rar (12.47K)
  Number of downloads: 168

This post has been edited by maldiablo: 17 August 2004 - 07:18 PM

[azndragon]

Woo! Go me! ;) Just make sure you config it PERFECT the first time :P Any by the way, its 255 + 3 characters per 'account', but that would probably fill up the database fast, and who has that much time? ;)

Also, please leave all credits intact :D

Too many emoticons... :band:

This post has been edited by azndragon: 20 April 2004 - 04:00 AM

[Senku]

Go grab a can of pepsi and smoke a cigg you 2 goons deserve it :)

[azndragon]

An update, because the script wasn't changing storage properly, cause Mal changed the name of the button :) Should work now, enjoy.

This post has been edited by maldiablo: 20 April 2004 - 01:29 PM

[Mana Isozaki]

Sweet *Beep*, thats incredible. I want to kiss you right now! (proverbally)

[Radamanthys]

Fatal error: Call to undefined function: mssql_connect() in functions.php on line 15

o.o?

[xmarv]

lol azndragon
That rar package is empty

Quote

Fatal error: Call to undefined function: mssql_connect() in functions.php on line 15

o.o?

You must uncomment the extension line for php_mssql.dll in your php.ini (in both folders... php\ and apache\bin\ )

This post has been edited by xmarv: 20 April 2004 - 01:13 PM

[siughoust]

Wow 255?? Crazy!! Awesome job guys! Can't wait to test it out. :huh:

EDIT: It might take some time for me to have a look for myself but, accessing 9+ charcters from the client, you just need to keep scrolling to see the additional characters as they are created?

This post has been edited by siughoust: 20 April 2004 - 01:23 PM

[maldiablo]

Found the bug Azndragon was referring to, fixed it, and re-uploaded it as 1.01. Check the first post for the dl link. Have fun!

[maldiablo]

siughoust, on Apr 20 2004, 09:19 AM, said:

Wow 255?? Crazy!! Awesome job guys! Can't wait to test it out. :huh:

EDIT: It might take some time for me to have a look for myself but, accessing 9+ charcters from the client, you just need to keep scrolling to see the additional characters as they are created?

Here goes the big evil double post, but to answer that question.. no.

A 3 slot char server and 3 slot client are all you need. If users want to access chars beyond the first 3, they simply log into the script, and move the extra characters to the first 3 slots with the swap function.

[WindyForce]

omfg 255 char slots *craps himself* :huh:

[kanechart]

wow so this account maker im guessing?? I dont even have run 5 slot charecter server just need run 3 slot? and this stable I dont want week evyone saying they lose accounts btw great job :D

[siughoust]

Thanx!
1st thing I noticed is that when I went to log in I got this message:

Quote

You are now logged in.
You are being redirected, if you do not wish to wait click here

But then after a few seconds it changed to this message:

Quote

You are not logged in!
You are being redirected, if you do not wish to wait click here

And brought me back to login screen.
I did manage to log in eventually after typing my user name exactly as it is shown in DB (case sensitive).

@maldiablo
Out of topic but, have you always been using 3 slot character server? If so, has any of the players experienced the guild skill reset and/or loss of guild exp?
I'm trying to rule out the possibilities and using the 5 slot charserver msyelf has lead me to believe that somehow it causes some type of domino effect after crashing so many times.

Thanx again!

[xmarv]

Doesn't work at me...
It disables both characters :P
I think I can make it work at me, lets see :D

[azndragon]

siughoust, the script uses cookies, so you need to enable cookies for that script if you want it to log in properly.

xmarv, how can it disable both characters? Only the characters in bold will be displayed in client.

[willy_sunny]

damn, today must be my lucky day <_<

[Veriad]

That's a coincidence... I've actually made something exactly like this. I made an ACP mod that gives you a character storage of up to 255 characters, for a total of 260 characters. I'm also making a a storage storage, (...yeah, that makes sense <_<) to allow around 1000 items. But, you have yours set up so that it shows the storage hex string, and most people have nooooo idea what that is. Mine, instead, will show all of the items in storage. I'll post a new topic with both scripts when I've completed the storage storage. But for now, here's a little screenshot preview of my character storage with 10 storage slots enabled, and to change that limit, all that needs to be changed is a line at the top of the script that says "$storageLimit = 10;"
edit: I also have a fix for the account cleanup system with unlinked accounts for mine...
edit2: LOL This is really ironic... Back when you made Transproxy, I had just finished making a proxy like that, to enable multiple zones behind a router... With in-game commands and stuff, but I never released it because I figured yours would get the job done for most people

Attached File(s)

•  charslots.gif (32.11K)
  Number of downloads: 1

This post has been edited by Veriad: 21 April 2004 - 02:00 AM

[thadarkman]

255 characters, that's just crazy o_O. Great job guys, and tough luck, you almost would have been the first Veriad :P.

[maldiablo]

xmarv, on Apr 20 2004, 01:53 PM, said:

Doesn't work at me...
It disables both characters :(
I think I can make it work at me, lets see :unsure:

Ok, this does not magically give you more characters slots in game... This swaps characters in and out of your first 3 slots so you can continue to make more and more characters in the first 3 slots.

It uses the same swapping method for storage.

@Veriad
What can I say? Great minds think alike I guess. :P We chose to go with the 3 slot char server instead of the 5 slot though because with multiple zones, 5 slot char server crashing is an extreme pain in the ass for zone to zone travel. As for our use of the hex string instead of items. We just wanted to give the user something to visually differentiate storage bins so they can verify that things have been swapped. It was the only thing we could do without spending the extra time to code an item browser or adding any tables to the database. We wanted to make sure this script goes in as clean as possible with the least amount of user configuration.

[azndragon]

The more features that you add, the more likely that the user is to mess up the configuration. By keeping it as simple as possible, it will reach the widest audience, and will be enjoyed by all B)