Ragnarok Online Control Panel Version 4

ASB News! ASB 5.0 Beta V2 has now been released!. See here for more Info.

4 Pages
1
2
3
→
Last »

You cannot start a new topic
You cannot reply to this topic

Ragnarok Online Control Panel Version 4 -- Now officially endorsed by asb! --

#1 azndragon

ROCP Creator & SQL God

Group: Members
Posts: 475
Joined: 15-July 03
Location:Brampton, Ontario, Canada

Posted 13 August 2004 - 02:18 AM

Note: Be sure to check this thread regularly for updates!

After developing this Control Panel for over a month on Aegis, 7 months total, I am pleased to present you with a visually-appealing (somewhat), server management tool that is not only thorough, in terms of database control, but is also secure as well.

A few screenshots: http://rocp.ragonline.net/screens.php

For those who are wondering, this is version 4, because my previously named Athena Control Panel was just on version 3, and one of the major updates to version 4 is the Aegis support. The integration of Aegis and Athena into one server management script is not very difficult, but because MSSQL and MySQL cannot perform all the same functions, Aegis users will have a slightly more difficult installation process.

Features:

Note: Some options are restricted to only certain server installations.

Server Management System for Aegis & SQL Athena Ragnarok Online Servers
Efficient SQL queries, to reduce load time.
GZIP Compatible, for faster load times.
Easily skinnable, with the use of changing the CSS through CP.

Normal Users:
Announcements for all users
Server Information (Forums, IRC, rules, # of accounts/players, # of each class)
Who's Online (Athena Only)
Full Character Ladder
Guild Ladder (Guilds and Castles)
Changing Account Options (password, email, gender)
Changing Character Hairstyles
Money transfer between characters on the same account.
Uploading Guild Emblems by Guild Master
Item & Monster database

GMs:
Announcements that can only be viewed by GMs and above.
Account/Character/Guild Management
Add accounts manually
Single Accounts/Characters can be banned/unbanned.
Remove accounts/players based on login frequency, or illegal ASCII characters in name.
Clear all information associated with currently banned accounts.
Remove the temporary bans caused by failed password attempts. (Athena Only)
Edit/Delete the current announcements.
Item Management, which allows for the searching of items, by item name, refine level, by account, or by character.
View the list of all accounts currently ignored from the ladder.
View Characters/Account associated with a given Character/Account ID/Name.
View the list of currently banned accounts.
View the logs of accounts banned, money transfer, and user actions.
Who's Online (Aegis Only)

Admins:
Announcements that can only be viewed by Admins.
All passwords will be visible in Account Management.
Search for illegal character names.
Delete inactive accounts (Athena Only)
Manage GM/Admin Privileges, and view page privileges.
Full SQL dump of the server's current information. (Athena Only)
Full editing of the configuration.

View the logs of:
Access
Admin Actions
Bans
Login Logs (Athena Only)
Possible Exploit Attempts
Server Logs (OmniAthena Only)
Trade Logs (Aegis Only)

Security:
Access levels are handled server-side, not browser-side.
Minimal cookies required.
All Major queries & actions are logged.
GM/Admin accounts are logged when logging in.
Passwords are encrypted before being sent.
All ID Numbers are encrypted before being sent to the user.
Strong filters rejecting special characters in inputs.
Various Registration methods, equipped with anti-bot measures.

Support & Releases for this project will be handled by my own forums, located in my sig, but you can obtain the first download here. Bug fixes, and later versions will be handled at my forum.

I have a (small) IRC Channel, but I hope it grows soon :hello:

irc.deltaanime.net #rocp

I cannot guarantee that installation will be easy, but I have included instructions in readme.txt, Aegis users have an additional install_functions.txt in the install folder for External Stored Procedure installation.

Please report all bugs here, or on my forums :unsure:

Enjoy :thrilled:

http://azndragon.rag...et/CP_4.3.1.rar
MD5: B469563DFF0DB4686192D0B6C7EA092A

This post has been edited by azndragon: 27 October 2004 - 09:24 PM

#2 maldiablo

Spread too thin.

Group: Administrators
Posts: 1428
Joined: 31-July 03
Gender:Male

Posted 13 August 2004 - 02:25 AM

dude.. this thing just rocks

Been waiting patiently for it for quite some time now.

#3 Devinen

The Unknown Anomoly

Group: Members
Posts: 226
Joined: 19-August 03
Location:Omaha, NE, USA

Posted 13 August 2004 - 02:33 AM

Nice job. ^^;; I've seen it in action on an Aegis server. It's very, very good.....be sure to configure it smarly and choose what features you want your users to see.

Mirror: CP_4.0.0

#4 makan

A/S/L?

Group: Members
Posts: 94
Joined: 05-April 03
Location:Sweden
Interests:Anime, Japan, Budo, Computers, Games

Posted 13 August 2004 - 02:37 AM

Kickass. :unsure:

#5 maldiablo

Spread too thin.

Group: Administrators
Posts: 1428
Joined: 31-July 03
Gender:Male

Posted 13 August 2004 - 07:29 PM

For those switching to this who have been using the roster system from Azndragon and I, here's a query here that you need to run to convert over to the new format.

The query looks long, but it's set up the way it is in case somebody actually used the roster manager to extend to a full 255 slots. Also, keep in mind, I havn't tested this with the roster system in acp4! It may work, but it will be up to you guys to test and confirm if it does/doesn't, so before trying it, BACK UP YOUR DATABASE!!

Change the line "Set @multiplier = 25000" to reflect the multiplier previously set in the roster manager.

Declare @multiplier INT
Set @multiplier = 25000
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 1 WHERE AID > 300000 + @multiplier * 1 AND AID < 300000 + @multiplier * 2
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 2 WHERE AID > 300000 + @multiplier * 2 AND AID < 300000 + @multiplier * 3
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 3 WHERE AID > 300000 + @multiplier * 3 AND AID < 300000 + @multiplier * 4
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 4 WHERE AID > 300000 + @multiplier * 4 AND AID < 300000 + @multiplier * 5
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 5 WHERE AID > 300000 + @multiplier * 5 AND AID < 300000 + @multiplier * 6
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 6 WHERE AID > 300000 + @multiplier * 6 AND AID < 300000 + @multiplier * 7
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 7 WHERE AID > 300000 + @multiplier * 7 AND AID < 300000 + @multiplier * 8
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 8 WHERE AID > 300000 + @multiplier * 8 AND AID < 300000 + @multiplier * 9
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 9 WHERE AID > 300000 + @multiplier * 9 AND AID < 300000 + @multiplier * 10
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 10 WHERE AID > 300000 + @multiplier * 10 AND AID < 300000 + @multiplier * 11
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 11 WHERE AID > 300000 + @multiplier * 11 AND AID < 300000 + @multiplier * 12
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 12 WHERE AID > 300000 + @multiplier * 12 AND AID < 300000 + @multiplier * 13
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 13 WHERE AID > 300000 + @multiplier * 13 AND AID < 300000 + @multiplier * 14
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 14 WHERE AID > 300000 + @multiplier * 14 AND AID < 300000 + @multiplier * 15
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 15 WHERE AID > 300000 + @multiplier * 15 AND AID < 300000 + @multiplier * 16
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 16 WHERE AID > 300000 + @multiplier * 16 AND AID < 300000 + @multiplier * 17
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 17 WHERE AID > 300000 + @multiplier * 17 AND AID < 300000 + @multiplier * 18
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 18 WHERE AID > 300000 + @multiplier * 18 AND AID < 300000 + @multiplier * 19
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 19 WHERE AID > 300000 + @multiplier * 19 AND AID < 300000 + @multiplier * 20
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 20 WHERE AID > 300000 + @multiplier * 20 AND AID < 300000 + @multiplier * 21
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 21 WHERE AID > 300000 + @multiplier * 21 AND AID < 300000 + @multiplier * 22
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 22 WHERE AID > 300000 + @multiplier * 22 AND AID < 300000 + @multiplier * 23
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 23 WHERE AID > 300000 + @multiplier * 23 AND AID < 300000 + @multiplier * 24
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 24 WHERE AID > 300000 + @multiplier * 24 AND AID < 300000 + @multiplier * 25
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 25 WHERE AID > 300000 + @multiplier * 25 AND AID < 300000 + @multiplier * 26
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 26 WHERE AID > 300000 + @multiplier * 26 AND AID < 300000 + @multiplier * 27
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 27 WHERE AID > 300000 + @multiplier * 27 AND AID < 300000 + @multiplier * 28
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 28 WHERE AID > 300000 + @multiplier * 28 AND AID < 300000 + @multiplier * 29
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 29 WHERE AID > 300000 + @multiplier * 29 AND AID < 300000 + @multiplier * 30
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 30 WHERE AID > 300000 + @multiplier * 30 AND AID < 300000 + @multiplier * 31
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 31 WHERE AID > 300000 + @multiplier * 31 AND AID < 300000 + @multiplier * 32
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 32 WHERE AID > 300000 + @multiplier * 32 AND AID < 300000 + @multiplier * 33
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 33 WHERE AID > 300000 + @multiplier * 33 AND AID < 300000 + @multiplier * 34
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 34 WHERE AID > 300000 + @multiplier * 34 AND AID < 300000 + @multiplier * 35
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 35 WHERE AID > 300000 + @multiplier * 35 AND AID < 300000 + @multiplier * 36
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 36 WHERE AID > 300000 + @multiplier * 36 AND AID < 300000 + @multiplier * 37
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 37 WHERE AID > 300000 + @multiplier * 37 AND AID < 300000 + @multiplier * 38
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 38 WHERE AID > 300000 + @multiplier * 38 AND AID < 300000 + @multiplier * 39
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 39 WHERE AID > 300000 + @multiplier * 39 AND AID < 300000 + @multiplier * 40
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 40 WHERE AID > 300000 + @multiplier * 40 AND AID < 300000 + @multiplier * 41
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 41 WHERE AID > 300000 + @multiplier * 41 AND AID < 300000 + @multiplier * 42
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 42 WHERE AID > 300000 + @multiplier * 42 AND AID < 300000 + @multiplier * 43
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 43 WHERE AID > 300000 + @multiplier * 43 AND AID < 300000 + @multiplier * 44
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 44 WHERE AID > 300000 + @multiplier * 44 AND AID < 300000 + @multiplier * 45
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 45 WHERE AID > 300000 + @multiplier * 45 AND AID < 300000 + @multiplier * 46
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 46 WHERE AID > 300000 + @multiplier * 46 AND AID < 300000 + @multiplier * 47
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 47 WHERE AID > 300000 + @multiplier * 47 AND AID < 300000 + @multiplier * 48
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 48 WHERE AID > 300000 + @multiplier * 48 AND AID < 300000 + @multiplier * 49
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 49 WHERE AID > 300000 + @multiplier * 49 AND AID < 300000 + @multiplier * 50
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 50 WHERE AID > 300000 + @multiplier * 50 AND AID < 300000 + @multiplier * 51
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 51 WHERE AID > 300000 + @multiplier * 51 AND AID < 300000 + @multiplier * 52
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 52 WHERE AID > 300000 + @multiplier * 52 AND AID < 300000 + @multiplier * 53
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 53 WHERE AID > 300000 + @multiplier * 53 AND AID < 300000 + @multiplier * 54
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 54 WHERE AID > 300000 + @multiplier * 54 AND AID < 300000 + @multiplier * 55
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 55 WHERE AID > 300000 + @multiplier * 55 AND AID < 300000 + @multiplier * 56
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 56 WHERE AID > 300000 + @multiplier * 56 AND AID < 300000 + @multiplier * 57
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 57 WHERE AID > 300000 + @multiplier * 57 AND AID < 300000 + @multiplier * 58
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 58 WHERE AID > 300000 + @multiplier * 58 AND AID < 300000 + @multiplier * 59
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 59 WHERE AID > 300000 + @multiplier * 59 AND AID < 300000 + @multiplier * 60
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 60 WHERE AID > 300000 + @multiplier * 60 AND AID < 300000 + @multiplier * 61
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 61 WHERE AID > 300000 + @multiplier * 61 AND AID < 300000 + @multiplier * 62
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 62 WHERE AID > 300000 + @multiplier * 62 AND AID < 300000 + @multiplier * 63
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 63 WHERE AID > 300000 + @multiplier * 63 AND AID < 300000 + @multiplier * 64
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 64 WHERE AID > 300000 + @multiplier * 64 AND AID < 300000 + @multiplier * 65
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 65 WHERE AID > 300000 + @multiplier * 65 AND AID < 300000 + @multiplier * 66
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 66 WHERE AID > 300000 + @multiplier * 66 AND AID < 300000 + @multiplier * 67
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 67 WHERE AID > 300000 + @multiplier * 67 AND AID < 300000 + @multiplier * 68
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 68 WHERE AID > 300000 + @multiplier * 68 AND AID < 300000 + @multiplier * 69
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 69 WHERE AID > 300000 + @multiplier * 69 AND AID < 300000 + @multiplier * 70
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 70 WHERE AID > 300000 + @multiplier * 70 AND AID < 300000 + @multiplier * 71
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 71 WHERE AID > 300000 + @multiplier * 71 AND AID < 300000 + @multiplier * 72
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 72 WHERE AID > 300000 + @multiplier * 72 AND AID < 300000 + @multiplier * 73
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 73 WHERE AID > 300000 + @multiplier * 73 AND AID < 300000 + @multiplier * 74
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 74 WHERE AID > 300000 + @multiplier * 74 AND AID < 300000 + @multiplier * 75
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 75 WHERE AID > 300000 + @multiplier * 75 AND AID < 300000 + @multiplier * 76
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 76 WHERE AID > 300000 + @multiplier * 76 AND AID < 300000 + @multiplier * 77
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 77 WHERE AID > 300000 + @multiplier * 77 AND AID < 300000 + @multiplier * 78
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 78 WHERE AID > 300000 + @multiplier * 78 AND AID < 300000 + @multiplier * 79
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 79 WHERE AID > 300000 + @multiplier * 79 AND AID < 300000 + @multiplier * 80
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 80 WHERE AID > 300000 + @multiplier * 80 AND AID < 300000 + @multiplier * 81
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 81 WHERE AID > 300000 + @multiplier * 81 AND AID < 300000 + @multiplier * 82
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 82 WHERE AID > 300000 + @multiplier * 82 AND AID < 300000 + @multiplier * 83
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 83 WHERE AID > 300000 + @multiplier * 83 AND AID < 300000 + @multiplier * 84
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 84 WHERE AID > 300000 + @multiplier * 84 AND AID < 300000 + @multiplier * 85
UPDATE charinfo SET CharNum = CharNum + 10, AID = AID - @multiplier * 85 WHERE AID > 300000 + @multiplier * 85 AND AID < 300000 + @multiplier * 86

This post has been edited by maldiablo: 14 August 2004 - 03:59 AM

#6 andz

Falling Away From Me

Group: Members
Posts: 2228
Joined: 09-April 03
Location:Avril's House
Interests:Avril Lavigne and Korn

Posted 13 August 2004 - 07:37 PM

great job

#7 maldiablo

Spread too thin.

Group: Administrators
Posts: 1428
Joined: 31-July 03
Gender:Male

Posted 14 August 2004 - 03:27 AM

It appears that storage bins have also been dropped from this. I'll release an updated storage bin only version of the original roster manager if azndragon doesn't get to adding it. I'd add storage bins myself, but my php skills are limited.

#8 Ashrain

Expert Member

Group: Members
Posts: 549
Joined: 25-June 03

Posted 14 August 2004 - 03:28 AM

Mirror: AznDragon-CP_4.0.0.rar
md5sum: a573eeb378c81397adbeb70de2f1af34

#9 azndragon

ROCP Creator & SQL God

Group: Members
Posts: 475
Joined: 15-July 03
Location:Brampton, Ontario, Canada

Posted 14 August 2004 - 03:31 AM

Mirrors aren't really too useful, cause I post fixes at least once a week, or more. I'm not particularly good at finding bugs ;)

#10 maldiablo

Spread too thin.

Group: Administrators
Posts: 1428
Joined: 31-July 03
Gender:Male

Posted 16 August 2004 - 08:29 AM

I heard Azndragon is on vacation, so I'll post a few fixes myself until Azndragon can take a look.

Things I've fixed:
- Character names not showing up in lookup.php
- Users getting thier passwords emailed to them as a MD5 hash instead of thier actual password when enabling MD5 passwords in Aegis

Just overwrite your existing php files in your ROCP folder with the ones in this rar file.

Also included is a version of the original roster manager watered down to storage only. This will allow your users to access thier old bins and still allow you a nice transition to ROCP. It checks all input for potential sql exploits and has safeguards against the storage theft bug. Config.inc has also been renamed to Config.php to prevent people from reading your server info.

http://asb.groundtac...blo/scripts.rar

Note to azndragon: I put comments by all the code I changed with my name on each one so just do a test search in each file for 'maldiablo' and you'll know exactly what I did. :grin:

Attached File(s)

scripts.rar (22.78K)
Number of downloads: 176

This post has been edited by maldiablo: 16 August 2004 - 08:34 AM

#11 newbe5

Delightfully deluded.

Group: Members
Posts: 435
Joined: 02-June 03

Posted 16 August 2004 - 01:09 PM

OK, problem. The query you posted to move from roster to ROCP roster doesn't seem to work. You can swap characters in/out of the active slots, but they don't actually appear. I'm not sure what the problem is, but it seems that even though the character I swapped out/in actually does have charnum 0 in the database, but slot 0 actually appears empty when you start the game, and when you double-click on it, it takes you into the "create new char" menu.

Help please!!

newbe5

Edit:
I applied Maldiablo's script fix BEFORE I tested this, so I can't tell you if it is a problem stemming from that or not.

Edit 2:
It appears that some characters CAN be swapped back in (presumably the ones that were in the 3 active slots at the time of changover) but the other characters simply don't show up when you move them into the active slots. No-matter what slot you put them in. Is anyone else experiencing the same problems?

Edit 3:
Lots of edits! I've been trowling through this problem, and I still can't seem to fix it. For clarity, are the extra char's (the ones that are in the roster "buffer" and not actually active) supposed to be stored on a different account, or on the same one but just using higher char numbers?

FINAL Edit:
The roster section of this script DOES NOT work for aegis. The character server will not read any characters made after the first 3 on an account (this is not judged by charnum, but by the actual date they were made). This is why the old roster system used multiple accounts to work. So yea, that needs to be changed. (This is using the original 3-char charserv, I haven't tried with the emu).

#12 maldiablo

Spread too thin.

Group: Administrators
Posts: 1428
Joined: 31-July 03
Gender:Male

Posted 17 August 2004 - 12:18 AM

Unfortunately, I have to confirm what newbe5 is saying. Azndragon has told me the alternate roster system works though, so perhaps it works for some but not all. In the meantime, expect an updated roster manager with exploit fixes and injection safeguards soon until Azndragon gets back and looks into the CP. This should help those that have had problems with this roster system.

Just be glad you took my advice and backed up your databases before running the conversion query... Those of you that switched over did back your stuff up didn't you? :(

#13 echira

Average Member

Group: Members
Posts: 129
Joined: 25-November 03
Location:\\texas\houston\

Posted 20 August 2004 - 08:51 PM

Great work azndragon. My "bugs/suggestions" are going on your ROCP forums ^^ :D

#14 Radamanthys

Advanced Member

Group: Members
Posts: 254
Joined: 31-December 03

Posted 25 August 2004 - 02:15 AM

Good Work, but when i login (like user) to modify the account password , allways says

"Your old password was not entered correctly!
To continue, please click here"

I allway entered Old Password correctly :/... why?

#15 azndragon

ROCP Creator & SQL God

Group: Members
Posts: 475
Joined: 15-July 03
Location:Brampton, Ontario, Canada

Posted 25 August 2004 - 08:48 PM

Yeah, I fixed that for the next version, as well as added the MD5 support for Aegis password-changing.

#16 Radamanthys

Advanced Member

Group: Members
Posts: 254
Joined: 31-December 03

Posted 25 August 2004 - 08:56 PM

Quote

// Confirm Old Password
if ($CONFIG_server_type > 0 && $CONFIG_use_md5) {
$query = sprintf(CHECK_OLD_MD5_PASS, $STORED_login, $old_password);
}
else {
$query = sprintf(CHECK_OLD_PASS, $STORED_login, $old_password);
}
$result = execute_query($query, "account.php");
if ($result->RowCount() == 0) {
redir("account.php", "Your old password was not entered correctly!");

Quote

"Your old password was not entered correctly!"

Allways appear that message, so, this version not support password changer for server aegis platform ?

#17 irenesandy

Newbie

Group: Members
Posts: 6
Joined: 21-May 04

Posted 26 August 2004 - 01:55 PM

my Mirror CP_4.0.5.rar

This post has been edited by irenesandy: 26 August 2004 - 01:55 PM

#18 Radamanthys

Advanced Member

Group: Members
Posts: 254
Joined: 31-December 03

Posted 26 August 2004 - 02:06 PM

Work perfectly good work ^^

#19 robyextreme

cant think of a title...

Group: Members
Posts: 1602
Joined: 25-January 04
Interests:Really do you care

Posted 02 September 2004 - 08:28 AM

Im setting it up now
the features look excellent.

#20 equinoz

Junior Member

Group: Members
Posts: 21
Joined: 07-May 04

Posted 04 September 2004 - 07:16 AM

i found some bugs in account.php.
this should fix it.

elseif ($POST_action == "Change Password") {
	$old_password = $POST_old_pass;
	$new_password = $POST_new_pass;
	$new_password2 = $POST_new_pass2;
	// Confirm Old Password
	if ($CONFIG_use_md5) {
  $query = sprintf(CHECK_OLD_MD5_PASS, $STORED_login, $old_password);
	}
	else {
  $query = sprintf(CHECK_OLD_PASS, $STORED_login, $old_password);
	}
	$result = execute_query($query, "account.php");
	if ($result->RowCount() == 0) {
  redir("account.php", "Your old password was not entered correctly!");
	}
	else {
  //Checks that new password is repeated correctly
  if (strcmp($new_password, $new_password2) == 0) {
  	//Checks length of password
  	if (strlen($new_password) < 4) {
    redir("account.php", "Password has to be 4 letters or more.");
  	}
  	else {
    //All checks have been passed, updating new password
    if ($CONFIG_use_md5) {
    	$query = sprintf(UPDATE_NEW_MD5_PASS, $new_password, $STORED_id);
    }
    else {
    	$query = sprintf(UPDATE_NEW_PASS, $new_password, $STORED_id);
    }
    $result = execute_query($query, "account.php");
    if ($link->Affected_Rows() > 0) {
    	add_user_entry("Changed Password");
    	redir("account.php", "Password Change Successful! Your new password is <b>$new_password</b>");
    }
    else {
    	redir("account.php", "Password Change Failed.");
    }
  	}
  }
  else {
  	redir("account.php", "You have not repeated your new password correctly!");
  }
	}
}

i changed

	$old_password = $POST_old_pass;
	$new_password = $POST_new_pass;
	$new_password2 = $POST_new_pass;

	$old_password = $POST_old_pass;
	$new_password = $POST_new_pass;
	$new_password2 = $POST_new_pass2;

and

 if ($new_password == $new_password2) {

 if (strcmp($new_password, $new_password2) == 0) {

and

  redir("account.php", "You have not repeated your old password correctly!");

  redir("account.php", "You have not repeated your new password correctly!");

This post has been edited by equinoz: 04 September 2004 - 08:04 PM

Share this topic:

4 Pages
1
2
3
→
Last »

You cannot start a new topic
You cannot reply to this topic

Aegis Support Board: Ragnarok Online Control Panel Version 4 - Aegis Support Board

Ragnarok Online Control Panel Version 4 -- Now officially endorsed by asb! --

#1 azndragon

#2 maldiablo

#3 Devinen

#4 makan

#5 maldiablo

#6 andz

#7 maldiablo

#8 Ashrain

#9 azndragon

#10 maldiablo

Attached File(s)

#11 newbe5

#12 maldiablo

#13 echira

#14 Radamanthys

#15 azndragon

#16 Radamanthys

#17 irenesandy

#18 Radamanthys

#19 robyextreme

#20 equinoz

Share this topic:

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users

Delete Post

Skin and Language

Execution Stats

Aegis Support Board: Ragnarok Online Control Panel Version 4 - Aegis Support Board

Ragnarok Online Control Panel Version 4 -- Now officially endorsed by asb! --

Attached File(s)

Share this topic:

1 User(s) are reading this topic 0 members, 1 guests, 0 anonymous users

Delete Post

Skin and Language

Execution Stats

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users