No..Quote:
this is not the best way to do it,
you can just add one more column in entities table called VIPEndTime and do a small check in player login if the VIPEndTime grater than the actual time add the viplevel else reset the VIPLevel column to zero.
To clear VIP field, perhaps once a dayQuote:
SELECT type, end FROM VIP WHERE user={The_Entity_UID}
To extend VIP timeQuote:
DELETE FROM VIP WHERE end > CURDATE()
Quote:
UPDATE VIP SET end = DATE_ADD(`end` , INTERVAL 30 DAY) WHERE user={The_Entity_UID}
why to add where there r codes could do the jobQuote:
you can just add one more column in entities table called VIPEndTime and do a small check in player login if the VIPEndTime grater than the actual time add the viplevel else reset the VIPLevel column to zero.
if (DateTime.Now > client.VIPInformation.SuscribtionDate.AddDays(client.VIPInformation.Days))
{
client.Send(new Conquer_Online_Server.Network.GamePackets.Message("Your VIP Suscribtion Has Expired", System.Drawing.Color.Red, Message.TopLeft));
// client.SendMessage("Your VIP Suscribtion Has Expired", Message.TopLeft);
Database.VipTable.Delete(client.Entity.Name);
}
MySQL is a very useful language to know in game programming and the software industry. If you're thinking about programming as a living (web, client, or server programming), you're on the right track. You should work on some programming language to go with it though. Maybe next you could work on improving your PHP or another high level programming language. If you go with C#, you could get some advice from the community (if they brighten up a bit).Quote:
That is why you always team up with someone who does to front-end, and you focus on backend :DQuote:
Note : i studied PHP long while ago but havent liked it ... and what i studied was too basic beside that Creating Web Requires More than 1 Language PHP , CSS , HTML5 , Java Scripts , JQuery or w.e which is too much to learn .
Once you have learned your goals it will be years and years, but I admire your courage, it pays off.Quote:
- Become Professional in C# (im good at C# basics , Studied Sockets for while but havent gone Deep) ..
- Becoming Very Good in using MYSQL , NHiberate Databases (maybe subsonic but i didnt and i wont ever like it)
- Become Very Good At Reverse Engineering (Ollydb as Example)
Once i do those ..ill be Happiest Person in The world
Note : i studied PHP long while ago but havent liked it ... and what i studied was too basic beside that Creating Web Requires More than 1 Language PHP , CSS , HTML5 , Java Scripts , JQuery or w.e which is too much to learn .
Not necessary. You can do it alone. I've done sites alone many times, it takes 1-3 weeks depending on the type of site. This is for less complex sites tho such as webshops, business websites etc.Quote:
I've never, ever, met a real good programmer or developer in general that has produced something good when it comes to both design and functionality. There are designers who know how to code, sure, but the end result is not near as good as a real back-end programmer, same goes for the opposite.Quote:
LOL No. I've never used wordpress. I don't even use such thing, nor do I use PHP anyways. I'm using Ruby on rails, Python + Django and ASP.NET for web only, but anyways this is off topic talk. Stop assuming so much tho, just because you're not capable of doing both. You come off kinda like an ass with an attitude "I'm the best and only webdeveloperin this community."Quote:
When talking front-end, I generally mean everything the user will see, which include design, properly strucured html and valid CSS, responsive and of course SEO-friendly.
And I sure as hell hope you don't mean like setting up a WordPress theme with some lame web shop plugin or w/e it's called. I'm talking proper projects, not 1-3 weeks lol. :facepalm: