[DiaDz]

dzRODM - Player Database - v1.1.a (Oct 25th, 2003)

Special Thanks:
ech0 - For the RODM base php Engine! :oops:
Kolina (Raya) - For making the additions on RODM! :D

Quickie Webserver Setup:
Not exactly as detailed as someone would like, but here you go:
(Yes, it's even in the same topic as the dzRODM)
Quickie webserver setup
(Updated! Oct 28th, 2003! {updates are in GRAY})

Background:
Well, I was being asked one day by a few players if they could know who was the
strongest on the server at that moment, so I fired up the RODM and took a look.
As the server grew, more and more people wanted to know, so I took the time to
sit down one day and edit the RODM php scripts. And the rest is history...

Features:
+ Main Website Link
- configured in config.php
+ Announcements
- index.php
+ Accout Registration
- no grade
+ Server Statistics
- players online
- total registered accounts
- total created players
+ Player Database
- lists: character name/class/level(base/job)/money
- loads: strongest to weakest
- sorts: stronger to weakest/richest to poorest
- lists [GM] before name and in blue
+ Online Players (Beta)
- lists player's status
- lists the account's characters (need "exact" player fix :clap: )
- lists [GM] before name and in blue (little annoying, but ok)
- although it's Beta, it is fairly very stable :)

Note: Lotta nice stuff to be added huh? Well not everything you want might be added as releases come out, I complete whatever is essential and easy to do first! :P

Planned Additions:
+ Server Statistics
- display IP addtion/option
+ Account Management
- change password
- change email
- change gender? (you sickos :P )
- change char hairstyle
+ Player Database
- more sorting options
+ Online Players
- "exact" player name that is online (Anyone wanna help me w/this? :clap: )
- loads: alphabetical order
+ Configuration Control Panel?
- instead of going into the congif.php, enter a pass to config the player database
- eventually make eveything dependant on the config.php
- this is just some wild idea, don't be surprised if i trash it :)

Planned Fixes:
+ polish up php code (yeah, it's everywhere! :P )
+ online players load time (maybe a diff recall method...)
+ getting rid of [GM] before names, it's really annoying! :cheers:
+ Priest <-> Hunter class swap - Fixed! look for the attachment on one of the pages
+ 5 character configuration

Example (Up to Date): Taken "down" due to "Security" issues

Current Version: dzRODM v1.1.a (Oct 25th, 2003)(See Attachment)

Attached File(s)

•  dzrodm.rar (93.47K)
  Number of downloads: 2131

This post has been edited by DiaDz: 31 October 2003 - 05:28 PM

[Kolina]

Nice little thing :)

I'm glad some of my addons helped

This post has been edited by Raya: 24 October 2003 - 07:33 PM

[DiaDz]

okay, got home form college x_x

Enjoy! <_<

(yes more features will be added soon =p)
(check first post)

This post has been edited by DiaDz: 25 October 2003 - 01:21 AM

[dovac]

adding it to the MALL <_<

[gugclo]

sigh, i have no where to host this >_<

[boines]

Is this windows only again php? Because i can't use rodm on unix because of sql dll >_> (you don't include that file but it calls it). My host i bought won't let me install win nt.

This post has been edited by boines: 25 October 2003 - 05:54 AM

[DiaDz]

Well it's based off of the original RODM (echo) and the modified RODM (Kolina), if Unix couldn't support those databases, then for sure it won't be able to support this one. Remember, Uni/Aegis was meant to run on windows ;)

This post has been edited by DiaDz: 25 October 2003 - 05:59 AM

[roh0502]

Fatal error: Call to undefined function: mssql_connect() in /free/home/roh0502/html/dzrodm/functionssss.php on line 7

what error?

[DiaDz]

Quote

Fatal error: Call to undefined function: mssql_connect() in /free/home/roh0502/html/dzrodm/functionssss.php on line 7

what error?

Okay, have you read the Readme-Install? There are 2 config.php's to edit:

config.php
configsss.php

Make sure that the IP you enter is for the database.

I've also found out the the databases run better on the server machine, so you'll have to set up your computer to host a webserver that supports php and mysql integration. the best server for this is: EasyPHP, but as I have stated in the Readme as well, I will give no furthur help in how to set that up for you.

(In short, if you couldn't run the RODM by ech0 or the RODM modified by Kolina, you most likely won't be able to run this RODM either...)

[gugclo]

umm......sigh

[gugclo]

i got a new error

Notice: Undefined variable: action in c:\program files\easyphp1-7\www\register.php on line 11

[_-=Stealth=-_]

hmmm....works for me wut try posting ur register.php in code
and ill show u wuts wrong

[DiaDz]

Sure.

<?php

//This adds players, unless you want to make it look pretty...don't change anything

require 'configsss.php';
require 'functionssss.php';

dopageheader();
doauth();
echo"<center><b>Register Account</b><br><br></center>";
if($action=="register")
{
        if($ID && $passwd)
        {
                connect("login","nLogin");
                
                $regDate = date("n/j/Y g:i:s A");
                $result = mssql_query("INSERT INTO login (ID,passwd,LastConnecTime,grade,isConfirmed,regDate)" . "VALUES ('$ID','$passwd',NULL,'$grade','3','$regDate')");
                $result2 = mssql_query("SELECT * FROM login");
                while($r=MSSQL_FETCH_ARRAY($result2))
                {
                        $AID=$r["AID"];

                        $registerAccount= @MSSQL_QUERY("INSERT INTO account (AID,Name,Address,Phone,HPhone,RegNum,zipcode,sex,Email,http,News,job,hobby,game,comment,nation,ip,lasttime)" . "VALUES ('$AID','$ID',NULL,NULL,NULL,'0','00000','$sex','$Email',NULL,'$news',NULL,NULL,NULL,NULL,'NA',NULL,NULL)");
                }

                domsg("User <b>$ID</b> has been added!");

        }
        elseif(!$ID)
        {
          doerror("Invalid Username");
        }
        elseif(!$passwd)
        { 
          doerror("Invalid Password");
        }
}

else
{
        dotableheader();
        doformheader($PHP_SELF);
        doinputvalue("Username", "ID");
        doinputvalue("Password", "passwd");
        doinputvalue("Email", "Email","" . $row2["Email"] . "");
        echo "<TD>Grade(acc lvl):</TD>\n";
        echo "<TD><SELECT class=button name=grade>
              <OPTION VALUE=1>1
              </SELECT></TD></TR>\n";
        echo "<TR>";
        echo "<TD>Sex:</TD>
              <TD><SELECT class=button name=sex>
              <OPTION VALUE=1>Male
              <OPTION VALUE=0>Female
              </SELECT></TD></TR>\n";
        dotablefooter();
        doformfooter("action","register",1);
}

dopagefooter();

?>

[Kolina]

Actually there's nothing wrong with his code
A notice is a little like a warning, it's not good to have a warning, but the code will still be executed.

I have tested this little program and it's cute, but there's a little thing you should'nt have added

(first off, the functionssss.php and the configsss.php (I don't really understand the point of having them ^^; )

and in players.php , instead of adding this line

$charname1=$r["CharName"]; // This line
$charname=$r[$charnametable];

You should've looked carefully into my config.php I have made at the following line

// This is a fix for people who are using charname column name instead of CharName
$charnametable = "charname";

and change "charname" to "CharName". I have added this variable because some zone require charname instead of CharName to work properly.

So when I tested your thing, the names werent displaying (because my dbase uses charname.

Your code needs some clean up ^^; I didnt take much time to clean mine so imagine how it is now XD

[DiaDz]

Quote

and in players.php , instead of adding this line

$charname1=$r["CharName"]; // This line
$charname=$r[$charnametable];

You should've looked carefully into my config.php I have made at the following line

// This is a fix for people who are using charname column name instead of CharName
$charnametable = "charname";

Once again, ThankYou Raya! :D

I'll edit this and release the fix in the next version. :P


Edit - I'll also take out the configsss and functionssss, those were there for stability reasons :(

This post has been edited by DiaDz: 25 October 2003 - 05:40 PM

[gugclo]

i will try the next verson >_<

[DiaDz]

Yah, as you can see, my example is pretty much very updated, I'll release the new version very very soon.

[gugclo]

tonightr i hope? cause i need a reg form, the form i was using is now not useable cause the ASP rules of brinkster forbid the select * from db for big dbs

[DiaDz]

Okay! New version is out!
dzRODM v1.1.a (Oct 25th, 2003)

dzRODM v1.0.a (Oct 24th, 2003) - IS DEAD!

This one has easy install, all you need to tweak is:

config.php
gmaccounts.txt
index.php

(Detailed intructions come w/the rar ^_^ )

***See first post for more details/download of the new version***

(Detailed notes come w/the rar :) )

This post has been edited by DiaDz: 26 October 2003 - 06:49 AM

[gugclo]

i am still gettin the old errors >_<

http://fro2.serveftp.com/dzrodm/

This post has been edited by gugclo: 26 October 2003 - 07:05 AM