DeathCo's custom lotf source

[1221]

hi guys its me Death from DeathCo and i just felt like sharing my customized lotf source with yall.... hav fun.... Thanks are greatly appreciated

[Mouse>Pro]

deathco?

[1221]

well i never got very big and popular but i hav working mana and weapon skills and stuff soo ya...

[glupkotrup]

Lol I mighty try it out...

[plasma-hand]

+k or (thanks) whichever you prefer for contributing

[jochemke]

Maybe u can add whats in the source
what the bugs are
or what u've fixed or changed

[marcel_bocao]

My browser windows freezes when i try to import the Backup

[1221]

hmmm im not sure how to make the backup like they did... can someone tell me?

[pauldexter]

I'm using Navicat for MySQL, you can find it in google, just search it.
i create backup using Navicat for MySQL.
After installing the program Click Connection:
Connection Name: (Anything)
Host name/IP Address: localhost
Port: 3306(the port you use for mysql)
User Name: root(mysql username)
Password: (mysql password)
then click Test Connection, it should work then press OK
double click your database(ex. coproj) then choose Dump SQL File, and save the file :P

hope it help

[IceyMan]

Not many ppl here use Navicat... we all prefer 2 use AppServ for MySQL lol.. its easier that way cuz the stuff isnt rly causing lag cuz u only open ur ie browser.. so i prefer 2 use Appserv PhpMyAdmin





choose ur database... If u dun have 1 just look in the middle near the side and click create new 1.. name it coproj
click import on the top in middle spot
Click browse
Choose ur DB
insert
and make acc... and ur off...



hope it helped 2 :O

[1221]

no i need to no how to make the backup file so other ppl can import it... brb

[Rechocto]

if importing backup.sql doesn't work you can do one of 2 things... what I didn't do: increase the time limit before Apache\Sql drops the connection or what I did do: parse the backup.sql into seperate text files containing each addition on a seperate line, open command prompt and connect to your server, copy the entire text file and rightclick in the cmd window.. it will add them all and wont disconnect you.

here's the start of one of those files so you get an Idea what I mean:

insert into `items`(`ItemID`,`ItemName`,`ClassReq`,`ProfReq`,` LvlReq`,`SexReq`,`StrReq`,`AgiReq`,`Worth`,`MinAtk `,`MaxAtk`,`Defense`,`MDef`,`MAttack`,`Dodge`,`Agi Give`,`CPsWorth`) values
(580173,'DragonHalbert',0,9,90,0,139,0,35000,396,7 33,0,0,0,0,18,0),
(580168,'ThornHalbert',0,9,85,0,131,0,28100,446,82 8,0,0,0,0,21,0),
(580169,'ThornHalbert',0,9,85,0,131,0,28100,498,92 8,0,0,0,0,22,0),
(580167,'ThornHalbert',0,9,85,0,131,0,28100,392,72 9,0,0,0,0,20,0),
(580165,'ThornHalbert',0,9,85,0,131,0,28100,356,66 3,0,0,0,0,19,0),
(580166,'ThornHalbert',0,9,85,0,131,0,28100,375,69 5,0,0,0,0,19,0),
(580164,'ThornHalbert',0,9,85,0,131,0,28100,350,64 9,0,0,0,0,19,0),
(580159,'FlyingHalbert',0,8,80,0,124,0,22600,427,7 93,0,0,0,0,22,0),
(580163,'ThornHalbert',0,9,85,0,131,0,28100,339,62 9,0,0,0,0,18,0),
(580158,'FlyingHalbert',0,8,80,0,124,0,22600,381,7 10,0,0,0,0,21,0),
(580156,'FlyingHalbert',0,8,80,0,124,0,22600,320,5 96,0,0,0,0,19,0),

here's a code to parse the files.. I suggest taking each table and parsing them seperately


<?php
echo "starting....<br>";
$f = fread(fopen("new 5.txt", "r"), filesize("new 5.txt"));
$f2 = str_replace("),(", "),
(", $f);
fwrite(fopen("new 6.txt", "w"), $f2);
echo "done!";
?>

[d3adklown]

ill try it out

[Incariuz]

If you want to create a backup. Simply load MySql, coproj, then select export at the top of the screen. Copy all the data given in the box (ctrl+A to highlight it all and save time), and paste it in notepad. Then go Save As, and make the change settings...

database.sql
set to "all files" and "UTF8"

now you have a backup, however it won't create a database folder in MySql, it's only capable of being imported into one you create. If you want it to create a database, simply open the backup.sql in notepad again, just scrolling down a bit to where you see.

--
--something said here, not sure.
--

and replace it with.

--
-- Create schema coproj
--

CREATE DATABASE IF NOT EXISTS coproj;
USE coproj;

Hope that helps.