Jump to content

baxr6

New Members
  • Posts

    7
  • Joined

  • Last visited

    Never

About baxr6

  • Birthday 05/28/1974

Profile Information

  • Gender
    Male

baxr6's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. yep all good, thanks m8
  2. might need to put it in code tags, i think its messed up
  3. specifically these (eregi("\([^>]*\"?[^)]*\)", $secvalue)) || (eregi("\"", $secvalue)) || (eregi("forum_admin", $sec_key)) || (eregi("inside_mod", $sec_key))) { and if it will function as before.
  4. Im converting my regex for php 5.3 and I am stuck on the following if((eregi("<[^>]script*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*object*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*iframe*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*applet*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*meta*\"?[^>]*>", $secvalue)) || (eregi("<[^>]style*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*form*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*img*\"?[^>]*>", $secvalue)) || (eregi("<[^>]*onmouseover*\"?[^>]*>", $secvalue)) || (eregi("<[^>]body*\"?[^>]*>", $secvalue) && !eregi("<[^>]tbody*\"?[^>]*>", $secvalue)) || (eregi("\([^>]*\"?[^)]*\)", $secvalue)) || (eregi("\"", $secvalue)) || (eregi("forum_admin", $sec_key)) || (eregi("inside_mod", $sec_key))) { block_ip($blocker_row); } anyone got any ideas on how to convert this to preg.so far I have this $html_regex = '{ ^( (?: <script\b[^>]*>.*?</script> # script block | <object\b[^>]*>.*?</object> # object block | <iframe\b[^>]*>.*?</iframe> # iframe block | <applet\b[^>]*>.*?</applet> # applet block | <meta\b[^>]*>.*?</meta> # meta block | <style\b[^>]*>.*?</style> # style block | <form\b[^>]*>.*?</form> # form block | <img\b[^>]*>.*?</img> # img block | <onmouseover\b[^>]*>.*?</onmouseover> # onmouseover block | <body\b[^>]*>.*?</body> # body block )*+ )$ }isx'; if (preg_match($html_regex, $html_string))
  5. What I want to do is record information on computers I build.For example I would like to have the customers details, Computer specs, benchmark results.I have been playing already and have decided I NEED HELP. :'( so far I have come up with the following.(please don't be shy to criticise) Database DROP TABLE IF EXISTS `benchmarks`; CREATE TABLE IF NOT EXISTS `benchmarks` ( `BenchmarkID` int(10) NOT NULL AUTO_INCREMENT, `UserBenchAudioTime` float DEFAULT NULL, `UserBenchAudioSpeed` float DEFAULT NULL, `UserBenchAudioScore` float DEFAULT NULL, `UserBenchVideoTime` float DEFAULT NULL, `UserBenchVideoSpeed` float DEFAULT NULL, `UserBenchVideoScore` float DEFAULT NULL, PRIMARY KEY (`BenchmarkID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `computer`; CREATE TABLE `computer` ( `ComputerID` int(10) NOT NULL AUTO_INCREMENT, `CustomerID` int(10) NOT NULL, `CPUID` int(10) NOT NULL, `MotherboardID` int(10) NOT NULL, `GraphicsID` int(10) NOT NULL, `BenchmarkID` int(10) NOT NULL, `DateBuilt` date DEFAULT NULL, `ModelNumber` varchar(15) DEFAULT NULL, `OS` varchar(10) DEFAULT NULL, `MemorySpeed` int(10) DEFAULT NULL, `MemoryAmount` int(10) DEFAULT NULL, `HardDriveType` varchar(10) DEFAULT NULL, `HardDriveSize` varchar(10) DEFAULT NULL, PRIMARY KEY (`ComputerID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `cpu`; CREATE TABLE `cpu` ( `CPUID` int(10) NOT NULL AUTO_INCREMENT, `NumOfCores` int(5) DEFAULT NULL, `sSpec` varchar(6) DEFAULT NULL, `CPUSpeed` varchar(50) DEFAULT NULL, `BusSpeed` int(5) DEFAULT NULL, `Technology` int(5) DEFAULT NULL, `L2CacheSize` int(10) DEFAULT NULL, `L3CacheSize` int(10) DEFAULT NULL, PRIMARY KEY (`CPUID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `customer`; CREATE TABLE IF NOT EXISTS `customer` ( `CustomerID` int(10) NOT NULL AUTO_INCREMENT, `FirstName` varchar(15) DEFAULT NULL, `LastName` varchar(15) DEFAULT NULL, `Address` varchar(50) DEFAULT NULL, `Phone` varchar(12) DEFAULT NULL, PRIMARY KEY (`CustomerID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `graphics`; CREATE TABLE `graphics` ( `GraphicsID` int(10) NOT NULL AUTO_INCREMENT, `Oem` varchar(15) DEFAULT NULL, `Manufacturer` varchar(25) DEFAULT NULL, `Model` varchar(25) DEFAULT NULL, `Gpu` varchar(15) DEFAULT NULL, `MemoryType` varchar(15) DEFAULT NULL, `MemorySize` int(5) DEFAULT NULL, `GpuClock` int(5) DEFAULT NULL, `MemClock` int(5) DEFAULT NULL, `BusWidth` int(5) DEFAULT NULL, `CrossfireSupport` varchar(5) DEFAULT NULL, `SliSupport` varchar(5) DEFAULT NULL, PRIMARY KEY (`GraphicsID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; DROP TABLE IF EXISTS `motherboard`; CREATE TABLE IF NOT EXISTS `motherboard` ( `MotherboardID` int(10) NOT NULL AUTO_INCREMENT, `Manufacturer` varchar(25) DEFAULT NULL, `Model` varchar(25) DEFAULT NULL, `Chipset` varchar(50) DEFAULT NULL, `PCIExpress16` int(2) DEFAULT NULL, `PCIExpress8` int(2) DEFAULT NULL, `PCIExpress4` int(2) DEFAULT NULL, `PCIExpress1` int(2) DEFAULT NULL, `PCI` int(2) DEFAULT NULL, `SATA` int(2) DEFAULT NULL, `IEEE1394` int(2) DEFAULT NULL, `USB` int(2) DEFAULT NULL, `Audio` varchar(25) DEFAULT NULL, `FormFactor` varchar(15) DEFAULT NULL, PRIMARY KEY (`MotherboardID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I had ideas of separating the information.....although while Im not to bad with php i always get stuck on bringing all the info together.For example i can bring together the customer table and computer table using left join but I'm lost after that.Am I heading in the right direction or should I redesign the database.
  6. Hi all, i have apache2triad version 1.5.4 installed and it works great...I decided then to upgrade phpmyadmin from the version 2.7pl2 it comes with to version 2.11.0.To do this i deleted all the files from the phpmyadmin folder and copied the new files across...i then updated the config file.(user and password). I works fine but it has at the bottom the following error message. also what charset should i be creating database in....as a lot of the databases i have with online providers seem to be latin1 and im using utf....this seems to be causing some issues when i try to restore.... and my final question is about php and mysql itself....we have a dedicated server that displays screen shots for an online game....it seems to be laging the server when we have the web server running....are there any good guides and/or tutorials out there on optimizing your web server for this type of application... Thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.