Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::General > Archive::General Discussion

Archive::General Discussion Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2002, 02:57 PM
Razzle
Sarnak
 
Join Date: Jan 2002
Posts: 54
Default SQL Database Combining

I am going to be working with a group of people in order to make an EQ server for a large online community.

Though we know a lot about the Emulator, none of us are very good with SQL.

We need some method of combining our work weekly. Does anyone know how to do this sort of thing?
Reply With Quote
  #2  
Old 02-18-2002, 03:43 PM
Minara
Sarnak
 
Join Date: Feb 2002
Posts: 36
Default

Actually it's not too hard to do this. Rather then having them each work in their own dbs.. Have them do the inserts in a txt file... like jerle.txt for me.. just put all the insert commmands(that you'd be using to fill a db) into the file.. and then send them to the db guy.. he can import those

P.S. I'd like to help if you guys need smoeone.. I'm knowledgeable about mySQL and I'm learnin' php.. Drop me an email(jerleminara@mac.com) or talk to me on irc(Jerle_Minara) if it might be possible.
__________________
Jerle the Magnificent
Level 100 Oracle of Gotfrags.com
Event Admin
Reply With Quote
  #3  
Old 02-18-2002, 05:59 PM
mByte
Hill Giant
 
Join Date: Feb 2002
Posts: 206
Default

make a web front end and all post from there?
__________________
mByte
Reply With Quote
  #4  
Old 02-19-2002, 12:28 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

Draigon was going to do that but he went back to HQ :(

a php admin tool would be neat though..
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #5  
Old 02-19-2002, 12:41 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

I actually made one in php that I had modified from a phone database application i had written. I need to update it a bit, doesnt include any of the new tables or updated table structs though. I whipped a real quick one together because I wanted to be able make item updates from work into the database when i found cool items on eqmaps.com.

Let me know what tables you are wanting to edit, and I'll look into throwing something together tonight when I get home..
Reply With Quote
  #6  
Old 02-19-2002, 12:44 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

Accounts and chars would be nice.
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #7  
Old 02-19-2002, 12:53 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Easy enough... Account tables are simple enough.. Havent looked at the struct for character info, it might be a bit more fun...
Reply With Quote
  #8  
Old 02-19-2002, 12:55 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

maby some basic item adding/editing too
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #9  
Old 02-19-2002, 12:58 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Yep.. Ive already got the old version of that one, should just have to whip it up into shape. What I'll do is just do it in modules, that way I can just turn out one php page at a time that will let you view and edit each indivudual tables, then combine them together to one version when I get a few of them together that I can tie into one application..

One word of warning... i am NOT a web designer, I am a coder, therefore my html formats SUCK.. No flames.. If you dont like it, change the html layout and send it back too me.. I dont do flashy gui's!!
Reply With Quote
  #10  
Old 02-19-2002, 01:03 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

heh, i'll mess around with the html when u release it..
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #11  
Old 02-19-2002, 01:08 AM
Pyrotek
Sarnak
 
Join Date: Jan 2002
Posts: 97
Default

phpMyAdmin...
Reply With Quote
  #12  
Old 02-19-2002, 01:20 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

I tried to use that once but i found it was just a ton of .php files which i have no idea what to do with.
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
Reply With Quote
  #13  
Old 02-19-2002, 03:26 AM
Hack_attack
Sarnak
 
Join Date: Jan 2002
Posts: 37
Default ??

hm well you all are way ahead of me :P i know how to work mySQL but i dont know a thing about php and i know even less of how to make a webpage use mySQL But im willing to learn
__________________
-----------------------
watch out i bite
Reply With Quote
  #14  
Old 02-19-2002, 01:15 PM
Baron Sprite's Avatar
Baron Sprite
Dragon
 
Join Date: Jan 2002
Posts: 708
Default

just make a vpn and all run off the same db
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 12:54 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3