From: <wel...@us...> - 2011-02-28 13:12:02
|
Revision: 7021 http://planeshift.svn.sourceforge.net/planeshift/?rev=7021&view=rev Author: weltall2 Date: 2011-02-28 13:11:56 +0000 (Mon, 28 Feb 2011) Log Message: ----------- script to update to new tables Added Paths: ----------- trunk/tools/faction-convert Added: trunk/tools/faction-convert =================================================================== --- trunk/tools/faction-convert (rev 0) +++ trunk/tools/faction-convert 2011-02-28 13:11:56 UTC (rev 7021) @@ -0,0 +1,31 @@ +#! /usr/bin/php +<?php +//converter for factions from the old faction_standing cvs to a proper database format. +// Change your database settings here: +$db = mysql_connect("localhost", "planeshift", "planeshift") or die ("Unable to connect!"); // host, user, pass +mysql_select_db("planeshift", $db) or die("Could not select database"); + +//loads all the id and faction standing for parsing +$scripts = mysql_query("SELECT id, faction_standings from characters") or die("fatal error: couldn't select stuff: " . mysql_error() . "\n"); +while ($row = mysql_fetch_array($scripts)) +{ + //get the pid of the character and the faction standing in the current format + $pid = $row[0]; + $factions = $row[1]; + //parse the faction list and output sql queries + $factionID = strtok($factions,","); + //if we don't find additional entries we are done + while($factionID != FALSE && $factionID != "") + { + $factionVALUE = strtok(","); + //protection against malformed faction standings + if($factionVALUE == FALSE || $factionVALUE == "") + break; + //add the new faction in the new table + $query = "INSERT INTO character_factions (character_id, faction_id, value) values (".$pid.",".$factionID.",".$factionVALUE.")"; + mysql_query($query); + $factionID = strtok(","); + } +} + +?> Property changes on: trunk/tools/faction-convert ___________________________________________________________________ Added: svn:executable + * Added: svn:mime-type + text/plain Added: svn:eol-style + native This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |
From: <wel...@us...> - 2011-04-27 18:52:05
|
Revision: 7192 http://planeshift.svn.sourceforge.net/planeshift/?rev=7192&view=rev Author: weltall2 Date: 2011-04-27 18:51:59 +0000 (Wed, 27 Apr 2011) Log Message: ----------- fixed comparison to false Modified Paths: -------------- trunk/tools/faction-convert Modified: trunk/tools/faction-convert =================================================================== --- trunk/tools/faction-convert 2011-04-27 18:50:22 UTC (rev 7191) +++ trunk/tools/faction-convert 2011-04-27 18:51:59 UTC (rev 7192) @@ -19,8 +19,10 @@ { $factionVALUE = strtok(","); //protection against malformed faction standings - if($factionVALUE == FALSE || $factionVALUE == "") + if($factionVALUE === FALSE || $factionVALUE == "") + { break; + } //add the new faction in the new table $query = "INSERT INTO character_factions (character_id, faction_id, value) values (".$pid.",".$factionID.",".$factionVALUE.")"; mysql_query($query); This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site. |