function jotform_db2dump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
// CREATE TABLE STATEMENT
$table = mysql_fieldname_format($formTitle);
$sql .= "IF NOT EXISTS (SELECT NAME FROM SYSIBM.SYSTABLES WHERE NAME=`" . $table . "`)\nTHEN\n";
$sql .= "CREATE TABLE `" . $table . "`(\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t`" . mysql_fieldname_format($questions[$i]['text']) . "` " . $mysql_type);
}
$sql .= "\t`submissionID` BIGINT,\n";
$sql .= implode(",\n", $fields_sql);
$sql .= ",\n\tPRIMARY KEY(submissionID)";
$sql .= ")\nEND IF\n";
// INSERT / REPLACE STATEMENT
foreach ($submissions as $s) {
$insert = "INSERT IGNORE INTO `{$table}` (\n";
$keys = array("`submissionID`");
$values = array($s["id"]);
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, "`" . mysql_fieldname_format($k) . "`");
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "'" . my_mysql_real_escape_string($a) . "'");
}
}
$insert .= implode(", ", $keys);
$insert .= "\n) VALUES (\n";
$insert .= implode(", ", $values);
$insert .= "\n);\n\n";
$sql .= $insert;
}
return $sql;
}
function jotform_postgresqldump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
// CREATE TABLE STATEMENT
$table = mysql_fieldname_format($formTitle);
$sql .= "CREATE TABLE IF NOT EXISTS \"" . $table . "\" (\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t\"" . mysql_fieldname_format($questions[$i]['text']) . "\" " . $mysql_type);
}
$sql .= "\t\"submissionID\" bigserial primary key,\n";
$sql .= implode(",\n", $fields_sql);
$sql .= "\n);\n\n";
// INSERT / REPLACE STATEMENT
foreach ($submissions as $s) {
$insert = "INSERT INTO \"" . $table . "\" (";
$keys = array("\"submissionID\"");
$values = array($s["id"]);
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, "\"" . mysql_fieldname_format($k) . "\"");
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "'" . my_mysql_real_escape_string($a) . "'");
}
}
$insert .= implode(", ", $keys);
$insert .= ")\nVALUES (";
$insert .= implode(", ", $values);
$insert .= ");\n\n";
$sql .= $insert;
}
return $sql;
}
function jotform_mongodbdump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
$fields = array();
foreach ($ordered_questions as $order => $i) {
array_push($fields, $questions[$i]['text']);
}
$sql = array();
foreach ($submissions as $s) {
$insert = array();
$keys = array("submission_id");
$values = array($s["id"]);
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, "" . mysql_fieldname_format($k) . "");
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "" . my_mysql_real_escape_string($a) . "");
}
}
for ($i = 0; $i < count($keys); $i++) {
$insert[$keys[$i]] = $values[$i];
}
array_push($sql, $insert);
}
return $sql;
}
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_workId = my_get_post_or_null('workId');
$p_externalId = my_get_post_or_null('externalId');
$p_externalCode = my_get_post_or_null('externalCode');
my_mysql_start_transaction();
$query = sprintf('insert into TbWkWorkExternal (workId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_externalCode));
my_mysql_query($query);
$p_workexternalid = my_mysql_insert_id();
my_mysql_commit();
echo "new external successfully inserted with id [{$p_workexternalid}]";
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_name = my_get_post_or_null('name');
$p_typeId = my_get_post_or_null('typeId');
$p_languageId = my_get_post_or_null('languageId');
my_mysql_start_transaction();
$query = sprintf('insert into TbWkWork (name,typeId,languageId) values(%s,%s,%s)', my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_languageId));
my_mysql_query($query);
$p_workid = my_mysql_insert_id();
my_mysql_commit();
echo "new work successfully inserted with id [{$p_workid}]";
$p_remark = my_get_post('remark');
$p_ratingId = my_get_post('ratingId');
$p_review = my_get_post('review');
// this is a line you can use for debugging...
//error('query not yet implemented');
//
my_mysql_start_transaction();
$p_typeId = my_mysql_query_one('select id from TbWkWorkType where name=\'video movie\'');
$p_externalId = my_mysql_query_one('select id from TbExternalType where name=\'imdb_title_id\'');
// insert the actual work
$query = sprintf('insert into TbWkWork (name,typeId) values(%s,%s)', my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_typeId));
my_mysql_query($query);
$p_workId = my_mysql_insert_id();
// insert an external imdb id
$query = sprintf('insert into TbWkWorkExternal (workId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_imdbid));
my_mysql_query($query);
$p_externalId = my_mysql_insert_id();
// insert a new view
$query = sprintf('insert into TbWkWorkView (endViewDate,locationId,deviceId,workId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_deviceId), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_remark));
my_mysql_query($query);
$p_workviewid = my_mysql_insert_id();
// insert the viewer
$query = sprintf('insert into TbWkWorkViewPerson (viewerId,viewId) values(%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_workviewid));
my_mysql_query($query);
$p_workviewpersonid = my_mysql_insert_id();
// insert a new review
$query = sprintf('insert into TbWkWorkReview (ratingId,review,reviewDate,workId,reviewerId) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_ratingId), my_mysql_real_escape_string($p_review), my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_personId));
my_mysql_query($query);
$p_workreviewid = my_mysql_insert_id();
my_mysql_commit();
echo "new work [{$p_workId}], external [{$p_externalId}], view [{$p_workviewid}], viewperson[{$p_workviewpersonid}], review [{$p_workreviewid}] successfully inserted";
function jotform_sqlserverdump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
// CREATE TABLE STATEMENT
$table = mysql_fieldname_format($formTitle);
$sql .= "IF NOT EXISTS\n(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID('" . $table . "') AND type in (N'U'))\nBEGIN\n";
$sql .= "CREATE TABLE " . $table . "\n(\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t" . mysql_fieldname_format($questions[$i]['text']) . " " . $mysql_type);
}
$sql .= "\tsubmissionID bigint PRIMARY KEY,\n";
$sql .= implode(",\n", $fields_sql);
$sql .= "\n);";
$sql .= "\nEND";
$sql .= "\nGO\n\n";
// INSERT / REPLACE STATEMENT
foreach ($submissions as $s) {
$insert = "IF NOT EXISTS\n(SELECT * FROM " . $table . " WHERE submissionID=" . $s["id"] . ")\n";
$insert .= "\tINSERT INTO " . $table . "(";
$keys = array("submissionID");
$values = array($s["id"]);
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, mysql_fieldname_format($k));
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "'" . my_mysql_real_escape_string($a) . "'");
}
}
$insert .= implode(", ", $keys);
$insert .= ")\n\tVALUES (";
$insert .= implode(", ", $values);
$insert .= ")\nELSE\n";
$insert .= "\tUPDATE " . $table . "\n\tSET ";
for ($i = 1; $i < count($keys); $i++) {
$insert .= $keys[$i] . "=" . $values[$i];
if ($i < count($keys) - 1) {
$insert .= ", ";
}
}
$insert .= "\n\tWHERE submissionID=" . $s["id"] . "\n\n";
$sql .= $insert;
}
return $sql;
}
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_honorificId = my_get_post_or_null('honorificId');
$p_firstname = my_get_post_or_null('firstname');
$p_surname = my_get_post_or_null('surname');
$p_othername = my_get_post_or_null('othername');
$p_ordinal = my_get_post_or_null('ordinal');
$p_remark = my_get_post_or_null('remark');
my_mysql_start_transaction();
$query = sprintf('insert into TbIdPerson (honorificId,firstname,surname,othername,ordinal,remark) values(%s,%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_honorificId), my_mysql_real_escape_string($p_firstname), my_mysql_real_escape_string($p_surname), my_mysql_real_escape_string($p_othername), my_mysql_real_escape_string($p_ordinal), my_mysql_real_escape_string($p_remark));
my_mysql_query($query);
$p_id = my_mysql_insert_id();
my_mysql_commit();
echo 'new person successfully inserted with id [' . $p_id . ']';
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_personId = my_get_post_or_null('personId');
$p_externalId = my_get_post_or_null('externalId');
$p_externalCode = my_get_post_or_null('externalCode');
my_mysql_start_transaction();
$query = sprintf('insert into TbIdPersonExternal (personId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_externalCode));
my_mysql_query($query);
$p_personexternalid = my_mysql_insert_id();
my_mysql_commit();
echo "new external successfully inserted with id [{$p_personexternalid}]";
function create_database($convert_version = FALSE)
{
global $s, $VIDSRC;
$conn = my_mysql_connect($s['MYSQL_HOST'], $s['MYSQL_USER'], $s['MYSQL_PASS']);
$dbs = my_mysql_select_db($s['MYSQL_DBNAME'], $conn);
if (!$conn || !$dbs) {
return FALSE;
}
my_mysql_query('SET NAMES utf8', $conn);
$v = $convert_version;
if ($v == '2.1.0') {
return TRUE;
}
if ($v && $v < '2.1.0') {
my_mysql_query('CREATE TABLE `sphinx_delta_ndx_counter` (
`index_name` enum("posts","comments","tags","users","groups") NOT NULL PRIMARY KEY,
`last_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8', $conn);
my_mysql_query('INSERT INTO `sphinx_delta_ndx_counter` (`index_name`,`last_id`)
VALUES ("posts",0), ("comments",0), ("tags", 0), ("users", 0), ("groups", 0) ', $conn);
my_mysql_query('ALTER TABLE `users` ADD INDEX ( `num_followers` )', $conn);
my_mysql_query('CREATE TABLE `post_tags` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`tag_name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,
`user_id` INT( 10 ) UNSIGNED NOT NULL,
`group_id` INT( 10 ) UNSIGNED NOT NULL,
`post_id` INT( 10 ) UNSIGNED NOT NULL ,
`date` INT( 10 ) UNSIGNED NOT NULL,
PRIMARY KEY ( `id` ),
INDEX (tag_name)
) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci', $conn);
my_mysql_query('UPDATE applications SET detect="twitter" WHERE id=8 LIMIT 1', $conn);
}
if ($v == '2.0.0') {
return TRUE;
}
if ($v && $v < '2.0.0') {
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("POST_TYPES_TO_AUTODELETE", "feed")', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("POST_TYPES_DELETE_PERIOD", "14")', $conn);
my_mysql_query('ALTER TABLE `users_details` ADD `integr_twitter` VARCHAR( 255 ) NOT NULL', $conn);
my_mysql_query('ALTER TABLE `users_details` ADD `extrnlusr_twitter` VARCHAR( 255 ) NOT NULL', $conn);
my_mysql_query('ALTER TABLE `users_details` ADD `integr_facebook` VARCHAR( 255 ) NOT NULL', $conn);
my_mysql_query('ALTER TABLE `users_details` ADD `extrnlusr_facebook` VARCHAR( 255 ) NOT NULL', $conn);
my_mysql_query('INSERT INTO applications( `name` , `detect`, `total_posts` ) VALUES (\'<a href="http://twitter.com/" target="_blank">Twitter</a>\', "twitter", 0)', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("POST_FROM_TWITTER_TAG", "0")', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("LAST_TWITTER_POST_ID", "0")', $conn);
my_mysql_query('ALTER TABLE `posts` ADD `likes` smallint(5) UNSIGNED NOT NULL DEFAULT "0" AFTER `reshares`', $conn);
my_mysql_query('ALTER TABLE `users_notif_rules` ADD `ntf_me_on_post_like` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT "0" COMMENT "0-off, 3-email"', $conn);
my_mysql_query('CREATE TABLE `post_likes` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`user_id` INT( 10 ) UNSIGNED NOT NULL ,
`post_id` INT( 10 ) UNSIGNED NOT NULL ,
`date` INT( 10 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;', $conn);
}
if ($v == '1.5.4') {
return TRUE;
}
if ($v && $v < '1.5.4') {
my_mysql_query('UPDATE `applications` SET `name` = "<a href=\'http://www.getspaz.com/\' target=\'_blank\'>Spaz</a>" WHERE `applications`.`id`=7', $conn);
my_mysql_query('ALTER TABLE `groups` ADD `is_special` TINYINT( 1 ) unsigned NOT NULL DEFAULT "0" AFTER `is_public`', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("PROTECT_OUTSIDE_PAGES", "0")', $conn);
my_mysql_query('ALTER TABLE `users` ADD `is_profile_protected` TINYINT( 1 ) unsigned NOT NULL DEFAULT "0" AFTER `is_network_admin`', $conn);
my_mysql_query('ALTER TABLE `users` ADD `is_posts_protected` TINYINT( 1 ) unsigned NOT NULL DEFAULT "0" AFTER `is_network_admin`', $conn);
my_mysql_query('ALTER TABLE `users` ADD `is_dm_protected` TINYINT( 1 ) unsigned NOT NULL DEFAULT "0" AFTER `is_network_admin`', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("SUPPORTED_EMAIL_DOMAINS", "0")', $conn);
my_mysql_query('INSERT INTO `settings` (`word`, `value`) VALUES ("API_STATUS", "1")', $conn);
}
if ($v == '1.5.3') {
return TRUE;
}
if ($v == '1.5.2') {
return TRUE;
}
if ($v && $v < '1.5.2') {
my_mysql_query('ALTER TABLE `users_dashboard_tabs` CHANGE `tab` `tab` ENUM( \'\', \'all\', \'@me\', \'private\', \'commented\', \'feeds\', \'tweets\' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL', $conn);
}
if ($v == '1.5.1') {
return TRUE;
}
if ($v && $v < '1.5.1') {
my_mysql_query('ALTER TABLE `applications` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL', $conn);
my_mysql_query('UPDATE applications SET name=\'<a href="http://www.tweetdeck.com/" target="_blank">tweetdeck</a>\' WHERE id=5', $conn);
my_mysql_query('ALTER TABLE `applications` ADD `detect` VARCHAR( 50 ) NOT NULL AFTER `name`', $conn);
my_mysql_query('REPLACE INTO applications(id, name, total_posts, detect) VALUES(7, \'<a href="http://getspaz.com/" target="_blank">Spaz</a>\', 0, "spaz")', $conn);
}
if ($v == '1.5.0' || $v == '1.5') {
return TRUE;
}
if ($v && $v < '1.5.0') {
my_mysql_query('ALTER TABLE `applications` ADD `suspended` tinyint(1) unsigned NOT NULL default "0" ', $conn);
my_mysql_query('ALTER TABLE `oauth_access_token` ADD `rate_limits` int(5) NOT NULL, ADD `rate_limits_date` int(5) NOT NULL', $conn);
my_mysql_query('ALTER TABLE `oauth_access_token` ADD INDEX `consumer_key` (`consumer_key`) ', $conn);
my_mysql_query('ALTER TABLE `oauth_request_token` ADD INDEX `request_token` (`request_token`) ', $conn);
my_mysql_query('ALTER TABLE `posts` ADD `reshares` smallint(5) unsigned NOT NULL default "0" ', $conn);
my_mysql_query('ALTER TABLE `post_userbox` ADD `id` BIGINT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ', $conn);
my_mysql_query('ALTER TABLE `post_userbox_feeds` ADD `id` BIGINT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST ', $conn);
my_mysql_query('ALTER TABLE `users_pageviews` ADD INDEX ( `date` )', $conn);
my_mysql_query('ALTER TABLE `groups_rssfeeds` ADD `hub_url` VARCHAR( 255 ) NOT NULL AFTER `date_last_item` ', $conn);
my_mysql_query('ALTER TABLE `groups_rssfeeds` ADD `hub_lastping` INT( 10 ) UNSIGNED NOT NULL DEFAULT "0" AFTER `hub_url` ', $conn);
my_mysql_query('ALTER TABLE `users_rssfeeds` ADD `hub_url` VARCHAR( 255 ) NOT NULL AFTER `date_last_item` ', $conn);
my_mysql_query('ALTER TABLE `users_rssfeeds` ADD `hub_lastping` INT( 10 ) UNSIGNED NOT NULL DEFAULT "0" AFTER `hub_url` ', $conn);
my_mysql_query('ALTER TABLE `users_rssfeeds` ADD `is_twitter` TINYINT( 1 ) NOT NULL DEFAULT "0" AFTER `is_deleted` ', $conn);
my_mysql_query('INSERT INTO applications(`id`, `name`, `total_posts`) VALUES(4, "api", 0), (5, \'<a href="http://www.tweetdeck.com/" target="_blank">tweetdeck</a>\', 0), (6, "twitter", 0);', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `ip_rates_limit` (
`id` int(10) NOT NULL auto_increment,
`ip` bigint(12) NOT NULL,
`rate_limits` int(10) NOT NULL,
`rate_limits_date` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `ip_rates_limit` (
`id` int(10) NOT NULL auto_increment,
`ip` bigint(12) NOT NULL,
`rate_limits` int(10) NOT NULL,
`rate_limits_date` int(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE `posts_reshares` (
`id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`post_id` INT( 10 ) UNSIGNED NOT NULL,
`user_id` INT( 10 ) UNSIGNED NOT NULL,
`date` INT( 10 ) UNSIGNED NOT NULL,
PRIMARY KEY (`id`),
KEY ( `post_id` )
) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `pubsubhubbub_subscriptions` (
`id` int(10) unsigned NOT NULL auto_increment,
`feed_url` varchar(500) collate utf8_unicode_ci NOT NULL,
`status` varchar(100) collate utf8_unicode_ci NOT NULL,
`last_status_date` int(10) unsigned NOT NULL,
`parse_needed` tinyint(1) unsigned NOT NULL default "0",
PRIMARY KEY (`id`),
KEY `feed_url` (`feed_url`(333)),
KEY `status` (`status`),
KEY `parse_needed` (`parse_needed`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `post_userbox_tweets` (
`id` BIGINT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,
`user_id` INT( 10 ) UNSIGNED NOT NULL ,
`post_id` INT( 10 ) UNSIGNED NOT NULL ,
PRIMARY KEY (`id`),
INDEX ( `user_id` , `post_id` )
) ENGINE = MYISAM;
', $conn);
}
if ($v == '1.4.2') {
return TRUE;
}
if ($v && $v < '1.4.2') {
my_mysql_query('ALTER TABLE `posts` ADD INDEX `api_user_IDX` ( `api_id` , `user_id` )', $conn);
my_mysql_query('ALTER TABLE `posts_attachments` ADD INDEX `post_type_IDX` ( `post_id` , `type` )', $conn);
my_mysql_query('ALTER TABLE `posts_comments` ADD FULLTEXT (`message`)', $conn);
my_mysql_query('ALTER TABLE `posts_comments_watch` ADD INDEX `user_post_IDX` ( `user_id` , `post_id` )', $conn);
my_mysql_query('ALTER TABLE `posts_pr_attachments` ADD INDEX `post_type_IDX` ( `post_id` , `type` )', $conn);
my_mysql_query('ALTER TABLE `posts_pr_comments_watch` ADD INDEX `user_post_IDX` ( `user_id` , `post_id` )', $conn);
my_mysql_query('ALTER TABLE `post_userbox` ADD INDEX `user_post_IDX` ( `user_id` , `post_id` )', $conn);
my_mysql_query('ALTER TABLE `users` ADD INDEX `pass_reset_IDX` ( `pass_reset_key` , `pass_reset_valid` )', $conn);
}
if ($v == '1.4.1') {
return TRUE;
}
if ($v == '1.4.0') {
return TRUE;
}
if ($v && $v < '1.4.0') {
my_mysql_query("REPLACE INTO `settings` SET `word`='THEME', `value`='default' ", $conn);
my_mysql_query('RENAME TABLE `post_api` TO `applications`', $conn);
my_mysql_query('ALTER TABLE `applications` CHANGE `id` `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT', $conn);
my_mysql_query('
ALTER TABLE `applications`
ADD `app_id` int(10) unsigned NOT NULL,
ADD `user_id` int(10) unsigned NOT NULL,
ADD `consumer_key` varchar(1000) collate utf8_unicode_ci NOT NULL,
ADD `consumer_secret` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `callback_url` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `avatar` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `description` text collate utf8_unicode_ci NOT NULL,
ADD `app_website` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `organization` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `website` varchar(100) collate utf8_unicode_ci NOT NULL,
ADD `app_type` enum("","browser","client") collate utf8_unicode_ci NOT NULL,
ADD `acc_type` enum("","r","rw") collate utf8_unicode_ci NOT NULL,
ADD `use_for_login` tinyint(1) unsigned NOT NULL,
ADD `reg_date` int(10) unsigned NOT NULL,
ADD `reg_ip` bigint(10) unsigned NOT NULL
', $conn);
my_mysql_query('ALTER TABLE `applications` ADD INDEX ( `app_id` ) ', $conn);
my_mysql_query('ALTER TABLE `applications` ADD INDEX ( `consumer_key` ) ', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `oauth_access_token` (
`id` int(10) unsigned NOT NULL auto_increment,
`app_id` int(10) unsigned NOT NULL,
`consumer_key` varchar(255) collate utf8_unicode_ci NOT NULL,
`time_stamp` bigint(20) NOT NULL,
`version` varchar(10) collate utf8_unicode_ci NOT NULL,
`nonce` varchar(255) collate utf8_unicode_ci NOT NULL,
`access_token` varchar(255) collate utf8_unicode_ci NOT NULL,
`token_secret` varchar(255) collate utf8_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`user_verified` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `oauth_log` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`app_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`date` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `app_id` (`app_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
my_mysql_query('
CREATE TABLE IF NOT EXISTS `oauth_request_token` (
`id` int(10) unsigned NOT NULL auto_increment,
`consumer_key` varchar(255) collate utf8_unicode_ci NOT NULL,
`nonce` varchar(255) collate utf8_unicode_ci NOT NULL,
`time_stamp` bigint(20) NOT NULL,
`version` varchar(10) collate utf8_unicode_ci NOT NULL,
`token_secret` varchar(100) collate utf8_unicode_ci NOT NULL,
`request_token` varchar(100) collate utf8_unicode_ci NOT NULL,
`verifier` varchar(100) collate utf8_unicode_ci NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
}
if ($v == '1.3.0') {
return TRUE;
}
if ($v == '1.2.2' || $v == '1.2.1' || $v == '1.2.0') {
return TRUE;
}
if ($v && $v < '1.2.0') {
my_mysql_query('ALTER TABLE `users` ADD `twitter_uid` VARCHAR( 32 ) NOT NULL AFTER `facebook_uid` ', $conn);
my_mysql_query("\n\t\t\t\tCREATE TABLE `email_change_requests` (\n\t\t\t\t `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n\t\t\t\t `user_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t `new_email` VARCHAR( 100 ) NOT NULL ,\n\t\t\t\t `confirm_key` VARCHAR( 32 ) NOT NULL ,\n\t\t\t\t `confirm_valid` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t INDEX ( `user_id` , `confirm_key` )\n\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n\t\t\t", $conn);
}
if ($v == '1.1.0') {
return TRUE;
}
if ($v == '1.0.4' || $v == '1.0.3') {
my_mysql_query("ALTER TABLE `posts` ADD INDEX (`api_id`) ", $conn);
return TRUE;
}
if ($v == '1.0.2' || $v == '1.0.1' || $v == '1.0.0') {
my_mysql_query("REPLACE INTO `settings` SET `word`='USERS_EMAIL_CONFIRMATION', `value`='1' ", $conn);
my_mysql_query("ALTER TABLE `posts` ADD INDEX (`api_id`) ", $conn);
return TRUE;
}
$prefix = '';
if ($convert_version) {
$prefix = substr(md5(rand() . time()), 0, rand(5, 8)) . '__';
}
$res = TRUE;
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "applications`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "applications` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `name` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `detect` varchar(50) collate utf8_unicode_ci NOT NULL,\n\t\t\t `total_posts` int(10) unsigned NOT NULL,\n\t\t\t `app_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `consumer_key` varchar(1000) collate utf8_unicode_ci NOT NULL,\n\t\t\t `consumer_secret` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `callback_url` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `avatar` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `description` text collate utf8_unicode_ci NOT NULL,\n\t\t\t `app_website` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `organization` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `website` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `app_type` enum('','browser','client') collate utf8_unicode_ci NOT NULL,\n\t\t\t `acc_type` enum('','r','rw') collate utf8_unicode_ci NOT NULL,\n\t\t\t `use_for_login` tinyint(1) unsigned NOT NULL,\n\t\t\t `reg_date` int(10) unsigned NOT NULL,\n\t\t\t `reg_ip` bigint(10) unsigned NOT NULL,\n\t\t\t `suspended` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `app_id` (`app_id`),\n\t\t\t KEY `consumer_key` (`consumer_key`(333))\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tINSERT INTO `" . $prefix . "applications` (`id`, `name`, `total_posts`) VALUES\n\t\t\t(1, 'mobi', 0),\n\t\t\t(2, 'RSS', 0),\n\t\t\t(3, 'email', 0),\n\t\t\t(4, 'web', 0);\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tUPDATE `" . $prefix . "applications` SET id=0 WHERE id=4 LIMIT 1;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tALTER TABLE `" . $prefix . "applications` AUTO_INCREMENT=4;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tINSERT INTO `" . $prefix . "applications` (`id`, `name`, `total_posts`, `detect`) VALUES\n\t\t\t(4, 'api', 0, ''),\n\t\t\t(5, '<a href=\"http://www.tweetdeck.com/\" target=\"_blank\">tweetdeck</a>', 0, ''),\n\t\t\t(6, 'twitter', 0, ''),\n\t\t\t(7, '<a href=\"http://getspaz.com/\" target=\"_blank\">Spaz</a>', 0, 'spaz'),\n\t\t\t(8, '<a href=\"http://twitter.com/\" target=\"_blank\">Twitter</a>', 0, 'twitter');\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "cache`;\n\t\t", $conn);
$varchar_len = 255;
$ver = my_mysql_get_server_info($conn);
$ver = str_replace('.', '', substr($ver, 0, 5));
if (intval($ver) >= 503) {
$varchar_len = 21810;
}
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "cache` (\n\t\t\t `key` varchar(32) NOT NULL,\n\t\t\t `data` varchar(" . $varchar_len . ") NOT NULL,\n\t\t\t `expire` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`key`)\n\t\t\t) ENGINE=MEMORY DEFAULT CHARSET=utf8;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "crons`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "crons` (\n\t\t\t `cron` varchar(10) collate utf8_unicode_ci NOT NULL,\n\t\t\t `last_run` int(10) unsigned NOT NULL,\n\t\t\t `next_run` int(10) unsigned NOT NULL,\n\t\t\t `is_running` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`cron`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "email_change_requests`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "email_change_requests` (\n\t\t\t `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n\t\t\t `user_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t `new_email` VARCHAR( 100 ) NOT NULL ,\n\t\t\t `confirm_key` VARCHAR( 32 ) NOT NULL ,\n\t\t\t `confirm_valid` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t INDEX ( `user_id` , `confirm_key` )\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `groupname` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `title` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `avatar` varchar(200) collate utf8_unicode_ci NOT NULL,\n\t\t\t `about_me` varchar(200) collate utf8_unicode_ci NOT NULL,\n\t\t\t `is_public` tinyint(1) unsigned NOT NULL,\n\t\t\t `is_special` tinyint(1) unsigned NOT NULL,\n\t\t\t `num_posts` int(10) unsigned NOT NULL default '0',\n\t\t\t `num_followers` int(10) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t UNIQUE KEY `groupname` (`groupname`),\n\t\t\t KEY `is_public` (`is_public`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_admins`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_admins` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `group_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `group_id` (`group_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_deleted`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_deleted` (\n\t\t\t `id` int(10) unsigned NOT NULL,\n\t\t\t `groupname` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `title` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `is_public` tinyint(1) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `is_public` (`is_public`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_followed`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_followed` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `group_id` int(10) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `group_from_postid` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `group_id` (`group_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_private_members`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_private_members` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `group_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `invited_by` int(10) unsigned NOT NULL,\n\t\t\t `invited_date` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `group_id` (`group_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_rssfeeds`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_rssfeeds` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `group_id` int(10) unsigned NOT NULL,\n\t\t\t `feed_url` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `feed_userpwd` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `feed_title` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `filter_keywords` varchar(1000) collate utf8_unicode_ci NOT NULL,\n\t\t\t `date_added` int(10) unsigned NOT NULL,\n\t\t\t `date_last_post` int(10) unsigned NOT NULL,\n\t\t\t `date_last_crawl` int(10) unsigned NOT NULL,\n\t\t\t `date_last_item` int(10) unsigned NOT NULL,\n\t\t\t `hub_url` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `hub_lastping` int(10) unsigned NOT NULL default '0',\n\t\t\t `added_by_user` int(10) unsigned NOT NULL,\n\t\t\t `is_deleted` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `group_id` (`is_deleted`,`group_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "groups_rssfeeds_posts`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "groups_rssfeeds_posts` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `rssfeed_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `rssfeed_id` (`rssfeed_id`),\n\t\t\t KEY `post_id` (`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "invitation_codes`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "invitation_codes` (\n\t\t\t `code` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `user_id` int(10) NOT NULL,\n\t\t\t PRIMARY KEY (`code`),\n\t\t\t KEY `network_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "ip_rates_limit`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "ip_rates_limit` (\n\t\t\t `id` int(10) NOT NULL auto_increment,\n\t\t\t `ip` bigint(12) NOT NULL,\n\t\t\t `rate_limits` int(10) NOT NULL,\n\t\t\t `rate_limits_date` int(10) NOT NULL,\n\t\t\t PRIMARY KEY (`id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "oauth_access_token`;\n\t\t", $conn);
$res = $res && my_mysql_query('
CREATE TABLE `' . $prefix . 'oauth_access_token` (
`id` int(10) unsigned NOT NULL auto_increment,
`app_id` int(10) unsigned NOT NULL,
`consumer_key` varchar(255) collate utf8_unicode_ci NOT NULL,
`time_stamp` bigint(20) NOT NULL,
`version` varchar(10) collate utf8_unicode_ci NOT NULL,
`nonce` varchar(255) collate utf8_unicode_ci NOT NULL,
`access_token` varchar(255) collate utf8_unicode_ci NOT NULL,
`token_secret` varchar(255) collate utf8_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`user_verified` tinyint(1) NOT NULL,
`rate_limits` int(5) NOT NULL,
`rate_limits_date` int(5) NOT NULL,
PRIMARY KEY (`id`),
KEY `consumer_key` (`consumer_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "oauth_log`;\n\t\t", $conn);
$res = $res && my_mysql_query('
CREATE TABLE `' . $prefix . 'oauth_log` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`app_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`date` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `app_id` (`app_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "oauth_request_token`;\n\t\t", $conn);
$res = $res && my_mysql_query('
CREATE TABLE `' . $prefix . 'oauth_request_token` (
`id` int(10) unsigned NOT NULL auto_increment,
`consumer_key` varchar(255) collate utf8_unicode_ci NOT NULL,
`nonce` varchar(255) collate utf8_unicode_ci NOT NULL,
`time_stamp` bigint(20) NOT NULL,
`version` varchar(10) collate utf8_unicode_ci NOT NULL,
`token_secret` varchar(100) collate utf8_unicode_ci NOT NULL,
`request_token` varchar(100) collate utf8_unicode_ci NOT NULL,
`verifier` varchar(100) collate utf8_unicode_ci NOT NULL,
`user_id` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
KEY `request_token` (`request_token`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
', $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `api_id` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `group_id` int(10) unsigned NOT NULL,\n\t\t\t `message` varchar(1000) collate utf8_unicode_ci NOT NULL,\n\t\t\t `mentioned` tinyint(2) unsigned NOT NULL default '0',\n\t\t\t `attached` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `posttags` tinyint(2) unsigned NOT NULL default '0',\n\t\t\t `comments` smallint(4) unsigned NOT NULL default '0',\n\t\t\t `reshares` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `likes` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `date_lastedit` int(10) NOT NULL,\n\t\t\t `date_lastcomment` int(10) NOT NULL,\n\t\t\t `ip_addr` bigint(10) NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `group_id` (`group_id`),\n\t\t\t KEY `api_id` (`api_id`),\n\t\t\t KEY `api_user_IDX` (`api_id`,`user_id`),\n\t\t\t FULLTEXT KEY `message` (`message`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_attachments`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_attachments` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `type` enum('link','image','videoembed','videoupload','text','file') collate utf8_unicode_ci NOT NULL,\n\t\t\t `data` text collate utf8_unicode_ci NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `type` (`type`),\n\t\t\t KEY `post_type_IDX` (`post_id`,`type`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_comments`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_comments` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `api_id` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `message` text collate utf8_unicode_ci NOT NULL,\n\t\t\t `mentioned` tinyint(2) unsigned NOT NULL,\n\t\t\t `posttags` tinyint(2) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `ip_addr` bigint(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t FULLTEXT KEY `message` (`message`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_comments_mentioned`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_comments_mentioned` (\n\t\t\t `id` int(10) NOT NULL auto_increment,\n\t\t\t `comment_id` int(10) NOT NULL,\n\t\t\t `user_id` int(10) NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `comment_id` (`comment_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_comments_watch`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_comments_watch` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `newcomments` smallint(5) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `user_post_IDX` (`user_id`,`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_mentioned`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_mentioned` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `api_id` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `to_user` int(10) unsigned NOT NULL,\n\t\t\t `message` varchar(1000) collate utf8_unicode_ci NOT NULL,\n\t\t\t `mentioned` tinyint(2) unsigned NOT NULL default '0',\n\t\t\t `attached` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `posttags` tinyint(2) unsigned NOT NULL default '0',\n\t\t\t `comments` smallint(4) unsigned NOT NULL default '0',\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `date_lastedit` int(10) NOT NULL,\n\t\t\t `date_lastcomment` int(10) NOT NULL,\n\t\t\t `ip_addr` bigint(10) NOT NULL,\n\t\t\t `is_recp_del` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `to_user` (`to_user`),\n\t\t\t KEY `is_recp_del` (`is_recp_del`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr_attachments`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr_attachments` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `type` enum('link','image','videoembed','videoupload','text','file') collate utf8_unicode_ci NOT NULL,\n\t\t\t `data` text collate utf8_unicode_ci NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `type` (`type`),\n\t\t\t KEY `post_type_IDX` (`post_id`,`type`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr_comments`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr_comments` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `api_id` smallint(5) unsigned NOT NULL default '0',\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `message` text collate utf8_unicode_ci NOT NULL,\n\t\t\t `mentioned` tinyint(2) unsigned NOT NULL,\n\t\t\t `posttags` tinyint(2) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `ip_addr` bigint(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr_comments_mentioned`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr_comments_mentioned` (\n\t\t\t `id` int(10) NOT NULL auto_increment,\n\t\t\t `comment_id` int(10) NOT NULL,\n\t\t\t `user_id` int(10) NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `comment_id` (`comment_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr_comments_watch`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr_comments_watch` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `newcomments` smallint(5) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_post_IDX` (`user_id`,`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_pr_mentioned`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_pr_mentioned` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "posts_reshares`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "posts_reshares` (\n\t\t\t `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t `post_id` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t `user_id` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t `date` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY ( `post_id` )\n\t\t\t) ENGINE=MYISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_tags`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `post_tags` (\n\t\t\t\t `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,\n\t\t\t\t `tag_name` VARCHAR( 200 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ,\n\t\t\t\t `user_id` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t\t `group_id` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t\t `post_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t `date` INT( 10 ) UNSIGNED NOT NULL,\n\t\t\t\t PRIMARY KEY ( `id` ),\n\t\t\t\t INDEX (tag_name)\n\t\t\t\t ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_unicode_ci;", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_favs`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "post_favs` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `post_type` enum('public','private') collate utf8_unicode_ci NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `post_type` (`post_type`,`post_id`),\n\t\t\t KEY `user_id` (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_likes`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "post_likes` (\n\t\t\t `id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,\n\t\t\t\t `user_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t `post_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t `date` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\tPRIMARY KEY ( `id` )\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_userbox`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "post_userbox` (\n \t\t\t `id` bigint(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n \t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `post_id` (`post_id`),\n\t\t\t KEY `user_post_IDX` (`user_id`,`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_userbox_feeds`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "post_userbox_feeds` (\n \t\t\t `id` bigint(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n \t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `post_id` (`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
//
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "post_userbox_tweets`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "post_userbox_tweets` (\n\t\t\t\t\t`id` BIGINT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT,\n\t\t\t\t\t`user_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t`post_id` INT( 10 ) UNSIGNED NOT NULL ,\n\t\t\t\t\t PRIMARY KEY (`id`),\n\t\t\t\t\tINDEX ( `user_id` , `post_id` )\n\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
//
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "pubsubhubbub_subscriptions`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "pubsubhubbub_subscriptions` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `feed_url` varchar(500) collate utf8_unicode_ci NOT NULL,\n\t\t\t `status` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `last_status_date` int(10) unsigned NOT NULL,\n\t\t\t `parse_needed` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `feed_url` (`feed_url`(333)),\n\t\t\t KEY `status` (`status`),\n \t\t\t KEY `parse_needed` (`parse_needed`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "searches`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "searches` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `search_key` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `search_string` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `search_url` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `added_date` int(10) unsigned NOT NULL,\n\t\t\t `total_hits` mediumint(5) unsigned NOT NULL default '0',\n\t\t\t `last_results` mediumint(5) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`,`search_key`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\t\t\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "settings`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "settings` (\n\t\t\t `word` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `value` text collate utf8_unicode_ci NOT NULL,\n\t\t\t UNIQUE KEY `word` (`word`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\t\t\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "sphinx_delta_ndx_counter`;\n\t\t", $conn);
$res = $res && my_mysql_query("CREATE TABLE `" . $prefix . "sphinx_delta_ndx_counter` (\n\t\t `index_name` enum('posts','comments','tags','users','groups') NOT NULL PRIMARY KEY,\n\t\t `last_id` int(10) unsigned NOT NULL\n\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8;\n\t\t", $conn);
$res = $res && my_mysql_query('INSERT INTO `' . $prefix . 'sphinx_delta_ndx_counter` (`index_name`,`last_id`)
VALUES ("posts",0), ("comments",0), ("tags", 0), ("users", 0), ("groups", 0) ', $conn);
$res = $res && my_mysql_query("\n\t\t\tINSERT INTO `" . $prefix . "settings` (`word`, `value`) VALUES\n\t\t\t('SITE_TITLE', '" . my_mysql_real_escape_string($s['SITE_TITLE'], $conn) . "'),\n\t\t\t('POST_MAX_SYMBOLS', '160'),\n\t\t\t('LANGUAGE', '" . my_mysql_real_escape_string($s['LANGUAGE'], $conn) . "'),\n\t\t\t('SYSTEM_EMAIL', '" . my_mysql_real_escape_string($s['ADMIN_EMAIL'], $conn) . "'),\n\t\t\t('COMPANY', '" . my_mysql_real_escape_string($s['SITE_TITLE'], $conn) . "'),\n\t\t\t('ATTACH_LINK_DISABLED', '0'),\n\t\t\t('ATTACH_IMAGE_DISABLED', '0'),\n\t\t\t('ATTACH_VIDEO_DISABLED', '0'),\n\t\t\t('ATTACH_FILE_DISABLED', '0'),\n\t\t\t('USERS_EMAIL_CONFIRMATION', '1'),\n\t\t\t('API_STATUS', '1'),\n\t\t\t('SUPPORTED_EMAIL_DOMAINS', '0'),\n\t\t\t('PROTECT_OUTSIDE_PAGES', '0'),\n\t\t\t('THEME', 'default'),\n\t\t\t('MOBI_DISABLED', '0'),\n\t\t\t('POST_TYPES_TO_AUTODELETE', 'feed'),\n\t\t\t('POST_TYPES_DELETE_PERIOD', '14'),\n\t\t\t('POST_FROM_TWITTER_TAG', '0'),\n\t\t\t('LAST_TWITTER_POST_ID', '0')\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "unconfirmed_registrations`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "unconfirmed_registrations` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `email` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `fullname` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `confirm_key` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `invited_code` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t UNIQUE KEY `email` (`email`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `facebook_uid` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `twitter_uid` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `email` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `username` varchar(200) collate utf8_unicode_ci NOT NULL,\n\t\t\t `password` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `fullname` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `avatar` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `about_me` text collate utf8_unicode_ci NOT NULL,\n\t\t\t `tags` text collate utf8_unicode_ci NOT NULL,\n\t\t\t `gender` enum('','m','f') collate utf8_unicode_ci NOT NULL,\n\t\t\t `birthdate` date NOT NULL,\n\t\t\t `position` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `location` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `language` varchar(5) collate utf8_unicode_ci NOT NULL,\n\t\t\t `timezone` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `num_posts` int(10) unsigned NOT NULL,\n\t\t\t `num_followers` int(10) unsigned NOT NULL,\n\t\t\t `used_storage` bigint(10) unsigned NOT NULL,\n\t\t\t `js_animations` tinyint(1) unsigned NOT NULL default '1',\n\t\t\t `dbrd_groups_closed` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `dbrd_whattodo_closed` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `comments_expanded` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `reg_date` int(10) unsigned NOT NULL,\n\t\t\t `reg_ip` bigint(10) NOT NULL,\n\t\t\t `lastlogin_date` int(10) unsigned NOT NULL,\n\t\t\t `lastlogin_ip` bigint(10) NOT NULL,\n\t\t\t `lastpost_date` int(10) unsigned NOT NULL,\n\t\t\t `lastemail_date` int(10) unsigned NOT NULL,\n\t\t\t `lastclick_date` int(10) unsigned NOT NULL,\n\t\t\t `lastclick_date_newest_post` int(10) unsigned NOT NULL,\n\t\t\t `pass_reset_key` varchar(32) collate utf8_unicode_ci NOT NULL,\n\t\t\t `pass_reset_valid` int(10) unsigned NOT NULL,\n\t\t\t `active` tinyint(1) unsigned NOT NULL default '1',\n\t\t\t `is_network_admin` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `is_posts_protected` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `is_profile_protected` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `is_dm_protected` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t UNIQUE KEY `email` (`email`),\n\t\t\t UNIQUE KEY `username` (`username`),\n\t\t\t KEY `active` (`active`),\n\t\t\t KEY `num_followers` (`num_followers`),\n\t\t\t KEY `facebook_uid` (`facebook_uid`),\n\t\t\t KEY `twitter_uid` (`twitter_uid`),\n\t\t\t KEY `pass_reset_IDX` (`pass_reset_key`,`pass_reset_valid`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\t\t\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_dashboard_tabs`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_dashboard_tabs` (\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `tab` enum('','all','@me','private','commented','feeds','tweets') collate utf8_unicode_ci NOT NULL,\n\t\t\t `state` tinyint(1) unsigned NOT NULL,\n\t\t\t `newposts` smallint(4) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`user_id`,`tab`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_details`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_details` (\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `website` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `work_phone` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `personal_phone` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `personal_email` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_skype` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_icq` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_gtalk` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_msn` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_yahoo` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_aim` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `im_jabber` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_linkedin` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_facebook` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_twitter` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_flickr` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_friendfeed` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_delicious` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_digg` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_myspace` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_orcut` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_youtube` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_mixx` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_edno23` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `prof_favit` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `integr_twitter` VARCHAR( 255 ) collate utf8_unicode_ci NOT NULL,\n\t\t\t `extrnlusr_twitter` VARCHAR( 255 ) collate utf8_unicode_ci NOT NULL,\n\t\t\t `integr_facebook` VARCHAR( 255 ) collate utf8_unicode_ci NOT NULL,\n\t\t\t `extrnlusr_facebook` VARCHAR( 255 ) collate utf8_unicode_ci NOT NULL,\n\t\t\t PRIMARY KEY (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_followed`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_followed` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `who` int(10) unsigned NOT NULL,\n\t\t\t `whom` int(10) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `whom_from_postid` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `who` (`who`),\n\t\t\t KEY `whom` (`whom`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_ignores`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_ignores` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `who` int(10) unsigned NOT NULL,\n\t\t\t `whom` int(10) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `who` (`who`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_invitations`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_invitations` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `date` int(10) unsigned NOT NULL,\n\t\t\t `recp_name` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `recp_email` varchar(100) collate utf8_unicode_ci NOT NULL,\n\t\t\t `recp_is_registered` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `recp_user_id` int(10) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`,`recp_is_registered`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_notif_rules`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_notif_rules` (\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `ntf_them_if_i_follow_usr` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_them_if_i_comment` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_them_if_i_edt_profl` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_them_if_i_edt_pictr` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_them_if_i_create_grp` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_them_if_i_join_grp` tinyint(1) unsigned NOT NULL COMMENT '0-off, 1-on',\n\t\t\t `ntf_me_if_u_follows_me` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_follows_u2` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_commments_me` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_commments_m2` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_edt_profl` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_edt_pictr` tinyint(3) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_creates_grp` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_joins_grp` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_invit_me_grp` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_posts_qme` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_posts_prvmsg` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_if_u_registers` tinyint(1) unsigned NOT NULL COMMENT '0-off, 2-msg, 3-mail, 1-both',\n\t\t\t `ntf_me_on_post_like` tinyint( 1 ) unsigned NOT NULL DEFAULT '0' COMMENT '0-off, 3-email',\n\t\t\t PRIMARY KEY (`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_pageviews`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_pageviews` (\n\t\t\t `id` bigint(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `date` varchar(13) collate utf8_unicode_ci NOT NULL COMMENT 'YY-MM-DD HH',\n\t\t\t `pageviews` smallint(5) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `user_id` (`user_id`),\n\t\t\t KEY `date` (`date`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_rssfeeds`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_rssfeeds` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `user_id` int(10) unsigned NOT NULL,\n\t\t\t `feed_url` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `feed_userpwd` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `feed_title` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `filter_keywords` varchar(1000) collate utf8_unicode_ci NOT NULL,\n\t\t\t `date_added` int(10) unsigned NOT NULL,\n\t\t\t `date_last_post` int(10) unsigned NOT NULL,\n\t\t\t `date_last_crawl` int(10) unsigned NOT NULL,\n\t\t\t `date_last_item` int(10) unsigned NOT NULL,\n\t\t\t `hub_url` varchar(255) collate utf8_unicode_ci NOT NULL,\n\t\t\t `hub_lastping` int(10) unsigned NOT NULL default '0',\n\t\t\t `is_deleted` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t `is_twitter` tinyint(1) unsigned NOT NULL default '0',\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `group_id` (`is_deleted`,`user_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tDROP TABLE IF EXISTS `" . $prefix . "users_rssfeeds_posts`;\n\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\tCREATE TABLE `" . $prefix . "users_rssfeeds_posts` (\n\t\t\t `id` int(10) unsigned NOT NULL auto_increment,\n\t\t\t `rssfeed_id` int(10) unsigned NOT NULL,\n\t\t\t `post_id` int(10) unsigned NOT NULL,\n\t\t\t PRIMARY KEY (`id`),\n\t\t\t KEY `rssfeed_id` (`rssfeed_id`),\n\t\t\t KEY `post_id` (`post_id`)\n\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;\n\t\t", $conn);
if (!$res) {
if (!empty($prefix)) {
database_drop_tables_with_prefix($prefix);
}
return FALSE;
}
if (!$convert_version && $s['ADMIN_ID'] == 0) {
$res = $res && my_mysql_query("\n\t\t\t\tINSERT INTO `" . $prefix . "users` SET\n\t\t\t\tid='1',\n\t\t\t\tusername='******'ADMIN_USER'], $conn) . "',\n\t\t\t\tpassword='******'ADMIN_PASS']), $conn) . "',\n\t\t\t\temail='" . my_mysql_real_escape_string($s['ADMIN_EMAIL'], $conn) . "',\n\t\t\t\tfullname='" . my_mysql_real_escape_string($s['SITE_TITLE'], $conn) . "',\n\t\t\t\treg_date='" . time() . "',\n\t\t\t\treg_ip='" . ip2long($_SERVER['REMOTE_ADDR']) . "',\n\t\t\t\tlastpost_date='" . time() . "',\n\t\t\t\tlanguage='" . my_mysql_real_escape_string($s['LANGUAGE'], $conn) . "',\n\t\t\t\tnum_posts='1',\n\t\t\t\tnum_followers='0',\n\t\t\t\tactive='1',\n\t\t\t\tis_network_admin='1';\n\t\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\t\tINSERT INTO `" . $prefix . "posts` SET\n\t\t\t\tid='1',\n\t\t\t\tapi_id='0',\n\t\t\t\tuser_id='1',\n\t\t\t\tgroup_id='0',\n\t\t\t\tmessage='Welcome to " . $s['SITE_TITLE'] . " :)',\n\t\t\t\tmentioned=0,\n\t\t\t\tattached=0,\n\t\t\t\tposttags=0,\n\t\t\t\tcomments=0,\n\t\t\t\tdate='" . time() . "',\n\t\t\t\tdate_lastedit='',\n\t\t\t\tdate_lastcomment='" . time() . "',\n\t\t\t\tip_addr='" . ip2long($_SERVER['REMOTE_ADDR']) . "';\n\t\t\t", $conn);
$res = $res && my_mysql_query("\n\t\t\t\tINSERT INTO post_userbox SET user_id='1', post_id='1';\n\t\t\t", $conn);
if (!$res) {
if (!empty($prefix)) {
database_drop_tables_with_prefix($prefix);
}
return FALSE;
}
}
if ($convert_version == 'unofficial') {
$tables = array();
$tmp = my_mysql_query('SHOW TABLES FROM ' . $s['MYSQL_DBNAME'], $conn);
while ($tbl = my_mysql_fetch_row($tmp)) {
$tables[] = $tbl[0];
}
if (in_array('users_watched', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_followed` (who, whom, date, whom_from_postid) SELECT who, whom, date, whom FROM `users_watched` ORDER BY id ASC", $conn);
}
if (in_array('users_invitations', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_invitations` (user_id, date, recp_name, recp_email, recp_is_registered, recp_user_id) SELECT user_id, date, recp_name, recp_email, recp_is_registered, recp_user_id FROM `users_invitations` ORDER BY id ASC", $conn);
}
if (in_array('users_ignores', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_ignores` (who, whom, date) SELECT who, whom, date FROM `users_ignores` ORDER BY id ASC", $conn);
}
if (in_array('users_feeds', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_rssfeeds` (id, user_id, feed_url, date_added, date_last_post, date_last_crawl, date_last_item, is_deleted) SELECT id, user_id, feed_url, date_added, date_lastpost, date_lastcrawl, date_feed_lastentry, '0' FROM `users_feeds` ORDER BY id ASC", $conn);
my_mysql_query("UPDATE `" . $prefix . "users_rssfeeds` SET date_date_last_post='" . time() . "', date_last_crawl='" . time() . "', date_last_item='" . time() . "' ", $conn);
}
if (in_array('users_feeds_posts', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_rssfeeds_posts` (rssfeed_id, post_id) SELECT feed_id, post_id FROM `users_feeds_posts` ORDER BY id ASC", $conn);
}
if (in_array('users_feeds_posts', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users_rssfeeds_posts` (rssfeed_id, post_id) SELECT feed_id, post_id FROM `users_feeds_posts` ORDER BY id ASC", $conn);
}
if (in_array('users', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "users` (id, email, username, password, fullname, avatar, about_me, tags, gender, birthdate, location, language, num_posts, num_followers, reg_date, reg_ip, lastlogin_date, lastlogin_ip, lastpost_date, lastemail_date, lastclick_date, lastclick_date_newest_post, active, is_network_admin) SELECT id, email, username, password, fullname, avatar, about_me, tags, gender, birthdate, country, lang, '0', '0', reg_date, reg_ip, lastlogin_date, lastlogin_ip, lastpost_date, lastemail_date, lastclick_date, lastclick_date_newest_post, '1', '0' FROM `users` ORDER BY id ASC", $conn);
if ($s['ADMIN_ID'] == 0) {
my_mysql_query("UPDATE `" . $prefix . "users` SET is_network_admin=1 WHERE id='1' LIMIT 1", $conn);
} else {
my_mysql_query("UPDATE `" . $prefix . "users` SET is_network_admin=1 WHERE id='" . intval($s['ADMIN_ID']) . "' LIMIT 1", $conn);
}
$tmp = my_mysql_query("SELECT whom, COUNT(who) AS c FROM `" . $prefix . "users_followed` GROUP BY whom", $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
my_mysql_query("UPDATE `" . $prefix . "users` SET num_followers='" . $obj->c . "' WHERE id='" . $obj->whom . "' LIMIT 1", $conn);
}
$tmp = my_mysql_query("SELECT DISTINCT language FROM `" . $prefix . "users` ", $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
if (empty($obj->language)) {
my_mysql_query("UPDATE `" . $prefix . "users` SET language='" . my_mysql_real_escape_string($s['LANGUAGE']) . "' WHERE language='" . $obj->language . "' LIMIT 1", $conn);
} elseif ($obj->language != $s['LANGUAGE'] && !file_exists(INCPATH . '../../system/languages/' . $obj->language)) {
my_mysql_query("UPDATE `" . $prefix . "users` SET language='" . my_mysql_real_escape_string($s['LANGUAGE']) . "' WHERE language='" . $obj->language . "' LIMIT 1", $conn);
}
}
}
if (in_array('posts_favs', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "post_favs` (user_id, post_type, post_id, date) SELECT user_id, 'public', post_id, date FROM `posts_favs` WHERE post_type='public' ORDER BY id ASC", $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "post_favs` (user_id, post_type, post_id, date) SELECT user_id, 'private', post_id, date FROM `posts_favs` WHERE post_type='direct' ORDER BY id ASC", $conn);
}
if (in_array('posts_mentioned', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_mentioned` (post_id, user_id) SELECT post_id, user_id FROM `posts_mentioned` ORDER BY id ASC", $conn);
}
if (in_array('posts_mentioned_d', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_mentioned` (post_id, user_id) SELECT post_id, user_id FROM `posts_mentioned_d` ORDER BY id ASC", $conn);
}
if (in_array('posts_usertabs', $tables)) {
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "post_userbox` (user_id, post_id) SELECT user_id, post_id FROM posts_usertabs", $conn);
$ids = array();
$tmp = my_mysql_query('SELECT id FROM posts WHERE is_feed=1', $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
$ids[] = $obj->id;
}
if (count($ids)) {
$ids = implode(', ', $ids);
my_mysql_query("INSERT INTO `" . $prefix . "post_userbox_feeds` (user_id, post_id) SELECT user_id, post_id FROM `" . $prefix . "post_userbox` WHERE post_id IN(" . $ids . ")", $conn);
my_mysql_query("DELETE FROM `" . $prefix . "post_userbox` WHERE post_id IN(" . $ids . ")", $conn);
}
}
if (in_array('posts', $tables)) {
$tmp = my_mysql_query("SELECT id, api_id, user_id, message, mentioned, attached_link, attachments, date, ip_address, is_feed FROM `posts` ORDER BY id ASC", $conn);
$res = $res && $tmp;
while ($obj = my_mysql_fetch_object($tmp)) {
$api_id = $obj->api_id == 1 ? 1 : ($obj->is_feed == 1 ? 2 : 0);
$message = stripslashes($obj->message);
$attached = intval($obj->attachments);
if (!empty($obj->attached_link)) {
$attached++;
}
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts` SET id='" . $obj->id . "', api_id='" . $api_id . "', user_id='" . $obj->user_id . "', group_id=0, message='" . my_mysql_real_escape_string($message, $conn) . "', mentioned='" . $obj->mentioned . "', attached='" . $attached . "', posttags=0, comments=0, date='" . $obj->date . "', date_lastcomment='" . $obj->date . "', ip_addr='" . $obj->ip_address . "' ", $conn);
if (!empty($obj->attached_link)) {
$atch = (object) array('link' => stripslashes($obj->attached_link), 'hits' => 0);
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_attachments` SET post_id='" . $obj->id . "', type='link', data='" . $atch . "' ", $conn);
}
if ($obj->attachments > 0) {
$tmp2 = my_mysql_query("SELECT embed_type, embed_w, embed_h, embed_thumb, if_image_filename, if_video_source, if_video_html FROM `posts_attachments` WHERE post_id='" . $obj->id . "' LIMIT 1", $conn);
$res = $res && $tmp2;
if ($atchobj = my_mysql_fetch_object($tmp2)) {
if ($atchobj->embed_type == 'video') {
$src = explode(' ', $atchobj->if_video_source);
$src[0] = strtolower($src[0]);
if (isset($VIDSRC[$src[0]])) {
$atch = (object) array('src_site' => $src[0], 'src_id' => trim($src[1]), 'title' => '', 'file_thumbnail' => '', 'embed_code' => stripslashes($atchobj->if_video_html), 'embed_w' => $atchobj->embed_w, 'embed_h' => $atchobj->embed_h, 'orig_url' => str_replace('###ID###', trim($src[1]), $VIDSRC[$src[0]]->insite_url), 'hits' => 0);
$fn = $atchobj->embed_thumb;
if (!empty($fn) && $fn != '_NOTHUMB.jpg') {
$oldfile = INCPATH . '../../img/attachments/thumbs/' . $fn;
$newfn = str_replace('.', '_thumb.', $fn);
$newfile = INCPATH . '../../i/attachments/1/' . $newfn;
if (@copy($oldfile, $newfile)) {
@chmod($newfile, 0777);
$atch->file_thumbnail = $newfn;
}
}
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_attachments` SET post_id='" . $obj->id . "', type='videoembed', data='" . $atch . "' ", $conn);
}
} elseif ($atchobj->embed_type == 'image') {
$fn = $atchobj->if_image_filename;
$old_file = INCPATH . '../../img/attachments/' . $fn;
$old_thumb = INCPATH . '../../img/attachments/thumbs/' . $atchobj->embed_thumb;
$atch = (object) array('title' => $fn, 'file_original' => str_replace('.', '_orig.', $fn), 'file_preview' => str_replace('.', '_large.', $fn), 'file_thumbnail' => str_replace('.', '_thumb.', $fn), 'size_original' => array($atchobj->embed_w, $atchobj->embed_h), 'size_preview' => array($atchobj->embed_w, $atchobj->embed_h), 'filesize' => 0, 'hits' => 0);
@copy($old_file, INCPATH . '../../i/attachments/1/' . $atch->file_original);
@copy($old_file, INCPATH . '../../i/attachments/1/' . $atch->file_preview);
@copy($old_thumb, INCPATH . '../../i/attachments/1/' . $atch->file_thumbnail);
$atch->filesize = intval(@filesize($old_file));
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_attachments` SET post_id='" . $obj->id . "', type='image', data='" . $atch . "' ", $conn);
}
}
}
}
}
if (in_array('posts_direct', $tables)) {
$tmp = my_mysql_query("SELECT id, api_id, user_id, to_user, message, mentioned, attached_link, attachments, date, ip_address FROM `posts_direct` ORDER BY id ASC", $conn);
$res = $res && $tmp;
while ($obj = my_mysql_fetch_object($tmp)) {
$api_id = $obj->api_id == 1 ? 1 : 0;
$message = stripslashes($obj->message);
$attached = intval($obj->attachments);
if (!empty($obj->attached_link)) {
$attached++;
}
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_pr` SET id='" . $obj->id . "', api_id='" . $api_id . "', user_id='" . $obj->user_id . "', to_user='******', message='" . my_mysql_real_escape_string($message, $conn) . "', mentioned='" . $obj->mentioned . "', attached='" . $attached . "', posttags=0, comments=0, date='" . $obj->date . "', date_lastcomment='" . $obj->date . "', ip_addr='" . $obj->ip_address . "' ", $conn);
if (!empty($obj->attached_link)) {
$atch = (object) array('link' => stripslashes($obj->attached_link), 'hits' => 0);
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_attachments` SET post_id='" . $obj->id . "', type='link', data='" . $atch . "' ", $conn);
}
if ($obj->attachments > 0) {
$tmp2 = my_mysql_query("SELECT embed_type, embed_w, embed_h, embed_thumb, if_image_filename, if_video_source, if_video_html FROM `posts_attachments_d` WHERE post_id='" . $obj->id . "' LIMIT 1", $conn);
$res = $res && $tmp2;
if ($atchobj = my_mysql_fetch_object($tmp2)) {
if ($atchobj->embed_type == 'video') {
$src = explode(' ', $atchobj->if_video_source);
$src[0] = strtolower($src[0]);
if (isset($VIDSRC[$src[0]])) {
$atch = (object) array('src_site' => $src[0], 'src_id' => trim($src[1]), 'title' => '', 'file_thumbnail' => '', 'embed_code' => stripslashes($atchobj->if_video_html), 'embed_w' => $atchobj->embed_w, 'embed_h' => $atchobj->embed_h, 'orig_url' => str_replace('###ID###', trim($src[1]), $VIDSRC[$src[0]]->insite_url), 'hits' => 0);
$fn = $atchobj->embed_thumb;
if (!empty($fn) && $fn != '_NOTHUMB.jpg') {
$oldfile = INCPATH . '../../img/attachments/thumbs/' . $fn;
$newfn = str_replace('.', '_thumb.', $fn);
$newfile = INCPATH . '../../i/attachments/1/' . $newfn;
if (@copy($oldfile, $newfile)) {
@chmod($newfile, 0777);
$atch->file_thumbnail = $newfn;
}
}
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_attachments` SET post_id='" . $obj->id . "', type='videoembed', data='" . $atch . "' ", $conn);
}
} elseif ($atchobj->embed_type == 'image') {
$fn = $atchobj->if_image_filename;
$old_file = INCPATH . '../../img/attachments/' . $fn;
$old_thumb = INCPATH . '../../img/attachments/thumbs/' . $atchobj->embed_thumb;
$atch = (object) array('title' => $fn, 'file_original' => str_replace('.', '_orig.', $fn), 'file_preview' => str_replace('.', '_large.', $fn), 'file_thumbnail' => str_replace('.', '_thumb.', $fn), 'size_original' => array($atchobj->embed_w, $atchobj->embed_h), 'size_preview' => array($atchobj->embed_w, $atchobj->embed_h), 'filesize' => 0, 'hits' => 0);
@copy($old_file, INCPATH . '../../i/attachments/1/' . $atch->file_original);
@copy($old_file, INCPATH . '../../i/attachments/1/' . $atch->file_preview);
@copy($old_thumb, INCPATH . '../../i/attachments/1/' . $atch->file_thumbnail);
$atch->filesize = intval(@filesize($old_file));
$atch = my_mysql_real_escape_string(serialize($atch), $conn);
$res = $res && my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_attachments` SET post_id='" . $obj->id . "', type='image', data='" . $atch . "' ", $conn);
}
}
}
}
}
if (!$res) {
if (!empty($prefix)) {
database_drop_tables_with_prefix($prefix);
}
return FALSE;
}
$tmp = my_mysql_query("SELECT id, user_id FROM `" . $prefix . "posts` WHERE user_id<>0 ORDER BY id ASC", $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
my_mysql_query("INSERT INTO `" . $prefix . "posts_comments_watch` SET user_id='" . $obj->user_id . "', post_id='" . $obj->id . "', newcomments=0", $conn);
}
$tmp = my_mysql_query("SELECT id, user_id, to_user FROM `" . $prefix . "posts_pr` WHERE user_id<>0 ORDER BY id ASC", $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_comments_watch` SET user_id='" . $obj->user_id . "', post_id='" . $obj->id . "', newcomments=0", $conn);
my_mysql_query("INSERT INTO `" . $prefix . "posts_pr_comments_watch` SET user_id='" . $obj->to_user . "', post_id='" . $obj->id . "', newcomments=0", $conn);
}
$tmp = my_mysql_query("SELECT user_id, COUNT(id) AS c FROM `" . $prefix . "posts` GROUP BY user_id", $conn);
while ($obj = my_mysql_fetch_object($tmp)) {
my_mysql_query("UPDATE `" . $prefix . "users` SET num_posts='" . $obj->c . "' WHERE id='" . $obj->user_id . "' LIMIT 1", $conn);
}
if (!$res) {
if (!empty($prefix)) {
database_drop_tables_with_prefix($prefix);
}
return FALSE;
}
$res = $res && my_mysql_query("DROP TABLE IF EXISTS `badwords`, `posts_direct`, `posts_from_email`, `posts_pingbacks`, `posts_usertabs`, `users_feeds`, `users_feeds_posts`, `users_notif_rules`, `users_notif_sent`, `users_profile_hits`, `users_spammers`, `users_watched`, `users_tabs_state`, `posts_mentioned_d`, `posts_favs`, `posts_attachments_d` ;", $conn);
foreach ($tables as $tbl) {
if (substr($tbl, 0, strlen($prefix)) == $prefix) {
$new = substr($tbl, strlen($prefix));
$res = $res && my_mysql_query("DROP TABLE IF EXISTS `" . $new . "`;", $conn);
$res = $res && my_mysql_query("RENAME TABLE `" . $tbl . "` TO `" . $new . "`;", $conn);
}
}
if (!$res) {
if (!empty($prefix)) {
database_drop_tables_with_prefix($prefix);
}
return FALSE;
}
}
return $res;
}
function jotform_sybasedump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
// CREATE TABLE STATEMENT
$table = mysql_fieldname_format($formTitle);
$sql .= "IF NOT EXISTS (\n\tSELECT 1\n\tFROM sysobjects\n\tWHERE name=" . $table . "\n\tAND type=\"U\"\n)\n";
$sql .= "EXECUTE(\"CREATE TABLE " . $table . " (\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t`" . mysql_fieldname_format($questions[$i]['text']) . "` " . $mysql_type);
}
$sql .= "\t`submissionID` bigint,\n";
$sql .= implode(",\n", $fields_sql);
$sql .= ",\n\tPRIMARY KEY(submissionID)";
$sql .= ")\")\nGO\n\n";
// INSERT / REPLACE STATEMENT
foreach ($submissions as $s) {
$insert = "INSERT INTO `{$table}` (";
$keys = array("`submissionID`");
$values = array($s["id"]);
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, "`" . mysql_fieldname_format($k) . "`");
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "'" . my_mysql_real_escape_string($a) . "'");
}
}
$insert .= implode(", ", $keys) . ")\n";
$insert .= "\t ON EXISTING UPDATE `" . $table . "`\n\t SET ";
for ($i = 0; $i < count($keys); $i++) {
$insert .= $keys[$i] . "=" . $values[$i];
if ($i < count($keys) - 1) {
$insert .= " AND ";
}
}
$insert .= "\nVALUES (";
$insert .= implode(", ", $values);
$insert .= ");\n\n";
$sql .= $insert;
}
return $sql;
}
my_include('src/utils.php');
$p_table = my_get_get('table');
$p_select_field = my_get_get('select_field');
$p_select_id = my_get_get('select_id');
$p_data_field = my_get_get('data_field');
$p_name_field = my_get_get('name_field');
$p_mime_field = my_get_get('mime_field');
$debug = 0;
# security...
assert($p_table == 'TbImage');
assert($p_select_field == 'id');
assert($p_data_field == 'smallData');
assert($p_name_field == 'slug');
assert($p_mime_field == 'smallMime');
my_mysql_connect();
$query = sprintf('SELECT %s,%s,%s FROM %s where %s=%s', $p_data_field, $p_name_field, $p_mime_field, $p_table, $p_select_field, my_mysql_real_escape_string($p_select_id));
if ($debug) {
echo $query . '<br/>';
}
$result = my_mysql_query_one_row($query);
$fileContent = $result[$p_data_field];
$fileName = $result[$p_name_field];
$fileMime = $result[$p_mime_field];
$fileLength = strlen($fileContent);
# You can see more HTTP headers that may improve stuff in
# http://en.wikipedia.org/wiki/List_of_HTTP_headers
# ideas are: Content-MD5, Content-Length, Last-Modified
# if you want to debug HTTP headers just use wget -S on the
# command line and compared the headers that you are generating
# with the headers that a regular content generates by using
# the web server...
$p_personId = my_get_post('personId');
$p_name = my_get_post('name');
$p_imdbid = my_get_post('imdbid');
$p_date = javascriptdate_to_mysqldate(my_get_post('date'));
$p_locationId = my_get_post('locationId');
$p_deviceId = my_get_post('deviceId');
$p_remark = my_get_post('remark');
// this is a line you can use for debugging...
//error('query not yet implemented');
//
my_mysql_start_transaction();
$p_typeId = my_mysql_query_one('select id from TbWkWorkType where name=\'video movie\'');
$p_externalId = my_mysql_query_one('select id from TbExternalType where name=\'imdb_title_id\'');
// insert the actual work
$query = sprintf('insert into TbWkWork (name,typeId) values(%s,%s)', my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_typeId));
my_mysql_query($query);
$p_workId = my_mysql_insert_id();
// insert an external imdb id
$query = sprintf('insert into TbWkWorkExternal (workId,externalId,externalCode) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_externalId), my_mysql_real_escape_string($p_imdbid));
my_mysql_query($query);
$p_externalId = my_mysql_insert_id();
// insert a new view
$query = sprintf('insert into TbWkWorkView (endViewDate,locationId,deviceId,workId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_date), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_deviceId), my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_remark));
my_mysql_query($query);
$p_workviewid = my_mysql_insert_id();
// insert the viewer
$query = sprintf('insert into TbWkWorkViewPerson (viewerId,viewId) values(%s,%s)', my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_workviewid));
my_mysql_query($query);
$p_workviewpersonid = my_mysql_insert_id();
my_mysql_commit();
echo "new work [{$p_workId}], external [{$p_externalId}], view [{$p_workviewid}], viewperson[{$p_workviewpersonid}] successfully inserted";
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
#$p_start=javascriptdate_to_mysqldate(my_get_post('start'));
$p_end = javascriptdate_to_mysqldate(my_get_post('end'));
#$p_personId=my_get_post('personId');
$p_locationId = my_get_post('locationId');
$p_activityId = my_get_post('activityId');
$p_remark = my_get_post('remark');
my_mysql_start_transaction();
# this is instead of getting it via the form above...
$p_personId = my_mysql_query_one('select id from TbIdPerson where firstname=\'Mark\' and surname=\'Veltzer\'');
$query = sprintf('insert into TbTdDone (end,personId,locationId,activityId,remark) values(%s,%s,%s,%s,%s)', my_mysql_real_escape_string($p_end), my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_activityId), my_mysql_real_escape_string($p_remark));
my_mysql_query($query);
$p_doneid = my_mysql_insert_id();
my_mysql_commit();
echo 'done item inserted with id [' . $p_doneid . ']';
function create_person($params)
{
$firstname = $params['firstname'];
$surname = $params['surname'];
$res = '';
$external = my_mysql_query_hash('SELECT * FROM TbExternalType', 'id');
$query = sprintf('SELECT * FROM TbIdPerson WHERE firstname=%s AND surname=%s', my_mysql_real_escape_string($firstname), my_mysql_real_escape_string($surname));
$row = my_mysql_query_one_row($query);
$id = $row['id'];
$res .= '<ul>';
$res .= '<li>id: ' . $id . '</li>';
$res .= '<li>Name: ' . get_full_name($row, $honorifics) . '</li>';
// handle externals
$query = sprintf('SELECT * FROM TbIdPersonExternal WHERE personId=%s', my_mysql_real_escape_string($id));
$result = my_mysql_query($query);
while ($row = $result->fetch_assoc()) {
$externalcode = $row['externalCode'];
$externalid = $row['externalId'];
$externalname = $external[$externalid]['name'];
$externalidname = $external[$externalid]['idname'];
$link = get_external_href($externalname, $externalcode);
$link = '<a href=\'' . $link . '\'>' . $externalidname . ': ' . $externalcode . '</a>';
$res .= '<li>' . $link . '</li>';
}
my_mysql_free_result($result);
$res .= '</ul>';
return $res;
}
<?php
require "utils.php";
utils_init();
$debug = 1;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_name = my_get_post('name');
$p_calendarIy = my_get_post('calendarId');
$p_companIy = my_get_post('companyId');
$p_courseId = my_get_post('courseId');
$p_locationId = my_get_post('locationId');
$p_personId = my_get_post('personId');
$p_remark = my_get_post('remark');
my_mysql_start_transaction();
$query = sprintf("insert into TbEvent (name,calendarId,companyId,courseId,locationId,personId,remark) values(%s,%s,%s,%s,%s,%s,%s)", my_mysql_real_escape_string($p_name), my_mysql_real_escape_string($p_calendarId), my_mysql_real_escape_string($p_companyId), my_mysql_real_escape_string($p_courseId), my_mysql_real_escape_string($p_locationId), my_mysql_real_escape_string($p_personId), my_mysql_real_escape_string($p_remark));
my_mysql_query($query);
$p_eventid = my_mysql_insert_id();
my_mysql_commit();
echo 'new event successfully inserted with id [' . $p_eventid . ']';
<?php
require 'utils.php';
utils_init();
$debug = 0;
if ($debug) {
print_r($_POST) . "\n";
}
# parameters for this script...
$p_workId = my_get_post_or_null('workId');
$p_typeId = my_get_post_or_null('typeId');
$p_organizationId = my_get_post_or_null('organizationId');
my_mysql_start_transaction();
$query = sprintf('insert into TbWkWorkContrib (workId,typeId,organizationId) values(%s,%s,%s)', my_mysql_real_escape_string($p_workId), my_mysql_real_escape_string($p_typeId), my_mysql_real_escape_string($p_organizationId));
my_mysql_query($query);
$p_id = my_mysql_insert_id();
my_mysql_commit();
echo 'new record successfully inserted with id [' . $p_id . ']';
function jotform_informixdump($apiKey, $format, $formTitle, $questions, $submissions)
{
// get a list of questions
$new_questions = array();
$ignored_fields = array("control_head", "control_button", "control_pagebreak", "control_collapse", "control_text");
$i = 0;
foreach ($questions as $q) {
if (!in_array($q['type'], $ignored_fields) && $q['text'] != "" && $q['text'] != "....") {
array_push($new_questions, $q);
$ordered_questions[$q['order']] = $i++;
}
}
$questions = $new_questions;
// CREATE TABLE STATEMENT
$table = mysql_fieldname_format($formTitle);
$sql .= "CREATE TABLE IF NOT EXISTS `" . $table . "` (\n";
$fields_sql = array();
$fields = array();
foreach ($ordered_questions as $order => $i) {
$mysql_type = "varchar(255)";
if ($questions[$i]['type'] == "control_textarea") {
$mysql_type = "text";
}
array_push($fields, $questions[$i]['text']);
array_push($fields_sql, "\t`" . mysql_fieldname_format($questions[$i]['text']) . "` " . $mysql_type);
}
$sql .= "\t`submissionID` BIGINT PRIMARY KEY,\n";
$sql .= implode(",\n", $fields_sql);
$sql .= "\n);\n\n";
// INSERT / REPLACE STATEMENT
foreach ($submissions as $s) {
$insert = "MERGE INTO `" . $table . "` (\n";
$insert .= "ON " . $table . ".submissionID = " . $s["id"] . "\n";
$insert .= "WHEN MATCHED THEN\n";
$keys = array();
$values = array();
$answer = array();
foreach ($s['answers'] as $a) {
$answer[$a['text']] = $a['answer'];
}
foreach ($fields as $k) {
if ($k != "" && $k != "....") {
array_push($keys, "`" . mysql_fieldname_format($k) . "`");
if (is_array($answer[$k])) {
$a = implode(",", $answer[$k]);
} else {
$a = $answer[$k];
}
array_push($values, "'" . my_mysql_real_escape_string($a) . "'");
}
}
$insert .= "UPDATE TABLE `" . $table . "` SET ";
for ($i = 0; $i < count($keys); $i++) {
$insert .= $keys[$i] . "=" . $values[$i];
if ($i < count($keys) - 1) {
$insert .= " AND ";
}
}
$insert .= "\nWHEN NOT MATCHED THEN\n";
$insert .= "INSERT INTO `" . $table . "` (";
$insert .= implode(", ", $keys);
$insert .= ")\nVALUES (";
$insert .= implode(", ", $values);
$insert .= ");\n\n";
$sql .= $insert;
}
return $sql;
}
