DeathCo's custom lotf source

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

deathco?

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

Lol I mighty try it out... :rolleyes:

+k or (thanks) whichever you prefer for contributing

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

My browser windows freezes when i try to import the Backup

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

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

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




[Only registered and activated users can see links. Click Here To Register...]
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

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

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:

Quote:

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!";
?>

ill try it out

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.

and replace it with.



Hope that helps.