Errore

query SQL :

ALTER TABLE user ADD `welcometext` mediumtext NOT NULL ,
ADD `linkcount` smallint( 6 ) DEFAULT0 NOT NULL

Messaggio di MySQL:

You have an error in your SQL syntax near 'DEFAULT0 NOT NULL ' at line 1

same again there, put a space between the word defult and the number

CREATE TABLE `banneradmin` (
`event` smallint(5) unsigned NOT NULL auto_increment,
`storehack` SMALLINT(6) DEFAULT 0 NOT NULL,
`storecredit` smallint(5) DEFAULT 0 NOT NULL,
`serverpath` varchar(100) NOT NULL,
`guestsfromserver` smallint(5) DEFAULT 0 NOT NULL,
`guestsspecial` smallint(5) DEFAULT 0 NOT NULL,
`alttext` varchar(100) NOT NULL,
`linktext` varchar(100) NOT NULL NOT NULL,
`bannerimg` varchar(100) NOT NULL NOT NULL,
`welcometext` mediumtext NOT NULL NOT NULL,
`guestclicks` smallint(6) DEFAULT 0 NOT NULL,
`membersfromserver` smallint(5) DEFAULT 1 NOT NULL,
`membersspecial` smallint(5) DEFAULT 1 NOT NULL,
`memberalttext` varchar(100) NOT NULL,
`membersclicks` smallint(5) DEFAULT 0 NOT NULL,
PRIMARY KEY (`event`))

where ???

this works,

CREATE TABLE `banneradmin` (
`event` smallint(5) unsigned NOT NULL auto_increment,
`storehack` SMALLINT(6) DEFAULT 0 NOT NULL,
`storecredit` smallint(5) DEFAULT 0 NOT NULL,
`serverpath` varchar(100) NOT NULL,
`guestsfromserver` smallint(5) DEFAULT 0 NOT NULL,
`guestsspecial` smallint(5) DEFAULT 0 NOT NULL,
`alttext` varchar(100) NOT NULL,
`linktext` varchar(100) NOT NULL,
`bannerimg` varchar(100) NOT NULL,
`welcometext` mediumtext NOT NULL,
`guestclicks` smallint(6) DEFAULT 0 NOT NULL,
`membersfromserver` smallint(5) DEFAULT 1 NOT NULL,
`membersspecial` smallint(5) DEFAULT 1 NOT NULL,
`memberalttext` varchar(100) NOT NULL,
`membersclicks` smallint(5) DEFAULT 0 NOT NULL,
PRIMARY KEY (`event`))

whoever i might ask Lesane if he could do one of his doqury.php adding scripts for me....I am still learning, sorry

sorry but the second and the third query don't work :( i can't install your hack

hmm i re-tested all of them on my server with no faults, I have asked Lesane for assistance. please hang in there

no, don't work :(

Errore

query SQL :

CREATE TABLE `banneradmin` (

`event` smallint( 5 ) unsigned NOT NULL auto_increment,
`storehack` SMALLINT( 6 ) DEFAULT0 NOT NULL ,
`storecredit` smallint( 5 ) DEFAULT0 NOT NULL ,
`serverpath` varchar( 100 ) NOT NULL ,
`guestsfromserver` smallint( 5 ) DEFAULT0 NOT NULL ,
`guestsspecial` smallint( 5 ) DEFAULT0 NOT NULL ,
`alttext` varchar( 100 ) NOT NULL ,
`linktext` varchar( 100 ) NOT NULL ,
`bannerimg` varchar( 100 ) NOT NULL ,
`welcometext` mediumtext NOT NULL ,
`guestclicks` smallint( 6 ) DEFAULT0 NOT NULL ,
`membersfromserver` smallint( 5 ) DEFAULT1 NOT NULL ,
`membersspecial` smallint( 5 ) DEFAULT1 NOT NULL ,
`memberalttext` varchar( 100 ) NOT NULL ,
`membersclicks` smallint( 5 ) DEFAULT0 NOT NULL ,
PRIMARY KEY ( `event` )
)

Messaggio di MySQL:


You have an error in your SQL syntax near 'DEFAULT0 NOT NULL , `storecredit` smallint( 5 ) DEFAULT0 NOT NULL , `server' at line 1
Indietro

ok, database problem fixed....i have built and tested a php file to do the database changes for you. :)

Wow this is awesome :) Excellent hack pal

- miSt

Thanks miSt,

Have you or are you intending to install it? cos i would realy love to see it on another site.