SQL Database Combining

[Razzle]

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?

[Minara]

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.

[mByte]

make a web front end and all post from there?

[Shawn319]

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

a php admin tool would be neat though..

[Trumpcard]

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..

[Shawn319]

Accounts and chars would be nice.

[Trumpcard]

Easy enough... Account tables are simple enough.. Havent looked at the struct for character info, it might be a bit more fun...

[Shawn319]

maby some basic item adding/editing too

[Trumpcard]

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!!

[Shawn319]

heh, i'll mess around with the html when u release it..

[Pyrotek]

phpMyAdmin...

[Shawn319]

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.

[Hack_attack]

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

[Baron Sprite]

just make a vpn and all run off the same db