[r4] Country Flags In Postbit

[sushruth]

man.. this is bad.. its like.. having a 16 core processor in your hand but not giving it to me..

i need to subscribe to download!!??

[ByteHunter]

As you have read in the PM yes !

[spinning]

I use this plugin for allready a long time, but after the update from 1.2 to 1.4 I go a big problem. All datas are save in another field as when I used it on 1.2.
So all people who add now a flag will not be vissible on the index or postbit. I could change the fid but then only the new flags are vissible but then the old are not.

I allready search for a long time for a sollution then I saw flags in postbit as unique ip address. I became a subscribler on that forum and download that plugin. In the begin that plugin had problem the owner will repair that and also promissed to create for me (after subscribling) a flag on index plugin.

Now 4 weeks later:
- no support
- no answers
- no new plugins
- the testpage is death (page not found)
- admin not online

I do not call names here but I wanne warn other users for that page.
I also saw that all plugins that he designed are not new, they are optimalisised or what else.

back to question

One of my tables in my database is called mybb_userfields.
This tables are build like: ufid fid1 fid2 fid3 fid4 fid11 fid12.



I want to move the datas from fid4 to fid12 .
It is possible that by some ufid there allready is a date in fid12 iets staat. THIS MAY NOT BE REWRITTEN.
Is there NULL or they are empty dan they had to be rewritten.

Hoe kan ik dit het snelste doenHow could I do this

[LeX-]

update mybb_userfields set fid12 = fid4 will overwrite the values of fid12 if i'm not mistaken;

Gonna test some things; will come back on this !

Edit:

update mybb_userfields set fid12=fid4 WHERE (fid12 = "" OR fid12 = NULL)

[spinning]

What do I had to do with that code? Run in phpmyadmin or something????

[Chainzs]

in the country flags pictures dir, "Vietnam" was showing like this
and i have a member from there, it was bothering me so i made this one
feel free to use it if you want. :o)

[LeX-]

(May 02, 2009 10:18 AM)spinning Wrote:  What do I had to do with that code? Run in phpmyadmin or something????

Yeah run it in phpMyAdmin; though that was obvious =/

(May 02, 2009 10:58 AM)Chainzs Wrote:  in the country flags pictures dir, "Vietnam" was showing like this
and i have a member from there, it was bothering me so i made this one
feel free to use it if you want. :o)

Never noticed that before
Thx for making it; gonna add it

[spinning]

Sorry the run on phpmyadmin did not work!
I tried it on 2 differents way.
1. from indexpage --> TAB SQL --> add code --> start
2. indexpage --> table mybb_userfields --> TAB SQL --> add code --> start

with the last method I get the message
0 rij(en) bijgewerkt. ( Query duurde 0.0049 sec )
UPDATE mybb_userfields SET fid12 = fid4 WHERE (
fid12 = "" OR fid12 = NULL
)

[LeX-]

Try this

Code:

UPDATE mybb_userfields SET fid12 = fid4 WHERE (fid12 = "" OR fid12 IS NULL)

[spinning]

(May 02, 2009 02:42 PM)LeX- Wrote:  Try this

Code:

UPDATE mybb_userfields SET fid12 = fid4 WHERE (fid12 = "" OR fid12 IS NULL)

Thank you it seems that that works.
Know I can run everything on fid12 (I changed it, it was 4 (the most members became before the issue)).