Need myphpadmin help...

[Peopleperson49]

My knowledge with myphpadmin and sql in general is weak. I'm slowly learning. I know there is a program out there somewhere to convert txt -> sql. Once I get it converted how do I add my custom item_db2 table to the myphpadmin so that I can be seen in the CP?

Peopleperson49

[Wafflebutt]

Why don´t you insert it directly into the item_db2 sql table?

IMHO its the easiest way to go.

Just get MySql Workbench and make a connection to your sql server. Then edit them directly in workbench.

But if you wanna do it your way just make a sql script like the official ones:

#
# Table structure for table `item_db2`
#
DROP TABLE IF EXISTS `item_db2`;
CREATE TABLE `item_db2` (
 `id` smallint(5) unsigned NOT NULL default '0',
 `name_english` varchar(50) NOT NULL default '',
 `name_japanese` varchar(50) NOT NULL default '',
 `type` tinyint(2) unsigned NOT NULL default '0',
 `price_buy` mediumint(10) unsigned default NULL,
 `price_sell` mediumint(10) unsigned default NULL,
 `weight` smallint(5) unsigned NOT NULL default '0',
 `attack` smallint(3) unsigned default NULL,
 `defence` tinyint(3) unsigned default NULL,
 `range` tinyint(2) unsigned default NULL,
 `slots` tinyint(2) unsigned default NULL,
 `equip_jobs` int(12) unsigned default NULL,
 `equip_upper` tinyint(8) unsigned default NULL,
 `equip_genders` tinyint(2) unsigned default NULL,
 `equip_locations` smallint(4) unsigned default NULL,
 `weapon_level` tinyint(2) unsigned default NULL,
 `equip_level` tinyint(3) unsigned default NULL,
 `refineable` tinyint(1) unsigned default NULL,
 `view` smallint(3) unsigned default NULL,
 `script` text,
 `equip_script` text,
 `unequip_script` text,
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
#  Items Additional Database - Custom Items go here
#
#  Structure of Database:
#REPLACE INTO `item_db2` VALUES ('ID','Name','Name','Type','Price','Sell','Weight','ATK','DEF','Range','Slot','Job','Upper','Gender','Loc','wLV','eLV','Refineable','View','Script','OnEquip_Script','OnUnequip_Script');
#
#  THQ Quest Items
# =============================================================
# REPLACE INTO `item_db2` VALUES (7950,'THG_Membership','THG Membership',3,NULL,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

And execute it in myphpadmin. (without the "#" in front of the items ofc)

Look at this thread from Mooka about PvP Master Ultimate: http://rathena.org/board/topic/53391-pvp-master-ultimate-v130/

There is a video of the script + execute method.

Edited June 27, 2012 by Ainna

[Peopleperson49]

Mainly because I have around 8,000 custom items. Just the 3,500 custom skill scrolls would take me forever! I need to find a good converter program, which I have yet to do. I have found a few, but they seem to have errors when converting.

Peopleperson49

Edited June 25, 2012 by peopleperson49

[Sharpienero]

Mainly because I have around 8,000 custom items. Just the 3,500 custom skill scrolls would take me forever! I need to find a good converter program, which I have yet to do. I have found a few, but they seem to have errors when converting.

Peopleperson49

8,000? Mother of god.

[Xantara]

Are you looking for a converter or steps on how to upload the query to PMA? o_o;

[Peopleperson49]

Yes I have around 8,000 custom items. I have over 3,500 custom skill scrolls, 300+ custom potions, various other useable items, custom elemental armor (every single armor of every element, do the math there), etc... I have so many that I actually don't have them all added to my server, but my item_db2 is massive! Anyways, I had a lot of time of my hands for a sad eight months when my wife was away... Also this is my second server and I make custom items for pretty much any player that asks if they are reasionalble. Over time you add up a lot of them. Back to myphpadmin... Sorry, but I don't really know what you talking about Zantara. Basically I want to take my item_db2.txt and convert it to item_db2.sql and then upload that to myphpadmin so anybody on my control panel can see what items are in there inventory, instead of saying unknown item. I hope thats more clear. Thanks for replying.

Peopleperson49

After rereading your question Zantara I understand what your asking. I guess I had a stupid moment. Both actually. I am looking for a relaiable converter which I havn't been able to find. With the one I'm trying to use your file size has to be under a certain size. Maybe if I split my item_db2 into several files and then convert them seperately. I can just add them back to one document in a table format. I think anyway. If you have a good one please share. I also need to know how to actually add that to myphpadmin also. Thanks again!

Peopleperson49

Edited June 26, 2012 by peopleperson49

[Xantara]

You can try using this TXT2SQL Converter program: [Xantara]_rA_text2sql_v1.2.0.zip

If you have a lot of commented lines in your TXT file, you might get an error when importing it to your PMA:

- http://rathena.org/b..._db +phpmyadmin

Edited August 16, 2012 by Xantara
Updated text2sql for v1.2.0 download link for rAthena SVN r16639. Use v1.1.0 if using previous revision.

[Peopleperson49]

I will try this when I get home, thanks. I can just use word to sort my items and then remove all commented lines before I convert. Would that help any?

Peopleperson49

[clydelion]

Hi, I took this as a challenge for myself. And alas, I made my own version of converting item_db.txt into a SQL version. It generates a sql file.

Requirement:

PHP (tested on XAMPP)

PS: I tested it on stock rAthena item_db.txt and found no problems generating the sql file. Imported the SQL file using phpmyadmin without any errors. So i think this works

parser2.php

Edited June 28, 2012 by clydelion

[Peopleperson49]

Thanks I will give it a try later when I get home. Is it an actual program that you install and run?

Peopleperson49

[clydelion]

step 1

Upload it to your PHP enable webserver(mine's XAMPP)

step 2

step 3

step 4

input: item_db.txt

output: converted_item_db.sql

It is pretty easy man

Edited June 28, 2012 by clydelion

[Asura]

Hi peopleperson49,

Once you convert the item_db2.txt to SQL-format; you can upload the .sql file onto your VPS and do the following command. I will be assuming that you are going to upload the file in '/root'.

cd /root
mysql -u USERNAME -p, --password=PASSWORD DATABASE_NAME < FILE_NAME.sql

You would have to replace all the capitalized words with the proper values.

[Xantara]

I will try this when I get home, thanks. I can just use word to sort my items and then remove all commented lines before I convert. Would that help any?

Peopleperson49

Yes, that would help. You may not even need too if you do not have a lot of commented lines. Anyways, if you have used my tool and produced errors, please let me know so I can fix it in the next revision. Thanks~

[Peopleperson49]

Xantara your version gives me lots of errors. I even removed all the // first. I put one example below. I got another error, I think it was #1056(not 100% sure). A large majority of my custom items errored if they had a { or } in it. Clydelion yours converts but when you client to view new file I get a 404 error.

SQL query:
REPLACEINTO`item_db2`
VALUES ( 28434,'Purple_Healthshroom','Purple Healthshroom', 0, 40,NULL , 70,NULL ,NULL ,NULL ,NULL , 0xFFFFFFFF, 7, 2,NULL ,NULL ,NULL ,NULL ,NULL ,'set @inchpheal,(readparam(bVit)*1); set @incspheal,(readparam(bInt)*1); for( set @healtime,0; @healtime < 30; set @healtime,@healtime+1 ) { itemheal @inchpheal,@incspheal; sleep2 2000; } dispbottom \"Your healing item has run out.\"; end;'},NULL ,NULL) ;
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '},NULL,NULL)' at line 1

[Xantara]

Thanks for letting me know. Unfortunately, I cannot reproduce that error. The program created a converted file and I ran the query without any errors. May I see that item in regular TXT format? Did your txt version run without problems? Perhaps you have an extra closing bracket in yours?

I used this to test...

6299,Worn_Fabric,Worn Fabric,3,0,,0,,,,,,,,,,,,,{ set @inchpheal,(readparam(bVit)*1); set @incspheal,(readparam(bInt)*1); for( set @healtime,0; @healtime < 30; set @healtime,@healtime+1 ) { itemheal @inchpheal,@incspheal; sleep2 2000; } dispbottom "Your healing item has run out."; end; },{},{}

And this is what my program spit out...

REPLACE INTO `item_db2` VALUES (6299,'Worn_Fabric','Worn Fabric',3,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'set @inchpheal,(readparam(bVit)*1); set @incspheal,(readparam(bInt)*1); for( set @healtime,0; @healtime < 30; set @healtime,@healtime+1 ) { itemheal @inchpheal,@incspheal; sleep2 2000; } dispbottom \"Your healing item has run out.\"; end;',NULL,NULL);

Edited June 30, 2012 by Xantara
omo, so many typos x_x

[clydelion]

@peopleperson49

As miss xantara said, please give us your txt file. So that we can reproduce the error.

@xantara

I tried your program, and it really rocks! Really amazing

[Xantara]

...

@xantara

I tried your program, and it really rocks! Really amazing

Thanks~ I love your source modifications by the way. =D ( Sorry for the late reply, too busy ><;; )