rhijaen

Basically I want to auto post to a VBulletin forum when I'm done transferring a file with my ftp client. Can this be done with php? or would another language be more suitable? Can anyone show me some code to get me started?

I used if (!empty($b_p_air)) and it worked..where if ($b_p_air != 0) didn't work

An example of one of the strings is self.true_light *25/100 They are all varchar(50) in the mysql db.

I'm having a problem..some of the values in my array are integer and some are "supposed" to be string. Though I think since the first are integer, when it gets to filling in a string, it knows it's not an integer so it passes 0 to the array value. Here's an example: while($newArray = mysql_fetch_array($result)){ $b_p_light[$count] = $newArray['b_p_light']; $count++; } When it gets to a string, it returns it as 0. How can I fix this to have it all strings or some integer and some string?

Mostly the $b_r_* and $b_p_* don't evaluate to true when comparing them to 0 even though they are 0 in the mysql db. They are varchar(50) in the mysql db. They aren't evaluating to true so they don't get printed. I tried (!empty($b_r_air)) and that is true but it prints nothing..what's wrong? while($newArray = mysql_fetch_array($result)){ $b_attack[$count] = $newArray['b_attack']; $b_dodge[$count] = $newArray['b_dodge']; $b_damage[$count] = $newarray['b_damage']; $b_radiance[$count] = $newarray['b_radiance']; $b_r_air[$count] = $newarray['b_r_air']; $b_r_dark[$count] = $newarray['b_r_dark']; $b_r_earth[$count] = $newarray['b_r_earth']; $b_r_fire[$count] = $newarray['b_r_fire']; $b_r_light[$count] = $newarray['b_r_light']; $b_r_water[$count] = $newarray['b_r_water']; $b_p_air[$count] = $newarray['b_p_air']; $b_p_dark[$count] = $newarray['b_p_dark']; $b_p_earth[$count] = $newarray['b_p_earth']; $b_p_fire[$count] = $newarray['b_p_fire']; $b_p_light[$count] = $newarray['b_p_light']; $b_p_water[$count] = $newarray['b_p_water']; $name[$count] = $newArray['Name']; $equippos[$count] = $newArray['EquipPosition']; $reqstr[$count] = $newArray['req_Strength']; $reqend[$count] = $newArray['req_Endurance']; $reqagi[$count] = $newArray['req_Agility']; $reqwis[$count] = $newArray['req_Wisdom']; $reqint[$count] = $newArray['req_Intelligence']; $reqatt[$count] = $newArray['req_Attack']; $b_str[$count] = $newArray['b_str']; $b_end[$count] = $newArray['b_end']; $b_agi[$count] = $newArray['b_agi']; $b_wis[$count] = $newArray['b_wis']; $b_int[$count] = $newArray['b_int']; $b_luck[$count] = $newArray['b_luck']; $count++; } $items = $count; $count--; print "$count items"; echo "<table width='100%' border='1' cellspacing='0' cellpadding='0'>"; echo "<tr> <th scope='col' align='center'><a href=\"t4citems.php?sort=name\">Name</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=EquipPosition\">Equip Position</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=req_Strength\">Req Strength</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=req_Endurance\">Req Endurance</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=req_Agility\">Req Agility</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=req_Wisdom\">Req Wisdom</a></th> <th scope='col' align='center'><a href=\"t4citems.php?sort=req_Intelligence\">Req Intelligence</a></th> <th scope='col' align='center'>Bonuses</th> </tr>"; $count = 1; while($count < $items){ print "<tr><td><b>$name[$count]</b></td><td><b>$equippos[$count]</b></td><td><b>$reqstr[$count]</b></td><td><b>$reqend[$count]</b></td><td><b>$reqagi[$count]</b></td><td><b>$reqwis[$count]</b></td><td><b>$reqint[$count]</b></td><td><b>"; if ($b_r_air[$count] != 0){ print "($b_r_air[$count] Air Resist) "; } if ($b_r_dark[$count] != 0){ print "($b_r_dark[$count] Dark Resist) "; } if ($b_r_earth[$count] != 0){ print "($b_r_earth[$count] Earth Resist) "; } if ($b_r_fire[$count] != 0){ print "($b_r_fire[$count] Fire Resist) "; } if ($b_r_light[$count] != 0){ print "($b_r_light[$count] Light Resist) "; } if ($b_r_water[$count] != 0){ print "($b_r_water[$count] Water Resist) "; } if ($b_str[$count] != 0){ print "($b_str[$count] Strength) "; } if ($b_end[$count] != 0){ print "($b_end[$count] Endurance) "; } if ($b_agi[$count] != 0){ print "($b_agi[$count] Agility) "; } if ($b_wis[$count] != 0){ print "($b_wis[$count] Wisdom) "; } if ($b_int[$count] != 0){ print "($b_int[$count] Intelligence) "; } if ($b_luck[$count] != 0){ print "($b_luck[$count] Luck) "; } if ($b_attack[$count] != 0){ print "($b_attack[$count] Attack) "; } if ($b_dodge[$count] != 0){ print "($b_dodge[$count] Dodge)"; } if ($b_damage[$count] != 0){ print "($b_damage[$count] Damage) "; } if ($b_radiance[$count] != 0){ print "($b_radiance[$count] Radiance) "; } print "</b></td></tr>"; $count++; } echo "</table>"; ?> </body></html>

I forgot to restart..works perfectly! Thanks

I'm getting this error when trying to import a sql file.. ERROR 2006 (HY000) at line 1: MySQL server has gone away I opened my.cnf and changed the max allowed bytes to 16M even though my file is only about 1M and it still didn't work.. What could the problem be? Here's the first few lines of my .sql INSERT INTO items (`IDString`,`IDNumber`,`Name`,`SkinID`,`ShopType`,`ItemType`,`EquipPosition`,`req_Strength`,`req_Endurance`,`req_Agility`,`req_Wisdom`,`req_Intelligence`,`req_Attack`,`DamageFormula`,`Exhaust`,`ArmorClass`,`Dodge`,`b_int`,`b_end`,`b_str`,`b_wis`,`b_agi`,`b_luck`,`b_attack`,`b_dodge`,`b_damage`,`b_radiance`,`b_r_air`,`b_r_fire`,`b_r_water`,`b_r_earth`,`b_r_light`,`b_r_dark`,`b_p_air`,`b_p_water`,`b_p_fire`,`b_p_earth`,`b_p_light`,`b_p_dark`,`b_StunBlow`,`b_PowerfulBlow`,`b_FirstAid`,`b_Parry`,`b_Meditate`,`b_Hide`,`b_Rob`,`b_Sneak`,`b_Search`,`b_PickLock`,`b_ArmorPenetration`,`b_Peek`,`b_RapidHealing`,`b_Archery`,`Radius`,`Charges`,`JunkAtRemort`,`CannotHide`,`CannotEquip`,`CannotJunk`,`CannotRob`,`CannotDrop`,`IsUnique`,`CanBeSummoned`,`IsRangedWeapon`,`Unlimited`,`Location`,`ReSell`,`Weight`) VALUES ('Steel Chest',41884,'Steel Chest',262,'armor','armor','body',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,true,true,true,true,false,false,true,'Nowhere',0,0), ('Jailer Axe',41886,'Jailer Axe',122,'weapon','weapon','right-handed',0,0,0,0,0,0,'1','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,false,true,false,true,true,true,false,false,false,true,'Nowhere',0,0), ('Jail Sign',41887,'Jail Sign',360,'sign','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,true,true,true,false,true,false,true,'Arakas',0,0), ('GM 1 HAND STAFF',41897,'GM 1 HAND STAFF',295,'weapon','junk','right-handed',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,true,true,true,false,true,false,true,'Arakas',0,0), ('Sign of Teleport',41901,'Sign of Teleport',361,'sign','armor','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,false,true,true,true,true,true,false,true,false,true,'GM Item (reserved)',0,0), ('Dantalir chest',41903,'Dantalir chest',20,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,false,false,false,'Stoneheim',0,10000), ('Oracle bonus chest 1',41905,'Oracle bonus chest 1',41,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,false,false,false,'Oracle zone',0,0), ('Oracle bonus chest 2',41906,'Oracle bonus chest 2',41,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,false,false,false,'Oracle zone',0,0), ('Oracle bonus chest 3',41907,'Oracle bonus chest 3',41,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,false,false,false,'Oracle zone',0,0), ('Oracle bonus chest 4',41908,'Oracle bonus chest 4',41,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,false,false,false,'Oracle zone',0,0), ('Shiny silver key',41910,'Shiny silver key',30,'potion','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,true,false,false,false,true,true,false,true,false,false,'Oracle zone',0,0), ('Temple door tester',41911,'Temple door tester',189,'standard','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,false,true,true,false,false,false,false,false,false,false,'Nowhere',0,0), ('Temple door tester 2',41912,'Temple door tester 2',41,'container','junk','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,false,true,true,false,false,false,false,false,false,false,'Nowhere',0,0), ('Winterbottom Sign',41914,'Winterbottom Sign',348,'sign','potion','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,false,true,true,false,false,false,false,true,false,true,'Arakas',0,0), ('Orealm1stChestEntryLever',41915,'Orealm1stChestEntryLever',189,'standard','armor','none',0,0,0,0,0,0,'0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,-1,false,true,true,false,false,false,false,true,false,true,'Stoneheim',0,0),

Thanks..so many values confused me.. All sorted

INSERT INTO items (IDString,IDNumber,Name,SkinID,ShopType,EquipPosition,req_Strength_req_Endurance,req_Agility,req_Wisdom,req_Intelligence,req_Attack,DamageFormula,Exhaust,ArmorClass,Dodge,b_int,b_end,b_str,b_wis,b_agi,b_luck,b_attack,b_dodge,b_damage,b_radiance,b_r_air,b_r_fire,b_r_water,b_r_earth,b_r_light,b_r_dark,b_p_air,b_p_water,b_p_water,b_p_fire,b_p_earth,b_p_light,b_p_dark,b_StunBlow,b_PowerfulBlow,b_FirstAid,bParry,b_Meditate,b_Hide,b_Rob,b_Sneak,b_Search,b_PickLock,b_ArmorPenetration,b_Peek,b_RapidHealing,b_Archery,Radius,Charges,JunkAtRemort,CannotHide,CannotEquip,CannotJunk,CannotRob,CannotDrop,IsUnique,CanBeSummoned,IsRangedWeapon,Unlimited,Location,ReSell,Weight) VALUES ('Steel Chest',41884,'Steel Chest',262,'armor',,'armor','body',0,0,0,0,0,0,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,0,0,1,'Nowhere',0,0) When trying to insert this into my table with phpmyadmin, I get: #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 ''armor','body',0,0,0,0,0,0,,,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0' at line 2 What am I doing wrong? version 5.0.67-community mysql> SHOW CREATE TABLE items\G *************************** 1. row *************************** Table: items Create Table: CREATE TABLE `items` ( `IDString` varchar(50) NOT NULL, `IDNumber` int(5) NOT NULL, `Name` varchar(50) NOT NULL, `SkinID` int(3) default NULL, `ShopType` varchar(20) default NULL, `ItemType` varchar(20) default NULL, `EquipPosition` enum('body','feet','hands','head','legs','finger','wrist','nec k','right-handed','left-handed','two-handed','waist','back','none') default NULL , `req_Strength` int(5) default NULL, `req_Endurance` int(5) default NULL, `req_Agility` int(5) default NULL, `req_Wisdom` int(5) default NULL, `req_Intelligence` int(5) default NULL, `req_Attack` int(5) default NULL, `DamageFormula` varchar(100) default NULL, `Exhaust` varchar(100) default NULL, `ArmorClass` decimal(3,3) default NULL, `Dodge` int(5) default NULL, `b_int` varchar(50) default NULL, `b_end` varchar(50) default NULL, `b_str` varchar(50) default NULL, `b_wis` varchar(50) default NULL, `b_agi` varchar(50) default NULL, `b_luck` varchar(50) default NULL, `b_attack` varchar(50) default NULL, `b_dodge` varchar(50) default NULL, `b_damage` varchar(50) default NULL, `b_radiance` varchar(50) default NULL, `b_r_air` varchar(50) default NULL, `b_r_fire` varchar(50) default NULL, `b_r_water` varchar(50) default NULL, `b_r_earth` varchar(50) default NULL, `b_r_light` varchar(50) default NULL, `b_r_dark` varchar(50) default NULL, `b_p_air` varchar(50) default NULL, `b_p_water` varchar(50) default NULL, `b_p_fire` varchar(50) default NULL, `b_p_earth` varchar(50) default NULL, `b_p_light` varchar(50) default NULL, `b_p_dark` varchar(50) default NULL, `b_StunBlow` varchar(50) default NULL, `b_PowerfulBlow` varchar(50) default NULL, `b_FirstAid` varchar(50) default NULL, `b_Parry` varchar(50) default NULL, `b_Meditate` varchar(50) default NULL, `b_Hide` varchar(50) default NULL, `b_Rob` varchar(50) default NULL, `b_Sneak` varchar(50) default NULL, `b_Search` varchar(50) default NULL, `b_PickLock` varchar(50) default NULL, `b_ArmorPenetration` varchar(50) default NULL, `b_Peek` varchar(50) default NULL, `b_RapidHealing` varchar(50) default NULL, `b_Archery` varchar(50) default NULL, `Radius` int(2) default NULL, `Charges` int(5) default NULL, `JunkAtRemort` tinyint(1) default NULL, `CannotHide` tinyint(1) default NULL, `CannotEquip` tinyint(1) default NULL, `CannotJunk` tinyint(1) default NULL, `CannotRob` tinyint(1) default NULL, `CannotDrop` tinyint(1) default NULL, `IsUnique` tinyint(1) default NULL, `CanBeSummoned` tinyint(1) default NULL, `IsRangedWeapon` tinyint(1) default NULL, `Unlimited` tinyint(1) default NULL, `Location` varchar(50) default NULL, `ReSell` int(9) default NULL, `Weight` int(2) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1