install files..

[jarhead!]

Hey,

for many weeks/ days ive been trying to figger out how i make isntall files..

will anybody help?

[F32]

For the computer or a script?

[Sam]

Well if for a Script youve made.. Install files are often for like.. Creating the SQL automatically (I think? Thats the only use i found for them) Basically, just create a simple PHP script like:


<?php
include("DATABADE CONNECT FILE");

mysql_query("YOUR SQL CODE HERE
)");
echo ("Table Created");

?>

I think thats right?

Im new to PHP

[jarhead!]

no it not right - anymore help

[Sam]

Well maybe if youd expalin more.. And yes that is right if your not a noob at PHP and can actually use it.. Im using it in my CMS atm.

[jarhead!]

do i just do this?



-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 13, 2006 at 09:37 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
--
-- Database: `speedan_Shout`
--

-- --------------------------------------------------------

--
-- Table structure for table `servers`
--

CREATE TABLE `servers` (
`id` varchar(8) NOT NULL default '',
`nick` varchar(25) NOT NULL default '',
`owner` varchar(8) NOT NULL default '',
`port` varchar(5) NOT NULL default '',
`listeners` varchar(10) NOT NULL default '',
`pid` varchar(10) NOT NULL default '',
`adjpid` varchar(50) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `servers`
--

INSERT INTO `servers` VALUES ('', 'Test', '', '8012', '500', '', '');
INSERT INTO `servers` VALUES ('', 'ja', '', '2465', '100', '', '');
INSERT INTO `servers` VALUES ('', 'Test', '', '9804', '20', '', '');
INSERT INTO `servers` VALUES ('', 'wackyhab', '', '8008', '500', '', '');
INSERT INTO `servers` VALUES ('', 'test', '', '8009', '500', '', '');
INSERT INTO `servers` VALUES ('', 'test2', '', '8891', '500', '', '');
INSERT INTO `servers` VALUES ('65932546', 'Harry - Demo', 'admin', '8890', '50', '20556\n', '');
INSERT INTO `servers` VALUES ('', 'Habblio.com', '', '8000', '5000', '', '');

-- --------------------------------------------------------

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
`id` varchar(8) NOT NULL default '',
`username` varchar(15) NOT NULL default '' COMMENT 'Client username',
`password` varchar(20) NOT NULL default '' COMMENT 'Client password, MD5 Hashed',
`rank` tinyint(3) NOT NULL default '0' COMMENT 'Users Rank, 1 = User 2 = Reseller 3 = Admin',
`billed` tinyint(1) NOT NULL default '0' COMMENT 'Is th user billed within Shell-Panel, 1 yes 0 No',
`email` varchar(255) NOT NULL default '0',
`mailing` varchar(255) NOT NULL default '',
`number` varchar(255) NOT NULL default '',
`paypal` varchar(255) NOT NULL default '',
UNIQUE KEY `username` (`username`),
UNIQUE KEY `paypal` (`paypal`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='User Base';

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES ('', 'admin', 'admin', 1, 0, '', 'Server Issues', '', '');

[Sam]

Go,

PHPMyadmin -> Sql -> Import Sql file or w/e -> Select it..

Voila o.o

Well thats what i do to speed up time.

[jarhead!]

well - i would like it to automaticly inset itself into phpmyadmin.