Gamestudio Links
Zorro Links
Newest Posts
Zorro 2.70
by jcl. 09/29/25 09:24
optimize global parameters SOLVED
by dBc. 09/27/25 17:07
ZorroGPT
by TipmyPip. 09/27/25 10:05
assetHistory one candle shift
by jcl. 09/21/25 11:36
Plugins update
by Grant. 09/17/25 16:28
AUM Magazine
Latest Screens
Rocker`s Revenge
Stug 3 Stormartillery
Iljuschin 2
Galactic Strike X
Who's Online Now
2 registered members (TipmyPip, 1 invisible), 18,787 guests, and 8 spiders.
Key: Admin, Global Mod, Mod
Newest Members
krishna, DrissB, James168, Ed_Love, xtns
19168 Registered Users
Previous Thread
Next Thread
Print Thread
Rate Thread
Page 1 of 2 1 2
Text Based Database - No Need for the MySQL DLL #91404
09/25/06 07:59
09/25/06 07:59
Joined: May 2006
Posts: 4
S
SilentSiren Offline OP
Guest
SilentSiren  Offline OP
Guest
S

Joined: May 2006
Posts: 4
Hi there, well I scanned the forums and it seemed there is not much in the way of attempts on making a MMO, there was a dll I did come across but its implementation seemed a little buggy to say the least upon following the instructions. Thus I asked why not use encrypted, no extension appended, text files server side which would transfer data to the player client side according to details they give logging in and once they disconnect to update new values server side. That way there is no 'stress' on the server of continued data flowing only on logging functions and the text files are as easy to back up as simply right clicking and copy/pasting. Not to mention using PHP Include you could display the resulting data as a online player list ^_^ and if they went to 'view source' it would only show the resulting data not the file itself.

I have already got a functioning login system based of this theory and will post the 'basic' version of the system once I am done most likely in a few hours, please feel free to critisize and point out security gaps/flaws you see with this in comparison to the mysql dll.

Last edited by SilentSiren; 09/25/06 08:00.
Re: Text Based Database - No Need for the MySQL DLL [Re: SilentSiren] #91405
09/25/06 09:51
09/25/06 09:51
Joined: Feb 2005
Posts: 3,687
Hessen, Germany
T
Tempelbauer Offline
Expert
Tempelbauer  Offline
Expert
T

Joined: Feb 2005
Posts: 3,687
Hessen, Germany
yeah, i thought so too...
i have played with the idea to create my own database system and offer it for free to the communtiy.
a wdl script is so i think too complex for such a script. the best way would be a dll. but i have less experience with it

generell a good idea. but needed?
why reinvent the wheel?

Re: Text Based Database - No Need for the MySQL DL [Re: Tempelbauer] #91406
09/25/06 13:51
09/25/06 13:51
Joined: Oct 2005
Posts: 4,771
Bay City, MI
lostclimate Offline
Expert
lostclimate  Offline
Expert

Joined: Oct 2005
Posts: 4,771
Bay City, MI
well i could see the point of making a textfile instead of using mysql, that aside, i think your right it might be easier to do with a dll instead of script.

Re: Text Based Database - No Need for the MySQL DL [Re: lostclimate] #91407
09/25/06 23:19
09/25/06 23:19
Joined: May 2006
Posts: 4
S
SilentSiren Offline OP
Guest
SilentSiren  Offline OP
Guest
S

Joined: May 2006
Posts: 4
Well you see the problems/advantages that arise are such:

Using the sql dll means you need to install mysql which not all people are completely understanding with.

Updating the text files in manual form as if you were in microsoft word as opposed to sql statements.

No need to run the sql server AND 3dgamestudio since 3dgamestudio becomes its OWN complete database/server.

I in no way wish to undermine the sql dll I mean come on that was a work of art ^_^ however I just saw a simpler way, needing less resources, less installs, easier back up and thought "hmmmm". I am new to the forum and see that people post links to the final product of the contribution so sorry about what I said being a 'few hours' I should make this bug free and complete first before, rather than uploading a semi working production.

In the meantime though here is some of the script in its basic form to show just how SIMPLE and quick it is to add in .


//////////////////////////////
If ( (Event_type == Event_Join) )
{

Ifdef Server;
//This is to create the file server side using the Player_Name engine variable which in a previous part of script is stored in 'playname_str'

filehandle = file_open_write(playname_str);
file_str_write(filehandle, "Player Name : ");
file_str_write(filehandle, playname_str);
file_close (filehandle);

// Now the file has been made with the file now holding 'Player Name : their name here' we open it to be read and use that information to pass it into namecheck_str

filehandle = file_open_read(playname_str);
file_str_read(filehandle, namecheck_str);

//Now we use a string checker to see if the players name, remember it is held/equal to 'playname_str' is found within 'namecheck_str'

if (Str_Stri (playname_str, "Player Name : Test") != 0)
{
allow_them_to_login();
}
file_close (filehandle);

Endif;

// If the player trying to login has the name 'Test' (Player Name : Test) held in file let them login

/////////////////////////////////

This is rough and currently working on it over, what the eventual system will be is a lot more developed and obviously will not need to hardcode each and every username to check using OR's

Watch this space and once again feel free to make judgements ^_^

Re: Text Based Database - No Need for the MySQL DL [Re: SilentSiren] #91408
09/25/06 23:56
09/25/06 23:56
Joined: Aug 2003
Posts: 7,440
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,440
Red Dwarf
Quote:

Using the sql dll means you need to install mysql which not all people are completely understanding with.




copying the libmysql.dll is fine, no need to instal mysql, my sql in fact is the SERVER not the client, so you do not need to install anything else than your game.


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: Text Based Database - No Need for the MySQL DL [Re: Michael_Schwarz] #91409
09/26/06 00:58
09/26/06 00:58
Joined: Aug 2000
Posts: 7,490
O
Orange Brat Offline

Senior Expert
Orange Brat  Offline

Senior Expert
O

Joined: Aug 2000
Posts: 7,490
I wish Conitec would bring back the database feature. My game is going to feature a lot of text(but no MP), and ideally a database is the way to go for this.


My User Contributions master list - my initial post links are down but scroll down page to find list to active links
Re: Text Based Database - No Need for the MySQL DL [Re: Michael_Schwarz] #91410
09/26/06 01:12
09/26/06 01:12
Joined: May 2006
Posts: 4
S
SilentSiren Offline OP
Guest
SilentSiren  Offline OP
Guest
S

Joined: May 2006
Posts: 4
Quote:

Quote:

Using the sql dll means you need to install mysql which not all people are completely understanding with.




copying the libmysql.dll is fine, no need to instal mysql, my sql in fact is the SERVER not the client, so you do not need to install anything else than your game.




What I had meant was the developer using the mysql dll say for example they wish to create a database of their users they need - according to the Documentation that came with that DLL since it connects to a database you need to off created beforehand - to have it set up so they can view such data.

Quote:


Tips:
When developping a game using a database, I recommand installing MySQL server on your computer.
You also need other tools to manage the database for your tests:
MySQL Administrator - http://www.mysql.com/products/administrator/
MySQL Query Browser - http://www.mysql.com/products/query-browser/





Whereas this method keeps it all in simple file form with the ability to store/write/access whatever you want without worrying about anything such as mysql queries/database setup/running a mysql server for A6 to access, this is ease on the Server side of things not Client side allowing the engine to just retrieve data on login/logout/disconnect all of which have event types predefined in the C-Script syntax - this method stores nothing client side. Sorry should have explained that more in detail.

I was just about to log for the night and saw new post, Ive made a little program demostrating this so once I got some sleep and done a little testing Ill upload it here for you to play with ^_^ night night all.

Re: Text Based Database - No Need for the MySQL DL [Re: SilentSiren] #91411
09/26/06 04:58
09/26/06 04:58
Joined: Aug 2003
Posts: 7,440
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,440
Red Dwarf
Quote:

Quote:

Quote:

Using the sql dll means you need to install mysql which not all people are completely understanding with.




copying the libmysql.dll is fine, no need to instal mysql, my sql in fact is the SERVER not the client, so you do not need to install anything else than your game.




What I had meant was the developer using the mysql dll say for example they wish to create a database of their users they need - according to the Documentation that came with that DLL since it connects to a database you need to off created beforehand - to have it set up so they can view such data.





Well, thats obivious. YOu also have to set up a text file before you can view it.

Quote:


Quote:


Tips:
When developping a game using a database, I recommand installing MySQL server on your computer.
You also need other tools to manage the database for your tests:
MySQL Administrator - http://www.mysql.com/products/administrator/
MySQL Query Browser - http://www.mysql.com/products/query-browser/





Whereas this method keeps it all in simple file form with the ability to store/write/access whatever you want without worrying about anything such as mysql queries/database setup/running a mysql server for A6 to access, this is ease on the Server side of things not Client side allowing the engine to just retrieve data on login/logout/disconnect all of which have event types predefined in the C-Script syntax - this method stores nothing client side. Sorry should have explained that more in detail.




MySQL doesnt store anything client side aswell, infact if you download a text file to read out data, it could be a big security leak, a smart guy could just hinder the text file from being deleted and then just read all the information he wants.

Also MySQL comes with all servers as standart today, no need to set it up specially. It is even less "stressier" than downloading anduploading files - and wastes less bandwith.


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Re: Text Based Database - No Need for the MySQL DL [Re: Michael_Schwarz] #91412
09/27/06 20:29
09/27/06 20:29
Joined: May 2006
Posts: 25
A
Albert Offline
Newbie
Albert  Offline
Newbie
A

Joined: May 2006
Posts: 25
Well, I haven't really read through the entire post, but I did want to mention a few things. I work for a software company (http://www.mainsequence.net,http://www.pcrecruiter.net) and our product is used for (job) recruiters. Our software is an interface for two different types of database, MS Access and MS SQL. We sell the access license to small offices because after 1 GB of data (sometimes a little less) the database becomes unstable and explodes (but it can be repaired), SQL on the other hand handles in the terrabytes.

Most game communities will never get that large, but consider a text file with 10,000 lines in it. Not Good. MySQL is a little different from MS SQL, but the same theory applies. The SQL Server can be hosted on its own seperate computer (which I hope you would if you ran a server), but the point is, a text file can only handle so much before its simply not going to be capable of huge amounts of data. Plus, the extra security that comes with an SQL server is, I think, more than useful.

But I'm always open to discussion and differences of opinion.

Re: Text Based Database - No Need for the MySQL DL [Re: Albert] #91413
09/27/06 21:39
09/27/06 21:39
Joined: Aug 2003
Posts: 7,440
Red Dwarf
Michael_Schwarz Offline
Senior Expert
Michael_Schwarz  Offline
Senior Expert

Joined: Aug 2003
Posts: 7,440
Red Dwarf
Quote:

Most game communities will never get that large, but consider a text file with 10,000 lines in it. Not Good. MySQL is a little different from MS SQL, but the same theory applies. The SQL Server can be hosted on its own seperate computer (which I hope you would if you ran a server), but the point is, a text file can only handle so much before its simply not going to be capable of huge amounts of data. Plus, the extra security that comes with an SQL server is, I think, more than useful.

But I'm always open to discussion and differences of opinion.




thanks for saying what i wanted to say


"Sometimes JCL reminds me of Notch, but more competent" ~ Kiyaku
Page 1 of 2 1 2

Moderated by  adoado, checkbutton, mk_1, Perro 

Gamestudio download | Zorro platform | shop | Data Protection Policy

oP group Germany GmbH | Birkenstr. 25-27 | 63549 Ronneburg / Germany | info (at) opgroup.de

Powered by UBB.threads™ PHP Forum Software 7.7.1