[LuBi]

Originally posted by humble
Nevermind!!!!

I find the work around!!!! For those who are interested....

In the Hack instructions.... check out the first TWO db queries to run....

See how it wants to create the new entries in settings line 171, and 172 respectively ...

INSERT INTO setting VALUES ( '171'  .......

&

INSERT INTO setting VALUES ( '172' ........

Well... I looked in my DB.. and sure enough.... a few hacks I've added took 171, 172, 173, 174, 175....

So... what to do???

SIMPLE!!!
Open up PhpAdmin... navigate to your db...

on the left navigation side.... find the Browse icon next to 'setting'

it'll display something like

Showing records 0 - 30 (175 total)
Show XX number of records, and start @ XX

Tell it to show you 30 records starting from 160....

Now look in the settingid column, for the LAST record you have.... it maybe be 170, give or take a few....

NOW....

Just modify the code instructions for the 1st two queries ... and change the code to add these new values on the NEXT available line.. i.e. if your settings ends @ 174... then change the code like so:

INSERT INTO setting VALUES ( '175'  .......

&

INSERT INTO setting VALUES ( '176' ........

I have tested it.... The actual value ID of the setting we add here is NOT specific, and EVERYTHING else stays the 100% the same... works great!!!

So here's that more THANKS!!!! for a great piece of code well done!

[quick questions]

a: can these code hack instructions be modified to add those values in the next available line entry?

b: or can someone come up with that simple query to check how many values are currently in the setting table, so we can identify that before we try to create new tables on top of existing ones.

c: just curious if gaps in the values matter, so if someone doesn't want to look how many that have, can they use...

INSERT INTO setting VALUES ( '998'  .......

&

INSERT INTO setting VALUES ( '999' ........

or would it create all the ones in between and be an ugly thing?


[quick recommendations]

It would be nice to have the ability to edit an existing post, and give it one of the custom prefix's..

Can we see a SS humble or maybe al ink to your site I'd love to see this hack working. Also which verison did you install 1.0.0 or 0.9.9?