Latest topics
» You know what?
Thu Mar 02, 2017 8:56 pm by DIABLO258

» I won't leave you
Wed Jan 04, 2017 9:33 am by Trippy

» I wonder if
Mon Apr 04, 2016 9:58 pm by Gremnkai

» Good Memories.
Sun Apr 03, 2016 2:04 pm by General Bravo

» can't actually reply to anything
Sun Aug 30, 2015 6:46 pm by Moose_hater

» Not being able to reply - Fixed
Wed Jul 01, 2015 11:51 am by DIABLO258

» assdasdgfadgf
Tue Jun 02, 2015 1:07 am by Gremnkai

» Gotta shitpost to get to 1004 posts
Tue Jun 02, 2015 1:06 am by Gremnkai

» I'm in love wit a coco (Trippy <3)
Tue Jun 02, 2015 1:02 am by Gremnkai

» For anyone who still happens to visit here from time to time
Wed Mar 25, 2015 1:21 pm by DIABLO258


@Diablo: MySQL backup?

View previous topic View next topic Go down

@Diablo: MySQL backup?

Post  Silver on Mon Sep 16, 2013 6:41 pm

Hey, I was thinking..

With the server going down tomorrow, could you backup the MySQL before it goes down? Who knows what we'll do in the future. Might be best to save it. Maybe even publish it, so that if anyone else ever wants to continue TC's legacy, they can with the old database.

Just a thought.

____________________
Code Developer of The Crew
I turn coffee into code.

Characters:
Stacey "Athena" Jadehood - Alive - A resistance medic with psychological problems.
Jill Farkas - Alive - Bright, hopeful and artistic.
CCA-C45-CORE-06.96773 - Alive - A relatively new CCA. Obsessed with punishing offenders.
Kyle Anderson - Dead - Scavenging in City 18 became his death.
avatar
Silver
Technical Officer

Posts : 90
Join date : 2013-01-27
Age : 22
Location : Netherlands

View user profile

Back to top Go down

Re: @Diablo: MySQL backup?

Post  General Bravo on Mon Sep 16, 2013 6:43 pm

This would actually be extremely helpful. If we end up getting enough people showing interest in bringing back HL2RP, or if somebody wants to make a successor to keep the stories going, a backup would save a lot of the in-game setup.

____________________
RP Characters:
Citizen:
Steven Davis-Alive-Citizen, in main district of City 18
Civil Protection:
CCA-C18-CmD.08292-Alive-Searching for APEX, hunting down the last surviving City 18 resistance members, and wiping out everyone who gets in his wayMuch has changed since days of old, but nothing changed what his mind holds.
Resistance:
Nick Bradford-Unknown-[STATUS UNKNOWN]


Former Supreme Military Commander of The Crew
Founder of The Event Horizon, that we may rise from the ashes.
avatar
General Bravo
Super Admin

Posts : 806
Join date : 2012-08-22
Age : 22
Location : Orbiting Earth on his Super Star Destroyer

View user profile

Back to top Go down

Re: @Diablo: MySQL backup?

Post  DIABLO258 on Mon Sep 16, 2013 6:58 pm

Ill see what I can do.

Update: I have an SQL file with all of the tables. No need to worry.

____________________
Always watching.

IC Characters:
CCA-C45-APEX.88052/John Partell - MISSING
Joe Partell - DEAD
Lok'Tar - ALIVE
Harold Kert - DEAD
Dexter Surbs - ALIVE
The G-Man - UNKNOWN


Owner of The Crew.
avatar
DIABLO258
Owner

Posts : 1010
Join date : 2012-07-21
Age : 21
Location : Minnesota

View user profile http://thecrew.forumotion.com

Back to top Go down

Re: @Diablo: MySQL backup?

Post  Silver on Mon Sep 16, 2013 7:14 pm

Awesome. Thanks

____________________
Code Developer of The Crew
I turn coffee into code.

Characters:
Stacey "Athena" Jadehood - Alive - A resistance medic with psychological problems.
Jill Farkas - Alive - Bright, hopeful and artistic.
CCA-C45-CORE-06.96773 - Alive - A relatively new CCA. Obsessed with punishing offenders.
Kyle Anderson - Dead - Scavenging in City 18 became his death.
avatar
Silver
Technical Officer

Posts : 90
Join date : 2013-01-27
Age : 22
Location : Netherlands

View user profile

Back to top Go down

Re: @Diablo: MySQL backup?

Post  Cergis on Mon Sep 16, 2013 7:17 pm

So everyone's SqL is in there?

____________________
Citizens
Alex 'Scar' McKinley: Dead from Helix DvL


Combine Civil Authority]
CCA.HELIX.03.90005

Vortigaunts
Vash'Nagul

CWU
John Kinnadey

Gif to large
avatar
Cergis

Posts : 273
Join date : 2013-01-06
Age : 17
Location : Minnesota

View user profile

Back to top Go down

Re: @Diablo: MySQL backup?

Post  DIABLO258 on Mon Sep 16, 2013 11:09 pm

Not every ones 'SQL', because there is only one SQL. And its not really a thing. MySQL is a database program that allows you to store and update information in real time, for websites, games, server hosting, etc.

In my 'SQL' I have 4 tables.
So I have 4 tables in my database. Each table represents a different kind of information. For example, one of them is called "Characters". This is the table that has every single character ever made on TC. Literally. From pre-clockwork. So, I got a lot of names. Another table is "Users", I have every single name, every steam ID, every IP, from every person who has connected to TC. Also, pre-clockwork.

This is highly private info, so do not expect to get it by just asking. (even if you weren't, I am just saying) I wouldn't want people giving out my info on a whims notice to some guy. So if anyone does want the SQL file for future use, I need you to show you are going to use it properly. I will be professional about this info for as long as I have it. I may have discontinued the server, but that does not mean I wont take responsibility for the information even after its gone.

With that said, if anyone is making a server and wants to continue our lore, contact me.


Edit: More info on how MySQL works.

Click this to see the image.

From left to right, we will use Noobstrikes OTA as an example.
-So on the far left you can see I could delete your character at any point. If I was to do that, it would be instantaneous.  As in, you go to switch characters, I remove one, and its gone within the second you want to change back.
-The next is the description. Which I can edit on the fly, and have it change real time. You would need to switch characters to see it change. But you can do that. How ever, its a hassle to go in and find this info for just one minge who doesn't know how to play.
-Next is the name. Which I can also change.
-The underlined number (6554) is the amount of tokens that character has. Can be changed, I can add 1,000 if I wanted.
-Then it shows the model, which can be changed.
-You can then see which flags a character has. Noobstrike is noticeable in the amount of players listed, because he has a shit ton of flags.
-It even tells you the gender, faction, and steam id.
-Then it shows the name of the player, which I cannot change.
-To the very far right is the inventory, which I can also change. Adding or taking things from you, in real time.
-Even farther right which cannot be seen is when the character was created, when the last time that character was used, and even the attributes that character had.

I blocked all the ID's, because who knows what some people get pissed about.

PS: I just went through the "Bans" table, and I noticed that anyone using a program to change their steam ID can be spotted. They replace their ID with letters or words. So, when I look for the ID all I see is "Das" or "Falggin". Weird shit.

____________________
Always watching.

IC Characters:
CCA-C45-APEX.88052/John Partell - MISSING
Joe Partell - DEAD
Lok'Tar - ALIVE
Harold Kert - DEAD
Dexter Surbs - ALIVE
The G-Man - UNKNOWN


Owner of The Crew.
avatar
DIABLO258
Owner

Posts : 1010
Join date : 2012-07-21
Age : 21
Location : Minnesota

View user profile http://thecrew.forumotion.com

Back to top Go down

Re: @Diablo: MySQL backup?

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum